ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
232 kVA Assumed
c.2x 100kWh Charger Site
3
Fixed Charges (p/Day)201920202021202220232024202520262027
4
5
DUoS (DNO) 13.76 14.59 15.05 1,372.01 996.96 2,626.51 265.41 275.45 649.75
6
Capacity Charges (DNO) 673.96 728.19 773.14 733.99 780.68 841.87 1,639.66 1,779.15 1,947.93
7
TNUoS (NG) - - - - 2,231.00 2,110.00 2,550.00 3,818.00 4,701.00
8
Policy 15.00 18.00 20.00 30.00 50.00 55.00 60.00 65.00 70.00
9
Supplier Admin/SoLR 55.00 60.00 70.00 190.00 300.00 325.00 335.00 350.00 370.00
10
Total 757.72 820.78 878.19 2,326.00 4,358.64 5,958.38 4,850.07 6,287.60 7,738.68
11
12
13
Unit Rate (p/kWh)201920202021202220232024202520262027
14
Commodity5.54.8718.51610.28.88.97.8
15
TNUoS8.228.238.228.850.610.801.030.901.11
16
DUoS1.041.130.991.150.801.691.031.011.16
17
Policy2.82.92.73.14.24.54.74.64.6
18
BSUoS/Losses0.911.11.41.822.22.42.6
19
Other666666876
20
Total24.4624.0626.0139.0029.4025.1925.7524.8023.27
21
22
Total Costs (£)201920202021202220232024202520262027
23
24
Monthly Utilisation Assumption (kWh/Month) 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000
25
26
Total Monthly Costs (£)
27
Unit Rate 733.88 721.70 780.17 1,169.89 882.14 755.67 772.64 744.06 698.16
28
Standing Charge 234.89 254.44 272.24 721.06 1,351.18 1,847.10 1,503.52 1,949.16 2,398.99
29
Total 968.77 976.14 1,052.41 1,890.95 2,233.32 2,602.77 2,276.16 2,693.22 3,097.15
30
31
Variance top Prior Year0.8%7.8%79.7%18.1%16.5%-12.5%18.3%15.0%
32
Variance to 20190.8%8.6%95.2%130.5%168.7%135.0%178.0%219.7%
33
34
TNUoS Variance (£)
35
Unit Rate 246.57 246.95 246.61 265.37 18.23 23.89 30.86 26.89 33.28
36
Standing Charge - - - - 691.61 654.10 790.50 1,183.58 1,457.31
37
Total 246.57 246.95 246.61 265.37 709.84 677.99 821.36 1,210.47 1,490.59
38
39
Variance top Prior Year0.2%-0.1%7.6%167.5%-4.5%21.1%47.4%23.1%
40
Variance to 20190.2%0.0%7.6%187.9%175.0%233.1%390.9%504.5%
41
42
DUoS Variance (£)
43
Unit Rate 31.31 33.75 29.56 34.53 23.92 50.79 30.79 30.18 34.88
44
Standing Charge 213.19 230.26 244.34 652.86 551.07 1,075.20 590.57 636.93 805.28
45
Total 244.50 264.01 273.90 687.39 574.98 1,125.98 621.36 667.10 840.16
46
47
Variance top Prior Year8.0%3.7%151.0%-16.4%95.8%-44.8%7.4%25.9%
48
Variance to 20198.0%12.0%181.1%135.2%360.5%154.1%172.8%243.6%
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