PLEASE EXPLAIN FORMULA TO SOLVE DECISION VARIABLE PLEASE!!

An air conditioning company manufactures three home air conditioners: a regular model, a

super model, and a deluxe model. The profits per unit are $$80,$$$105,$ and $$160,$ respectively. The

production requirements per unit and the availability of the three resources are given below:

How many regular models, super models, and deluxe models should the company manufacture in

order to maximize profit?

a$.$ Formulate a linear optimization model for this problem.

b$.$ Solve this model by using the Excel Solver. Include Excel output with you answer.

c$.$ Determine the optimal solution. Interpret and make recommendations based on the optimal

solution.