To set the selling price of an organic dried fruit, three figures are enough: the purchase price excl. VAT, the 5.5% VAT rate and the target markup rate on selling price. Rotation then tells you whether the reference deserves its place on the shelf.
The four formulas to know
- Selling price excl. VAT = selling price incl. VAT ÷ 1.055 (reduced 5.5% VAT rate on food in France).
- Gross margin = selling price excl. VAT − purchase price excl. VAT.
- Margin rate on selling price = gross margin ÷ selling price excl. VAT. This is the percentage commonly called "margin" in shops.
- Multiplier = selling price incl. VAT ÷ purchase price excl. VAT. It lets you set a price with a single multiplication.
Worked example
A 100 g bag of organic dried banana bought at €1.75 excl. VAT and sold at €3.49 incl. VAT:
| Selling price excl. VAT | 3.49 ÷ 1.055 = €3.31 |
| Gross margin | 3.31 − 1.75 = €1.56 |
| Margin rate on selling price | 1.56 ÷ 3.31 = 47% |
| Multiplier | 3.49 ÷ 1.75 = 1.99 |
Be careful not to confuse margin on selling price with markup on cost: the latter is calculated on the purchase price (1.56 ÷ 1.75 = 89%). Comparing two suppliers requires using the same indicator.
Rotation: how long a product stays on the shelf
- Stock cover (in weeks) = stock in units ÷ average sales per week. With a carton of 10 bags and 5 sales a week, the carton covers 2 weeks.
- Rule of prudence: stock cover must remain well below the time left before the best-before date, so that you never have to sell off stock.
- Margin per week = unit margin × sales per week. A reference with a €1.56 margin sold 5 times a week brings in €7.80 a week; this is the figure that compares references with each other, not the margin rate alone.
Deciding on a reference in 4 weeks
- List 1 carton per product tested.
- Record sales every week.
- After 4 weeks, rank the references by margin per week.
- Restock the best ones and replace the weakest with a new product.
Prices for the BioGoût retail shelf range
The 11 100 g kraft bags in the retail shelf range come with a recommended retail price that leaves a 47 to 48% margin on selling price, i.e. a multiplier of about 2. Discounts of 5% from 5 cartons of the same reference and 8% from 10 cartons. Create your professional account to see prices.