Welcome to the Municipal Fleet Electrification Planning Tool

This tool is designed to guide local government staff through a methodology for analyzing the electrification potential of their organization’s fleet. Along the way, this tool provides resources to assist staff in organizing fleet dataidentifying a vehicle replacement timeline and determining which EV models best fit their fleet’s needs.
The Fleet Electrification Planning Tool will guide you through the following steps:
  • Description: A series of questions to set the context and framework around your fleet assessment.
  • Result: An understanding of the scope of your fleet assessment.
  • Estimated Time: ~1 hour
  • Description: Guidance on finding and gathering data necessary to complete a fleet assessment.
  • Result: A clean, organized database that can be input to complete the remaining steps of the fleet assessment and/or turned over to a consultant to streamline a future project.
  • Estimated Time: ~3-6 weeks
  • Description: Identification of the expected replacement year for each existing vehicle based on data provided and user inputs.
  • Result: A 20-year timeline of vehicle replacements.
  • Estimated Time: Automatically calculated from data input.
  • Description: Identification of existing EV models that may fit your existing vehicles needs based on data provided and choices made by other municipal fleets.
  • Result: A recommended EV type for each existing vehicle
  • Estimated Time: Automatically calculated from data input.
  • Description: Estimates of the total cost of ownership for two scenarios
    1. Replacing an existing vehicle with a new ICE vehicle
    2. Replacing an existing vehicle with a new EV
  • Result: Estimated cost savings, or cost increases, of vehicle electrification on a per vehicle and fleet-wide basis.
  • Estimated Time: Automatically calculcated from data input.

List of Data Fields

You can find definitions for these data fields in the Fleet Data Template

Required Data Optional Data
Equipment ID Expected Service Life (yrs)
Make Fuel Usage
Model FHWA Vehicle Class
Model Year Gross Vehicle Weight Rating
Purchase Price  
Aux. Eq. Cost  
Current Life-to-Date (LTD) Maintenance Cost  
Fuel Type  
Powertrain  
Department  
Domicile Location  
Meter Type  
Beginning Meter Read  
Ending Meter Read  
Body Class  

We've got you covered

We made a set of dummy data in case you need more help filling out your data template. This Excel file will be identical to the Fleet Database Template, but all of our dummy data will be filled in to give you a better idea of what yours might look like. Maybe it will be shorter, maybe it will be longer, but the format will be the same.

You may want telematics...

Telematics can help you make smart decisions about your fleet to help you minimize cost and maximize impact. We have compiled some resources that might help convince you to get telematics.

Great!

We will come back to telematics later in the process.