Margin Calculations
Margin calculations are presented in two ways:
Basic margin calculations: These are based on the general sell price of the item and the target margin (either the account default or product-overriden value). Note that any bulk pricing brackets are essentially ignored for this calculation.
Per-site margin calculations: These are based on the price that the item sells for on that site. The price on that site may be different from the base sell price of the product either as a result of site pricing override or a pricing scheme being in effect on that site. If target margin has been overriden for that site (in the Site settings) then that will be used, otherwise the product/account default will be used.
Here’s an outline of what each of the margin calculation metrics means:
Total Variable Costs
The sum of all the calculations specified by the variable cost matrix.
Total Unit Cost
The total variable costs added to the purchase price in the base currency of the product.
Unit Profit
The difference between the selling price and the total unit cost.
Gross Margin
The percentage of the sell price that corresponds to profit.
Gross Markup
Another way of thinking about margin that some prefer. This is the ratio of sell price to unit cost expressed as a percentage.
Gross Markup Multiplier
An alternative way of expressing markup that some prefer. Instead of a percentage, this is simply a multiplier.
Target Margin
A record of the target margin used (either from the account default or product override or website override).
Target Price
The price you would have to sell the product at in order to achieve the target margin with all variable costs factored in.
Margin Classification
Either 'losing money', 'below target', or 'above target', indicating the profitability status based on the margin.
Example Calculation
Purchase a product for £2
Total variable costs of £1
Sell the product for £9
Total unit cost is £3
Unit profit is £6
Gross margin is 66%
Markup multiplier is 3
Markup percentage is 200%
If target margin is 100%, target price is £6
Therefore the margin classification is ‘above target’
When are margin calculations updated?
Margin calculations for products are updated in the following circumstances:
You edit a product: that product's margin calculations are updated
You add a new exchange rate / edit an existing exchange rate: products who have a preferred supplier with the affected currency have their margin calculations updated
You change margin calculation defaults at account level: all products' margin calculations are updated
You change target margin override on a website: products that are active on that website have their margin calculations updated
What about composites?
The purchase price used in the margin calculations is the sum of the purchase price in base currency of the composite members in the correct proportions.
All other variable costs are derived in exactly the same way as for normal products, using the variable cost matrix. i.e. the system does not attempt to 'combine' or 'add' variable costs from the composite members.
Last updated