Labour Budget Scenario Planner methodology

employeeBudgetExTax = Σ headcount × (annual base cost + annual on-cost) × active months ÷ 12

totalLabourBudgetExTax = employee budget + contractor budget + overtime budget

labourBudgetRate = total labour budget ÷ revenue budget

targetLabourBudgetExTax = revenue budget × target labour-cost rate

budgetGapExTax = total labour budget − target labour budget

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.

• The exact engine accepts 1 to 12 unique stable role IDs.
• Headcount is a non-negative whole number and active months remain between 0 and 12.
• Employee budget reconciles every role before contractor and overtime budgets are added.
• A zero revenue budget returns a nullable rate while the target budget remains calculable.

Role A headcount minimum

role1Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role A headcount maximum

role1Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role A annual base cost per person minimum

role1AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role A annual base cost per person maximum

role1AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role A annual on-cost per person minimum

role1AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role A annual on-cost per person maximum

role1AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role A active months minimum

role1ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role A active months maximum

role1ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role B headcount minimum

role2Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role B headcount maximum

role2Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role B annual base cost per person minimum

role2AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role B annual base cost per person maximum

role2AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role B annual on-cost per person minimum

role2AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role B annual on-cost per person maximum

role2AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role B active months minimum

role2ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role B active months maximum

role2ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 3 headcount minimum

role3Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 3 headcount maximum

role3Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 3 annual base cost per person minimum

role3AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 3 annual base cost per person maximum

role3AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 3 annual on-cost per person minimum

role3AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 3 annual on-cost per person maximum

role3AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 3 active months minimum

role3ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 3 active months maximum

role3ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 4 headcount minimum

role4Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 4 headcount maximum

role4Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 4 annual base cost per person minimum

role4AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 4 annual base cost per person maximum

role4AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 4 annual on-cost per person minimum

role4AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 4 annual on-cost per person maximum

role4AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 4 active months minimum

role4ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 4 active months maximum

role4ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 5 headcount minimum

role5Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 5 headcount maximum

role5Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 5 annual base cost per person minimum

role5AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 5 annual base cost per person maximum

role5AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 5 annual on-cost per person minimum

role5AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 5 annual on-cost per person maximum

role5AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 5 active months minimum

role5ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 5 active months maximum

role5ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 6 headcount minimum

role6Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 6 headcount maximum

role6Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 6 annual base cost per person minimum

role6AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 6 annual base cost per person maximum

role6AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 6 annual on-cost per person minimum

role6AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 6 annual on-cost per person maximum

role6AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 6 active months minimum

role6ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 6 active months maximum

role6ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 7 headcount minimum

role7Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 7 headcount maximum

role7Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 7 annual base cost per person minimum

role7AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 7 annual base cost per person maximum

role7AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 7 annual on-cost per person minimum

role7AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 7 annual on-cost per person maximum

role7AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 7 active months minimum

role7ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 7 active months maximum

role7ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 8 headcount minimum

role8Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 8 headcount maximum

role8Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 8 annual base cost per person minimum

role8AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 8 annual base cost per person maximum

role8AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 8 annual on-cost per person minimum

role8AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 8 annual on-cost per person maximum

role8AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 8 active months minimum

role8ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 8 active months maximum

role8ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 9 headcount minimum

role9Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 9 headcount maximum

role9Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 9 annual base cost per person minimum

role9AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 9 annual base cost per person maximum

role9AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 9 annual on-cost per person minimum

role9AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 9 annual on-cost per person maximum

role9AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 9 active months minimum

role9ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 9 active months maximum

role9ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 10 headcount minimum

role10Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 10 headcount maximum

role10Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 10 annual base cost per person minimum

role10AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 10 annual base cost per person maximum

role10AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 10 annual on-cost per person minimum

role10AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 10 annual on-cost per person maximum

role10AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 10 active months minimum

role10ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 10 active months maximum

role10ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 11 headcount minimum

role11Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 11 headcount maximum

role11Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 11 annual base cost per person minimum

role11AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 11 annual base cost per person maximum

role11AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 11 annual on-cost per person minimum

role11AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 11 annual on-cost per person maximum

role11AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 11 active months minimum

role11ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 11 active months maximum

role11ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Role 12 headcount minimum

role12Headcount ≥ 0 whole people/role — A lower value is rejected before calculation.

Role 12 headcount maximum

role12Headcount ≤ 100,000 whole people/role — A higher value is rejected before calculation.

Role 12 annual base cost per person minimum

role12AnnualBaseCostPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 12 annual base cost per person maximum

role12AnnualBaseCostPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 12 annual on-cost per person minimum

role12AnnualOnCostsPerPersonExTax ≥ 0 currency units/person/year, ex tax — A lower value is rejected before calculation.

Role 12 annual on-cost per person maximum

role12AnnualOnCostsPerPersonExTax ≤ 10,000,000 currency units/person/year, ex tax — A higher value is rejected before calculation.

Role 12 active months minimum

role12ActiveMonths ≥ 0 whole months/12-month budget — A lower value is rejected before calculation.

Role 12 active months maximum

role12ActiveMonths ≤ 12 whole months/12-month budget — A higher value is rejected before calculation.

Contractor budget minimum

contractorBudgetExTax ≥ 0 currency units/12-month budget, ex tax — A lower value is rejected before calculation.

Contractor budget maximum

contractorBudgetExTax ≤ 10,000,000 currency units/12-month budget, ex tax — A higher value is rejected before calculation.

Overtime budget minimum

overtimeBudgetExTax ≥ 0 currency units/12-month budget, ex tax — A lower value is rejected before calculation.

Overtime budget maximum

overtimeBudgetExTax ≤ 10,000,000 currency units/12-month budget, ex tax — A higher value is rejected before calculation.

Revenue budget minimum

revenueBudgetExTax ≥ 0 currency units/12-month budget, ex tax — A lower value is rejected before calculation.

Revenue budget maximum

revenueBudgetExTax ≤ 10,000,000 currency units/12-month budget, ex tax — A higher value is rejected before calculation.

Target labour-cost rate minimum

targetLabourCostRate ≥ 0 decimal fraction of ex-tax revenue budget (1 = 100%) — A lower value is rejected before calculation.

Target labour-cost rate maximum

targetLabourCostRate ≤ 1 decimal fraction of ex-tax revenue budget (1 = 100%) — A higher value is rejected before calculation.

• Each role is prorated by its entered active months in a 12-month planning horizon.
• On-cost, contractor, overtime, revenue and target values are all user-owned inputs.
• A component table is used; no chart adds decision value for the role-budget reconciliation.

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.

• The planner does not calculate statutory on-costs, award entitlements or worker classification.
• It does not replace accounting, payroll, employment, tax or legal 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.

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.

1. 2026-07-16: Initial public release of the Labour Budget Scenario planner and methodology.