Attachment_1_-_Pricing_Workbook.xlsx
XLSX spreadsheet 47 KB Posted
- Attached to
- Portable DCFC Chargers
- Solicitation number
- 0000035225
- Issued by
- California
About this file
The document is a Pricing Workbook from the Department of General Services - Procurement Division for an Invitation for Bid (IFB) Event ID 0000035225 involving Portable Direct Current Fast Charging (DCFC) Chargers. The solicitation covers six distinct groups across two categories (Trailer and Skid), with power ranges from 30 to 250 kW/KVA. Each group includes 11 line items for EVSE Portable DCFC Charger Units, adapters, power cables, extended warranties, connection/disconnection services, equipment maintenance, diagnostic fees, and various repair services. The procurement allows for 10 units of most items, with 5 units for extended warranties and certain service-related items. The bid response date is set for 6/2/2025.
The pricing worksheet provides a detailed template for bidders to complete, with columns for contract line items, UNSPSC codes, manufacturer details, item descriptions, unit of measure, quantities, list prices, contract prices, and discounts. The document requires bidders to input pricing information in yellow-highlighted cells, with extensions calculated automatically. Each group represents a different power configuration (Low, Medium, High Power) and mounting type (Trailer or Skid), suggesting a comprehensive approach to procurement that allows for varied electric vehicle charging infrastructure needs. The pricing structure appears designed to provide flexibility and competitive pricing across different charging station specifications and service requirements.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| APP_Cover_Page_(rev_1-15).docx | DOCX document | |
| Attachment_2a_-_Technical_Questionnaire.xlsx | XLSX spreadsheet | |
| Attachment_3_-_Narrative_Response.docx | DOCX document | |
| Attachment_4_-_Contractors_License_Requirements.xlsx | XLSX spreadsheet | |
| IFB_35225,_Portable_DCFC_Chargers.docx | DOCX document | |
| Attachment_2_-_Bid_Specification_Number_6115-BS-0250731.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
Pricing Worksheet Key
| PRICING WORKSHEET KEY |
| PRICING WORKSHEET TEMPLATE |
(Rev 3/25/2021)
| Column Number | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 16 | Column 18 | Column 19 | Column 22 |
| Column Name | Contract Line Item Number (CLIN) | |||||||||||
| UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure | Quantity in |
Unit of Measure
| (If Applicable) | List Price/MSRP | Contract Unit Price | Contract Discount | Segment ID /Product Category/Group ID |
| Description | Unique 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.asp | Identifies 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). | ||||||||||||
| Format | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | Currency | Currency | Percentage | Variable Character | |
| Example | 625 | 43211503 | PT-674344457 | HP | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | BOX | 10 | $2,500.00 | $1,650.00 | 66% | 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: 0000035225, Portable DCFC Chargers, Category 1 - Trailer, Group 1 - DCFC Basic, Low Power, ≥ 30 to < 150 (kW or KVA) | ||||||||||||||
| Attachment 1 - Pricing Workbook, 6/2/2025 | ||||||||||||||
| 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) | Quantity | Commodity Description | Core Item Category | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | ENERGY STAR® Yes or No | Unit of Measure | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||||
| T-100 | 10 | EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760. | EVSE Hardware | EA | 1 | $ - 0 | $ - 0 | |||||||
| T-101 | 10 | CCS1 to NACS adapter if the above unit quoted has CCS1 connector or | ||||||||||||
| NACS to CCS1 adapter if the above unit quoted has NACS connector. | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||||
| T-102 | 10 | 25 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-103 | 10 | 50 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-104 | 5 | 3-Year Extended Warranty | Extended Warranty | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-105 | 10 | Connection of EVSE | Connection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| T-106 | 10 | Disconnection of EVSE | Disconnection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| T-107 | 5 | Equipment Maintenance |
Service During Regular Business Hours
| (M-F 8:00AM - 5:00PM) | Equipment Maintenance Services | N/A | Annually | 1 | $ - 0 | $ - 0 | |||||||
| T-108 | 5 | Diagnostic Fee | |||||||||||
| (Waived if repair or replacment is approved) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| T-109 | 5 | Repairs During Regular Business Hours | |||||||||||
| (M-F 8:00AM - 5:00PM) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| T-110 | 5 | Repairs During Weekends, Holidays, and After Regular Business Hours | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| T-111 | 5 | Expedited Repairs | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| TOTAL: | $ - 0 | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | |||||||||||||
| End of Sheet |
Page &P
Group 2
| Department of General Services - Procurement Division | ||||||||||||||
| Event ID: 0000035225, Portable DCFC Chargers, Category 1 - Trailer, Group 2 - DCFC Basic, Medium Power, ≥ 150 to < 250 (kW or KVA) | ||||||||||||||
| Attachment 1 - Pricing Workbook, 6/2/2025 | ||||||||||||||
| 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) | Quantity | Commodity Description | Core Item Category | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | ENERGY STAR® Yes or No | Unit of Measure | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||||
| T-200 | 10 | EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760. | EVSE Hardware | EA | 1 | $ - 0 | $ - 0 | |||||||
| T-201 | 10 | CCS1 to NACS adapter if the above unit quoted has CCS1 connector or | ||||||||||||
| NACS to CCS1 adapter if the above unit quoted has NACS connector. | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||||
| T-202 | 10 | 25 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-203 | 10 | 50 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-204 | 5 | 3-Year Extended Warranty | Extended Warranty | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-205 | 10 | Connection of EVSE | Connection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| T-206 | 10 | Disconnection of EVSE | Disconnection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| T-207 | 5 | Equipment Maintenance |
Service During Regular Business Hours
| (M-F 8:00AM - 5:00PM) | Equipment Maintenance Services | N/A | Annually | 1 | $ - 0 | $ - 0 | |||||||
| T-208 | 5 | Diagnostic Fee | |||||||||||
| (Waived if repair or replacment is approved) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| T-209 | 5 | Repairs During Regular Business Hours | |||||||||||
| (M-F 8:00AM - 5:00PM) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| T-210 | 5 | Repairs During Weekends, Holidays, and After Regular Business Hours | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| T-211 | 5 | Expedited Repairs | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| TOTAL: | $ - 0 | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | |||||||||||||
| End of Sheet |
Page &P
Group 3
| Department of General Services - Procurement Division | ||||||||||||||
| Event ID: 0000035225, Portable DCFC Chargers, Category 1 - Trailer, Group 3 - DCFC Basic, High Power, ≥ 250 (kW or KVA) | ||||||||||||||
| Attachment 1 - Pricing Workbook, 6/2/2025 | ||||||||||||||
| 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) | Quantity | Commodity Description | Core Item Category | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | ENERGY STAR® Yes or No | Unit of Measure | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||||
| T-300 | 10 | EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760. | EVSE Hardware | EA | 1 | $ - 0 | $ - 0 | |||||||
| T-301 | 10 | CCS1 to NACS adapter if the above unit quoted has CCS1 connector or | ||||||||||||
| NACS to CCS1 adapter if the above unit quoted has NACS connector. | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||||
| T-302 | 10 | 25 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-303 | 10 | 50 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-304 | 5 | 3-Year Extended Warranty | Extended Warranty | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| T-305 | 10 | Connection of EVSE | Connection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| T-306 | 10 | Disconnection of EVSE | Disconnection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| T-307 | 5 | Equipment Maintenance |
Service During Regular Business Hours
| (M-F 8:00AM - 5:00PM) | Equipment Maintenance Services | N/A | Annually | 1 | $ - 0 | $ - 0 | |||||||
| T-308 | 5 | Diagnostic Fee | |||||||||||
| (Waived if repair or replacment is approved) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| T-309 | 5 | Repairs During Regular Business Hours | |||||||||||
| (M-F 8:00AM - 5:00PM) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| T-310 | 5 | Repairs During Weekends, Holidays, and After Regular Business Hours | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| T-311 | 5 | Expedited Repairs | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| TOTAL: | $ - 0 | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | |||||||||||||
| End of Sheet |
Page &P
Group 4
| Department of General Services - Procurement Division | ||||||||||||||
| Event ID: 0000035225, Portable DCFC Chargers, Category 2 - Skid, Group 4 - DCFC Basic, Low Power, ≥ 30 to < 150 (kW or KVA) | ||||||||||||||
| Attachment 1 - Pricing Workbook, 6/2/2025 | ||||||||||||||
| 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) | Quantity | Commodity Description | Core Item Category | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | ENERGY STAR® Yes or No | Unit of Measure | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||||
| S-100 | 10 | EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760. | EVSE Hardware | EA | 1 | $ - 0 | $ - 0 | |||||||
| S-101 | 10 | CCS1 to NACS adapter if the above unit quoted has CCS1 connector or | ||||||||||||
| NACS to CCS1 adapter if the above unit quoted has NACS connector. | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||||
| S-102 | 10 | 25 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-103 | 10 | 50 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-104 | 5 | 3-Year Extended Warranty | Extended Warranty | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-105 | 10 | Connection of EVSE | Connection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| S-106 | 10 | Disconnection of EVSE | Disconnection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| S-107 | 5 | Equipment Maintenance |
Service During Regular Business Hours
| (M-F 8:00AM - 5:00PM) | Equipment Maintenance Services | N/A | Annually | 1 | $ - 0 | $ - 0 | |||||||
| S-108 | 5 | Diagnostic Fee | |||||||||||
| (Waived if repair or replacment is approved) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| S-109 | 5 | Repairs During Regular Business Hours | |||||||||||
| (M-F 8:00AM - 5:00PM) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| S-110 | 5 | Repairs During Weekends, Holidays, and After Regular Business Hours | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| S-111 | 5 | Expedited Repairs | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| TOTAL: | $ - 0 | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | |||||||||||||
| End of Sheet |
Page &P
Group 5
| Department of General Services - Procurement Division | ||||||||||||||
| Event ID: 0000035225, Portable DCFC Chargers, Category 2 - Skid, Group 5 - DCFC Basic, Medium Power, ≥ 150 to < 250 (kW or KVA) | ||||||||||||||
| Attachment 1 - Pricing Workbook, 6/2/2025 | ||||||||||||||
| 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) | Quantity | Commodity Description | Core Item Category | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | ENERGY STAR® Yes or No | Unit of Measure | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||||
| S-200 | 10 | EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760. | EVSE Hardware | EA | 1 | $ - 0 | $ - 0 | |||||||
| S-201 | 10 | CCS1 to NACS adapter if the above unit quoted has CCS1 connector or | ||||||||||||
| NACS to CCS1 adapter if the above unit quoted has NACS connector. | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||||
| S-202 | 10 | 25 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-203 | 10 | 50 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-204 | 5 | 3-Year Extended Warranty | Extended Warranty | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-205 | 10 | Connection of EVSE | Connection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| S-206 | 10 | Disconnection of EVSE | Disconnection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| S-207 | 5 | Equipment Maintenance |
Service During Regular Business Hours
| (M-F 8:00AM - 5:00PM) | Equipment Maintenance Services | N/A | Annually | 1 | $ - 0 | $ - 0 | |||||||
| S-208 | 5 | Diagnostic Fee | |||||||||||
| (Waived if repair or replacment is approved) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| S-209 | 5 | Repairs During Regular Business Hours | |||||||||||
| (M-F 8:00AM - 5:00PM) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| S-210 | 5 | Repairs During Weekends, Holidays, and After Regular Business Hours | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| S-211 | 5 | Expedited Repairs | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| TOTAL: | $ - 0 | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | |||||||||||||
| End of Sheet |
Page &P
Group 6
| Department of General Services - Procurement Division | ||||||||||||||
| Event ID: 0000035225, Portable DCFC Chargers, Category 2 - Skid, Group 6 - DCFC Basic, High Power, ≥ 250 (kW or KVA) | ||||||||||||||
| Attachment 1 - Pricing Workbook, 6/2/2025 | ||||||||||||||
| 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) | Quantity | Commodity Description | Core Item Category | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | ENERGY STAR® Yes or No | Unit of Measure | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||||
| S-300 | 10 | EVSE Portable DCFC Charger Unit as specified in Attachment 2 – Bid Specification Number 6115-BS-0195760. | EVSE Hardware | EA | 1 | $ - 0 | $ - 0 | |||||||
| S-301 | 10 | CCS1 to NACS adapter if the above unit quoted has CCS1 connector or | ||||||||||||
| NACS to CCS1 adapter if the above unit quoted has NACS connector. | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||||
| S-302 | 10 | 25 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-303 | 10 | 50 foot input power cable | Accessories | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-304 | 5 | 3-Year Extended Warranty | Extended Warranty | N/A | EA | 1 | $ - 0 | $ - 0 | ||||||
| S-305 | 10 | Connection of EVSE | Connection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| S-306 | 10 | Disconnection of EVSE | Disconnection | N/A | Hourly | 1 | $ - 0 | $ - 0 | ||||||
| S-307 | 5 | Equipment Maintenance |
Service During Regular Business Hours
| (M-F 8:00AM - 5:00PM) | Equipment Maintenance Services | N/A | Annually | 1 | $ - 0 | $ - 0 | |||||||
| S-308 | 5 | Diagnostic Fee | |||||||||||
| (Waived if repair or replacment is approved) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| S-309 | 5 | Repairs During Regular Business Hours | |||||||||||
| (M-F 8:00AM - 5:00PM) | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||||
| S-310 | 5 | Repairs During Weekends, Holidays, and After Regular Business Hours | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| S-311 | 5 | Expedited Repairs | Repair Services | N/A | Hourly | 1 | $ - 0 | $ - 0 | |||||
| TOTAL: | $ - 0 | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | |||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .