Act on the result
Resolve uncovered hours and confirm every entered loading and on-cost before selecting a shift pattern.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Operators reconciling a bounded shift pattern with required coverage hours and entered cost loadings.
Outputs
Scheduled hours, exact shift cost, unit cost, uncovered hours and excess hours.
Start here
Enter required hours and activate up to 12 shift slots using your own base rates, loadings and on-cost.
Use a different tool when: Do not use this to compare staffing cost with a user-entered share-of-revenue target; use Staffing Cost Percentage Planner for that decision. Use this tool to choose a shift pattern that covers required hours with explicit entered loadings.
Profit & break-even
Shift Coverage Cost: scheduled hours
Scheduled hours, exact shift cost, unit cost, uncovered hours and excess hours.
Amounts use the same currency as your inputs. No currency conversion is performed.
Coverage and shift assumptions
Use your own records on one consistent currency, ex-tax and reporting-period basis.
Your numbers stay in this browser
Hours the selected staffing pattern needs to cover.
User-entered rate; no jurisdiction or statutory default is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
Up to 12 shift slotsOpen the assumptions you are less likely to change on every comparison.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Whole workers assigned to this shift slot.
Paid hours for each worker in this shift.
User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis.
User-entered loading; no award or statutory rate is inferred.
Decision result
Exact engine outputs; no benchmark or statutory default is inserted.
- Scheduled coverage hours
- 24 hours
- Total shift cost
- 1,300.00
- Cost per scheduled hour
- 54.17
- Uncovered hours
- 6 hours
- Excess hours
- 0 hours
| Shift | Workers | Hours each | Base rate | Loading | Scheduled hours | Exact cost |
|---|---|---|---|---|---|---|
| Shift 1 | 2 | 8 | 40.00 | 0% | 16 | 800.00 |
| Shift 2 | 1 | 8 | 40.00 | 25% | 8 | 500.00 |
| Engine total | 24 | 1,300.00 | ||||
Empty slots are ignored. Active slots receive generated IDs; the exact engine rejects more than 12 rows.
Scenario comparison
Each row names the assumption axis changed from the baseline.
ScenarioResultDifference
Entered scenario1,300.00Baseline
Lower Required coverage hours1,300.000.00
Higher Required coverage hours1,300.000.00
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Scheduled coverage hours
Scheduled coverage hours
sum(workers × hours per worker)24 hoursResult24 hours
Reports hours for the entered staffing period using the declared pay, on-cost, capacity and ex-tax revenue basis. The exact engine retains raw precision; display formatting never feeds calculation.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Scheduled coverage hoursRequired Coverage Hours
- 30
- Scheduled coverage hoursEmployer On Cost Rate
- 0.25
- Scheduled coverage hoursShift1 Workers
- 2
- Scheduled coverage hoursShift1 Hours Per Worker
- 8
- Scheduled coverage hoursShift1 Base Hourly Rate
- 40
- Scheduled coverage hoursShift1 Loading Rate
- 0
- Scheduled coverage hoursShift2 Workers
- 1
- Scheduled coverage hoursShift2 Hours Per Worker
- 8
- Scheduled coverage hoursShift2 Base Hourly Rate
- 40
- Scheduled coverage hoursShift2 Loading Rate
- 0.25
- Scheduled coverage hoursShift3 Workers
- 0
- Scheduled coverage hoursShift3 Hours Per Worker
- 0
- Scheduled coverage hoursShift3 Base Hourly Rate
- 0
- Scheduled coverage hoursShift3 Loading Rate
- 0
- Scheduled coverage hoursShift4 Workers
- 0
- Scheduled coverage hoursShift4 Hours Per Worker
- 0
- Scheduled coverage hoursShift4 Base Hourly Rate
- 0
- Scheduled coverage hoursShift4 Loading Rate
- 0
- Scheduled coverage hoursShift5 Workers
- 0
- Scheduled coverage hoursShift5 Hours Per Worker
- 0
- Scheduled coverage hoursShift5 Base Hourly Rate
- 0
- Scheduled coverage hoursShift5 Loading Rate
- 0
- Scheduled coverage hoursShift6 Workers
- 0
- Scheduled coverage hoursShift6 Hours Per Worker
- 0
- Scheduled coverage hoursShift6 Base Hourly Rate
- 0
- Scheduled coverage hoursShift6 Loading Rate
- 0
- Scheduled coverage hoursShift7 Workers
- 0
- Scheduled coverage hoursShift7 Hours Per Worker
- 0
- Scheduled coverage hoursShift7 Base Hourly Rate
- 0
- Scheduled coverage hoursShift7 Loading Rate
- 0
- Scheduled coverage hoursShift8 Workers
- 0
- Scheduled coverage hoursShift8 Hours Per Worker
- 0
- Scheduled coverage hoursShift8 Base Hourly Rate
- 0
- Scheduled coverage hoursShift8 Loading Rate
- 0
- Scheduled coverage hoursShift9 Workers
- 0
- Scheduled coverage hoursShift9 Hours Per Worker
- 0
- Scheduled coverage hoursShift9 Base Hourly Rate
- 0
- Scheduled coverage hoursShift9 Loading Rate
- 0
- Scheduled coverage hoursShift10 Workers
- 0
- Scheduled coverage hoursShift10 Hours Per Worker
- 0
- Scheduled coverage hoursShift10 Base Hourly Rate
- 0
- Scheduled coverage hoursShift10 Loading Rate
- 0
- Scheduled coverage hoursShift11 Workers
- 0
- Scheduled coverage hoursShift11 Hours Per Worker
- 0
- Scheduled coverage hoursShift11 Base Hourly Rate
- 0
- Scheduled coverage hoursShift11 Loading Rate
- 0
- Scheduled coverage hoursShift12 Workers
- 0
- Scheduled coverage hoursShift12 Hours Per Worker
- 0
- Scheduled coverage hoursShift12 Base Hourly Rate
- 0
- Scheduled coverage hoursShift12 Loading Rate
- 0
Total shift cost
Total shift cost
sum(each exact shift cost)1,300.00Result1,300.00
Reports money for the entered staffing period using the declared pay, on-cost, capacity and ex-tax revenue basis. The exact engine retains raw precision; display formatting never feeds calculation.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Total shift costRequired Coverage Hours
- 30
- Total shift costEmployer On Cost Rate
- 0.25
- Total shift costShift1 Workers
- 2
- Total shift costShift1 Hours Per Worker
- 8
- Total shift costShift1 Base Hourly Rate
- 40
- Total shift costShift1 Loading Rate
- 0
- Total shift costShift2 Workers
- 1
- Total shift costShift2 Hours Per Worker
- 8
- Total shift costShift2 Base Hourly Rate
- 40
- Total shift costShift2 Loading Rate
- 0.25
- Total shift costShift3 Workers
- 0
- Total shift costShift3 Hours Per Worker
- 0
- Total shift costShift3 Base Hourly Rate
- 0
- Total shift costShift3 Loading Rate
- 0
- Total shift costShift4 Workers
- 0
- Total shift costShift4 Hours Per Worker
- 0
- Total shift costShift4 Base Hourly Rate
- 0
- Total shift costShift4 Loading Rate
- 0
- Total shift costShift5 Workers
- 0
- Total shift costShift5 Hours Per Worker
- 0
- Total shift costShift5 Base Hourly Rate
- 0
- Total shift costShift5 Loading Rate
- 0
- Total shift costShift6 Workers
- 0
- Total shift costShift6 Hours Per Worker
- 0
- Total shift costShift6 Base Hourly Rate
- 0
- Total shift costShift6 Loading Rate
- 0
- Total shift costShift7 Workers
- 0
- Total shift costShift7 Hours Per Worker
- 0
- Total shift costShift7 Base Hourly Rate
- 0
- Total shift costShift7 Loading Rate
- 0
- Total shift costShift8 Workers
- 0
- Total shift costShift8 Hours Per Worker
- 0
- Total shift costShift8 Base Hourly Rate
- 0
- Total shift costShift8 Loading Rate
- 0
- Total shift costShift9 Workers
- 0
- Total shift costShift9 Hours Per Worker
- 0
- Total shift costShift9 Base Hourly Rate
- 0
- Total shift costShift9 Loading Rate
- 0
- Total shift costShift10 Workers
- 0
- Total shift costShift10 Hours Per Worker
- 0
- Total shift costShift10 Base Hourly Rate
- 0
- Total shift costShift10 Loading Rate
- 0
- Total shift costShift11 Workers
- 0
- Total shift costShift11 Hours Per Worker
- 0
- Total shift costShift11 Base Hourly Rate
- 0
- Total shift costShift11 Loading Rate
- 0
- Total shift costShift12 Workers
- 0
- Total shift costShift12 Hours Per Worker
- 0
- Total shift costShift12 Base Hourly Rate
- 0
- Total shift costShift12 Loading Rate
- 0
Cost per scheduled hour
Cost per scheduled hour
total shift cost ÷ scheduled hours54.17Result54.17
Reports money for the entered staffing period using the declared pay, on-cost, capacity and ex-tax revenue basis. The exact engine retains raw precision; display formatting never feeds calculation.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Cost per scheduled hourRequired Coverage Hours
- 30
- Cost per scheduled hourEmployer On Cost Rate
- 0.25
- Cost per scheduled hourShift1 Workers
- 2
- Cost per scheduled hourShift1 Hours Per Worker
- 8
- Cost per scheduled hourShift1 Base Hourly Rate
- 40
- Cost per scheduled hourShift1 Loading Rate
- 0
- Cost per scheduled hourShift2 Workers
- 1
- Cost per scheduled hourShift2 Hours Per Worker
- 8
- Cost per scheduled hourShift2 Base Hourly Rate
- 40
- Cost per scheduled hourShift2 Loading Rate
- 0.25
- Cost per scheduled hourShift3 Workers
- 0
- Cost per scheduled hourShift3 Hours Per Worker
- 0
- Cost per scheduled hourShift3 Base Hourly Rate
- 0
- Cost per scheduled hourShift3 Loading Rate
- 0
- Cost per scheduled hourShift4 Workers
- 0
- Cost per scheduled hourShift4 Hours Per Worker
- 0
- Cost per scheduled hourShift4 Base Hourly Rate
- 0
- Cost per scheduled hourShift4 Loading Rate
- 0
- Cost per scheduled hourShift5 Workers
- 0
- Cost per scheduled hourShift5 Hours Per Worker
- 0
- Cost per scheduled hourShift5 Base Hourly Rate
- 0
- Cost per scheduled hourShift5 Loading Rate
- 0
- Cost per scheduled hourShift6 Workers
- 0
- Cost per scheduled hourShift6 Hours Per Worker
- 0
- Cost per scheduled hourShift6 Base Hourly Rate
- 0
- Cost per scheduled hourShift6 Loading Rate
- 0
- Cost per scheduled hourShift7 Workers
- 0
- Cost per scheduled hourShift7 Hours Per Worker
- 0
- Cost per scheduled hourShift7 Base Hourly Rate
- 0
- Cost per scheduled hourShift7 Loading Rate
- 0
- Cost per scheduled hourShift8 Workers
- 0
- Cost per scheduled hourShift8 Hours Per Worker
- 0
- Cost per scheduled hourShift8 Base Hourly Rate
- 0
- Cost per scheduled hourShift8 Loading Rate
- 0
- Cost per scheduled hourShift9 Workers
- 0
- Cost per scheduled hourShift9 Hours Per Worker
- 0
- Cost per scheduled hourShift9 Base Hourly Rate
- 0
- Cost per scheduled hourShift9 Loading Rate
- 0
- Cost per scheduled hourShift10 Workers
- 0
- Cost per scheduled hourShift10 Hours Per Worker
- 0
- Cost per scheduled hourShift10 Base Hourly Rate
- 0
- Cost per scheduled hourShift10 Loading Rate
- 0
- Cost per scheduled hourShift11 Workers
- 0
- Cost per scheduled hourShift11 Hours Per Worker
- 0
- Cost per scheduled hourShift11 Base Hourly Rate
- 0
- Cost per scheduled hourShift11 Loading Rate
- 0
- Cost per scheduled hourShift12 Workers
- 0
- Cost per scheduled hourShift12 Hours Per Worker
- 0
- Cost per scheduled hourShift12 Base Hourly Rate
- 0
- Cost per scheduled hourShift12 Loading Rate
- 0
Uncovered hours
Uncovered hours
max(0, required hours − scheduled hours)6 hoursResult6 hours
Reports hours for the entered staffing period using the declared pay, on-cost, capacity and ex-tax revenue basis. The exact engine retains raw precision; display formatting never feeds calculation.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Uncovered hoursRequired Coverage Hours
- 30
- Uncovered hoursEmployer On Cost Rate
- 0.25
- Uncovered hoursShift1 Workers
- 2
- Uncovered hoursShift1 Hours Per Worker
- 8
- Uncovered hoursShift1 Base Hourly Rate
- 40
- Uncovered hoursShift1 Loading Rate
- 0
- Uncovered hoursShift2 Workers
- 1
- Uncovered hoursShift2 Hours Per Worker
- 8
- Uncovered hoursShift2 Base Hourly Rate
- 40
- Uncovered hoursShift2 Loading Rate
- 0.25
- Uncovered hoursShift3 Workers
- 0
- Uncovered hoursShift3 Hours Per Worker
- 0
- Uncovered hoursShift3 Base Hourly Rate
- 0
- Uncovered hoursShift3 Loading Rate
- 0
- Uncovered hoursShift4 Workers
- 0
- Uncovered hoursShift4 Hours Per Worker
- 0
- Uncovered hoursShift4 Base Hourly Rate
- 0
- Uncovered hoursShift4 Loading Rate
- 0
- Uncovered hoursShift5 Workers
- 0
- Uncovered hoursShift5 Hours Per Worker
- 0
- Uncovered hoursShift5 Base Hourly Rate
- 0
- Uncovered hoursShift5 Loading Rate
- 0
- Uncovered hoursShift6 Workers
- 0
- Uncovered hoursShift6 Hours Per Worker
- 0
- Uncovered hoursShift6 Base Hourly Rate
- 0
- Uncovered hoursShift6 Loading Rate
- 0
- Uncovered hoursShift7 Workers
- 0
- Uncovered hoursShift7 Hours Per Worker
- 0
- Uncovered hoursShift7 Base Hourly Rate
- 0
- Uncovered hoursShift7 Loading Rate
- 0
- Uncovered hoursShift8 Workers
- 0
- Uncovered hoursShift8 Hours Per Worker
- 0
- Uncovered hoursShift8 Base Hourly Rate
- 0
- Uncovered hoursShift8 Loading Rate
- 0
- Uncovered hoursShift9 Workers
- 0
- Uncovered hoursShift9 Hours Per Worker
- 0
- Uncovered hoursShift9 Base Hourly Rate
- 0
- Uncovered hoursShift9 Loading Rate
- 0
- Uncovered hoursShift10 Workers
- 0
- Uncovered hoursShift10 Hours Per Worker
- 0
- Uncovered hoursShift10 Base Hourly Rate
- 0
- Uncovered hoursShift10 Loading Rate
- 0
- Uncovered hoursShift11 Workers
- 0
- Uncovered hoursShift11 Hours Per Worker
- 0
- Uncovered hoursShift11 Base Hourly Rate
- 0
- Uncovered hoursShift11 Loading Rate
- 0
- Uncovered hoursShift12 Workers
- 0
- Uncovered hoursShift12 Hours Per Worker
- 0
- Uncovered hoursShift12 Base Hourly Rate
- 0
- Uncovered hoursShift12 Loading Rate
- 0
Excess hours
Excess hours
max(0, scheduled hours − required hours)0 hoursResult0 hours
Reports hours for the entered staffing period using the declared pay, on-cost, capacity and ex-tax revenue basis. The exact engine retains raw precision; display formatting never feeds calculation.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Excess hoursRequired Coverage Hours
- 30
- Excess hoursEmployer On Cost Rate
- 0.25
- Excess hoursShift1 Workers
- 2
- Excess hoursShift1 Hours Per Worker
- 8
- Excess hoursShift1 Base Hourly Rate
- 40
- Excess hoursShift1 Loading Rate
- 0
- Excess hoursShift2 Workers
- 1
- Excess hoursShift2 Hours Per Worker
- 8
- Excess hoursShift2 Base Hourly Rate
- 40
- Excess hoursShift2 Loading Rate
- 0.25
- Excess hoursShift3 Workers
- 0
- Excess hoursShift3 Hours Per Worker
- 0
- Excess hoursShift3 Base Hourly Rate
- 0
- Excess hoursShift3 Loading Rate
- 0
- Excess hoursShift4 Workers
- 0
- Excess hoursShift4 Hours Per Worker
- 0
- Excess hoursShift4 Base Hourly Rate
- 0
- Excess hoursShift4 Loading Rate
- 0
- Excess hoursShift5 Workers
- 0
- Excess hoursShift5 Hours Per Worker
- 0
- Excess hoursShift5 Base Hourly Rate
- 0
- Excess hoursShift5 Loading Rate
- 0
- Excess hoursShift6 Workers
- 0
- Excess hoursShift6 Hours Per Worker
- 0
- Excess hoursShift6 Base Hourly Rate
- 0
- Excess hoursShift6 Loading Rate
- 0
- Excess hoursShift7 Workers
- 0
- Excess hoursShift7 Hours Per Worker
- 0
- Excess hoursShift7 Base Hourly Rate
- 0
- Excess hoursShift7 Loading Rate
- 0
- Excess hoursShift8 Workers
- 0
- Excess hoursShift8 Hours Per Worker
- 0
- Excess hoursShift8 Base Hourly Rate
- 0
- Excess hoursShift8 Loading Rate
- 0
- Excess hoursShift9 Workers
- 0
- Excess hoursShift9 Hours Per Worker
- 0
- Excess hoursShift9 Base Hourly Rate
- 0
- Excess hoursShift9 Loading Rate
- 0
- Excess hoursShift10 Workers
- 0
- Excess hoursShift10 Hours Per Worker
- 0
- Excess hoursShift10 Base Hourly Rate
- 0
- Excess hoursShift10 Loading Rate
- 0
- Excess hoursShift11 Workers
- 0
- Excess hoursShift11 Hours Per Worker
- 0
- Excess hoursShift11 Base Hourly Rate
- 0
- Excess hoursShift11 Loading Rate
- 0
- Excess hoursShift12 Workers
- 0
- Excess hoursShift12 Hours Per Worker
- 0
- Excess hoursShift12 Base Hourly Rate
- 0
- Excess hoursShift12 Loading Rate
- 0
Shift 1 scheduled hours
Shift 1 scheduled hours
workers × hours per worker16 hoursResult16 hours
Exact single-row engine result using the active shift slot. Raw precision is retained before display formatting.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Shift 1 scheduled hoursWorkers
- 2
- Shift 1 scheduled hoursHours Per Worker
- 8
Shift 1 cost
Shift 1 cost
workers × hours × base rate × (1 + loading) × (1 + employer on-cost)800.00Result800.00
Exact single-row engine result using the entered loading and employer on-cost. Raw precision is retained before display formatting.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Shift 1 costWorkers
- 2
- Shift 1 costHours Per Worker
- 8
- Shift 1 costBase Hourly Rate Ex Tax
- 40
- Shift 1 costLoading Rate
- 0
- Shift 1 costEmployer On Cost Rate
- 0.25
Shift 2 scheduled hours
Shift 2 scheduled hours
workers × hours per worker8 hoursResult8 hours
Exact single-row engine result using the active shift slot. Raw precision is retained before display formatting.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Shift 2 scheduled hoursWorkers
- 1
- Shift 2 scheduled hoursHours Per Worker
- 8
Shift 2 cost
Shift 2 cost
workers × hours × base rate × (1 + loading) × (1 + employer on-cost)500.00Result500.00
Exact single-row engine result using the entered loading and employer on-cost. Raw precision is retained before display formatting.
Shift Coverage Cost Planner formulas →Inputs used by these formula steps
- Shift 2 costWorkers
- 1
- Shift 2 costHours Per Worker
- 8
- Shift 2 costBase Hourly Rate Ex Tax
- 40
- Shift 2 costLoading Rate
- 0.25
- Shift 2 costEmployer On Cost Rate
- 0.25
Inputs used
- Required coverage hours
- 30
- Employer on-cost rate
- 0.25
- Shift 1 workers
- 2
- Shift 1 hours per worker
- 8
- Shift 1 base hourly rate
- 40
- Shift 1 loading
- 0
- Shift 2 workers
- 1
- Shift 2 hours per worker
- 8
- Shift 2 base hourly rate
- 40
- Shift 2 loading
- 0.25
- Shift 3 workers
- 0
- Shift 3 hours per worker
- 0
- Shift 3 base hourly rate
- 0
- Shift 3 loading
- 0
- Shift 4 workers
- 0
- Shift 4 hours per worker
- 0
- Shift 4 base hourly rate
- 0
- Shift 4 loading
- 0
- Shift 5 workers
- 0
- Shift 5 hours per worker
- 0
- Shift 5 base hourly rate
- 0
- Shift 5 loading
- 0
- Shift 6 workers
- 0
- Shift 6 hours per worker
- 0
- Shift 6 base hourly rate
- 0
- Shift 6 loading
- 0
- Shift 7 workers
- 0
- Shift 7 hours per worker
- 0
- Shift 7 base hourly rate
- 0
- Shift 7 loading
- 0
- Shift 8 workers
- 0
- Shift 8 hours per worker
- 0
- Shift 8 base hourly rate
- 0
- Shift 8 loading
- 0
- Shift 9 workers
- 0
- Shift 9 hours per worker
- 0
- Shift 9 base hourly rate
- 0
- Shift 9 loading
- 0
- Shift 10 workers
- 0
- Shift 10 hours per worker
- 0
- Shift 10 base hourly rate
- 0
- Shift 10 loading
- 0
- Shift 11 workers
- 0
- Shift 11 hours per worker
- 0
- Shift 11 base hourly rate
- 0
- Shift 11 loading
- 0
- Shift 12 workers
- 0
- Shift 12 hours per worker
- 0
- Shift 12 base hourly rate
- 0
- Shift 12 loading
- 0
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| employerOnCostRate | User-entered rate; no jurisdiction or statutory default is inferred. | decimal fraction of loaded shift wages before employer on-cost (1 = 100%) | 0 to 1 | Required | 0.25 |
| requiredCoverageHours | Hours the selected staffing pattern needs to cover. | coverage hours/selected staffing period | 0 to 100000000 | Required | 30 |
| shift10BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift10HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift10LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift10Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift11BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift11HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift11LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift11Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift12BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift12HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift12LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift12Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift1BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 40 |
| shift1HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 8 |
| shift1LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift1Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 2 |
| shift2BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 40 |
| shift2HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 8 |
| shift2LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0.25 |
| shift2Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 1 |
| shift3BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift3HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift3LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift3Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift4BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift4HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift4LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift4Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift5BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift5HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift5LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift5Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift6BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift6HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift6LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift6Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift7BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift7HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift7LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift7Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift8BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift8HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift8LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift8Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
| shift9BaseHourlyRate | User-entered base hourly cost before loading and on-cost. Use one consistent currency and ex-tax basis. | currency units/worker-hour, ex tax | 0 to 10000000 | Required | 0 |
| shift9HoursPerWorker | Paid hours for each worker in this shift. | paid hours/worker/shift | 0 to 100000000 | Required | 0 |
| shift9LoadingRate | User-entered loading; no award or statutory rate is inferred. | decimal fraction of base hourly cost (1 = 100%) | 0 to 2 | Required | 0 |
| shift9Workers | Whole workers assigned to this shift slot. | whole workers/shift slot | 0 to 100000 | Required | 0 |
Shift Coverage Cost: scheduled hours
Use uncovered and excess hours alongside exact cost; the cheapest entered pattern may not meet required coverage.
Formula summary
- Primary formula
- shift cost = workers × hours × base rate × (1 + loading) × (1 + employer on-cost)
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Stress-test the decision
Retest required hours, active workers and loadings while keeping the same cost basis.
When this estimate can be misleading
- All commercial values, FTE allocations, targets, rates, loadings and on-costs are user-entered.
- Use one consistent currency, ex-tax and reporting-period basis.
- This does not provide a productivity or staffing benchmark, interpret employment rules, classify workers, or replace professional advice.
- Use uncovered and excess hours alongside exact cost; the cheapest entered pattern may not meet required coverage.
Educational estimate, not advice. See all assumptions & limitations →
Related reading
Guides to interpret the decision and its assumptions.
- How to Model a Labour Budget Before Hiring
Build a period labour-cost envelope, test timing and capacity scenarios, and identify decision boundaries before hiring.
Read guide
Frequently asked questions
How do I choose a shift pattern that covers required hours with explicit entered loadings?
Resolve uncovered hours and confirm every entered loading and on-cost before selecting a shift pattern.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.