Attachment_2_Cost_Worksheet_FINAL2.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
CAL FIRE Structural Fire Fighting Turnout (DGS-OTA)
Solicitation number
0000030775
Issued by
California

About this file

This document is a cost worksheet template from the California Department of General Services - Procurement Division for a state-wide structural fire fighting protective ensemble contract. The contract covers the purchase of turnout jackets and pants in four different geographic locations across the state, with a total quantity of 814 units. The contract specifications are defined in State of California Specification # 4210-0330227 dated 04/24/2024. Bidders must submit pricing for the unit cost and extended cost for each line item, including shipping and handling. The bid is due on an unspecified date, and the contract term is not provided.

The cost worksheet template includes fields for the contract line item number, unit of measure, manufacturer part number, manufacturer name, supplier SKU number, product description, and unit price. Bidders must complete the yellow input cells with their pricing information. The total cost will include a subtotal for each location group and the overall total, as well as applicable sales tax.

View the file

Other files

File Type Posted
Alternative_Protest_Process.doc DOC document
Attachment_4_Work_Authorization_Form1.docx DOCX document
IFB_3540_0000030775_FINAL2.docx DOCX document
Attachment_3_Narrative_Response.docx DOCX document
Attachment_1_Specification.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)

NOTE TO Buyers:

This template is to be used as a guide for Buyers developing cost worksheets for one-time solicitations (IFBs or RFQs). Buyerss are required to review the following information before developing cost worksheets.

● The columns below represent POSSIBLE data fields that could be required in a cost worksheet.

● Each Cost Worksheet should have a worksheet for field definitions or clear completion instructions within the solicitation.

● For ADA Purposes: Provide a data validation input message for every cell (be as descriptive as possible) in the table and every input cell; lock/unlock cells where appropriate; do not merge or split cells within a table; delete or hide all unused rows and columns; rename workbook tabs (be as descriptive as possible); write "End of Sheet" or "End of Worksheet" in the last row for each sheet; set print area; prior to posting, protect sheet allowing "select locked cells" and "select unlocked cells" only.

***Delete these instructions before release***

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 General Services - Procurement Division
BU 3540, Event ID 0000030775, Structural Fire Fighting Protective Ensemble
Attachment 2 - Cost Worksheet
Bidder:Blank
Instructions: Unit and Extended Cost must include both shipping and handling costs. Refer to Event's Cost language section, for completion instructions. Bidder must complete the Yellow Input Cells .
Group 1Location: MEU Service Center 17501 North Hwy 101 Willits, CA 95490
Line Item # (LIN)QuantityUnit of MeasureCommodity DescriptionProposed Product DescriptionUnit CostExtension Cost
1-1148EachCategory 2 Structural Turnouts Jackets as described in State of California Specification # 4210-0330227 dated 04/24/2024$ - 0
1-2148EachCategory 2 Structural Turnouts Pants as described in State of California Specification # 4210-0330227 dated 04/24/2024$ - 0
Subtotal:$ - 0
Sales Tax:$ - 0
Total Cost:$ - 0
Group 2Location: BTU Service Center 434 B ST. Biggs, CA. 95917
Line Item # (LIN)QuantityUnit of MeasureCommodity DescriptionProposed Product DescriptionUnit CostExtension Cost
2-1130EachCategory 2 Structural Turnouts Jackets as described in State of California Specification # 4210-0330227 dated 04/24/2024$ - 0
2-2130EachCategory 2 Structural Turnouts Pants as described in State of California Specification # 4210-0330227 dated 04/24/2024$ - 0
Subtotal:$ - 0
Sales Tax:$ - 0
Total Cost:$ - 0
Group 3Location: HUU Service Center 118 S. Fortuna Blvd, CA. 95540
Line Item # (LIN)QuantityUnit of MeasureCommodity DescriptionProposed Product DescriptionUnit CostExtension Cost
3-1120EachCategory 1 Structural Turnouts Jackets as described in State of California Specification # 4210-0330227 dated 04/24/2024$ - 0
3-2120EachCategory 1 Structural Turnouts Pants as described in State of California Specification # 4210-0330227 dated 04/24/2024$ - 0
Subtotal:$ - 0
Sales Tax:$ - 0
Total Cost:$ - 0
Group 4Location: MMU Service Center – 5366 HWY 49 North Mariposa, CA 95338
Line Item # (LIN)QuantityUnit of MeasureCommodity DescriptionProposed Product DescriptionUnit CostExtension Cost
4-1286EachCategory 2 Structural Turnouts Jackets as described in State of California Specification # 4210-0330227 dated 04/24/2024$ - 0
4-2286EachCategory 2 Structural Turnouts Pants as described in State of California Specification # 4210-0330227 dated 04/24/2024$ - 0
Subtotal:$ - 0
Sales Tax:$ - 0
Total Cost:$ - 0
Total Cost:$ - 0

End of Sheet

Page &P

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