Inventory analytics. Manager using digital tablet in warehouseDistribution is an intensely competitive business and inventory is key to determining profitability. Applying advanced analytics to inventory management is a savvy way for distributors to track their performance and gain insights that can fuel profitability and growth.

Tweet: Inventory analytics: Two sets of metrics that really matter

There now are more than 30 metrics distributors can use to gauge their performance. I like to group inventory metrics into three sets: those concerned with inventory only, those that focus on the interplay of inventory and people, and those that track inventory with sales. Let’s take a closer look at the first two categories and how they can improve distributors’ performance.

Inventory-only metrics

Inventory carrying cost

How much does it cost to carry your inventory? Too few companies can answer this question accurately – and that means they do not know how their warehousing costs affect profitability. Your inventory carrying cost is not simply the cost of the inventory itself. It includes all the costs associated with your storage facility, such as rent, insurance, utilities, taxes, and depreciation. It also includes the costs related to your inventory management systems, including software applications, conveyors, and scanners.

I suggest distributors carefully go through their books to determine all these costs. Often, these are calculated per year and expressed as a percentage of the cost of inventory items. To determine the true cost of your inventory, add the carrying cost to the actual cost of items in inventory.

Once you have these numbers, what is the best way to present them? As with all metrics, I recommend displays that are simple, easily readable, and actionable, so you can click on and dive into the numbers. Inventory carrying cost is best displayed as a percentage along with your current inventory. Distributors should aim for a carrying cost of no more than 25%.

Inventory shrinkage

Shrinkage is a second “inventory only” metric that often yields insights. Shrinkage is the difference between what you physically have in your warehouse and stores versus what the computer thinks you have. Employee theft, shoplifting, and vendor fraud are common causes of shrinkage.

It’s useful to display shrinkage in three ways: as a dollar value, a percentage of sales, and a percentage of inventory. Companies want these numbers to be as low as possible. It’s wise to look at shrinkage numbers over time, watching for trends and opportunities to examine outliers.

Average cost per unit

Calculating your average cost per unit and tracking it over time helps monitor costs. If you see your average cost increasing, it may mean your internal overall costs are rising or you have more expensive products coming into inventory. It also could signal there has been a costing mistake.

The formula is simple: total inventory cost divided by number of units. This is best displayed as a straight number, with a graph over time.

Inventory & people metrics

Now let’s take a look at metrics that track the performance of your warehouse workers, the people who actually handle the inventory. Tracking their performance – and sharing the numbers with them – helps the entire organization set goals and can motivate individuals to continually work to improve their performance.

Average number of units picked

How much product is being picked every day? Every night? What is the total picked throughout the cycle? And what do you do with these numbers to maximize productivity? I suggest calculating the number of units pick per hour and the number of units picked per employee on a given shift. Then post these numbers for the team, as they directly relate to their activity. The average number of units picked is best displayed in comparison to your goal, so employees can work as a team to meet that goal.

Average number of units put away

The average number of units put away is a useful metric for the receiving team to see how they are performing putting away products received from suppliers. Again, you can slice this data per hour and per employee and the results are best displayed in tandem with the goal.

Takeaways

Inventory is a complex supply chain topic, and one in which targeted analytics can deliver insights and prompt action, especially for distributors. In my next blog, I will discuss four metrics related to inventory and sales that distributors can use to understand and improve their performance while getting a leg up on the competition.

Learn more

Mike Brockway

Mike Brockway

Mike Brockway is Dimensional Insight’s Consulting Director. He’s also the developer of our Program Advisor and Pricing Advisor applications. Mike presented at the MDM Analytics Summit in September 2018 on inventory analytics.
Mike Brockway