Att.2_-_Cost_Worksheet.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
UPS Batteries (DGS-OTA)
Solicitation number
0000035332
Issued by
California

About this file

This document is a Cost Worksheet template from the Department of General Services - Procurement Division for an Uninterruptible Power Supply (UPS) batteries solicitation with Event ID 0000035332. The procurement involves 32 APC High Performance Battery Modules for the Symmetra PX 250/500kW system, specifically 32 batteries with 6 units per battery (totaling 192 units), along with a heavy pickup recycling/disposal service. The worksheet is designed for bidders to complete yellow input cells with pricing and product information.

The cost worksheet provides a structured template for vendors to submit pricing, requiring details such as manufacturer part numbers, SKU numbers, unit of measure, and unit costs. While the current worksheet shows zero dollar amounts, it indicates that bidders must provide comprehensive pricing information consistent with the solicitation's specifications. The document emphasizes the need for detailed product descriptions and precise unit cost calculations, with a note referencing additional instructions in the Invitation for Bid (IFB) packet regarding destination, freight, travel, and installation costs.

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 0820, Event ID 0000035332, APC Uninterruptible Power Supply (UPS) batteries
Attachment 2 - Cost Worksheet
Bidder:
Instructions: Refer to Event Cost language, for completion instructions. Bidder must complete the Yellow Input Cells only.
Line ItemQuantityUnit of MeasureService/Commodity DescriptionSKUUnit CostExtension Cost
1-132EachAPC High Performance Battery Module for the Symmetra PX 250/500kW
32 Batteries with 6 Units each battery =192 Unit TotalSYBT9-B6**0
1-41EachHeavy Pickup Recycling/DisposalWSRV-QJTR02525-00$ - 0
Total Cost:$ - 0
**Note: Please refer to the IFB packet for detailed instructions regarding FOB destination, freight prepaid, travel, and installation costs.

Page &P

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