Hi,

I have built a productivity forecast model and am now in the process of comparing actual performance against forecast month on month.

I already have an erlang formula in place to tell me how many staff i utilised to achieve the service level I did the month before but I have no where to factor in the actual occupancy levels the advisors achieved.

As the advisors have been put under pressure and set some tight deadlines their occupancy percentage for the month is in the 90's and i do not feel this is reflected in the FTE my calculation is telling me I used (When I have done the occupancy calculation on the erlang formula is is coming out in the high 70's.

Can anyone help me with an idea on how to factor this in or a specific formula?

Thanks