Compute Inventory Turnover Ratio from the following information: Revenue from Operations Rs. 2,00,000 Gross Profit Rs. 50,000 Inventory at the end Rs. 60,000 Excess of inventory at the end over inventory in the beginning Rs. 20,000
Cost of Revenue from Operations = Revenue from Operations – Gross Profit = Rs. 2,00,000 – Rs. 50,000 = Rs. 1,50,000
Inventory in the beginning = Inventory at the end – Excess of inventory at the end over inventory in the beginning = Rs. 60,000 – Rs. 20,000 = Rs. 40,000
Average Inventory = (Inventory in the beginning + Inventory at the end) / 2 = (Rs. 40,000 + Rs. 60,000) / 2 = Rs. 50,000
Inventory Turnover Ratio = Cost of Revenue from Operations / Average Inventory = Rs. 1,50,000 / Rs. 50,000 = 3 Times
Explanation
To solve this, we first determine the Cost of Revenue from Operations using the formula 'Revenue from Operations - Gross Profit' found in the context. Next, we calculate the opening inventory by subtracting the given excess from the closing inventory. Then, we find the Average Inventory using the formula '(Inventory in the beginning + Inventory at the end) / 2'. Finally, we apply the Inventory Turnover Ratio formula 'Cost of Revenue from Operations / Average Inventory' as illustrated in the textbook examples.
Solution Steps
Step 1: Calculate Cost of Revenue from Operations (Revenue from Operations - Gross Profit).
Step 2: Determine Inventory in the beginning (Inventory at the end - Excess).
Step 3: Calculate Average Inventory ((Inventory in the beginning + Inventory at the end) / 2).
Step 4: Compute Inventory Turnover Ratio (Cost of Revenue from Operations / Average Inventory).