(Answered) : Please Show Solve Excel Please Show Formuals Used Showhow Solve Excel Solver Sudden Increa Q34297834

PLEASE SHOW HOW TO SOLVE IN EXCEL. PLEASE SHOW FORMUALS USED.AND SHOWHOW TO SOLVE IN EXCEL SOLVER.

A sudden increase in the demand for smoke detectors has leftAcme Alarms with insufficient capacity to meet demand. The companyhas seen monthly demand for its electronic and battery-operateddetectors rise to 20,000 and 10,000, respectively; and Acme wishesto continue meeting demand. Acme’s production process involvesthree departments: fabrication, assembly, and shipping. Therelevant quantitative data on production and prices are summarizedbelow. Monthly Hours Hours/Unit Hours/Unit Department Available(Electronic) (Battery) Fabrication 2000 0.15 0.10 Assembly 42000.20 0.20 Shipping 2500 0.10 0.15 Variable cost/unit $18.80 $16.60Retail price $29.50 $28.00 The