Question 14 0 / 1 pts To simulate the inventory management of a particular product, the demand is assumed to be between 10 and 50 units with probabilities as shown in cells B4 through B8 below. The policy is to order 40 units when the inventory level drops below the reorder point of 15 units at the start of a period. Suppose that inventory orders arrive immediately, and that negative inventory levels are allowed. This simulation takes place over 40 weeks. B D E G H K Probability Total Inv Cost $3,200 0.20 0.25 0.30 0.15 0.10 FIX) 0.20 0.45 0.75 0.90 F'() 0 0 0.20 0.45 0.75 0.90 Demand 10 20 30 40 50 units 1 Inventory Simulation 2 3 3 Demand 4 10 5 20 6 30 7 40 8 50 9 9 units 10 11 Order Quantity 12 Reorder Point 13 14 Period 15 1 16 2 17 3 18 4 4 19 5 Data Table for Cost Total Cost Sim 1 2 2 3 3 4 5 6 7 8 1.00 40 units 15 units Holding Cost Shortage Cost SS per week $10 per week Ending Inv 0 0 Starting in 30 0 0 0 10 40 Demand 30 40 30 10 30 SA Order Qty 0 0 40 40 40 0 AN 9 10 11 12 13 14 15 Inw Cost $o $o SSO $200 $50 CA 10 40 10 SA There is a holding cost of $5 per unit-week and a shortage cost of $10 per unit-week. These costs are computed based on the ending inventory. The total inventory cost has been computed for the forty-week simulation. What is the next step to set up a data table (in cells 14 to J104) representing the total costs for 100 repetitions of this forty-week simulation? Go to Data/What If Analysis in the Excel menu Enter"=G4" in cell 34 Enter"=$G$4" in cells J5 through J104 Enter "=ABS(E15)*$F$11" in cells 5 through J104 Exactly two of the answers are correct. None of the answers are correct