please answer a,b,c,d

PLEASE USE EXCEL

Show all work, keep organized

A small firm makes three products, which all follow the same three-step process consisting of milling, inspection, and drilling. Product A requires 3 minutes of milling, 6 minutes of inspection, and 4 minutes of drilling; Product B requires 7 minutes of milling, 4 minutes of inspection, and 5 minutes of drilling; and Product C requires 5 minutes of milling, 4 minutes of inspection, and 8 minutes of drilling. The department has 250 hours available during the next period for milling, 180 hours for inspection, and 240 hours for drilling. The milling process costs $60 per hour, the inspection costs $30 per hour and finally drilling costs $90 per hour. The costs are the same for all product types. Product A is sold for $34.00 per unit, product B is sold for $28.00 per unit, and product C is sold for $35.00 per unit. There is an outstanding order of 800 Product A that the company has to satisfy. You are trying to determine the best production mix that maximizes your profit. a) Formulate the problem as a linear programming model and solve it in Excel. Briefly describe your solution. b) Is it feasible to produce 1200 units of Product A, 500 units of Product B, and 600 units of Product C ? Create a sensitivity report and answer the following questions based on the sensitivity report. c) What would happen to the optimal values of A,B, and C if the profit per unit of Product A is decreased by $5.00 ? d) If the available amount of inspection hours is decreased by 1500 minutes, what would happen to the optimal value of the objective function