- Before
- Sends booked plus a buffer for every departure, with no time to look at no-show history, upgrades or late inbounds before the cut-off.
- Now
- Opens each proposal with its reasons and sources a few minutes before the cut-off and decides. “Tell me the number, and tell me why. I'll decide.”
Inflight catering demand forecasting, one flight from booking to the caterer's acknowledgment
Thursday, October 15, 2:32 p.m. at Chicago O'Hare. Corvane Airways CV 118 to Frankfurt, a 787-9 with 48 business seats, leaves at 17:55. The caterer cut-off is 14:55, in 23 minutes. Here is what happens next, screen by screen, in the working solution.
- 0114:32
Six decisions, ranked by cut-off
Renee Castillo · Catering planner, ORDRenee's day starts with one line: CV 118 to Frankfurt, the agents propose 40 business meals, not 46. Below it, six decisions wait by cut-off — a caterer counter-offer on CV 1422, CV 118, a low-confidence Denver flight and three more — and what the agents found since 06:00, from a late Boston inbound to a short rib that ran out yesterday. 142 catered departures today; 203 meals not made so far, $4,742.
“CV 902 from Boston will misconnect 10 passengers · 85 minutes late; 10 connecting passengers rebooked off CV 118, so their meals come out of the forecast.”
- 02One click
The forecast cone, and the agents beside it
Renee Castillo · Catering planner, ORDCV 118 opens as a forecast cone for business meals: booked rising from 14 days out to 41 of 48, the forecast narrowing to 37 (range 35–39), and the standing caterer order of 46 as its own line. The proposed 40 sits dashed at the cut-off mark. Beside the chart, five agents explain the flight in a conversation Renee can join.
- 0314:29
Four business passengers will misconnect
Connection WatcherCV 902 from Boston is now due at 17:10, 85 minutes late. Four business passengers connecting to CV 118 would have 45 minutes against the 75-minute minimum connection time, and they are already rebooked on CV 126 at 21:40, so the agent removes them. Renee clicks the citation and the flight status message opens with the delay highlighted.
Limit: the Connection Watcher never removes a passenger who is not rebooked.
- 0414:29
From 41 booked to 37 expected to board
Load Forecaster41 booked, minus 4 rebooked off the late CV 902, minus 0.8 expected no-shows (2.1% in October), plus 0.7 of 3 waitlisted upgrades expected to clear: 36.9, so 37. The spare policy adds one meal per choice, 3 in business, for an order of 40. Every line on the flight detail cites its source, and the passenger movements show who the meals follow.
“Special meals: loaded by name, never forecast.”
- 0514:31
One sentence, and an independent check
Order Planner · Forecast AuditorThe Choice Mix Forecaster expects 61% to choose the braised short rib, 27% the halibut and 12% the risotto; nine pre-ordered. The Order Planner proposes in one sentence: cut business from 46 to 40, loaded as 24 short rib, 11 halibut and 5 risotto, and economy from 214 to 204. The Forecast Auditor re-derives the forecast from the raw booking and flight-status data only, gets 36.9 → 37 and agrees, confidence 92%.
“Your decision, the reason and the agents' sources go on the audit trail. The Caterer Liaison sends only what you approve.”
- 0614:34 · acknowledged 14:36
Approved with a reason; the caterer confirms
Renee Castillo · Catering planner, ORDRenee approves 40 with the reason “Misconnects confirmed”. The Caterer Liaison sends the change to Northmere Flight Kitchen as NFK-118-1015-3, and at 14:36 Northmere acknowledges 40 business (24 short rib, 11 halibut, 5 risotto), 24 premium economy and 204 economy. The cone's order line drops to 40 and the flight moves to sent and acknowledged.
- 07Cut-off 15:20
On stale data, the agents will not cut
Forecast Auditor · Order PlannerPM 412 to Denver is an acquired Pellmar flight, and the Pellmar booking feed has not updated since 11:30. The Load Forecaster's range is wide, 9–12, at 54% confidence. The Forecast Auditor works from departure control instead — 7 of 11 checked in — expects 11 to board, not 10, and disagrees with a cut. The Order Planner keeps the order at 12 and hands the flight to Renee: keep 12, set a number or ask the station.
“I will not propose a cut on data this old. The order stays at 12 unless you set a number.”
- 0814:24
A counter-offer from the kitchen
Caterer LiaisonAn approved cut on CV 1422 to San Francisco reached Northmere after hot-meal production started at 14:10. Luis Romero replies that they can reduce 2 first-class meals at a 50% charge under §4.4, $16.00 each. The Caterer Liaison works out the net saving, $32, and recommends accepting; Renee decides before 14:40.
Limit: the Caterer Liaison never accepts a caterer's charge itself.
- 09The morning after
Yesterday's flights, measured
Waste & Short-Load ReviewerThe reviewer read each caterer's return-load report and the crew's notes: 131 of 138 flights measured, 3.7% of meals returned untouched (2,184 of 58,460 uplifted), 2 run-outs. The miss that matters is CV 86 to London, where the new autumn short rib ran out at row 8 — chosen 68%, forecast 52%. The reviewer proposed raising its share; Owen Mercer approved at 09:12, and today's CV 86 proposal uses it.
- 10Last 30 days
The agents grade themselves, openly
Forecast AuditorAccuracy is a screen anyone can open: 96.8% of cabins within 2 meals, an average error of 1.4 meals against 4.9 for the old buffer rule, business run-outs 0.9%, untouched returns 3.8% against 7.1% before. Each big miss is explained, and the agents propose rule R-12 — use a coach group's own show-up history — for Owen Mercer to approve or reject.
“CV 140 HND · Oct 11 · premium · 3 fewer boarded than forecast: misconnecting passengers were not yet rebooked at the cut-off. Correct by design: never removed until rebooked.”