English

Calculate Inventory Turnover Ratio from the Following: - Accountancy

Advertisements
Advertisements

Question

Calculate Inventory Turnover Ratio from the following:

 
Opening Inventory 29,000
Closing Inventory 31,000
Revenue from Operations, i.e., Sales 3,20,000
Gross Profit Ratio 25%
Sum

Solution

Sales = 3,20,000

Gross Profit = 25% on Sales

∴ Gross Profit = `320000 xx 25/100 = 80000`

Cost of Goods Sold = Total Sales − Gross Profit

= 3,20,000 − 80,000 = 2,40,000

Average Inventory

= `("Opening Inventory + Closing Inventory")/2`

`=(29000 + 31000)/2 = 30000`

Inventory Turnover Ratio=`"Cost of goods Sold"/"Average Inventory"`

`= 240000/30000` = 8 times 

shaalaa.com
Types of Ratios
  Is there an error in this question or solution?
Chapter 3: Accounting Ratios - Exercises [Page 99]

APPEARS IN

TS Grewal Accountancy - Analysis of Financial Statements [English] Class 12
Chapter 3 Accounting Ratios
Exercises | Q 64 | Page 99

RELATED QUESTIONS

From the following, calculate (a) Debt Equity Ratio (b) Total Assets to Debt Ratio (c) Proprietary Ratio.

  Rs.
Equity Share Capital 75,000
Preference Share Capital 25,000
General Reserve 45,000
Balance in the Statement of Profits and Loss 30,000
Debentures 75,000
Trade Payables 40,000
Outstanding Expenses 10,000

Current Liablilites of a company were ₹1,75,000 and its Current Ratio was 2:1. It paid ₹30,000 to a Creditor. Calculate Current Ratio after payment.


From the following calculate: (i) Current Ratio; and (ii) Quick Ratio:

 
Total Debt 6,00,000 Long-term Borrowings 2,00,000
Total Assets 8,00,000 Long-term Provisions 2,00,000
Fixed Assests (Tangible) 3,00,000 Inventories 95,000
Non-current Investment 50,000 Prepaid Expenses 5,000
Long-term Loans and Advances 50,000    

From the following information, calculate Total Assets to Debt Ratio:

     
Fixed Assets (Gross) 6,00,000   Accumulated Depreciation 1,00,000
Non-current Investments 10,000   Long-term Loans and Advances 40,000
Current Assets 2,50,000   Current Liabilities 2,00,000
Long-term Borrowings 3,00,000   Long-term Provisions 1,00,000

From the following information, calculate Inventory Turnover Ratio:

 
Revenue from Operations 16,00,000
Average Inventory 2,20,000
Gross Loss Ratio 5%  

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.


From the following Information, calculate Inventory Turnover Ratio:
Credit Revenue from Operations ₹ 3,00,000; Cash Revenue from Operations ₹ 1,00,000, Gross Profit 25% of Cost, Closing Inventory was 3 times the Opening Inventory. Opening Inventory was 10% of Cost of Revenue from Operations.


Credit Revenue from Operations, i.e., Net Credit Sales for the year 1,20,000
Debtors 12,000
Billls Receivable 8,000

Calculate Trade Receivables Turnover Ratio.


From the following information, calculate Gross Profit Ratio:

     
Credit Sales 5,00,000   Decrease in Inventory 10,000
Purchases 3,00,000   Returns Outward 10,000
Carriage Inwards 10,000   Wages 50,000
      Rate of Credit Sale to Cash Sale 4:1

Calculate Cost of Revenue from Operations from the following information:
Revenue from Operations ₹ 12,00,000; Operating Ratio 75%; Operating Expenses ₹ 1,00,000.


What will be the Operating Profit Ratio, if Operating Ratio is 82.59%?


Cash Sales ₹ 2,20,000; Credit Sales ₹ 3,00,000; Sales Return ₹ 20,000; Gross Profit ₹ 1,00,000; Operating Expenses ₹ 25,000; Non-operating incomes ₹ 30,000; Non-operating Expenses ₹ 5,000. Calculate Net Profit Ratio.


Revenue from Operations, i.e., Net Sales ₹ 8,20,000; Return ₹ 10,000; Cost of Revenue from Operations (Cost of Goods Sold) ₹ 5,20,000; Operating Expenses ₹ 2,09,000; Interest on Debentures ₹ 40,500; Gain (Profit) on Sale of a Fixed Asset ₹ 81,000. Calculate Net Profit Ratio. 


From the following calculate:

(a) Current Ratio; and 
(b) Working Capital Turnover Ratio.
   
(i) Revenue from Operations 1,50,000
(ii) Total Assets 1,00,000
(iii) Shareholders' Funds 60,000
(iv) Non-current Liabilities 20,000
(v) Non-current Assets 50,000

Calculate following ratios on the basis of the given information:
(i) Current Ratio;
(ii) Acid Test Ratio;
(iii) Operating Ratio; and 
(iv) Gross Profit Ratio.

     
Current Assets 70,000   Revenue from Operations (Sales) 1,20,000
Current Liabilities 35,000   Operating Expenses 40,000
Inventory 30,000   Cost of Goods Sold or Cost of Revenue from Operations 60,000

From the following, calculate (a) Debt to Equity Ratio; (b) Total Assets to Debt Ratio; and (c) Proprietary Ratio:
 

Equity Share Capital ₹ 75,000   Debentures  ₹ 75,000
Preference Share Capital ₹ 25,000   Trade Payable ₹ 40,000
General Reserve ₹ 45,000   Outstanding Expenses ₹ 10,000
Balance in Statement of Profit and Loss ₹ 30,000    

The Debt Equity ratio of a company is 1: 2. State whether 'Issue of bonus shares' will increase, decrease or not change the Debt Equity Ratio.


Items excluded in liquid assets are:


Consider the following data and answer the question that follows:

Particulars
Revenue From Operations 12,00,000
Cost of Revenue from Operations 9,00,000
Operating Expenses 15,000
Inventory 20,000
Other Current Assets 2,00,000
Current Liabilities 75,000
aid up Share Capital 4,00,000
Statement of Profit and Loss (Dr.) 47,500
Total Debt 2,50,000

What is the working capital turnover ratio?


Debt to Capital Employed ratio is 0.3:1. State whether the following transaction, will improve, decline or will have no change on the Debt to Capital Employed Ratio. Also give a reason for the same.

Tax Refund of ₹ 50,000 during the year.


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×