Methodology
Staffing Cost Percentage Planner methodology
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: Calculations run locally; Margin101 does not receive your commercial inputs.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
1. Formulas and units
totalStaffingCostExTax = wages + employer on-costs + contractor costWhere
- wagesExTax
- Wages (currency units on one consistent ex-tax basis)Source: Business record
- employerOnCostsExTax
- Employer on-costs (currency units on one consistent ex-tax basis)Source: Business record
- contractorCostExTax
- Contractor cost (currency units on one consistent ex-tax basis)Source: Business record
- totalStaffingCostExTax
- Total staffing cost (money)Source: Calculated output
staffingCostRate = total staffing cost รท revenueWhere
- revenueExTax
- Ex-tax revenue (currency units on one consistent ex-tax basis)Source: Business record
- totalStaffingCostExTax
- Total staffing cost (money)Source: Calculated output
- staffingCostRate
- Staffing cost rate (percent)Source: Calculated output
targetStaffingCostExTax = revenue ร target rateWhere
- revenueExTax
- Ex-tax revenue (currency units on one consistent ex-tax basis)Source: Business record
- targetStaffingCostRate
- Target staffing-cost rate (decimal rate)Source: User decision
- totalStaffingCostExTax
- Total staffing cost (money)Source: Calculated output
- staffingCostRate
- Staffing cost rate (percent)Source: Calculated output
- targetStaffingCostExTax
- Target staffing cost (money)Source: Calculated output
costGapExTax = total staffing cost โ target staffing costWhere
- totalStaffingCostExTax
- Total staffing cost (money)Source: Calculated output
- targetStaffingCostExTax
- Target staffing cost (money)Source: Calculated output
- costGapExTax
- Cost gap to target (money)Source: Calculated output
Money inputs and outputs use the currency selected in the scenario without changing the canonical methodology. Rates, margins, utilisation and buffers are entered as percentages and converted to decimal values for calculation.
2. Worked example
Input assumptions
The worked values below come from the exact engine and the visible default assumptions.
- Ex-tax revenue
- 1,000,000 currency units/reporting period, ex tax
- Wages
- 300,000 currency units/reporting period, ex tax
- Employer on-costs
- 60,000 currency units/reporting period, ex tax
- Contractor cost
- 40,000 currency units/reporting period, ex tax
- Target staffing-cost rate
- 0.35 decimal fraction of ex-tax revenue (1 = 100%)
Calculation and outputs
Total staffing cost
totalStaffingCostExTax = wages + employer on-costs + contractor cost- Wages
- 300,000 currency units/reporting period, ex tax
- Employer on-costs
- 60,000 currency units/reporting period, ex tax
- Contractor cost
- 40,000 currency units/reporting period, ex tax
- Target staffing-cost rate
- 0.35 decimal fraction of ex-tax revenue (1 = 100%)
- Staffing cost rate
- 0.4 percent
- Target staffing cost
- 350,000 money
- Cost gap to target
- 50,000 money
Engine result: 400,000 money
Staffing cost rate
staffingCostRate = total staffing cost รท revenue- Ex-tax revenue
- 1,000,000 currency units/reporting period, ex tax
- Contractor cost
- 40,000 currency units/reporting period, ex tax
- Target staffing-cost rate
- 0.35 decimal fraction of ex-tax revenue (1 = 100%)
- Total staffing cost
- 400,000 money
- Target staffing cost
- 350,000 money
- Cost gap to target
- 50,000 money
Engine result: 0.4 percent
Target staffing cost
targetStaffingCostExTax = revenue ร target rate- Ex-tax revenue
- 1,000,000 currency units/reporting period, ex tax
- Target staffing-cost rate
- 0.35 decimal fraction of ex-tax revenue (1 = 100%)
- Staffing cost rate
- 0.4 percent
- Cost gap to target
- 50,000 money
Engine result: 350,000 money
Cost gap to target
costGapExTax = total staffing cost โ target staffing cost- Contractor cost
- 40,000 currency units/reporting period, ex tax
- Target staffing-cost rate
- 0.35 decimal fraction of ex-tax revenue (1 = 100%)
- Total staffing cost
- 400,000 money
- Staffing cost rate
- 0.4 percent
- Target staffing cost
- 350,000 money
Engine result: 50,000 money
Example
The worked values below come from the exact engine and the visible default assumptions.
- Total staffing cost
- 400,000.00 currency units
- Staffing cost rate
- 40%
- Target staffing cost
- 350,000.00 currency units
- Cost gap to target
- 50,000.00 currency units
The exact engine-derived outputs are shown in the labelled rows below.
Interpretation
The signed gap shows how the entered staffing-cost definition compares with your chosen target.
3. Validation and boundary checks
- Revenue must be positive and the target rate must remain between 0% and 100%.
- Total cost equals the exact wages, on-cost and contractor sum.
- The signed gap equals actual total less target cost.
- Ex-tax revenue minimum
revenueExTax โฅ 0 currency units/reporting period, ex taxโ A lower value is rejected before calculation.- Ex-tax revenue maximum
revenueExTax โค 10,000,000 currency units/reporting period, ex taxโ A higher value is rejected before calculation.- Wages minimum
wagesExTax โฅ 0 currency units/reporting period, ex taxโ A lower value is rejected before calculation.- Wages maximum
wagesExTax โค 10,000,000 currency units/reporting period, ex taxโ A higher value is rejected before calculation.- Employer on-costs minimum
employerOnCostsExTax โฅ 0 currency units/reporting period, ex taxโ A lower value is rejected before calculation.- Employer on-costs maximum
employerOnCostsExTax โค 10,000,000 currency units/reporting period, ex taxโ A higher value is rejected before calculation.- Contractor cost minimum
contractorCostExTax โฅ 0 currency units/reporting period, ex taxโ A lower value is rejected before calculation.- Contractor cost maximum
contractorCostExTax โค 10,000,000 currency units/reporting period, ex taxโ A higher value is rejected before calculation.- Target staffing-cost rate minimum
targetStaffingCostRate โฅ 0 decimal fraction of ex-tax revenue (1 = 100%)โ A lower value is rejected before calculation.- Target staffing-cost rate maximum
targetStaffingCostRate โค 1 decimal fraction of ex-tax revenue (1 = 100%)โ A higher value is rejected before calculation.
4. Assumptions and source classification
- Cost classification and target share are user decisions.
- Wages, on-costs and contractors use the same reporting period as revenue.
- The hospitality module is a labelled scenario of this owner, not a separate benchmark or methodology.
This planner has no current policy-data dependency. Its commercial assumptions are user supplied. Registered family-level regression suites exercise the shared business-logic engine and worked-result reconciliation.
5. Limitations
- No productivity, wage, loading, on-cost or staffing benchmark is embedded.
- The model does not interpret awards, classify workers or establish compliance.
- It is educational decision support, not accounting, tax, legal or employment advice.
This is educational decision support, not tax, accounting, legal or financial advice. Check the treatment of your actual transactions under the rules that apply to your business and seek qualified advice where appropriate.
6. Update and evidence policy
Registered family-level suites test formula invariants and example reconciliation; the release ledger records that coverage without claiming a separate oracle for every line of public copy. There is no official threshold or benchmark to refresh for this planner. Commercial inputs remain user-supplied because they vary by business and contract.
Change history
- : Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.
Related reading
Guides to interpret the decision and its assumptions.
- Staffing Cost Percentage Explained for Small Teams
Build a consistent staffing-cost numerator and revenue denominator before comparing periods or scenarios.
Read guide