A fountain drink is syrup, carbonated water, ice and a cup, and the cup costs nearly as much as what's in it. In the made-up restaurant below, a medium costs 39 cents to pour, with 26 cents of syrup, gas and water and 13 cents of cup, lid and straw, and sells for $2.69. After the card fee it keeps 82.5% of its price. That's a high margin, which is why it's worth knowing exactly: every decision about refills, combo prices and cup sizes moves real money. Below are six drinks, a month, what moves the number, and a calculator. Every figure is this restaurant's own.
The short version
- A medium costs 39 cents: 26 of syrup, gas and water, 13 of cup, lid and straw.
- At $2.69 it keeps 82.5% after the card fee.
- A refill doubles the syrup and still keeps 72.8%.
- In a combo priced at $1.50 the same drink keeps 71.0%.
- A bottled soda at $2.79 keeps 48.6%.
- The machine's lease and cleaning come out of the month, not out of each cup.
- TaroStack costs syrup and cups from what you last paid. More below.
Six drinks
| Product | Sold where | Price | Cost | Left | Margin |
|---|---|---|---|---|---|
| Small, 16 oz | Counter | $2.29 | $0.37 | $1.92 | 83.9% |
| Medium, 22 oz | Counter | $2.69 | $0.47 | $2.22 | 82.5% |
| Large, 32 oz | Counter | $2.99 | $0.63 | $2.36 | 78.9% |
| Medium, with one refill | Dining room | $2.69 | $0.73 | $1.96 | 72.8% |
| Medium, in a combo | Counter, priced at $1.50 in the meal | $1.50 | $0.43 | $1.06 | 71.0% |
| Bottled soda, 20 oz | Cooler | $2.79 | $1.43 | $1.36 | 48.6% |
Cost is syrup, carbon dioxide, water and ice, the cup, lid and straw, and a 3% card fee.
Sizes. The large has twice the syrup of the small and costs 24 cents more to pour. It sells for 70 cents more. Bigger cups earn more, in cents, for the same trip to the counter.
The refill. A second fill adds 26 cents of syrup and no cup. The drink still keeps 72.8%. Free refills cost this restaurant about a quarter each time one is taken.
The combo. A drink priced at $1.50 inside a meal keeps $1.06, against $2.22 sold alone. That's the price of the combo, and it buys a sandwich sale that might not have happened.
The bottle. A bottled soda costs $1.35 and keeps 48.6%. It earns less than a small fountain drink, and it takes cooler space.
A month
| Product, sold where | Drinks | Sales | Left after its own costs |
|---|---|---|---|
| Small, 16 oz, counter | 900 | $2,061 | $1,729 |
| Medium, 22 oz, counter | 1,500 | $4,035 | $3,329 |
| Large, 32 oz, counter | 700 | $2,093 | $1,652 |
| Medium, with one refill, dining room | 600 | $1,614 | $1,176 |
| Medium, in a combo, counter, priced at $1.50 in the meal | 2,400 | $3,600 | $2,556 |
| Bottled soda, 20 oz, cooler | 300 | $837 | $407 |
| Total | $14,240 | $10,849 | |
| Fixed costs | −$650 | ||
| Left | $10,199 |
Fixed costs here are the fountain's lease and cleaning supplies: $650 a month. At this mix the drinks cover that with about $853 of sales.
The month's $14,240 of drink sales leaves $10,199 after the machine. The 2,400 drinks that went out in combos at the lowest price still leave $2,556, the second largest line.
What moves the number
- The cup. Cup, lid and straw are a third of a medium's cost. Two cents on the cup is two cents on every drink: about $122 on this month's 6,100 cups.
- The mix ratio. Syrup is metered against water by the machine. A valve that pours rich uses syrup faster than the price assumes. Check it when a box runs out sooner than it should.
- Ice. Ice displaces drink. Less ice in the cup is more syrup in it.
- Refills taken. Count cups against syrup boxes used and you'll know how many refills the dining room takes.
The same sum for cocktails and coffee is in drink cost calculator. Markup against margin is in markup vs margin, and the whole restaurant's numbers in restaurant profit margin.
Get the calculator
Download the fountain drink profit margin calculator. One sheet and a read-me: a row for each drink, with price, syrup, cup and fees, and the cost, gross profit, margin and markup worked out. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator has a cost for syrup per drink. The storeroom has bag-in-box syrup bought at three prices this year, and a stack of cups from two suppliers. The cost of a medium is whatever those were, in the proportions the machine and the customers actually used them. Nobody recalculates that when an invoice arrives.
How TaroStack does it
TaroStack works the margin out from what you actually paid.
Receiving records each delivery at what it cost, freight included, so a price rise shows up the week it happens.
Margins by product, on real cost. A fountain drink and a bottle are seen side by side.
A price-creep report by supplier shows what went up and by how much.
Counting works on a phone, and a count shows what each difference is worth.
A reorder list in days of cover, with each supplier's lead time and minimum.
| The question | A sheet typed once | In TaroStack |
|---|---|---|
| What a drink costs today | The price from the last time you typed it | From the last delivery |
| Which product earns the most | Last quarter's guess | Margins by product |
| What went up | Compare invoices | Price creep, by supplier |
| What's on hand, and what it's worth | Count and multiply | Stock value |
TaroStack doesn't run the till or meter the fountain. It connects to Square. Stock, receiving, counts and margins are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). 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.
