5. [40 points] A restaurant has tracked the average frequency of tables needed for a month...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5. [40 points] A restaurant has tracked the average frequency of tables needed for a month for lunch and dinner service. The data is as follows: Tables needed 30 Lunch Avg. Frequency 3.6 Dinner Avg. Frequency 0 31 4.65 0.31 32 6.4 0.64 33 6.6 0.66 34 3.4 1.7 35 2.45 3.5 36 1.8 7.2 37 1.11 9.25 38 1.52 7.6 39 1.17 3.9 40 0.4 2 A waiter can handle four tables and the restaurant needs one beverage person for each eight tables plus one busboy per twelve tables. To improve customer service the restaurant always rounds up a fractional waiter, beverage, or busboy load. The restaurant wants to simulate the number of tables needed and calculate the staffing required for waiters, busboys, and beverage servers. a. Set up a probability and cumulative probability distribution for the number of tables needed for lunch and dinner services. b. Using Excel random number generator, simulate the table requirement for 2 weeks for lunch and dinner service. Show the table requirement. c. Determine the staffing required for waiters, busboys, and beverage servers for each day for each service. Show the staffing requirement. Calculate the average staffing requirement per day for waiters, busboys, and beverage servers. d. Run the simulation for 5 replications with different random numbers. Record the average staffing requirement for each replication. Discuss the variation of staff requirement in each replication. If you were the operations manager of the restaurant, how would you use the simulation results to plan employee scheduling? 000 5. [40 points] A restaurant has tracked the average frequency of tables needed for a month for lunch and dinner service. The data is as follows: Tables needed 30 Lunch Avg. Frequency 3.6 Dinner Avg. Frequency 0 31 4.65 0.31 32 6.4 0.64 33 6.6 0.66 34 3.4 1.7 35 2.45 3.5 36 1.8 7.2 37 1.11 9.25 38 1.52 7.6 39 1.17 3.9 40 0.4 2 A waiter can handle four tables and the restaurant needs one beverage person for each eight tables plus one busboy per twelve tables. To improve customer service the restaurant always rounds up a fractional waiter, beverage, or busboy load. The restaurant wants to simulate the number of tables needed and calculate the staffing required for waiters, busboys, and beverage servers. a. Set up a probability and cumulative probability distribution for the number of tables needed for lunch and dinner services. b. Using Excel random number generator, simulate the table requirement for 2 weeks for lunch and dinner service. Show the table requirement. c. Determine the staffing required for waiters, busboys, and beverage servers for each day for each service. Show the staffing requirement. Calculate the average staffing requirement per day for waiters, busboys, and beverage servers. d. Run the simulation for 5 replications with different random numbers. Record the average staffing requirement for each replication. Discuss the variation of staff requirement in each replication. If you were the operations manager of the restaurant, how would you use the simulation results to plan employee scheduling? 000
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Explain how to apply the rules of Section (61)a to determine taxable items.
-
The object provides methods for the creation of Statement objects that will be used to execute Oracle statements in the next step. a. Statement b. Connection c. DriverManager d. Driver
-
The following table gives a number of Rockwell G hardness values that were measured on a single steel specimen. Compute average and standard deviation hardness values. 47.3 48.7 47.1 52.1 50.0 50.4...
-
What is the difference between an objective measure and a subjective measure?
-
Assume the expected inflation rate in China to be 4.5 percent. If the current real rate of interest is 6.5 percent, what is the nominal rate of interest?
-
The financial statements for Nike, Inc., are presented in Appendix B at the end of the text. The following additional information (in thousands) is available: Accounts receivable at May 31, 2008........
-
why is there an OSI and TCP / IP model?
-
On February 1, 2014, Punto Company purchased 95% of the outstanding common stock of Sara Company and 85% of the outstanding common stock of Rob Company. Immediately before the two acquisitions,...
-
One would usually find the expected contribution of the report to existing knowledge and identify gaps in knowledge in which section of the research report? One would usually find the expected...
-
https://www.coursehero.com/u/file/130136645/Enterprise-Rental-Case-Culture-People-Centric-Practicesdocx/ Show how this case follows the classical management practices and theories of Taylor, Weber,...
-
A state law reads as follows; " Any child under the age of 10 that is sexually molested by an adult may testify by closed circuit television. Only the judge shall be allowed to question the child....
-
Write a Java function that efficiently calculates the edit distance between two strings.
-
How does the poet employ linguistic ambiguity and metaphorical resonance to evoke the existential conflict between the ephemeral nature of existence and the perennial quest for meaning?
-
Writing is one of the essential skills at school. When learners struggle to write, teachers get frustrated. Describe how you can identify learners who experience barriers to writing. Specific...
-
In cell G6, enter a formula that calculates the Discount Rate for the Off-Peak rental price per day. For example, using the peak and off-peak per day values, the studio apartment rents for 80% of its...
-
What key concerns must functional tactics address in marketing? Finance? POM? Personnel?
-
Table P-20 contains quarterly sales ($MM) of The Gap for fiscal years 1980-2004. Plot The Gap sales data as a time series and examine its properties. The objective is to generate forecasts of sales...
-
Describe each of the components in a time series.
-
a. For a sample of 100 observations of random data, calculate a 95% confidence interval for the autocorrelation coefficient at any lag. b. If all the autocorrelation coefficients are within their...
-
Find the general solution for the difference equation in Example 1.9 when \(a=b\). Example 1.9. Solve the difference equation y(n) + ay(n 2) = b" sin(n)u(n) assuming that ab and y(n) = 0, for n < 0....
-
Write a Matlab program to plot the samples of the solutions of the difference equations in Exercise 1.9 from \(n=0\) to \(n=20\). Exercise 1.9 Find one solution for each of the difference equations...
-
Show that a system described by Equation (1.63) is linear if and only if the auxiliary conditions are zero. Show also that the system is time invariant if the zero auxiliary conditions are defined...
Study smarter with the SolutionInn App