EV Analysis

	A	B	C	D	E	F	G	H	I	J	K	O	P
1		Entry ICE	Mid Priced ICE	Luxury ICE	Mid EV Com	Lux EV Com	Lux 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 year	12000	12000	12000	12000	12000	12000	12000	12000	12000	12000	Fuel Efficiency Ratio ICE	1
3	Deadhead Miles per year	96	96	96	960	720	480	69	51	69	51	Fuel Efficiency Ratio EV	0.88
4	Total Miles	12096	12096	12096	12960	12720	12480	12069	12051	12069	12051	Cost Elect Home	$0.17
5												Cost Elect Com	$0.43
6	Fuel Economy mpg	33	33	26								Mid Ev mpkWh	4.2
7	Fuel Economy miles per kWh				4.2	3.3	3.3	4.2	3.3	4.2	3.3	Lux Ev mpkWh	3.3
8	Fuel Efficiency Ratio	1	1	1	0.88	0.88	0.88	0.88	0.88	0.88	0.88	Price of Gas	$2.81
9	Fuel Units Used	367	367	465	3506	4380	4298	3265	4150	3265	4150	Price of Premium Gas	$3.25
10												Miles / Year	12000
11	Fraction Commercial Share	1	1	1	0.7	0.7	0.4	0.05	0.05	0.05	0.05	Dead Head Rate ICE	0.008
12	Fraction home share	0	0	0	0.3	0.3	0.6	0.95	0.95	0.95	0.95	Dead Head Rate EV Mid	0.114
13												Dead Head Rate EV Lux	0.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.17	All 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.18	Lifespan of EV Charger in years	5
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.5	116.7	100.0	87.5	116.7	87.5	116.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