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 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 NameContract Line Item Number (CLIN)
Three (3) Year Estimated Quantity in LBCommodity DescriptionUNSPSCManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

(If Applicable)List Price/MSRPContract DiscountContract Unit PriceExtension
DescriptionUnique 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.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 (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.
FormatVariable CharacterNumberVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberCurrencyPercentageCurrencyCurrency
Example6251,000Laptop43211503PT-674344457HP4576543245-JH/4567CHP Compaq 8710p Notebook PCLB10$2,500.0066%$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 LBCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract PriceExtension
N1002200Type 1 Glass Beads, Totes, order in 2200 LB increments60122906LB1ERROR:#DIV/0!$ - 0
N200550Type 1 Glass Beads, Drums, order in 550 LB increments60122906LB1ERROR:#DIV/0!$ - 0
N30030,000Type 1 Glass Beads, Bags, order in 50 LB increments60122906LB1ERROR:#DIV/0!$ - 0
N400296,855Type 2 Glass Beads, Totes, order in 2200 LB increments60122906LB1ERROR:#DIV/0!$ - 0
N5002,596,495Type 2 Glass Beads, Drums, order in 550 LB increments60122906LB1ERROR:#DIV/0!$ - 0
N60051,150Type 2 Glass Beads, Bags, order in 50 LB increments60122906LB1ERROR:#DIV/0!$ - 0
N700244,200Type 3 Glass Beads, Totes, order in 2200 LB increments60122906LB1ERROR:#DIV/0!$ - 0
N80017,600Type 3 Glass Beads, Drums, order in 550 LB increments60122906LB1ERROR:#DIV/0!$ - 0
N900608,371Type 3 Glass Beads, Bags, order in 50 LB increments60122906LB1ERROR:#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 LBCommodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in
Unit of MeasureList Price/MSRPContract DiscountContract PriceExtension
S1002200Type 1 Glass Beads, Totes, order in 2200 LB increments60122906LB1ERROR:#DIV/0!$ - 0
S200550Type 1 Glass Beads, Drums, order in 550 LB increments60122906LB1ERROR:#DIV/0!$ - 0
S30030,000Type 1 Glass Beads, Bags, order in 50 LB increments60122906LB1ERROR:#DIV/0!$ - 0
S400296,855Type 2 Glass Beads, Totes, order in 2200 LB increments60122906LB1ERROR:#DIV/0!$ - 0
S5002,596,495Type 2 Glass Beads, Drums, order in 550 LB increments60122906LB1ERROR:#DIV/0!$ - 0
S60051,150Type 2 Glass Beads, Bags, order in 50 LB increments60122906LB1ERROR:#DIV/0!$ - 0
S700244,200Type 3 Glass Beads, Totes, order in 2200 LB increments60122906LB1ERROR:#DIV/0!$ - 0
S80017,600Type 3 Glass Beads, Drums, order in 550 LB increments60122906LB1ERROR:#DIV/0!$ - 0
S900608,371Type 3 Glass Beads, Bags, order in 50 LB increments60122906LB1ERROR:#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 .