Cost_Worksheet.xlsx

XLSX spreadsheet 17 KB Posted

Attached to
IFB 24-010 Handguns Purchase and Trade-In
Solicitation number
0000034562
Issued by
Sacramento County, Sacramento City, San Francisco City, West Sacramento City, California

About this file

This is a Cost Worksheet for the Department of Cannabis Control's Acquisitions Unit, specifically for Invitation for Bid (IFB) 24-010 involving a handgun purchase and trade-in program. The procurement covers 41 Bravo IWB Holsters, 43 Safariland 6305RDS Glock holsters, 45 Holosun MOS Green Multi-Reticle optics, and 54 Glock 19 Gen 5 MOS 9mm handguns, with additional line items for sales tax and trade-in credits for existing Glock G19 Gen4 and Sig Sauer P320 Pro firearms.

The cost worksheet provides a detailed pricing template with placeholders for unit costs and extension costs, allowing bidders to complete yellow and blue input cells. The worksheet includes provisions for trade-in credits for existing firearms, with a sales tax rate of 7.75% applied to the new item subtotal. The document appears to be a standardized procurement template designed to capture precise pricing information for a comprehensive firearms equipment refresh, with line items that facilitate both new equipment acquisition and existing equipment trade-in.

View the file

Other files

File Type Posted
IFB_24-010_Handguns.pdf PDF

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

Cost Worksheet Key

PRICING WORKSHEET KEY
COST WORKSHEET TEMPLATE

(Rev 8/30/2022)

Column NameContract Line Item Number (CLIN)
Unit of MeasureManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Proposed Product DescriptionContract Unit Price
DescriptionUnique line item number.Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc).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 is the contractual price for a given line item based on the price that was bid, as relative to the

unit of measure.

END OF SHEET.
END OF SHEET.

Cost Worksheet

Department of Cannabis Control - Acquisitions Unit
BU 1115 IFB 24-010 Handguns Purchase and Trade-In
Cost Worksheet
Bidder:
Instructions: Refer to IFB Cost language for completion instructions. Bidder must complete the Yellow and Blue Input Cells only.
Line Item # (LIN)QuantityUnit of MeasureItem/DescriptionUnit CostExtension Cost
1-141EachBC20-1001, Bravo IWB Holsters Right Handed$ - 0
1-243Each6305RDS-2832-131, Safariland 6305RDS Glock 19/23 x300U STX TAC BLK RH$ - 0
1-345EachSCS-M-GR, Holosun MOS Green Multi-Rectical 2 MOA Dot LEM MODEL$ - 0
1-454EachGlock 19, Gen 5 MOS 9mm Handguns FXD, 15 Rounds Option$ - 0
1-51EachSALES TAX ON NEW ITEM SUBTOTAL @ 7.75%$ - 0
1-639EachTRADE IN GLOCK G19 GEN4 W/ 2-3 MAGAZINES EACH$ - 0
1-723EachTRADE IN SIG SAUER P320 PRO W/ 2-3 MAGAZINES EACH$ - 0
Total Cost:$ - 0
Note: Extension is automatically calculated (Contract Unit Price x Quantity).
Line Items # 1-6 and 1-7 (blue cells) are credits provided for trading in equipment. Enter -(Unit Price)
Unit and Extension Cost must include Shipping and Handling.
End of Sheet

Page &P

File details come from the government source that posted it. Updated .