Jessica Williams, manager of kitchen appliances for the Midtown Department Store, feels that her inventory levels of stoves have been
running higher than necessary. Before revising the inventory policy for stoves, she records
the number sold each day over a period of
25 days, as
summarized below.
Number sold
Number of days
2
3
4
5
6
4
7
8
5
1
Click here for the Excel Data File
Formulate a spreadsheet model for performing a computer simulation of the daily sales.
Perform 300 replications and obtain the average of the sales over the 300 simulated days.
Note: Round your answer to 2 decimal places
.
Average daily sales