Supply Chains to Admire 2023 - Report v4.0

55 SUPPLY CHAINS TO ADMIRE | 2023

55

Calculations

The methodology used to define the 2023 winners outlined in this report is as follows: ‣ Determine Industry Peer Groups. We started by placing companies into industry peer groups (based on prior work, we found NAICS and SIC codes inadequate). After much debate, we defined 28 peer groups, assigned companies to their respective industry sectors, and analyzed 512 public companies. There is no such thing as a perfect peer group. ‣ Define Timeframe. The next step was to determine the appropriate period. Since it takes at least three years for supply chain leaders to translate strategy to balance sheet results, and project outputs are often hard to sustain, we selected 2013-2022. Our goal was to understand post- recessionary trends. ‣ Identify the Metrics for Comparison. The third step was to identify the metrics to be collected and analyzed. In this analysis, we selected two value metrics (Market Capitalization and Price to Book Value (PTBV)) and four performance metrics (Growth, Operating Margin, Inventory Turns, and Return on Invested Capital (ROIC)). We aim to move supply chain leaders from a cost to a value focus. We know that the performance metrics selected have the highest correlation to market capitalization from our work with Arizona State University based on prior research. ‣ Start the Analysis. We collected publicly available data from balance sheets and income statements to complete the analysis. We used YCharts, a syndicated data provider of the balance sheet and income statement data, for this analysis. We only included companies that had at least one data point across all of the metrics in the period selected. ‣ Defining Improvement. The base principle of this analysis is that supply chain winners drive improvement while outperforming their peer group. As will be seen, this is hard to do. Our first calculation defined improvement in balance sheet performance compared to the peer group. To accomplish this goal, we calculated each Company's Supply Chain Index Ranking, a measurement of supply

chain improvement based on balance, strength, and resiliency. Companies are then stacked and ranked within a peer group and assigned an overall ranking based on the relative level of improvement. The lower the rank number, the higher the level of maturity. When companies tie, each Company receives the same ranking. ‣ Analyzing Performance. For each metric chosen, we calculated the mean, adjusted for outliers, and then analyzed the pattern over the period. We then compared each Company's statistical mean to the industry peer group. ‣ Define Winners. Our final step was to determine winners based on the improvement, value, and performance criteria, as will be explained in detail in this report. To understand the methodology completely, it is essential to note what the analysis does not include: ‣ This analysis does not include private companies or companies trading only on Chinese and Korean stock exchanges. ‣ We exclude companies with issues on reporting during the period (M&A) or public offerings. ‣ We excluded companies that did not have at least one data point for each metric across the period studied. ‣ The research focuses on retail, distribution, and manufacturing companies. The work does not include financial, insurance, or service sectors. ‣ Within each industry, there are metrics we consider essential, but feel that there is no good data source. An example is customer service. While we firmly believe that the analysis should include customer service in the performance metrics, we cannot find a reliable data source.

2 Supply Chain Index, published by Supply Chain Insights, http://supplychaininsights.com/research-2, July 12, 2017

Made with FlippingBook interactive PDF creator