Att_3_-_Cost_Worksheet.xlsx

XLSX spreadsheet 17 KB Posted

Attached to
Trane Centrifugal Water Chillers (DGS-OTA)
Solicitation number
0000033681
Issued by
Riverside County, California

About this file

This is a Cost Worksheet template from the California Department of General Services - Procurement Division (Event ID 0000033681) for Trane Centrifugal Water Chillers. The worksheet specifically requests pricing for two Trane Centrifugal Water Chillers (Model CVHF048, Part Number CTV, A1, CH-1).

The worksheet is designed to capture unit costs and extended costs, with the requirement that pricing must include both shipping and handling costs. The template includes fields for Line Item Numbers, quantities, units of measure, commodity descriptions, proposed product descriptions, and pricing calculations. The document provides detailed instructions for buyers developing cost worksheets for one-time solicitations (IFBs or RFQs) and includes specific guidance for ADA compliance in worksheet preparation.

View the file

Other files

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 7760, Event ID 0000033681, Trane Centrigual Water Chillers
Attachment 3 - 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 only.
Line Item # (LIN)QuantityUnit of MeasureCommodity DescriptionProposed Product DescriptionUnit CostExtension Cost
1-12EachBrand: Trane

Model: CVHF048.

Part Number: Trane Centrifugal Water Chiller (CTV), A1, CH-1

Brand:

Model:$ - 0
Subtotal:$ - 0
$ - 0
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 .