Question

Calculate Inventory Turnover Ratio from the following information:

Opening Inventory ₹ 40,000; Purchases ₹ 3,20,000; and Closing Inventory ₹ 1,20,000.
State, giving reason, which of the following transactions would (i) increase, (ii) decrease, (iii) neither increase nor decrease the Inventory Turnover Ratio:
(a) Sale of goods for ₹ 40,000 (Cost ₹ 32,000).
(b) increase in the value of Closing Inventory by ₹ 40,000.
(c) Goods purchased for ₹ 80,000.
(d) Purchases Return ₹ 20,000.
(e) goods costing ₹ 10,000 withdrawn for personal use.
(f) Goods costing ₹ 20,000 distributed as free samples.

Answer 1

Cost of Goods Sold = Opening Stock + Purchases + Closing Stock

= 40,000 + 3,20,000 − 1,20,000 = 2,40,000

Average Stock = `("Opening Stock + Closing Stock")/2`

`= (40000 + 120000)/2 = 80000`

Stock turnover Ratio = `240000/80000 = 3` times

(a) Sale of goods for Rs 40,000 (Cost Rs 32,000)- Increase

Reason: This transaction will decrease stock at the end (closing stock). Decrease in closing stock will result increase the proportion of Cost of Goods Sold and decrease in Average Stock

(b) Increase in value of Closing Stock by 40,000- Decrease

Reason: Increase in Closing Stock results decrease in Cost of Goods Sold and increase in Average Stock.

(c) Goods purchased for Rs 80,000- Decrease

Reason: This Transaction increases the amount of Closing Stock. Increase in Closing Stock reduces the proportion of Cost of Goods Sold and Increase in Average Stock.

(d) Purchase Return Rs 20,000- Increase

Reason: It will result decrease in Cost of Goods Sold and Average Stock with same amount.

(e) Goods costing Rs 10,000 withdrawn for personal use- Increase

Reason: Drawing of goods will decrease the amount of Closing Stock and increase in Cost of Goods Sold.

(f) Goods costing Rs 20,000 distributed as free sample- Increase

Reason: Goods distributed as free sample reduces Closing Stock. Reduction in Closing Stock will result increase in Cost of Goods Sold and decrease in Average Stock.