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
PayPal Gateway not configured
PayPal Gateway not configured