Attachment_1_Pricing_Worksheet_.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- Handguns CHP
- Solicitation number
- 0000036391
- Issued by
- California
About this file
This is a Pricing Worksheet for a multi-year statewide handgun contract issued by the California Department of General Services, Procurement Division (DGS-PD) on behalf of the California Highway Patrol (CHP). The solicitation seeks qualified bidders to supply primary duty weapons, supplemental duty weapons, magazines, holsters, red dot optics, and related components through an Invitation for Bid (IFB) process. The contract encompasses significant quantities across 21 core line items, including 16,500 primary duty pistols with mounted red dot optics, 82,500 duty magazines with black bases, 49,050 training magazines with green bases, 3,000 additional red dot optics, and various support items such as holsters, magazine pouches, replacement slides, and grip modules. The contract term is three years with seven optional one-year extension periods, and delivery is to the CHP Academy in West Sacramento. The award methodology is "All or None," meaning bidders must propose pricing for the entire package rather than individual line items.
The pricing worksheet includes a trade-in credit segment for existing equipment, comprising 8,145 Smith and Wesson M&P40 1.0 pistols, 1,100 M&P40c pistols, and approximately 76,550 used and new magazines with various base plate colors and capacities. Bidders are required to complete only the yellow input cells on the worksheet, providing List Price/MSRP, Contract Unit Price, and Contract Discount percentage for each line item. The Grand Total price is calculated by subtracting the Trade In Items Credit Subtotal from the Core Items Subtotal. All pricing must be independently verifiable and available to the general public. The worksheet contains error indicators in unfilled cells, signifying that bidder pricing information has not yet been submitted.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Addendum_1_Cover_Sheet.docx | DOCX document | |
| Attachment_3_-_Narrative_Response,_Addendum_1.xlsx | XLSX spreadsheet | |
| Attachment_2_-_Specification_1005-TS-0269749_9-9-25.pdf | ||
| APP_Cover_Page_(rev_1-15).docx | DOCX document | |
| Event_0000036391.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 Letter | Column A | Column D | Column E | Column F | Column G | Column H | Column I | Column J | Column K | Column L | Column M |
| 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. | |||||||||||
| NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.). | |||||||||||
| END OF SHEET. |
Core and Trade In
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000036391, Handguns CHP | ||||||||||||
| Attachment 1 - Pricing Worksheet, 11/10/2025 | ||||||||||||
| Bidder: | Blank | |||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | ||||||||||||
| CORE ITEMS | ||||||||||||
| Contract Line Item # (CLIN) | 10 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 Unit Price | Contract Discount | Extension | ||||||||
| Primary Duty Weapons | ||||||||||||
| 1 | 16,500 | Primary Duty Pistol with RMR mounted Red Dot Optics | 46101504 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 2 | 82,500 | Duty Magazines (Black Base) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 3 | 49,050 | Training Magazines (Green Base) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 4 | 33,000 | Magazine Pouch's | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 5 | 14,850 | Right Hand Primary Duty Holster | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 6 | 1,650 | Left Hand Primary Duty Holster | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 7 | 3000 | Red Dot Optics (Same make and model as CLIN 1) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 8 | 500 | Parts Kit (Internal Parts) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 9 | 20 | Replacement Slides with sights and barrels | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 10 | 10 | Site Pushers | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 11 | 100 | Back Straps, palm swells, or grip modules (M, L) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| Supplemental Duty Weapons | ||||||||||||
| 12 | 1100 | Supplemental Duty Pistol with Red Dot Optics | 46101504 | Each | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 13 | 20,000 | Duty Magazines (Black Base) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 14 | 1,100 | Magazine Pouch's | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 15 | 4,500 | Right Hand Primary Duty Holster | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 16 | 500 | Left Hand Primary Duty Holster | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 17 | 1,000 | Red Dot Optics (Same make and model as CLIN 12) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 18 | 100 | Parts Kit (Internal Parts) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 19 | 10 | Replacement Slides with sights and barrels | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 20 | 10 | Site Pushers | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| 21 | 25 | Back Straps, palm swells, or grip modules (M,L) | Each | 1 | ERROR:#DIV/0! | $ - 0 | ||||||
| CORE ITEMS SUBTOTAL: | $ - 0 | |||||||||||
| Trade In Pistols and Magazines Credit | ||||||||||||
| Segment ID/Group ID | Quantity | Commodity Description | UNSPSC | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure | Quantity in |
Unit of Measure
| List Price/MSRP (for evaluation purposes) | Contract Unit Price | ||||||||||||
| (Trade In Credit) | Contract Discount | Extension | |||||||||||
| 22 | 8,145 | Smith and Wesson M&P40 1.0 | 46101504 | N/A | N/A | N/A | N/A | Each | 1 | N/A | NA | $ - 0 | |
| 23 | 1,100 | Smith and Wesson M&P40c | 46101504 | N/A | N/A | N/A | N/A | Each | 1 | N/A | N/A | $ - 0 | |
| 24 | 30,000 | Used Orange Base Plate S&W M&P 40 Magazines (15rd) | N/A | N/A | N/A | N/A | Each | 1 | N/A | N/A | $ - 0 | ||
| 25 | 41,000 | Used Black Base Plate S&W M&P 40 Magazines (15rd) | N/A | N/A | N/A | N/A | Each | 1 | N/A | N/A | $ - 0 | ||
| 26 | 2,250 | New Black Base Plate S&W M&P 40 Magazines(15rd) | N/A | N/A | N/A | N/A | Each | 1 | N/A | N/A | $ - 0 | ||
| 27 | 3,300 | Used Black base Plate S&W M&P40c Magazine (10rd) | N/A | N/A | N/A | N/A | Each | 1 | N/A | N/A | $ - 0 | ||
| 28 | 50 | New Black base Plate S&W M&P40c Magazine (10rd) | N/A | N/A | N/A | N/A | Each | 1 | NA | NA | $ - 0 | ||
| TRADE IN ITEMS CREDIT SUBTOTAL: | $ - 0 | ||||||||||||
| GRAND TOTAL: | $ - 0 | ||||||||||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | |||||||||||||
| Note: Extension is automatically calculate by (Contract Unit Price x Quantity) | |||||||||||||
| Note: Grand Total is calculated by (Core Items Subtotal - Trade In Items Credit Subtotal) | |||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .