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 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 LetterColumn AColumn DColumn EColumn FColumn GColumn HColumn IColumn JColumn KColumn LColumn M
Column NameContract Line Item Number (CLIN)
UNSPSCManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

(If Applicable)List Price/MSRPContract Unit PriceContract Discount
DescriptionUnique 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.aspIdentifies 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 %.

FormatVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberCurrencyCurrencyPercentage
Example62543211503PT-674344457HP4576543245-JH/4567CHP Compaq 8710p Notebook PCBOX10$2,500.00$1,650.0066%
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 DescriptionUNSPSCManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of Measure (UOM)Quantity in
Unit of MeasureList Price/MSRPContract Unit PriceContract DiscountExtension
Primary Duty Weapons
116,500Primary Duty Pistol with RMR mounted Red Dot Optics46101504Each1ERROR:#DIV/0!$ - 0
282,500Duty Magazines (Black Base)Each1ERROR:#DIV/0!$ - 0
349,050Training Magazines (Green Base)Each1ERROR:#DIV/0!$ - 0
433,000Magazine Pouch'sEach1ERROR:#DIV/0!$ - 0
514,850Right Hand Primary Duty HolsterEach1ERROR:#DIV/0!$ - 0
61,650Left Hand Primary Duty HolsterEach1ERROR:#DIV/0!$ - 0
73000Red Dot Optics (Same make and model as CLIN 1)Each1ERROR:#DIV/0!$ - 0
8500Parts Kit (Internal Parts)Each1ERROR:#DIV/0!$ - 0
920Replacement Slides with sights and barrelsEach1ERROR:#DIV/0!$ - 0
1010Site PushersEach1ERROR:#DIV/0!$ - 0
11100Back Straps, palm swells, or grip modules (M, L)Each1ERROR:#DIV/0!$ - 0
Supplemental Duty Weapons
121100Supplemental Duty Pistol with Red Dot Optics46101504Each1ERROR:#DIV/0!$ - 0
1320,000Duty Magazines (Black Base)Each1ERROR:#DIV/0!$ - 0
141,100Magazine Pouch'sEach1ERROR:#DIV/0!$ - 0
154,500Right Hand Primary Duty HolsterEach1ERROR:#DIV/0!$ - 0
16500Left Hand Primary Duty HolsterEach1ERROR:#DIV/0!$ - 0
171,000Red Dot Optics (Same make and model as CLIN 12)Each1ERROR:#DIV/0!$ - 0
18100Parts Kit (Internal Parts)Each1ERROR:#DIV/0!$ - 0
1910Replacement Slides with sights and barrelsEach1ERROR:#DIV/0!$ - 0
2010Site PushersEach1ERROR:#DIV/0!$ - 0
2125Back Straps, palm swells, or grip modules (M,L)Each1ERROR:#DIV/0!$ - 0
CORE ITEMS SUBTOTAL:$ - 0
Trade In Pistols and Magazines Credit
Segment ID/Group IDQuantityCommodity DescriptionUNSPSCManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

List Price/MSRP (for evaluation purposes)Contract Unit Price
(Trade In Credit)Contract DiscountExtension
228,145Smith and Wesson M&P40 1.046101504N/AN/AN/AN/AEach1N/ANA$ - 0
231,100Smith and Wesson M&P40c46101504N/AN/AN/AN/AEach1N/AN/A$ - 0
2430,000Used Orange Base Plate S&W M&P 40 Magazines (15rd)N/AN/AN/AN/AEach1N/AN/A$ - 0
2541,000Used Black Base Plate S&W M&P 40 Magazines (15rd)N/AN/AN/AN/AEach1N/AN/A$ - 0
262,250New Black Base Plate S&W M&P 40 Magazines(15rd)N/AN/AN/AN/AEach1N/AN/A$ - 0
273,300Used Black base Plate S&W M&P40c Magazine (10rd)N/AN/AN/AN/AEach1N/AN/A$ - 0
2850New Black base Plate S&W M&P40c Magazine (10rd)N/AN/AN/AN/AEach1NANA$ - 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 .