Formula Questions

  • Thread starter Thread starter esi
  • Start date Start date
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?
 
Hi

Filling staff
=9000/(7.5*300)
Packing staff
=9000/(7.5*100)
Shipping staff
=9000/(7.5*50)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 1
Total percentages 2
Rate Calculation 9
Independant times in excel 1
Need formula help 3
HELP!! Formula for calculating overtime 1
Calculating total amount in a Pivot Table 1
Convert Figure to Time HH:ss 2

Back
Top