1. When backorder is not allowed, add an appropriate constraint in the spreadsheet and find the optimal solution. Please include a snapshot of the constraint you add, list the optimal solution including the decision variables and corresponding minimized total cost.

2. Assuming that backorder is not allowed, add an appropriate constraint that forces the factory to maintain a minimum buffer inventory of 100 gears each month. Please include a snapshot of the constraint you add, list the optimal solution including the decision variables and corresponding minimized total cost.

3. Assuming that backorder is not allowed, add an appropriate constraint that forces the factory to maintain a minimum buffer inventory of 100 gears each month. If you are using level strategy, what needs to be changed in the given spreadsheet? Please attach a snapshot of the new spreadsheet with the changed number(s) bolded.

Linear program (Profit Max) Given Parameters Profit Maximization Strategy Solver Variables LP Variables K= gears/day Ending Inventory 3.8 Forecaste d Days Units/W kr per Month Pt Ht Productio Hire n S Lt Lay Offs Wt I+ Worker Holdin S g I- Backord er Demand per Month 0 0 0 0 Jan 2700 Feb 3000 Mar 4000 Apr 4500 May 3200 Jun 2900 Total 20300 Cost of Strategy 21 20 23 21 22 22 79.8 76 87.4 79.8 83.6 83.6 3032.4 3192 3670.8 3351.6 3511.2 3594.8 20352.8 3 4 0 0 0 0 0 0 35 38 42 42 42 42 43 332.4 524.4 195.2 0 0 52.8 1104.8 0 953.2 642 0 1595.2 0 1 8 0 Profit Maximization Strategy Costs 30.00 Units 20352.8 Subtotal $610,584.00 4,500.00 8 $36,000.00 Production Costs Hiring Costs Layoff Costs Inv Holding Costs Backorder Costs 6,000.00 5.00 15.00 0 1104.8 1595.2 $0.00 $5,524.00 $23,928.00 unit cost subtotal $676,036.00 Cost (per day (8hr) 64.00 days 5356 hourly worker costs $342,784.00 hourly cost subtotal $342,784.00 $1,018,820. 00 Total Cost Linear program (Profit Max) Given Parameters Profit Maximization Strategy Solver Variables LP Variables K= gears/day Ending Inventory 3.8 Forecaste d Days Units/W kr per Month Pt Ht Productio Hire n S Lt Lay Offs Wt I+ Worker Holdin S g I- Backord er Demand per Month 0 0 0 0 Jan 2700 Feb 3000 Mar 4000 Apr 4500 May 3200 Jun 2900 Total 20300 Cost of Strategy 21 20 23 21 22 22 79.8 76 87.4 79.8 83.6 83.6 3032.4 3192 3670.8 3351.6 3511.2 3594.8 20352.8 3 4 0 0 0 0 0 0 35 38 42 42 42 42 43 332.4 524.4 195.2 0 0 52.8 1104.8 0 953.2 642 0 1595.2 0 1 8 0 Profit Maximization Strategy Costs 30.00 Units 20352.8 Subtotal $610,584.00 4,500.00 8 $36,000.00 Production Costs Hiring Costs Layoff Costs Inv Holding Costs Backorder Costs 6,000.00 5.00 15.00 0 1104.8 1595.2 $0.00 $5,524.00 $23,928.00 unit cost subtotal $676,036.00 Cost (per day (8hr) 64.00 days 5356 hourly worker costs $342,784.00 hourly cost subtotal $342,784.00 $1,018,820. 00 Total Cost