This is a sample report on demo bakery data — every number below was computed by the engine, exactly like it would be for your file.
CalGrid AISample data
bakery_sales_q2.csv
Saturday drives 24% of weekly revenue, but Tuesday runs 41% below average — that gap is worth roughly $1,900 a month.
Your bakery brought in $47,312 across 1,284 transactions this quarter, averaging $36.85 per order. Revenue is growing 8.2% month over month, driven almost entirely by weekend traffic — Saturday alone accounts for $11,354. The clearest opportunity is your weekday trough: Tuesday and Wednesday together run 35% below your daily average, and your top product (Sourdough Loaf, $9,840) sells out by 2pm on weekends while weekday batches go unsold.
1,284
Rows analyzed
$47,312
Total Total
99%
Data quality
AI insights
↗
Revenue up 8.2% month over month, accelerating in the last 6 weeks
Monthly totals climbed from $14,205 to $16,691 across the quarter, and the daily trend line has steepened since mid-quarter. If the current trajectory holds, next month lands around $18,100 — but the growth is concentrated in weekends, which limits how far it can run without weekday improvement.
★
Sourdough Loaf is your workhorse: $9,840 — 21% of all revenue from one product
It outsells the next-best item (Almond Croissant, $6,120) by 61% and holds the highest average quantity per order at 1.8 units. Weekend batches sell out by 2pm, which means the true ceiling is higher than the recorded number.
!
Tuesday runs 41% below your daily average — the weakest day by a wide margin
Tuesday averages $412 against a $698 daily mean, and the gap has widened each month of the quarter. At the current pace that's roughly $1,900 a month in lost revenue versus an average day, and there's no matching dip in foot traffic data — it looks like an offer problem, not a demand problem.
→
Launch a Tuesday-only bundle before adding any weekend capacity
Pair the Sourdough Loaf with coffee at a modest discount on Tuesdays. Your discount column shows you barely discount at all (mean 0.4%), so there's margin room, and pulling even half of Tuesday up to average is worth about $950 a month at zero capex.
Recommended next steps
1.Run a 'Sourdough Tuesday' bundle (loaf + coffee, 10% off) for four weeks — closing half the Tuesday gap adds roughly $950/month at your current margins.
2.Increase Saturday Sourdough production by 20% — weekend batches sell out by 2pm, so the recorded $11,354 understates real Saturday demand.
3.Track waste on Wednesday's pastry batch — quantity sold averages 0.9 units/order vs 1.4 on weekends, pointing to over-production worth ~$300/month.
Want this for your own data?
Upload a spreadsheet and get a report like this in 30 seconds. Your first report is free — no card required.
Analyze my data free →