A B 1 Input Parameters 2 3 Demand 4 Production Capacity 5 Unit Production Cost 1 4000 5200 $49 D E Months 2 3 5000 6000 4100 6500 $45 $46 4 5500 5600 $47 6 2200 5000 33% 7 Starting Inventory 8 Maximum Stock Amount 9 Safety Inventory Level 10 Unit Carrying Cost 11 Inventory Spoilage Rate 12 13 Decision Variables $1.5 2% 14 2 3 15 Production Amt Beginning Inventory Amount Produced Demand Ending Inventory 16 17 Calculations 18 19 20 21 22 23 Objective 24 25 26 27 28 Subject to Total Production Cost Inventory Holding Cost Total Cost 20 Maximum Production Can 33 Safety Stock Consider Beyond Sports problem statement and figure above. Construct the formula that models the beginning inventory of period 2? (Cell D18) Select) # Select) Select) period 2? (Cell D18) [ Select] [ Select ] (1-C10) C11 (1-C11) C10 C9 C7 0 (1-C9) 1 S.com Maximum Stock Amount Safety Stock roblem statement and figure above. Construc [ Select ] 1 [ Sele + [Select ] C18 C19 C21 C15 C20 A B 1 Input Parameters 2 3 Demand 4 Production Capacity 5 Unit Production Cost 1 4000 5200 $49 D E Months 2 3 5000 6000 4100 6500 $45 $46 4 5500 5600 $47 6 2200 5000 33% 7 Starting Inventory 8 Maximum Stock Amount 9 Safety Inventory Level 10 Unit Carrying Cost 11 Inventory Spoilage Rate 12 13 Decision Variables $1.5 2% 14 2 3 15 Production Amt Beginning Inventory Amount Produced Demand Ending Inventory 16 17 Calculations 18 19 20 21 22 23 Objective 24 25 26 27 28 Subject to Total Production Cost Inventory Holding Cost Total Cost 20 Maximum Production Can 33 Safety Stock Consider Beyond Sports problem statement and figure above. Construct the formula that models the beginning inventory of period 2? (Cell D18) Select) # Select) Select) period 2? (Cell D18) [ Select] [ Select ] (1-C10) C11 (1-C11) C10 C9 C7 0 (1-C9) 1 S.com Maximum Stock Amount Safety Stock roblem statement and figure above. Construc [ Select ] 1 [ Sele + [Select ] C18 C19 C21 C15 C20