← 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.

Financial modeling Forecasting KPI design Python Excel automation Toast POS Restaurant365
0.1%
Model error vs. actual sales, back-tested on the latest full month
18
Months projected
6.2×
Weekday revenue growth target
$144.6k
Month-12 revenue target
~12.7k
Orders analyzed
7
Deliverables built
Dollar, order and seat figures are scaled for confidentiality. Percentages, ratios and methods are shown as calculated.

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

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

Wed$38.00
Thu$42.60
Fri$41.40
Sat$40.30
Sun$38.80

$38–$43 · no blended average

Decision 3
Jul ’26

Baseline = latest actuals

Starting occupancy back-solved from real sales

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

18 months, month by month.

Projected monthly revenue

Outdoor open Outdoor closed (winter)
$0$40k$80k$120k$160k$46k$57k$145k$121kAug '26Nov '26Feb '27May '27Aug '27Nov '27Feb '28Outdoor closes

Occupancy ramp — equal monthly steps

Weekday Weekend
Today
6.9%
26.7%
Month 6
24.6%
46.1%
Month 12
42.3%
65.6%
Month 18
60.0%
85.0%

Not every day is the same problem.

Revenue on a typical day

Today Month 12
$0$2k$4k$6k$8k6.2×WedLunch6.2×ThuLunch6.2×FriLunch2.5×SatBrunch2.5×SunBrunch
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

Capacity isn’t constant.

Share of seating capacity, by zone

Indoor · year-round Outdoor · seasonal
30%Dining room
5%Bar
15%Wine room
15%Tavern
12%Balcony
22%Courtyard
Summer100%
Winter66%
−34%capacity when outdoor closes — built into every month of the model

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
PRELIMINARY
03All 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 · DRAFT
05Internal

Gross profit analysis

PDF · 2 pages
Monthly + per-day annualized value
NOT FOR DISTRIBUTION
06Internal

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 5
Weeks 1–4Weeks 5–8
Wed
Thu
Fri
Sat
Sun
$8,444 / wk$10,210 / wk

Tools.

Build
Python · openpyxlPython · ReportLabCustom recalculation script
Data
Toast POSRestaurant365
Output
Excel · input cells vs. calculated cellsPDF · brand-consistent layouts

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

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