Attachment_1_-_Pricing_Workbook.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- 0000039133
- Issued by
- Sacramento County, San Francisco City, California
About this file
This is a Pricing Workbook attachment for a state and local contract opportunity administered by the Department of General Services - Procurement Division (Event ID: 0000039133). The solicitation encompasses two groups for Sander Body with Anti-Ice, Directional Roll-Off equipment. Group 1 requests a 3-year estimated quantity of 30 units, while Group 2 requests 50 units over the same 3-year period. Both groups utilize UNSPSC code 22101700 and require bidders to submit pricing for each contract line item. The workbook is structured to collect manufacturer information, part numbers, item descriptions, and unit pricing, with the document dated 9/25/26.
Bidders are required to complete only the yellow input cells within the pricing workbook, providing List Price/MSRP, Contract Unit Price, and allowing the Contract Discount to be automatically calculated using the formula ((List Price/MSRP - Contract Unit Price) / List Price/MSRP). The extension for each line item is automatically calculated by multiplying the Contract Unit Price by the quantity. The unit of measure for both groups is specified as "Each" with a quantity in unit of measure of 1. The workbook currently displays error values and zero totals, indicating that bidder pricing information has not yet been entered. No specific response dates, award dates, incumbent information, or funding source details are provided in this pricing document.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| APP_Cover_Page.docx | DOCX document | |
| Attachment_4_-_Schematic_Drawing__3CY_.pdf | ||
| IFB_Event_ID_0000039133.docx | DOCX document | |
| Attachment_2b_-_Technical_Questionnaire__3CY_.xlsx | XLSX spreadsheet | |
| Attachment_3_-_Narrative_Response.xlsx | XLSX spreadsheet | |
| Attachment_4a_-_Schematic_Drawing__6CY_.pdf | ||
| Attachment_2a_-_Bid_Spec_BDYROFDSBTK33-430-261T__3CY_.pdf | ||
| Attachment_2d_-_Technical_Questionnaire__6CY_.xlsx | XLSX spreadsheet | |
| Attachment_2c_-_Bid_Spec_BDYROFDSBTK53-430-261T__6CY_.pdf | ||
| Attachment_2_-_Admin_Bid_Spec__3CY_and_6CY_.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) | |||||
| 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 |
| 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 %.
| Format | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | Currency | Currency | Percentage |
| Example | 625 | 43211503 | PT-674344457 | HP | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | BOX | 10 | $2,500.00 | $1,650.00 | 66% |
| CORE - Often refers to a Fixed Price. | |||||||||||
| END OF SHEET. |
Group 1
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000039133, 3CY, Sander Body with Anti-Ice, Directional Roll-Off | ||||||||||||
| Attachment 1 - Pricing Workbook, 9/25/26 | ||||||||||||
| 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 | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Unit Price | Extension | ||||||||
| 1 | 30 | 3CY, Sander Body with Anti-Ice, Directional Roll-Off | 22101700 | Each | 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) | ||||||||||||
| End of Sheet |
Page &P
Group 2
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000039133, 6CY, Sander Body with Anti-Ice, Directional Roll-Off | ||||||||||||
| Attachment 1 - Pricing Workbook, 9/25/26 | ||||||||||||
| 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 | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Unit Price | Extension | ||||||||
| 1 | 50 | 6CY, Sander Body with Anti-Ice, Directional Roll-Off | 22101700 | Each | 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) | ||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .