Calculate Total Head Count from Forecast Hours

Hello everyone,

I am new to this forum and I am grateful to be part of this community. I am hoping to get some help with a current task I am trying to accomplish.

I am trying to run an analysis to calculate total employee needed for Forecasted Hours, by FTE FT, PT and Casual buckets. I have a sample data sheet attached to help understand this better.

The scenario is, I have multiple locations and do a monthly forecaste of how many hours I think we might need to run successfully. I would also love to know how to break down my total hours into the total number of employee that worked those hours. I have a sample data sheet attached.

Thank you so much in advance for your help!

Hi,
please advise what is FTE FT, PT and Casual.
what results do you expect to see there?

Hello! Thanks for your response. Please see below.

FTE = Full Time Equivalent
FT = Full Time
PT = Part Time

I am hoping to get a solution where I see a breakdown of total employees that make up the total hours worked and then I can predict how many employee it would take for the forecasted hours to get the job done.

For Example:

Total hours worked in the month of January = 256 hours
How can I get the exact totals as listed below
Total FT employees = 4
Total PT employees = 5
Total FTE = 3

Thanks again!