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. Wi- P. Formula Data Review View Help Fle Home Insert Dan Page Layout Share Coment AA 1) Nu Acom 29 PO som O Forum Fouble Sy 027 C D M N 0 P 0 v w G H Profit Maximilation Strategy OP Solver Pes 3.0 pary Forecasted Bayan Demand per oth per Moth re 2700 3000 0000 6500 000 200 2000 tar 10 AT 11 Way 12 13 TON 21 20 23 21 22 PU W! Ending + Producers Lyon Worry Halong Backorder 30124 3 . 34 319 4 0 544 3600 0 1952 35518 o 0 0 9532 35112 0 643 43 S8 O 2012 . 0 0 110 1992 78 Cost 20 Production Cost 9000200 1000 71 Cow 10000 360000 22 Laut Chi 6.000.00 . 3000 3 INC 500110 A50800 pooh 15.00 COX 00 COM dy 97 Folyo 1.00 $312700 Tout com $342.704 00 Total Cost 2010,120,00 31 Constant Word Pro Max AutoSave of Search (Alt+ Weeks AggregatePlan_Example Formulas Data Review View Help File Home Insert Draw Page Layout IG Arial v 10 - A A Number Paste Wrap Text Merge & Center BIU a $%$8-98 Conditional Format as Cell Formatting Table Styles Styles Font Alignment 5 Number Clipboard 27 =898 f B Given Parameters D H K L M N E Profit Maximization Strategy Solver Variables LP Variables K= 3.8 gears/day Forecasted Days Units/Wkr Demand per Month per Month Pt Production Jan Feb Mar Apr May Jun 3 Total 1 5 2700 3000 4000 4500 3200 2900 20300 21 20 23 21 22 22 79.8 76 874 79.8 836 836 3032.4 3192 3670.8 3351.6 35112 35948 20352.8 Ht L_t Wt Ending 1+ 1- Hires Lay Offs Workers Inventory Holding Backorder 35 3 0 38 332.4 0 4 42 5244 0 0 42 1952 0 0 42 0 953.2 0 42 0 642 1 43 52.8 0 8 0 11048 1595 2 OOOOOO Cost of Strategy Profit Maximization Strategy Costs Units Production Costs 30.00 20352.8 Hiring Costs 4,500.00 8 2.Layoff Costs 6,000.00 0 3 Inv Holding Costs 5.00 1104.8 Backorder Costs 15.00 1595.2 5 unit cost subtotal 3 Cost (per day (Shr) days hourly worker costs 64.00 5356 3 hourly cost subtotal 3 Total Cost Subtotal $610,584.00 $36,000.00 $0.00 $5,524.00 $23,928.00 $676,036.00 $342,784.00 $342,784.00 $1,018,820.00 Chase Constant Workforce Backorders Constant Workforce NO backorder Profit Max (2) ady 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. Wi- P. Formula Data Review View Help Fle Home Insert Dan Page Layout Share Coment AA 1) Nu Acom 29 PO som O Forum Fouble Sy 027 C D M N 0 P 0 v w G H Profit Maximilation Strategy OP Solver Pes 3.0 pary Forecasted Bayan Demand per oth per Moth re 2700 3000 0000 6500 000 200 2000 tar 10 AT 11 Way 12 13 TON 21 20 23 21 22 PU W! Ending + Producers Lyon Worry Halong Backorder 30124 3 . 34 319 4 0 544 3600 0 1952 35518 o 0 0 9532 35112 0 643 43 S8 O 2012 . 0 0 110 1992 78 Cost 20 Production Cost 9000200 1000 71 Cow 10000 360000 22 Laut Chi 6.000.00 . 3000 3 INC 500110 A50800 pooh 15.00 COX 00 COM dy 97 Folyo 1.00 $312700 Tout com $342.704 00 Total Cost 2010,120,00 31 Constant Word Pro Max AutoSave of Search (Alt+ Weeks AggregatePlan_Example Formulas Data Review View Help File Home Insert Draw Page Layout IG Arial v 10 - A A Number Paste Wrap Text Merge & Center BIU a $%$8-98 Conditional Format as Cell Formatting Table Styles Styles Font Alignment 5 Number Clipboard 27 =898 f B Given Parameters D H K L M N E Profit Maximization Strategy Solver Variables LP Variables K= 3.8 gears/day Forecasted Days Units/Wkr Demand per Month per Month Pt Production Jan Feb Mar Apr May Jun 3 Total 1 5 2700 3000 4000 4500 3200 2900 20300 21 20 23 21 22 22 79.8 76 874 79.8 836 836 3032.4 3192 3670.8 3351.6 35112 35948 20352.8 Ht L_t Wt Ending 1+ 1- Hires Lay Offs Workers Inventory Holding Backorder 35 3 0 38 332.4 0 4 42 5244 0 0 42 1952 0 0 42 0 953.2 0 42 0 642 1 43 52.8 0 8 0 11048 1595 2 OOOOOO Cost of Strategy Profit Maximization Strategy Costs Units Production Costs 30.00 20352.8 Hiring Costs 4,500.00 8 2.Layoff Costs 6,000.00 0 3 Inv Holding Costs 5.00 1104.8 Backorder Costs 15.00 1595.2 5 unit cost subtotal 3 Cost (per day (Shr) days hourly worker costs 64.00 5356 3 hourly cost subtotal 3 Total Cost Subtotal $610,584.00 $36,000.00 $0.00 $5,524.00 $23,928.00 $676,036.00 $342,784.00 $342,784.00 $1,018,820.00 Chase Constant Workforce Backorders Constant Workforce NO backorder Profit Max (2) ady
