Retail, wholesale and restaurant prices from one cost, in one sheet
One cost per product, one markup per customer type. Change the cost and every price list follows.
· 4 min read
A business that sells to the public, to other shops and to restaurants has several prices for every product. Kept in separate files, they drift apart: the retail list gets the new cost, the restaurant list doesn't, and someone sells below cost without knowing.
One cost, many prices
Build every price from the same unit cost — including transport — with one markup column per kind of customer:
| Price list | Markup | €0.735 cost sells at |
|---|---|---|
| Retail (shop) | 40% | €1.03 |
| Restaurant | 25% | €0.92 |
| Wholesale | 10% | €0.81 |
Prices here are before VAT. Keep VAT in its own column, because the rate depends on the product. And choose each markup for the margin you need — a 40% markup is not a 40% margin, see markup vs margin.
How SAMZY does it
A Smart Sheet works like Excel, with your own columns and formulas, and SAMZY keeps them connected. Change a cost and every price list updates. Type a new restaurant price and its markup updates to match. When the next invoice comes in, your template prices it for every customer at once.
Questions
- How do I manage several price lists in one spreadsheet?
- Keep one unit cost per product and one markup column per price list. Each selling price is a formula: cost × (1 + markup).
- Should prices include VAT?
- Keep prices before VAT and add VAT in its own column, because different products can have different VAT rates.
