ATTACHMENT_4_COST_WORKSHEET.xlsx
XLSX spreadsheet 17 KB Posted
- Solicitation number
- 0000037658
- Issued by
- Sacramento County, San Francisco City, California
About this file
This is a Cost Worksheet attachment for an Invitation for Bid (IFB) issued by the California Department of General Services, Procurement Division on behalf of the California Department of Consumer Affairs. The solicitation requests bids for two (2) truck tractor day cabs that must meet the requirements of Specification #6115-TS-0282245. This is a one-time acquisition with delivery required to be completed within one hundred eighty (180) calendar days after receipt of the purchase order. The delivery location is the Department of Consumer Affairs Bureau of Automotive Repair at 10233 Systems Parkway, Sacramento, California 95827.
The cost worksheet template requires bidders to complete yellow input cells only, providing unit costs and extended costs for each line item, with both shipping and handling costs included in the pricing. The worksheet automatically calculates extension costs by multiplying the contract unit price by the quantity ordered and includes fields for sales tax calculation and total cost. Bidders must reference the event's cost language section for specific completion instructions and ensure compliance with accessibility requirements, including data validation messages and proper cell protection prior to submission.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ATTACHMENT_2__SPECS.pdf | ||
| ATTACHMENT_3_ADMIN.docx | DOCX document | |
| ATTACHMENT_5_NARRATIVE(ER).docx | DOCX document | |
| ATTACHMENT_6_-_WORK_AUTHORIZATION.pdf | ||
| TRUCK_TRACTOR_DAY_CAB.docx | DOCX document | |
| ATTACHMENT_1_COVER_LETTER.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 1111, Event ID 0000037658, TRUCK TRACTOR DAY CAB | ||||||
| Attachment 4 - 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 | 2 | Each | TRUCK TRACTOR DAY CAB - Meeting the requirements of Specification 6115TS-0282245, dated 12/09/2025 | |||
| Subtotal: | $ - 0 | |||||
| Sales Tax: | 0.00% | $ - 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 .