Please answer in excel

Example B.3

Excel Template

9. The sales activity at BestCar (see Example B.3) has changed. Weekly sales are now estimated to be dis- tributed as follows: Weekly Sales (cars) Relative Frequency (probability) 0.02 0 1 0.03 0.05 2 3 0.10 4 0.15 5 0.30 6 0.20 0 0907 7 0.10 8 0.05 Total 1.00 Create an Excel model that simulates 500 weeks at BestCar. It should calculate from the simulated experi- ence the average number of cars and revenue per week and also a frequency table on car sales. in EXAMPLE B.3 Excel Simulation Model for BestCar Auto Dealer The BestCar automobile dealership sells new automobiles. The BestCar store manager believes that the number of cars sold weekly has the following probability distribution: Weekly Sales (cars) Relative Frequency (probabllity) 0 1 2 3 4 5 0.05 0.15 0.20 0.30 0.20 0.10 Total 1.00 Probabilty of Weekly Demand Simulation of 50 weeks Lower Range Probability Prob. Of Demand Car Random Number Simulated Sales (Cars) Demand Week Revenue 1 2 3 4 min 000 5 6 7 8 9 10 11 12 Results 13 Demand Frequency Percentage Cumulative 14 15 16 17 9 10 11 12 : 13 14 Total 0 0 15 16