Electrocomps management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that to ensure an adequate supply of air conditioners for a contract, at least 20 air conditioners should be manufactured. Because Electrocomp incurred an oversupply of fans in the preceding period, management also insists that no more than 80 fans be produced during this production period. Resolve this product mix problem to find the new optimal solution.

File Home Insert Page Layout Formulas Data Review View Help Tell me what you wan UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now F16 1 Problem 7-15 Input the numbers in the beige cells Write formulas to compute values (e.g. profit, resoure utilization) in blue cells 5 Solution t Total AC FAN?T RHS 7 Maximize 8 WIRING TIME 9 DRILLING TIME 0 AC Demand 11 Fan Demand 12 17 18 19 20