Im looking to create a simple capacity plan for a team but crucially it has to consider skill level or length of service.
Most capacity plans give you if volume is x then you need x people but what i need is a simple way of showing that if volume is x headcount is x but that assumes they are skilled
For example
Employee 1 length of service 2 years
Employee 2 length of service 3 years
Employee 3 length of service 0
If i have 10 x employee 1 then my capacity is easy but 1/2 leave so i have 5 x employee 1 how many employee 3 would i need for it to be equal
It sound simple in my head but i can't seem to get into excel
Any ideas or examples?
Most capacity plans give you if volume is x then you need x people but what i need is a simple way of showing that if volume is x headcount is x but that assumes they are skilled
For example
Employee 1 length of service 2 years
Employee 2 length of service 3 years
Employee 3 length of service 0
If i have 10 x employee 1 then my capacity is easy but 1/2 leave so i have 5 x employee 1 how many employee 3 would i need for it to be equal
It sound simple in my head but i can't seem to get into excel
Any ideas or examples?