Attachment_1-_Pricing_Worksheet.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- Beverage Base
- Solicitation number
- 0000040022
- Issued by
- California
About this file
This is a pricing worksheet attachment related to a Beverage Base Invitation For Bid (IFB) issued by the California Department of General Services, Procurement Division (DGS-PD). The solicitation seeks qualified firms to establish a multi-year statewide contract for beverage base products mandatory for use by all State of California departments. The contract term is two years with two optional one-year extension periods, making the potential total contract duration up to four years. The delivery and service area encompasses the entire state of California, and award will be made on an all-or-none basis.
The pricing worksheet serves as the primary instrument for bidders to submit their cost proposals for the beverage base products. This document establishes the pricing structure and format that bidders must follow when submitting their bids in response to the IFB. All pricing information, rates, and cost breakdowns must be completed in accordance with the worksheet's requirements to ensure bid compliance and facilitate comparative evaluation among respondents. Bidders should refer to the complete solicitation documents available in the event package for all specifications, terms, conditions, and additional pricing requirements governing this statewide contract opportunity.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_6-_Food_Safety_Information_Listing.docx | DOCX document | |
| Attachment_5_-_Estimated_Institution_Usage.xlsx | XLSX spreadsheet | |
| APP_Front_Page.docx | DOCX document | |
| Attachment_2-_State_of_California_Bid_Specification.pdf | ||
| Attachment_3_-_Narrative_Response.xlsx | XLSX spreadsheet | |
| Attachment_7-_Northern-Southern_Institution_Listing.docx | DOCX document | |
| Attachment_4_-_Food_Special_Provisions.docx | DOCX document | |
| IFB_Event_0000040022.docx | DOCX document |
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
Pricing Worksheet Key
| PRICING WORKSHEET KEY | |||||||||||||||
| Column Name | Contract Line Item Number (CLIN) | ||||||||||||||
| Estimated Quantity | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Flavor | Unit of Measure | Packs per case (for quantity estimate) | Estimated Packs per Case | Offered Serving per Case | Price per Pack | Bags per Case | Cost per 8 oz serving | Contract Case Price | Extension |
| Description | Unique line item number. | Estimated quantity ordered per year based on Unit of Measure | Informational text about the commodity being purchased. | The United Nations Standard Products and Services Code. It’s a global multi-sector standard for efficient, accurate classification of products and services. |
This field should document the appropriate UNSPSC Commodity Code for each line item.
| Website for codes: http://www.unspsc.org/Search.asp | Identifies the manufacturer's name for each line item. | Identifies brand name for each line item | Identifies manufacturer's unique identifier for a particular line item. | Identifites the flavor for each line item | Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc). | The number of packets per case used for purposes of determing the Estimated Quantity | The estimated number of packets per case offered. | The number of bags per case offered. | The price per pack offered. | The number of servings per bag. | The cost per 8 oz measure of serving. | This is the contractual price for a given line item based on the price that was bid, as relative to the | |||
| unit of measure. | Calculated extended price for evaluation. | ||||||||||||||
| Format | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | Currency | Currency | |||||
| Example | 625 | 43211503 | PT-674344457 | HP | BOX | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | 10 | $2,500.00 | $1,650.00 | |||||
| CORE - Often refers to a Fixed Price. | |||||||||||||||
| NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.). | |||||||||||||||
| END OF SHEET. |
Beverage Base
| Department of General Services - Procurement Division | ||||||||||||||
| Event ID: 0000040022, Beverage Base | ||||||||||||||
| Attachment 1 - Pricing Worksheet, 9/24/2026 | ||||||||||||||
| Bidder: | ||||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | ||||||||||||||
| Pricing must be the same for all flavors per line item | ||||||||||||||
| Contract Line Item # (CLIN) | 2 Years Estimated Quantity per UOM | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code(s) | Flavor | Unit of Measure | Estimated Packs per case | Offered Packs per Case | Price per Pack | Contract Case Price | Extension | |
| 1 | 20,374 | Beverage Base, Sugar-Free Artificially sweetened | ||||||||||||
| Individual serving, 8 oz. yield per packet | 50202311 | Case | 2000 | $ - 0 | ERROR:#DIV/0! |
| Contract Line Item # (CLIN) | Estimated Quantity | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code(s) | Flavor | Unit of Measure | Estimated Servings per case | Offered Servings per Case | Bags per case | Cost per 8 oz Serving | Contract Case Price | Extension | |
| 2 | 3,196 | Beverage Base, Sugar-Free Artificially sweetened | |||||||||||||
| Bulk Pack. Quantity based on 44 bags per case, 10 gallons per bag. | 50202311 | Case | 7040 | $ - 0 | ERROR:#DIV/0! |
TOTAL: ERROR:#DIV/0!
Note: CLIN 1 Contract Price Calculation: (Offered Packs per Case x Price per Pack),
| Note: CLIN 2 Contract Price Calculation: (Cost per 8 oz Serving x Offered Servings per Case) |
| Note: Extension is automatically calculated: |
CLIN 1: (Contract Case Price x Estimated Quantity x (Estimated Packs per Case/Offered Packs per Case)), CLIN 2: (Contract Case Price x Estimated Quantity x (Estimated Servings per Case/Offered Servings per Case)) End of Sheet
File details come from the government source that posted it. Updated .