Question

The Attaran Corporation manufactures two electrical​ products: portable air conditioners and portable heaters. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each heater must go through 2 hours of wiring and 1 hour of drilling. During the next production​ period, 240 hours of wiring time are available and up to 130 hours of drilling time may be used. Each air conditioner sold yields a profit of ​$20. Each heater assembled may be sold for a ​$16 profit.

Number of air conditioners to be produced​ =_____ ​(round your response to two decimal​ places).
Number of heaters to be produced​ = _______​(round your response to two decimal​ places).
Optimal solution value​ = _______​(round your response to two decimal​ places).

Answer 1

Number of air conditioners to be produced​ = 0
Number of heaters to be produced​ = 120
Optimal solution value​ = $1920

The problem is formulated in excel as below. The below 2 images show the formulation as well as the formulas used. The objective function to maximize is highlighted in green and the decision variables are highlighted in yellow.

Post these the solver parameters need to be entered as per the below image.

Once this is done, click on solve. The solver will solve the problem and show the message stating the same. Click on ok. The excel will now have the final solution as per below image.

Hence we can see that final solution is as below

Air conditioners : 0

Heaters : 120

Profit : 1920