02a. Cost Submittal (Specifications) HYPERLINKS_CLEANED 6.4.26.xlsx

Bidder Instructions

Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models)

GENERAL INSTRUCTIONS FOR COMPLETING THIS WORKBOOK

The Cost Submittal Worksheets contained in this workbook shall constitute as the Cost Submittal.

The Cost Submittal Worksheets must be completed and returned in this Microsoft Excel format and not password protected.

All attached worksheets must be completed in their entirety.

Data may only be entered in the cells highlighted in BLUE.

2. Enter your company information in the BLUE highlighted fields.

NOTE: The information you supply here must match the information you provided on your vendor registration in the PA Supplier Portal.

Links to Each Manufacturer tab are below.

*Cost Submittal Instructions and Dealer Submission Requirements *Separate Cost Submittals are required for each Dealer/Manufacturer and require seperate bid login requirements *Bidders must submit one separate Cost Submittal Workbook for each manufacturer they are representing. Each workbook must contain only the pricing and information for that specific to each manufacturer.

Bidders must also ensure they are logged into the Commonwealth’s procurement system under the correct dealership entity name associated with the manufacturer for which they are submitting a bid.

For example, if submitting a Ford bid, the bidder must be logged in under the Ford dealership entity and submit only the Ford specific Cost Submittal Workbook.

If the bidder also intends to submit a bid for another manufacturer (e.g., Honda), the bidder must log out and then log back in under the dealership entity tied to that manufacturer before submitting the additional workbook.

Each submission must include a fully completed Bidder Information tab that reflects the dealership information specific to that manufacturer being bid.

Bidders must not combine multiple manufacturers in a single workbook. Failure to submit manufacturer specific workbooks—or to submit under the correct dealership entity—may result in the bid being deemed non responsive.

Cost Submittal Instructions:

Please refer to the Cost Submittal tabs for the manufacturer you wish to bid.

1. Complete the Bidder Information tab: Enter your dealership’s contact information.

The dealer name must match exactly as listed in the Commonwealth Supplier Portal.

2. Enter vehicle pricing: For each vehicle you are bidding, enter your price in Column M.

3. Select the correct Model Year: Choose the applicable Model Year (2027 or 2028) from the drop down menu in Column C.

4. Do not alter protected fields Do not modify or overwrite any drop down menus, formulas, or protected cells.

Do not password protect any portion of the workbook.

5.Submit the completed workbook: Upload each completed manufacturer specific Cost Submittal Workbook as part of your bid response.(One workbook per manufacturer.)

6. Cells highlighted in Green represent Hybrid or Electric Models

Please note that vehicles submitted with the bid shall be substantially equivalent. The Commonwealth's determination of "equivalent" shall be final.

Roadside Mitigation Equipment Vehicle shall be equipped with manufacturer-standard roadside mitigation equipment. Acceptable configurations include, but are not limited to, an inflator/sealant kit, compact spare tire, or full-size spare tire, as provided by the original equipment manufacturer (OEM).

The Commonwealth will not require the addition of a spare tire where the manufacturer does not provide a designed and secure storage location. Any non-standard or aftermarket additions that are not OEM-integrated are not acceptable due to potential safety and liability concerns.

Bidder Information Cost Submittal Workbook (Model Year 2027 and Newer) IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models)

Bidder Information Tab Please ensure that the dealer name you enter matches the name listed in the Commonwealth Supplier Portal (https://pasupplierportal.state.pa.us/irj/portal/anonymous) Many bidders register under names that differ significantly from their public or commonly used business names, and mismatches can delay the procurement process.

Chevrolet Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - CHEVROLET Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column R Item Number Class ModelYear Model Cab Configuration Trim Level Wheelbase Bed Length Van Roof Height (Van Only) Seating Capacity Drive Type Powertrain Type Engine Combined Average Fuel Economy Standard GVWR (Please contact vendor for variables) Maximum Trailer with standard drivetrain (may require options, please refer to vendor for variables) Assembly Plant Location Vendor Price Entry

Ford Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - FORD Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column M

Honda Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - Honda Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column R Item Number Class ModelYear Model Cab Configuration Trim Level Wheelbase Bed Length Van Roof Height (Van Only) Seating Capacity Drive Type Powertrain Type Standard Engine (please contact vendor for variables) Combined Average Fuel Economy Standard GVWR (Please contact vendor for variables) Maximum Trailer with standard drivetrain (may require options, please refer to vendor for variables) Assembly Plant Location Vendor Price Entry

Hyundai Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - Hyundai Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column R Item Number Class ModelYear Model Cab Configuration Trim Level Wheelbase Bed Length Van Roof Height (Van Only) Seating Capacity Drive Type Powertrain Type Standard Engine (please contact vendor for variables) Combined Average Fuel Economy Standard GVWR (Please contact vendor for variables) Maximum Trailer with standard drivetrain (may require options, please refer to vendor for variables) Assembly Plant Location Vendor Price Entry

JEEP

Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - JEEP Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column R Item Number Class ModelYear Model Cab Configuration Trim Level Wheelbase Bed Length Van Roof Height (Van Only) Seating Capacity Drive Type Powertrain Type Standard Engine (please contact vendor for variables) Combined Average Fuel Economy Standard GVWR (Please contact vendor for variables) Maximum Trailer with standard drivetrain (may require options, please refer to vendor for variables) Assembly Plant Location Vendor Price Entry

Nissan Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - Nissan Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column R Item Number Class ModelYear Model Cab Configuration Trim Level Wheelbase Bed Length Van Roof Height (Van Only) Seating Capacity Drive Type Powertrain Type Standard Engine (please contact vendor for variables) Combined Average Fuel Economy Standard GVWR (Please contact vendor for variables) Maximum Trailer with standard drivetrain (may require options, please refer to vendor for variables) Assembly Plant Location Vendor Price Entry

RAM

Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - RAM Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column R Item Number Class ModelYear Model Cab Configuration Trim Level Wheelbase Bed Length Van Roof Height (Van Only) Seating Capacity Drive Type Powertrain Type Engine Combined Average Fuel Economy Standard GVWR (Please contact vendor for variables) Maximum Trailer with standard drivetrain (may require options, please refer to vendor for variables) Assembly Plant Location Vendor Price Entry

Tesla Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - Tesla Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column R Item Number Class ModelYear Model Cab Configuration Trim Level Wheelbase Bed Length Van Roof Height (Van Only) Seating Capacity Drive Type Powertrain Type Standard Engine (please contact vendor for variables) Combined Average Fuel Economy Standard GVWR (Please contact vendor for variables) Maximum Trailer with standard drivetrain (may require options, please refer to vendor for variables) Assembly Plant Location Vendor Price Entry

2050 Fullsize 2027 Cybertruck Crew Cab Standard 143.1" 71.8" (6') 5 AWD BEV Battery Electric 63 MPGe 9,169-lbs 7,500-lbs Texas

Toyota Cost Submittal Workbook (Model Year 2027 and Newer)

Instructions for the Cost Submittal Workbook for IFB 6100066036 – Light‑Duty Pickup Trucks and Cargo Vans (Gas, Diesel, Hybrid, and Electric Models) CWOPA Vehicle Classification & Specifications - Toyota Instructions: Use the drop‑down menu in Column C to choose the Model Year (2027 or 2028). Enter the corresponding vehicle bid price in Column M