Spreadsheet: 07b7dcaf-8db9-41b5-a6ee-99ab73f0e2d9
Sheet: Surcharge Estimating Tool

[Agency Name] |  | FY13 Initial Surcharge (will appear as a line item on your monthly bill) | FY13 [NAME] off when? | FY14 CONUS GSA Fleet Leased Inventory | FY13 Incremental Spent
 |  | $X | All Fy13 surcharges were turned off in April | [NAME] | [NAME]
 |  |  |  |  |  | **FSRs can use their discretion regarding which to replace (number is as funding permits)
FY14 Incremental Projection Worksheet
Sedan Incremental Scenerio* :
Size | SIN | Make | Model | When you Would Order | FY14 incremental | QTY | Total Incremental projected to spend in Fy14 | Estimated FY14 [NAME]
Sub-compact Sedan | 8C | Ford/Chevrolet | Focus/Cruze | Need Gas or [NAME] in 38 NON CARB States | 0 | 10
Sub-compact Sedan | 8C | Dodge | Dart E85 | [NAME] in one of 12 CARB States | 2744.169999999998
Sub-compact Sedan | 8H | Ford | CMAX Hybrid | Want Sub-Comapct Hybrid | 7483.09 | 23
Sub-compact Sedan | 8E | Ford | Focus BEV | Want Electric | 16573.09 | 0
Sub-compact Sedan | 8P | Ford | CMAX Plugin | Want Plugin | 14899.52 | 15
Sub-compact Sedan | 8P | Chevrolet | Volt | Want Plugin | 17087.18 | 0
Sub-compact Sedan | 8N | Honda | CIVIC GX NGV | Low GHG CNG | 11790.74
Compact Sedan | 9C | Chevrolet | Malibu (Low GHG) | Low GHG Gas | 0 | 10
Compact Sedan Hybrid | 9H | Hyundai | [NAME] | Low price [NAME] | 5540.86 | 20
Compact Sedan Hybrid | 9H | Ford | Fusion HEV | Compact Hybrid (not low) | 5995.36 | 10
Compact Sedan Plugin Electric | 9P | Ford | Fusion Plugin | Compact Plugin | 19289.99 | 0
Compact, MIN 5000LBS [NAME] | 30 | CHRYSLER | CV TRADESMAN | Only Low GHG Cargo Van | 471.67
Crossover, 4DR 5Pass, MIN 4500 LBS GVWR | 91 | Dodge | Journey | Low GHG (Lowest price E85 SIN 91-50 State Engine | 2696.700000000001
Compact, 4DR 5Pass, MIN 4400 LBS GVWR | 98 | Ford | Equinox [NAME] | Low [NAME] (Not 50 State Engine)-Only comes in E85 in 38 NON Carb States | 1972.529999999999 | 0
Compact, 4DR 5Pass, MIN 4500 LBS GVWR | 99 | Ford | Equinox [NAME] | Low [NAME] (Not 50 State Engine)-Only comes in E85 in 38 NON Carb States | 809.0099999999984
Intermediate, 4DR 5Pass, MIN 5300 LBS GVWR | 100A | Ford | Equinox [NAME] | Low GHG and [NAME] (only low ghg 100A) | 389.8600000000006 | 0
 |  |  |  |  | Total
*Based on FY14 Awards
To get an idea of what was spent in FY13 you may want to look at what your surcharge was in Fiscal Year 13. You may also want to think about how much total incremental was spent. It may be helpful to view incremental spent over the past few years to identify any trends. Please keep in mind that in FY10 GSA funded many of your hybrids through the American Reinvestment and Recovery Act (ARRA) funds and in FY11 there was a big push for hybrids. In FY12 and into the future budget cuts, green initiatives and the Vehicle Allocation Methodology have lead many agencies to spend less on newer technology/more expensive vehicle models.
Instructions:You will need to fill in your current inventory (Cell E2) as well as enter in new Quanties (Cell G7) to see what your yearly surcharge should be. Please enter 0 for vehicles you do not plan on acquiring (all numbers in column G are just used as an example).
**Please be aware that any vehicle's that are leased through GSA's EV Pilot program, GSA MVM's Hybrid Consolidation Initiative, or Full replacement Rate Program will not incur incremental costs and therefore, will not apply.