English

Calculate Inventory Turnover Ratio from the Data Given Below: - Accountancy

Advertisements
Advertisements

Question

Calculate Inventory Turnover Ratio from the data given Below:

Inventory in the beginning of the year Rs 20000
Inventory at the end of the year Rs 10000
Purchases Rs 50,000
Carriage Inwards Rs 5000
Revenue from Operations, i.e., Sales  Rs 100000

State the significance of this ratio.

Sum

Solution

Cost of Goods Sold = Opening Stock + Purchases + Carriage Inwards − Closing Stock

= 20,000 + 50,000 + 5,000 − 10,000 = 65,000

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

`= (20000 + 10000)/2 = 15000`

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

`=65000/15000 = 4.33` times

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

APPEARS IN

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

RELATED QUESTIONS

Short Answer Question

The average age of inventory is viewed as the average length of time inventory is held by the firm for which explain with reasons.


State giving reasons, which of the following transactions would improve, reduce or not change the Current Ratio, if Current Ratio of a company is (i) 1:1; or (ii) 0.8:1:
(a) Cash paid to Trade Payables.
(b) Purchase of Stock-in-Trade on credit.
(c) Purchase of Stock-in-Trade for cash.
(d) Payment of Dividend payable.
(e) Bills Payable discharged.
(f) Bills Receivable endorsed to a Creditor.
(g) Bills Receivable endorsed to a Creditor dishonoured.


The Quick Ratio of a company is 0.8:1. State with reason, whether the following transactions will increase, decrease or not change the Quick Ratio:
(i) Purchase of loose tools for ₹2,000; (ii) Insurance premium paid in advance ₹500; (iii) Sale of goods on credit ₹3,000; (iv) Honoured a bills payable of ₹5,000 on maturity.


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%

From the following data, calculate Inventory Turnover Ratio:
Total Sales ₹5,00,000; Sales Return ₹50,000; Gross Profit ₹90,000; Closing Inventory ₹1,00,000; Excess of Closing Inventory over Opening Inventory ₹20,000.


Inventory Turnover Ratio 5 times; Cost of Revenue from Operations (Cost of Goods Sold) ₹ 18,90,000. Calculate Opening Inventory and Closing Inventory if Inventory at the end is 2.5 times more than that in the beginning.


Calculate Working Capital Turnover Ratio from the following information: 
Revenue from Operations ₹ 30,00,000; Current Assets ₹ 12,50,000; Total Assets ₹ 20,00,000; Non-current Liabilities ₹ 10,00,000, Shareholders' Funds ₹ 5,00,000.


From the following, calculate Gross Profit Ratio:
Gross Profit:₹50,000; Revenue from Operations ₹5,00,000; Sales Return: ₹50,000.


Compute Gross Profit Ratio from the following information:
Revenue from Operations, i.e., Net Sales = ₹4,00,000; Gross Profit 25% on Cost.


Gross Profit Ratio of a company is 25%. State giving reason, which of the following transactions will (a) increase or (b) decrease or (c) not alter the Gross Profit Ratio.
(i) Purchases of Stock-in-Trade ₹50,000.
(ii) Purchases Return ₹15,000.
(iii) Cash Sale of Stock-in-Trade ₹40,000.
(iv) Stock-in-Trade costing ₹20,000 withdrawn for personal use.
(v) Stock-in-Trade costing ₹15,000 distributed as free sample.


(i) Revenue from Operations: Cash Sales ₹4,20,000; Credit Sales ₹6,00,000; Return ₹20,000. Cost of Revenue from Operations or Cost of Goods Sold ₹8,00,000. Calculate Gross Profit Ratio.
(ii) Average Inventory ₹1,60,000; Inventory Turnover Ratio is 6 Times; Selling Price 25% above cost. Calculate Gross Profit Ratio.
(iii) Opening Inventory ₹1,00,000; Closing Inventory ₹60,000; Inventory Turnover Ratio 8 Times; Selling Price 25% above cost. Calculate Gross Profit Ratio.


Revenue from Operations ₹ 4,00,000; Gross Profit Ratio 25%; Operating Ratio 90%. Non-operating Expenses ₹ 2,000; Non-operating Income ₹22,000. Calculate Net Profit Ratio.


State with reason whether the following transactions will increase, decrease or not change the 'Return on Investment' Ratio:
(i) Purchase of machinery worth ₹10,00,000 by issue of equity shares.
(ii) Charging depreciation of ₹25,000 on machinery.
(iii) Redemption of debentures by cheque ₹2,00,000.
(iv) Conversion of 9% Debentures of ₹1,00,000 into equity shares.


Opening Inventory ₹80,000; Purchases ₹4,30,900; Direct Expenses ₹4,000; Closing Inventory ₹1,60,000; Administrative Expenses ₹21,100; Selling and Distribution Expenses ₹40,000; Revenue from Operations, i.e., Net Sales ₹10,00,000. Calculate Inventory Turnover Ratio; Gross Profit Ratio; and Opening Ratio.


Current ratio is also known as ____________.


Which Ratio establishes the relationship between current assets and current liabilities?


Current Ratio is ____________.


Calculate current ratio from the following information:

Stock Rs.50,000, Cash 30,000, Debtors 40,000, Creditors 60,000, Bills Receivable 10,000, Bills Payable 40,000, Advance Tax 4,000, Bank Overdraft 4,000


Debt-Equity Ratio can be calculated as ______?


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.

Conversion of Debentures into Equity Shares of ₹ 2,00,000.


Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×