Your Inventory Days Ratio: Do You Have Too Much Inventory?
Originally published: 08.01.14 by Ruth King
Find out how quickly inventory is increasing or decreasing in your business
Over the past few months I have written about liquidity ratios, debt ratios and productivity ratio. This month looks at the final ratio: Inventory Days, which tells you whether you have too much inventory or are building inventory.
The Inventory Days ratio lets you know how quickly inventory is increasing or decreasing in your business. Since inventory is a bet, it’s important to know how much of your hard earned cash is being spent on inventory. It’s defined as the number of days from the time you purchase an item to the time you use that item on a job.
The Inventory Days ratio is calculated from the Inventory Turns ratio. I don’t track turns because the critical ratio is the number of days. Inventory Turns is calculated by dividing annualized cost of goods sold by inventory. This is not the “text book” definition of inventory turns, which uses annualize material expense divided by inventory. In our industry, materials and labor are connected. You can’t install a motor or system without labor. That’s why I use cost of goods sold rather than simply material expense.
Annualized cost of goods sold is year to date cost of goods sold times 12, divided by the month of the fiscal year covered
Inventory days are calculated by dividing 365 by inventory turns.
This ratio assumes you’re tracking inventory properly. If you have the same inventory number every month, then this ratio is useless. If you have no inventory on your balance sheet, this ratio is useless.
Assuming your inventory is accurate, every contractor’s inventory days should be less than 30 days.
If your inventory days are less than 30 days, you still have to be vigilant. If they’re 18 days and they jump to 23 days, that’s an extra week of inventory in your business, which is significant. Find out why — it could simply be the company received a fall or spring stocking order, It could be build up for a large commercial job or someone isn’t paying attention and ordering, rather than using, inventory in the shop.
Like all of the ratios discussed previously, the trends are important. Figure 1 shows monthly Receivable Days and Inventory Days — I covered Receivable Days in the June issue.
It’s hard to tell what’s happening with inventory days from this graph. Figure 2 shows trailing long-term inventory days. You can see the inventory days line is flat. This is good. It shows in busy times and slow times, inventory is at a consistent level for that time period.
You now have all 10 operational ratios. Calculate each ratio every month, plot the trends and you’ll spot minor issues and take care of them before they become major crises. You can make good business decisions based on good financial data.
Ruth King is president of HVAC Channel?TV and holds a Class II (unrestricted) contractors license in Georgia. She has?more than 25 years of experience in the HVACR industry, working with contractors, distributors and manufacturers to help grow their companies and make them profitable. Ruth has authored two books: The Ugly Truth About Small Business and The Ugly Truth About Managing People. You can contact Ruth at email@example.com, or call 770-729-0258.
Articles by Ruth King
Where You Should Put Labor Burden
True profit is determined by net profit per hour, calculations which take both direct and overhead costs into consideration. Labor burden is included, whether you put it in direct or overhead cost.
Profitable Sales Turned into Positive Cash Flow is Critical
Although cash is king and is used to pay all of your bills, cash flow is important, but profitable sales turned into positive cash flow is critical.
Know When You’re Growing Too Fast or Too Slow
Business profitability doesn’t mean business survival. By running out of cash and not having the ability to borrow or get it in an equity investment, you can be profitable and go out of business by growing too fast.
Understand Your P&L: Overhead
Understand Your P&L Statement: Gross Margin, pt. 2
Gross margin should not vary more than a few points each month. If it does, then you must find out why the margin is varying.