Question

Please complete all work in excel. Use excel to make the calculations (cells can be clicked...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units.

  1. Patrons arrive at a movie theater at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson).
    1. What is the average number of patrons in the system with 5 ticketing stations?

  1. What is the minimum number of ticketing stations needed to keep the average time in the system under three minutes?

Homework Answers

Answer #1

Arrival rate = 4 per minute

Service rate = 50 per hour = 50/60 = 0.8333 per minute

Formulate Excel model with formulas as shown below:

b)

Using 5 ticket stations (number of servers, s=5), calculations are following:

Average number of patrons in the system, L = 26.4408

----------------------------------------------------

b)

Increase the number of servers in cell B6 to 6 and see the value in cell B12

Using 6 ticketing stations,

Average time in the system = 1.7178 minutes

We see that, with 6 ticketing stations, average time in system (W) is well under three minutes

Therefore, minimum number of ticketing stations needed to keep the average time in system under three minutes = 6 ticketing stations

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. A manager needs to buy raw materials for the production process. For a particular raw material, the manager uses 20,000 units each year. The supplier has quoted a price of $6.50 per unit for an order size of 999 units or less, a price of $6 per unit for...
*please use excel and provide the formulas Customers arrive randomly at a product returns counter at...
*please use excel and provide the formulas Customers arrive randomly at a product returns counter at a department store, which meets the assumptions of the Single-Server, Single-Phase waiting line model (i.e., the arrival rate is Poisson distributed and service rate is exponentially distributed). There is only one returns employee, and the time required for returns varies from customer to customer. There is a single waiting line. The average arrival rate is 15 customers per hour. The average time to serve...
Work all problems in terms of hours. 1.) If it takes 5 minutes to serve a...
Work all problems in terms of hours. 1.) If it takes 5 minutes to serve a customer at a fast food restaurant, the service rate is ______ . (Give the number only, don't include any words. ) 2.) Customers arrive at a candy shop every 8 minutes on average. What is the arrival rate? (Give the number only.) 3.) In a single-server queuing system, 10 customers arrive per hour, and 20 customers are served per hour. What is the arrival...
1. Willow Brook National Bank operates a drive-up teller window that allows customers to complete bank...
1. Willow Brook National Bank operates a drive-up teller window that allows customers to complete bank transactions without getting out of their cars. On weekday mornings, arrivals to the drive-up teller window occur at random, with an arrival rate of 6 customers per hour or 0.1 customers per minute. Also assume that the service times for the drive-up teller follow an exponential probability distribution with a service rate of 54 customers per hour, or 0.9 customers per minute. Determine the...
Please answer the entire problem! Problem 15-25 (Algorithmic) Burger Dome sells hamburgers, cheeseburgers, French fries, soft...
Please answer the entire problem! Problem 15-25 (Algorithmic) Burger Dome sells hamburgers, cheeseburgers, French fries, soft drinks, and milk shakes, as well as a limited number of specialty items and dessert selections. Although Burger Dome would like to serve each customer immediately, at times more customers arrive than can be handled by the Burger Dome food service staff. Thus, customers wait in line to place and receive their orders. Suppose that Burger Dome analyzed data on customer arrivals and concluded...
Review “Multiple Regression Models Case Study: Web Video on Demand” for this topic’s case study, predicting...
Review “Multiple Regression Models Case Study: Web Video on Demand” for this topic’s case study, predicting advertising sales for an Internet video-on-demand streaming service. After developing Regression Model A and Regression Model B, prepare a 250-500 word executive summary of your findings. Explain your approach and evaluate the outcomes of your regression models. Submit a copy of the Excel spreadsheet file you used to design your regression model and determine statistical significance. (Use Excel’s regression option to perform the regression)....
*** Please show excel formulas, thanks *** Babaloo leather company produces briefcases from leather, fabric, and...
*** Please show excel formulas, thanks *** Babaloo leather company produces briefcases from leather, fabric, and synthetic materials in a single production department. The basic product is a standard briefcase made from leather and lined with fabric. Babaloo has a good reputation in the market because the standard briefcase is a high-quality item that has been produced for many years. Last year, the company decided to expand its product line and produce specialty briefcases for special orders. These briefcases differ...
In the case below please answer the following 4- 6 pages 1. State the ethical issues...
In the case below please answer the following 4- 6 pages 1. State the ethical issues 2. State the legal issues 3. Discuss the options/debate the issues 4. Discuss extra info needed to make decision Rina Cummings has worked three 12-hour shifts every week at Amazon’s gargantuan New York City warehouse, called JFK8, on Staten Island since it first began operations in late 2018. As a sorter on the outbound ship dock, her job is to inspect and scan a...
Review the Robatelli's Pizzeria Case Study. Develop another internal controls system, but this time, in the...
Review the Robatelli's Pizzeria Case Study. Develop another internal controls system, but this time, in the purchases and fixed assets business areas. Prepare a 12- to 16-slide presentation describing the purchases and fixed assets business areas. Be sure to incorporate speaker notes as well as appropriate visuals, graphics, fonts, etc. Include any associated risk in these areas. Describe specific internal controls that include authorization of transactions, segregation of duties, adequate records and documentation, security of assets, and independent checks and...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT