The Fleet Procurement Analysis Tool equips users with decision-relevant information on the financial viability and environmental impact of light-, medium-, and heavy-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.
This tool was originally created with funding from the U.S. Department of Energy.
Last Updated: April 2021
Release Notes
Found what’s new and download previous versions of the tool.
Version | Date | Author | Organization | Revisions |
1.20 | 4/9/2021 | Nick Nigro, Josh Rosenberg | Atlas Public Policy | Resolved issue related to incorrect emissions modeled for Canadian provinces. |
1.19 | 4/7/2021 | Nick Nigro, Josh Rosenberg | Atlas Public Policy | Updated data for U.S. and Canadian market for fuel prices, vehicles available, incentives, and inflation. |
1.18 | 11/30/2020 | Nick Nigro | Atlas Public Policy | Improved descriptions in tool. Corrected emissions factor for NOx emissions for heavy-duty vehicles. Added many more vehicles to vehicle database from fueleconomy.gov and Atlas database of medium- and heavy-duty vehicles. Updated light-duty vehicle depreciation calculation for BEVs to reflect resale data from 2015-2019. Updated light-duty vehicle insurance costs and charging infrastructure costs. Updated medium- and heavy-duty vehicle maintenance costs using the 2019 version of AFLEET. |
1.17 | 2/12/2020 | Nick Nigro | Atlas Public Policy | Updated fuel prices for 2019, vehicle availability through February 2020, and eGrid for 2018. Fixed bugs with cash flow chart and Load/Save feature. |
1.16 | 12/11/2019 | Nick Nigro | Atlas Public Policy | Fixed bug with vehicle selection. |
1.15 | 11/20/2019 | Nick Nigro | Atlas Public Policy | Fixed bug with custom vehicle selection. |
1.14 | 9/17/2019 | Nick Nigro | Atlas Public Policy | Upgrade to support medium- and heavy-duty vehicles. Fixed bug with calculating maintenance costs for Canadian market. Updated vehicle incentives for light-duty vehicles to remove federal incentive for Tesla and General Motors. Added vehicles for model years 2019 and 2020. |
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 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 |