- #1
sleepingneko
- 1
- 0
Hi there everyone, need help with a work assignment which I feel is simple but I just cannot wrap my mind around it. Not too sure if this is the correct thread though, so I beg for your forgiveness if it is the wrong thread. :X
Premise:
At a certain workplace, there are 5 equipment loading bays, and 1 equipment issuance counter.
The work flow is as such:
1) Person goes to the issuance counter to draw his equipment.
2) Person goes to the equipment loading bay to load his equipment.
3) Person leaves the area.
Parameters:
A) Total number of persons
B) Time it takes for person to draw his equipment
C) Time it takes for person to load his equipment
Assumption:
The issuance counter can only handle one person at a time.
Question:
So say if I have 30 persons, and it takes 2 minutes for the person to equip his items, and 1 minute for the equipment to be issued at the counter, how long is it going to take with just 5 equipment loading bays and 1 equipment issuance counter?
I have been racking my brains as to come up with a formula for Excel so that I can vary the above-mentioned parameters and come up with an optimal ratio of equipment loading bays to equipment issuance counters…
My math is rather rusty and this is work assignment given by my boss. I have not practiced math for about 4 years since graduation and my boss is rather demanding… Sigh. Help... please?
Much thanks to anyone who can help in advance. :)
Premise:
At a certain workplace, there are 5 equipment loading bays, and 1 equipment issuance counter.
The work flow is as such:
1) Person goes to the issuance counter to draw his equipment.
2) Person goes to the equipment loading bay to load his equipment.
3) Person leaves the area.
Parameters:
A) Total number of persons
B) Time it takes for person to draw his equipment
C) Time it takes for person to load his equipment
Assumption:
The issuance counter can only handle one person at a time.
Question:
So say if I have 30 persons, and it takes 2 minutes for the person to equip his items, and 1 minute for the equipment to be issued at the counter, how long is it going to take with just 5 equipment loading bays and 1 equipment issuance counter?
I have been racking my brains as to come up with a formula for Excel so that I can vary the above-mentioned parameters and come up with an optimal ratio of equipment loading bays to equipment issuance counters…
My math is rather rusty and this is work assignment given by my boss. I have not practiced math for about 4 years since graduation and my boss is rather demanding… Sigh. Help... please?
Much thanks to anyone who can help in advance. :)