7-7- Pricing Schedule Excel with Formulas.xlsx

This is a pricing schedule template for food services at the Williamson County Jail in Texas, establishing the bidding framework for meal provision costs across multiple categories. The document provides blank fields for unit pricing of inmate meals organized by Average Daily Population (ADP) tiers ranging from 400 to 800+ inmates, with separate pricing required for breakfast, lunch, and dinner at each tier level. Additionally, bidders must submit pricing for special dietary meals including diabetic, low sodium, vegan/vegetarian, and religious-sensitive (kosher/halal) options; sack meals for standard and special diet transport; trustee meals; employee meals; holiday meals for Thanksgiving and Christmas across inmate, trustee, and employee categories; and monthly snack provisions.

The pricing schedule incorporates calculation fields that automatically compute annual costs based on input variables including average daily population, percentages of inmates requiring special diets, monthly sack meal quantities, daily trustee and employee meal counts, holiday meal counts, and monthly snack quantities. Bidders are required to populate the unit price fields for each meal category, and the spreadsheet will generate total annual costs for each service component as well as a grand total annual contract value. The template establishes a standardized approach to pricing evaluation, allowing Williamson County Jail to compare bids on a consistent basis across all meal service categories and operational scenarios.