Workforce Planning Simulation

Serviceman Capacity and Capability Distribution

MODE:

Assumptions

Working Days / Year ✏️

Hours per Day ✏️

Internal Job (%) ✏️

Internal/ Non Revenue Job. eg. Warranty.

Target STUR (Utilization)

85%

Rate (USD / Hour) ✏️

Effective Hours/FTE

Rev Cap / FTE

Service Revenue Budget

Est. Revenue (By Actual MP)

Actual Manpower

Net Gap (FTE)

Input Your Actual Budget/Manpower/Serviceman Ratio%.

Upload Excel

Business Unit ✏️	Revenue ($)	Hist. STUR ✏️ Ref	Current Actual Manpower ✏️					Serviceman Ratio (%) ✏️			Ideal Required FTE				Gap
Business Unit ✏️	Revenue ($)	Hist. STUR ✏️ Ref	Mech	Tech	STech	Total	Est. Rev ($)	%Mech	%Tech	%STech	Mech	Tech	Stech	Total	Gap