Skip to main content

Methodology

Staffing Cost Percentage Planner methodology

Reconcile wages, employer on-costs and contractor cost against revenue and a user-entered staffing-cost target.

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

Total staffing cost
totalStaffingCostExTax = wages + employer on-costs + contractor cost

Where

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
Staffing cost rate
staffingCostRate = total staffing cost รท revenue

Where

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
Target staffing cost
targetStaffingCostExTax = revenue ร— target rate

Where

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
Cost gap to target
costGapExTax = total staffing cost โˆ’ target staffing cost

Where

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

  1. 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

  2. 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

  3. 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

  4. 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

  1. : Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.

Guides to interpret the decision and its assumptions.

Return to the planner