Attachment_1_-_Pricing_Worksheet_Wildland_PPE.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- Wildland PPE
- Solicitation number
- 0000033987
- Issued by
- California
About this file
This document is a Pricing Worksheet for Wildland Personal Protective Equipment (PPE) issued by the Department of General Services - Procurement Division, with Event ID 0000033987. The worksheet covers a three-year contract for wildland firefighting apparel, specifically detailing three primary line items: Wildland Dual-Compliant Tactical Pants (28,350 units), Wildland Dual-Compliant Work/Uniform Pants (8,400 units), and Wildland Jackets (16,500 units). The contract appears to be structured with unit pricing, allowing bidders to complete yellow input cells with list prices, manufacturer details, and contract discounts.
The pricing worksheet provides a comprehensive template for bidders to submit pricing information, including requirements for UNSPSC codes, manufacturer part numbers, SKU details, and unit of measure. While the current worksheet shows calculation errors (displaying "ERROR:#DIV/0!" in some cells), it is designed to automatically calculate contract discounts and total extensions based on list prices and quantities. The document suggests a standardized approach to pricing wildland PPE, with an emphasis on transparent pricing methodology and detailed product specifications. The contract term is set to expire on 7/1/2025, indicating a multi-year procurement strategy for essential firefighting personal protective equipment.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| APP_Cover_Page__0000033987.docx | DOCX document | |
| Attachment_2_-__State_of_CA_Bid_Spec_4210-TS-0235559.pdf | ||
| IFB_0000033987_Wildland_PPE.docx | DOCX document | |
| Attachment_3_-_Narrative_Response.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 A | Column D | Column E | Column F | Column G | Column H | Column I | Column J | Column K | Column M | Column L |
| 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 |
| 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 %.
| 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% |
| END OF SHEET. | |||||||||||
| NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.). | |||||||||||
| END OF SHEET. |
Wildland PPE
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000033987, Wildland PPE | ||||||||||||
| Attachment 1 - Pricing Worksheet, 7/1/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 (UOM) | Quantity in | ||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||
| 1 | 28350 | Wildland Dual-Compliant Pant (Tactical) | 46181500 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 2 | 8400 | Wildland Dual-Compliant Pant (Work/Uniform Pant) | 46181500 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 3 | 16500 | Wildland Jacket | 46181500 | 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 .