Question: Given the previous analyses based on the observed inter-arrival times between the orders and the times to process them (see the two spreadsheets provided in

Given the previous analyses based on the observed inter-arrival times between the orders and the times to process them (see the two spreadsheets provided in the previous questions), the site manager hopes to estimate the average time to get an order ready for pickup. Please note that this time includes both the duration an order needs to wait before it can be processed by an in-store shopper, and the processing time by the shopper (shopping, checkout, and moving the the staging area).

The following diagram illustrates the waiting line model. In queueing terms, the time to be estimated is the "system time".

With 11 in-store shoppers, what is the average time to get an order ready for pickup (in minutes), based on the PollaczekKhinchine formula?

Note: 1. Round your answer to 2 decimal places.

2. Please make use of the two spreadsheets appeared in previous questions to perform the required calculations. Some of the intermediate results may already be available from earlier questions. However, please make sure that they are correct as they may affect the correctness of your answer to the current question. Given the previous analyses based on the observed

AutoSave OFF 9 ... Service_times (1) AutoSave OFF no @ @y... Interarrival_times Home Insert Draw Page Layout Formulas Data >> Tell me Share Comments Home Insert Draw Page Layout Formulas >> >> Tell me Share Comments A % o A. Fm V Conditional Formatting Format as Table Cell Styles % ma Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Analyze Sens Clipboard Font Alignment Number Cells Editing Se Data Analyze Data A2 4 x fx foc A2 2x fx 2.8 7 B D D E F F A B D E E F F G H 1 Time of picking items 1 Order # (minutes) 2 #1 27 3 #2 13 4 #3 10 5 #4 17 6 #5 25 7 #6 12 8 #7 7 9 #8 26 10 #9 37 11 #10 18 12 #11 19 13 #12 33 14 #13 14 15 #14 26 16 #15 31 17 #16 23 18 #17 39 19 #18 14 60 21 #20 41 22 #21 29 23 #22 19 24 #23 34 25 #24 21 26 #25 36 Time fo checkout and moving to the staging area (minutes) 7 4 6 6 5 25 12 2 11 37 18 19 33 14 26 31 23 14 4 20 11 11 5 9 1 Interarrival times (minutes) 2 2.8 3 3 6.4 4 4 3.5 5 0.1 6 1.5 7 3.3 8 0.8 9 7.1 10 0.8 11 1.2 12 0.1 13 12.8 14 8.1 15 3.7 16 3.6 17 8.1 18 4.1 19 0.7 20 2.7 21 5.2 22 3.3 23 0.5 24 0.6 25 10 20 #19 26 6 27 15 28 27 29 28 30 29 31 30 Sheet1 + Sheet1 + Ready a + 100% Ready 100% A +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

the spread sheets are from the previous questions , please use those previous question is Q 10 The manager hopes to reduce the average time for getting an order ready for pick-up (either by a...

Please help me with this question ASAP. Thank you! Given the previous analyses based on the observed inter-arrival times between the orders and the times to process them (see the two spreadsheets...

Describe why cluster analysis might be appropriate both before and after an MDS study.

Skillings Industrial Chemicals, Inc., operates a refinery in southwestern Ohio near the Ohio River. The companys primary product is manufactured from a chemical process that requires the use of two...

Joaquim recently learned about a fund that boasted a 2 8 % return in ts marketing materials. Eagerly, he invested $ 1 0 0 , 0 0 0 without doing any research into the fund. A yur later, he had $ 1 2 5...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...