To price a convenience store item, work out what one unit costs from the case, divide it by one minus the category's target margin, and round up to a price ending in 9. Price = unit cost ÷ (1 − target margin). A case of 24 colas at $27.60 is $1.15 a bottle; at a 52% target, $1.15 ÷ 0.48 = $2.40, so $2.49. That's the floor. Then check it against the price printed on the pack, if there is one, and what the store down the street charges, and decide. In the example below, a Memphis store prices eleven items and ends up with a 58% margin across a week's sales of them. Below is the formula, target margins and markups by category, the eleven items, and a free calculator.
The short version
- Unit cost = case cost ÷ units in the case.
- Price at target = unit cost ÷ (1 − target margin), rounded up to end in 9.
- Set a target margin for each category: high for coffee and drinks, low for milk and eggs.
- A price printed on the pack by the maker is the price customers expect.
- Check the store down the street: the formula is the floor, the market is the ceiling.
- Keep staples near the target; they're why people stop in.
- Reprice when a vendor's cost goes up.
- TaroStack shows margin by product on what each delivery cost, and flags a vendor's rising prices. More below.
The formula
| Step | Formula | Cola, 20 oz |
|---|---|---|
| Unit cost | Case cost ÷ units in the case | $27.60 ÷ 24 = $1.15 |
| Price at target | Unit cost ÷ (1 − target margin) | $1.15 ÷ 0.48 = $2.40 |
| Round up to end in 9 | The next price ending in 9 | $2.49 |
| Margin | (Price − unit cost) ÷ price | 53.8% |
| Markup | (Price − unit cost) ÷ unit cost | 116.5% |
Margin is a share of the price; markup is a share of the cost. A 50% margin is a 100% markup, which is why a vendor's "double it" and a 50% margin are the same thing. The difference is in markup vs margin, and pricing from cost in general in cost plus pricing example.
Target margins and markups by category
| Category | Target margin | Same as a markup of |
|---|---|---|
| Coffee bar | 75% | 300% |
| Beverages | 52% | 108% |
| Snacks and candy | 50% | 100% |
| Local products | 45% | 82% |
| Bakery and household | 40% | 67% |
| Dairy and eggs | 30% | 43% |
These are the example store's targets, not rules. Milk and eggs carry a low margin because people compare their price and come in for them; the coffee bar carries a high one because the cup costs little and the price is set by what a cup costs elsewhere.
An example: eleven items at a Memphis store
Bluff City Market, a made-up convenience store in Memphis, Tennessee, I use in these examples, prices these items:
| Item | Case cost ÷ pack | Unit cost | At target, rounded | Printed | Competitor | Its price | Margin | Sold a week |
|---|---|---|---|---|---|---|---|---|
| Cola, 20 oz | $27.60 ÷ 24 | $1.15 | $2.49 | $2.49 | $2.49 | 53.8% | 60 | |
| Water, 16.9 oz | $4.32 ÷ 24 | $0.18 | $0.39 | $1.29 | $1.29 | 86.0% | 90 | |
| Energy drink, 8.4 oz | $34.80 ÷ 24 | $1.45 | $3.09 | $3.29 | $3.29 | 55.9% | 40 | |
| Potato chips, 2.6 oz | $60.80 ÷ 64 | $0.95 | $1.99 | $2.19 | $2.19 | $2.19 | 56.6% | 50 |
| Chocolate bar | $30.60 ÷ 36 | $0.85 | $1.79 | $1.99 | $1.99 | 57.3% | 45 | |
| Whole milk, gallon | $12.40 ÷ 4 | $3.10 | $4.49 | $4.59 | $4.49 | 31.0% | 30 | |
| Eggs, dozen | $33.00 ÷ 15 | $2.20 | $3.19 | $3.49 | $3.19 | 31.0% | 15 | |
| White bread, loaf | $21.00 ÷ 12 | $1.75 | $2.99 | $3.29 | $2.99 | 41.5% | 18 | |
| Coffee, 12 oz cup | cup, lid, coffee, milk | $0.42 | $1.69 | $1.99 | $1.89 | 77.8% | 120 | |
| Paper towels, 2 rolls | $19.20 ÷ 12 | $1.60 | $2.69 | $2.99 | $2.69 | 40.5% | 10 | |
| Memphis hot sauce, 5 oz | $54.00 ÷ 12 | $4.50 | $8.19 | $8.99 | 49.9% | 3 |
A week of these eleven sells $1,113.19 and keeps $646.84, 58.1%. Five decisions moved prices off the formula. Water at the formula would be 39¢, and every store nearby sells it for $1.29, so it's $1.29: the formula is a floor, not a price. The energy drink and the chocolate bar go to the competitor's price, because $3.09 and $1.79 give away margin nobody asked for, and the coffee goes to $1.89, ten cents under the competitor's cup. Milk, eggs and bread stay at the formula, below the competitor, because they're what brings someone in for the drink and the snack. The chips have a price printed on the bag, $2.19, so that's the price. The hot sauce from a Memphis maker sells at the maker's suggested $8.99.
When costs change
A vendor's price goes up a few cents on one invoice and the shelf price stays the same, so the margin shrinks without anyone deciding it should. Compare each invoice's cost with the last one, and reprice the item when its margin falls below the category's target. A sheet for watching what vendors charge is in supplier price tracking template, and a price list to keep the store's prices in one place in price list template.
Get the calculator
Download the convenience store pricing calculator. Three sheets: target margins by category; prices, where you type each item's category, case cost and case pack and the unit cost, the price at the target and that price rounded up to end in 9 fill in, then the printed price, the competitor's price, your price and how many sell a week, with the margin, markup, sales and gross profit filling in; and a week's sales and gross profit across the items. A rounded price above the competitor's turns red. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Eleven items price easily. Three thousand don't, and each vendor's invoice changes a few of their costs every month. A calculator holds the cost you typed last time; it can't say which items' margins slipped when the soda route's prices went up, or what an item cost on the delivery that's on the shelf now.
How TaroStack does it
TaroStack shows margin by product on what each delivery cost, and flags a vendor's rising prices.
Margins on real costs. Each delivery is received at what it cost, so margins by product use what the item actually cost, not last year's number.
Rising prices flagged. A price-creep report by supplier shows which vendor's prices are going up, so the items to reprice are on a list instead of discovered at the end of the month. A photo of a vendor's invoice is read into rows to check before anything is saved.
Losses with a reason. Every adjustment carries its reason, expired, damaged or lost, so the shrink that eats into a category's margin is reported by reason and item, not hidden in the month's total.
| The job | Calculator | In TaroStack |
|---|---|---|
| Unit cost | Typed from the last invoice | From each delivery received |
| A vendor's price going up | Unnoticed | Price-creep report by supplier |
| An invoice | Typed in | A photo read into rows |
| Margin by item | Your typed numbers | Reported on actual cost |
| Shrink in a category | Not on the sheet | By reason and item |
Margin reports, price-creep by supplier and receiving are on every plan, from $49 a month, with no limit on items; TaroStack connects to Square. 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.
