๐Ÿ“ˆ Product Margin Comparison Tracker

Add each of your products with its cost and selling price to compare profit margin and markup percentage across your whole lineup at a glance.

Three numbers per row

Each product is scored on its own cost and price, then the table is sorted by margin, highest first:

profit = price - cost
margin = profit / price × 100
markup = profit / cost  × 100

The two starting rows show why both percentages are printed:

ProductCostPriceProfitMarginMarkup
A$10$25$1560.0%150.0%
B$20$30$1033.3%50.0%

Same profit column, wildly different percentages: markup divides by cost, margin by price, so markup is always the larger number.

Reading the ranking without being fooled

Margin percentage is an outcome of the price you chose, not a reason for it. Raising a 33% product to 60% on the spreadsheet is easy; keeping the customers afterwards is the part the table cannot model.

Frequently asked questions

What is a good profit margin on a product?

It depends on the trade. Grocery and electronics resale run on thin single-digit margins and survive on volume, while handmade goods and services often need 50% or more to cover slow production. Compare against your own category, not a headline figure.

Should I drop the lowest-margin product?

Not on percentage alone. A low-margin line that sells constantly can pay more of the rent than a high-margin one that moves twice a month, and it may be what brings people in. Check profit per month and per hour of work first.

Why does the results list reorder as I type?

The summary card re-sorts by margin on every keystroke, so the best-margin product holds the top line. The input rows above it stay in the order you entered them.