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. 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 Orl Search (Alt03 Week6 AggregatePian_Example Formulas Data Review View Help File Home Insert Draw Page Layout X Arial 10 - A Number Wrap Text 3 Merge & Center Paste BIU $%$8-98 Conditional Format as Cell Formatting Table Styles Styles Font Alignment Number Clipboard 27 =898 for B Given Parameters c 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 OOC 2700 3000 4000 4500 3200 2900 20300 21 20 23 21 22 22 79.8 76 87.4 79.8 836 836 Ht L_t Wt Ending 1+ 1- Hires Lay Offs Workers Inventory Holding Backorder 35 3 0 38 332.4 4 42 524.4 0 42 1952 0 42 0 953.2 0 42 0 642 1 43 528 0 8 0 11048 1595 2 3032.4 3192 3670.8 3351.6 35112 35948 20352.8 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 In 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 Subtotal $610,584.00 $36,000.00 $0.00 $5,524.00 $23,928,00 $676,036.00 $342,784.00 $342,784.00 Total Cost $1,018,820.00 Chase Constant Workforce Backorders Constant Workforce NO backorder Profit Max (2) eady