How to calculate gross profit per product, with the formulas

· 7 min read

The formula for gross profit per product is simple: the selling price minus the cost of that product. If ground coffee sells for Rp 45,000 and costs Rp 30,000, the gross profit is Rp 45,000 - Rp 30,000 = Rp 15,000 per pack. The hard part isn't the formula; it's knowing the right cost when your supplier's prices keep changing. In this article we cover both, with numbers from one shop.

Why you need to know gross profit per product

High turnover doesn't necessarily mean profit. Your best seller may be the one with the thinnest profit, and something that rarely sells may be your biggest earner. If you only look at total sales, you can't tell the difference.

Gross profit per product helps you make practical decisions: which items to stock more of, which need a higher selling price, and which are better dropped. Decisions like these are too important to make on gut feeling.

The formulas for gross profit and margin

Gross profit per item equals the selling price minus the cost per item. Total gross profit for one product over a period equals gross profit per item times the number sold. Or, another way that gives the same result: total sales of that product minus the total cost of the units sold.

Margin is gross profit divided by the selling price, times 100%. It shows what percentage of every rupiah of sales becomes gross profit. For the coffee above, margin = Rp 15,000 ÷ Rp 45,000 x 100% = 33.3%.

Don't confuse it with markup

Markup is calculated on cost, not on the selling price. For the same coffee, markup = Rp 15,000 ÷ Rp 30,000 x 100% = 50%. So "50% profit on cost" and "a 33.3% margin" are the same thing seen from two sides. Make sure you know which one is being discussed, especially when comparing with other sellers or setting prices.

The hard part: a cost that keeps changing

Costs are rarely fixed. Last month you bought coffee at Rp 28,000 a pack; this month the supplier raised the price. Stock from those two purchases sits mixed on the same shelf, so which cost applies when one pack is sold?

One common method is weighted average cost. Here's how it works: each time there's a new purchase, add the value of the stock you still have to the value of the new purchase, then divide by the number of items after the purchase. The result becomes the cost per item for every sale that follows, until another purchase changes the average.

It's called weighted because larger purchases have more influence on the average. Buying 14 packs at the new price shifts the average much further than buying 2.

A full example: ground coffee at Toko Kopi Mekar

Toko Kopi Mekar sells ground coffee at Rp 45,000 a pack. Let's follow one month.

Start of the month: the first stock

The shop buys 10 packs at Rp 28,000. Stock is worth 10 x Rp 28,000 = Rp 280,000, an average cost of Rp 28,000 a pack.

The first sales

4 packs are sold. Sales are 4 x Rp 45,000 = Rp 180,000. The cost of goods sold is 4 x Rp 28,000 = Rp 112,000. Gross profit is Rp 180,000 - Rp 112,000 = Rp 68,000, a margin of Rp 68,000 ÷ Rp 180,000 x 100% = 37.8%.

6 packs remain, worth 6 x Rp 28,000 = Rp 168,000.

A second purchase at the new price

The supplier raises the price, and the shop buys 14 packs at Rp 33,000. The purchase is worth 14 x Rp 33,000 = Rp 462,000. Stock is now 6 + 14 = 20 packs, worth Rp 168,000 + Rp 462,000 = Rp 630,000. The new average cost is Rp 630,000 ÷ 20 = Rp 31,500 a pack.

The second sales

10 packs are sold at the same price, Rp 45,000. Sales are 10 x Rp 45,000 = Rp 450,000. The cost of goods sold is 10 x Rp 31,500 = Rp 315,000. Gross profit is Rp 450,000 - Rp 315,000 = Rp 135,000, a margin of Rp 135,000 ÷ Rp 450,000 x 100% = 30%.

The month's result

In total 14 packs were sold, with sales of Rp 180,000 + Rp 450,000 = Rp 630,000. Total cost of goods sold is Rp 112,000 + Rp 315,000 = Rp 427,000. Gross profit for the month is Rp 630,000 - Rp 427,000 = Rp 203,000, a margin of about 32.2%. 10 packs remain, worth 10 x Rp 31,500 = Rp 315,000.

Cross-check: money spent was Rp 280,000 + Rp 462,000 = Rp 742,000. The cost of what was sold, Rp 427,000, plus the value of the remaining stock, Rp 315,000, is also Rp 742,000. It matches, so no cost has gone missing from the sums.

The lesson: the selling price didn't change, yet the margin fell from 37.8% to 30% simply because the purchase price rose. If the shop had kept using the old cost of Rp 28,000, the profit on the second sales would have been recorded as Rp 170,000, when it was really Rp 135,000. That Rp 35,000 difference is profit that exists only on paper.

Comparing several products

Now compare three products in the same shop over a month.

Granulated sugar, 1 kg, sells at Rp 18,000 with an average cost of Rp 16,500. Gross profit is Rp 1,500 a pack, a margin of 8.3%. 200 packs were sold, so sales were Rp 3,600,000 and gross profit 200 x Rp 1,500 = Rp 300,000.

Ground coffee, as in the example above, brought in sales of Rp 630,000 and gross profit of Rp 203,000 from just 14 packs.

Tea bags sell at Rp 12,000 a box with a cost of Rp 7,200. Gross profit is Rp 4,800 a box, a margin of 40%. 30 boxes were sold, so sales were Rp 360,000 and gross profit 30 x Rp 4,800 = Rp 144,000.

Sugar brings in the most sales and the most gross profit, but its thin margin leaves the shop exposed: if the cost of sugar rises by just Rp 1,500 and the selling price isn't adjusted, the profit is gone. Tea bags sell rarely but have a thick margin, so they deserve a more visible spot.

Gross profit is not net profit

Gross profit doesn't yet subtract operating costs: rent, wages, electricity, shipping you cover, and marketplace fees. Gross profit answers "which products make money", while net profit answers "is my business making money or not".

You need both. But for deciding which products to stock more of, reprice, or stop selling, gross profit per product is the right tool.

Three decisions from these numbers

A product that sells well but has a thin margin: check whether the selling price can go up a little, or look for a supplier with a better price.

A product with a thick margin that rarely sells: make it stand out. Put it at the front, offer it when buyers ask in chat, or bundle it with a best seller.

A product with a negative margin: usually because the cost went up and the selling price wasn't adjusted. Fix it today.

Calculating gross profit automatically in Tekomata

Working out a weighted average by hand after every purchase is tiring, especially with hundreds of products. In Tekomata, stock is recorded at weighted average cost, so every purchase updates the cost per item without you calculating it yourself.

Every sales invoice shows its gross profit on that invoice's page, calculated from the average cost at the moment the goods leave stock. A gross profit report by product and by period, such as this month, last month or this year, is available from the Gold plan up, so you can see at a glance which products earn the most and which need attention.