Using the 2014 Tesla Model S data on page 44 of Electric Powertrain Hayes, calculate the vehicle range for the following scenarios. Do not use the ABC coefficients. Frontal Area is 2.34 m^2 and air density is 1.225 kg/m^3. The vehicle is equipped with an 85 kWh battery pack.
1. A constant speed of 70 mph.
2. The US06 drivetrace.
a. With 100% efficiencies and no accessory load
b. With 85% drive efficiency and 75% regenerative braking efficiency
c. With 85% drive efficiency and 75% regenerative braking efficiency and a 2kW constant accessory load.
Turn in your assignment as an excel spreadsheet to D2L. As always, use formulas in excel so that the variables are variable.