Formula Creation?

[jkmcken]

Hello,

I am trying to create a formula that when given a Target/Current Utilization Percentage and Current Personnel Number returns a Target Personnel Number.

The Current formula I am using(which is not correct) is as follows:

Target Utilization= Current Associates in Use - ( Current Utilization % / 100 * (Target Utilization % - Current Utilization %))

Current UTILIZATION (%)	27	30	Current Personnel in use
Target Utilization (%)	65	20	Target associates

Thanks for your help!

JM

 

[jkmcken]

Thanks for your review.

I am trying to figure out the correct formula for the Number of Employees needed based on a Target Utilization.

I have 30 Employees that have a overall Average Utilization of 54%

My Target Utilization is 65%

If the employees were working at a Utilization of 65% how many less Employees would I need?

Thanks,

JM

 

[Ishuda]

Thanks for your review.

I am trying to figure out the correct formula for the Number of Employees needed based on a Target Utilization.

I have 30 Employees that have a overall Average Utilization of 54%

My Target Utilization is 65%

If the employees were working at a Utilization of 65% how many less Employees would I need?

Thanks,

JM

One assumption is 'Full Utilization is 0.556' (or Employees / Utilization is constant). That is, employs have a higher utilization rate if there are more of them. A (very simple) example of this is we want to make say 16 widgets an hour and the process requires two steps where the transition time depends on the number of employees. The more employees the faster the tear down/build for the two different set ups need for the two processes. So
Employees = 0.556 * Utilization
So given a Utilization of 65%, the number of employees would actually be 36 and you would need to hire 6 more employees.

Other assumptions can be made and the answer depends on the assumption. For example you could assume that
Employees * Utilization = constant