Attachment_1_-_Pricing_Workbook,_Addendum_1.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
EVSE Portable DCFC Charger
Solicitation number
0000031603
Issued by
California

About this file

This is a pricing workbook from the California Department of General Services - Procurement Division for portable DC fast chargers (DCFC). The solicitation (Event ID: 0000031603) covers six groups of EVSE portable DCFC chargers across two categories: trailer-mounted (Groups 1-3) and skid-mounted (Groups 4-6), with power ranges of low (30 to <150 kW), medium (150 to <250 kW), and high (250 kW). Each group includes requirements for 10 charging units, associated accessories (CCS1/NACS adapters, power cables), 5 extended warranties, and various service components including connection/disconnection, maintenance, and repair services. The contract term appears to extend to December 16, 2024.

The pricing structure requires bidders to complete core items pricing for each group, including list price/MSRP, contract discount, and contract price calculations. The workbook includes hourly rates for services such as equipment connection/disconnection, repairs during regular and non-regular business hours, and expedited repairs. Maintenance services are priced annually, while equipment and accessories are priced per unit. The pricing template includes automatic calculations for discounts ((List Price - Contract Price)/List Price) and extensions (Contract Unit Price x Quantity).

View the file

Other files

File Type Posted
APP_Cover_Page_(rev_1-15).docx DOCX document
Portable_DCFC_Chargers_IFB_31603.docx DOCX document
Question___Answer_Set_1.docx DOCX document
Question___Answer_Set_2.docx DOCX document
Attachment_1_-_Pricing_Workbook.xlsx XLSX spreadsheet
Attachment_2a_-_Technical_Questionnaire.xlsx XLSX spreadsheet
Addendum_Cover_Sheet.docx DOCX document
IFB_31603,_Adddendum_2.docx DOCX document
Addendum_Cover_Sheet,_Addendum_3.docx DOCX document
IFB_31603,_Adddendum_3.docx DOCX document
Attachment_2_-_Bid_Specification_6115-BS-0195760.pdf PDF
Attachment_3_-_Narrative_Response.docx DOCX document
Attachment_4_-_Contractors_License_Requirements.xlsx XLSX spreadsheet
Attachment_2_-_Bid_Spec._6115-BS-0195760RevA.pdf PDF
Addendum_Cover_Sheet,_Addendum_2.docx DOCX document
Question___Answer_Set_3.docx DOCX document
Show all 16

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

Pricing Worksheet Key

PRICING WORKSHEET KEY
PRICING WORKSHEET TEMPLATE

(Rev 3/25/2021)

Column NumberColumn 7Column 8Column 9Column 10Column 11Column 12Column 13Column 14Column 16Column 18Column 19Column 22
Column NameContract Line Item Number (CLIN)
UNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

(If Applicable)List Price/MSRPContract Unit PriceContract DiscountSegment ID /Product Category/Group ID
DescriptionUnique line item number.The United Nations Standard Products and Services Code. It’s a global multi-sector standard for efficient, accurate classification of products and services.

This field should document the appropriate UNSPSC Commodity Code for each line item.

Website for codes: http://www.unspsc.org/Search.aspIdentifies manufacturer's unique identifier for a particular line item.Identifies the manufacturer's name for each line item.Identifies supplier's unique identifier for a particular line item.Informational text about the commodity being purchased. Description should be descriptive enough to show the item is consistent with the specifications (high-level).Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc).This field will carry the number of base units in the packaging of the products
(i.e. # of pencils in a box).An independently verifiable public price available to the general public.
This is the contractual price for a given line item based on the price that was bid, as relative to the
unit of measure.For commodities with a discount structure - this value represents the contractual discount off the List Price.
For commodities with a fixed price structure, discount is derived based on the following calculation: ((List Price - Contract Price)/List Price) = Contract Discount %.This non-core identifier will uniquely categorize each commodity grouping to its respective contractual discount(s).
FormatVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberCurrencyCurrencyPercentageVariable Character
Example62543211503PT-674344457HP4576543245-JH/4567CHP Compaq 8710p Notebook PCBOX10$2,500.00$1,650.0066%A
CORE - Often refers to a Fixed Price.
NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.).
END OF SHEET.

Group 1

Department of General Services - Procurement Division
Event ID: 0000031603, Portable DCFC Chargers, Category 1 - Trailer, Group 1 - DCFC Basic, Low Power, ≥ 30 to < 150 (kW or KVA)
Attachment 1 - Pricing Workbook, *12/16/2024, Addendum 1*
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)QuantityCommodity DescriptionCore Item CategoryManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionENERGY STAR® Yes or NoUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract PriceExtension
T-10010EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760.EVSE HardwareEA1$ - 0$ - 0
T-10110CCS1 to NACS adapter if the above unit quoted has CCS1 connector or
NACS to CCS1 adapter if the above unit quoted has NACS connector.AccessoriesN/AEA1$ - 0$ - 0
T-1021025 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
T-1031050 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
T-10453-Year Extended WarrantyAccessoriesN/AEA1$ - 0$ - 0
T-10510Connection of EVSEConnectionN/A*Hourly*1$ - 0$ - 0
T-10610Disconnection of EVSEDisconnectionN/A*Hourly*1$ - 0$ - 0
T-1075Equipment Maintenance

Service During Regular Business Hours

(M-F 8:00AM - 5:00PM)Equipment Maintenance ServicesN/A*Annually*1$ - 0$ - 0
T-1085Diagnostic Fee
(Waived if repair or replacment is approved)Repair ServicesN/A*Hourly*1$ - 0$ - 0
T-1095Repairs During Regular Business Hours
(M-F 8:00AM - 5:00PM)Repair ServicesN/A*Hourly*1$ - 0$ - 0
T-1105Repairs During Weekends, Holidays, and After Regular Business HoursRepair ServicesN/A*Hourly*1$ - 0$ - 0
T-1115Expedited RepairsRepair ServicesN/A*Hourly*1$ - 0$ - 0
TOTAL:$ - 0
AN/A
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculate by (Contract Unit Price x Quantity)
End of Sheet

Page &P

Group 2

Department of General Services - Procurement Division
Event ID: 0000031603, Portable DCFC Chargers, Category 1 - Trailer, Group 2 - DCFC Basic, Medium Power, ≥ 150 to < 250 (kW or KVA)
Attachment 1 - Pricing Workbook, *12/16/2024, Addendum 1*
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)QuantityCommodity DescriptionCore Item CategoryManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionENERGY STAR® Yes or NoUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract PriceExtension
T-20010EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760.EVSE HardwareEA1$ - 0$ - 0
T-20110CCS1 to NACS adapter if the above unit quoted has CCS1 connector or
NACS to CCS1 adapter if the above unit quoted has NACS connector.AccessoriesN/AEA1$ - 0$ - 0
T-2021025 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
T-2031050 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
T-20453-Year Extended WarrantyAccessoriesN/AEA1$ - 0$ - 0
T-20510Connection of EVSEConnectionN/A*Hourly*1$ - 0$ - 0
T-20610Disconnection of EVSEDisconnectionN/A*Hourly*1$ - 0$ - 0
T-2075Equipment Maintenance

Service During Regular Business Hours

(M-F 8:00AM - 5:00PM)Equipment Maintenance ServicesN/A*Annually*1$ - 0$ - 0
T-2085Diagnostic Fee
(Waived if repair or replacment is approved)Repair ServicesN/A*Hourly*1$ - 0$ - 0
T-2095Repairs During Regular Business Hours
(M-F 8:00AM - 5:00PM)Repair ServicesN/A*Hourly*1$ - 0$ - 0
T-2105Repairs During Weekends, Holidays, and After Regular Business HoursRepair ServicesN/A*Hourly*1$ - 0$ - 0
T-2115Expedited RepairsRepair ServicesN/A*Hourly*1$ - 0$ - 0
TOTAL:$ - 0
NON-CORE ITEMS SUBTOTAL:ERROR:#REF!
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculate by (Contract Unit Price x Quantity)
End of Sheet

Page &P

Group 3

Department of General Services - Procurement Division
Event ID: 0000031603, Portable DCFC Chargers, Category 1 - Trailer, Group 3 - DCFC Basic, High Power, ≥ 250 (kW or KVA)
Attachment 1 - Pricing Workbook, *12/16/2024, Addendum 1*
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)QuantityCommodity DescriptionCore Item CategoryManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionENERGY STAR® Yes or NoUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract PriceExtension
T-30010EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760.EVSE HardwareEA1$ - 0$ - 0
T-30110CCS1 to NACS adapter if the above unit quoted has CCS1 connector or
NACS to CCS1 adapter if the above unit quoted has NACS connector.AccessoriesN/AEA1$ - 0$ - 0
T-3021025 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
T-3031050 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
T-30453-Year Extended WarrantyAccessoriesN/AEA1$ - 0$ - 0
T-30510Connection of EVSEConnectionN/A*Hourly*1$ - 0$ - 0
T-30610Disconnection of EVSEDisconnectionN/A*Hourly*1$ - 0$ - 0
T-3075Equipment Maintenance

Service During Regular Business Hours

(M-F 8:00AM - 5:00PM)Equipment Maintenance ServicesN/A*Annually*1$ - 0$ - 0
T-3085Diagnostic Fee
(Waived if repair or replacment is approved)Repair ServicesN/A*Hourly*1$ - 0$ - 0
T-3095Repairs During Regular Business Hours
(M-F 8:00AM - 5:00PM)Repair ServicesN/A*Hourly*1$ - 0$ - 0
T-3105Repairs During Weekends, Holidays, and After Regular Business HoursRepair ServicesN/A*Hourly*1$ - 0$ - 0
T-3115Expedited RepairsRepair ServicesN/A*Hourly*1$ - 0$ - 0
TOTAL:$ - 0
NON-CORE ITEMS SUBTOTAL:ERROR:#REF!
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculate by (Contract Unit Price x Quantity)
End of Sheet

Page &P

Group 4

Department of General Services - Procurement Division
Event ID: 0000031603, Portable DCFC Chargers, Category 2 - Skid, Group 4 - DCFC Basic, Low Power, ≥ 30 to < 150 (kW or KVA)
Attachment 1 - Pricing Workbook, *12/16/2024, Addendum 1*
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)QuantityCommodity DescriptionCore Item CategoryManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionENERGY STAR® Yes or NoUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract PriceExtension
S-10010EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760.EVSE HardwareEA1$ - 0$ - 0
S-10110CCS1 to NACS adapter if the above unit quoted has CCS1 connector or
NACS to CCS1 adapter if the above unit quoted has NACS connector.AccessoriesN/AEA1$ - 0$ - 0
S-1021025 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
S-1031050 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
S-10453-Year Extended WarrantyAccessoriesN/AEA1$ - 0$ - 0
S-10510Connection of EVSEConnectionN/A*Hourly*1$ - 0$ - 0
S-10610Disconnection of EVSEDisconnectionN/A*Hourly*1$ - 0$ - 0
S-1075Equipment Maintenance

Service During Regular Business Hours

(M-F 8:00AM - 5:00PM)Equipment Maintenance ServicesN/A*Annually*1$ - 0$ - 0
S-1085Diagnostic Fee
(Waived if repair or replacment is approved)Repair ServicesN/A*Hourly*1$ - 0$ - 0
S-1095Repairs During Regular Business Hours
(M-F 8:00AM - 5:00PM)Repair ServicesN/A*Hourly*1$ - 0$ - 0
S-1105Repairs During Weekends, Holidays, and After Regular Business HoursRepair ServicesN/A*Hourly*1$ - 0$ - 0
S-1115Expedited RepairsRepair ServicesN/A*Hourly*1$ - 0$ - 0
TOTAL:$ - 0
NON-CORE ITEMS SUBTOTAL:ERROR:#REF!
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculate by (Contract Unit Price x Quantity)
End of Sheet

Page &P

Group 5

Department of General Services - Procurement Division
Event ID: 0000031603, Portable DCFC Chargers, Category 2 - Skid, Group 5 - DCFC Basic, Medium Power, ≥ 150 to < 250 (kW or KVA)
Attachment 1 - Pricing Workbook, *12/16/2024, Addendum 1*
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)QuantityCommodity DescriptionCore Item CategoryManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionENERGY STAR® Yes or NoUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract PriceExtension
S-20010EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760.EVSE HardwareEA1$ - 0$ - 0
S-20110CCS1 to NACS adapter if the above unit quoted has CCS1 connector or
NACS to CCS1 adapter if the above unit quoted has NACS connector.AccessoriesN/AEA1$ - 0$ - 0
S-2021025 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
S-2031050 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
S-20453-Year Extended WarrantyAccessoriesN/AEA1$ - 0$ - 0
S-20510Connection of EVSEConnectionN/A*Hourly*1$ - 0$ - 0
S-20610Disconnection of EVSEDisconnectionN/A*Hourly*1$ - 0$ - 0
S-2075Equipment Maintenance

Service During Regular Business Hours

(M-F 8:00AM - 5:00PM)Equipment Maintenance ServicesN/A*Annually*1$ - 0$ - 0
S-2085Diagnostic Fee
(Waived if repair or replacment is approved)Repair ServicesN/A*Hourly*1$ - 0$ - 0
S-2095Repairs During Regular Business Hours
(M-F 8:00AM - 5:00PM)Repair ServicesN/A*Hourly*1$ - 0$ - 0
S-2105Repairs During Weekends, Holidays, and After Regular Business HoursRepair ServicesN/A*Hourly*1$ - 0$ - 0
S-2115Expedited RepairsRepair ServicesN/A*Hourly*1$ - 0$ - 0
TOTAL:$ - 0
NON-CORE ITEMS SUBTOTAL:ERROR:#REF!
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculate by (Contract Unit Price x Quantity)
End of Sheet

Page &P

Group 6

Department of General Services - Procurement Division
Event ID: 0000031603, Portable DCFC Chargers, Category 2 - Skid, Group 6 - DCFC Basic, High Power, ≥ 250 (kW or KVA)
Attachment 1 - Pricing Workbook, *12/16/2024, Addendum 1*
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
CORE ITEMS
Contract Line Item # (CLIN)QuantityCommodity DescriptionCore Item CategoryManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionENERGY STAR® Yes or NoUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract PriceExtension
S-30010EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760.EVSE HardwareEA1$ - 0$ - 0
S-30110CCS1 to NACS adapter if the above unit quoted has CCS1 connector or
NACS to CCS1 adapter if the above unit quoted has NACS connector.AccessoriesN/AEA1$ - 0$ - 0
S-3021025 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
S-3031050 foot input power cableAccessoriesN/AEA1$ - 0$ - 0
S-30453-Year Extended WarrantyAccessoriesN/AEA1$ - 0$ - 0
S-30510Connection of EVSEConnectionN/A*Hourly*1$ - 0$ - 0
S-30610Disconnection of EVSEDisconnectionN/A*Hourly*1$ - 0$ - 0
S-3075Equipment Maintenance

Service During Regular Business Hours

(M-F 8:00AM - 5:00PM)Equipment Maintenance ServicesN/A*Annually*1$ - 0$ - 0
S-3085Diagnostic Fee
(Waived if repair or replacment is approved)Repair ServicesN/A*Hourly*1$ - 0$ - 0
S-3095Repairs During Regular Business Hours
(M-F 8:00AM - 5:00PM)Repair ServicesN/A*Hourly*1$ - 0$ - 0
S-3105Repairs During Weekends, Holidays, and After Regular Business HoursRepair ServicesN/A*Hourly*1$ - 0$ - 0
S-3115Expedited RepairsRepair ServicesN/A*Hourly*1$ - 0$ - 0
TOTAL:$ - 0
NON-CORE ITEMS SUBTOTAL:
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Extension is automatically calculate by (Contract Unit Price x Quantity)
End of Sheet

Page &P

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