General, Manufacturers & Distributors, Tax & Assurance Guidance

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

Share on facebook
Share on twitter
Share on linkedin
Share on email

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

Dave leads the advisory & assurance practice and is well known inside and outside the firm for being both engaged & positive.

Jim Biehl

Shareholder

As the leader of the firm’s manufacturing & distribution team Jim is known for his engaged & energetic approach and deep industry knowledge.

Related Insights

Manufacturers & Distributors

Women & Manufacturing: 3 Success Strategies

Posted on May 12, 2022 by

Katie Blake
Competition for talent is heating up as job growth edges the country closer to full employment. Adding to conventional market pressures, fallout from the coronavirus pandemic is raising crucial questions about the future of work. Employers are having to rethink their assumptions about how to attract and retain an engaged workforce. 

Tax & Assurance Guidance

Foreign Tax Withholding: What You Need to Know

Posted on April 26, 2022 by

Rob Cheyne
Making service payments to a foreign person is a common cross-border transaction. U.S. taxpayers need to be aware of the applicability of withholding tax and related reporting requirements to ensure they comply and avoid unintended consequences. A U.S. payor must collect withholding tax and remit it to the IRS in the case it is applicable.

Manufacturers & Distributors

Tech Innovations Driving M&D Industry Growth

Posted on April 19, 2022 by

Rob Cheyne
Technologies like augmented reality (AR) are no longer just for games like Pokémon Go—businesses across almost every industry including manufacturing have found ways to increase their productivity with new technologies such as robotics, AR, virtual reality (VR), data visualization, and remote monitoring. While these kinds of innovations require an initial investment, they unquestionably pay off to increase ROI.

Sign up for our newsletters

Get general business and industry-specific news and knowledge straight from our accounting specialists.

The Sound of Automation Podcast

The Sound of Automation Podcast

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

Insights & Perspectives

Data-driven decision making: 3 key insights for business owners

What does it take to build a data-driven business? For self-reliant leaders who feel they’ve hit a plateau when it comes to scaling a business, adopting a data-driven approach can be a breakthrough success strategy. Using data in a more focused way helps good engineers become good entrepreneurs. It’s about creating balance. Here we take a look at key insights for business owners when using data in decision making.

Read More

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