Coffee drink cost calculator

How do you calculate the cost of a coffee drink?

There is one sum, and every drink cost calculator on the internet is running it. What separates a real number from a guess is not the calculator, it is whether you know what a gram of your beans costs and how many grams actually go in the cup.

cost per unit = pack cost / pack size, converted to the unit you pour
line cost    = amount poured x cost per unit
drink cost   = every line added up
food cost %  = drink cost / menu price x 100
gross        = menu price - drink cost

The same sum with the seeded numbers in it, so you can check the calculator against your own arithmetic:

beans   $65.00 / 2,267.96 g   = $0.0287 per gram
        20 g x $0.0287       = $0.57

oat     $28.80 / 192 oz      = $0.1500 per ounce
        6 oz x $0.1500       = $0.90

cup     $12.00 / 50 each     = $0.24 each
lid     $5.50 / 50 each      = $0.11 each
sleeve  $5.00 / 100 each     = $0.05 each

drink cost = 0.57 + 0.90 + 0.24 + 0.11 + 0.05 = $1.87

Every ingredient arrives priced in a unit you do not pour. Beans come by the pound and go in by the gram. Milk comes by the case and goes in by the ounce. Cups come 50 to a sleeve and leave one at a time. So the first move on every row is one division you do once and reuse forever.

Two conversions carry most of the work behind a bar: a pound is 453.59 grams, and a gallon is 128 fluid ounces. The calculator does both, plus kilograms, litres and millilitres. What it will not do is convert a weight into a volume, because that needs a density it does not have. Ask it for pounds into millilitres and it says so on the row and leaves the row out of the total instead of inventing a number.

Round once, at the end. Rounding each line to cents before adding them is how a five line drink drifts a few cents from the truth, which is small until you price a menu off it.

A worked example in real dollars

The calculator opens on a 12 ounce hot oat latte, seeded with the pack prices from a working cafe, so it is useful before you type anything. Twenty grams of Ethiopian out of a five pound bag at $65. Six ounces of oat out of a case that works out to $0.15 an ounce. A cup, a lid and a sleeve.

That drink costs $1.87 to make. On a $6.50 menu price that is a 28.8 percent food cost and $4.63 left on the ticket before anyone is paid to make it.

Two things in that table are worth sitting with. The milk is $0.90 of $1.87, just under half the drink, which is not where most owners spend their attention. And the cup, lid and sleeve add up to $0.40, about 21 percent of the drink, which is the part that gets left out of most costing exercises entirely. Leave the paper out and every menu price you set off that number is 21 percent optimistic.

Now swap your own prices in. Change the pack cost and pack size on any row to what your last invoice said, add rows for syrup or a second shot, and read the total again. Then export the CSV or print it.

Every one of those five lines, and the reasoning behind it, is written out in what it costs to make a latte.

Frequently asked questions about drink cost

How do you calculate the cost of a coffee drink?

Divide each pack cost by its pack size to get a cost per unit, multiply that by the amount the recipe actually pours, and add the lines up. Beans at $65 for a five pound bag is $0.0287 a gram, so a 20 gram dose is $0.57. The arithmetic is the easy half. The hard half is knowing the true dose and having the pack price in front of you, which is why the calculator asks for the invoice figure rather than a cost per gram you would have to work out yourself.

Should the cup and lid be in the drink cost?

Yes. A cup leaves the shelf on a specific sale, so it belongs on that drink's line, not in a supplies bucket you look at once a quarter. On the seeded latte the cup, lid and sleeve are $0.40 of a $1.87 drink, about 21 percent. That is the single most commonly dropped line in a drink costing, and dropping it makes every price you set off the result look better than it is.

What does an oat milk swap add to a latte?

On the published example it is about 48 cents on one latte: ten ounces of oat at $0.089 an ounce against whole milk at $0.041. Rather than take that figure, run it. Change the milk row's pack cost and pack size to your whole milk pack, read the total, then change it back. The reason the number matters is not its size, it is that the receipt total does not move when a customer says make it oat, so nothing in your register ever tells you the drink got more expensive.

Why does my food cost look lower than this?

Usually three lines are missing. The second shot, because most bars pull doubles all day while the recipe card in someone's head says single. The paper, because a lid does not feel like an ingredient. And the modifier, because the version that was actually sold is not the version that was costed. Add those three back and most cafe drinks land higher than the owner expected.