← Back to case study
Case Study · Financial Modeling & KPI Design
Lunch & Delivery Growth Initiative
An 18-month, capacity-driven revenue model that turns “grow lunch” into month-by-month targets — and the reporting built to track them.
Dollar, order and seat figures are scaled for confidentiality. Percentages, ratios and methods are shown as calculated.
01 · Starting point
Most lunch seats sat empty.
7%
Weekday lunch
of seats filled today
27%
Weekend brunch
of seats filled today
Lunch window 11am–4pm
Wed–Sun
6 zones · indoor + outdoor
External marketing agency engaged
Business goal
→
Monthly targets
→
Tracking
02 · Method
Capacity-first, not trend-extrapolated.
Available Seats
×
Occupancy %
×
Avg. Spend / Order
=
Revenue
Decision 1
10×
One-year sample, not one month
Wednesday orders: full year vs. July alone
Decision 2
Spend per order, by day
$38–$43 · no blended average
Decision 3
Jul ’26
Baseline = latest actuals
Starting occupancy back-solved from real sales
03 · Back-test
Model vs. reality.
Model projection$36,170
Actual (Toast POS)$36,123
0.1%
margin of error
Δ $47
Net sales, 11am–4pm, after discounts and voids · calendar-exact weekday mix
04 · Growth curve
18 months, month by month.
Projected monthly revenue
Outdoor open
Outdoor closed (winter)
Occupancy ramp — equal monthly steps
Weekday
Weekend
Today
Month 6
Month 12
Month 18
05 · Day of week
Not every day is the same problem.
Revenue on a typical day
Today
Month 12
6.2×
Weekday lunch
$746 → $4,601 (Wed)
2.5×
Weekend brunch
Three one-metric slides: Revenue · Orders · Occupancy
Weekday and weekend strategies tracked separately
06 · Seasonality
Capacity isn’t constant.
Share of seating capacity, by zone
Indoor · year-round
Outdoor · seasonal
Summer100%
Winter66%
−34%capacity when outdoor closes — built into every month of the model
07 · Deliverables
7 deliverables. Two audiences.
External
Internal
PRELIMINARY · DRAFT
01Internal
Combined financial model
Excel · 5 tabs
Inputs → projection → milestones → quarters
ActualsInputs18-mo projectionDay-of-weekQuarterly
02External
KPI one-pager
PDF · 1 page
3 KPIs × 7 checkpoints
PRELIMINARY03All stakeholders
Methodology guide
PDF · 2 pages
Every number, with its source
04External
Day-of-week slides
PDF · 3 pages
Revenue / Orders / Occupancy — one metric per page
PRELIMINARY · DRAFT05Internal
Gross profit analysis
PDF · 2 pages
Monthly + per-day annualized value
NOT FOR DISTRIBUTION06Internal
8-week tracker
Excel
Targets pre-filled · actuals in yellow · auto-delta
07Internal
8-week tracker visual
PDF · landscape
Both metrics, 8 weeks, one page
8-week tracker — weekly revenue targets
Step-up at Week 5Weeks 1–4Weeks 5–8
Wed
Thu
Fri
Sat
Sun
$8,444 / wk$10,210 / wk
08 · Stack
Tools.
Build
Python · openpyxlPython · ReportLabCustom recalculation script
Data
Toast POSRestaurant365
Output
Excel · input cells vs. calculated cellsPDF · brand-consistent layouts
09 · Stakeholders
Four audiences. Four styles.
Owner
Waterfall: big picture firstData reconciled before trusted
Operations manager
Summary firstUsable now, refined later
External marketing agency
KPI one-pager firstEverything marked preliminary
Front-of-house manager
Data source, not model userSeats + season confirmed
Budget · locked at launch
vs.
Actuals
+
Separate forecast if actuals miss
10 · Demonstrated
Skills in this project.
Capacity-driven modeling
Back-testing against actuals
Sample-size judgment
KPI framework design
Seasonal capacity modeling
Budget vs. forecast discipline
Python Excel & PDF automation
POS & accounting systems
Internal vs. external deliverables