Handled by Morning Book a free look

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.

This sends your email address and nothing else. Nothing you put into the tool is sent.

Book a free look

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.