D.2 EPA Fuel Surcharge Calculator.xlsx
XLSX spreadsheet 151 KB Posted
- Attached to
- V226--Wheelchair Transport (Cleveland)
- Solicitation number
- 36C25023R0306
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 36C25023R0306 0001.docx | DOCX document | |
| 36C25023R0306.docx | DOCX document | |
| D.3 WD 2015-4727 (R20), Cleveland, 27 Dec 2022.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 | 36C25023R0305 | |||||||||
| Contract Title | Wheelchair Service (Cleveland VAMC) | |||||||||
| Period Of Performance | 1 April 2023 to 31 March 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 | |||
| Apr-June | Jul-Sep | Oct-Dec | Jan-Mar | Nov-Jan | Feb-Apr | May-July | Aug-Sep | |||
| Avg Fuel Cost for Quarter (Start) | 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 + Month 3) / 3 = AFC https://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_m.htm
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 | $5.255 | ||||||
| Price Per mile (Start) | Month 2 | $4.714 | ||||||
| Wear and tear Per Mile | Month 3 | $4.576 | ||||||
| Mileage Rate (Current) | Apr-June | Jul-Sep | Oct-Dec | Jan-Mar | ||||
| Avg Fuel Cost for Quarter (End) | AFC | $4.85 | ||||||
| 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 | ||
| Apr-June | Jul-Sep | Oct-Dec | Jan-Mar | Nov-Jan | Feb-Apr | May-July | Aug-Sep | ||
| Avg Fuel Cost for Quarter (Start) | Month 1 | ||||||||
| Price Per mile (Start) | Month 2 | ||||||||
| Wear and tear Per Mile | Month 3 | ||||||||
| Mileage Rate (Current) | Apr-June | Jul-Sep | Oct-Dec | Jan-Mar | |||||
| 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 | ||
| Apr-June | Jul-Sep | Oct-Dec | Jan-Mar | Nov-Jan | Feb-Apr | May-July | Aug-Sep | ||
| Avg Fuel Cost for Quarter (Start) | Month 1 | ||||||||
| Price Per mile (Start) | Month 2 | ||||||||
| Wear and tear Per Mile | Month 3 | ||||||||
| Mileage Rate (Current) | Apr-June | Jul-Sep | Oct-Dec | Jan-Mar | |||||
| Avg Fuel Cost for Quarter (End) | AFC | ||||||||
| Price Per mile (End) | |||||||||
| Mileage Rate (Proposed) |
EIA Data (Base)
EIA Data (OY1)
EIA Data (OY2) image1.png
File details come from the government source that posted it. Updated .