Attachment_1_-_Pricing_Worksheet.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- Ammunition, Factory loaded
- Solicitation number
- 0000037533
- Issued by
- California
About this file
This is a pricing worksheet attachment associated with an Invitation For Bid issued by the California Department of General Services, Procurement Division for a statewide contract to supply factory-loaded ammunition. The solicitation seeks qualified firms to establish a multi-year contract with a primary term of three years, followed by two optional one-year extension periods, making the maximum contract duration five years. The contract is mandatory for use by all State of California departments and available for use by local governmental agencies on a statewide basis. The award methodology is structured by line item, allowing for differentiated pricing across various ammunition types and specifications. The specific file referenced is a pricing worksheet in Excel format that would contain the detailed line items, quantities, unit prices, and extended pricing calculations required for bid submission.
The pricing worksheet serves as the primary document for vendors to submit their cost proposals for the ammunition products requested under this solicitation. This attachment would typically include columns for itemized ammunition specifications, requested quantities, unit pricing, total line item costs, and any applicable discounts or volume-based pricing structures. As a statewide contract with mandatory usage requirements for state departments and optional availability for local agencies, the pricing structure must accommodate varying demand levels and usage patterns across multiple government entities. The worksheet format allows for transparent cost evaluation and comparison among competing bidders, ensuring that the state can identify the most economical pricing while maintaining quality and performance standards for factory-loaded ammunition supplies.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| APP_Cover_Page__rev_1-15_.docx | DOCX document | |
| IFB_Event_0000037533.docx | DOCX document | |
| Attachment_4_-_CHP_Approved_Brands_List.xlsx | XLSX spreadsheet | |
| Attachment_2_-_Specifications.pdf | ||
| Attachment_3_-_Narrative_Response.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 Worksheet Key
| PRICING WORKSHEET KEY | ||||||||||||
| Column Name | Contract Line Item Number (CLIN) | |||||||||||
| Estimated Annual Quantity (Per Round) | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | # of Rounds Per Box | # of Boxes Per Case | Price Per Round | List Price/MSRP Per Box | Contract Discount % Per Box | Evaluated Extended Price |
| Description | Unique line item number. | The State's estimated annual 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.
| 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). | This field will carry the number of base units in the packaging of the products | ||||||||||
| (i.e. # of pencils in a box). | This field will carry the number of boxes in a case of the line item product | ||||||||||||||
| (i.e. # of boxes in a case). | This is the contractual unit price for a given line item. | An independently verifiable price available to the general public for the price of one box. | |||||||||||||
| This field is automatically calculated. Discount is derived based on the following calculation: (((List Price - (Price Per Round*Rounds Per Box))/List Price) = Contract Discount %. | This field is automatically calculated (Quantity in Column 2 multiplied by the Price Per Round in Column 11) 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 | Currency | Percentage | Currency | |
| Example | 625 | 1,000 | Laptop | 43211503 | PT-674344457 | HP | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | 20 | 48 | $1.00 | $2,500.00 | 66% | $1,000.00 | |
| END OF SHEET |
Ammunition
| Department of General Services - Procurement Division | |||||||||||
| Event ID: 0000037533, Ammunition, Factory Loaded | |||||||||||
| Attachment 1 - Pricing Worksheet, 06/22/2026 | |||||||||||
| Bidder: | Blank | ||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | |||||||||||
| Contract Line Item # (CLIN) | Estimated Annual Quantity (Per Round) | Commodity Description | |||||||||
| (See Attachment 2 - Approved Brands List (ABL) for approved Brands and Models) | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | # of Rounds Per Box | # of Boxes Per Case | Price Per Round | List Price/MSRP Per Box | Contract Discount % Per Box | Evaluated Extended Price |
| HANDGUN, 9mm LUGER/NATO | |||||||||||
| 100 | 348,000 | 124 Grain, Full Metal Jack (FMJ), Ballistic | 46101600 | ||||||||
| 101 | 1,500,000 | 124-147 Grain, Controlled Expansion | 46101600 | ||||||||
| 102 | 47,500 | 100 Grain, Lead-Free, Frangible | 46101600 | ||||||||
| 103 | 2,400,000 | 147 Grain, Full Metal Jacket (FMJ), Ballistic | 46101600 | ||||||||
| 104 | 2,900,000 | 135-147 Grain, Ballistic | 46101600 | ||||||||
| 105 | 60,000 | 115 Grain, Full Metal Jacket (FMJ), Ballistic | 46101600 | ||||||||
| 106 | 35,000 | 150 Grain, Total Synthetic Jacket (TSJ) | 46101600 | ||||||||
| 107 | 1,250,000 | 147 Grain, Total Metal Jacket (TMJ), Clean Fire | 46101600 | ||||||||
| HANDGUN, .38 SPECIAL | |||||||||||
| 200 | 1,000 | 130-135 Grain, Full Metal Jacket (FMJ), Ballistic | 46101600 | ||||||||
| 201 | 6,500 | 125-135 Grain, Controlled Expansion | 46101600 | ||||||||
| HANDGUN, .357 SIG | |||||||||||
| 300 | 1,000 | 125 Grain, Ballistic | 46101600 | ||||||||
| 301 | 3,000 | 125-135 Grain, Controlled Expansion | 46101600 | ||||||||
| 302 | 1,000 | 100 Grain, Lead-Free, Frangible | 46101600 | ||||||||
| HANDGUN, .40 SMITH & WESSON (S&W) | |||||||||||
| 400 | 200,000 | 180 Grain, Full Metal Jacket (FMJ), Ballistic | 46101600 | ||||||||
| 401 | 5,000,000 | 175-180 Grain, Controlled Expansion | 46101600 | ||||||||
| 402 | 500,000 | 125-135 Grain, Lead Free, Frangible | 46101600 | ||||||||
| 403 | 250,000 | 180 Grain, Clean Fire | 46101600 | ||||||||
| HANDGUN, .45 AUTOMATIC COLT PISTOL (ACP) | |||||||||||
| 500 | 50,000 | 230 Grain, Full Metal Jacket (FMJ), Ballistic | 46101600 | ||||||||
| 501 | 22,500 | 220-230 Grain, Controlled Expansion | 46101600 | ||||||||
| 502 | 1,000 | 185 Grain, Lead-Free, Controlled Expansion | 46101600 | ||||||||
| 503 | 1,000 | 155-175 Grain, Lead-Free, Frangible | 46101600 | ||||||||
| SHOTGUN, 12 GAUGE | |||||||||||
| 600 | 80,000 | 2 3/4 inch, 1 ounce Slug | 46101600 | ||||||||
| 601 | 500,000 | 2 3/4 inch, 9 Pellet, 00 Buck | 46101600 | ||||||||
| 602 | 50,000 | 2 3/4 inch, Lead Free, Frangible, 9 Pellet, 00 Buck | 46101600 | ||||||||
| 603 | 1,000 | 2 3/4 inch, 9 Pellet, 00 Buck, Low Recoil | 46101600 | ||||||||
| RIFLE, .223 REMINGTON/5.56mm NATO | |||||||||||
| 700 | 600,000 | 55 Grain, Full Metal Jacket (FMJ), Ballistic | 46101600 | ||||||||
| 701 | 450,000 | 62 Grain, Ballistic | 46101600 | ||||||||
| 702 | 1,000 | 62 Grain, Penetrator/M855 | 46101600 | ||||||||
| 703 | 175,000 | 55 Grain, Controlled Expansion | 46101600 | ||||||||
| 704 | 1,500,000 | 55 Grain, Soft Point | 46101600 | ||||||||
| 705 | 2,500,000 | 62/64 Grain, Soft Point | 46101600 | ||||||||
| 706 | 100,000 | 55 Grain, Lead-Free, Frangible | 46101600 | ||||||||
| RIFLE, .308 WINCHESTER/7.62mm NATO | |||||||||||
| 800 | 1,000 | 147-150 Grain, Ballistic | 46101600 | ||||||||
| 801 | 1,000 | 150 Grain, Lead-Free, Controlled Expansion | 46101600 | ||||||||
| 802 | 115,000 | 165-168 Grain, Controlled Expansion | 46101600 | ||||||||
| 803 | 1,000 | 165-168 Grain, Lead-Free, Controlled Expansion | 46101600 | ||||||||
| 804 | 50,000 | 168 Grain, Open Tip Match | 46101600 | ||||||||
| 805 | 2,000 | 175-180 Grain, Open Tip Match | 46101600 | ||||||||
| 806 | 35,000 | 168 Grain, Tipped Matchking | 46101600 | ||||||||
| RIFLE, .338 LAPUA | |||||||||||
| 900 | 400 | 250 Grain, Boat Tail Hollow Point | 46101600 | ||||||||
| 901 | 700 | 300 Grain, Boat Tail Hollow Point | 46101600 | ||||||||
| Evaluated Extended Price is automatically calculated by (Price Per Round X Estimated Quantity Per Round) | |||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .