Exhibit 12.5
The following questions use the information below.
The owner of Sal's Italian Restaurant wants to study the growth of his business using simulation.He is interested in simulating the number of customers and the amount ordered by customers each month.He currently serves 1000 customers per month and feels this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%.The bill for each customer is a normally distributed random variable with a mean of $20 and a standard deviation of $5.The average order has been increasing steadily over the years and the owner expects the mean order will increase by 2% per month.You have created the following spreadsheet to simulate the problem.
-The spreadsheet model for Sal,from Exhibit 12.5,has been run 300 times to produce the following output.What is the best case scenario for Sal based on this output?
Correct Answer:
Verified
Q21: Methods for analyzing risk that are discussed
Q35: Using the information in Exhibit 12.3, what
Q41: A machine produces an average of
Q44: Exhibit 12.5
The following questions use the
Q46: What function should be used for
Q47: University Florists makes bouquets from a
Q57: Exhibit 12.3
The following questions use the information
Q68: Exhibit 12.5
The following questions use the information
Q78: Exhibit 12.5
The following questions use the information
Q81: Exhibit 12.5
The following questions use the information
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents