Question: please help answer all parts as this is technically only one question The owner of Sal's Italian Restaurant wants to study the growth of his

please help answer all parts as this is technically only one question
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 that each month, this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%, where the increase or decrease is based on the previous month. The bill for each customer is currently 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, while the standard deviation will remain unchanged. The following spreadsheet has been set up to simulate the problem using Analytic Solver Platform. Note that only the resulting numbers of the underlying formulae are shown. The initial conditions shown in the spreadsheet may be thought of as month O; increases in the minimum and maximum number of customers, and in the average bill per customer, begin in month 1. D F G H H 1 B 1 Initial Conditions: 2 Number of Customers: 3 Average Bill 4 E Assumptions: Max Decrease Mthi. Increase: 596 9% Uniform 1000 S20 Max Increase: Std Dev: 296 Normal Constant 5 6 Total Revenue 7 Month 8 1 1 9 2 3 Number of Avg. Bil Customers 10148 $17 106454 $23 1054 23 $24 - 1114.73 $31 1208.94 $25 131042 $16 1352.23 $24 1336.12 10 11 12 13 14 4 S 6 $17,703 S24,645 $24.904 $35,001 - $29,947 $21,202 Sandra $32,983 $40.851 . $30 545 www. $40,292 $44.899 $39.695 7 8 15 $31 16 9 1412.07 $22 17 10 528 18 11 12 1444.66 1462.64 1539.91 $31 $26 19 20 21 Income: $382,670 22 In answering the questions below, the arguments" for a function are its inputs. For example, the first argument for the function SUM(A1,B1,C3) is A1, the second argument is B1, and so forth. The Analytic Solver Platform function needed in cell B9 is: The first argument for the Analytic Solver Platform function needed in cell B9 is: The second argument for the Analytic Solver Platform function needed in cell B9 is: The Analytic Solver Platform function needed in cell C9 is: The first argument for the Analytic Solver Platform function needed in cell C9 is: The second argument for the Analytic Solver Platform function needed in cell C9 is: 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 that each month, this can vary uniformly between a decrease of as much as 5% and an increase of up to 9%, where the increase or decrease is based on the previous month. The bill for each customer is currently 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, while the standard deviation will remain unchanged. The following spreadsheet has been set up to simulate the problem using Analytic Solver Platform. Note that only the resulting numbers of the underlying formulae are shown. The initial conditions shown in the spreadsheet may be thought of as month O; increases in the minimum and maximum number of customers, and in the average bill per customer, begin in month 1. D F G H H 1 B 1 Initial Conditions: 2 Number of Customers: 3 Average Bill 4 E Assumptions: Max Decrease Mthi. Increase: 596 9% Uniform 1000 S20 Max Increase: Std Dev: 296 Normal Constant 5 6 Total Revenue 7 Month 8 1 1 9 2 3 Number of Avg. Bil Customers 10148 $17 106454 $23 1054 23 $24 - 1114.73 $31 1208.94 $25 131042 $16 1352.23 $24 1336.12 10 11 12 13 14 4 S 6 $17,703 S24,645 $24.904 $35,001 - $29,947 $21,202 Sandra $32,983 $40.851 . $30 545 www. $40,292 $44.899 $39.695 7 8 15 $31 16 9 1412.07 $22 17 10 528 18 11 12 1444.66 1462.64 1539.91 $31 $26 19 20 21 Income: $382,670 22 In answering the questions below, the arguments" for a function are its inputs. For example, the first argument for the function SUM(A1,B1,C3) is A1, the second argument is B1, and so forth. The Analytic Solver Platform function needed in cell B9 is: The first argument for the Analytic Solver Platform function needed in cell B9 is: The second argument for the Analytic Solver Platform function needed in cell B9 is: The Analytic Solver Platform function needed in cell C9 is: The first argument for the Analytic Solver Platform function needed in cell C9 is: The second argument for the Analytic Solver Platform function needed in cell C9 isStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
