Attachment_1_-_Pricing_Worksheet.xlsx
XLSX spreadsheet 26 KB Posted
- Attached to
- Paint (Exterior, Recycled, Reprocessed)
- Solicitation number
- 0000035324
- Issued by
- California
About this file
This is a Pricing Worksheet for an Invitation for Bid (IFB) issued by the California Department of General Services, Procurement Division to establish a multi-year statewide contract for exterior, recycled, and reprocessed paint products. The contract has a primary term of three years with two optional one-year extension periods. The solicitation is mandatory for use by all State of California departments and available for use by other state departments and local governmental agencies throughout the state. The IFB encompasses ten contract line items (CLINs) covering various paint formulations including latex exterior paint in flat, eggshell, and semi-gloss finishes; graffiti cover-up paint; and primer, available in both one-gallon and five-gallon sizes. Three-year estimated quantities range from 20 gallons for eggshell finish five-gallon containers to 18,300 gallons for graffiti cover-up five-gallon containers, with total estimated purchases reaching approximately 22,530 gallons across all product lines. The award methodology is "All or None," meaning bidders must supply the complete range of paint products to be eligible for contract award.
Bidders must complete only the yellow input cells on the pricing worksheet, providing list prices, contract unit prices, and calculated contract discounts for each line item. The contract discount is calculated using the formula ((List Price/MSRP – Contract Unit Price) / List Price/MSRP), with extensions automatically calculated by multiplying the contract unit price by the estimated quantity. All line items are classified under UNSPSC code 31211506 and use "Each" as the unit of measure, with the quantity in UOM field indicating the number of gallons per container. Electronic bid submissions are not permitted for this event, and bidders must refer to the complete solicitation documentation for specific submission instructions and requirements.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_3_-_Narrative_Response.xlsx | XLSX spreadsheet | |
| APP_Cover_Page.docx | DOCX document | |
| IFB_Event_ID_0000035324.docx | DOCX document | |
| Attachment_2_-_Bid_Specification_8010-BS-0248230.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 | ||||||||||||
| 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 | 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 price available to the general public. | |||||
| This is the proposed contractual price for a given line item, 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. | |||||||||||||
| END OF SHEET. | |||||||||||||
| END OF SHEET. | |||||||||||||
| END OF SHEET. | |||||||||||||
| END OF SHEET. |
Pricing Worksheet
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000035324, Paint (Exterior, Recycled, Reprocessed) | ||||||||||||
| Attachment 1 - Pricing Worksheet, 11/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) | 3 Year Estimated Quantity | |||||||||||
| (per UOM) | Commodity Description | UNSPSC | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure (UOM) | Quantity in | ||||
| UOM (Gallons) | List Price/MSRP | Contract Unit Price | Contract Discount | Extension | ||||||||
| 100 | 400 | Paint, Latex, Exterior, Recycled, Reprocessed, Flat Finish (1 gallon) | 31211506 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 200 | 600 | Paint, Latex, Exterior, Recycled, Reprocessed, Flat Finish (5 gallon) | 31211506 | Each | 5 | ERROR:#DIV/0! | $ - 0 | |||||
| 300 | 60 | Paint, Latex, Exterior, Recycled, Reprocessed, Eggshell Finish (1 gallon) | 31211506 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 400 | 20 | Paint, Latex, Exterior, Recycled, Reprocessed, Eggshell Finish (5 gallon) | 31211506 | Each | 5 | ERROR:#DIV/0! | $ - 0 | |||||
| 500 | 1,200 | Paint, Latex, Exterior, Recycled, Reprocessed, Semi-Gloss Finish (1 gallon) | 31211506 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 600 | 1,500 | Paint, Latex, Exterior, Recycled, Reprocessed, Semi-Gloss Finish (5 gallon) | 31211506 | Each | 5 | ERROR:#DIV/0! | $ - 0 | |||||
| 700 | 70 | Paint, Latex, Exterior, Recycled, Reprocessed, Graffiti Cover-up (1 gallon) | 31211506 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 800 | 18,300 | Paint, Latex, Exterior, Recycled, Reprocessed, Graffiti Cover-up (5 gallon) | 31211506 | Each | 5 | ERROR:#DIV/0! | $ - 0 | |||||
| 900 | 80 | Paint, Latex, Exterior Recycled, Reprocessed, Primer (1 gallon) | 31211506 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 1000 | 160 | Paint, Latex, Exterior Recycled, Reprocessed, Primer (5 gallon) | 31211506 | Each | 5 | 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) | ||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .