Att.2_Cost_Worksheet.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Floating Restrooms (DGS-OTA)
Solicitation number
0000038979
Issued by
California

About this file

This is a Cost Worksheet template and sample document prepared by the California Department of General Services (DGS) Procurement Division for a Floating Restrooms solicitation (BU 3790, Event ID 38979). The solicitation requests bids for five floating restroom units to be delivered to five separate California reservoir locations: two units for Lake Oroville in Oroville, and one unit each for Lake Elsinore in Lake Elsinore, Lake Shasta in Redding, El Capitan Reservoir in Lakeside (San Diego County), and New Bullard's Bar in Dobbins (Yuba County). Each floating restroom must meet the requirements specified in Attachment 1 and applicable administrative requirements. Bidders are required to complete only the yellow input cells in the cost worksheet, specifically the Unit Cost and Extension Cost columns for each line item. The document emphasizes that any modification to the Cost Worksheet will result in bidder disqualification.

The pricing structure requires bidders to provide unit costs for each floating restroom, with extension costs automatically calculated by multiplying the unit cost by quantity. The sample worksheet provided shows a unit cost of $209,000 per floating restroom for the Lake Oroville line item (quantity 2), resulting in a pre-tax extension cost of $418,000 and a post-tax total of $456,665 when applying the applicable California sales tax rate of 9.25% at the delivery location. Bidders must not enter data into grey-shaded cells, which are reserved for automatic calculations. The evaluated total represents the sum of all extension costs across the five line items. Tax rates must be based on California Department of Tax and Fee Administration rates applicable to each delivery location. Bids must be submitted in writing to ota@dgs.com, not directly to the procurement official, with all submissions subject to the instructions outlined in the complete Event package.

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 6/2025)

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 NameLine Item Number (LIN)
QuantityUnit of MeasureProposed Product Description including SKU/Part #ManufacturerMSRP / List PriceUnit CostExtension Cost
Description

(Bidder completes yellow cells only.) DGS Unique line item number. DGS's listed quantity DGS Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc). Identify manufacturer's unique identifier for a particular line item and/or

Provide informational text about the commodity being purchased. Description should be descriptive enough to show the item is consistent with the SOW/Specifications.Informational text about the ManufacturerIdentify Manufacturer's Suggested Retail PricePrice for line item relative to the
unit of measure.Automatically calculated

(Unit of Measure x Unit Cost)

END OF SHEET.
END OF SHEET.

Cost Worksheet

Department of General Services - Procurement Division
BU 3790, Event ID 38979, Floating Restroom
Attachment 2 - Cost Worksheet
Bidder:
Instructions: Refer to Event's Cost language section for completion instructions. Bidder must complete the Yellow Input Cells only.
Line Item # (LIN)QuantityUnit of MeasureService/Commodity DescriptionProposed Product Description including SKU/Part #Unit CostExtension Cost
1-12EachFloating Restroom: meeting the requirements of Attachment 1 and Administrative Requirements:

Lake Oroville 917 Kelly Ridge Road

Oroville, CA 95966$ - 0$ - 0
1-21EachFloating Restroom: meeting the requirements of Attachment 1 and Administrative Requirements:

Lake Elsinore 32040 Riverside Drive

Lake Elsinore, CA 92530$ - 0$ - 0
1-31EachFloating Restroom: meeting the requirements of Attachment 1 and Administrative Requirements:

Lake Shasta 14225 Holiday Road

Redding, CA 96003$ - 0$ - 0
1-41EachFloating Restroom: meeting the requirements of Attachment 1 and Administrative Requirements:

El Capitan Reservoir (San Diego County) 16850 El Monte Road

Lakeside, CA 92040$ - 0
1-51EachFloating Restroom: meeting the requirements of Attachment 1 and Administrative Requirements:

New Bullard’s Bar (Yuba County) 12561 Marysville Road

Dobbins, CA 95935$ - 0$ - 0
Evaluated Total:$ - 0
Note: Extension is automatically calculated (Contract Unit Price x Quantity)
Bidders must not enter data into any grey shaded fields. These fields are calculated automatically.
Tax rate shall be based on the California City and County Sales and Use Tax Rates published by the California Department of Tax and Fee Administration.
ANY MODIFICATION OF ATTACHMENT 2 - COST WORKSHEET WILL DISQUALIFY BIDDER
END OF SHEET

SAMPLE of Cost Worksheet

SAMPLE ONLY
Line Item # (LIN)QuantityUnit of MeasureService/Commodity DescriptionProposed Product Description including SKU/Part #ManufacturerMSRP / List PriceUnit CostPre‑Tax Extension CostSales Tax Rate (Delivery Location)Sales Tax AmountExtension Cost (After Tax)
1-12EachFloating Restroom: meeting the requirements of Attachment 1 and Administrative Requirements:

Lake Oroville 917 Kelly Ridge Road Oroville, CA 95966 $ - 0 $ 209,000.00 $ 418,000.00 9.25% $ 38,665.00 $ 456,665.00

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