The Fleet Procurement Analysis Tool equips users with decision-relevant information on the financial viability and environmental impact of light-duty vehicle fleet procurements. The Microsoft Excel-based tool can evaluate a variety of procurement ownership structures, vehicle types, and procurement scenarios. The tool compares procurements side-by-side on a cost-per-mile basis and provides an analysis of cash flows and location-specific lifecycle emissions. The tool is highly flexible, supports customizable sensitivity variables, and produces user-friendly results summaries.

The tool was built as part of EV Smart Fleets, an initiative from 2016-2017 aimed at implementing a multi-state aggregated electric vehicle procurement for public fleets. The Department of Energy’s Clean Cities program provided funding for this effort as part of their work with nearly 100 coalitions nationwide to decrease the use of petroleum in transportation.

Last Updated: June 2019

Get the Tool with U.S. Market Defaults
Get the Tool with Canadian Market Defaults
Canadian metrics supported by 
Get the User Guide
Let us know if you need help!

Release Notes

Found what’s new and download previous versions of the tool.

Version Date Author Organization Revisions
1.13 6/17/2019 Nick Nigro Atlas Public Policy Fixed bug with calculating costs for Purchased (loan) when lease year is set to a non-zero value.
1.12 4/12/2019 Nick Nigro Atlas Public Policy Update data through 2018 for U.S. and Canadian markets.
1.11 1/18/2018 Nick Nigro Atlas Public Policy Add significantly more U.S.-based light-duty vehicles (over 2,000). Updated fuel price data for 2017.
1.10 12/4/2017 Philip Quebe The Cadmus Group, Inc. Backend code improvements
1.09 11/17/2017 Philip Quebe The Cadmus Group, Inc. Improvements to sensitivity analysis functionality. Added ability to model both baseline and comparison scenarios in a single sensitivity chart. Simplified and organized sensitivity selection options.
1.08 10/20/2017 Nick Nigro Atlas Public Policy Added support for Canadian market (metric system, Canadian province-specific data, etc.). Moved remaining hardcoded defaults to Data tab to make it easier for users to customize them. Speed up user experience when editing inputs. Updated GREET figures for gasoline emissions. Updated U.S. insurance costs. Argument files created with previous version of the tool will not work correctly.
1.07 9/5/2017 Nick Nigro Atlas Public Policy Fix to allow users to add custom vehicles to “DB_Vehicles” table.
1.06 7/3/2017 Nick Nigro Atlas Public Policy Added support for U.S. average emissions and fuel prices. Use ZIP Code 00000 to set to U.S. average. Added support for more comprehensive vehicle selection and vehicle incentives. Improved robustness of some table lookup calculations. Added link to vehicle details on
1.05 6/1/2017 Philip Quebe The Cadmus Group, Inc. Minor bug fixes: sensitivity analysis and EV infrastructure inputs
1.00 5/30/2017 Philip Quebe The Cadmus Group, Inc. First launch