A roaster buys green coffee and loses about 15% of its weight in the roaster, so 15 pounds of green makes about 12.75 pounds to sell. Green coffee is most of a bag's cost; the valve bag, label and roasting time make up the rest. Retail bags keep a wide margin, café wholesale a thin one, and a cup poured at a market the widest. Margin = (price − cost) ÷ price. In the example below, a 12-ounce bag costs $8.95 to roast and sell and goes for $18.00, a 50.3% margin. A month of four ways of selling brings $18,200 of sales and about $8,160 of gross profit.
The short version
- Margin = (price − cost) ÷ price; markup = (price − cost) ÷ cost.
- Count your time as a cost, even if you don't pay yourself yet.
- A 12-ounce retail bag: $8.95, $18.00, 50.3%.
- Roasting loses about 15% of the green weight.
- Café wholesale keeps a thin margin.
- Subscriptions keep close to retail and come every month.
- TaroStack costs each bag from what each roast used. More below.
A bag, costed
Driftwood Coffee Roasters, the made-up roaster in Bend, Oregon, I use in these examples, roasts 15 pounds of green coffee at a time into 17 twelve-ounce bags:
| A 12-ounce bag at the market | Cost |
|---|---|
| Green coffee, after roast loss | $5.74 |
| Valve bag and label | $0.85 |
| Roasting and packing | $1.82 |
| Card fees, 3% of $18.00 | $0.54 |
| Cost | $8.95 |
Setting the bag price is in how to price coffee, and roasting at home in can you sell coffee from home.
Margins by channel
| Product | Sold where | Price | Cost | Gross profit | Margin |
|---|---|---|---|---|---|
| Whole bean, 12 oz bag | Markets and online | $18.00 | $8.95 | $9.05 | 50.3% |
| Whole bean, 5 lb bag | Cafés, wholesale | $60.00 | $45.44 | $14.56 | 24.3% |
| Subscription, 12 oz bag | Monthly, shipped | $17.00 | $9.52 | $7.48 | 44% |
| Drip coffee, 12 oz cup | Farmers market stand | $3.50 | $1.51 | $2.00 | 57% |
The café's 5-pound bag keeps 24.3%; the subscription keeps 44%, with the mailer in its cost and the postage charged to the customer.
A month's numbers
A month for Driftwood Coffee Roasters:
| Product | Units | Sales | Gross profit |
|---|---|---|---|
| Whole bean, 12 oz bag, markets and online | 400 | $7,200 | $3,620 |
| Whole bean, 5 lb bag, cafés | 60 | $3,600 | $874 |
| Subscription, 12 oz bag, monthly | 250 | $4,250 | $1,870 |
| Drip coffee, 12 oz cup, farmers market stand | 900 | $3,150 | $1,796 |
| Month | $18,200 | $8,159 |
Retail bags and subscriptions bring most of the gross profit; the cafés bring steady pounds and the roaster's name on a menu board. The cups at the market sell bags: people taste the coffee and take one home. When the roasting outgrows the roaster, the choice is in coffee co-packer.
Get the calculator
Download the coffee margin calculator. One sheet: one line for each product and channel, with its price, materials, packaging, labor and fee rate; the cost, gross profit, margin, markup and the price your target margin needs fill in. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator holds one green price and one roast loss. A new lot of green at $1 more a pound, or a darker roast that loses 18%, changes every bag, and only the roast records show it.
How TaroStack does it
TaroStack costs each bag from what each batch used, so margins sit on real cost.
True cost from the batch. Each batch takes green coffee at the price of the deliveries they came from, so a price rise shows in the next batch's cost.
Labor on the batch. The minutes a batch took are recorded on it, so the hours behind each product are on record.
Margins by product. Margins are reported per product on that actual cost, and a price-creep report per supplier shows whose prices moved.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| What a bag cost | One price from last season | Cost from the batch's deliveries |
| The hours behind a batch | Remembered | Labor minutes on the batch |
| An ingredient creeping up | Noticed late | A price-creep report |
| Margins by product | Re-worked by hand | Margins on real cost |
Recipes, batches, costing and margin reports are on every plan, from $49 a month. The first 30 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
