#### Hardcastle

##### New Member

- Joined
- Nov 10, 2005

- Messages
- 2

*A small store is considering hiring a second checker to join its existing checker. An analysis of the store''s traffic reveals that for each five-minute interval there is a 10% chance of no customers arriving, a 15% chance of one customer arriving, a 15% chance of two customers arriving, a 25% chance of three customers arriving, a 15% chance of four customers arriving, a 10% chance of five customers arriving and a 10% of chance of six customers arriving. Cells G15 and H15 should contain the number of customers the first checker and the second checker can process respectively during a five-minute interval.*

Assume that the customers arrive one at a time at the beginning of the five-minute interval and that each customer chooses the shortest line. How long will each line be after 8 hours, and how many customers will each checker process?

Assume that the customers arrive one at a time at the beginning of the five-minute interval and that each customer chooses the shortest line. How long will each line be after 8 hours, and how many customers will each checker process?

I know it's a lot, and here is my worksheet:

I'm doing the following:

1. Creating a listing of times in column A in 5 minute intervals

2. Generating a random number in column B

3. In column C I'm using VLOOKUP to investigate a table I've created in J25:K31 to return the number of customer's arriving each minute.

4. I've created columns for each checker, and the number of customers they can serve in a 5 minute period.

5. The number of customers each checker can serve is in A19 & B19, respectively

6. The number of customers that each checker CANNOT serve goes into a queue (Columns F & G)

I'm having a little difficulty adapting the following into my worksheet:

*"Assume that the customers arrive one at a time at the beginning of the five-minute interval and that each customer chooses the shortest line."*

Do I need to integrate an IF statement somewhere in my current setup? Once I find that, I can easily determine the line length at the end of 8 hours and the total number of customers served with no problem.

How would I go about setting up my worksheet so that the randomly generated customers go to the shortest line, etc. and the ones that are not served go into a queue?

I truly appreciate your help.