User Tools

Site Tools


faq:price_code_calculations_how_does_the_markup_calculation_work_margin_retail_tab

This is an old revision of the document!


How do the calculations on the retail tab work

Markup Calculations

A markup calculation is a calculation that does its math from “the bottom up”. This means that it refers to the dollar value increase as a percentage of cost. The 2 codes that use the markup calculation style are W and L. The cost used is different for each one. W uses base cost, and L uses actual costs otherwize known as the landed cost.

Calculation

COST + (COST x (Percentage))

Example 1

  • Where COST = 100
  • Where Markup Percentage = 100
COST + (COST x (Markup Percentage)) =
100 + (100 x 100%) =
100 + (100 x 1) = 
100 + (100) =
200

Example 2

  • Where COST = 100
  • Where Markup Percentage = 150
COST + (COST x (Markup Percentage)) =
100 + (100 x 150%) =
100 + (100 x 1.5) = 
100 + (150) =
250

Explenation

The 100% markup scenario is a great example because most retailers know that a 100% markup is double the price. You can think of the calculation of markup as a way to compare the cost to the increase in terms of a percentage.

A common mistake in the calculation can happen if you are used to thinking about things in terms of percentage of cost. if I have a cost of $100 and a price of $300 it is intuative to say that the price is cost x 300%. The problem with that is that the markup is only 200%. Test it using the formula above. Please look at our price code X for this type of calculation.

Margin Calculations

A margin calculation is a calculation that does its math from “the top down”. This means that it refers to the dollar value increase as a percentage of retail. The 2 codes that use the margin calculation style are H and M. The cost used is different for each one. H uses base cost, and M uses actual costs otherwize known as the landed cost.

Calculation

Gross margin = (Revenue - Cost of goods sold) / Revenue

Example 1

  • Where COST = 100
  • Where Margin Percentage = 50
Gross margin = (Revenue - Cost of goods sold) / Revenue

100 / (50%)
100 / (.5)
200

Example 2

  • Where COST = 100
  • Where Margin Percentage = 40
retail = cost /(margin percentage)

100 / (40%)
100 / (.4)
250
faq/price_code_calculations_how_does_the_markup_calculation_work_margin_retail_tab.1314912250.txt.gz · Last modified: 2011/09/01 14:24 (13 years ago) by tanya