Attachment_1_-_Pricing_Workbook.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Inclement Weather Protective Ensembles
- Solicitation number
- 0000035796
- Issued by
- California
About this file
This is a Pricing Workbook for a state and local contract opportunity issued by the Department of General Services - Procurement Division for Inclement Weather Protective Ensembles (Event ID: 0000035796). The solicitation encompasses two primary product groups: IWPE Jackets and IWPE Pants, available in multiple sizes and lengths to accommodate male and female personnel. Group 1 includes six line items (CLINs 100-105) for jackets in sizes ranging from Small through XL to XXXXL and above, with short, regular, and tall length options, totaling 2,738 estimated jackets over a two-year period. Group 2 includes six line items (CLINs 200-205) for protective pants with similar size and length variations, totaling 2,738 estimated pants. A seventh CLIN (106) is included for pricing a discount applicable to jackets without logos. All items are classified under UNSPSC code 46181533 for jackets and 46181527 for pants, with unit of measure specified as "each."
Bidders are required to complete yellow input cells in the workbook, providing List Price/MSRP, Contract Unit Price, and Contract Discount information for evaluation purposes. The Contract Discount is automatically calculated using the formula ((List Price/MSRP - Contract Unit Price) / List Price/MSRP), and the Extension is calculated by multiplying the Contract Unit Price by the estimated quantity. The workbook is structured to allow bidders to propose pricing for each size and length variation separately, enabling the state to evaluate total two-year costs across all line items. All calculated fields display error messages until bidder pricing data is entered, indicating this is a blank template awaiting completion by prospective contractors.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| APP_Cover_Page.docx | DOCX document | |
| IFB_Event_ID_0000035796.docx | DOCX document | |
| Attachment_2_-_Specification_4210-TS-0258645.pdf | ||
| Attachment_3_-_Narrative_Response.xlsx | XLSX spreadsheet | |
| Attachment_4_-_CAL_FIRE_AML.pdf | ||
| Attachment_5_-_OEM_SKU_List.xlsx | XLSX spreadsheet |
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 Workbook Key
| PRICING WORKBOOK KEY | |||||||||||||||
| Column Number | Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column I | Column J | Column K | Column L | Column M | Column N | |
| Column Name | Contract Line Item Number (CLIN) | ||||||||||||||
| Two (2) Year Estimated Quantity | |||||||||||||||
| (per UOM) | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | Base SKU # | Item Description | Unit of Measure | Quantity in | |||||||
| Unit of Measure | 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. | Identifies manufacturer's unique identifier for a particular line item. | Identifies the manufacturer's name for each line item. | A base SKU refers to the core identifier for a product before any variations (like size, color, or configuration) are added. It’s essentially the “parent” or foundational Stock Keeping Unit that represents the general product type. | 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. | ||||||||||||||
| For commodities with a fixed price structure, discount is derived based on the following calculation: ((List Price - Contract 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. | This field is automatically calculated (Quantity in Column B multiplied by the Price Per Unit in Column M) and is used for evaluation purposes.. | ||||||||||||||
| Format | Variable Character | Number | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | Currency | Percentage | Currency | Currency | |
| Example | 100 | 3204 | IWPE Jacket | 43211503 | PT-674344457 | HP | JH/4567C | HP Compaq 8710p Notebook PC | EACH | 1 | $2,500.00 | 66% | $1,650.00 | $1,650.00 | |
| END OF SHEET. |
Group 1 - IWPE Jackets
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000035796, Inclement Weather Protective Ensembles | ||||||||||||
| Attachment 1 - Pricing Workbook, 10/21/2025 | ||||||||||||
| Bidder: | Blank | |||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | ||||||||||||
| Contract Line Item # (CLIN) | Two (2) Year Estimated Quantity | |||||||||||
| (per UOM) | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | Base SKU # | Item Description | Unit of Measure (UOM) | Quantity in | ||||
| Unit of Measure | List Price/MSRP (if applicable) | Contract Discount | Contract Unit Price | Extension | ||||||||
| 100 | 1600 | Inclement Weather Protective Jacket (Sizes: Male and Female, Small through XL, Short and Regular Lengths) | 46181533 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 101 | 800 | Inclement Weather Protective Jacket (Sizes: Male and Female, Small through XL, Tall Length) | 46181533 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 102 | 134 | Inclement Weather Protective Jacket (Sizes: Male and Female, XXL through XXXL, Short and Regular Lengths) | 46181533 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 103 | 134 | Inclement Weather Protective Jacket (Sizes: Male and Female, XXL through XXXL, Tall Length) | 46181533 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 104 | 35 | Inclement Weather Protective Jacket (Sizes: Male and Female, XXXXL and above, Short and Regular Lengths) | 46181533 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 105 | 35 | Inclement Weather Protective Jacket (Sizes: Male and Female, XXXXL and above, Tall Length) | 46181533 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 106 | 1 | Price decrease per jacket for no logo (not included in evaluated price). | N/A | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| TOTAL: | $ - 0 | |||||||||||
| Note: Contract Discount is automatically calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Estimated Quantity) | ||||||||||||
| Note: Total Extension is automatically calculated for CLINs 100 through 105. Does not include CLIN 106. | ||||||||||||
| End of Sheet |
Page &P
Group 2 - IWPE Pants
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000035796, Inclement Weather Protective Ensembles | ||||||||||||
| Attachment 1 - Pricing Workbook, 10/21/2025 | ||||||||||||
| Bidder: | Blank | |||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | ||||||||||||
| Contract Line Item # (CLIN) | Two (2) Year Estimated Quantity | |||||||||||
| (per UOM) | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | Base SKU # | Item Description | Unit of Measure (UOM) | Quantity in | ||||
| Unit of Measure | List Price/MSRP (if applicable) | Contract Discount | Contract Unit Price | Extension | ||||||||
| 200 | 1600 | Inclement Weather Protective Pant (Sizes: Male and Female, Small through XL, Short and Regular Lengths) | 46181527 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 201 | 800 | Inclement Weather Protective Pant (Sizes: Male and Female, Small through XL, Tall Length) | 46181527 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 202 | 134 | Inclement Weather Protective Pant (Sizes: Male and Female, XXL through XXXL, Short and Regular Lengths) | 46181527 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 203 | 134 | Inclement Weather Protective Pant (Sizes: Male and Female, XXL through XXXL, Tall Length) | 46181527 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 204 | 35 | Inclement Weather Protective Pant (Sizes: Male and Female, XXXXL and above, Short and Regular Lengths) | 46181527 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 205 | 35 | Inclement Weather Protective Pant (Sizes: Male and Female, XXXXL and above, Tall Length) | 46181527 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| TOTAL: | $ - 0 | |||||||||||
| Note: Contract Discount is automatically calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Estimated Quantity) | ||||||||||||
| Note: Total Extension is automatically calculated for CLINs 200 through 205. | ||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .