Question

**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.**

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

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

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

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 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 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 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 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
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 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 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
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 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

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 4 minutes ago

asked 7 minutes ago

asked 7 minutes ago

asked 18 minutes ago

asked 21 minutes ago

asked 21 minutes ago

asked 21 minutes ago

asked 35 minutes ago

asked 36 minutes ago

asked 36 minutes ago

asked 44 minutes ago