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

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

Time fo checkout and moving to the staging area (minutes) 7 4 6 5 25 12 2 11 19 Time of picking items Order # (minutes) #1 27 #2 13 #3 10 #4 17 #5 25 #6 12 #7 7 #8 26 #9 37 #10 18 #11 #12 33 14 #14 26 #15 31 #16 23 #17 39 #18 14 #19 60 #20 41 #21 29 19 #23 34 #24 21 #25 36 #13 37 18 19 33 14 26 31 23 14 4 20 11 11 5 9 #22 6 15 Interarrival_times_(minutes) 2.8 6.4 3.5 0.1 1.5 3.3 0.8 7.1 0.8 1.2 0.1 12.8 8.1 3.7 3.6 8.1 4.1 0.7 2.7 5.2 3.3 0.5 0.6 10

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

2. Change the total fixed manufacturing overhead cost for the Milling Department in the area back to $390,000, keeping all of the other data the same as in the original example. Consider a new job,...

Refer to the information in QS 10-9. Assume the equipment is depreciated using the double-declining-balance method. Calculate depreciation for 2014 and 2015: a. To the nearest whole month, and b....

This year Southfork began work on a serior center to hold activities for th growing senior cllean population. It is to be financed by a $ 6 , 7 0 0 , 0 0 0 bond issue, a $ 6 7 0 , 0 0 0 grant, and a...

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