Fleet Procurement Analysis Tool

Fleet Procurement Analysis Tool 2017-09-13T11:57:51+00:00

Project Description

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 to implement a multi-state aggregated electric vehicle procurement for public fleets. EV Smart Fleets seeks to accelerate electric vehicle adoption by public fleets, lower the purchase price of electric vehicles for public fleets, and increase access to a wider range of electric vehicle models. The Department of Energy’s Clean Cities program has 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: September 2017

Get the Tool
Get the User Guide

Below is the contact information for all contributors to the design and development of the Fleet Procurement Analysis Tool.

Contact at Atlas Public Policy
Nick Nigro

Contact at the Cadmus Group, Inc.
Philip Quebe
Senior Associate
Let us know if you need help!

Release Notes

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

Version Date Author Organization Revisions
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 fueleconomy.gov.
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