1._Pricing_Workbook_0000035894.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Pavement Markers
- Solicitation number
- 0000035894
- Issued by
- Sacramento County, San Francisco City, California
About this file
This is a Pricing Worksheet for the Department of General Services Procurement Division, Event ID 0000035894, specifically for Pavement Markers. The solicitation covers three primary groups of pavement markers: Group 1 standard pavement markers (various types including RY, D, H, G, C, and R), Group 2 temporary pavement markers for short-term day/night use, and Group 3 pavement markers for recessed applications. The total estimated quantities across these groups range from 500 to 230,400 units per marker type, with a total estimated procurement of approximately 579,700 markers. The contract appears to be structured for a three-year term, with markers specified as having minimum dimensions and abrasion-resistant surfaces, packaged in cartons of 100 or 500 units.
The pricing worksheet is designed for bidders to input unit pricing, with columns for UNSPSC codes, manufacturer part numbers, list prices, contract unit prices, and contract discounts. A unique feature is the inclusion of a non-mandatory take-back service line item. The worksheet uses formulas to calculate contract discounts and extensions, allowing for dynamic pricing calculations. While specific pricing details are not completed in this template, the document provides a structured approach for vendors to quote prices for different pavement marker types, with an emphasis on standardized specifications and comprehensive product categorization across different marker applications and configurations.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 0._IFB_0000035894.docx | DOCX document | |
| 00._APP_Cover_Page_00000358994.docx | DOCX document | |
| 2._IFB_Narrative_Response_0000035894.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 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. |
Core Items
| Department of General Services - Procurement Division | ||||||||||
| Event ID: 0000035894, Pavement Markers | ||||||||||
| Attachment 1 - Pricing Worksheet, 7/7/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 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 | ||||||
| Group 1 - Pavement Markers |
(length x width) - Minimum 3 inch x 4 inch
| 1 | 25000 | Type RY, Reflectorized 2-way, Red & Yellow, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | |
| 2 | 116000 | Type D, Reflectorized 2-way, Yellow, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | |
| 3 | 30200 | Type H, Reflectorized 1-way, Yellow, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | |
| 4 | 43000 | Type G, Reflectorized 1-way, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | |
| 5 | 135000 | Type C, Reflectorized 2-way, Red and Clear, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | |
| 6 | 230400 | Type R, Reflectorized 1-way, Red, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | |
| TOTAL Group 1 | $ - 0 | |||||||
| Group 2 - Temporary Pavement Markers |
Short term day/night use (14 days or less)
| 7 | 25000 | Chip and Seal Type, 2-way, Yellow, Flex Self Adhesive - 500 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | |
| 8 | 25000 | Chip and Seal Type, 1-way, Flex Self Adhesive - 500 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | |
| TOTAL Group 2 | $ - 0 | |||||||
| Group 3 - Pavement Markers for Recessed Application |
(length x width) Minimum 2 inch x 4.5 inch
| 9 | 500000 | Type D, Reflectorized 2-way, Yellow, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | ||||
| 10 | 200000 | Type H, Reflectorized 1-way, Yellow, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | ||||
| 11 | 128000 | Type G, Reflectorized 1-way, Clear, Abrasion Resistant Surface - 100 per Carton | 13111064 | EA | 1 | ERROR:#DIV/0! | $ - 0 | ||||
| TOTAL Group 3 | $ - 0 | ||||||||||
| Take Back Service | |||||||||||
| 12 | 1 | Take-Back cost per unit - Non-Mandatory | |||||||||
| (not included in evaluated price) | N/A | N/A | N/A | EA | 1 | ERROR:#DIV/0! | $ - 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 .