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 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 NameContract Line Item Number (CLIN)
Estimated Annual Quantity (Per Round)Commodity DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item Description# of Rounds Per Box# of Boxes Per CasePrice Per RoundList Price/MSRP Per BoxContract Discount % Per BoxEvaluated Extended Price
DescriptionUnique 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.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).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..
FormatVariable CharacterNumberVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberCurrencyCurrencyPercentageCurrency
Example6251,000Laptop43211503PT-674344457HP4576543245-JH/4567CHP Compaq 8710p Notebook PC2048$1.00$2,500.0066%$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 CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item Description# of Rounds Per Box# of Boxes Per CasePrice Per RoundList Price/MSRP Per BoxContract Discount % Per BoxEvaluated Extended Price
HANDGUN, 9mm LUGER/NATO
100348,000124 Grain, Full Metal Jack (FMJ), Ballistic46101600
1011,500,000124-147 Grain, Controlled Expansion46101600
10247,500100 Grain, Lead-Free, Frangible46101600
1032,400,000147 Grain, Full Metal Jacket (FMJ), Ballistic46101600
1042,900,000135-147 Grain, Ballistic46101600
10560,000115 Grain, Full Metal Jacket (FMJ), Ballistic46101600
10635,000150 Grain, Total Synthetic Jacket (TSJ)46101600
1071,250,000147 Grain, Total Metal Jacket (TMJ), Clean Fire46101600
HANDGUN, .38 SPECIAL
2001,000130-135 Grain, Full Metal Jacket (FMJ), Ballistic46101600
2016,500125-135 Grain, Controlled Expansion46101600
HANDGUN, .357 SIG
3001,000125 Grain, Ballistic46101600
3013,000125-135 Grain, Controlled Expansion46101600
3021,000100 Grain, Lead-Free, Frangible46101600
HANDGUN, .40 SMITH & WESSON (S&W)
400200,000180 Grain, Full Metal Jacket (FMJ), Ballistic46101600
4015,000,000175-180 Grain, Controlled Expansion46101600
402500,000125-135 Grain, Lead Free, Frangible46101600
403250,000180 Grain, Clean Fire46101600
HANDGUN, .45 AUTOMATIC COLT PISTOL (ACP)
50050,000230 Grain, Full Metal Jacket (FMJ), Ballistic46101600
50122,500220-230 Grain, Controlled Expansion46101600
5021,000185 Grain, Lead-Free, Controlled Expansion46101600
5031,000155-175 Grain, Lead-Free, Frangible46101600
SHOTGUN, 12 GAUGE
60080,0002 3/4 inch, 1 ounce Slug46101600
601500,0002 3/4 inch, 9 Pellet, 00 Buck46101600
60250,0002 3/4 inch, Lead Free, Frangible, 9 Pellet, 00 Buck46101600
6031,0002 3/4 inch, 9 Pellet, 00 Buck, Low Recoil46101600
RIFLE, .223 REMINGTON/5.56mm NATO
700600,00055 Grain, Full Metal Jacket (FMJ), Ballistic46101600
701450,00062 Grain, Ballistic46101600
7021,00062 Grain, Penetrator/M85546101600
703175,00055 Grain, Controlled Expansion46101600
7041,500,00055 Grain, Soft Point46101600
7052,500,00062/64 Grain, Soft Point46101600
706100,00055 Grain, Lead-Free, Frangible46101600
RIFLE, .308 WINCHESTER/7.62mm NATO
8001,000147-150 Grain, Ballistic46101600
8011,000150 Grain, Lead-Free, Controlled Expansion46101600
802115,000165-168 Grain, Controlled Expansion46101600
8031,000165-168 Grain, Lead-Free, Controlled Expansion46101600
80450,000168 Grain, Open Tip Match46101600
8052,000175-180 Grain, Open Tip Match46101600
80635,000168 Grain, Tipped Matchking46101600
RIFLE, .338 LAPUA
900400250 Grain, Boat Tail Hollow Point46101600
901700300 Grain, Boat Tail Hollow Point46101600
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 .