The DoubleDown Donut shop has decided to produce 15 dozen of its favorite chocolate donut every day. The shop manager has gathered data for a few months and found the distribution of demand is as follows:

Daily Demand (dozens)	Probability
5	.15
10	.25
15	.40
20	.20

Each dozen costs DoubleDown $5.60 to produce and is sold for $9.99. Any leftover donuts at the end of the day are sold to a local homeless shelter for $3.00 per dozen.

1. Create a simulation model to calculate daily profit. The profit model should be similar to those that were set up for Ch 10, however run them horizontally – each day on a separate row.

2. Simulate 30 days (a month) of operation.

3. Calculate the monthly profit

4. Replicate the simulation 12 times

5. Calculate the average monthly profit using the results of the replications

Answer rating: 100% (QA)

Simulation model is as follows K10 SUM 1039 A B c H 1 Cumulative Probability 0 015 5... View the full answer