Question: A local bank has a single drive-through window with arrival times and service times that follow the distributions from the following table: Simulate the arrival

A local bank has a single drive-through window with arrival times and service times that follow the distributions from the following table:

Simulate the arrival of 200 customers to compute each of the following measures: (a) average time a customer waits for service, (b) average time a customer is in the system (wait plus service time), and (c) percentage of time the server is busy with customers. Replicate each measure N times to compute the average.

TIME BETWEEN ARRIVALS SERVICE TIME (MIN.)PROBABILITY (MINPROBABILITY( 0.15 0.24 0.27 0.22 0.12 0.15 0.35 0.22 0.28

Step by Step Solution

★★★★★

3.55 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

718-M-S-L-P (1281).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

A customer service counter at a local bookstore is normally staffed by a single employee. The probabilities of arrival times and service times are shown in the following table: Simulate the arrival...

of a branch of a local bank has the business objective of reducing the waiting times of customers for teller service during the 12: 00 noon to 1: 00 p. m. lunch hour. A subgroup of four customers is...

In response to an inquiry from its national office, the manager of a local bank has stated that her banks average service time for a drive-through customer is 93 seconds. A student intern working at...

( EXCEL FORMAT, PLEASE USE TEMPLATE PROVIDED ) A local bank has a single drive - through window with arrival times and service times that follow the distributions from the following table: TIME...

38 A local bank has a single drive-through window with arrival times and service times that follow the distributions from the following table: TIME BETWEEN ARRIVALS (min.) PROBABILITY SERVICE TIME...

How to solve Using excel. Please include steps and formulas 10-38. ?A local bank has a single drive-through window with arrival times and service times that follow the distributions from the...

A local bank has a single drive-thru window with arrival times and service times that follow the distributions from the table below. Simulate 11 customers arriving for service format below and...

fill out the table QUESTION 18 110 marks A college cafeteria has a single checkout lane manned by a single cashier with student arrival times and service times that follow the distributions from the...

Consider single channel queue system shown in Figure 1. Arrival times and Service times are shown in Table 1. Simulate the problem for 5 customers by filling in the simulation table given in Table 1....

It is important to ensure passenger comfort on ships by stabilizing the ship's oscillations due to waves [13]. Most ship stabilization systems use fins or hydrofoils projecting into the water to...

The square footage and monthly rental of 10 similar two-bedroom apartments yield the linear regression formula y = 1.165x + 615.23 where x represents the square footage of the apartment and y...

Question content area top Part 1 Westin Delivery Service owns a delivery truck. Which of the following costs, associated with the truck, will be treated as a revenue expenditure? Question content...

The following accounts are the consolidated balance sheet and parent company balance sheet for Alpha Ltd as at 30 June 20X2. Notes: (i) There was only one subsidiary called Beta Ltd. (ii) There were...

Consider the following nonlinear programming problem. Minimize Z = x41 + 2x22 Subject to x21 + x22 2. (There are no nonnegativity constraints.) Use dynamic programming to solve this problem.

Consider the following nonlinear programming problem. Maximize Z = x31 + 4x22 + 16x3, Subject to x1 x2 x3 =4 and x1 1, x2 1, x3 1. (a) Solve by dynamic programming when, in addition to the given...

Consider the following nonlinear programming problem. Maximize Z = x1 (1 x2) x3, Subject to x1 x2 + x3 1 and x1 0, x2 0, x3 0. Use dynamic programming to solve this problem.

A firm has invested $500 in a new machine that is expected to last for the next 5 years. The machine will be depreciated on a straight line basis down to zero by the end of its 5 year life. The firm...

You have to choose between two projects as given below and you cannot repeat either project. Which project would you choose and why? Assume discount rate at 20%. Investment (mn.) Cashflow in Year 2...

For 2019, Wilma has properly determined that her taxable income is $36,000, including $3,000 of unrecaptured & 1250 gain and $8,200 of 0%/15%/20% gain. Wilma qualifies for head-of-household filing...