Solution for Optimal Number of Issuance Counters and Loading Bays

  • Context: MHB 
  • Thread starter Thread starter sleepingneko
  • Start date Start date
Click For Summary
SUMMARY

The discussion focuses on optimizing the workflow of equipment issuance and loading at a workplace with 5 loading bays and 1 issuance counter. Given 30 persons, each requiring 1 minute at the counter and 2 minutes at the loading bays, the total time for all individuals to complete the process is calculated. The challenge lies in developing an Excel formula to determine the optimal ratio of loading bays to issuance counters based on varying parameters.

PREREQUISITES
  • Understanding of basic queuing theory
  • Familiarity with Excel formulas and functions
  • Knowledge of time management in workflow processes
  • Basic arithmetic and algebra skills
NEXT STEPS
  • Research queuing theory principles to optimize workflow
  • Learn how to create dynamic Excel models for process simulations
  • Explore time management techniques in operational settings
  • Investigate case studies on equipment issuance and loading optimization
USEFUL FOR

Operations managers, workflow analysts, and anyone involved in optimizing equipment issuance and loading processes in a workplace setting.

sleepingneko
Messages
1
Reaction score
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. :)
 
Mathematics news on Phys.org
sleepingneko said:
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. :)

Hi sleepingneko! Welcome to MHB! (Smile)

Let's see if we can break this down into smaller and simpler pieces.

Suppose there was only 1 person.
At which time will he have his equipment and at which time will he be done equipping his items?

Now suppose there is a 2nd person.
When can he start getting his equipment?
Where can he load his equipment when he has it?
And when will he be ready?
 

Similar threads

  • · Replies 3 ·
Replies
3
Views
1K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 26 ·
Replies
26
Views
3K
  • · Replies 20 ·
Replies
20
Views
8K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 6 ·
Replies
6
Views
3K
  • · Replies 14 ·
Replies
14
Views
1K
  • · Replies 6 ·
Replies
6
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K