A bottled water brand doesn't need a bottling plant. A co-packer, an existing bottler, fills its own bottles with its own water, puts your label on them, and sells them to you by the pallet. What you run is the brand: the label, the customers, the deliveries and the stock. The decision that makes or loses the money is how big a run to order. On this brand's quotes the price falls as the run grows, so the truckload is the cheapest case. It's also the most cash and the most months of water sitting in storage. For the made-up brand below, a case costs $9.93 in a 3-pallet run, $7.52 in a 10-pallet run and $6.77 by the truckload, storage included, and the truckload is nearly nine months of sales. Below is the sum, how to choose, what to ask a bottler, and the file. Every figure is this brand's own: use your quotes.
The short version
- The bottler supplies the water, bottle, cap, case and filling. You supply the label design and the customers.
- Cost of a run = cases × fee + labels + setup + freight.
- Add storage until it's sold: a big run sits for months.
- Cost a case falls with size. Cash out and months of stock rise.
- Order the run you can sell in a few months, not the cheapest one.
- Ask for the lot code on every case, and keep a record of where each went.
- TaroStack keeps each run as a lot and shows what's left of it. More below.
Three quotes, one brand
This brand sells 180 cases a month, of 24 bottles.
| 3 pallets | 10 pallets | A truckload, 22 pallets | |
|---|---|---|---|
| Cases | 216 | 720 | 1,584 |
| Fee a case | $5.40 | $4.60 | $4.10 |
| Label a bottle | $0.06 | $0.04 | $0.03 |
| Setup fee | $350.00 | $350.00 | $350.00 |
| Freight a pallet | $95.00 | $70.00 | $45.00 |
| Months to sell | 1.2 | 4.0 | 8.8 |
| Cost of the run | $2,112.44 | $5,053.20 | $8,974.88 |
| Storage until sold | $32.40 | $360.00 | $1,742.40 |
| Cost a case | $9.93 | $7.52 | $6.77 |
| Cost a bottle | $0.414 | $0.313 | $0.282 |
The run. For 3 pallets: 216 cases at $5.40 is $1,166.40. Labels for 5,184 bottles at 6 cents, $311.04. The setup fee, $350.00. Freight for three pallets, $285.00. Together, $2,112.44, paid before a bottle is sold.
Storage. At $18.00 a pallet a month, charged on what's left as it sells down, the truckload's 22 pallets over 8.8 months cost $1,742.40. That's $1.10 on every case, and it takes back nearly half of the truckload's price advantage over the 10-pallet run.
The result. From 3 pallets to 10, a case gets $2.41 cheaper. From 10 pallets to a truckload, 75 cents.
How big a run
This brand sells a case for $14.50.
| 3 pallets | 10 pallets | A truckload | |
|---|---|---|---|
| Left a case | $4.57 | $6.98 | $7.73 |
| Left a month, at 180 cases | $823 | $1,257 | $1,392 |
| Cash paid for the run | $2,112.44 | $5,053.20 | $8,974.88 |
| The run, in months of sales | 0.8 | 1.9 | 3.4 |
The step from 3 pallets to 10 is worth $434 a month for $2,940.76 more cash. The step from 10 to a truckload is worth $135 a month for $3,921.68 more, and it turns four months of stock into nearly nine.
Those nine months carry risks the sum doesn't. A customer who takes 60 cases a month can leave. A label can change. This brand's cases carry a best-by date, and a hotel may refuse cases close to it. This brand orders 10 pallets, and will look at a truckload when it sells 400 cases a month and the truck is four months of sales.
What to ask a bottler
- The water. What's the source, and what is it sold as on the label? May I see the latest test reports?
- The minimum. Smallest run, in pallets? Is there a fee for a small one?
- The label. What size and material? Who prints it, and what's the lead time for a new design?
- Whose name is on it. What does the label say about who bottled it and who it's distributed by?
- Codes. Is there a date or lot code on each bottle and each case? What does it mean?
- The pallet. How many cases, how high, wrapped how? Can I collect, or do you deliver?
- Lead time. From order to pickup, and how far ahead do you book?
- Storage. Can a run stay with you and be called off by the pallet? At what price?
- A problem. If you find a fault in a run after I have it, how do I hear?
What the bottler's own plan covers is in HACCP plan for bottled water. What to put in writing is in private label agreement, and finding a packer at all in how to find a co-packer. The sums for a bottler with its own plant and a delivery route are in bottled water profit margin.
Get the sheet
Download the co-packed water run sheet. One sheet and a read-me: type each quote's cases, fee a case, label, setup fee, freight and storage, and the cases you sell a month, and it works out the pallets, the months to sell, the cost of the run, the storage until it's sold, and the cost of a case and a bottle. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The sheet prices a run before it's ordered. Afterward there are two runs in the storage unit with different codes and different dates, and a list of hotels and gyms that each got some of each. When the bottler phones about one code, or a hotel asks how old its cases are, the sheet has nothing to say. And the 180 cases a month it was built on was a guess that nobody has checked against what actually left.
How TaroStack does it
TaroStack keeps each run as a lot, from the pallet to the customer.
Each run comes in as a lot, at what you paid, with the bottler's code and the best-by date.
Oldest out first. Picking takes the first-expired lot by default, and lots close to their date are flagged.
Customers and sales orders, with what ships recorded by lot. One report shows every customer a run reached.
A reorder list in days of cover, with the bottler's lead time and minimum, from how stock actually moves.
Margins by product and by customer, on what each run actually cost.
| The question | Run sheet | In TaroStack |
|---|---|---|
| Cases left of each run | Count the pallets | Stock by lot |
| Which hotels got run two | Read the invoices | One report |
| When to order the next run | A guess at 180 a month | Days of cover, from real sales |
| What a case cost in each run | The quote | From what you paid |
TaroStack doesn't book freight or take payments. Lots, dates, sales orders and reordering 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.
