The price paid to the supplier, without VAT.
The price on the shelf, VAT included.
To see the total margin over a month, for example.
Price excl. VAT = price incl. VAT ÷ (1 + VAT rate). VAT is not yours: it goes to the State, so the margin is worked out without it.
Margin = selling price excl. VAT − purchase price excl. VAT.
Markup = margin ÷ purchase price. Gross margin rate = margin ÷ selling price excl. VAT. The gross margin rate is always lower than the markup.
Multiplier = selling price incl. VAT ÷ purchase price excl. VAT: what to multiply the cost by to get the shelf price.
A bag of rice bought €8.00 excl. VAT and sold €12.66 incl. VAT (5.5 % VAT): €12.00 excl. VAT, margin €4.00, markup 50 %, gross margin rate 33.3 %, multiplier 1.58.
The till, the stock and the purchases work out your margins and prices on their own, product by product. Free account.