PLEASE SOLVE IN EXCEL AND SHOW FORMULAS, DO NOT USE SOLVER.

Problem 18: Medaas Electronics is a fictional producer of laser printers. The company's production planner. Christian Medaas, has developed the following cost data (in U.S. dollars) Costs Regular Overtime Subcontracting Inventory Carrying Cost: 80 Per printer 120 Per printer 140 Per printer 10 per printer per month Months 1 2500 2 3 Demand 3000 3200 1800 2700 3400 2200 Production Capacity Regular Overtime Subcontracting 500 600 2700 500 600 1000 300 600 2000 500 600 2600 500 600 1700 500 600 4 5 6 Total 16300