Practical scheduling playbooks for small bakeries — templates, heuristics and real results?

Small and medium bakeries: you face a constrained scheduling puzzle every day — limited ovens and trays, long changeovers, many SKUs with short shelf life, and last‑minute order swings. Academic MIP papers are great, but what low‑friction models, spreadsheets and rules do you actually run on a Monday morning to keep product fresh, throughput high and waste down?

I’m starting a focused exchange to collect implementation‑ready assets and first‑hand tactics. Useful contributions include: short, runnable templates (Google Sheets/Excel) for lot sizing and batching; simple heuristics for sequencing to reduce stale stock; changeover matrices; oven‑load visualizers; and step‑by‑step playbooks for noisy POS forecasting.

Questions to spark practical sharing
- Which simple scheduling templates or rules do you use (fixed runs, time‑based batches, min‑max par levels, FIFO by bake time)? Please share the file or a screenshot.
- How do you treat changeovers? (e.g., batch similar SKUs together, dedicate an oven block for high‑velocity items, set minimum run sizes). Share the matrix of setup times if you have one.
- What minimal data do you collect that actually improves the schedule (sales by hour, product age, oven occupancy, changeover duration)?
- What KPIs moved after you changed scheduling? (waste %, sell‑through within X hours, oven utilization, labor hours). Real numbers help others decide what’s achievable.
- Which quick wins worked in <30 days? (order cutoffs, afternoon bake vs morning, reserve bake quantities, dynamic par levels, promo blackouts).

Starter building blocks people often find useful
- Oven load heatmap (hour × oven) to visualize peaks and forced changes.
- Changeover‑aware batch planner: SKU × oven capacity table + min run sizes => batch assignments.
- Freshness penalty estimator: simple score that degrades value by age to prioritize sells.
- Weekly menu → daily schedule playbook: convert forecast into block runs, reserve windows for high‑variability items, and set hard cutoffs for custom orders.

If you can, please post: bakery size (SME: ovens, trays, staff), typical product mix (bread, viennoiserie, cakes), a one‑week sample of sales/production, and the simple template or rule you tried. Tell us what changed (waste, service, labor). If you’re looking for a starter template, say so and include your oven count and main SKUs — community members can share a spreadsheet you can adapt.

Goal: collect practical, copy‑and‑paste templates and short playbooks that a baker can apply this week. Share what you ran, what you changed, and the before/after numbers.