Please include Excel 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 2 3 4 5 6 Demand 3000 3200 1800 2700 3400 2200 Regular 2500 2700 1000 2000 2600 1700 Production Capacity Overtime Subcontracting 500 600 500 600 300 600 500 600 500 600 500 600 Total 16300 Christian Medaas has 600 Printers in Stock at the beginning of the planning period. Develop a least-cost production plan. No backorders are permitted