Solved

The Owner of Sal's Italian Restaurant Wants to Study the Growth

Question 33

Essay


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 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. -Using the information in Exhibit 12.5 and the Risk Solver Platform (RSP), what formulas should go in cells B8:D21 of the spreadsheet? 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. -Using the information in Exhibit 12.5 and the Risk Solver Platform (RSP), what formulas should go in cells B8:D21 of the spreadsheet?
-Using the information in Exhibit 12.5 and the Risk Solver Platform (RSP), what formulas should go in cells B8:D21 of the spreadsheet?

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q6: If chance or uncertainty is present in

Q21: Exhibit 12.2<br>The following questions use the information

Q28: How should one determine which RNGs to

Q29: Which of the following probability distributions are

Q30: <br>The owner of Sal's Italian Restaurant wants

Q31: What is the correct Risk Solver Platform

Q36: University Florists makes bouquets from a variety

Q47: Exhibit 12.5<br>The following questions use the information

Q53: Simulation is used to<br>A) find possible worst

Q83: If a spreadsheet simulation user has a