This calculator vs. a spreadsheet
A spreadsheet can subtract cost from price fine. Where it quietly goes wrong: a half-filled modifier or mixer priced as free instead of flagged, no way to solve backward from a target percentage to the price it needs, and no annualized figure for what a small over-pour costs across a year of shifts.
What each one actually does
A lot of beverage programs already reach for a spreadsheet: one column per ingredient cost, a formula that sums them, another that divides the total by the menu price. That arithmetic is trivial and a spreadsheet does it fine, for a recipe that is fully typed in. What it does not do on its own is catch the mistakes that actually change the number: a modifier or mixer line started but not finished, a target percentage that has to be reached by guessing at prices one at a time, and a small over-pour that never gets turned into what it costs across a real drink volume.
This calculator takes one recipe — a primary spirit plus an optional modifier and mixer, each priced by bottle cost, bottle size, and the amount poured — and works out the pour cost percentage, the price this exact recipe would need to hit a target you set, and the weekly and annual cost of a stated over-pour on the primary spirit across your own drink volume. It runs free in any browser, keeps no account, and nothing you type is uploaded.
| Question | Where to answer it |
|---|---|
| What's this recipe's pour cost, given its ingredient costs and menu price? | Either one — a spreadsheet divides fine, once every cost is entered. |
| I typed a modifier's bottle cost but forgot its pour size. What happens? | This calculator — flags the unfinished line instead of quietly pricing it as free. |
| What price does this recipe need to hit an 20% pour cost target? | This calculator — solves backward for the price in one pass, no trial and error. |
| What is a quarter-ounce over-pour on the well spirit actually costing across a year? | This calculator's over-pour section — annualized from your own drinks-per-week figure. |
| How do I calculate pour cost by hand, with the formula and a worked example? | This calculator's worked walkthrough. |
| Is anything I enter uploaded anywhere? | No, on either — but this calculator needs no formulas to build or maintain. |
Most beverage programs get different value from each: an ongoing spreadsheet or POS export for tracking every recipe and every price change over a season, and a page like this one for an instant, no-login check on one recipe's real pour cost, the price it would take to hit a target, and what an over-pour on it is really costing before or without ever building a formula. This page's own figures are an arithmetic comparison built from what you typed in, not a substitute for your own cost records.
This tool needs no account and no sign-in: it is a static page, the arithmetic runs in your browser, and once it has loaded it keeps working with the connection off. Nothing you type is uploaded.
A worked example
A well spirit at $22 a 750ml (25.4oz) bottle, poured at 1.5oz, mixed with 5oz from a $4 mixer bottle, sold at $7 with a 20% target: the recipe's real pour cost is 27.0%, 7.0 points above target, so hitting 20% at this exact recipe cost would take a menu price of $9.45, not $7.00. Nothing about that math needs a new spreadsheet formula — it needs the division run backward, which a cell built for the forward direction does not do on its own.
Add a quarter-ounce over-pour on the well spirit and the same recipe's pour cost moves to 30.1%. Across 400 drinks a week that is $86.61 a week, or about $4,504 a year, in liquor the $7 price never accounted for — a figure no single ticket, and no spreadsheet built one drink at a time, shows on its own.
Common questions
Isn't pour cost just ingredient cost divided by menu price?
That division is trivial and a spreadsheet does it fine once every ingredient cost is already in a cell. What a plain spreadsheet does not do on its own is decide what a half-entered modifier or mixer line means — a blank cell just computes as zero, which prices that ingredient as free rather than flagging that the entry is unfinished.
Why does a partially filled modifier or mixer line matter?
A recipe slot has three fields — bottle cost, bottle size, and the amount poured — and all three blank means the recipe genuinely skips that ingredient, which is a normal, valid entry. One or two filled in is different: it is a bottle cost typed in with no pour size next to it, which a spreadsheet formula either errors on or silently treats as zero. This calculator tells the two cases apart and asks you to finish or clear the slot instead of guessing which one you meant.
What does solving backward for the target price actually save you?
Most spreadsheets go one direction: type a menu price, get a pour cost percentage. Hitting a specific target percentage from there means typing a different price, checking the percentage, and typing again until it lands — trial and error with the same formula. This calculator solves the arithmetic in the other direction too: enter the target percentage and it shows the exact price this recipe, at its current ingredient cost, would need to hit it, in one pass.
Why does a small over-pour matter enough to compute a whole year of it?
A quarter-ounce over a 1.5oz pour looks generous on any single ticket, not expensive — a spreadsheet that only prices one drink at a time never shows the other side of it. Multiplied by the primary spirit's cost per ounce and the drinks actually poured in a week, then by 52 weeks, the same over-pour becomes a specific dollar figure across a year, which is the number that makes it worth fixing rather than shrugging at.
Does this replace a beverage program's own cost spreadsheet or POS reports?
No. A spreadsheet or POS report that tracks every recipe, every price change, and every ordering period over a season is still the right tool for that ongoing record. This page answers one recipe at a time — what its real pour cost is, what price it would need to hit a target, and what a stated over-pour on it is costing across a year — and nothing it computes is saved anywhere once you leave the page.
Open the Pour Cost Calculator to check your own recipe, or read how to calculate pour cost.