My challenge is similar. I'm trying to calculate staffing levels based on volume and average handling time per item and having trouble with finding a formula. If I have 50,000 items a month to process and it takes 3 mins 30 seconds to process each item, how do a write a formula to calculate the total time required to process those items and then based on 174 hours a month (hours worked by 1 fte), how many FTEs do I need.
With 50000 in A1 and 00:03:30 in B1, then in C1
=ROUND((A1*B1/174*24),0) this round it to WTE
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks