Attachment_1-_Pricing_Worksheet.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- Glass Spheres (Beads)
- Solicitation number
- 0000035632
- Issued by
- California
About this file
This document is a Pricing Worksheet for a glass beads procurement opportunity involving the Northern and Southern California Departments of General Services, with the solicitation Event ID 0000035632. The procurement covers three types of glass beads (Type 1, Type 2, and Type 3) to be delivered in various packaging configurations including totes (2200 lb increments), drums (550 lb increments), and bags (50 lb increments). The total estimated three-year quantity spans multiple line items, with Northern California seeking approximately 2,700 lbs in Type 1 beads, 2,944,505 lbs in Type 2 beads, and 869,171 lbs in Type 3 beads. Similarly, Southern California has identical estimated quantities across the same three bead types and packaging configurations.
The pricing worksheet is structured to allow bidders to input list prices, contract discounts, and unit prices for each line item, with calculations for total extended pricing. The United Nations Standard Products and Services Code (UNSPSC) of 60122906 is consistently used for all line items. The worksheet provides a standardized format for bidders to respond, requiring completion of yellow input cells and offering guidance on calculating contract discounts and extensions. While specific pricing details are not populated in the provided document, the worksheet is designed to capture comprehensive pricing information for a potential three-year contract period, with the solicitation dated 8/12/2025.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| APP_Cover_Page.docx | DOCX document | |
| Attachment_2-_Specifications_9340-BS-0256455.pdf | ||
| Attachment_3-_Narrative_Response.docx | DOCX document | |
| IFB_0000035632.docx | DOCX document |
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 | ||||||||
| Column Name | Contract Line Item Number (CLIN) | |||||||
| Three (3) Year Estimated Quantity in LB | Commodity Description | UNSPSC | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure | Quantity in |
Unit of Measure
| (If Applicable) | List Price/MSRP | Contract Discount | Contract Unit Price | Extension | |
| Description | Unique line item number. | The State's estimated quantity; used for evaluation purpose only. | The State's description of the product. | 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 (LB is defined as pound). | 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. | ||||||||||||||
| For commodities with a fixed price structure, discount is derived based on the following calculation: ((List Price - Contract Unit Price)/List Price) = Contract Discount %. | This is the contractual price for a given line item based on the price that was bid, as relative to the | ||||||||||||||
| unit of measure (per pound). | Quantity in Column 2 multiplied by the Contract Unit Price in Column 13. | ||||||||||||||
| Format | Variable Character | Number | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | Currency | Percentage | Currency | Currency | |
| Example | 625 | 1,000 | Laptop | 43211503 | PT-674344457 | HP | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | LB | 10 | $2,500.00 | 66% | $1,650.00 | $1,650,000.00 | |
| 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- Northern California
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000035632, Glass Spheres (Beads) | ||||||||||||
| Attachment 1 - Pricing Worksheet, 8/12/2025 | ||||||||||||
| Bidder: | Blank | |||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | ||||||||||||
| Contract Line Item # (CLIN) | Three (3) Year Estimated Quantity | |||||||||||
| in LB | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||
| N100 | 2200 | Type 1 Glass Beads, Totes, order in 2200 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| N200 | 550 | Type 1 Glass Beads, Drums, order in 550 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| N300 | 30,000 | Type 1 Glass Beads, Bags, order in 50 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| N400 | 296,855 | Type 2 Glass Beads, Totes, order in 2200 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| N500 | 2,596,495 | Type 2 Glass Beads, Drums, order in 550 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| N600 | 51,150 | Type 2 Glass Beads, Bags, order in 50 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| N700 | 244,200 | Type 3 Glass Beads, Totes, order in 2200 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| N800 | 17,600 | Type 3 Glass Beads, Drums, order in 550 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| N900 | 608,371 | Type 3 Glass Beads, Bags, order in 50 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| TOTAL: | $ - 0 | |||||||||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | ||||||||||||
| Note: LB is defined as pound | ||||||||||||
| End of Sheet |
Page &P
Group 2- Southern California
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000035632, Glass Spheres (Beads) | ||||||||||||
| Attachment 1 - Pricing Worksheet, 8/12/2025 | ||||||||||||
| Bidder: | Blank | |||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | ||||||||||||
| Contract Line Item # (CLIN) | Three (3) Year Estimated Quantity | |||||||||||
| in LB | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||
| S100 | 2200 | Type 1 Glass Beads, Totes, order in 2200 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| S200 | 550 | Type 1 Glass Beads, Drums, order in 550 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| S300 | 30,000 | Type 1 Glass Beads, Bags, order in 50 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| S400 | 296,855 | Type 2 Glass Beads, Totes, order in 2200 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| S500 | 2,596,495 | Type 2 Glass Beads, Drums, order in 550 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| S600 | 51,150 | Type 2 Glass Beads, Bags, order in 50 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| S700 | 244,200 | Type 3 Glass Beads, Totes, order in 2200 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| S800 | 17,600 | Type 3 Glass Beads, Drums, order in 550 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| S900 | 608,371 | Type 3 Glass Beads, Bags, order in 50 LB increments | 60122906 | LB | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| TOTAL: | $ - 0 | |||||||||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | ||||||||||||
| Note: LB is defined as pound | ||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .