Is my Excel solution for A is correct?

1. Exercise One: Ferrari Motors produces three lines of luxury vehicles, Model A, Model B, and Model C. The profits for each model are, $1,350,000, $1,465,000 and $2,925,000, respectively. The company expects the daily demand for each model to be at least 250, 125 and 86 units, respectively. Due to limitations in their manufacturing facility, the company cannot exceed 640 units for Model A, 450 units for Model B, and 198 units for model X. Due to global demand, the company has a contractual obligation to send at least 225 units every day to emerging market customers. In addition, the marketing department has requested to avoid brand dilution by limiting total output to 675 units per day. Given your knowledge of Linear Programming, (a) how many units of each model should Tesla Motors produce to maximize daily profits? (b) Create a Sensitivity Report and state, both the Reduced Cost, and the Shadow Price, (c) interpret the significance of both, Reduced Cost and the Shadow Price, (d) suppose an emerging markets customer wants to order 1630 units of Model A, is this feasible and why? (6 Points). Problem 1 Obj. Function max (235000 M +485000 S + 790000 X) Model A 1625 235000 Model B 940 (a) Model C 425 790000 485000 1,173,525,000.00 SUMPRODUCT(SCS6 SES6,C7:57) 1 Model Units Profit Constraints Demand A Demand B Demand C Production A Production B Production C Contractual Marketing 1.625.00 940.00 425.00 1.625.00 940.00 425.00 2,990.00 2.990.00 850 325 276 1625 940 425 750 2350 RHS LHS