Margin and markup, from any two numbers
Fill in any two of cost, price, margin and markup and the rest is worked out. Below that: the price that keeps your margin when a cost goes up, what a discount really costs, and margins for a whole list of items at once. Nothing you type leaves this page.
The numbers already in the boxes are an example. Type over them. The two boxes you typed in last are kept and the other two are filled in.
Keep your margin when a cost goes up
What a discount really costs
Margins for a whole list
Paste three columns from a spreadsheet: item, cost, price. One item on each line.
Want your margins checked every morning?
Costs move and price lists do not. I connect your purchasing and sales systems read-only and send one page each morning with the items whose margin slipped. A free 30-minute look shows what your systems could answer today.
Margin and markup are not the same number
Both start from the same profit: price minus cost. Margin divides that profit by the price. Markup divides it by the cost.
margin = (price − cost) ÷ price markup = (price − cost) ÷ cost
Something that costs $60 and sells for $100 has a 40% margin and a 66.7% markup. Mixing the two up is a common and expensive mistake: marking a $60 cost up by 40% gives a price of $84, which is a margin of only 28.6%.
Why a small discount needs a lot more sales
A discount comes straight out of profit, not out of the price as a whole. At a 40% margin, a 10% discount removes a quarter of the profit on each sale, so you need to sell a third more just to stand still. At a 20% margin, the same discount means selling twice as much.
Questions
How do I get a price from a cost and a target margin?
Divide the cost by one minus the margin. For a 40% margin on a $60 cost: 60 divided by 0.60 is $100. Type the cost and the margin above and the price is filled in.
How much should I raise prices when costs go up?
To keep the same margin percent, raise the price by the same percent as the cost. To keep the same dollars of profit on each sale, raise the price by the dollar amount of the cost increase. The second section above shows the first of these and what happens if you do nothing.
Is anything I type sent anywhere?
No. The arithmetic runs in your browser.
Who made this?
Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools.