Advertisements
Advertisements
Question
From the following information calculate inventory turnover ratio; Revenue from operations Rs.16,00,000; Average Inventory Rs.2,20,000; Gross Loss Ratio 5%.
Solution
`"Inventory Turnover Ratio" = "Cost of Revenue from Operations"/"Average Inventory"`
`"Gross Loss Ratio"="Gross Loss"/"Revenue from Operations"`
`5%="Gross Loss"/(16,00,000)=>"Gross Loss"=5%"of "16,00,000 = 80,000`
Cost of Revenue from Operations = Revenue from Operations + Gross Loss
= 16,00,000 + 80,000 = 16,80,000
`"Inventory Turnover Ratio"=(16,80,000)/(2,20,000)=7.64 " Times"`
APPEARS IN
RELATED QUESTIONS
What is meant by 'Activity Ratios'?
From the following information obtained from the books of Kundan Ltd., calculate the inventory turnover ratio for the years 2015-16 and 2016-17 :
| 2015-16 (Rs) | 2016-17(Rs) | |
| Inventory on 31st March | 7,00,000 | 17,00,000 |
| Revenue from operations | 50,00,000 | 75,00,000 |
(Gross profit is 25% on the cost of revenue from operations)
In the year 2015-16, inventory increased by Rs 2,00,000.
The Quick Ratio of a company is 0.8:1. State whether the Quick Ratio will improve, decline or will not change in the
following cases:
(i) Cash collected from Debtors Rs. 50,000.
(ii) Creditors of Rs. 20,000 paid off.
Choose the appropriate alternative from the given options:
Which of the following is not an activity ratio?
| Inventory in the beginning | ₹ 30,000 |
| Inventory at the end | ₹ 50,000 |
| Net Purchases | ₹ 5,00,000 |
| Wages | ₹ 25,000 |
| Salaries | ₹ 40,000 |
| Revenue from operations | ₹ 8,00,000 |
| Carriage Inwards | ₹ 5,000 |
| Returns Outwards | ₹ 30,000 |
Calculate Inventory Turnover Ratio
Calculate Revenue from operations of BN Ltd. From the following information:
| Current assets | ₹ 8,00,000. |
| Quick ratio is | 1.5: 1 |
| Current ratio is | 2: 1 |
| Inventory turnover ratio is | 6 times. |
Goods were sold at a profit of 25% on cost.
Interest on Loans given by a financial company is shown in the Statement of Profit and Loss as ______.
Cost of goods sold =____.
The 'Inventory Turnover Ratio' from the following information will be:
| (₹) | |
| Revenue from Operations | 12,00,000 |
| Average Inventory | 2,00,000 |
| Gross loss ratio | 20% |
If revenue from operations is ₹ 9,00,000; gross profit is 25% on cost and operating expenses are ₹ 90,000 the operating ratio will be:
From the following information, calculate the value of opening and closing inventory:
Inventory Turnover Ratio - 4 times.
Gross Profit = 20% on Revenue from Operations.
Revenue from Operations = ₹ 10,00,000.
Opening inventory is 25% of the inventory at the end.
The spreadsheet below shows the sales of Jupiter Ltd. made by four salesmen in the four quarters of the financial year 2022-23:
| A | B | C | D | E | F | G | |
| 1 | Sales in ₹ | ||||||
| 2 | Salesman No. | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | Total Sales | Commission @ 10% of sales (₹) |
| 3 | S1 | 6,000 | 7,000 | ?? | 9,000 | ||
| 4 | S2 | 8,000 | 9,000 | 8,200 | 8,500 | 33,700 | |
| 5 | S3 | 9,600 | 8,400 | 9,200 | 9,500 | 36,700 | ?? |
| 6 | S4 | ?? | 7,600 | 8,000 | 12,000 | ||
| 7 | Total | ||||||
Based on the above transactions and the information given in the spreadsheet, answer the following question:
- Write the formula to calculate the cost of the goods sold by Salesman No. S2 in Qtr 2, if he had sold the goods at a profit of 10% of the sales.
- Write the formula to calculate the sales made by Salesman No. S2 in Qtr 3 in cell D3, if he had sold the goods at a profit of 10% of the cost.
- In Qtr 1, Salesman No. S4 sold goods costing ₹ 8,800 at a loss of 10% of the sales. What is the selling price of the goods in cell B6.
- The company gives a commission of 10% on its total sales. Write the formula to calculate the commission earned by Salesman No. S3 in cell G5.
