PRICE_PAGE.xlsx
XLSX spreadsheet 185 KB Posted
- Solicitation number
- 226060
- Issued by
- Pima County, Tucson City, Arizona
About this file
The document is a Price Page Excel spreadsheet for an Invitation for Bid (IFB 171592) issued by the City of Tucson for Light and Heavy-Duty Vehicle Transmission Rebuild or Exchange Unit Service. The contract is structured across four distinct groups covering automatic transmissions from General Motors, Chrysler Corporation, Ford Motor Company, and Allison, with the City's Environmental and General Services Department - Fleet Services Division as the primary user. The solicitation allows bidders to bid on one or more groups, with the intent to award two positions per group to the lowest and second-lowest responsive and responsible bidders. Estimated annual quantities vary by transmission type, ranging from 2 to 15 units per line item across the different groups.
The pricing structure requires bidders to provide unit prices for rebuilt base bid torque converters, removal and replacement labor, and additional parts for each transmission type. The document includes provisions for percentage discounts on unlisted parts, hourly labor rates for non-standard repairs, warranty information, and parts brand specification. The solicitation is designed as an annual requirements contract, allowing the City of Tucson flexibility in procuring transmission rebuild and exchange services across multiple vehicle manufacturers and transmission types. Each group includes detailed line items for specific transmission models, with bidders expected to complete pricing in highlighted yellow cells of the Excel spreadsheet.
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
GROUP 1
| GROUP 1 – GENERAL MOTORS AUTOMATIC TRANSMISSIONS | ||||
| Instructions: Provide pricing in the highlighted yellow cell for each item. Your bid must be inclusive of all items. | ||||
| Item No. | Description | Unit Price | Estimated Annual Quantity | Extended Total |
| 1 | 4L60-E | |||
| 1a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 1b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 1c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| ITEM 1 TOTAL | 0.00 | |||
| 2 | 4L65-E | |||
| 2a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 2b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Front Pump | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 2c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| ITEM 2 TOTAL | 0.00 | |||
| 3 | 4L80-E | |||
| 3a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 6 | 0.00 | |
| 3b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 6 | 0.00 | |
| 3c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 6 | 0.00 | |
| ITEM 3 TOTAL | 0.00 | |||
| 4 | 4L85-E | |||
| 4a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 15 | 0.00 | |
| 4b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 10 | 0.00 | |
| 4c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 15 | 0.00 | |
| ITEM 4 TOTAL: | 0.00 |
GROUP 1 TOTAL (Sum of Items 1 – 4 Extended Totals): 0.00
5 Percent Discount Off of Parts (Not Listed): %
6 Hourly Labor Rate for Non-Standard Repairs: $
7 State the Warranty for Group 1 Transmissions:
8 State the Brand of Parts Bidding:
&"Arial,Bold"IFB 171592
GROUP 1
&"Arial,Bold"ATTACHMENT 1
&"Arial,Bold Italic"NOTE: Enter price in the yellow higlighted Unit Price cells. &"Arial,Bold"EXCEL PRICE PAGE
GROUP 2
| GROUP 2 – CHRYSLER CORPORATION AUTOMATIC TRANSMISSIONS | ||||
| Instructions: Provide pricing in the highlighted yellow cell for each item. Your bid must be inclusive of all items. | ||||
| Item No. | Description | Unit Price | Estimated Annual Quantity | Extended Total |
| 1 | 45RFE | |||
| 1a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 1b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 1c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| ITEM 1 TOTAL | 0.00 | |||
| 2 | 545RFE | |||
| 2a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 2b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 2c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| ITEM 2 TOTAL | 0.00 | |||
| 3 | 40TE | |||
| 3a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 3b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 3c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| ITEM 3 TOTAL | 0.00 | |||
| 4 | 41TE | |||
| 4a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 4b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 4c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| ITEM 4 TOTAL | 0.00 |
GROUP 2 TOTAL (Sum of Items 1 – 4 Extended Totals): 0.00
5 Percent Discount Off of Parts (Not Listed): %
6 Hourly Labor Rate for Non-Standard Repairs: $
7 State the Warranty for Group 2 Transmissions:
8 State the Brand of Parts Bidding:
GROUP 2
&"Arial,Bold"ATTACHMENT 1
&"Arial,Bold Italic"NOTE: Enter price in the yellow highlighted Unit Price cells. &"Arial,Bold"EXCEL PRICE PAGE
GROUP 3
| GROUP 3 – FORD MOTOR COMPANY AUTOMATIC TRANSMISSIONS | ||||
| Instructions: Provide pricing in the highlighted yellow cell for each item. Your bid must be inclusive of all items. | ||||
| Item No. | Description | Unit Price | Estimated Annual Quantity | Extended Total |
| 1 | 4R70E | |||
| 1a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 1b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 1c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| ITEM 1 TOTAL | 0.00 | |||
| 2 | 4R75E | |||
| 2a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 2b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Front Pump | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 2c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| ITEM 2 TOTAL | 0.00 | |||
| 3 | 4R100 | |||
| 3a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 15 | 0.00 | |
| 3b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 15 | 0.00 | |
| 3c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 15 | 0.00 | |
| ITEM 3 TOTAL | 0.00 | |||
| 4 | 5R110W | |||
| 4a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 4b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 4c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| ITEM 4 TOTAL | 0.00 | |||
| 5 | 5R110 TORQSHIFT | |||
| 5a. | Rebuilt Base Bid | |||
| Torque Converter | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 5b. | Additional Parts, if required |
(list discounted price):
| Front Pump | ||||
| Planetary Unit | ||||
| Ring Gear | ||||
| Direct Drum | ||||
| Rear Mount | ||||
| Input Shaft | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 5c. | Rebuilt Exchange Transmission | |||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| ITEM 5 TOTAL: | 0.00 |
GROUP 3 TOTAL (Sum of Items 1 – 5 Extended Totals): 0.00
6 Percent Discount Off of Parts (Not Listed): %
7 Hourly Labor Rate for Non-Standard Repairs: $
8 State the Warranty for Group 3 Transmissions:
9 State the Brand of Parts Bidding:
GROUP 3
&"Arial,Bold"ATTACHMENT 1
&"Arial,Bold Italic"NOTE: Enter price in the yellow highlighted Unit Price cells. &"Arial,Bold"EXCEL PRICE PAGE
GROUP 4
| GROUP 4 – ALLISON AUTOMATIC TRANSMISSIONS, EXCHANGE UNITS ONLY | ||||
| Instructions: Provide pricing in the highlighted yellow cell for each item. Your bid must be inclusive of all items. | ||||
| Item No. | Description | Unit Price | Estimated Annual Quantity | Extended Total |
| 1 | HT 750 DR Automatic | |||
| Rebuilt Exchange | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 4 | 0.00 | |
| 2 | HT 740 RS | |||
| Rebuilt Exchange | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 5 | 0.00 | |
| 3 | HT 754 CR | |||
| Rebuilt Exchange | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 4 | 0.00 | |
| 4 | MD 3060P | |||
| Rebuilt Exchange | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 5 | MD 3560P | |||
| Rebuilt Exchange | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 3 | 0.00 | |
| 6 | HD 4060P | |||
| Rebuilt Exchange | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 | |
| 7 | HD 4560P | |||
| Rebuilt Exchange | ||||
| R & R Labor | ||||
| Subtotal | 0.00 | 2 | 0.00 |
GROUP 4 TOTAL (Sum of Items 1 – 7 Extended Totals) 0.00
8 Discount Off Parts Price List for Additional Repairs: %
9 Hourly Labor Rate: $
10 State the Warranty for Group 4 Transmissions:
11 State the Brand of Parts Bidding:
GROUP 4 &"Arial,Bold"ATTACHMENT 1
&"Arial,Bold Italic"NOTE: Enter price in the yellow highlighted Unit Price cells. &"Arial,Bold"EXCEL PRICE PAGE
File details come from the government source that posted it. Updated .