ATTACHMENT_3_CW_CR.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- HOSPITAL BEDS AND MATTRESS (DGS/OTA)
- Solicitation number
- 0000035204
- Issued by
- Napa County, California
About this file
This document is a Cost Worksheet from the California Department of General Services Procurement Division (Event ID 0000035204) for a solicitation involving hospital beds for the Yountville Skilled Nursing Facility (SNF). The procurement seeks 230 bed frames, 100 specialty mattresses, and 130 regular mattresses, all as described in specification document 6530-BS-0214729 dated 12/2/2024. The worksheet is designed for bidders to complete pricing information for each line item, with requirements that unit and extended costs must include shipping and handling.
The cost worksheet template provides a structured format for bidders to input manufacturer details, part numbers, and pricing, with a sales tax rate of 7.75% applied to the subtotal. Bidders are instructed to complete only the yellow input cells, with extension costs automatically calculated by multiplying the contract unit price by the quantity. The document includes guidance for creating accessible cost worksheets, emphasizing clear data validation, cell protections, and descriptive naming conventions to ensure comprehensive and transparent pricing submissions.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ATTACHMENT_1_SPECS_CR_.pdf | ||
| APP_Cover_Page_CR.pdf | ||
| ATTACHMENT_2_ADMIN_CR.docx | DOCX document | |
| ATTACHMENT_4_NARRATIVE_CR.docx | DOCX document | |
| ATTACHMENT_5_WORK_AUTH_CR.docx | DOCX document | |
| IFB_8955_0000035204_CR.pdf |
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 8955 Event ID 0000035204 Commodity - Hospital Beds - Yountville SNF | ||||||
| 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) | Quantity | Unit of Measure | Commodity Description | Proposed Product Description | Unit Cost | Extension Cost |
| 1-1 | 230 | Each | Bed Frame, as described in 6530-BS-0214729 dated 12/2/2024 | $ - 0 | ||
| 1-2 | 100 | Each | Specialty Mattress, as described in 6530-BS-0214729 dated 12/2/2024 | $ - 0 | ||
| 1-3 | 130 | Each | Regular Mattress, as described in 6530-BS-0214729 dated 12/2/2024 | $ - 0 | ||
| Subtotal: | $ - 0 | |||||
| Sales Tax: | 7.75% | $ - 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 .