Calculate
Door rate, ELR & parts matrix
The owner math shops already do in spreadsheets: loaded cost ÷ billed hours ÷ (1 − target GP). Effective labour rate is labour dollars collected ÷ hours billed — the number that actually landed.
Door rate from cost
Billed hours
28.5
Cost / billed hour
$270.18
Implied door (ex GST)
$600.39
$330.21 GP per billed hour exclusive · GST 10%
Effective labour rate
ELR
$158.06
Door was $600.39. Gap is $442.33.
Parts matrix (sample bands)
Sell at 50 GP ($50–150)
$168.00
| Band | Target GP |
|---|---|
| Under $20 | 70 GP |
| $20–50 | 60 GP |
| $50–150 | 50 GP |
| $150–400 | 40 GP |
| $400+ | 30 GP |
Theory
Door rate is posted. ELR is collected.
Door rate = (weekly overhead + weekly wage cost) ÷ billed hours ÷ (1 − target labour GP). Billed hours = available hours × utilisation. Effective labour rate = labour dollars collected ÷ hours billed. Shops go broke posting $180 and collecting $142. The loaded MA000089 cost is the floor under the door rate — not a substitute for it.
Overhead $4,500 + wages $3,200 = $7,700. 38 h × 75% = 28.5 billed. Cost/h = $270.18. At 55% GP, door = $600.39 exclusive.
How to use it
- Role
- Owner / GM (P01)
- Shop-day step
- HISTORY → the weekly numbers, not a single RO
- Do
- Set door from loaded cost, then watch ELR every week. Import the award loaded $ if wages are award-shaped.
- Do not
- Do not discount on the counter until you know the ELR gap. This page does not read your tenant reports.
Official sources
Related tools
Teaching calculator. It does not read your Wrench tenant. Posted door rate is not ELR.