bid worksheet.xlsx

XLSX spreadsheet 26 KB Posted

Attached to
2027 Light Duty Truck Chevrolet Colorado or equivalent
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 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
CategoryGroup #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 Truck4X2
Extended Cab - Automatic TransmissionMake:
Model Name:
Example - Chevy ColoradoExact Model Code:
Trim Pkg. Common Name:
Exact Trim Pkg. Code:
Engine Code:
Transmission Code:
Payload Capacity:
Towing Capacity:
BASE VEHICLE SPECIFICATIONS
Body & ChassisMinimum RequirementsMfg. Codes - Specs (Note STD for standard)
Gross Vehicle Weight Rating (4X2)6,000 lb. GVWR minimumSTATE GVWR:
Wheelbase lengthMinimum 130 inchesSTATE LENGTH:
BedCargo box length mininum 60"STATE LENGTH:
Engine
EngineTurbocharged 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 AxleLocking differential must be provided if available; limited slip acceptable if locking differential not available. 3.42 ratioSTATE RATIO:Locking or limited slip provided?
Electrical
Power PointLocated in Driver Area
Doors & Windows
DoorsPower door locks with remote keyless entrySTD
Key Sets / Fobs2 Fobs with push button start; 2 keys and fobs w/o push button start
WindowsPower
WindowsRear Defroster, if available must provideRear Defroster Included?
WipersIntermittent
Exterior
BumperCorner Step
License Plate HoldersFront and Rear license plate holders
MirrorsPower, if available must providePower included?
TailgateLocking, if not standard
Flooring
Floor CoveringFull floor covering, rubber or vinyl acceptable.
Interior
Air ConditioningAC with all required options.
BluetoothFactory preferred but dealer installed acceptable
RadioDiagnal advanced color LCD display. Apple CarPlay and Android Auto.
Steering ColumnTilt / Cruise Control
Trim PackageInterior, with insulating headliner, full door and back of cab panels, dome lamp. Front bucket w/cloth upholstery.
Safety
BrakesPower 4 Wheel Anti-lock
Daytime Running LightsIf available must provide
Rearview CameraHitch ViewFactory installed?
Tires & Wheels
Tires (4X2)All Season blackwall
SpareIf available must provideIs 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 TruckPage 2
Example - Chevy Colorado
0
ADDITIONAL OPTIONS
EngineMinimum RequirementsMfg. Codes - Specs (Note STD for standard)Cost
Engine Block HeaterDEDUCT COST:
Alternator220 Amp
Doors & Windows
Key Sets / Fobs, Additional2 Fobs with push button start; 2 keys and fobs w/o push button start
Electrical
Power PointPower outlet, 110 Volt; Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.
Exterior
Bed LinerSpray In, Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Bed InsertFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Bed MatFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Cargo Tie DownsFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Mud flapsOEM or OEM authorized flexible heavy duty, behind all wheels. No dealer logo on mud flaps.
Recovery HooksFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Running BoardsTubular, Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Tonneau CoverSoft material style, rolling or trifold; dealer installed acceptable
Tonneau CoverHard surface, locking; dealer installed acceptable
Trailer Brake ControllerIntergrated trailer brake controllerFactory installed?
Trailer tow mirrorsFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Trailer tow packageAdvanced trailering packageFactory installed?
Packages
WT Convenience PackageWrapped steering wheel, 8 way power seat, EZ lift tailgate & locking cylinderFactory installed?
WT Custom Package18 WheelsFactory installed?
Safety
AlarmBackup alarm; Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Reverse Sensing SystemFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Other
Options not listed aboveDiscount 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 FOBPrice per mile to deliver vehicle anywhere in State of IowaPer Mile Charge
Delivery CostDelivery Cost to Department of Administrative Services Fleet Services, 510 E. 12th Street, Des Moines, IA 50319Enter miles in whole number:

LDT 2

LDT 2 Standard 4X4 Work Truck4X4
Extended Cab - Automatic TransmissionMake:
Model Name:
Example - Chevy ColoradoExact Model Code:
Trim Pkg. Common Name:
Exact Trim Pkg. Code:
Engine Code:
Transmission Code:
Payload Capacity:
Towing Capacity:
BASE VEHICLE SPECIFICATIONS
Body & ChassisMinimum RequirementsMfg. Codes - Specs (Note STD for standard)
Gross Vehicle Weight Rating (4X4)6,000 lb. GVWR minimumSTATE GVWR:
Wheelbase lengthMinimum 130 inchesSTATE LENGTH:
BedCargo box length mininum 60"STATE LENGTH:
Engine
EngineTurbocharged 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 AxleLocking differential must be provided if available; limited slip acceptable if locking differential not available. 3.42 ratioSTATE 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 PointLocated in Driver Area
Doors & Windows
DoorsPower door locks with remote keyless entry
Key Sets / Fobs2 Fobs with push button start; 2 keys and fobs w/o push button start
WindowsPower
WindowsRear Defroster, if available must provideRear Defroster Included?
WipersIntermittent
Exterior
BumperCorner Step
License Plate HoldersFront and Rear license plate holders
MirrorsPower, if available must providePower included?
TailgateLocking, if not standard
Flooring
Floor CoveringFull floor covering, rubber or vinyl acceptable.
Interior
Air ConditioningAC with all required options.
BluetoothFactory preferred but dealer installed acceptable
RadioDiagnal advanced color LCD display. Apple CarPlay and Android Auto.
Steering ColumnTilt / Cruise Control
Trim PackageInterior, with insulating headliner, full door and back of cab panels, dome lamp. Front bucket w/cloth upholstery.
Safety
BrakesPower 4 Wheel Anti-lock
Daytime Running LightsIf available must provide
Rearview CameraHitch ViewFactory installed?
Suspension
SuspensionIndependent front, leaf rear
Tires & Wheels
Tires (4X4)All season blackwall
SpareIf available must provideIs 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 TruckPage 2
Example - Chevy Colorado
0
ADDITIONAL OPTIONS
EngineMinimum RequirementsMfg. Codes - Specs (Note STD for standard)Cost
Engine Block HeaterDEDUCT COST:
Alternator220 Amp
Doors & Windows
Key Sets / Fobs, Additional2 Fobs with push button start; 2 keys and fobs w/o push button start
Electrical
Power PointPower outlet, 110 Volt; Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.
Exterior
Bed LinerSpray In, Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Bed InsertFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Bed MatFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Cargo Tie DownsFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Mud flapsOEM or OEM authorized flexible heavy duty, behind all wheels. No dealer logo on mud flaps.
Recovery HooksFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Running BoardsTubular, Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Tonneau CoverSoft material style, rolling or trifold; dealer installed acceptable
Tonneau CoverHard surface, locking; dealer installed acceptable
Trailer Brake ControllerIntergrated trailer brake controllerFactory installed?
Trailer tow mirrorsFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Trailer tow packageAdvanced trailering packageFactory installed?
Packages
WT Convenience PackageWrapped steering wheel, 8 way power seat, EZ lift tailgate & locking cylinderFactory installed?
WT Custom Package18 WheelsFactory installed?
Safety
AlarmBackup alarm; Factory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?DI
Reverse Sensing SystemFactory installed preferred, if available must provide; dealer installed acceptable when Factory installed not available.Factory installed?
Other
Options not listed aboveDiscount 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 FOBPrice per mile to deliver vehicle anywhere in State of IowaPer Mile Charge
Delivery CostDelivery Cost to Department of Administrative Services Fleet Services, 510 E. 12th Street, Des Moines, IA 50319Enter miles in whole number:

File details come from the government source that posted it. Updated .