D.2 EPA Fuel Surcharge Calculator.xlsx
XLSX spreadsheet 155 KB Posted
- Solicitation number
- 36C25024Q7572
About this file
This Excel workbook template is for an EPA Fuel Surcharge Calculator to be submitted with proposals for the Wheelchair Transportation Service solicitation issued by the Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 10. Offerors must populate fields in the green-highlighted areas to calculate fuel price adjustments for the base year and four option years based on miles traveled, fuel prices from the EIA, and a fixed wear and tear cost per mile. Proposed adjustments will modify CLIN 0002 for the base and option years. Failure to complete the required green fields will result in the proposal being deemed non-compliant and removed from consideration for award. The service is to transport veterans in wheelchairs at the Cincinnati VAMC from June 1, 2024 through May 31, 2029.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C25024Q7572 0001.docx | DOCX document | |
| 36C25024Q7572.docx | DOCX document | |
| D.1 WD 2015-4729 (R25) Columbus, 26 Dec 2023.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
| Contractor Name | ||||||||||
| Solicitation or Contract Number | 36C25024Q07572 | |||||||||
| Contract Title | Wheelchair Service (Columbus VAACC) | |||||||||
| Period Of Performance | 1 June 2024 to 31 May 2029 | |||||||||
| 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 | |||
| Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | Mar-May | Jun-Aug | Sep-Nov | Dec-Feb | |||
| Avg Fuel Cost for Quarter (Start) | Average Fuel Cost shall be the price of fuel within the area of performance. |
Avg Cost can be found on (but not limited) to www.eig.gov and selecting "Monthly" as the period. The formula for avg fuel cost (AFC) will be as follows:
(Month 1 + Month 2 + Month 3) / 3 = AFC https://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_m.htm
MPG is established at time of offer and shall remain for the life of the contract.
Wear and Tear is an Operational and Maintenace cost (fuel cost per mile not included) established at time of offer and shall remain at same cost established at the time of offer. The Offeror may include an esclated price for each Option Year or remain constant throughout the contract. Once Offer is recieved this wear and tear per mile cost will not be included in the EPA. This worksheet is designed to isolate the delta in the price of fuel and edit CLIN 0002 (1002, 2002, 3002, 4002) accordingly.
| ***IF the Green highlight areas, which are blocks B1, B2, B3, B5, B10, B12, B24, B36, B48, and B60 are not filled, then this requirement for the submission of an offer will be considered non-complaint and will result in eliminated from competition for Award. *** | Month 1 | ||||||
| Price Per mile (Start) | Month 2 | ||||||
| Wear and tear Per Mile | Month 3 | ||||||
| Mileage Rate (Current) | Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | |||
| Avg Fuel Cost for Quarter (End) | AFC | ||||||
| Price Per mile (End) | |||||||
| Mileage Rate (Proposed) |
| Option Year 1 | Option Year 1 | ||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | ||
| Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | Mar-May | Jun-Aug | Sep-Nov | Dec-Feb | ||
| Avg Fuel Cost for Quarter (Start) | Month 1 | ||||||||
| Price Per mile (Start) | Month 2 | ||||||||
| Wear and tear Per Mile | Month 3 | ||||||||
| Mileage Rate (Current) | Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | |||||
| Avg Fuel Cost for Quarter (End) | AFC | ||||||||
| Price Per mile (End) | |||||||||
| Mileage Rate (Proposed) |
| Option Year 2 | Option Year 2 | ||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | ||
| Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | Mar-May | Jun-Aug | Sep-Nov | Dec-Feb | ||
| Avg Fuel Cost for Quarter (Start) | Month 1 | ||||||||
| Price Per mile (Start) | Month 2 | ||||||||
| Wear and tear Per Mile | Month 3 | ||||||||
| Mileage Rate (Current) | Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | |||||
| Avg Fuel Cost for Quarter (End) | AFC | ||||||||
| Price Per mile (End) | |||||||||
| Mileage Rate (Proposed) |
| Option Year 3 | Option Year 3 | ||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | ||
| Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | Mar-May | Jun-Aug | Sep-Nov | Dec-Feb | ||
| Avg Fuel Cost for Quarter (Start) | Month 1 | ||||||||
| Price Per mile (Start) | Month 2 | ||||||||
| Wear and tear Per Mile | Month 3 | ||||||||
| Mileage Rate (Current) | Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | |||||
| Avg Fuel Cost for Quarter (End) | AFC | ||||||||
| Price Per mile (End) | |||||||||
| Mileage Rate (Proposed) |
| Option Year 4 | Option Year 4 | ||||||||
| Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | ||
| Jun-Aug | Sep-Nov | Oct-Dec | Jan-Mar | Mar-May | Jun-Aug | Sep-Nov | Dec-Feb | ||
| Avg Fuel Cost for Quarter (Start) | Month 1 | ||||||||
| Price Per mile (Start) | Month 2 | ||||||||
| Wear and tear Per Mile | Month 3 | ||||||||
| Mileage Rate (Current) | Jun-Aug | Sep-Nov | Dec-Feb | Mar-May | |||||
| Avg Fuel Cost for Quarter (End) | AFC | ||||||||
| Price Per mile (End) | |||||||||
| Mileage Rate (Proposed) |
EIA Data (Base)
EIA Data (OY1)
EIA Data (OY2)
EIA Data (OY3)
EIA Data (OY4) image1.png
File details come from the government source that posted it. Updated .