Stock Days - KPIs in Action
Quite often we relate to our inventory holdings purely as a dollar number. So at any point in time we know the dollar value and use that as our guide as to whether the value is currently appropriate to our trading.
By using this "dollar" Inventory number you still need to mentally ascertain whether the current holdings are appropriate or not and that determination will be based on historical data and your past knowledge of trading and trading cycles.
There is a better measure. One that quickly relates to day to day operations, that is, Stock Days. Stock days gives you the number of days inventory you have on hand to fulfill future sales orders based on current levels of inventory consumption.
Ideally the calculation is conducted on an annual basis, this helps with fluctuations in seasonal trends. With this in mind however, Stock days can comfortably be ascertained on a monthly basis. A measure on a monthly basis also provides some measure of accountability as to the buying cycle of your inventory holdings.
To consider whether your KPI is appropriate have a look at "Can my KPI be wrong"
Calculation of Days Inventory is pretty straight forward and makes an ideal Liquidity KPI for financial analysis. The annual calculation is:
Inventory days = 365 x (Ave Inventory/Cost of Goods Sold)
For monthly measures adjust 365 (being annual days) to a rough monthly days average. And obviously monthly cost of good sold.
Inventory can also be coupled with sales as an appropriate yardstick for resource allocation. Kpi benchmarks for a Sales to Inventory ratio will also identify excess stock levels to current sales demands. To calculate: Sales / Inventory. Used consistently, an appropriate identifiable benchmark can be set to develop target inventory levels based on expected sales ensuring efficient use of liquid resources.
Inventory holdings can be a great bottomless pit for your cash flow. Managed properly with good current information will certainly assist you putting a lid on that pit. Managing these KPIs has never been easier with ezzykpi.com. Get a board with a free trial and give it a go.
CHECK OUT OUR SOFTWARE SOLUTIONS & ENJOY A 30-DAY FREE TRIAL NOW!
ezzyKPI | ezzyScorecard | Buy A Business
About Mark Walmsley
We try to make businesses a little smarter with the use of our Strategy, Operations and Acquisition tools. Our simple and easy-to-use business performance software solutions have helped accountants, consultants, managers and businesses quickly identify problem trends and leverage opportunities.
Director of Human Resources, AEC Consulting
6 年Hi Mark, I love the article. We must also look at our inventory-assets People. We invest in lubricating forklifts, our technology and business strategy but in my experience and opinion our investment in developing people to keep up with the growth and speed of technology is lagging with serious consequences.
Hi, I hope you are doing amazing. Working on something.
6 年Mark Walmsley this is an excellent look at inventory based evaluation. To be honest this is excellent for a liquidation. I would have to say after being involved in one currently, there is a ton of money that can be resurrected back from the dead in a manner of speaking. Companies have no idea about how much stuff the miss placed or don't know it has sellable value, before liquidation. What kind of company do you mostly use this for? Thanks very much for the great article.