Average Attrition Rate

[mdalby]

Our company attrition rate calculation = Attrits / Average Headcount.

I want to use the same calculation for any set of agents, whether the agents are in classroom trianing or production. The problem is that the training group needs to back into the number of agents that need to start a training class.

For example. If you have a class that starts with 25 and ends with 20 there is a 20% fallout but due to average headcount in the calculation the attrition rate is 22.1%.

How can I have a formula that backs into the 25 that I would need to start in classroom training? I would like to use the 20 that end training and the 22.1% attrition rate in the formula if possible. I would like to keep using the agerage headcount in the attrition rate if possible.

I have attached a file.

Thank you for your help.

MD