Formula Questions

E

esi

Trying to calculate this in Excel

I have 3 different processes for an order:

Filling - 300 parts per hour
Packing - 100 parts per hour
Shipping - 50 parts per hour

If I need to staff for 9,000 parts per day for a 7.5 hour day, how would I
calculated my total production for all 3 steps combined per hour remembering
that each part must pass all 3 stations?
 
A

Arvi Laanemets

Hi

Filling staff
=9000/(7.5*300)
Packing staff
=9000/(7.5*100)
Shipping staff
=9000/(7.5*50)
 
Top