A candy shop's margin is made by the scoop. Candy bought by the case and sold by the quarter pound keeps far more of its price than anything that arrives in its own box. In the example below, a made-up neighborhood candy shop keeps 61.3% of a quarter pound of bulk candy and 46.2% of a box of chocolates. Its month sells $23,460, leaves $12,616 after the cost of what it sold, and $3,097 after rent, wages and the candy that was sampled, went stale or walked out. Below are six lines with their margins, the month, what moves the number, and a calculator. Every figure is the example's own.
The short version
- Bulk candy: $4.00 a quarter pound, $1.55 of cost, 61.3% kept.
- Fudge made in the shop keeps the same, 61.2%, and takes time to make.
- Boxed chocolates keep 46.2%. Gift baskets keep 37.7%.
- The month: $23,460 of sales, $3,097 left before the owner's pay.
- Rent and wages are $8,000 of the $9,050 in fixed costs.
- Shrink in a shop with open bins is real. Count it.
- TaroStack keeps bulk candy by the pound and by lot, with its dates. More below.
Six lines
| Product | Price | Cost | Left | Margin |
|---|---|---|---|---|
| Bulk candy, a quarter pound | $4.00 | $1.55 | $2.45 | 61.3% |
| Boxed chocolates, 8 oz | $18.00 | $9.69 | $8.31 | 46.2% |
| Fudge, made in the shop, a quarter pound | $6.00 | $2.33 | $3.67 | 61.2% |
| Novelty and imported candy, each | $4.00 | $2.42 | $1.58 | 39.5% |
| Gift basket, made to order | $45.00 | $28.05 | $16.95 | 37.7% |
| Soda and drinks, each | $3.00 | $1.24 | $1.76 | 58.7% |
Cost is what the shop paid for the candy, the bag or box, the time to scoop, make or assemble it, and a 3% card fee.
Bulk. This shop pays an average of $4.60 a pound for the candy in its bins and sells it at $16.00 a pound, a quarter pound at a time. The quarter pound costs $1.15, the bag 8 cents, the time to weigh and ring it 20 cents, and the card fee 12 cents.
Chocolates. A box bought at $9.00 and sold at $18.00 is a 50% margin before the card fee and the time at the counter, 46.2% after. The price is the maker's suggestion and the shop down the road sells the same box.
Fudge. $1.10 of sugar, butter, cream and chocolate in a quarter pound, and 90 cents of time: someone stands at the kettle. It keeps as much as bulk candy, and it's the one thing in the shop nobody else sells.
Baskets. $45.00 looks like the big sale. It holds $19.50 of candy at cost, a $3.20 basket and wrap, and twelve minutes of someone's time. It keeps $16.95, the most dollars of any line and nearly the lowest share.
A month
| Product | Sold | Sales | Left after its own costs |
|---|---|---|---|
| Bulk candy, quarter pounds | 2,400 | $9,600 | $5,880 |
| Boxed chocolates | 180 | $3,240 | $1,496 |
| Fudge, quarter pounds | 520 | $3,120 | $1,908 |
| Novelty and imported candy | 900 | $3,600 | $1,422 |
| Gift baskets | 40 | $1,800 | $678 |
| Soda and drinks | 700 | $2,100 | $1,232 |
| Total | $23,460 | $12,616 | |
| Fixed costs | −$9,050 | ||
| Shrink, 2% of sales | −$469 | ||
| Left | $3,097 |
Fixed costs here are rent ($3,800), wages for counter staff ($4,200), utilities ($450), insurance ($220) and supplies and other costs ($380): $9,050 a month. At this mix the shop needs about $16,830 of sales to cover them.
Bulk candy is 41% of sales and 47% of what's left. 600 lb a month across the bins. The chocolates, which look like the premium end, bring $1,496.
The $3,097 is before the owner's pay. The owner works the counter and isn't in the wages line.
December isn't this month. A candy shop's year has a few very large weeks. This is an ordinary month, and it's the ordinary months that have to cover the rent.
What moves the number
- Shrink. Open bins mean samples, spills, candy that goes stale before the bin empties, and some that leaves in pockets. This shop loses about 2% of sales, $469 this month. It knows because it weighs the bins monthly. A shop that doesn't weigh has shrink too, and no number for it.
- Slow bins. Sixty kinds of candy don't sell equally. A bin that takes four months to empty is selling stale candy by the end. Fewer, faster bins, or smaller fills of the slow ones.
- Scoop size. Customers serve themselves by eye. The price a pound does the work, so the scale has to be right and checked.
- Seasonal buys. Holiday candy is ordered months ahead and marked down the day after. What's left on December 26 comes straight off the month's margin: see retail markdown formula.
- The fudge kettle. A second batch a day costs ingredients and an hour, and sells at 61%. It's the cheapest way this shop has to add margin, as long as the fudge sells while it's fresh.
A sheet for the stock is in candy store inventory, opening a shop in how to start a candy store, and making the fudge pay in fudge profit margin. The two percentages people quote are explained in markup vs margin.
Get the calculator
Download the candy store profit margin calculator. One sheet and a read-me: a row for each line, with price, cost of the candy, packaging, time 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 knows what a quarter pound keeps. It doesn't know that there are sixty bins, that the sour belts were filled in August, or that the case of imported chocolate in the back passes its date in three weeks. And shrink is only "2%" because somebody weighs the bins. Margin by line is arithmetic. What's in the shop, how old it is and how much has gone missing is the part that takes a system.
How TaroStack does it
TaroStack keeps candy by weight, by lot and by date.
Buy by the case, stock by the pound, sell by the quarter pound. TaroStack does the conversion.
Each delivery is a lot with its best-before date, and lots close to their date are flagged.
Counting on a phone: weigh a bin, type the weight, and see what the difference is worth before you post it.
Adjustments carry a reason: samples, damaged, expired, lost. Shrink becomes a number by cause.
A reorder list in days of cover, so fast bins are refilled and slow ones aren't overbought.
| The question | Calculator | In TaroStack |
|---|---|---|
| How much is in the bins | Not there | Stock, by the pound |
| What goes out of date next | Not there | Lots, by date |
| What shrink really is | A typed 2% | Counts and adjustments, by reason |
| What to reorder | Walk the bins | The reorder list |
TaroStack connects to Square. It doesn't take payments or run the scale at the counter. Stock, lots and counts 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.
