The water in a bottle of water costs almost nothing, which is why people assume the margin is enormous. It isn't the water you're selling. It's the bottle, the cap, the label, the film and the truck, and those are most of the cost of a case. In the made-up bottler below, a case of 24 sold to convenience stores keeps 33.5%, the same case sold through a distributor keeps 9.1%, and a 5 gallon jug delivered to an office keeps 55.8%, because the jug comes back and is filled again. So the margin depends far more on the package and the route to the customer than on the water. Below are five products, a month, what moves the number, and a calculator. Every figure is this bottler's own: use your invoices.
The short version
- Packaging and delivery, not water, are the cost of a case.
- The same case keeps 33.5% sold to stores and 9.1% through a distributor.
- A refillable 5 gallon jug keeps 55.8%, and needs a driver and a route.
- Private label sits in between, at 18.4%.
- This month sells $56,770 and has $3,806 left after fixed costs.
- Volume through a thin channel can fill the line without paying for it.
- TaroStack costs each run from what the bottles and film really cost. More below.
Five products
| Product | Sold where | Price | Cost | Left | Margin |
|---|---|---|---|---|---|
| Case of 24, 16.9 oz | To convenience stores | $6.50 | $4.32 | $2.18 | 33.5% |
| Case of 24, 16.9 oz | To a distributor | $4.75 | $4.32 | $0.43 | 9.1% |
| Case of 24, private label | For a gym chain | $5.60 | $4.57 | $1.03 | 18.4% |
| 5 gallon jug, delivered | Offices, on a route | $8.00 | $3.54 | $4.46 | 55.8% |
| 1 gallon jug | To grocers | $1.45 | $0.82 | $0.63 | 43.4% |
Cost is this bottler's variable cost for one unit: water treatment, preforms and caps, labels, film and tray, the labor to run and load it, and card fees where a customer pays by card.
The distributor's case costs the same $4.32 to make as the store's and sells for $1.75 less. What's left is 43 cents. A distributor moves volume a small bottler can't reach alone, and takes its margin for doing it.
The 5 gallon jug has 35 cents of water and cap in it and $2.40 of a driver's time. The jug itself isn't in the cost because it comes back. That only holds while jugs do come back: a lost jug is several fills' profit.
The gallon jug keeps 43.4% of a small price: 63 cents.
A month
| Product, sold where | Units | Sales | Left after its own costs |
|---|---|---|---|
| Case of 24, 16.9 oz, to convenience stores | 2,400 | $15,600 | $5,232 |
| Case of 24, 16.9 oz, to a distributor | 3,000 | $14,250 | $1,290 |
| Case of 24, private label, for a gym chain | 1,200 | $6,720 | $1,236 |
| 5 gallon jug, delivered, offices, on a route | 1,800 | $14,400 | $8,028 |
| 1 gallon jug, to grocers | 4,000 | $5,800 | $2,520 |
| Total | $56,770 | $18,306 | |
| Fixed costs | −$14,500 | ||
| Left | $3,806 |
Fixed costs here are rent, the line's lease, utilities, water testing, insurance, the truck and one salary: $14,500 a month. At this mix the bottler has to sell about $44,967 a month to cover them.
The distributor takes the most units and brings in the least. Three thousand cases leave $1,290. The route, with 1,800 jugs, leaves $8,028. If the line has spare hours, the distributor's cases cover some fixed cost. If it doesn't, they're crowding out work that pays six times as much per hour of line time.
What moves the number
- Resin and film. Packaging is $1.85 of a $4.32 case. A ten percent rise there is 19 cents, and nearly half of what the distributor's case leaves.
- Route density. The jug's cost is mostly driving. Ten stops in one industrial park and ten stops across a county are different businesses.
- Private label terms. The gym chain's case keeps 18.4% because its label costs more. Who pays for label changes and minimum runs decides whether that holds.
- Line speed. Labor is 42 cents a case at this bottler's speed. A line that stops for changeovers puts more labor in every case.
Markup and margin aren't the same number: see markup vs margin. What a product should keep is in good profit margin for food product, a bottler's safety plan in HACCP plan for bottled water, and what a distributor takes in distributor margin.
Get the calculator
Download the bottled water profit margin calculator. One sheet and a read-me: a row for each product and channel, with price, materials, packaging, labor 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 one cost for a preform and one for film. A bottler buys them by the truckload at a price that moves with resin. The cost typed in March is still there in September, and the distributor's 43 cents may by then be 20, or nothing, without anyone having decided to sell at a loss.
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.
Each product is a recipe, and each batch or run takes its materials off stock by lot. Its cost comes from the lots it used.
Margins by product, on real cost. A case to a store and the same case to a distributor are seen side by side.
A price-creep report by supplier shows what went up and by how much.
Customers and sales orders, so what each case sold for is beside what it cost.
| The question | A sheet typed once | In TaroStack |
|---|---|---|
| What a case 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 plan delivery routes or take payments. Recipes, batches and costs 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.
