Back to Coffee Shop
Coffee ShopPro · $5~3 hours to set up, 1 hour/week ongoing

Build a Staff Schedule That Matches Your Busy Hours

Labor is usually a cafe's biggest controllable cost after product. Over-staffing on slow hours and under-staffing during rush both hurt — over-staffing eats margin, under-staffing drives customers away. Most cafes schedule from habit, not data. This guide builds a demand-matched scheduling system: hourly sales analysis, a labor-to-sales target, position-specific scheduling (barista, cashier, food prep), weather and event overlays, and a weekly scheduling rhythm that controls labor cost without creating staff resentment.

Intermediate~3 hours to set up, 1 hour/week ongoingChatGPT or Claude · Hourly POS data · Labor data

What You’ll Get

  • An hourly sales heatmap showing your real demand pattern
  • A labor-to-sales target and break-even labor hours calculation
  • Position-specific schedule templates by day and part of day
  • A weather/event overlay that flexes staffing proactively
  • A weekly scheduling ritual that takes 1 hour

Step-by-Step Guide

1

Build an hourly sales heatmap

Staffing decisions should come from data. Know your real peak and trough hours.

Data you need

Export hourly sales data for 60–90 days. For each hour: transaction count, revenue, average ticket.

Prompt
I want an hourly sales heatmap.

My cafe:
- Hours of operation: [e.g. 6am–7pm, 7 days]
- Format: [full service / counter only / drive-thru]
- Typical weekly revenue: $[AMOUNT]

Here is my hourly sales data for 60–90 days:
[PASTE EXPORT OR DESCRIBE PATTERN]

Please analyze:
1. **Hourly heatmap** — transactions and revenue by hour × day of week
2. **Peak hours** — rush windows (usually 7–9am, sometimes 12–1pm, sometimes 3–5pm)
3. **Trough hours** — consistent slow periods
4. **Day-of-week variation** — weekdays vs. weekends
5. **Hour-to-hour transitions** — how fast rush ramps and fades (affects shift structure)
6. **"Below break-even" hours** — hours where revenue doesn't cover standard staff cost
7. **Weather-correlation** (if trackable) — rainy days vs. nice days
8. **Quarterly trend** — is volume shifting within the day (e.g. mornings softening, afternoons growing)
2

Set a labor-to-sales target

Labor cost as a % of sales is the cleanest target. The ranges below are common rules of thumb; set your own target from your P&L, not from someone else's.

Prompt
I want a labor-to-sales target.

My current labor cost: [approximate weekly $ or % of sales]
My wages paid (minimum range to top range): $[LOW–HIGH per hour]
My service model: [counter / full-service / drive-thru]

Please calculate:
1. **Current labor % of sales** and benchmark
2. **Target labor %** — 25–28% for counter, 28–32% for full service, 22–28% for drive-thru
3. **Weekly labor budget** at current sales — dollar target
4. **Hour budget per day** — max labor hours to hit target
5. **Day-level allocation** — how many hours per day, weighted to peak demand
6. **Position allocation** — split between barista, cashier, food prep, floor
7. **"Crossing the line" alert** — if weekly revenue comes in light, we're over budget; mid-week adjustment protocol
8. **Training/onboarding exception** — how to budget for new-hire labor that's non-productive initially

Pro guide

Unlock the full playbook.

This guide has 6 steps — prompts, frameworks, and templates built for your industry. Unlock for $5.

How Pro works

one-time, unlock this guide forever on this browser. Secure checkout via Stripe.