Done in the Excel sheet attached below, instruction #2.

You have been provided 9 years of sales and cost data for 3 products (the first four years of which are historical and the last 5 are forecasts). You have been hired as a Business Analyst consultant to analyze the current data and to recommend how many of each product to make in a specific year and how many laborers and machines are needed. 1. I have created a new tab after LP3 tab to use for your final report. (See last section of this tab) 2. Create a new tab for DEMANDS FOR PRODUCT tab labeled ACTUAL DEMANDS FOR PRODUCT. On this tab, note that some of the data are interval estimates, so you need to clearly state how you handle these variances in the estimates and build a new matrix with single numbers instead of intervals. Use either average or optimistic criterion (not pessimistic lower bound). 3. Compute Demand for Drones, INC product rows for each product using the first two rows of data for each product, replacing the words PROVIDED BY ANALYST TEAM with your computation. These values will later be used as the upper bound of the number of each product produced in the CONSTRAINTS OF THE LINEAR PROGRAM. After completing your analysis through 2020, you can use linear regression for extra credit points to complete the table in "ACTUAL DEMANDS FOR PRODUCTS" for the years 2021 through 2025. 4. Determine Product mix (number of each product) to produce each year. Here you will need to formulate and solve a Linear Programming formulation using the variable costs/unit of each product and the forecasted demand. Note that your production each year should not exceed the forecasted demand from Drones, INC for each product. As a minimum requirement, you must do the LP for Year 2016. If you do 2017 through 2020, you can receive extra credit points.