ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Product costing and pricing
Excel template · Pricing

Product costing and pricing template

Enter each product's variable costs and sales volume: the template allocates fixed costs and calculates full unit cost, the price for your target margin and the actual margin at the current price.

Updated:
Valtera_Cost_and_pricing_EN.xlsx · 14 KB · Sheets: Guide, Costing
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Cost_and_pricing_EN.xlsx — Costing · Preview with sample data
Monthly fixed costs18,000Monthly revenue109,668
Target margin30.0%Monthly profit35,642
VAT rate18.0%Average margin32.5%
ProductMonthly units soldMaterials / purchaseLabourPackagingDeliveryOther variableVariable cost
Office chair1209518653127
Desk6014030894191
Bookcase45701556298
Filing cabinet30160259105209
Meeting table123806015208483
Drawer unit80451033263
Coat stand10018421.50126.50
Office sofa852070202510645

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.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.