What the template includes
- Settings: monthly fixed costs, target margin, VAT rate.
- For 30 products: sales volume, raw materials or purchase cost, labour, packaging, delivery, other variable costs.
- Automatic: variable cost, share of fixed costs, full cost, target price (excl. and incl. VAT), actual margin, markup, monthly profit.
- Products with a margin below target are highlighted in red.
How fixed costs are allocated
The template allocates fixed costs to products in proportion to variable cost × sales volume. This is a simple, easy-to-follow method. If products use fixed resources very differently (for example, one needs special equipment), the allocation should be analysed separately.
Price decisions are not based on full cost alone. In the short term, if the price is above variable cost, a sale helps cover fixed costs. See: break-even calculator.
The difference between margin and markup: explanation and margin calculator.