Supply chain networks remain exceptionally complex and unpredictable. Key performance indicators (KPIs) show what is working.
In the new now, distributors are challenged like never before: Supply chain networks remain exceptionally complex and unpredictable, competition is tougher every day and customer expectations are escalating. And, most important, margins are slim and getting slimmer.
Today, it’s important to do everything that can be done to shave costs, increase revenue and boost profitability. The question – and challenge – is identifying the processes and functions where new efficiencies, extra pennies and an additional tenth of a percentage point in margin can be found.
The right metrics will make the answer clear. With up-to-the-minute, detailed and accurate key performance indicators (KPIs) driven by data provided by your ERP solution, you can know which processes are working well (and which may be broken), determine target areas for improvements, and make informed, intelligent decisions that will boost your bottom line.
Which KPI’s are the most critical? We asked our expert distribution ERP consultants for their insight.
This is the primary measurement of the efficiency of your processes, and it is simply measured as a ratio of the number of units delivered divided by the total units shipped. The definition of “on time” can vary depending on the customer and the industry, and whether shipping was handled in-house or by an outside provider. If partial deliveries are common, On-Time Delivery In-Full is a useful drill-down metric.
Assuming that customer satisfaction is one of the leading goals for your business, this is the metric to look at first. A caveat: The root causes of customer complaints can be many: picking inaccuracies, mis-ships, shipping damage, slow Return Merchandise Authorizations (RMAs) and credits, and more. So, it’s smart to measure Complaints and these more granular metrics as well, and use any increases as the trigger to scrutinize the underlying processes and performance.
TOCT has become an important KPI as business customers have come to expect Amazon-like delivery timeframes. With TOCT, we are measuring the time it takes to fulfill a customer’s order, but a similar metric for fulfilling your own purchase orders with your suppliers is also important. You should not only monitor for any increases in TOCT but also benchmark it against competitors.
As a high-level metric for warehouse efficiency, Throughput offers insight into how effectively your warehouse operation is utilizing its manpower in handling receiving, replenishment, order fulfillment and shipping processes. Your warehouse staff is one of your most critical assets and it’s important to make sure you are always using it in the most effective way.
A growing number of distributors are applying advanced analytics to help them balance inventory levels with service levels. To make that work, you need to know exactly how much inventory you have in stock. In fact, without at least a 98%-accurate cycle count inventory metric, you’re highly likely to have issues like stock-outs, long order cycle times, high back-order rates, lost sales and, eventually, poor customer satisfaction scores.
The utilization of your warehouse capacity is important to know. This metric could be based on available cubic feet storage, number of pallet locations or available pick facings. If your company is using only 50% of its warehouse capacity, it may be wasting money. And, if more than 85% of your capacity is utilized, you’re probably unable to operate efficiently (or safely). Identifying the utilization sweet spot – where your warehouse, people and processes operate most efficiently – is key. Your ERP will help you make that calculation and help you understand and accommodate seasonal and temporary variability.
No one should argue with the need to minimize, monitor and measure incidents, accidents, lost time and lost productivity in your warehouse and fleet. Not only should we be genuinely concerned about the health and safety of our employees, but there are significant costs associated with not focusing on safety.
Simple to calculate (revenue divided by number of employees) and easy to break down by function, RPE is a valuable indicator of productivity. Caution: RPE is highly variable by industry sector. Industry analyst data show that, in 2021, RPE for the distribution industry as a whole ranged from roughly $1.8 million to $600,000, with the average being around $800,000. But it would be more insightful – and more accurate – to set a benchmark using your own data, and then utilize percent change or increase/decrease as your metric.
Most people think about assets such as equipment, but you should also evaluate things such as receivables and inventory. In a low margin business such as distribution, how effectively you use all your assets can be the difference between being profitable and not.
There are many different ways to measure profitability – and no matter which you choose, you should look at it for the entire organization, by product or product family, by facility, by customer and by customer group. What metrics are the most edifying? Gross Profit Margin makes it easy to see profitability trends over time. Net Profit Margin reveals exactly how much profit your company makes after expenses. EBITA (earnings before interest, taxes and amortization) provides an accurate view of your company’s overall financial performance. Profitability literally is the bottom line.
Patti Jo Rosenthal chats about her role as Manager of K-12 STEM Education Programs at ASME where she drives nationally scaled STEM education initiatives, building pathways that foster equitable access to engineering education assets and fosters curiosity vital to “thinking like an engineer.”