ABCDEFGHIJKLMWXYZ
1
2
3
4
5
6
7
8
9
10
11
Residential Bill Calculation
12
Billing Month Comparison
13
14
Select Billing Month 1Select Billing Month 2
15
Billing MonthJan-2020Jan-2021
16
17
Enter kWh for Billing PeriodEnter kWh for Billing Period
18
Kilowatt Hours (kWh)10001000
19
20
21
Average Temperature 45.3 42.3
22
23
24
Bill CalculationBill Calculation$ Change% Change
25
Customer Charge $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ - 0.00%
26
Base Rate 0.07680 76.80 0.07680 76.80 - 0.00%
27
Fuel Cost Adjustment 0.01990 19.90 0.01713 17.13 (2.77)-13.92%
28
29
Total Energy Charge $ 116.70 $ 113.93 $ (2.77)-2.37%
30
31
Avg Rate per kWh 0.11670 0.11393 (0.00277)-2.37%
32
33
34
35
Billing Change Analysis
36
37
 Effect of Change in kWh $ 0.00
38
39
 Effect of Change in Rates $ (2.77)
40
41
Total Change in Energy Charge
 $ (2.77)
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100