Organic Food Exhibit B Cost sheet.xlsx

This is a cost sheet and bid response template for a procurement by the University of Wisconsin-Milwaukee (UWM) to supply and deliver natural and organic foods for resale in university convenience stores. The bid solicitation requires vendors to provide diverse product lines across multiple categories including cereals, bars, chips, crackers, frozen foods, beverages, candy, cookies, refrigerated items, pasta sauces, soups, and dried fruits. The template specifies estimated annual volumes for each product, with items ranging from individual packages (such as 1.69-ounce Luna bars and 1-ounce Organic Valley string cheese) to larger case quantities. For example, the bid includes 19 cases annually of Cascade Dark Chocolate Almond Granola cereal and 87 cases of Organic Valley string cheese. Small package sizing for single consumer purchases and low order minimums are identified as critical components of the contract. The spreadsheet contains an incomplete bid response with only one item showing pricing: Cascade Dark Chocolate Almond Granola with a vendor net unit cost of $2.20 per box and a total estimated annual price of $501.60.

Vendors are instructed to enter category-specific markup percentages as whole numbers, with the cereal category showing a 10 percent markup while all other categories show zero percent markup in the template. The vendor's net unit cost must be provided for individual items (per box, bar, bag, or case measure), and the total price is calculated by adding the markup percentage to the net unit cost. The estimated annual total price is then calculated by multiplying the total price by the estimated annual volume ordered. Bidders have the option to propose alternate products that are substantially similar in brand recognition, taste, consumer preference, and weight to the listed items. The current bid spreadsheet shows a total lot bid of $501.60, though this represents only partial completion as all other product categories show $0.00 values with zero vendor net unit costs entered. The document indicates that for bids to be considered responsive, vendors must bid on all items, either the products as listed or approved alternates.