Define your own rate bands. Test when a flat average rate deviates more than ±10% from actual cost.
FLAT RATE
DKK
RATE BANDS (8.000h · 50.0 FTE)
Range
Single
–
DKK/h
800h
5.0 FTE
–
DKK/h
2880h
18.0 FTE
–
DKK/h
2400h
15.0 FTE
–
DKK/h
1280h
8.0 FTE
–
DKK/h
640h
4.0 FTE
Effective rate: 1164 DKK
DEVIATION
+5.8%
WITHIN THRESHOLD
Estimated cost
8.800.000 DKK
1100 × 8.000h
Actual cost
9.308.000 DKK
Difference
+508.000 DKK
DEVIATION GAUGE
−20%−10%0%+10%+20%
HOURS BY RATE BAND
How to read this: Define rate bands to match your project's rate structure. The flat rate is your forecasting shortcut — one rate × total hours = estimated cost. The "actual cost" uses each band's midpoint × hours in that band. Drag the hours sliders to model different month scenarios — e.g. "what if this month is heavy on senior rates?" Toggle between range and single rate mode depending on whether you know exact rates or are working with brackets.
