Question 16 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. G H H 1 K L M N o o P Q Q R Total Inv Cost $4,300 Run Statistics for Total Inv Cost Low $2,700 Average $3,762 High $7,400 Std Dev $673 $5 per week $10 per week Data Table for Cost Total Cost Sim $4,300 1 $4,700 2 $3,800 3 $3,050 4 $2,800 5 $3,250 6 $3,950 7 $4,000 8 $4,100 9 $3,000 10 $3,400 11 $3,750 12 $4,100 13 $4,400 14 $7,400 15 $3,150 16 $3,350 Frequency Table Bin Count $2,000 $2,250 $2,500 $2,750 $3,000 $3,250 $3,500 $3,750 $4,000 $4,250 $4,500 $4,750 $5,000 $5,250 $5,500 $5,750 Cost SO $ $0 $100 $200 $200 $100 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 statistics have been computed for 100 runs of this forty-week simulation in cells J5:J104. Now it is time to set up a histogram to see a distribution of the data. To do this in cells P5 through Q21, one would: Click on Q4 and enter =FREQUENCY() with the proper arguments. Click on Q4 and enter =COUNTIF() with the proper arguments. Highlight Q4 through Q21 and enter =FREQUENCY() with the proper arguments. Highlight Q4 through Q21 and go to Data What If Analysis Data Table. Exactly two of the answers are correct