Calculate Inventory Turnover Ratio from the following information:
| Particulars | Amount (₹) |
|---|---|
| Inventory in the beginning | 76,250 |
| Inventory at the end | 98,500 |
| Sales | 5,20,000 |
| Sales Return | 20,000 |
| Purchases | 3,22,250 |
You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.
Start your 14-day free trial to unlock the full solution →Inventory Turnover Ratio = 3.43 times, calculated as Cost of Revenue from Operations divided by Average Inventory.
Concept First: Why This Ratio Matters
The Inventory Turnover Ratio tells us how efficiently a business sells and replaces its stock. A higher ratio means faster moving inventory — goods are sold quickly, which is generally good for liquidity. A lower ratio might indicate overstocking or slow-moving items.
The formula is:
Inventory Turnover Ratio = Cost of Revenue from Operations / Average Inventory
Cost of Revenue from Operations is simply the cost of goods sold (COGS). We don't get it directly — we must compute it from the given data. The key rule: COGS = Opening Inventory + Purchases – Closing Inventory. Sales and Sales Returns are used to check if we need to adjust for gross profit, but here we have Purchases, so we can compute COGS directly.
Average Inventory is the simple average of opening and closing inventory: (Opening + Closing) / 2.
Step-by-Step Solution
Step 1: Compute Cost of Revenue from Operations (COGS)
We have:
- Opening Inventory = ₹76,250
- Purchases = ₹3,22,250
- Closing Inventory = ₹98,500
COGS = Opening Inventory + Purchases – Closing Inventory
= 76,250 + 3,22,250 – 98,500
= 3,98,500 – 98,500
= ₹3,00,000
Sales (₹5,20,000) and Sales Returns (₹20,000) give Net Sales = ₹5,00,000. But we don't need them for COGS because we have Purchases. If Purchases were missing, we'd use Net Sales – Gross Profit. Here, it's a direct calculation.
Step 2: Compute Average Inventory
Average Inventory = (Opening Inventory + Closing Inventory) / 2
= (76,250 + 98,500) / 2
= 1,74,750 / 2
= ₹87,375
Step 3: Compute Inventory Turnover Ratio
Inventory Turnover Ratio = COGS / Average Inventory
= 3,00,000 / 87,375
Let's do the division carefully:
87,375 × 3 = 2,62,125
Remainder = 3,00,000 – 2,62,125 = 37,875
Now 37,875 / 87,375 = 0.4335... (approx)
So the ratio = 3.4335... times
Rounding to two decimal places: 3.43 times …
Unlock everything free for 14 days
- Full step-by-step solutions
- Concept-first explanations
- Methods, shortcuts & mistakes
- PYQ mapping + timed mock tests
Full access for 14 days. No credit card required.