Forecast How Many Employees To Hire Based on Active and Termed Employees

Hello everyone,

I was wondering if someone might be able to assist me in figuring this issue out with me or if it is even possible to solve this issue. I'm trying to forecast or estimate how may people I would need to hire based on the current number of active employees we have right now and the people who have been termed?

Is this even possible or am I missing data that would make this calculation possible. I'm thoroughly at a dead end in trying to formulate this and any/all assistance is greatly appreciated.

I've attached the data I have below.

Thank you!


Data.xlsx

Hi Kanook,

Just to clarify something, why are you using May, June, July etc to replace employees terminated in April? Wouldnt it be employees terminated in April are replaced in May, those terminated in May replaced in June etc. It just seems like your trying to pull the data for the whole year based on one source, in this case the figures from April.

EDIT: Or are you using the figures from April to estimate the requirements for the whole year?

Thank you Phrick,

Those are great follow up questions to my issue. The simple answer to that first question is yes, that would make sense to replace the previous month's terminated employees in the current month. However since we are looking at a projection for the rest of the year, I would need to find a way to guess/project how many employees we would need for the rest of the year (ie: in july, august, september) right now.

Would providing a monthly data from previous months this year (jan-apr) help this at all? I realized I just have the overall total of active and termed employees up to the month ending in April and I wonder if breaking it down by month would help calculate for the future months this year?

Your second question is about exactly what I"m trying to do. I am trying to figure out the requirements we would need to hire throughout the whole year and hopefully break that down by month or by quarter based on the data I already have in terms of active/termed employees from the previous months this year (Jan-Apr).

I hope I'm making any sense and thank you so much for your reply.