FTE calculation for month totaling 147 hrs

Topic Views - 704

FTE calculation for month totaling 147 hrs
What is the formula used to calculate the hours for each FTE in a given month of 22 working days which results in 147 hours.


Call Centre Helper

Are you talking about a scheduling algorithm?
So what details do you have.
Do you have daily call volumes for each of the 22 days? Do you have it broken down by hours? Do you have the number of staff needed across each hour?
Depending upon the information that you have the answer will be different.

Calculation- DAY(EDATE(A2,1)-1)/7*5*8 where A2 is month in question (01/05/19 for instance) will give gross hours (177.14), presumably your 146 is after shrinkage (about 17.6% in your case if so)

Want to add a comment?

Not found what you were looking for?

1. Try searching through our site.
2. Still not got an answer?

Why not ask the Call Centre Helper Community? Click here to ask your question