bid worksheet.xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- 005-RFB-3021-2027
- Issued by
- Polk County, Iowa
About this file
This is a Vehicle Data Sheet and bid worksheet for Iowa Department of Administrative Services (DAS) Fleet Services, which is soliciting bids from dealerships for the supply of 2027 Light Duty Trucks, specifically Chevrolet Colorado or equivalent vehicles. The procurement encompasses two vehicle categories: LDT 1 (Standard 4X2 Work Truck with Extended Cab and Automatic Transmission) and LDT 2 (Standard 4X4 Work Truck with Extended Cab and Automatic Transmission). Dealers must submit pricing for each vehicle specification using the provided Excel worksheet, with final bid prices entered in yellow-highlighted fields. Submission requirements include one electronic copy of the completed Vehicle Specification Worksheets in Excel format and one electronic copy of the completed RFB Criteria document. Delivery is required to the Department of Administrative Services Fleet Services at 510 E. 12th Street, Des Moines, Iowa 50319.
Base vehicle specifications for both categories include a turbocharged inline 4-cylinder engine with E85 FFV capability if available, minimum 6,000 lb. GVWR, minimum 130-inch wheelbase, and 60-inch bed cargo box. Both configurations require power door locks with remote keyless entry, power windows, air conditioning, factory or dealer-installed Bluetooth and radio with advanced color LCD display, power brakes with 4-wheel anti-lock capability, rearview camera, and all-season tires. The 4X4 model additionally requires a transfer case with automatic 4WD engagement capability and independent front suspension with leaf rear suspension. Dealers must price the base vehicle and separately price optional items including engine block heater, upgraded alternator, additional key fobs, 110-volt power outlet, bed liners, bed inserts, bed mats, cargo tie downs, mud flaps, recovery hooks, running boards, tonneau covers, trailer brake controller, trailer tow mirrors, trailer tow package, convenience packages, custom packages, alarm systems, and reverse sensing systems. Dealers may offer a discount percentage off MSRP for optional items $3,000 or less, with engine and powertrain options excluded from discount eligibility. Delivery costs are calculated based on FOB pricing per mile for delivery anywhere in Iowa, with specific mileage to be entered by the dealer for delivery to Des Moines.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1433684-event.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
cover
| Vehicle Data Sheets for 2027 Light Duty Truck Chevrolet Colorado or equivalent |
| This Vehicle Specification Worksheets will be used by the dealer to calculate their cost for each of the vehicle items they intend to bid. Please notice the tabs along the bottom correspond to the outline pictured below. This provides an outline of the items that are being bid in this Vehicle Data Sheet. The price located in the yellow highlighted field in each specification will be considered the dealer's final price submission for each respective vehicle specification. |
Once the dealer has entered all the pricing information into the Vehicle Specification Worksheets, the Dealer will submit one electronic copy of the Vehicle Specification Worksheets in Excel format along with one electronic copy of their Vehicle Specification Worksheets. Dealers will also have to submit one electronic copy of their completed RFB Criteria document.
| All vehicle specifications are designed for single vehicle pricing | ||
| Category | Group # | Vehicle Mfg. and Model |
Light Duty Truck LDT 1 LDT 1 Standard 4X2 Work Truck
LDT 2 LDT 2 Standard 4X4 Work Truck
LDT 1
| LDT 1 Standard 4X2 Work Truck | 4X2 | ||
| Extended Cab - Automatic Transmission | Make: | ||
| Model Name: | |||
| Example - Chevy Colorado | Exact Model Code: | ||
| Trim Pkg. Common Name: | |||
| Exact Trim Pkg. Code: | |||
| Engine Code: | |||
| Transmission Code: | |||
| Payload Capacity: | |||
| Towing Capacity: | |||
| BASE VEHICLE SPECIFICATIONS | |||
| Body & Chassis | Minimum Requirements | Mfg. Codes - Specs (Note STD for standard) | |
| Gross Vehicle Weight Rating (4X2) | 6,000 lb. GVWR minimum | STATE GVWR: | |
| Wheelbase length | Minimum 130 inches | STATE LENGTH: | |
| Bed | Cargo box length mininum 60" | STATE LENGTH: | |
| Engine | |||
| Engine | Turbocharged inline 4 cylinder Engine, E85 FFV engine if available; include all required options and other pertinent information. | Cylinders: Liters: | HP: Torque: |
| E85 FFV Engine? | |||
| Drive Axle | |||
| Rear Axle | Locking differential must be provided if available; limited slip acceptable if locking differential not available. 3.42 ratio | STATE RATIO: | Locking or limited slip provided? |
| Electrical | |||
| Power Point | Located in Driver Area | ||
| Doors & Windows | |||
| Doors | Power door locks with remote keyless entry | STD | |
| Key Sets / Fobs | 2 Fobs with push button start; 2 keys and fobs w/o push button start | ||
| Windows | Power | ||
| Windows | Rear Defroster, if available must provide | Rear Defroster Included? | |
| Wipers | Intermittent | ||
| Exterior | |||
| Bumper | Corner Step | ||
| License Plate Holders | Front and Rear license plate holders | ||
| Mirrors | Power, if available must provide | Power included? | |
| Tailgate | Locking, if not standard | ||
| Flooring | |||
| Floor Covering | Full floor covering, rubber or vinyl acceptable. | ||
| Interior | |||
| Air Conditioning | AC with all required options. | ||
| Bluetooth | Factory preferred but dealer installed acceptable | ||
| Radio | Diagnal advanced color LCD display. Apple CarPlay and Android Auto. | ||
| Steering Column | Tilt / Cruise Control | ||
| Trim Package | Interior, with insulating headliner, full door and back of cab panels, dome lamp. Front bucket w/cloth upholstery. | ||
| Safety | |||
| Brakes | Power 4 Wheel Anti-lock | ||
| Daytime Running Lights | If available must provide | ||
| Rearview Camera | Hitch View | Factory installed? | |
| Tires & Wheels | |||
| Tires (4X2) | All Season blackwall | ||
| Spare | If available must provide | Is spare full size? |
| BASE VEHICLE PRICE CONFIGURED AS PER ABOVE FOR 4X2: | ||||
| Delivery Cost to Department of Administrative Services, Des Moines: | ||||
| TOTAL VEHICLE PRICE FOR 4X2 INCLUDING BASE COST AND DELIVERY: | Final Bid Price | |||
| LDT 1 Standard 4X2 Work Truck | Page 2 | |||
| Example - Chevy Colorado | ||||
| 0 | ||||
| ADDITIONAL OPTIONS | ||||
| Engine | Minimum Requirements | Mfg. Codes - Specs (Note STD for standard) | Cost | |
| Engine Block Heater | DEDUCT COST: | |||
| Alternator | 220 Amp | |||
| Doors & Windows | ||||
| Key Sets / Fobs, Additional | 2 Fobs with push button start; 2 keys and fobs w/o push button start | |||
| Electrical | ||||
| Power Point | Power outlet, 110 Volt; Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | |||
| Exterior | ||||
| Bed Liner | Spray In, Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Bed Insert | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Bed Mat | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Cargo Tie Downs | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Mud flaps | OEM or OEM authorized flexible heavy duty, behind all wheels. No dealer logo on mud flaps. | |||
| Recovery Hooks | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Running Boards | Tubular, Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Tonneau Cover | Soft material style, rolling or trifold; dealer installed acceptable | |||
| Tonneau Cover | Hard surface, locking; dealer installed acceptable | |||
| Trailer Brake Controller | Intergrated trailer brake controller | Factory installed? | ||
| Trailer tow mirrors | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Trailer tow package | Advanced trailering package | Factory installed? | ||
| Packages | ||||
| WT Convenience Package | Wrapped steering wheel, 8 way power seat, EZ lift tailgate & locking cylinder | Factory installed? | ||
| WT Custom Package | 18 Wheels | Factory installed? | ||
| Safety | ||||
| Alarm | Backup alarm; Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Reverse Sensing System | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Other | ||||
| Options not listed above | Discount percentage off MSRP for options $3,000 or less as specified in the Vehicle Specifications Terms and Conditions document attached to the bid. Engine and powertrain options excluded. | Enter Percentage Discount MSRP: | ||
| DELIVERY | ||||
| Delivery FOB | Price per mile to deliver vehicle anywhere in State of Iowa | Per Mile Charge | ||
| Delivery Cost | Delivery Cost to Department of Administrative Services Fleet Services, 510 E. 12th Street, Des Moines, IA 50319 | Enter miles in whole number: |
LDT 2
| LDT 2 Standard 4X4 Work Truck | 4X4 | ||
| Extended Cab - Automatic Transmission | Make: | ||
| Model Name: | |||
| Example - Chevy Colorado | Exact Model Code: | ||
| Trim Pkg. Common Name: | |||
| Exact Trim Pkg. Code: | |||
| Engine Code: | |||
| Transmission Code: | |||
| Payload Capacity: | |||
| Towing Capacity: | |||
| BASE VEHICLE SPECIFICATIONS | |||
| Body & Chassis | Minimum Requirements | Mfg. Codes - Specs (Note STD for standard) | |
| Gross Vehicle Weight Rating (4X4) | 6,000 lb. GVWR minimum | STATE GVWR: | |
| Wheelbase length | Minimum 130 inches | STATE LENGTH: | |
| Bed | Cargo box length mininum 60" | STATE LENGTH: | |
| Engine | |||
| Engine | Turbocharged inline 4 cylinder Engine, E85 FFV engine if available; include all required options and other pertinent information. | Cylinders: Liters: | HP: Torque: |
| E85 FFV Engine? | |||
| Drive Axle | |||
| Rear Axle | Locking differential must be provided if available; limited slip acceptable if locking differential not available. 3.42 ratio | STATE RATIO: | Locking or limited slip provided? |
| Transfer Case (4X4) | 4-button control 2WD, Auto, 4WD, 4WD LO | ||
| Transfer Case (4X4) | Automatically engages 4WD until traction is regained | ||
| Electrical | |||
| Power Point | Located in Driver Area | ||
| Doors & Windows | |||
| Doors | Power door locks with remote keyless entry | ||
| Key Sets / Fobs | 2 Fobs with push button start; 2 keys and fobs w/o push button start | ||
| Windows | Power | ||
| Windows | Rear Defroster, if available must provide | Rear Defroster Included? | |
| Wipers | Intermittent | ||
| Exterior | |||
| Bumper | Corner Step | ||
| License Plate Holders | Front and Rear license plate holders | ||
| Mirrors | Power, if available must provide | Power included? | |
| Tailgate | Locking, if not standard | ||
| Flooring | |||
| Floor Covering | Full floor covering, rubber or vinyl acceptable. | ||
| Interior | |||
| Air Conditioning | AC with all required options. | ||
| Bluetooth | Factory preferred but dealer installed acceptable | ||
| Radio | Diagnal advanced color LCD display. Apple CarPlay and Android Auto. | ||
| Steering Column | Tilt / Cruise Control | ||
| Trim Package | Interior, with insulating headliner, full door and back of cab panels, dome lamp. Front bucket w/cloth upholstery. | ||
| Safety | |||
| Brakes | Power 4 Wheel Anti-lock | ||
| Daytime Running Lights | If available must provide | ||
| Rearview Camera | Hitch View | Factory installed? | |
| Suspension | |||
| Suspension | Independent front, leaf rear | ||
| Tires & Wheels | |||
| Tires (4X4) | All season blackwall | ||
| Spare | If available must provide | Is spare full size? |
| BASE VEHICLE PRICE CONFIGURED AS PER ABOVE FOR 4X4: | ||||
| Delivery Cost to Department of Administrative Services, Des Moines: | ||||
| TOTAL VEHICLE PRICE FOR 4X4 INCLUDING BASE COST AND DELIVERY: | Final Bid Price | |||
| LDT 2 Standard 4X4 Work Truck | Page 2 | |||
| Example - Chevy Colorado | ||||
| 0 | ||||
| ADDITIONAL OPTIONS | ||||
| Engine | Minimum Requirements | Mfg. Codes - Specs (Note STD for standard) | Cost | |
| Engine Block Heater | DEDUCT COST: | |||
| Alternator | 220 Amp | |||
| Doors & Windows | ||||
| Key Sets / Fobs, Additional | 2 Fobs with push button start; 2 keys and fobs w/o push button start | |||
| Electrical | ||||
| Power Point | Power outlet, 110 Volt; Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | |||
| Exterior | ||||
| Bed Liner | Spray In, Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Bed Insert | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Bed Mat | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Cargo Tie Downs | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Mud flaps | OEM or OEM authorized flexible heavy duty, behind all wheels. No dealer logo on mud flaps. | |||
| Recovery Hooks | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Running Boards | Tubular, Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Tonneau Cover | Soft material style, rolling or trifold; dealer installed acceptable | |||
| Tonneau Cover | Hard surface, locking; dealer installed acceptable | |||
| Trailer Brake Controller | Intergrated trailer brake controller | Factory installed? | ||
| Trailer tow mirrors | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Trailer tow package | Advanced trailering package | Factory installed? | ||
| Packages | ||||
| WT Convenience Package | Wrapped steering wheel, 8 way power seat, EZ lift tailgate & locking cylinder | Factory installed? | ||
| WT Custom Package | 18 Wheels | Factory installed? | ||
| Safety | ||||
| Alarm | Backup alarm; Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed?DI | ||
| Reverse Sensing System | Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available. | Factory installed? | ||
| Other | ||||
| Options not listed above | Discount percentage off MSRP for options $3,000 or less as specified in the Vehicle Specifications Terms and Conditions document attached to the bid. Engine and powertrain options excluded. | Enter Percentage Discount MSRP: | ||
| DELIVERY | ||||
| Delivery FOB | Price per mile to deliver vehicle anywhere in State of Iowa | Per Mile Charge | ||
| Delivery Cost | Delivery Cost to Department of Administrative Services Fleet Services, 510 E. 12th Street, Des Moines, IA 50319 | Enter miles in whole number: |
File details come from the government source that posted it. Updated .