D.2 - EPA Fuel Surcharge Calulator.xlsx
XLSX spreadsheet 63 KB Posted
- Solicitation number
- 36C25023Q1850
About this file
This spreadsheet template is for calculating fuel surcharges 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. Price per mile and wear and tear costs must be proposed initially and remain constant throughout the life of the contract. Quarterly average fuel costs will be calculated using monthly fuel prices from EIA.gov for the Cleveland area and applied to the mileage rate to determine fuel surcharge adjustments for each option year quarter. Proposed pricing includes rates for the base period and two option years.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C25023Q1850 0002.docx | DOCX document | |
| D.4 36C25023Q1850 Reissue 9.14.2023.pdf | ||
| 36C25023Q1850 0001.docx | DOCX document | |
| 36C25023Q1850 Reissue.pdf | ||
| D.3 - WD 2015-4729 (R23), Columbus, 14 June 2023.pdf | ||
| 36C25023Q1850_1.docx | DOCX document | |
| D.1 Statement of FAR 52.219-14 Limitations on Subcontracting.pdf |
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 .