Inventory Turnover Ratio
NickyW
Registered Posts: 97 Regular contributor ⭐
Please can someone help? I don't understand what this ratio is telling me!
Also sometimes it is calculated using the cost of sales and then other times the sales figures!!!!
Any help would be greatly appreciated.
Nicky
Also sometimes it is calculated using the cost of sales and then other times the sales figures!!!!
Any help would be greatly appreciated.
Nicky
0
Comments
-
Inventories/Cost of Sales x 365 = Inventory Turnover days
This tells you how many days the company hold on to their inventories before replinishing their inventories. A market trader would be expected to have an invetory turnover of a day or two as most of their stock on the stall would be gone before they bother to buy more invetories (I'm thinking of a fruit and vegetable stall here). A big jewelly shop (with lots of jewellery) however would have a long long invertory turnover - like 60 or 90 days - to sell their goods before they replenish their invertories.
The smaller the inventory turnover the more efficient the company is at selling their stock before buying more. Hope this helps.0 -
That really helps.
Thankyou!0 -
Please allow me to add a small condition
Remember that inventory is made up of:- Raw materials
- Work in progress
- Finished goods
Inventory (or Ave Inventory) x 365
Cost of Sales........................................ is fine for finished goods,
but if you are looking at a j-i-t production facility, there shouldn't be any finished goods. So if you want to know the inventory days you really want to know how long raw materials are in stock before being turned into products and sold.
Cost of sales includes purchases, and the conversion costs.
Using the formula above you would get a misleading figure because of the conversion costs, so it would be better to use purchase costs only.
Inventory (or Ave Inventory) x 365
Material purchasesSandy
sandy@sandyhood.com
www.sandyhood.com0 -
Sandy that is a brilliant explanation. I've printed it off for my DFS & PEV notes. Thank you.0
-
Thank you , Sandy. This really helps!!
Nicky0 -
Really sorry but confused again - why does my text book have the ratio as cost of sales divided by inventories?? - in the above replies it is the other way round?0
-
It is measuring the number of times the stock that stock will turnover (or be fully replaced) each year.
If you have a stock holding period of 1 month, the stock will turnover 12 times per year.Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
Sandy
Thank you for this. I completely get that inventories/cost of sales x 365 days gives you the average number of days it takes to turn over inventories.
I also get that cost of sales/inventories gives you the amount of times the stock will turnover.
What I still dont get is my text book has inventory turnover period as cost of sales/inventories x 365 days - this is different from the above 2 formula. Is it a misprint?
I hope I am making sense - and thank you for replying to my threads!
Nicky0 -
We would like our terminology to be precise:
- Inventory Turnover (often times per year)
- Inventory Holding Period (often in days)
Your point about the confusing use of the terminology in your text book could also apply to some exam questions.
I tend to find the holding period the most useful, so turnover period can genuinly be interpreted as holding period.
In terms of the formula, I agree that the book has an error. It should either miss off the x 365 or have inventory divided by cost of sales.
I think I addressed the use of the "cost of sales" part before - it would be most useful in relation to finished goods.Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
I undertand exactly what your saying Nicky I am confused with exactly the same ratio and in the text book and on other websites i've been on the stock turnover ratio is:
Cost of sales/inventories, the complete opposite of the ratio above.
The other thing that is confusing me is:
The Dec 08 PEV past paper question 2:1 (a) (vii) raw material stock turnover in days
How do they get the answers as 40.56 days and 73 days?0 -
Oly
For the raw material question you asked, see if this helps.
Raw material holding period
As far as your other point is concerned, remember cost of sales/stock gives the number of times the stock turns over in a year, whereas stock/cost of sales x 365 shows the ave number of days stock is heldSandy
sandy@sandyhood.com
www.sandyhood.com0 -
Just recalculated the past paper question using the ratio you supplied in the link Sandy, at last it makes sense.
Thanks Alot0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 322 NEW! Qualifications 2022
- 159 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 93 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 274 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership