Revenue Rex logo mark
💰 Financial · Rex's Toolbox

Substitute Teacher Cost Calculator

Project your annual substitute budget from absence rates and sub pay.

Revenue Rex peeking

Rex says

Money math without the spreadsheet headache. Plug in your numbers and I'll show you exactly where the dollars land.

Try a scenario

Click to load — tweak from there.

Inputs

Result

Annual internal sub cost

$29,250

Annual agency-only cost (comparison)

$45,000

Annual savings vs. agency-only

$15,750

Total sub days needed / year

225

Sub cost per operating day

$117

Revenue Rex peeking

Psst — share this and help Rex grow

One click, a permanent link with your numbers baked in.

More financial

How to use this

  1. 1Enter teacher headcount.
  2. 2Enter average absence days per teacher / year.
  3. 3Enter internal / float sub day rate ($).
  4. 4Enter agency sub day rate ($).
  5. 5Enter operating days per year.
  6. 6Read your annual internal sub cost on the right — it updates as you type.
  7. 7Hit Share to keep the scenario or send it to someone.

About this calculator

Substitute coverage is a recurring, budgetable cost, not a surprise, once you know your staff's average absence rate. This calculator takes headcount, average sick/personal days used per teacher per year, and your substitute day rate (or hourly rate times hours) to project total annual substitute spend, then compares that to what you'd pay if uncovered absences forced ratio violations and temporary agency staff at a premium rate. It also computes cost per classroom day, useful for building substitute costs into your per-classroom budget rather than lumping it into a vague 'other staffing' line. Centers relying heavily on last-minute staffing agencies instead of an internal sub pool typically pay a 30-60% premium per shift, so this tool includes a comparison so you can see the dollar impact of building an internal float-staff pool versus staying reactive.

FormulaTotal sub days needed = headcount × avg absence days per teacher; internal sub cost = sub days × internal day rate; agency cost = sub days × agency day rate; savings = agency cost − internal cost.

Worked example

Using the values the calculator loads with:

Inputs

  • Teacher headcount: 25
  • Average absence days per teacher / year: 9
  • Internal / float sub day rate: 130 $
  • Agency sub day rate: 200 $
  • Operating days per year: 250

Results

  • Annual internal sub cost: $29,250
  • Annual agency-only cost (comparison): $45,000
  • Annual savings vs. agency-only: $15,750
  • Total sub days needed / year: 225
  • Sub cost per operating day: $117

What each field means

Inputs

Teacher headcount
The teacher headcount used in the calculation. Starts at 25 so you have a working example on load.
Average absence days per teacher / year
The average absence days per teacher / year used in the calculation. Starts at 9 so you have a working example on load.
Internal / float sub day rate ($)
The internal / float sub day rate used in the calculation, measured in $. Starts at 130 $ so you have a working example on load.
Agency sub day rate ($)
The agency sub day rate used in the calculation, measured in $. Starts at 200 $ so you have a working example on load.
Operating days per year
The operating days per year used in the calculation. Starts at 250 so you have a working example on load.

Results

Annual internal sub cost
Returned as a money amount in US dollars and shown as the headline result. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
Annual agency-only cost (comparison)
Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
Annual savings vs. agency-only
Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
Total sub days needed / year
Returned as a whole number. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
Sub cost per operating day
Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.

FAQ

What's a typical teacher absence rate in childcare and schools?

Public school teacher absence data commonly shows 8-12 sick/personal days used per year on average; childcare and private school staff tend to fall in a similar range, sometimes higher in infant/toddler rooms due to illness exposure. Pull your own attendance system data rather than assuming a national number, since it varies a lot by center culture and benefits structure.

Why build an internal float pool instead of calling an agency every time?

Agency subs typically charge a placement fee or premium hourly rate on top of the worker's pay, and quality is inconsistent since they don't know your kids or routines. A part-time internal float staff person paid a flat day rate is usually 30-50% cheaper per shift and produces better continuity for the classroom, though it requires having someone available and cross-trained.

Does this cost belong in the classroom staffing budget?

Yes — treat it as a predictable line item rather than an emergency expense. Spread the annual total across classrooms by headcount share, or track it centrally if you run a shared float pool across multiple rooms, and review actual usage against budget quarterly since absence patterns shift seasonally (cold and flu season spikes utilization).

How does chronic short-staffing affect this number?

If you're already understaffed, absences often go uncovered rather than filled by subs, which shows up as ratio violations or exhausted remaining staff rather than as a substitute cost line. A suspiciously low sub cost paired with high staff turnover is often a sign absences aren't being covered at all, not that your team never gets sick.

Accuracy and limitations

  • Results are estimates before tax, fees, and inflation unless an input explicitly covers them.
  • Rates are treated as fixed for the whole period — variable-rate products will drift from this projection.
  • This is educational maths, not financial advice. Check anything contractual with the lender or your accountant.

Related tools

Cite this calculator

Writing about this topic? Grab a citation — every link helps keep these tools free.

APA
RevenueLab. (2026). Substitute Teacher Cost Calculator. Retrieved from https://www.revenuelab.fyi/toolbox/substitute-teacher-cost
HTML
<p>Source: <a href="https://www.revenuelab.fyi/toolbox/substitute-teacher-cost" target="_blank" rel="noopener">Substitute Teacher Cost Calculator — RevenueLab</a> (2026).</p>
Markdown
Source: [Substitute Teacher Cost Calculator — RevenueLab](https://www.revenuelab.fyi/toolbox/substitute-teacher-cost) (2026).
Advertisement