Skip to content
Faidah

Cost of goods sold and inventory turnover

Find the cost of what you sold, your gross profit, and how fast your stock turns.

Period
SAR
SAR
SAR

Net of returns and discounts, plus freight to bring the goods in.

SAR

Result

Cost of goods sold

210,000.00SAR

Gross profit
90,000.00 SAR
Gross margin
30%
Average inventory
45,000.00
Inventory turnover
4.67 times
Days in inventory
78 days

Results are estimates for guidance. Check important figures with your accountant.

How it is calculated

Cost of goods sold = opening inventory + purchases − closing inventory.

Average inventory = (opening + closing) ÷ 2. Inventory turnover = cost of goods sold ÷ average inventory.

Days in inventory = days in the period ÷ turnover: roughly how long an item stays in stock before it is sold.

Worked example

A shop starts the year with SAR 50,000 of stock, buys SAR 200,000 and ends with SAR 40,000. Cost of goods sold is SAR 210,000. With sales of SAR 300,000, gross profit is SAR 90,000 (30%). Average stock is SAR 45,000, so stock turns about 4.7 times a year, or every 78 days.

Questions

What goes into purchases?

The cost of goods bought for resale in the period, net of returns and discounts, plus freight and other costs to bring them in.

Is a higher inventory turnover always better?

It usually means less cash tied up in stock, but very high turnover can mean running out. Compare it with your own past periods and with similar businesses.

Should I enter amounts with VAT?

No. If your business is registered for VAT, use amounts before VAT.

COGS and inventory turnover calculator | Faidah