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 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 NameContract Line Item Number (CLIN)
Estimated QuantityCommodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeFlavorUnit of MeasurePacks per case (for quantity estimate)Estimated Packs per CaseOffered Serving per CasePrice per PackBags per CaseCost per 8 oz servingContract Case PriceExtension
DescriptionUnique line item number.Estimated quantity ordered per year based on Unit of MeasureInformational 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.aspIdentifies the manufacturer's name for each line item.Identifies brand name for each line itemIdentifies manufacturer's unique identifier for a particular line item.Identifites the flavor for each line itemUnit 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 QuantityThe 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.
FormatVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberCurrencyCurrency
Example62543211503PT-674344457HPBOX4576543245-JH/4567CHP Compaq 8710p Notebook PC10$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 UOMCommodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product Code(s)FlavorUnit of MeasureEstimated Packs per caseOffered Packs per CasePrice per PackContract Case PriceExtension
120,374Beverage Base, Sugar-Free Artificially sweetened
Individual serving, 8 oz. yield per packet50202311Case2000$ - 0ERROR:#DIV/0!
Contract Line Item # (CLIN)Estimated QuantityCommodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product Code(s)FlavorUnit of MeasureEstimated Servings per caseOffered Servings per CaseBags per caseCost per 8 oz ServingContract Case PriceExtension
23,196Beverage Base, Sugar-Free Artificially sweetened
Bulk Pack. Quantity based on 44 bags per case, 10 gallons per bag.50202311Case7040$ - 0ERROR:#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 .