How to use
- For each product, type any two values: cost, price, margin % or markup %.
- The other two are solved instantly, along with profit per unit.
- Add rows for more products; totals show overall profit and the weighted average margin and markup.
Worked example: Two products, one weighted margin
Product A costs $50.00 and sells for $80.00. Profit is $30.00, margin is 30 ÷ 80 = 37.5%, markup is 30 ÷ 50 = 60%.
Product B costs $20.00 with a 25% margin. Price = 20 ÷ (1 − 0.25) = $26.67, profit $6.67, markup 33.3%. Across both: revenue $106.67, profit $36.67, average margin 34.4%, which is revenue-weighted, not the simple average of 37.5% and 25%.
Frequently asked questions
What is the difference between margin and markup?
Margin is profit as a share of the selling price. Markup is profit as a share of cost. The same sale has a lower margin than markup: $30 profit on an $80 price is 37.5% margin and 60% markup.
How do I convert markup to margin?
Margin = markup ÷ (1 + markup). A 60% markup is 60 ÷ 160 = 37.5% margin. The reverse: markup = margin ÷ (1 − margin).
How is price found from cost and margin?
Price = cost ÷ (1 − margin ÷ 100). A 100% margin is impossible, so that case is not solved.
Which two values does it use if I fill in three?
The first two you typed. The others turn grey and show the solved value; clear one to type it instead.
How is the average margin calculated?
Total profit ÷ total revenue. It weights products by how much they sell for, which is what a business actually earns.
Can I export the table?
Yes, CSV or Excel with all rows and totals.