Attachment_4_Fish_Tank_Cost_Worksheet.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- CDFW - Fish Hauling Tank (OTA-DGS)
- Solicitation number
- 0000030454
- Issued by
- California
About this file
The document provided is a Cost Worksheet for a state government contract opportunity. The contracting agency is the California Department of Fish and Wildlife (CDFW) and the contract is for the procurement of Fish Hauling Tanks. The document lists 19 line items for various sizes of fish hauling tanks ranging from 250 gallons to 2,000 gallons for delivery to different hatchery locations across California. The contract requires bidders to provide unit pricing, total extended pricing, and adherence to specified unit of measure and product descriptions. The contract opportunity is an Open Term Agreement (OTA) solicitation managed by the California Department of General Services (DGS) with a due date for bids not specified in the information provided.
The cost worksheet template provides instructions for bidders to complete the required pricing information, including the need to incorporate shipping and handling costs into the unit and extended pricing. The worksheet also notes requirements for data validation, cell locking, and worksheet formatting for accessibility compliance prior to the final solicitation posting. No other details on pricing terms, funding sources, or incumbent contractors are included in the provided information.
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 Name | Contract Line Item Number (CLIN) | ||||||
| Unit of Measure | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Proposed Product Description | Contract Unit Price | ||
| Description | Unique 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 3600, Event ID 0000030454, Fish Hauling Tank | ||||||
| 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, 18 for completion instructions. Bidder must complete the Yellow Input Cells only. | ||||||
| Line Item # (LIN) | Quantity | Unit of Measure | Commodity Description | Proposed Product Description | Unit Cost | Extension Cost |
| 1-1 | 2 | Each | AMERICAN RIVER HATCHERY – 400 GALLON 8 INCH VALVE | $ - 0 | ||
| 1-2 | 1 | Each | AMERICAN RIVER HATCHERY – 400 GALLON 10 INCH VALVE | $ - 0 | ||
| 1-3 | 2 | Each | BLACK ROCK HATCHERY – 400 GALLON | $ - 0 | ||
| 1-4 | 1 | Each | BLACK ROCK HATCHERY – 1200 GALLON | $ - 0 | ||
| 1-5 | 1 | Each | CRYSTAL LAKE HATCHERY – 400 GALLON | $ - 0 | ||
| 1-6 | 1 | Each | CRYSTAL LAKE HATCHERY – 2000 GALLON | $ - 0 | ||
| 1-7 | 1 | Each | DARRAH SPRING HATCHERY – 400 GALLON | $ - 0 | ||
| 1-8 | 1 | Each | FILLMORE HATCHERY – 400 GALLON | $ - 0 | ||
| 1-9 | 1 | Each | FILLMORE HATCHERY – 600 GALLON | $ - 0 | ||
| 1-10 | 2 | Each | HOT CREEK HATCHERY – 800 GALLON | $ - 0 | ||
| 1-11 | 2 | Each | IRON GATE HATCHERY – 400 GALLON | $ - 0 | ||
| 1-12 | 1 | Each | MAD RIVER HATCHERY – 250 GALLON | $ - 0 | ||
| 1-13 | 2 | Each | MOCCASIN CREEK HATCHERY – 500 GALLON | $ - 0 | ||
| 1-14 | 1 | Each | MOCCASIN CREEK HATCHERY – 700 GALLON | $ - 0 | ||
| 1-15 | 1 | Each | MOUNT SHASTA HATCHERY – 900 GALLON | $ - 0 | ||
| 1-16 | 2 | Each | SAN JOAQUIN HATCHERY – 500 GALLON | $ - 0 | ||
| 1-17 | 1 | Each | WARM SPRINGS HATCHERY – 250 GALLON | $ - 0 | ||
| 1-18 | 1 | Each | WARM SPRINGS HATCHERY – 400 GALLON | $ - 0 | ||
| 1-19 | 1 | Each | WARM SPRINGS HATCHERY – 1400 GALLON | $ - 0 | ||
| Total Cost: | $ - 0 | |||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) |
Page &P
File details come from the government source that posted it. Updated .