| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||
2 | Projected Months: | 24 | Auto Budget: | $185.00 | |||||||||||
3 | Monthly Efficiency: | 0.0% | |||||||||||||
4 | |||||||||||||||
5 | Month | Year | Bill | Projected | Budget | Remainder | Running | YoY Bill | kWh | Supply Cost | YoY kWh | $/kWh Supply | ~Delivery Cost | ~$/kWh Delivery | ~$/kWh Total |
6 | 5 | 2020 | $167.10 | $190.00 | $22.90 | $22.90 | 921 | ||||||||
7 | 6 | 2020 | $137.09 | $190.00 | $52.91 | $75.80 | 1008 | ||||||||
8 | 7 | 2020 | $181.26 | $190.00 | $8.74 | $84.54 | 1246 | ||||||||
9 | 8 | 2020 | $94.26 | $160.00 | $65.74 | $150.28 | 1402 | ||||||||
10 | 9 | 2020 | $132.94 | $160.00 | $27.06 | $177.34 | 1155 | ||||||||
11 | 10 | 2020 | $135.52 | $160.00 | $24.48 | $201.82 | 1144 | ||||||||
12 | 11 | 2020 | $145.17 | $160.00 | $14.83 | $216.65 | 1221 | ||||||||
13 | 12 | 2020 | $253.94 | $180.00 | -$73.94 | $142.71 | 1814 | ||||||||
14 | 1 | 2021 | $282.90 | $180.00 | -$102.90 | $39.81 | 2255 | $162.92 | $0.07225 | $117.97 | $0.05231 | $0.12456 | |||
15 | 2 | 2021 | $202.66 | $180.00 | -$22.66 | $17.15 | 2243 | $158.86 | $0.07082 | $41.80 | $0.01864 | $0.08946 | |||
16 | 3 | 2021 | $145.46 | $160.00 | $14.54 | $31.69 | 1557 | $109.82 | $0.07053 | $34.15 | $0.02193 | $0.09247 | |||
17 | 4 | 2021 | $183.54 | $160.00 | -$23.54 | $8.15 | 1309 | $92.32 | $0.07053 | $89.92 | $0.06869 | $0.13922 | |||
18 | 5 | 2021 | $119.94 | $160.00 | $40.06 | $48.21 | -$47.16 | 1072 | $75.61 | 151 | $0.07053 | $43.21 | $0.04031 | $0.11084 | |
19 | 6 | 2021 | $161.38 | $160.00 | -$1.38 | $46.83 | $24.28 | 1096 | $79.41 | 88 | $0.07245 | $80.83 | $0.07375 | $0.14620 | |
20 | 7 | 2021 | $203.23 | $175.00 | -$28.23 | $18.60 | $21.97 | 1388 | $105.54 | 142 | $0.07604 | $96.33 | $0.06940 | $0.14544 | |
21 | 8 | 2021 | $129.88 | $175.00 | $45.12 | $63.72 | $35.62 | 1230 | $94.25 | -172 | $0.07663 | $34.39 | $0.02796 | $0.10458 | |
22 | 9 | 2021 | $115.87 | $175.00 | $59.13 | $122.86 | -$17.07 | 1044 | $80.00 | -111 | $0.07663 | $34.76 | $0.03330 | $0.10993 | |
23 | 10 | 2021 | $90.42 | $175.00 | $84.58 | $207.43 | -$45.10 | 866 | $71.18 | -278 | $0.08219 | $18.28 | $0.02110 | $0.10330 | |
24 | 11 | 2021 | $140.45 | $190.00 | $49.55 | $256.98 | -$4.72 | 1083 | $90.21 | -138 | $0.08330 | $49.11 | $0.04535 | $0.12864 | |
25 | 12 | 2021 | $244.42 | $190.00 | -$54.42 | $202.56 | -$9.52 | 1935 | $161.19 | 121 | $0.08330 | $81.46 | $0.04210 | $0.12540 | |
26 | 1 | 2022 | $318.42 | $190.00 | -$128.42 | $74.14 | $35.52 | 2101 | $175.01 | -154 | $0.08330 | $141.52 | $0.06736 | $0.15066 | |
27 | 2 | 2022 | $248.08 | $190.00 | -$58.08 | $16.07 | $45.41 | 2089 | $173.46 | -154 | $0.08303 | $72.73 | $0.03482 | $0.11785 | |
28 | 3 | 2022 | $165.62 | $190.00 | $24.38 | $40.44 | $20.17 | 1584 | $131.44 | 27 | $0.08298 | $32.68 | $0.02063 | $0.10361 | |
29 | 4 | 2022 | $209.59 | $190.00 | -$19.59 | $20.85 | $26.05 | 1514 | $125.63 | 205 | $0.08298 | $82.51 | $0.05450 | $0.13747 | |
30 | 5 | 2022 | $184.42 | $190.00 | $5.58 | $26.44 | $64.47 | 1107 | $91.86 | 35 | $0.08298 | $91.41 | $0.08257 | $0.16555 | |
31 | 6 | 2022 | $136.07 | $180.00 | $43.93 | $70.37 | -$25.31 | 1177 | $93.07 | 81 | $0.07907 | $41.80 | $0.03551 | $0.11459 | |
32 | 7 | 2022 | $134.90 | $180.00 | $45.10 | $115.46 | -$68.33 | 1331 | $104.08 | -57 | $0.07820 | $29.51 | $0.02217 | $0.10037 | |
33 | 8 | 2022 | $145.85 | $180.00 | $34.16 | $149.62 | $15.97 | 1261 | $98.61 | 31 | $0.07820 | $45.97 | $0.03646 | $0.11466 | |
34 | 9 | 2022 | $197.09 | $180.00 | -$17.09 | $132.53 | $81.22 | 1291 | $100.96 | 247 | $0.07820 | $94.84 | $0.07346 | $0.15167 | |
35 | 10 | 2022 | $165.99 | $180.00 | $14.01 | $146.54 | $75.57 | 1037 | $98.64 | 171 | $0.09512 | $66.25 | $0.06389 | $0.15901 | |
36 | 11 | 2022 | $142.81 | $42.19 | $188.73 | ||||||||||
37 | 12 | 2022 | $249.18 | -$64.18 | $124.55 | ||||||||||
38 | 1 | 2023 | $300.66 | -$115.66 | $8.89 | ||||||||||
39 | 2 | 2023 | $225.37 | -$40.37 | -$31.48 | ||||||||||
40 | 3 | 2023 | $155.54 | $29.46 | -$2.02 | ||||||||||
41 | 4 | 2023 | $196.57 | -$11.57 | -$13.59 | ||||||||||
42 | 5 | 2023 | $157.15 | $27.85 | $14.26 | ||||||||||
43 | 6 | 2023 | $144.85 | $40.15 | $54.41 | ||||||||||
44 | 7 | 2023 | $173.13 | $11.87 | $66.28 | ||||||||||
45 | 8 | 2023 | $123.33 | $61.67 | $127.95 | ||||||||||
46 | 9 | 2023 | $148.63 | $36.37 | $164.32 | ||||||||||
47 | 10 | 2023 | $130.64 | $54.36 | $218.68 | ||||||||||
48 | 11 | 2023 | $142.81 | $42.19 | $260.87 | ||||||||||
49 | 12 | 2023 | $249.18 | -$64.18 | $196.68 | ||||||||||
50 | 1 | 2024 | $300.66 | -$115.66 | $81.02 | ||||||||||
51 | 2 | 2024 | $225.37 | -$40.37 | $40.65 | ||||||||||
52 | 3 | 2024 | $155.54 | $29.46 | $70.11 | ||||||||||
53 | 4 | 2024 | $196.57 | -$11.57 | $58.55 | ||||||||||
54 | 5 | 2024 | $157.15 | $27.85 | $86.40 | ||||||||||
55 | 6 | 2024 | $144.85 | $40.15 | $126.55 | ||||||||||
56 | 7 | 2024 | $173.13 | $11.87 | $138.42 | ||||||||||
57 | 8 | 2024 | $123.33 | $61.67 | $200.09 | ||||||||||
58 | 9 | 2024 | $148.63 | $36.37 | $236.46 | ||||||||||
59 | 10 | 2024 | $130.64 | $54.36 | $290.81 | ||||||||||
60 | |||||||||||||||
61 | |||||||||||||||
62 | |||||||||||||||
63 | |||||||||||||||
64 | |||||||||||||||
65 | |||||||||||||||
66 | |||||||||||||||
67 | |||||||||||||||