How to Keep Inventory and Receivables Balanced
Originally published: 08.01.12 by Ruth King
Check these ratios monthly to detect problems with collections and materials.
For the past three months, I’ve written about the liquidity ratios (Can you pay your bills?); the debt ratios (Are you taking on too much debt?); and percentage compensation, (How productive are your employees?)
This month I’ll examine the last category of financial ratios — inventory days and receivable days. These ratios answer the questions, Do I have a collection problem, and am I building up too much inventory?
These ratios are calculated by using values from the balance sheet and the profit-and-loss statement. I also calculate inventory days differently from the “textbook” definition of inventory days. That version calculates the inventory days using material expense only. I include total cost of goods sold. In the HVAC industry, when companies sell a part, they sell the labor to install the part. Any time a company has material expense, it also has a labor expense. Thus, the ratio as I calculate it ensures profitable use of inventory by the field employees.
The inventory days and receivable days are calculated from the inventory turns and receivable turns. The days trends are what you need to watch each month.
The receivable-days ratio must be looked at in
Table 1 shows the inventory and receivable ratios that I track each month for a contractor. It is hard to decipher what is happening in this company just looking at the numbers.
Graph 1 shows the graph of the inventory and receivable ratios. Both the receivable days and inventory days increase and decrease each month. It’s hard to see what is happening because there are months where the accounts receivable days are as high as 100, and other months as low as 30. The inventory days also range.
The trailing data graph for this contractor shows a good story for inventory usage and a warning for receivable days. Inventory usage remains fairly constant on a long-term basis, which means that the company is being efficient with inventory. It is not building up inventory on a long-term basis.
However, the receivable days show a different story. The company has a collection problem. The fact that receivable days hit 100 days during a month is definitely a warning sign that someone had to start calling overdue accounts. The long-term trend is still rising. Even though the receivable-to-payables ratio is decreasing, (see my May 2012 HVACR Business column), the company’s receivable-days ratio is a warning sign to continue collection efforts. This ratio will eventually start decreasing on a long-term basis as the monthly receivable days start decreasing.
The last thing to look at is ensuring that the receivable days are higher than the inventory days, as they are with this contractor. This means that your company doesn’t have too much inventory. If both receivable days and inventory days are under 30 days, as they are with many residential contractors, there may be months where the receivable days are higher than inventory days and vice versa. Just ensure that they both stay under 30 days.
Take 15 to 30 minutes each month to calculate the 10 operating ratios I’ve written about over the past four months. Calculating the trends is critical to ensuring that your company can pay its bills, isn’t carrying too much debt, doesn’t have a collection problem, and is productive.
Ruth King has over 25 years of experience in the hvacr industry and has worked with contractors, distributors, and manufacturers to help grow their companies and become more profitable. She is president of HVAC Channel TV and holds a Class II (unrestricted) contractors license in Georgia. Ruth has written two books: The Ugly Truth About Small Business and The Ugly Truth About Managing People. Contact Ruth at email@example.com or 770.729.0258.
Articles by Ruth King
Increase Your Office Productivity
Are you staffing for the busy times or the slower times? If you hire office personnel to cover all of the busy times, they will not be productive in the slower times of the year.
Increase Warehouse and Inventory Profitability
Inventory is a bet. You’re betting your hard earned dollars that you will be able to sell parts and equipment that you buy and store in a warehouse or on trucks.
Six Easy Ways to Increase Marketing Profitability
If you want to waste marketing dollars, then just burn the leads that marketing generates. You invest thousands of marketing dollars to produce those leads. Keep them productive. Keep them profitable.
Three Ways to Increase Sales Profitability
Selling profitably, riding with your salespeople and tracking results will improve your company’s sales profitability.
Increase Installation Profitability
At the end of the day or the job, these are the wasted materials that get left on job sites or damaged, rolling around in trucks. Returning materials at the end of a job is one of the quickest ways to increase your bottom line.