D.2 - EPA Fuel Surcharge Calulator.xlsx
XLSX spreadsheet 63 KB Posted
- Solicitation number
- 36C25023Q0890
About this file
This document is a fuel surcharge calculator spreadsheet for an ambulance service contract with the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 10. The base period of performance is from September 15, 2023 to September 14, 2026 with two option years. The spreadsheet calculates quarterly fuel costs using the average monthly fuel prices for the Cleveland area from EIA.gov and adjusts the mileage rate reimbursement accordingly. The price per mile and maintenance costs are set at proposal and remain fixed throughout the contract term. The related solicitation is for ambulance transportation services for the base year plus four option years starting on December 1, 2023.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
EPA Calculations
| Vendor | ||||||||||
| Solicitation or Contract Number | 36C25023Q1850 | |||||||||
| Contract Title | Ambulance Service (Columbus VAACC) | |||||||||
| Period Of Performance | 15 Sep 2023 to 14 Sep 2026 | |||||||||
| MPG | 10 | |||||||||
| ** Only input data into this color of box**** | ||||||||||
| Base Year | Base Year | |||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | |||
| Oct-Dec | Jan-Mar | Apr-June | Jul-Sep | Jul-Aug | Oct-Nov | Jan-Feb | Apr-May | |||
| Avg Fuel Cost for Quarter (Start) | $4.03 | https://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_m.htm |
or https://gasprices.aaa.com/?state=OH
Average Fuel Cost shall be the price of fuel within the area of performance.
Avg Cost will be found on www.eig.gov for the area of Cleveland and selecting "Monthly" as the period. The formula for avg fuel cost (AFC) will be as follows:
(Month 1 + Month 2 ) / 2 = AFC
Price Per Mile is established at time of proposal ans shall remain for the life of the contract.
| Wear and Tear is an Operational and Maintenace cost established at time of proposal and shall remain consitant through out the life of the contract. | Month 1 | $3.765 | |||||||
| Price Per mile (Start) | $0.40 | Month 2 | $4.299 | ||||||
| Wear and tear Per Mile | |||||||||
| Mileage Rate (Current) | $0.40 | Oct-Dec | Jan-Mar | Apr-Jun | Jul-Sep | ||||
| Avg Fuel Cost for Quarter (End) | AFC | $4.03 | |||||||
| Price Per mile (End) | |||||||||
| Mileage Rate |
| Option Year 1 | Option Year 1 | ||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | ||
| Oct-Dec | Jan-Mar | Apr-June | Jul-Sep | Jul-Aug | Oct-Nov | Jan-Feb | Apr-May | ||
| Avg Fuel Cost for Quarter (Start) | Month 1 | ||||||||
| Price Per mile (Start) | Month 2 | ||||||||
| Wear and tear Per Mile | |||||||||
| Mileage Rate (Current) | Oct-Dec | Jan-Mar | Apr-Jun | Jul-Sep | |||||
| Avg Fuel Cost for Quarter (End) | AFC | ||||||||
| Price Per mile (End) | |||||||||
| Mileage Rate |
| Option Year 2 | Option Year 2 | ||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | ||
| Oct-Dec | Jan-Mar | Apr-June | Jul-Sep | Jul-Aug | Oct-Nov | Jan-Feb | Apr-May | ||
| Avg Fuel Cost for Quarter (Start) | Month 1 | ||||||||
| Price Per mile (Start) | Month 2 | ||||||||
| Wear and tear Per Mile | |||||||||
| Mileage Rate (Current) | Oct-Dec | Jan-Mar | Apr-Jun | Jul-Sep | |||||
| Avg Fuel Cost for Quarter (End) | AFC | ||||||||
| Price Per mile (End) | |||||||||
| Mileage Rate |
Price Data (Base)
Price Data (OY1)
Price Data (OY2) image1.png
File details come from the government source that posted it. Updated .