Simulation Hill Plumbing and Heating maintains a supply of eight water heaters in any given week. James Hill, the owner, likes the idea of having this large supply on hand to meet customer demand but also recognizes that a large inventory is expensive. James examines water heater sales over the past 50 weeks and notes the following data: Water Heater Sales Number of Weeks Per Week this Number Sold 4 6 5 5 6 9 7 12 8 8 9 7 10 James contracts your team to simulate Hill weekly sales over a 2-year (104 week) period. Using a single replication, your team is to compute the following metrics: - Average weekly sales . Number of weeks with stockouts Once you have the single replication simulated. use Data Table to replicate the model 200 times. Determine the weekly sales and probability that Hill will stockout of water heaters more than 20 times each 104-week period. Use the template provided. Hill Plumbing and Heating sales Distribution Random Random Stockout? (1 Prob- Number Number Average Stockout Week Sales = Yes Sales ability Lower Limit Upper Limit Run Sales Weeks 1 1 2 Supply each week = Expected Weekly Sales = 12 13 Based on 1 Replication: 14 Average Weekly Sales = 15 # of Stockout Weeks= 16 17 Based on 200 Replications; 15 Average Weekly sales = 19 P(>20 stockout weeks= 20 34 35 38 37 38 39 40 41 42 49 44 49 48 47 49 51\f