Attachment_2_-_COST_WORKSHEET_7PA6J00743.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
7PA6J00743 AMU Electronic Control-Unit Assembly
Solicitation number
0000040610
Issued by
Sacramento County, California

About this file

This is a cost worksheet template for an Invitation for Bid (IFB) issued by the California Department of Forestry and Fire Protection (CAL FIRE), Business Service Office, for an Electronic Control-Unit Assembly to be used by the Aviation Management Unit located in McClellan, California in Sacramento County. The procurement document number is 7PA6J00743. The solicitation requires bidders to supply two units of an Electronic Control-Unit Assembly, with each unit measured individually. Bidders are instructed to complete only the yellow input cells in the worksheet and must provide detailed commodity and product descriptions that demonstrate consistency with specifications.

The cost worksheet requires bidders to submit a unit cost and extended cost (calculated as contract unit price multiplied by quantity) for the Electronic Control-Unit Assembly line item, with both shipping and handling costs included in the pricing. Bidders must also account for applicable sales tax. The worksheet includes standard fields for contract line item numbers, unit of measure, manufacturer information, SKU details, and product descriptions. All pricing terms and completion instructions are referenced in Section 18 of the IFB cost language document. The worksheet is designed with accessibility features including data validation messages, locked and unlocked cells, and designated input areas for bidder completion.

View the file

Other files

File Type Posted
Attachment_4_-_SPECIFICATIONS_7PA6J00743.pdf PDF
Bidder_Declaration.pdf PDF
std204.pdf PDF
Bidder_Instructions.pdf PDF
CAL_FIRE_Agreement_Letter.pdf PDF
Cal_Recycle_Form.pdf PDF
calfire720.docx DOCX document
Attachment_3_-_NARRATIVE_RESPONSE_7PA6J00743.docx DOCX document
CALIFORNIA_CIVIL_RIGHTS_LAWS_ATTACHMENT.pdf PDF
Attachment_1_-_ADMIN_REQUIREMENTS_7PA6J00743.pdf PDF
std205.pdf PDF
IFB_7PA6J00743.pdf PDF
Show all 12

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 Forestry and Fire Protection - Business Service Office, Procurement
Document ID # 7PA6J00743 - Item Description
Attachment 2 - Cost Worksheet
Bidder:Blank
Instructions: Unit and Extended Cost must include both shipping and handling costs. Refer to IFB Cost language, Section 18, for completion instructions. Bidder must complete the Yellow Input Cells only.
Line ItemQuantityUnit of MeasureCommodity DescriptionProposed Product DescriptionUnit CostExtension Cost
1-12EachElectronic Control-Unit Assembly
Subtotal:$ - 0
Sales Tax:_______
Total Cost:$ - 0
Note: Extension is automatically calculated (Contract Unit Price x Quantity)
End of Sheet

Page &P

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