Att.2_Cost_Worksheet.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
ADA Wheelchair Lift Van Conversion
Solicitation number
0000038047
Issued by
California

About this file

This is a Cost Worksheet template for the California Department of General Services, Procurement Division, related to the ADA Wheelchair Lift Van Conversion solicitation (BU 5225, Event ID 38047). The worksheet is designed for bidders to submit pricing for wheelchair lift van conversions that meet the requirements outlined in the Statement of Work and Administrative Requirements. The solicitation includes a base purchase line item (1-1) for 40 units of wheelchair lift van conversions and an optional purchase line item (1-2) for 10 additional units. Bidders must complete only the yellow input cells in the worksheet, providing unit costs and extension costs for each line item. The extension cost is automatically calculated by multiplying the contract unit price by the quantity ordered. Electronic bid submissions through Cal eProcure are not permitted; bids must be submitted in writing to ota@dgs.com with specific subject line formatting including the Business Unit number, Event/Solicitation number, title, due date, and Procurement Official's name.

All pricing submitted must include both shipping and handling costs as part of the unit and extended cost calculations. The cost worksheet serves as the pricing component of the bid package and establishes the contractual prices for each line item based on the bidder's proposed unit prices relative to the specified unit of measure. The worksheet includes fields for Contract Line Item Number (CLIN), quantity, unit of measure, commodity description, proposed product description, unit cost, and extension cost. Per Section 13 of Exhibit C – Administrative Requirements, specific rules apply to the optional purchase line item. The Procurement Official is Phebe Lapinig (phebe.lapinig@dgs.ca.gov, 279-799-3944), with Jennifer Maier serving as backup (jennifer.maier@dgs.ca.gov, 279-799-4117).

View the file

Other files

File Type Posted
Att.1_Exhibit_B_-_Cost_Worksheet.docx DOCX document
Att.3_IFB_Narrative_Response_Form.docx DOCX document
Agreement_Cover_Letter.docx DOCX document
Att.1_Exhibit_F_-_Authorized_Warranty_Repair.docx DOCX document
Att.1_Exhibit_A_-_Statement_of_Work.docx DOCX document
Att.4_Van_Wheelchair_Lift_Drawings.docx DOCX document
Att.1_Exhibit_A-1_-_Specifications.docx DOCX document
STD_204.pdf PDF
IFB_38047_Wheelchair_Van_Conversion.docx DOCX document
Att.1_Exhibit_C_-_Admin_Requirements.docx DOCX document
Att.1_Exhibit_G_-_Insurance_and_Liability_Terms.docx DOCX document
Att.1_Exhibit_E_-_Van_Inspection_Form.docx DOCX document
Att.1_Exhibit_D_-_Work_Authorization_Form.docx DOCX document
Show all 13

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). Buyers 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 5225, Event ID 38047, Wheelchair Lift Van Conversion
Attachment 4 - Cost Worksheet, X/X/XXXX
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)QuantityUnit of MeasureCommodity DescriptionProposed Product DescriptionUnit CostExtension Cost
1-140EachWheelchair Lift Van Conversion, meeting the requirements of the Statement of Work and Administrative Requirements$ - 0
TOTAL COST FOR BASE PURCHASE LINE 1-1:$ - 0
OPTIONAL PURCHASE
1-2 **10EachWheelchair Lift Van Conversion, meeting the requirements of the Statement of Work and Administrative Requirements.
$ - 0
TOTAL COST FOR OPTIONAL PURCHASE LINE 1-2:$ - 0
GRAND TOTAL COST (BASE AND OPTIONAL PURCHASE):$ - 0
Note: Extension is automatically calculated (Contract Unit Price x Quantity)
***Refer to Section 13 of Exhibit C – Administrative Requirements for the rules applicable to Optional Purchase.
End of Sheet

Page &P

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