le Home Insert Page Layout Formulas Data X lo Calibri 12 - A A A- General Review View Help Wrap Text Merge & Center ate BLU- 10 lile TODO = = $ -% -8 Conditional Format as Formatting Table Styl Styles pboard Font Alignment Number B D K M3 A firm produces three different models of a product: model 1 (M1), model 2 (M2), and model 3 (M3). The profit per unit are $63, $95, and $135 respectively. The production requirements are given in the table on the right. Also, 200 units of Part 1, 320 units of part 2, and 2400 hours of manufacturing time are available. M1 1 M2 1 2 - 1 1 4 Part 1 Part 2 Manufacturing time (hours) 00 12 14 a. Assume that the firm want to determine the profit maximizing output mix. Derive the linear programming model, 3 pts. b. Implement and solve the LP model in Excel. State your solution. 4 pts. c. Which constraints are binding? 1 pt. d. Create the Sensitivity Report. Based on the Report derive the range of optimality for each objective function coefficient. Select one interval and explain what it means. 2