3-ISBE calculations for meals.xlsx

This is a meals calculation spreadsheet for a childcare food services contract in Illinois involving five sites under the Illinois State Board of Education (ISBE) program. The document outlines enrollment and meal service projections across five locations: Daley, KKC, MXC, OHC, and Truman centers, with a combined enrollment of 187 children against a total capacity of 200 as of February 20, 2026. The meal service plan encompasses 230 serving days per year across three meal categories: breakfast, lunch, and afternoon snack. Annual meal projections total 138,000 meals across all five sites, with daily service distributed proportionally based on each site's enrollment.

The pricing structure establishes unit costs for each meal type: breakfast at $4.05 per meal, lunch at $6.17 per meal, and afternoon snack at $2.65 per meal. Based on 46,000 annual meals per meal type across all sites, the total contract value is $592,020 annually, comprising $186,300 for breakfast service, $283,820 for lunch service, and $121,900 for afternoon snack service. This calculation reflects a sole source public review arrangement for childcare food services, indicating this may be a continuation or renewal of services with an incumbent provider.