Answer the following questions by inputting the given data below into the simula

Answer the following questions by inputting the given data below into the simulation spreadsheet attached.
ch05spreadsheet.xlsm
A baker is trying to determine how many dozens of sourdough rolls to bake each day. The number of customers visiting the bakery each days follows a Poisson distribution with ʎ= 10. The customers purchase 1, 2, 3, or 4 dozen rolls with respective probabilities of .30, .35, .25, and .10 each.
(Part A) The rolls sell for $15 per dozen. The cost $5 per dozen to make, all rolls not sold at the end of the day are sold at half price to a local grocery store. How many dozens of bagels should be baked each day?
Note: This problem can be analyzed by developing a static dynamic simulation model
(Part B) Now assume that customers arrive at an inter arrival rate that is exponentially distributed with a mean of 10 minutes. We will need to know how many hours the bakery is open and keep track of the passage of time. In this case the problem can be analyzed by developing a stochastic, dynamic, discrete event simulation model.

Posted in Uncategorized