Attachment_1_-_Pricing_Worksheet.xlsx

This is a Pricing Worksheet attachment for a multi-region bottled drinking water contract opportunity issued by the California Department of General Services, Procurement Division. The contract encompasses six geographic regions covering all California counties, with award made separately by region and product group to the lowest-cost responsible bidder. The solicitation addresses two primary product groups: bottled drinking water in 16 fluid ounce (0.47 liter) and 1-gallon (3.79 liter) formats, available in both standard and electrolyte varieties, with quantities ranging from approximately 28,800 to 2,620,000 units depending on pallet size tier. The contract term is three years with two optional one-year extension periods. The pricing worksheet contains line items organized by pallet purchase tiers (half pallet, full pallet, 2-10 pallets, and 11+ pallets), emergency delivery options with 12-hour service requirements, and miscellaneous services such as delivery without loading dock capabilities.

The worksheet template requires bidders to provide List Price/MSRP, Contract Unit Price, Contract Discount percentages, and extended pricing for each line item across all six regions. Yellow cells are designated as mandatory completion fields, and all pricing calculations automatically generate based on the formula ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) for discount determination. The current worksheet contains ERROR:#DIV/0! entries, indicating it is a blank template awaiting bidder pricing submissions. The contract is available for use by state of California departments and participating local agencies, other states, and local agencies in other states through a cooperative purchasing model.