Coffee Shop Performance Dashboard
Fourth of July weekend in a beach town. The line at the walk-up window runs past the bike rack, the cold brew ran out at 1pm, and the drive-through lane is backed up onto the road. The register says it's the best day of the summer. Nobody knows how many people looked at the line and kept walking.
A bigger share of coffee drinkers is buying out of home than at any point since early 2020. The National Coffee Association's 2026 National Coffee Data Trends Fall Report, surveyed in June 2026, found 38% of past-day coffee drinkers had bought coffee out of home, the highest since January 2020. 21% of past-day drinkers had cold coffee, up from 16% in 2022, and a record 40% of past-week out-of-home buyers ordered on an app.
The seasonality shows up nationally, too. BLS counts 970,300 people working in snack and nonalcoholic beverage bars in January 2026 and 1,086,200 in July, before seasonal adjustment. That's about 116,000 extra jobs for the summer, most of them new people to train before the rush.
The beans cost more as well. The BLS average US retail price of ground coffee went from $6.31 a pound in August 2024 to $9.72 in April 2026, the highest since the series began in 1980. It was still $9.30 in August 2026. A shop buys from a roaster, not a supermarket, but it's the same green coffee underneath.
The company here is fictional and its numbers are modeled, not real results. None of the ten targets below has a published industry benchmark behind it, so all are marked as starting points. The story covers two summers, and what one owner changed between them.
What is a Coffee Shop KPI Dashboard?
Overview
A coffee shop KPI dashboard shows how many people came to the counter, what each of them spent, what it cost to make and serve them, and how long they waited.
The register comes first. Daily transactions is the count of tickets rung up. Average ticket is what each one was worth, and food attach rate is the share that included something to eat. Multiply the first two by the days you were open and you have net sales, the headline number.
Then the bar. Speed of service is the average wait from order to handoff in the morning peak, when commuters decide whether you're worth the stop. Sales per labor hour shows whether the people on shift matched the people in line.
Then the costs. COGS covers beans, milk, cups, syrups and food. Waste is the slice of COGS that went in the trash: cold brew past its hold time, milk left out, croissants nobody bought. Labor cost is the wage bill as a share of sales. Net profit margin sits at the bottom and settles the argument.
If you're deciding which of these to start with, our guide to coffee shop KPIs goes through them in more depth.
Who benefits from this dashboard?
- Owner: The question every October is whether the summer paid for the winter. Net profit margin by month, against the same month last year, answers it before the accountant does.
- General Manager: Labor cost and sales per labor hour turn the weekly schedule into a numbers decision. Speed of service shows where the schedule was wrong.
- Shift Leads: They see waste and speed of service every morning, and they can fix both by lunchtime: brew less, move a barista to the window, restock the grab-and-go shelf.
- Whoever places the orders: Waste and COGS tell the person ordering from the bakery and the dairy whether the standing order still fits the weather.
- Bookkeeper: A monthly inventory count is what turns COGS into a real number rather than a pile of invoices. When a count gets skipped, COGS jumps and the dashboard shows it.
A waste sheet only works if it's filled in when something goes in the trash. Filled in at close from memory, it records the cold brew and misses the dropped pastries, the milk that turned at 2pm and the drinks remade at the window. Log remakes too: a bar remaking one drink in ten at peak is losing product and minutes at the same time.
Dashboard Example Overview
The example company runs two counter-service shops in a harbor town on the New England coast. One is on the waterfront, with a walk-up window and a dozen seats. The other sits on the highway into town and has a drive-through. Locals and commuters keep both open all year, and day-trippers and summer renters roughly triple the trade between Memorial Day and Labor Day. It reports monthly, both shops combined, on ten KPIs:
- Net Sales: Gross sales less discounts, comps and refunds, before sales tax and tips. Set targets by month, because July 2026 ran four times February.
- Daily Transactions: Tickets rung up divided by days open, with voids and staff drinks left out. It's the closest thing the POS has to a foot-traffic count.
- Average Ticket: Net sales divided by transactions. It moves with menu prices, with food, and with group orders, which is why it climbs every summer.
- Food Attach Rate: Transactions with at least one food item, as a share of all transactions. The way to lift the ticket without a price rise.
- COGS: Opening inventory, plus purchases of coffee, milk, food, cups and syrups, minus closing inventory, divided by net sales. Waste is inside it.
- Labor Cost: Hourly wages, salaries, payroll taxes and benefits divided by net sales. Tips are left out, because customers pay them, not the shop.
- Sales per Labor Hour: Net sales divided by hours worked by hourly staff. It shows how closely the schedule followed the trade.
- Speed of Service: Average minutes from order to handoff between 7am and 10am, from POS and kitchen display timestamps, with drive-through and mobile orders included. Lower is better.
- Waste: The cost of discarded drinks, food, milk and cold brew, logged on the waste sheet, divided by net sales.
- Net Profit Margin: Net sales less COGS, labor, rent, utilities, card fees and every other operating cost, divided by net sales, before the owner's draw.
Winter sets the baseline. In January 2025 the two shops rang up 288 transactions a day at an average ticket of $8.02, and net profit margin in February 2025 was -16.6%. That's normal here. The summer pays for the winter, and the owner plans the year around it.
Summer 2025 was run the way summer 2024 had been. College students were hired as they came home in June. Cold brew was batched to the same volume every day, and the bakery delivered the same standing order whatever the forecast said.
July 2025 broke that plan. Transactions reached 870 a day and net sales $238,684, but the average morning wait was 9.6 minutes, against 3.7 in January. Waste hit 4.0% of sales, from cold brew poured away on wet days and pastries ordered for sunny ones, and COGS reached 30.9%. Food attach rate sat at 24.2%, because the pastry case was at the far end of a line nobody wanted to stay in any longer.
The labor numbers looked like the best the company had ever posted. Sales per labor hour was $97.94 and labor cost was 21.7% of sales. They were that good because both shops were short of people.
So over the winter the owner planned summer 2026 from the 2025 data. The schedule was rebuilt from hourly transaction counts, and the seasonal crew was hired by mid-May and trained before Memorial Day. One shift lead stayed on full-time through the winter to run that training. Cold brew batches and the bakery order moved to a par sheet set two days ahead from the forecast high. Menu prices went up in March 2026, and a grab-and-go food shelf went in beside both registers in April. Mobile ordering, with a pickup shelf at the waterfront shop, went live in May.
The winter paid for some of that. Labor cost in February 2026 was 41.1%, against 38.2% a year earlier, and net profit margin fell to -20.7%. The price rise did its job: the average ticket went from $8.30 in February to $8.80 in March, and COGS dropped from 30.3% to 28.7%. The new shelf moved food attach rate from 22.4% in March to 27.2% in April.
July 2026 is the month the plan was built for. Transactions rose to 954 a day and net sales to $288,346, up 20.8% on the July before. The average ticket was $9.75 and food attach rate 31.1%. Waste fell to 2.4% and the morning wait to 5.5 minutes. Labor cost rose to 26.2% and sales per labor hour fell to $85.56, which is what more people on shift looks like. Net sales for June to August came to $811,463, up 22.0%, and net profit for those three months rose from roughly $168,000 to $192,000.
Two numbers fell short. COGS stayed at or near 30% all summer, above its 28% target, with coffee at record prices and more of each ticket coming from food, which costs more to make than a latte. Speed of service never got down to its five-minute target in July or August. And the margin slipped: 24.4% in July 2026 against 26.4% the July before, and 11.1% over the twelve months to September against 12.6%. More profit dollars on a thinner margin, plus a winter shift lead the owner thinks was worth every week.
Creating a Coffee Shop Dashboard in SimpleKPI
-
Step 1 Agree on what a ticket is and what goes in COGS
Does a comped drink for a regular count as a transaction? Is a mobile order split across two cards one ticket or two? Do cups, lids and sleeves go in COGS or in supplies? Is waste logged at cost or at menu price? Two shops answering those differently can't be compared, and a shop that changes its answers can't compare this summer with last.
If you're still choosing which KPIs to run, the KPI selection guide walks through how to pick them.
-
Step 2 Keep the walk-up window, drive-through and app orders apart underneath
The three channels back up differently. A drive-through lane spills onto the road where every passing driver sees it; a walk-up line just gets shorter as people give up; app orders pile up on the pickup shelf and slow the bar for everyone else. Keep transactions and order-to-handoff times by channel and by shop in the POS, even though the board shows both shops combined, so that when the morning wait rises you can tell which lane caused it. Put the shop on every payroll line and waste sheet too, or the waterfront and the highway can't be compared.
-
Step 3 Set cold brew and bakery pars from the forecast, then check them against waste
Cold brew has to be started a day ahead and has a fixed hold time, and the bakery wants its order before anyone knows whether Saturday will be sunny. Set both two days ahead from the forecast high and the day of the week, then read the waste sheet against the weather a week later. High waste on cool, wet days means the par is still set for sun. Running out on hot afternoons means it's set for an average day that doesn't exist in July.
-
Step 4 Hire and train from last July's hourly counts
Pull last summer's busiest weeks while there's still time to hire. Hourly transaction counts set the schedule, and speed of service by hour shows where a second barista or a mobile pickup shelf would have paid for itself. Seasonal hires who start after Memorial Day learn the espresso machine on the busiest days of the year. Then set this summer's targets from those months, not from the annual average.
List of Coffee Shop KPIs
None of these ten has a published US benchmark for independent coffee shops, so every target here is a starting point. Replace them with your own after a full year, and set the sales targets month by month.
| KPI Name | Typical Target | Description / Calculation |
|---|---|---|
| Net Sales | $150,000 a month (starting point); set by month from the same month last year plus planned growth | Gross sales less discounts, comps and refunds, before sales tax and tips. |
| Daily Transactions | ≥ 550 a day (starting point); set by month from the same month last year | POS transactions divided by days open. Voids and staff drinks excluded. |
| Average Ticket | ≥ $9.00 (starting point) | Net sales divided by transactions. |
| Food Attach Rate | ≥ 30% (starting point) | Transactions with at least one food item divided by all transactions. |
| COGS | ≤ 28% (starting point) | Opening inventory plus purchases of coffee, milk, food, cups and syrups, minus closing inventory, divided by net sales. Lower is better. |
| Labor Cost | ≤ 30% over the year (starting point) | Hourly wages plus salaries, payroll taxes and benefits, divided by net sales. Tips excluded. Lower is better. |
| Sales per Labor Hour | ≥ $75 (starting point) | Net sales divided by hourly labor hours worked. Salaried hours excluded. |
| Speed of Service | ≤ 5 minutes (starting point) | Average minutes from order placed to drink handed off, 7am to 10am, all channels. Lower is better. |
| Waste | ≤ 2% (starting point) | Cost of discarded drinks, food, milk and cold brew divided by net sales. Lower is better. |
| Net Profit Margin | ≥ 10% over the year (starting point) | Net sales less COGS, labor, occupancy and all other operating costs, divided by net sales. Before owner's draw, interest and depreciation. |
Why Coffee Shop Dashboards Matter
Coffee is a business of small numbers repeated thousands of times. Forty cents on the average ticket, two minutes off the morning wait, one fewer tray of croissants in the trash: none of them shows on a single day, and across a summer of 900 tickets a day they decide whether the year was good or flat. In a seasonal town the shortfall usually shows up in October, when it's too late to fix the summer.
Most of these ten pull against another one. Cutting a barista from the schedule lifts sales per labor hour and makes the morning wait longer. Selling more food lifts the average ticket and pushes COGS up, because a breakfast sandwich costs more to make than a cappuccino. Brewing less cold brew cuts waste and risks running out at 1pm on the hottest Saturday of the year.
None of those trades is wrong. The owner in this example chose a higher labor cost and a slightly thinner margin to get a shorter line, and made more money doing it. What matters is that the choice was made on purpose, with the numbers in view, rather than found out from the bank balance.
For a shop with a summer peak, the most useful thing on the dashboard in January is last July. Read the speed of service and the waste beside the sales, and hire for what you see. If you run a full-service kitchen rather than a counter, the restaurant dashboard example is built around covers, table turns and prime cost instead.
Building it in SimpleKPI
Build this dashboard yourself with SimpleKPI's KPI dashboards. The mechanics are the same whatever you track:
- KPIs: each one gets a target, an entry frequency and tags, so you can report by team, site, product or whatever you split the numbers by.
- Data: type numbers in, import a spreadsheet, or use an integration or the API. The dashboard updates as each number lands, so daily and monthly KPIs sit side by side.
- Reports: scheduled KPI reports email the numbers to people who never log in.
- AI: Kip, the built-in AI, suggests targets and flags indicative benchmarks (AI estimates, not peer data) once some history builds up.
- Price: $79 a month for unlimited users and KPIs, as one flat price, with a 14-day free trial and no card needed.