ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Entry ICEMid Priced ICELuxury ICEMid EV ComLux EV ComLux EV "mostly"Mid EV 5%Lux EV 5%
Mid EV 5% - No State Surcharg
Lux EV 5% - No State Surcharg
Constants
2
Purposfull Miles per year12000120001200012000120001200012000120001200012000Fuel Efficiency Ratio ICE1
3
Deadhead Miles per year96969696072048069516951Fuel Efficiency Ratio EV0.88
4
Total Miles 12096120961209612960127201248012069120511206912051Cost Elect Home$0.17
5
Cost Elect Com$0.43
6
Fuel Economy mpg333326Mid Ev mpkWh4.2
7
Fuel Economy miles per kWh4.23.33.34.23.34.23.3Lux Ev mpkWh3.3
8
Fuel Efficiency Ratio1110.880.880.880.880.880.880.88Price of Gas$2.81
9
Fuel Units Used3673674653506438042983265415032654150Price of Premium Gas$3.25
10
Miles / Year12000
11
Fraction Commercial Share1110.70.70.40.050.050.050.05Dead Head Rate ICE0.008
12
Fraction home share 0000.30.30.60.950.950.950.95Dead Head Rate EV Mid0.114
13
Dead Head Rate EV Lux0.086
14
Commericial Fuel cost$2.81$2.81$3.25$0.43$0.43$0.43$0.43$0.43$0.43$0.43
15
Home Fuel cost$0.17$0.17$0.17$0.17$0.17$0.17$0.17All in Costs of L2 Charger$1,600.00
16
Weighted average$2.81$2.81$3.25$0.35$0.35$0.27$0.18$0.18$0.18$0.18Lifespan of EV Charger in years5
17
18
Fueling Costs Per Year$1,029.99$1,029.99$1,512.00$1,234.29$1,541.82$1,177.52$597.55$759.44$597.55$759.44
19
20
Additional Costs
21
Home Charger / year$120.00$120.00$320.00$320.00$320.00$320.00$320.00
22
Additional Reg$200.00$200.00$200.00$200.00$200.00
23
Total Fueling Costs$1,029.99$1,029.99$1,512.00$1,554.29$1,861.82$1,697.52$1,117.55$1,279.44$917.55$1,079.44
24
Cost per purposeful mile$0.086$0.086$0.126$0.130$0.155$0.141$0.093$0.107$0.076$0.090
25
26
Commercial Miles Added per visit
27
87.5116.7100.087.5116.787.5116.7
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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