What a latte actually costs to make (and where the answer hides)
Ask a shop owner what their 12-ounce latte costs to make and the usual answer is a shrug toward the beans: "maybe a dollar?" The beans are the visible part. The honest answer is a small recipe — espresso, milk, and then the parade nobody prices: the cup, the lid, the sleeve, and (iced) the plastic, the straw, and the ice. Priced properly, most drinks are fine. But almost every board is carrying one drink whose cost crept while nobody looked, and it's rarely the one you'd guess.
Cost the way you pour, not the way you buy
Invoices arrive in bags, gallons, and bottles; drinks leave in shots, ounces, and pumps. The bridge is one division per ingredient: a five-pound bag of espresso at $62.50 that yields 125 double-shot doses is $0.50 a shot. A $4.20 gallon of whole milk is 3.3¢ an ounce. A $7.20 bottle of syrup at 90 pumps is 8¢ a pump. A sleeve of fifty 12-ounce cups with lids at $11 is 22¢ a set. Do that division once for everything behind the bar — packaging included — and every drink on the board becomes simple addition:
| Latte, 12 oz — $5.75 | Qty | Unit cost | Line |
|---|---|---|---|
| Espresso | 2 shots | $0.50 | $1.00 |
| Whole milk | 8 oz | $0.033 | $0.26 |
| Cup + lid | 1 | $0.22 | $0.22 |
| Sleeve | 1 | $0.04 | $0.04 |
| Cup cost | $1.52 — 26% of price |
Twenty-six percent is a healthy specialty-bar number. The point isn't this latte — it's that once the arithmetic exists, every drink gets the same honest read, and the board stops hiding.
The drink that creeps is the modified one
Run the same addition on a 16-ounce iced oat vanilla latte at $7.25: two shots ($1.00), ten ounces of oat milk (8.75¢ an ounce — $0.88), three pumps of syrup ($0.24), a cold cup and lid ($0.21), a straw, ice. Cup cost: about $2.40 — 33% of the price, the worst number on a board where everything else sits in the mid-twenties. Nothing scandalous happened; oat milk simply costs nearly triple dairy per ounce, and the drink accreted a surcharge-worth of extras one modifier at a time. The fix is a menu decision, not a moral one — a bigger oat upcharge, a smaller default pour, a repriced drink — but you can only make it if the number exists.
Blend by what you sell, then scale it
Per-drink numbers decide reprices; the business runs on the blend — each drink's cost weighted by how many you actually sell. Sixty drips and twenty oat lattes produce a very different blended COGS than the reverse, on the identical menu. Put a typical day's mix next to the cup costs and the day prices itself: revenue, cost, gross margin. Then multiply, because coffee is a repetition business: a dime saved on a drink you sell forty times a day is roughly $125 a month, real money for switching lid suppliers or tightening a pour. One deliberate boundary keeps this honest: labor stays out of the cup. Drink cost is COGS; staffing is a different decision with a different lever, and mixing them muddies both.
Ingredients by the shot, recipes per drink, and your typical day priced
The Coffee Shop Drink Costing Calculator is this arithmetic as a workbook: ingredients priced the way you buy and costed the way you pour (packaging too), recipe lines per drink, a menu reading cup cost, margin, and COGS % against your target (“OVER — rework?” in red), and a day-mix calculator that scales your typical morning to a week, a month, a year. Reprice oat milk once and the whole board re-reads. Pure formulas, no macros, Excel & Google Sheets.
An afternoon of division, then it's live forever
List what you buy with pack costs and usable yields, build each drink's lines once, and set your target. From then on the work is maintenance: when an invoice price moves, change one cell and read what happened to the board. To be clear about this note's boundary: it describes costing arithmetic, not business, tax, or food-safety advice — health permits and handling rules are your shop's own, and what you charge is always your call.