A latte is 18 grams of coffee, 10 ounces of milk, a cup, a lid, a sleeve and about three and a half minutes of a barista. Cost each at what you pay, and the 12 oz latte below comes to $2.30: 63 cents of coffee, 34 cents of milk, 27 cents of paper and $1.05 of labor. At $5.50 it leaves $3.04 toward the cart, the rent and you. The calculator works for any espresso drink; change the grams, the ounces and the prices.
The short version
- Coffee: grams in the dose × price of the bag ÷ grams in the bag.
- Milk: ounces steamed (not ounces in the cup) × price a gallon ÷ 128.
- Cup, lid and sleeve are a real line. So is a syrup pump.
- Labor is the minutes from order to handoff.
- TaroStack tracks beans, milk and cups as they're used and keeps each drink's cost current. More below.
An example: a 12 oz latte
Foothills Coffee Cart is a made-up Boise espresso cart I use in these examples:
| What goes in | Amount | You pay | Cost |
|---|---|---|---|
| Espresso, roasted beans | 18 g | $16.00 a pound (454 g) | $0.63 |
| Milk | 10 fl oz | $4.40 a gallon | $0.34 |
| Ingredients | $0.98 |
| The latte | |
|---|---|
| Ingredients | $0.98 |
| Cup 16 cents, lid 5 cents, sleeve 6 cents | $0.27 |
| Labor: 3.5 minutes at $18 an hour | $1.05 |
| Full cost | $2.30 |
| Where it sells | Price | Fees | Left | Margin |
|---|---|---|---|---|
| Latte, at the cart | $5.50 | 3% | $3.04 | 55% |
| Event, prepaid by the host | $4.00 | 0% | $1.70 | 43% |
(The ingredient lines round to 63 and 34 cents; unrounded they add to 98.)
Why 10 ounces of milk in a 12 ounce cup
You steam more than you pour. Milk left in the pitcher goes down the drain, and it was paid for. Measure what goes into the pitcher for a week, not what ends up in the cup. The same goes for coffee: 18 grams is the dose, but dialing in the grinder each morning and the odd sink shot are beans too. If a 5 lb bag yields 115 drinks where the dose says 126, your real coffee cost is 70 cents a drink, not 63.
What changes the answer
| Change | Cost of the latte |
|---|---|
| As above | $2.30 |
| Oat milk at $7.00 a half gallon (10 oz is $1.09) | $3.05 |
| Vanilla syrup, one ounce at $0.22 | $2.52 |
| 16 oz size: 13 oz of milk, larger cup | $2.43 |
| A rush: two baristas, 2 minutes a drink | $1.85 |
Oat milk adds 75 cents. If your upcharge is 75 cents you break even on it; at a dollar you make a quarter. And speed is worth more than any ingredient: a drink made in 2 minutes costs 45 cents less in labor than one made in 3.5.
Get the calculator
Download the coffee drink cost calculator. Two sheets and a read-me: the cost of one drink and the prices to test. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. The cart's whole year is in coffee cart business plan, and a shop's margins in coffee shop profit margin.
Where this stops working
The sheet tells you what a latte should cost. It can't tell you what it did cost this week, because that depends on how much milk and coffee actually left the cart against how many drinks were sold. The gap between the two is waste, free drinks and heavy pours, and it's where a café's margin goes.
How TaroStack does it
TaroStack compares what the recipes say you used with what's gone from the shelf.
Each drink is a recipe. 18 grams of beans, 10 ounces of milk, a cup, a lid, a sleeve.
Stock is counted, fast. Count beans, milk and cups on a phone, with no signal if the cart's in a field. The count shows what a difference is worth before you post it, and suggests what to count first.
The gap is a number. If the recipes say the week used 9 gallons of milk and 11 are gone, that's 2 gallons to explain, in dollars.
Costs follow deliveries. When milk goes to $4.85, every milk drink's cost moves with it.
Selling at a till. TaroStack connects to Square.
| The job | Calculator | In TaroStack |
|---|---|---|
| What a latte should cost | Yes | From the recipe and what you paid |
| What the week really used | No | Counts against recipes |
| Milk went up | Retype | Updates every milk drink |
| Cups and lids | Look in the box | A reorder list |
Recipes and true cost are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
