Workforce Ratios
Calculate using the labelled inputs: Workforce Ratios.
Enter a finite value within the formula’s domain and supported numeric range.
Use the same period and currency throughout. FTE hour presets 30/40 are examples, not legal eligibility rules. The 20.38% employer surcharge reproduces an archived example; enter the rate that applies to your calculation. Annual cost assumes 12 identical months. The revenue threshold defaults to the source’s arbitrary 2× cost; it is adjustable and is not the accounting break-even point. Production reproduces source formulas: availability=(shift minutes−downtime)/shift minutes, performance=actual/nominal, quality=1−defect%, OEE=their product. Output=actual rate×scheduled hours, with no extra downtime deduction. Output must be a whole count; defective units round half up. Nominal zero leaves performance/OEE undefined. This is a source estimate, not a certified production metric.
Calculation and assumptions
average=(start+end)/2; turnover=100·leavers/average; FTE=hours/standard; productivity=units/hours.
Use one period throughout. The two-point mean approximates staffing; it is not a daily average. Turnover can exceed 100%. Enter your own full-time hours; no statutory hours or payroll rules are supplied. A dash means the corresponding ratio is undefined because its denominator is zero.
Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.
Use the same period and currency throughout. FTE hour presets 30/40 are examples, not legal eligibility rules. The 20.38% employer surcharge reproduces an archived example; enter the rate that applies to your calculation. Annual cost assumes 12 identical months. The revenue threshold defaults to the source’s arbitrary 2× cost; it is adjustable and is not the accounting break-even point. Production reproduces source formulas: availability=(shift minutes−downtime)/shift minutes, performance=actual/nominal, quality=1−defect%, OEE=their product. Output=actual rate×scheduled hours, with no extra downtime deduction. Output must be a whole count; defective units round half up. Nominal zero leaves performance/OEE undefined. This is a source estimate, not a certified production metric.
Frequently asked questions
How is the result calculated?
average=(start+end)/2; turnover=100·leavers/average; FTE=hours/standard; productivity=units/hours.
What assumptions apply?
Use one period throughout. The two-point mean approximates staffing; it is not a daily average. Turnover can exceed 100%. Enter your own full-time hours; no statutory hours or payroll rules are supplied. A dash means the corresponding ratio is undefined because its denominator is zero.
How precise are the results?
Results show up to ten significant digits. Display precision does not improve the accuracy of the measurements or model. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.