Menu Planning at Scale — AI-Adapted Camp Cost Model

Menu planning at scale.

Explore a five-week institutional summer camp menu through weighted station meal costs, category targets, and live guest-count service budgets.

ADAPTING OPERATIONS TO AI Multi-week cycle menus involve dozens of linked tabs. By adapting my 2022 camp benchmark workbook with AI, station take-rate math and 25-to-1,000 guest budget projections become an interactive decision tool.

How to read the figures

The 2022 summer camp menu model uses station category costs multiplied by projected guest take rates to estimate food cost per meal. The all-weeks view averages all five menu weeks. Guest counts in the bottom simulator are interactive. Calculations reflect raw food cost and exclude labor, waste, and overhead.

Source workbook

CMP_DINE&_Camp_Summer2022_3.14.22_Final.xlsx — Benchmark & Targets 2022 (rows 3–25) and referenced Week 1–Week 5 station cost tabs.

EX.AI-02 // 5-WEEK STATION TAKE-RATE & TARGET VARIANCE MODEL

Breakfast menu costs.

Choose a meal period and menu week above to compare modeled food costs against category targets.

Modeled Cost

Target Cap

Where the difference comes from

Select a station category to see the take-rate calculation

Sage green = below target cap. Scarlet = above target cap. Bar length shows the weighted difference in dollars per meal. Category take rates can total more than 100% because guests visit multiple stations.

Plan a service budget.

Apply the selected meal’s modeled food cost to any guest count from 25 to 1,000 campers.

SERVICE HEADCOUNT: 100 GUESTS

Modeled Food Cost for This Service