Shift Coverage Cost Planner methodology

scheduledCoverageHours = sum(workers × hours per worker)

totalShiftCostExTax = sum(each exact shift cost)

costPerCoverageHourExTax = total shift cost ÷ scheduled hours

uncoveredHours = max(0, required hours − scheduled hours)

excessHours = max(0, scheduled hours − required hours)

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.

• One to 12 active shift rows are accepted; IDs are generated and unique.
• Worker counts are whole numbers; loading is bounded at 200% and on-cost at 100%.
• Scheduled hours and exact shift costs reconcile before uncovered or excess hours are calculated.
• Zero scheduled hours returns an explicit unreachable unit cost.

Required coverage hours minimum

requiredCoverageHours ≥ 0 coverage hours/selected staffing period — A lower value is rejected before calculation.

Required coverage hours maximum

requiredCoverageHours ≤ 100,000,000 coverage hours/selected staffing period — A higher value is rejected before calculation.

Employer on-cost rate minimum

employerOnCostRate ≥ 0 decimal fraction of loaded shift wages before employer on-cost (1 = 100%) — A lower value is rejected before calculation.

Employer on-cost rate maximum

employerOnCostRate ≤ 1 decimal fraction of loaded shift wages before employer on-cost (1 = 100%) — A higher value is rejected before calculation.

Shift 1 workers minimum

shift1Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 1 workers maximum

shift1Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 1 hours per worker minimum

shift1HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 1 hours per worker maximum

shift1HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 1 base hourly rate minimum

shift1BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 1 base hourly rate maximum

shift1BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 1 loading minimum

shift1LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 1 loading maximum

shift1LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 2 workers minimum

shift2Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 2 workers maximum

shift2Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 2 hours per worker minimum

shift2HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 2 hours per worker maximum

shift2HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 2 base hourly rate minimum

shift2BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 2 base hourly rate maximum

shift2BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 2 loading minimum

shift2LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 2 loading maximum

shift2LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 3 workers minimum

shift3Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 3 workers maximum

shift3Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 3 hours per worker minimum

shift3HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 3 hours per worker maximum

shift3HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 3 base hourly rate minimum

shift3BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 3 base hourly rate maximum

shift3BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 3 loading minimum

shift3LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 3 loading maximum

shift3LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 4 workers minimum

shift4Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 4 workers maximum

shift4Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 4 hours per worker minimum

shift4HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 4 hours per worker maximum

shift4HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 4 base hourly rate minimum

shift4BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 4 base hourly rate maximum

shift4BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 4 loading minimum

shift4LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 4 loading maximum

shift4LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 5 workers minimum

shift5Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 5 workers maximum

shift5Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 5 hours per worker minimum

shift5HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 5 hours per worker maximum

shift5HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 5 base hourly rate minimum

shift5BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 5 base hourly rate maximum

shift5BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 5 loading minimum

shift5LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 5 loading maximum

shift5LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 6 workers minimum

shift6Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 6 workers maximum

shift6Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 6 hours per worker minimum

shift6HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 6 hours per worker maximum

shift6HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 6 base hourly rate minimum

shift6BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 6 base hourly rate maximum

shift6BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 6 loading minimum

shift6LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 6 loading maximum

shift6LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 7 workers minimum

shift7Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 7 workers maximum

shift7Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 7 hours per worker minimum

shift7HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 7 hours per worker maximum

shift7HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 7 base hourly rate minimum

shift7BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 7 base hourly rate maximum

shift7BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 7 loading minimum

shift7LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 7 loading maximum

shift7LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 8 workers minimum

shift8Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 8 workers maximum

shift8Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 8 hours per worker minimum

shift8HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 8 hours per worker maximum

shift8HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 8 base hourly rate minimum

shift8BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 8 base hourly rate maximum

shift8BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 8 loading minimum

shift8LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 8 loading maximum

shift8LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 9 workers minimum

shift9Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 9 workers maximum

shift9Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 9 hours per worker minimum

shift9HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 9 hours per worker maximum

shift9HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 9 base hourly rate minimum

shift9BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 9 base hourly rate maximum

shift9BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 9 loading minimum

shift9LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 9 loading maximum

shift9LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 10 workers minimum

shift10Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 10 workers maximum

shift10Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 10 hours per worker minimum

shift10HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 10 hours per worker maximum

shift10HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 10 base hourly rate minimum

shift10BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 10 base hourly rate maximum

shift10BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 10 loading minimum

shift10LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 10 loading maximum

shift10LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 11 workers minimum

shift11Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 11 workers maximum

shift11Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 11 hours per worker minimum

shift11HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 11 hours per worker maximum

shift11HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 11 base hourly rate minimum

shift11BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 11 base hourly rate maximum

shift11BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 11 loading minimum

shift11LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 11 loading maximum

shift11LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

Shift 12 workers minimum

shift12Workers ≥ 0 whole workers/shift slot — A lower value is rejected before calculation.

Shift 12 workers maximum

shift12Workers ≤ 100,000 whole workers/shift slot — A higher value is rejected before calculation.

Shift 12 hours per worker minimum

shift12HoursPerWorker ≥ 0 paid hours/worker/shift — A lower value is rejected before calculation.

Shift 12 hours per worker maximum

shift12HoursPerWorker ≤ 100,000,000 paid hours/worker/shift — A higher value is rejected before calculation.

Shift 12 base hourly rate minimum

shift12BaseHourlyRate ≥ 0 currency units/worker-hour, ex tax — A lower value is rejected before calculation.

Shift 12 base hourly rate maximum

shift12BaseHourlyRate ≤ 10,000,000 currency units/worker-hour, ex tax — A higher value is rejected before calculation.

Shift 12 loading minimum

shift12LoadingRate ≥ 0 decimal fraction of base hourly cost (1 = 100%) — A lower value is rejected before calculation.

Shift 12 loading maximum

shift12LoadingRate ≤ 2 decimal fraction of base hourly cost (1 = 100%) — A higher value is rejected before calculation.

• Each active slot represents one entered shift pattern.
• Rates, loadings and on-costs are entered by the user and are not jurisdiction defaults.

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.

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

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-31: Initial public release of the planner and methodology after pre-launch calculation, content, source and interaction review.