Attachment A Soft Drinks Bid Spreadsheet 2021.xlsx

This is a bid spreadsheet for a soft drinks procurement contract. The spreadsheet is organized into four scoring categories with assigned point values. The Bag-In-Box category (35 points) requests pricing for 2.5-gallon and 5.0-gallon containers. The Can/Bottle/2-Liter category (20 points) solicits pricing for 12-ounce cans in 6-pack, 12-pack, and 24-pack configurations, 20-ounce bottles, and 2-liter containers in both soft drink and lemonade/fruit drink varieties. The Other Item category (20 points) covers an extensive range of beverage products including water in multiple formats (0.5-liter 24-packs and 6-packs, 12-ounce 8-packs, 20-ounce individual units, and 300-milliliter individual units), tea, lemonade/fruit juice, energy drinks, and sports drinks in various pack sizes and volumes.

The Commission category (25 points) requires bidders to state a commission percentage for vending operations. Bidders must provide pricing for all listed items in dollar amounts and specify their commission percentage. The spreadsheet also requires vendors to provide contact information for orders, including a phone number, email address, website portal, and designated contacts for contract operations and billing issue resolution. The point allocation structure indicates that pricing competitiveness (35 points for Bag-In-Box products) is weighted most heavily, followed equally by the breadth of product offerings in other categories and commission terms, suggesting the purchasing entity prioritizes both value and service capabilities in supplier selection.