Form C Price Response Spreadsheet RFP10_20.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- MBTA Lease & Service of Transit Bus Tires, and, Inspection, Servicing & Cleaning of Used Bus Wheels
- Solicitation number
- BD-19-1206-40000-40000-47352
- Issued by
- Suffolk County, Massachusetts
About this file
This document is a price response spreadsheet related to RFP 10-20 for the Massachusetts Bay Transportation Authority (MBTA) seeking bids for the lease and service of transit bus tires, as well as the inspection, servicing, and cleaning of used bus wheels. The spreadsheet outlines the estimated mileage, tire sizes, and quantities for Years 1-5, including option years. It provides line items for rates per mile, monthly service fees, wheel refinishing, and new wheel costs. The contract term is 3 years with two 1-year option periods.
The pricing spreadsheet indicates the annual increase in the rate per vehicle mile and monthly service fee will not exceed 2.5%. It also defines "unusable wheel cost" as the cost associated with every step in the wheel refinishing process, including inspection, up to the point of determining the integrity of the wheel to be refinished or scrapped. No other salient pricing, funding, or set-aside information is provided.
View the file
Other files
Show all 14
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
Year One
| RFP 10-20 | Enter rates in Column F, only | |||
| Form C | BID FORM CALCULATIONS SHEET – YEAR ONE | |||
| Year One | Tire Size - Six Wheel Vehicle Mile | Estimated Number of Miles | Rate per Mile | Year One Mileage Cost |
| 305/70R 22.5 | 24,260,000 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year One Mileage Cost |
| 305/70R 22.5 | 1,240,000 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year One Mileage Cost |
| 315/80R 22.5 | 1,200,000 | $ - 0 |
| Monthly Service Fee – on-site | Bid Price per month | Year One Service Fee |
| Inspections, inventories, reports, etc. and off-site inspections, | $ - 0 | |
| repairs, dismounts, mounts, shipping, etc. |
| Wheel Refinishing | Estimated Number of Wheels | Bid Price per wheel | Year One Refinished Wheel Cost |
| 5,720 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year One Wheel Cost |
| Accurate P/N 28440-PKBLK21 | 1,270 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year One Wheel Cost |
| Wheels Now P/N WN225900-10M | 30 | $ - 0 |
| Unusable Wheel Cost (post shipment to Wheel Refinisher) | Estimated Number of Wheels | Bid Price per wheel | Year One Unusable Wheel Cost (post shipment to Wheel Refinisher) |
| 745 | $ - 0 |
| TOTAL Year 1 Cost |
| $ - 0 |
TOTAL:
| Note: The annual increase in the Rate per Vehicle Mile and Monthly Service Fee will not increase by more than 2.5%. |
| Note: "Unusable Wheel Cost" correlates to every step in the refinishing process, including inspection, up to the point of determing the integrity of the wheel to be refinished or scrapped. |
Year Two
| RFP 10-20 | Enter rates in Column F, only | |||
| Form C | BID FORM CALCULATIONS SHEET – YEAR TWO | |||
| Year Two | Tire Size - Six Wheel Vehicle Mile | Estimated Number of Miles | Rate per Mile | Year Two Mileage Cost |
| 305/70R 22.5 | 24,602,540 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year Two Mileage Cost |
| 305/70R 22.5 | 1,240,000 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year Two Mileage Cost |
| 315/80R 22.5 | 1,240,000 | $ - 0 |
| Monthly Service Fee – on-site | Bid Price per month | Year Two Service Fee |
| Inspections, inventories, reports, etc. and off-site inspections, | $ - 0 | |
| repairs, dismounts, mounts, shipping, etc. |
| Wheel Refinishing | Estimated Number of Wheels | Bid Price per wheel | Year Two Refinished Wheel Cost |
| 5,720 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year Two Wheel Cost |
| Accurate P/N 28440-PKBLK21 | 1,270 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year Two Wheel Cost |
| Wheels Now P/N WN225900-10M | 30 | $ - 0 |
| Unusable Wheel Cost (post shipment to Wheel Refinisher) | Estimated Number of Wheels | Bid Price per wheel | Year Two Unusable Wheel Cost (post shipment to Wheel Refinisher) |
| 745 | $ - 0 |
| TOTAL Year 2 Cost |
| $ - 0 |
TOTAL:
| Note: The annual increase in the Rate per Vehicle Mile and Monthly Service Fee will not increase by more than 2.5%. |
| Note: "Unusable Wheel Cost" correlates to every step in the refinishing process, including inspection, up to the point of determing the integrity of the wheel to be refinished or scrapped. |
Year Three
| RFP 10-20 | Enter rates in Column F, only | |||
| Form C | BID FORM CALCULATIONS SHEET – YEAR THREE | |||
| Year Three | Tire Size - Six Wheel Vehicle Mile | Estimated Number of Miles | Rate per Mile | Year Three Mileage Cost |
| 305/70R 22.5 | 24,602,540 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year Three Mileage Cost |
| 305/70R 22.5 | 1,240,000 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year Three Mileage Cost |
| 315/80R 22.5 | 1,240,000 | $ - 0 |
| Monthly Service Fee – on-site | Bid Price per month | Year Three Service Fee |
| Inspections, inventories, reports, etc. and off-site inspections, | $ - 0 | |
| repairs, dismounts, mounts, shipping, etc. |
| Wheel Refinishing | Estimated Number of Wheels | Bid Price per wheel | Year Three Refinished Wheel Cost |
| 5,720 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year Three Wheel Cost |
| Accurate P/N 28440-PKBLK21 | 1,270 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year Three Wheel Cost |
| Wheels Now P/N WN225900-10M | 30 | $ - 0 |
| Unusable Wheel Cost (post shipment to Wheel Refinisher) | Estimated Number of Wheels | Bid Price per wheel | Year Three Unusable Wheel Cost (post shipment to Wheel Refinisher) |
| 745 | $ - 0 |
| TOTAL Year 3 Cost |
| $ - 0 |
TOTAL:
| Note: The annual increase in the Rate per Vehicle Mile and Monthly Service Fee will not increase by more than 2.5%. |
| Note: "Unusable Wheel Cost" correlates to every step in the refinishing process, including inspection, up to the point of determing the integrity of the wheel to be refinished or scrapped. |
Year Four Option
| RFP 10-20 | Enter rates in Column F, only | |||
| Form C | BID FORM CALCULATIONS SHEET – YEAR FOUR OPTION | |||
| Year Four Option | Tire Size - Six Wheel Vehicle Mile | Estimated Number of Miles | Rate per Mile | Year Four Mileage Cost |
| 305/70R 22.5 | 24,602,540 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year Four Mileage Cost |
| 305/70R 22.5 | 1,240,000 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year Four Mileage Cost |
| 315/80R 22.5 | 1,240,000 | $ - 0 |
| Monthly Service Fee – on-site | Bid Price per month | Year Four Service Fee |
| Inspections, inventories, reports, etc. and off-site inspections, | $ - 0 | |
| repairs, dismounts, mounts, shipping, etc. |
| Wheel Refinishing | Estimated Number of Wheels | Bid Price per wheel | Year Four Refinished Wheel Cost |
| 5,720 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year Four Wheel Cost |
| Accurate P/N 28440-PKBLK21 | 1,270 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year Four Wheel Cost |
| Wheels Now P/N WN225900-10M | 30 | $ - 0 |
| Unusable Wheel Cost (post shipment to Wheel Refinisher) | Estimated Number of Wheels | Bid Price per wheel | Year Four Unusable Wheel Cost (post shipment to Wheel Refinisher) |
| 745 | $ - 0 |
| TOTAL Year 4 Option Cost |
| $ - 0 |
TOTAL:
| Note: The annual increase in the Rate per Vehicle Mile and Monthly Service Fee will not increase by more than 2.5%. |
| Note: "Unusable Wheel Cost" refers to every step in the refinishing process, including inspection, up to the point of determing the integrity of the wheel to be refinished or scrapped. |
Year 5 Option
| RFP 10-20 | Enter rates in Column F, only | |||
| Form C | BID FORM CALCULATIONS SHEET – YEAR FIVE OPTION | |||
| Year Five Option | Tire Size - Six Wheel Vehicle Mile | Estimated Number of Miles | Rate per Mile | Year Five Mileage Cost |
| 305/70R 22.5 | 24,602,540 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year Five Mileage Cost |
| 305/70R 22.5 | 1,240,000 | $ - 0 |
| Rate Per Ten Wheel Vehicle Mile – | Estimated Number of Miles | Rate per Mile | Year Five Mileage Cost |
| 315/80R 22.5 | 1,240,000 | $ - 0 |
| Monthly Service Fee – on-site | Bid Price per month | Year Five Service Fee |
| Inspections, inventories, reports, etc. and off-site inspections, | $ - 0 | |
| repairs, dismounts, mounts, shipping, etc. |
| Wheel Refinishing | Estimated Number of Wheels | Bid Price per wheel | Year Five Refinished Wheel Cost |
| 5,720 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year Five Wheel Cost |
| Accurate P/N 28440-PKBLK21 | 1,270 | $ - 0 |
| New Wheel Cost | Estimated Number of Wheels | Bid Price per wheel | Year Five Wheel Cost |
| Wheels Now P/N WN225900-10M | 30 | $ - 0 |
| Unusable Wheel Cost (post shipment to Wheel Refinisher) | Estimated Number of Wheels | Bid Price per wheel | Year Five Unusable Wheel Cost (post shipment to Wheel Refinisher) |
| 745 | $ - 0 |
| TOTAL Year 5 Option Cost |
| $ - 0 |
TOTAL:
| Note: The annual increase in the Rate per Vehicle Mile and Monthly Service Fee will not increase by more than 2.5%. |
| Note: "Unusable Wheel Cost" correlates to every step in the refinishing process, including inspection, up to the point of determing the integrity of the wheel to be refinished or scrapped. |
File details come from the government source that posted it. Updated .