Please fill out the data tables using the given information Marsha operates an espresso stand. Customers arrive randomly at a mean rate of 30 per hour. The time needed by Marsha to serve aCustomer has an exponential distribution with a mean of 75 seconds.Click here for the Excel Data Filea. Use the Excel template for the M/G/1 model to find L, Lq, W, Wq, P. and Po.Note: Round your answers to 3 decimal places.L=q=W=W₁ =p=Po=Resultsb. Suppose Marsha is replaced by an espresso vending machine that requires exactly 75 seconds to operate for each customer. FindL, Lq, W, Wq, p, and Po.Note: Round your answers to 3 decimal places.|L=LqW =W₁ =p=Po=Results Template for the M/G/1 Queueing Model|λ=V/u=G8-Data(mean arrival rate)(expected service time(standard deviation)#servers)LE≤W =W₂PP₁=ResultsRange Nar CellLLambda C4LqRhoOneOverM C5158333355 858SigmaG4WaG10G7

Mean arrival rate = 30 per hourExponential service rate = 75 secondsNotations used:Convert the values in per minute as follows:Use the following formulas:Excel calculations:Convert the values in per minute as follows:Use the following formulas:Excel calculations:Thus, the final solution values are as follows:a.b.

Answered: Marsha operates an espresso stand.…

Business

Operations Management

Marsha operates an espresso stand. Customers arrive randomly at a mean Pate of 30 per hour. The ustomer has an exponential distribution with a mean of 75 seconds.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Why is it necessary to gather data on a continuous basis?
Explain the importance of data management in modern organizations. What are the key components of a data management strategy?
perspective on the importance of data management.
Define data mining
Evaluate the data management strategies of various companies.
Explain the concept of data management in the context of modern businesses, highlighting its significance.
Describe and elaborate on the numerous categories of available data sources.
Explain the concept of master data management (MDM) and its significance in maintaining data quality.
This piece will differentiate between the two types of data flow charts and explain their uses. How come MetaData is crucial for data warehousing operations if it's not really needed?
Describe the process of master data management (MDM) and its role in maintaining data consistency across an organization.
What are slowly changing dimensions (SCDs), and why are they important in data warehousing? Describe the different types of SCDs and when to use them.
Explore the role of master data management (MDM) in maintaining data consistency across an organization.