Summarize twelve months of utility spending
A household closes its simulated year with a spending total for both utilities. It wants to compare annual budget performance by utility even if the combined number looks close.
Open TrackerInputs and calculation
| Month | Utility | Usage | Bill | Budget | Variance | Month change |
|---|---|---|---|---|---|---|
| 2025-01 | electricity | 400 kWh | 100 | 100 | 0 | — |
| 2025-02 | electricity | 400 kWh | 100 | 100 | 0 | 0 (0%) |
| 2025-03 | electricity | 400 kWh | 100 | 100 | 0 | 0 (0%) |
| 2025-04 | electricity | 360 kWh | 90 | 100 | -10 | -10 (-10%) |
| 2025-05 | electricity | 360 kWh | 90 | 100 | -10 | 0 (0%) |
| 2025-06 | electricity | 440 kWh | 110 | 100 | 10 | 20 (22.2222%) |
| 2025-07 | electricity | 480 kWh | 120 | 100 | 20 | 10 (9.0909%) |
| 2025-08 | electricity | 480 kWh | 120 | 100 | 20 | 0 (0%) |
| 2025-09 | electricity | 440 kWh | 110 | 100 | 10 | -10 (-8.3333%) |
| 2025-10 | electricity | 360 kWh | 90 | 100 | -10 | -20 (-18.1818%) |
| 2025-11 | electricity | 360 kWh | 90 | 100 | -10 | 0 (0%) |
| 2025-12 | electricity | 400 kWh | 100 | 100 | 0 | 10 (11.1111%) |
| 2025-01 | water | 10 m³ | 40 | 50 | -10 | — |
| 2025-02 | water | 10 m³ | 40 | 50 | -10 | 0 (0%) |
| 2025-03 | water | 10 m³ | 40 | 50 | -10 | 0 (0%) |
| 2025-04 | water | 10 m³ | 40 | 50 | -10 | 0 (0%) |
| 2025-05 | water | 12 m³ | 48 | 50 | -2 | 8 (20%) |
| 2025-06 | water | 14 m³ | 56 | 50 | 6 | 8 (16.6667%) |
| 2025-07 | water | 15 m³ | 60 | 50 | 10 | 4 (7.1429%) |
| 2025-08 | water | 15 m³ | 60 | 50 | 10 | 0 (0%) |
| 2025-09 | water | 14 m³ | 56 | 50 | 6 | -4 (-6.6667%) |
| 2025-10 | water | 12 m³ | 48 | 50 | -2 | -8 (-14.2857%) |
| 2025-11 | water | 10 m³ | 40 | 50 | -10 | -8 (-16.6667%) |
| 2025-12 | water | 10 m³ | 40 | 50 | -10 | 0 (0%) |
Electricity rows sum to 1,220 against 12 × 100 = 1,200. Water rows sum to 568 against 12 × 50 = 600. Combined spending is 1,788 against 1,800.
What the comparison shows
The combined year is 12 under budget, but electricity alone is 20 over. The water allowance absorbs that overrun in the combined view.
Assumptions and limits
Enter each monthly row in the tracker. Annual sums are a separate calculation, and a missing bill should be resolved before summing.