Hi, could you please explain how to do this preferably on excel. Thank you so much I really appreciate it!!!

Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $63, $97, and $133, respectively. The production requirements per unit are as follows: Number of Fans Number of Cooling Coils Manufacturing Time (hours) Economy Standard Deluxe For the coming production period, the company has 350 fan motors, 340 cooling coils, and 2000 hours of manufacturing time available. How many economy models (E), standard models (S), and deluxe models (D) should the company produce in order to maximize profit? The linear programming model for the problem is as follows: Max 63E + 975 + 133D s.t. 1E + 15 + 1Ds 350 Fan motors 1E + 25 + 4D 340 Cooling coils 8E + 125 + 14D S 2000 Manufacturing time E,S,D20 The sensitivity report is shown in the figure below. Optimal Objective Value = 16660.00000 Variable Value 180.00000 0.00000 40.00000 Reduced Cost 0.00000 2.55556 0.00000 Constraint Fan motors Cooling coils Manufacturing time Slack/Surplus 130.00000 0.00000 0.00000 Dual Value 0.00000 10.11111 6.61111 Variable Objective Coefficient 63.00000 97.00000 133.00000 Allowable Increase 13.00000 2.55556 119.00000 Allowable Decrease 2.30000 Infinite 11.50000 Constraint Fan motors Cooling coils Manufacturing time RHS Value 350.00000 340.00000 2000.00000 Allowable Increase Infinite 231.42860 720.00000 Allowable Decrease 130.00000 90.00000 810.00000 a. Identify the range of optimality for each objective function coefficient. If there is no limit, then enter the text "NA" as your answer. If required, round your answers to one decimal place. Objective Coefficient Range Variable lower limit upper limit b. Suppose the profit for the economy model (E) is increased by $6 per unit, the profit for the standard model (S) is decreased by $2 per unit, and the profit for the deluxe model (D) is increased by $4 per unit. What will the new optimal solution be? If required, round your answers to three decimal places. If your answer is zero, enter "0". Optimal Solution E 180 s 0 D 40 If required, round your answer for Total Profit to two decimal places. Total Profit: $ C. Identify the range of feasibility for the right-hand-side values. If there is no limit, then enter the text "NA" as your answer. If required, round your answers to one decimal place. Right-Hand-Side-Range lower limit upper limit Constraints Fan motors Cooling coils Manufacturing time d. If the number of manufacturing time available for production is increased by 740, will the dual value for that constraint change? because the allowable increase for manufacturing time is without changing the optimal solution