Bid Recap.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- FM-23-301
- Issued by
- California
About this file
This is a bid recap spreadsheet for a California state and local contract opportunity for CNG (Compressed Natural Gas) conversion systems for light and medium duty trucks under a multi-year procurement. The contract encompasses 21 line items representing various Ford truck configurations, including F-250 and F-350 pickup trucks in multiple cab styles (regular, super, and crew cab) and configurations (2WD and 4WD), as well as F-250 and F-350 service bed trucks, and F-550 service bed trucks. Each line item specifies a quantity of 5 units and includes pricing from two bidders: Landi Renzo and an unnamed Model 1 bidder. The bid recap provides unit costs and total costs for comparison purposes, with unit costs ranging from $15,900 to $38,900 depending on truck type and configuration.
The total bid values show significant price variation between the two bidders, with the Model 1 bidder's total of $2,114,500 compared to Landi Renzo's total of $2,547,923 across all line items. The spreadsheet follows a standardized upload format requiring specific fields including unique item numbers, print sequences, item type designation, descriptions, quantities, units of measure, and NIGP class identification. This appears to be a vehicle procurement for a governmental fleet conversion to cleaner-burning CNG technology, with the bid recap serving as a formal comparison document for evaluating competing proposals from multiple vendors offering similar truck configurations and specifications.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| NOI to Award ITB FM-23-301.pdf | ||
| 7-01-2023 Appendix A - Multi Year Package Specs FY-23_~2.docx | DOCX document | |
| ITB Attachments~3.pdf | ||
| ITB FM-23-301 Addendum 2 .pdf | ||
| 7-03-2023 CNG Conversion Specs Appendix B.docx | DOCX document | |
| ITB FM-23-301 Addendum .pdf | ||
| ITB FM 23-301 CNG Conversion Review~3.pdf | ||
| CNG Conversion 23 - Item Export ~1.xlsx | XLSX spreadsheet |
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
Item_Export_Upload_Example_inst
| Model 1 | Landi Renzo | |||||||||||
| Item Number | Print Sequence | Item Type | Stock Item Number | Description | Disable Pricing on Quote | Fixed Asset | Quantity | UOM | Unit Cost | Total | Unit Cost | Total |
| FORD F-250 XL, 2WD SUPER CAB PICK UP, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 15,900 | $ 79,500 | ||||||
| FORD F-250, 2WD CREW CAB PICK UP, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 15,900 | $ 79,500 | ||||||
| FORD F-250, 4WD REGULAR CAB PICK UP, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 15,900 | $ 79,500 | ||||||
| FORD F-250, 4WD SUPER CAB PICK UP, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 15,900 | $ 79,500 | ||||||
| FORD F-250, 4WD CREW CAB PICK UP, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 15,900 | $ 79,500 | ||||||
| FORD F-350, 2WD REGULAR CAB PICK UP, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 17,900 | $ 89,500 | ||||||
| FORD F-350, 2WD REGULAR CAB PICK UP, CNG | 5 | EA | $24,114.15 | $120,570.75 | $ 17,900 | $ 89,500 | ||||||
| FORD F-350, 2WD SUPER CAB PICK UP, CNG | 5 | EA | $24,114.15 | $120,570.75 | $ 17,900 | $ 89,500 | ||||||
| FORD F-350, 4WD REGULAR CAB PICK UP, CNG | 5 | EA | $24,114.15 | $120,570.75 | $ 17,900 | $ 89,500 | ||||||
| FORD F-350, 4WD SUPER CAB PICK UP, CNG | 5 | EA | $24,114.15 | $120,570.75 | $ 17,900 | $ 89,500 | ||||||
| FORD F-350, 4WD CREW CAB PICK UP, CNG | 5 | EA | $24,114.15 | $120,570.75 | $ 17,900 | $ 89,500 | ||||||
| FORD F-350, 4WD CREW CAB PICK UP, CNG | 5 | EA | $24,114.15 | $120,570.75 | $ 17,900 | $ 89,500 | ||||||
| FORD F-250 REGULAR CAB SERVICE BED TRUCK, CNG | 5 | EA | $24,114.15 | $120,570.75 | $ 15,900 | $ 79,500 | ||||||
| FORD F-250 SUPER CAB SERVICE BED TRUCK, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 15,900 | $ 79,500 | ||||||
| FORD F-250, CREW CAB SERVICE BED TRUCK, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 15,900 | $ 79,500 | ||||||
| FORD F-350, REGULAR CAB SERVICE BED TRUCK, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 17,900 | $ 89,500 | ||||||
| FORD F-350 SUPER CAB SERVICE BED TRUCK, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 17,900 | $ 89,500 | ||||||
| FORD F-350, CREW CAB SERVICE BED TRUCK, CNG | 5 | EA | $23,931.45 | $119,657.25 | $ 17,900 | $ 89,500 | ||||||
| FORD F-550, REGULAR CAB SERVICE BED TRUCK, CNG | 5 | EA | $25,846.51 | $129,232.55 | $ 38,900 | $ 194,500 | ||||||
| FORD F-550, SUPER CAB SERVICE BED TRUCK , CNG | 5 | EA | $25,846.51 | $129,232.55 | $ 38,900 | $ 194,500 | ||||||
| FORD F-550, CREW CAB SERVICE BED TRUCK, CNG | 5 | EA | $25,846.51 | $129,232.55 | $ 38,900 | $ 194,500 |
| $ 2,547,923 | $ 2,114,500 | |
| INSTRUCTIONS ON COMPLETING AN ITEM UPLOAD: |
| Required Fields | Must Contain |
| Item Number | unique, numeric value no greater than 4 digits |
| Print Sequence | numeric value equal to 'Item Number' |
| Item Type | must be the letter 'I' |
| Description | alphanumeric |
| Quantity | numeric value |
| Unit of Measure | Reference tab below |
| NIGP Class ID | numeric value, 3 digits |
| NIGP Class Item | numeric value, 2 digits |
File must be saved as a csv
File details come from the government source that posted it. Updated .