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 listMarkup€0.735 cost sells at
Retail (shop)40%€1.03
Restaurant25%€0.92
Wholesale10%€0.81
One unit cost feeds every price list through its own markup.

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.