Advertisements
Advertisements
प्रश्न
Calculate Inventory Turnover Ratio for the year 2021-22 and 2022-23 from the following information:
| 2021-22 ₹ |
2022-23 ₹ |
|
| Inventory on 31st March | 11,00,000 | 15,00,000 |
| Revenue from Operations | 75,00,000 | 93,60,000 |
(Gross Profit is 20% on cost of revenue from Operations)
In the year 2021-22 inventory decreased by ₹ 3,00,000
Advertisements
उत्तर
Inventory Turnover Ratio = `"Cost of Revenue from Operations"/"Average Inventory"`
Year 2021-22:
Gross Profit is 20% on cost. Hence, goods costing ₹ 100 are sold for ₹ 120.
If Revenue from Operations is ₹ 75,00,000
Cost of Revenue from Operations = `75,00,000 xx 100/120`
= ₹ 62,50,000
Closing Inventory = ₹ 11,00,000
Opening Inventory = ₹ 11,00,000 + ₹ 3,00,000
= ₹ 14,00,000
Average Inventory = `("Opening Inventory + Closing Inventory")/2`
= `(₹ 14,00,000 + ₹ 11,00,000)/2`
= `(₹ 25,00,000)/2`
= ₹ 12,50,000
Inventory Turnover Ratio = `(₹ 62,50,000)/(₹ 12,50,000)`
= 5 times
2022-23:
Gross Profit is 20% on cost. Hence, goods costing ₹ 100 are sold for ₹ 120.
If Revenue from Operations is ₹ 93,60,000
Cost of Revenue from Operations = `₹ 93,60,000 xx 100/120`
= ₹ 78,00,000
Closing Inventory = ₹ 15,00,000
Opening Inventory = ₹ 11,00,000
Average Inventory = `("Opening Inventory + Closing Inventory")/2`
= `(₹ 11,00,000 + ₹ 15,00,000)/2`
= `(₹ 26,00,000)/2`
= ₹ 13,00,000
Inventory Turnover Ratio = `(₹ 78,00,000)/(₹ 13,00,000)`
= 6 times
