Change Country

Manufacturers & Distributors

Turns on Inventory – Systems and Processes to Monitor Inventory Levels

Posted on June 22, 2020 by

Dave Van Damme

Dave Van Damme

Jim Biehl

Jim Biehl

Share This

You’re in the wholesale or distribution space and have a huge asset, called inventory, which needs to be converted to cash, but you aren’t great at tracking or counting it and you are not really sure which items are sitting.  So what do you do?   Outlined below are some simple ratios that can give you additional insight into what is happening with your inventory and allow you to start moving in the right direction.

Turnover

One of the most common ratios that we look at in servicing wholesale and distribution companies is inventory efficiency, or more specifically turnover and days on hand.  These ratios provide valuable insight into how successful a business is at managing one of their most significant assets.

In the broadest sense, turnover identifies how many times per year an average inventory clears out of a distribution center and is replenished.  That figure is compared against the number of days in a year, and speaks to how many days on hand of inventory you have;  meaning if you weren’t going to place another order, how many days it would likely take to sell out of everything.

Generally, the higher the turnover the better, as it would indicate that inventory is efficient and that owners are buying (and then selling) what the market is demanding.  A lower than desirable turnover indicates lower sales in relation to carrying higher inventory, which further means cash is tied up in inventory.  In some cases, cash is being spent on higher interest costs associated with money borrowed to purchase inventory that isn’t turning over.

Categorization

While computing inventory turnover and days sales outstanding are a great starting place, you then need to take your ratio analysis to the next level by categorizing inventory into “meaningful groups,” and then recomputing those same ratios for next-level insight.

Selection of meaningful groups depends on the particular business. For example, a soda-pop distributor might utilize generic categories such as cans versus bottles. Taking things one step further could also group caffeinated beverages vs. noncaffeinated; and even further within with diet caffeinated colas, vs. regular caffeinated colas.

Market Insight

Categorization matters because with this critical step, management can begin to have better insight into what’s actually happening with inventory.  From that data, a number of insights and related action steps can be implemented, including increasing demand through targeted marketing, analyzing and possibly consolidating vendors to achieve pricing/quantity discounts or even optimizing reorder points.

Turnover data should be compared to industry peers to both ask questions and, separately, understand your company’s performance.  Through this objective comparison, it may become clear what can be optimized.

Understanding and regularly reviewing ratios is the opposite of inventory opacity. Simply put, you’ll be able to influence how resources are performing so that you can more quickly adapt and respond to changes in the marketplace.  It also frees up cash to be invested in more than just inventory!

Financial analysis of inventory can be challenging, and it may not be clear where to start or what to focus on first.  Clayton & McKervey can help provide resources and interpret results.   Contact us today to learn more.

Dave Van Damme

Shareholder

Leading the firm's advisory & assurance group, Dave supports closely held businesses with audits, financial reporting and fraud analysis.

Jim Biehl

Shareholder

Leading the firm’s manufacturing & distribution group, Jim has built a reputation for providing strategic tax, accounting and operational support to owners.

Related Insights

Manufacturers & Distributors

Michigan Manufacturers: Talent Funding on the Way

Posted on September 9, 2022 by

Jim Biehl
In talking with manufacturers, we know that talent is a top issue. If you’re a manufacturer in Michigan seeking assistance with talent retention, you don’t want to miss out on applying for the Going PRO Talent Fund. This fund is designed to help employers with training, developing and retaining employees.

Manufacturers & Distributors

Are You Ready for the Bonus Depreciation Withdrawal?

Posted on August 31, 2022 by

Jim Biehl
America’s bonus depreciation addiction is scheduled to end. It may not be “cold turkey” but all businesses need to review the pending changes and related tax and cash flow impacts, especially considering a potential business slow down and/or recession.  

Manufacturers & Distributors

Manufacturers: Secure Capital for Expansion

Posted on August 25, 2022 by

Jim Biehl
The MEDC is launching two new programs to give Michigan manufacturers access to capital through local banks. Learn how these programs can help with your growth efforts.

The Sound of Automation Podcast

Industrial automation businesses are the driving force behind Industry 4.0, and Clayton & McKervey is here to help.

Skip to content