Hardcastle
New Member
- Joined
- Nov 10, 2005
- Messages
- 2
Hello again, I posted yesterday, but no one responded. 
I'm creating a simple queueing problem. I have 2 cashiers or checkers, and then I generate a random number of customers. Each cashier can only help so many customers per 5 minutes period. Basically, I have 2 columns that keeps track of how many customers each cashier has served, and then the customers they did not serve go into a "queue" meaning they have to wait in line.
You can see my worksheet setup here.
http://www.mrexcel.com/board2/viewtopic.php?p=858148
I'm trying to do the following:
Suppose the arriving customers go to the shortest line. For example, when there are two customers in line A, four customers in line B, four new customers arrive. The first two customers will go to line A because it is shortest. The third customer will go to either line A or line B. The fourth customer will go to whichever line the third customer did not go to.
With one cashier, it's not a problem. However, I'm trying to set up an IF statement that compares the queues for TWO cashiers, places the new arriving customers in the shortest queue or line, and then determines how many each cashier can serve before the next arrivals come. Help please? Thank you again!
I'm creating a simple queueing problem. I have 2 cashiers or checkers, and then I generate a random number of customers. Each cashier can only help so many customers per 5 minutes period. Basically, I have 2 columns that keeps track of how many customers each cashier has served, and then the customers they did not serve go into a "queue" meaning they have to wait in line.
You can see my worksheet setup here.
http://www.mrexcel.com/board2/viewtopic.php?p=858148
I'm trying to do the following:
Suppose the arriving customers go to the shortest line. For example, when there are two customers in line A, four customers in line B, four new customers arrive. The first two customers will go to line A because it is shortest. The third customer will go to either line A or line B. The fourth customer will go to whichever line the third customer did not go to.
With one cashier, it's not a problem. However, I'm trying to set up an IF statement that compares the queues for TWO cashiers, places the new arriving customers in the shortest queue or line, and then determines how many each cashier can serve before the next arrivals come. Help please? Thank you again!
