The owner of Sal's Italian Restaurant wants to study the growth of his business using simulation....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. A Initial Conditions: 2 Number of Customers: 1000 3 Average Bilt: $20 Number of Avg Bll Total Month Customers Revenue 1014.80 $17 $17,703 106454 $23 524.645 10 3 1054.23 $24 $24,904 11 1114.73 $31 $35.001 12 1208.94 $25 $29.947 13 1310.42 $16 $21.202 14 1352.23 $24 $32.983 15 1336.12 $31 $40,851 16 1412.07 $22 $30.548 17 10 1444.66 $28 $40.292 18 11 1462.64 $31 $44.899 19 12 1539.91 $26 $39.695 20 21 Income $382.670 SAL'S MODEL G. H. 1 Assumptions: 2 Max Decrease Max Increase: Std Dev SK 9% Uniform Mthl Increase 2% Normal 4. Constant 9. 6. 10 11 12 13 14 15 16 17 18 19 20 21 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? Simulation Statistics Name Description Cell Minimum= Maximum= Mean= Std Deviation= Income/Revenue Output D21 211786.92 435002.74 419518.91 33831.44 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. A Initial Conditions: 2 Number of Customers: 1000 3 Average Bilt: $20 Number of Avg Bll Total Month Customers Revenue 1014.80 $17 $17,703 106454 $23 524.645 10 3 1054.23 $24 $24,904 11 1114.73 $31 $35.001 12 1208.94 $25 $29.947 13 1310.42 $16 $21.202 14 1352.23 $24 $32.983 15 1336.12 $31 $40,851 16 1412.07 $22 $30.548 17 10 1444.66 $28 $40.292 18 11 1462.64 $31 $44.899 19 12 1539.91 $26 $39.695 20 21 Income $382.670 SAL'S MODEL G. H. 1 Assumptions: 2 Max Decrease Max Increase: Std Dev SK 9% Uniform Mthl Increase 2% Normal 4. Constant 9. 6. 10 11 12 13 14 15 16 17 18 19 20 21 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? Simulation Statistics Name Description Cell Minimum= Maximum= Mean= Std Deviation= Income/Revenue Output D21 211786.92 435002.74 419518.91 33831.44
Expert Answer:
Answer rating: 100% (QA)
Given that Average meal price 20 SD of meal price 5 The current number of customers vary from 095 to ... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-111182591
7th edition
Authors: Philip J. Pratt, Joseph J. Adamski
Posted Date:
Students also viewed these accounting questions
-
1. Design a database for Ray. He is interested in movie DVDs and wants to keep information on movies, actors, and directors in a database. The only user is Ray, and he needs to produce the following...
-
Rosas Italian restaurant wants to develop forecasts of daily demand for the next week. The restaurant is closed on Mondays and experiences a seasonal pattern for the other six days of the week....
-
The owner of the Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. He has gathered data on the monthly...
-
6 Question 9 of 11 View Policies Cash Receivables Inventories Current Attempt in Progress On January 1, 2024, Novak Company acquired all the assets and assumed all the liabilities of Crane Company...
-
Explain the concepts of fiscal and monetary policy. Who conducts them and how do they work their way through the economy?
-
List the popular query languages.
-
Refer to the bond situation of Hewitt Corporation in Exercise 15-27. Hewitt issued the bonds at the advertised price. The company uses the straight-line amortization method and reports financial...
-
Effects of Burger Kings Current Liabilities on Its Statement of Cash Flows The following items are classified as current liabilities on Burger King Holdings, Inc.s balance sheets as of June 30, 2008,...
-
Identify the video produced by the Tourism SA Are the videos effective? Do they fit the organisation's brand? If the organisation has not produced any videos, do you think they should?...
-
Consider the December transactions for Crystal Clear Cleaning that were presented in Chapter 5. Crystal Clear uses the perpetual inventory system. Dec. 2 Purchased 475 units of inventory for $2,850...
-
The group project is a hands-on exercise in planning a financial statement audit. The project will give you an opportunity to consider how the concepts and techniques discussed in the course apply in...
-
The functions and g are defined as follows. f(x)=x+9x+4 and g(x)=- Find f(x-2) and, 7 Write your answers without parentheses and simplify them as much as possible. f(x-2)= G X 0-(+-)
-
Utilize the graph above, which illustrates average fixed costs, average variable costs, average total costs, and marginal costs of production for a firm in a perfectly competitive market, to answer...
-
Simplify the expressions below -27 =0 -20--5=0
-
If a credit card company runs an ad quoting a nominal interest rate of 2 3 . 7 percent on charges. What is the effective interest rate if interest is compounded quarterly? monthly?
-
The board of directors agreed with your strategic report, and now the chief marketing officer (CMO) would like you to provide the board an analysis of the company's consumers and their perception of...
-
Teamwork is important to both organizations and quality. However, it is difficult to implement teamwork, if at first you lack a team. So, to begin with, leaders need skills in team building prior to...
-
Find the numerical value of each expression. (a) sech 0 (b) cosh -1 1
-
In a two-tier client/server architecture, what problems occur when you place the business functions on the clients? On the server?
-
What does XSLT accomplish?
-
The Orders table contains a foreign key, CustomerNum, that must match the primary key of the Customer table. What type of update to the Orders table would violate referential integrity? If deletes do...
-
Brown, CPA, is auditing the financial statements of Big Z Wholesaling, Inc., a continuing audit client, for the year ended January 31, 19X2. On January 5, 19X2, Brown observed the tagging and...
-
Your audit client, Household Appliances, Inc., operates a retail store in the center of town. Because of lack of storage space, Household keeps inventory that is not on display in a public warehouse...
-
Assume that a CPA's client proposes to have an independent firm that specializes in inventory taking count the merchandise rather than use their own employees. Under these conditions, would it be...
Study smarter with the SolutionInn App