Cost of goods sold and inventory turnover
Find the cost of what you sold, your gross profit, and how fast your stock turns.
Net of returns and discounts, plus freight to bring the goods in.
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.