Part 2: Create a Foundation of Repeatable Data Integrity to Fuel Your AI Solution

DC Velocity

Three Part Series on Smartly Avoiding the AI Hype Cycle

Part 2: Create a Foundation of Repeatable Data Integrity to Fuel Your AI Solution

Bad Data Leads to Bad Insights. Bad Insights lead to Bad Decisions.

This posting is part of a three part series on smartly avoiding the AI Hype Cycle. Part 1 of this series “Have a Clear, Intentional Focus on the Business Problem You Want to Solve” can be accessed here.

Creating a foundation of repeatable data integrity is absolutely essential to have a sustainable AI solution that provides ongoing value. However, companies continue to struggle with data issues. According to Gartner:

“Less than half of data and analytics (D&A) leaders (44%) reported that their team is effective in providing value to their organization.”

Companies have made investments to improve their data environment but still have not realized the attributes that they need. For data to be actionable it must be Accurate, Specific, Trusted and Repeatable. Instead, companies discover that their data remains Siloed, Fragmented, Missing or the right data is Difficult to Obtain. The required transformation is depicted in the following diagram:

Diagrams on Data

Lisa Harrington, President of the Harrington Group, summarizes the issue with the following:

“Harnessing the true power of data driven insights is the holy grail of future business. A wealth of this data comes from the supply chain. But, while the information is there, companies are not yet capitalizing on its real value as a source of insight capable of shaping the future of the enterprise.”

Let’s further define the characteristics in the diagram above that are required to create a foundation of repeatable data integrity. The data must be:

  • Accurate – use a 3-step process incorporating Machine Learning to ensure the accuracy of supply chain data;
    • Data Recognition – repeatable data sources have been agreed upon
    • Validation – detailed data values and data patterns have been analyzed
    • Verification – functional transactional data has been approved by SME’s
  • Specific - minimize data approximations or allocations whenever possible
  • Trusted - take the time to verify the organization trusts the information that you are using for your AI solution
  • Repeatable - require your data solution to provide for frequent refreshes that meet the other three requirements

One aspect of AI, Machine Learning (ML), positions companies to harness the full potential of their supply chain related data. In the attached video from a recent Georgia Tech conference, Brian Greene offered the following:

Brian Greene quote

The frustration associated with data issues can be solved. Ask any Executive if they would like to have better, more insightful, cost and profit performance visibility based on trusted and repeatable data. I guarantee the answer will be YES!

The power of AI can deliver cost and profit performance visibility that continually adds “disruptive” competitive advantage.

The third part of this series will address Manage the Adoption of AI/ML Solutions to Provide Rapid, Repeatable and Actionable Results.

We would love to hear your thoughts and comments. Please feel free to reach me directly at rsharpe@ci-advantage.com or visit our website at www.ci-advantage.com.

All the best,

Richard Sharpe
CEO – Competitive Insights

Have a clear, intentional focus on the business problem you want to solve using AI

DC Velocity

Three Part Series on Smartly Avoiding the AI Hype Cycle

Part 1: Have a Clear, Intentional Focus on the Business Problem You Want to Solve

“I continue to be impressed by the system.”

John Elliot • Former SVP of Operations • Hospira

Many companies are struggling to find the value (the “beef”) in Artificial Intelligence (AI) / Machine Learning (ML).

Companies are forecasted to spend $407 Billion on AI/ML technology in 2027 up front $86.9 billion in 2022 according to Forbes. As companies invest in the latest technology, they find that their expenditures have been influenced by typical hype cycle expectations.

This frustration can be avoided by following these three adoption cornerstones:

  1. Have a clear, intentional focus on the business problem you want to solve using AI (not a solution looking for a problem)
  2. Create a foundation of repeatable data integrity to fuel your AI solution (garbage in / garbage out)
  3. Manage the adoption of AI/ML solutions to provide rapid, repeatable and actionable results (not boiling the ocean)

The focus of this three-part series is to help companies avoid the hype cycle in AI investments. Investments that empower an organization to have game changing cost and profit performance insights for every product sold to every customer through every channel.

Part 1: Have a clear, intentional focus on the business problem you want to solve using AI

Companies have long recognized that having high-level cost and profit details, based on allocation methods, do not support making the critical types of decisions that are required in today’s competitive marketplace. The following highlights come from an article published by Clorox, Georgia Tech and Competitive Insights:

“Grouping customers by their revenue contributions or products based on their market category is commonplace. But zeroing in on discrete segments based on their exact contribution to bottom-line profits is another matter.”
“To be actionable, the profit contributions must be based on the actual realized net revenue for each product sold to each customer as well as all costs required to service that order from the sourcing of the product to the order-fulfillment activities.”

-Soumen Ghosh, Mark Hersh, and Richard Sharpe - Supply Chain Xchange

This was certainly the case for Hospira, a pharmaceutical company. The Executives realized that they needed to have complete end-to-end visibility of the costs associated with their complex product portfolio. The following provides a summary of the segmentation of their products based on accurate and specific profit performance for every product being sold.

Product segmentation distribution chart

The company gained such incredible value from these insights that they directed the data to be refreshed regularly.

“I continue to be impressed by the system.” – John Elliot, former SVP of Operations, Hospira

Ask any Executive if they would like to have better, more insightful, cost and profit performance visibility and I can guarantee the answer will be YES!

Following these cornerstones, the power of AI can deliver cost and profit performance visibility that continually adds “disruptive” competitive advantage.

Please comment on this posting or email me at rsharpe@ci-advantage.com

All the best,

Richard Sharpe
CEO – Competitive Insights

Putting AI/ML To Work – Smarter Cost & Profit Decisions

DC Velocity

Putting AI/ML To Work - Smarter Cost & Profit Decisions

Do you have trusted analytical insights?

One of the world’s most iconic brands announced they would reduce the number of brands in their portfolio by 50%. James Quincey, CEO of The Coca-Cola Company, stated in The Wall Street Journal:
"Now is the time for Coca-Cola to cull the portfolio of the many small, less profitable, resource-depleting brands"
“All told, the 200 brands slated to be discontinued account for only about 1% of the company’s profits. They consume too much attention and resources.”
Atlanta Journal Constitution October 22, 2020

With growing inflationary pressures, companies are pursuing aggressive strategies to reduce costs and operating complexity while still delivering expected profit contributions and shareholder value.

One prime area of focus is Portfolio Management.

Progressive companies are taking a proactive approach to reducing cost and operational complexity by performing a rigorous review of their product portfolio:

The Executive Vice President for a U.S. based company was dealing with significant cost and complexity pressures. His solution was to focus on the impact of SKU proliferation; "can we measure the specific cost and profit performance at the SKU, Customer, Channel and Region levels to reprioritize resources?”

Working with Competitive Insights, his organization discovered:

  • Only 3% of their entire Customer base was contributing 80% of their profit
  • 45% of their operating costs were being spent on servicing unprofitable customers and products
  • Their 11th largest Customer, measured by Revenue contributions, was totally unprofitable

Having accurate, specific and trusted Cost and Profit performance insights produces actionable strategies that have extremely positive results.

Please comment on this posting or email me at rsharpe@ci-advantage.com

All the best,

Richard Sharpe
CEO – Competitive Insights

Smartly Eliminate Roadblocks to Pinpoint Significant Cost Reduction Opportunities

S&OP with Profit
tackle supply chain stress

Smartly Eliminate Roadblocks to Pinpoint Significant Cost Reduction Opportunities

Roadblocks to Actionable Cost Reductions

Many innovative companies are supporting their supply chain leaders in spearheading approaches to capitalize on Artificial Intelligence (AI) and Machine Learning (ML) to reduce costs and protect operating margins.

However, laggard companies are experiencing internal resistance to adopting solutions that deliver accurate and specific SKU, Customer and Channel cost and profit performance insights.

The following statements come from hundreds of frustrated Supply Chain Executives:

  1. Our data is bad, missing, fragmented, siloed and managed in different systems.
    The power of AI and ML can be harnessed to eliminate the burden of connecting, validating and transforming data from multiple operating systems. In addition, significant data validation can be done efficiently by pinpointing possible data issues to Subject Matter Experts within a company.
  2. We have a hold on outside expenditures.
    Cost containment is a primary mandate for companies during inflationary business cycles. This unfortunately means that companies try to maintain their current operation by reducing any possible discretionary expense. This position indirectly discourages the use of innovation to reduce costs. Having the knowledge of where to focus on the most effective cost reductions will provide far more opportunities than just “tightening the belt”.
  3. We are just too busy and have very limited resources.
    AI / ML advancements can greatly simplify the ability to have unified and trusted information that can be used cross-functionally to make better enterprise-based decisions instead of departmental, siloed decisions.
  4. We can do this ourselves.
    Companies that undertake this type of development effort often experience unanticipated, longer development timeframes and higher personnel costs. Business Intelligence (BI) tools are very useful but are not designed to handle the required volume of transactional data (typically 4 billion+ transactions). The result is often organizational frustration and extended timeframes to achieve significant ROIs.
  5. We tried doing this before and it didn’t work.
    Only one or two companies have the supply chain, data analytics and data governance knowledge and experience. Add the need for AI/ML knowledge and it clear why internal efforts fail.
Top opportunities by product and customer

The companies that are successful at creating specific, accurate and actionable cost and profit performance insights will be the winners in the next decade. Companies must overcome organizational roadblocks to taking advantage of ongoing AI/ML advancements like generating specific, accurate and actionable cost and profit performance insights.

The reality is that having this type of information on a continuous basis has become table stakes to accelerating a company’s growth and gaining market share. Allowing excuses to prohibit the adoption of these strategic advancements is a dangerous competitive disadvantage.

Please comment on this posting or email me at rsharpe@ci-advantage.com

All the best,

Richard Sharpe
CEO – Competitive Insights

accurately understand SKU level cost and profit performance

Accurately Understand SKU Level Cost and Profit Performance

S&OP with Profit
tackle supply chain stress

Smartly Pinpoint Significant Cost Reduction Opportunities

Accurately Understand SKU Level Cost and Profit Performance

Smartly Pinpointing Significant Cost Reduction Opportunities

37,825 unprofitable products adding $608 million in operating costs and draining $146 million from the profitable performance of the company

Companies are pursuing aggressive strategies to reduce costs and operating complexity while still delivering expected profit contributions and shareholder value. Using price increases, package down-sizing and re-negotiating supplier agreements can have damaging, long-term impact on customer and supplier relations.

In contrast, some progressive companies are taking a more proactive approach to reduce cost and operational complexity by doing a rigorous review of their product portfolio. (Osprey – Hydroflask: https://www.supplychaindive.com/news/osprey-hydroflask-helen-of-troy-supply-chain-overhaul/649176/ )

Another case in point is for a well-known global company that continued to increase the size of its Product Portfolio sold through three different Channels. The global Head of the Supply Chain knew that this was adding operational complexity and costs. He also knew that the answer to solving this problem was to gain accurate, specific and repeatable cost and profit performance for every SKU in their portfolio.

As with most companies, this company had a host of data sources that were siloed and difficult to use. Having previous experience with these issues, he charged his organization to find a solution that was scalable and that would provide a significant ROI every month. A solution was selected and found the following results:

Product Segmentation by Net Landed Profit Product Segmentation by Net Landed Profit

As you can see, there were 37,825 unprofitable products adding $608 million in operating costs and draining $146 million from the profitable performance of the company.

Inflationary pressures are a significant concern for all companies. Understanding the ROI on where a company’s resources are being applied is critical as it relates to the actual costs being applied to servicing Customers, Channels and Regions and their Product orders. Having accurate, specific and repeatable insights to Cost and Profit performance produces actionable strategies that have extremely positive results.

Please comment on this posting or email me at rsharpe@ci-advantage.com

All the best,

Richard Sharpe
CEO – Competitive Insights

Smartly Pinpoint Significant Cost Reduction Opportunities

S&OP with Profit
tackle supply chain stress

Smartly Pinpoint Significant Cost Reduction Opportunities

Unwarranted Costs Associated with Unprofitable Customers

Reduce costs using Customer Profitability

This change dropped $3 million dollars off of their Outbound delivery costs.

Everyone of your customers provides a specific profit contribution to your Quarterly Earnings. It may be very positive, marginal or negative. Clearly knowing and trusting profit performance information at the Customer / SKU level goes beyond what is typically available in a P&L Statement. Having this information on a repeatable basis can lead to actionable strategies on sourcing, pricing and customer related operating costs. For most companies, not having this information leads to a “one size fits all” approach.

A previous client had a typical complex supply chain network of manufacturing locations, D.C.s, local service centers, their own private fleet and third-party service providers. Their network serves 110,000 customers across the United States. Want to guess how many customer locations provided 80% of their operating margin on a repeatable basis?

Customer Segmentation by Net Landed Profit

As shown in the chart, 2,843 customers provided 80% of their recurring profits. 106,362 were very marginal contributing 20% and the remaining 40,517 were unprofitable draining ($5 million) off their yearly earnings.

The Executive Team immediately identified 24 new operating strategies based on the financial performance insights that were provided. One of them was to no longer offer next day service to unprofitable customers.

This change dropped $3 million dollars off of their Outbound delivery costs.

Please comment on this posting or email me at rsharpe@ci-advantage.com

All the best,

Richard Sharpe
CEO – Competitive Insights

Smartly Tackle Data Barriers to Use Advanced Analytics

S&OP with Profit
tackle supply chain stress

Smartly Tackle Data Barriers to Use Advanced Analytics

Using AI/ML to Continually Reduce Operating Costs

Getthing through the Roadblock of Data

"less than half (44%) of data and analytics leaders reported that their team is effective in providing value to their organization"

“Harnessing the true power of data driven insights is the holy grail of future business. A wealth of this data comes from the supply chain. But, while the information is there, companies are not yet capitalizing on its real value as a source of insight capable of shaping the future of the enterprise.”

Lisa Harrington – President, lharringtongroup.com

Companies are struggling to use data and analytics to continually find ways to reduce operating costs and protect margins. According to Gartner, “less than half of data and analytics (D&A) leaders (44%) reported that their team is effective in providing value to their organization”.

So why are so many companies still struggling with the adoption of Machine Learning / Artificial Intelligence (ML/AI) technologies to handle today’s inflationary pressures? The reasons can vary but some of the most common complaints are:

Our data still sits in silos and it is difficult to integrate.

We have pulled all our data together but people still don’t trust it.

As a large company, we have a long way to go to be able to support advanced analytics with the current state of our data.

Case In Point: A meeting was held with the CFO, COO and SVP of Supply Chain for a well-known apparel company. They knew that they needed to build analytical capabilities, but were skeptical because of their perception of the current state of their data. Fortunately, the SVP of Supply Chain had previous experience in working with a solutions provider in tackling this issue. He convinced the others to take a first step that would demonstrate that their data could be turned from a liability to an asset to produce meaningful insights on opportunities to reduce costs and increase profit margins.

Data Assurance

Action: A Project Team was assembled and all sources for their supply chain and sales transactional data were identified. Data Subject Matter Experts were involved to address any data issues. Consensus was reached by the Team on how the data should be intentionally transformed to build a foundation for SKU and Customer specific cost and profit performance information. ML/AI technology was then used to further validate data quality problems and to create specific and actionable financial performance insights that could be refreshed periodically. The Project team found a potential inventory working capital reduction in excess of $10 million dollars.

Data integrity issues can be proactively addressed to ensure that operating data becomes a valuable asset. An asset that allows for visibility into actionable insights that drive trusted, fact-based decisions. The companies that take this seriously will consistently move ahead of their competition and drive additional cost reductions and profitable performance.

Please comment on this posting or email me at rsharpe@ci-advantage.com

All the best,

Richard Sharpe
CEO – Competitive Insights

Quickly Find Hidden Inventory Opportunities

S&OP with Profit
tackle supply chain stress

Quickly Finding Hidden Inventory Opportunities

Do you know where biggest inventory opportunitites are?

The most common issue still plaguing many industries is an increase in inventory and the impact on the bottom line. One company that is making progress is Guess. Check out this article on their efforts.

Guess CFO Markus Neubrand attributed the company’s growing operating margins in part to “clean inventories” and “carefully managed” costs. In today’s volatile operating environment, it is a difficult problem to solve. One critical consideration is understanding the specific and accurate cost and profit performance for each SKU in every inventory location.

The company highlighted below found hidden inventory reduction opportunities of over $400k out of a total Cost to Serve and Net Landed Profit opportunity of $2.9 million (40x return on investment).

Figure 1 Identifying Unprofitable SKUs With High Inventory Levels

Identifying Unprofitable SKUs With High Inventory Levels

Understanding the true costs and profit performance for inventory investments can provide the actionable insights needed to develop more profitable inventory deployment strategies. In one case, an international company serving over 50 countries had significant profit leakage issues. They knew they needed accurate and repeatable inventory insights on their Cost to Serve and Profitability opportunities across their international operations. In meeting this objective, the company was able to pinpoint the significant opportunities noted above.

Using traditional information in managing your inventory investments can lead to missed cost reduction and profit generation opportunities. Accurate, specific, trusted and repeatable Cost to Serve insights positions companies to out pace their competition and delight their stakeholders.

Please comment on this posting or email me at rsharpe@ci-advantage.com

All the best,

Richard Sharpe
CEO – Competitive Insights

search for cost reduction opportunities

Smartly Finding Significant Cost Reduction Opportunities

S&OP with Profit
tackle supply chain stress

Smartly Finding Significant Cost Reduction Opportunities

search for cost reduction opportunities

Finding cost-to-serve opportunities buried in the P&L

In this tough operating environment, companies are often forced to use a generalized strategy on cutting costs in key areas like minimizing supplier replenishment orders

Importantly, the specific total cost-to-serve and profit performance contributions by SKU, Customer and Channel are buried and certainly not visible through the P&L. So what is at stake? Hidden opportunities to realize significant cost reductions while increasing profit margins!

Case In Point: The following table shows the segmentation of customer performance by unprofitable customers (Unprofitable column), marginally performing customers (Bottom 4% column) and very profitable customers (Top 96% column). The same analysis can be done by products, markets, regions and channels.

184 unprofitable customers represent 34% of total Net Sales but add 41% of the total Net Landed Cost to Serve. Bottom line, company profitabiliy is reduced over 50%.  Highly profitable customers (491) represent 61% of total Net Sales but produce 196 of profitable performance. The distribution of Customer profit contributions is not atypical.

: Specific and accurate Cost-to-Serve and Net Landed Profit performance knowledge is essential in managing dynamic and changing operating environments. Using generalized information in managing your operation can lead to missed cost reduction and profit protection opportunities. Accurate, specific and repeatable Cost To Serve insights will allow you to out pace your competition and delight your stakeholders.

Please comment on this posting or email me at rsharpe@ci-advantage.com

All the best,

Richard Sharpe
CEO – Competitive Insights

77% have data quality issues, 91% said it's impacting their company's performance, study by Great Expectations 2022

how to eliminate data issues as a roadblock

S&OP with Profit
tackle supply chain stress

How to Eliminate Data Issues as a Roadblock

data integrity: 77% have data quality issues, 91% said it's impacting their company's performance

“Our data has significant challenges, and this is a real handicap for us!”

Summary: It is rare to talk to a company that believes they have very little challenges with their data. Unfortunately, many companies use their data integrity issues as a crutch to justify why they are not getting true value from business analytics.

Case In Point: Recently, Competitive Insights (CI) facilitated a meeting with the CFO, COO and SVP of Supply Chain for a well-known apparel company. The Executives knew that to proactively address inflationary pressures to reduce costs and complexity, they needed accurate and specific Cost-to-Serve and Profit Performance insights by Product, Customer and Channel but were skeptical because of concerns about the current state of their data.

Action: Fortunately, the SVP of Supply Chain convinced the other Executives to take a first step that would demonstrate that their data could be turned from a liability to an asset and produce meaningful financial insights to reduce costs and increase profit margins. He emphasized the need to efficiently:

  • Obtain, validate and transform all relevant end-to-end transactional data
  • Ensure cross-functional buy-in to the Cost-to-Serve and Profit performance insights
  • Provide for monthly updates accessible in an easy and intuitive format

Problems are solved by business leaders and managers making decisions that positively impact the efficiency and financial impact of the operation. Decisions that are fact based and that are actionable.

Results: Working with CI, all relevant transactional data was identified. Consensus was reached on how the data should be intentionally validated and transformed to build accurate and specific Product (SKU) and Customer Cost to Serve and Profit information that was far more granular than provided by their P&L. The following actionable financial opportunities were identified:

  • Out of 142,493 Products using 875 Colors, only 53 colors provided 80% of their profits
  • Segmenting Products and Customers by financial performance revealed that a very small number of Products and Customers contributed 96% of their true operating margin
  • Significant opportunities were identified to reduce operating costs by focusing on the large number of Unprofitable and Marginal Customers buying unprofitable Products
  • Inventory Working Capital reduction opportunities in excess of $10 million dollars were identified

Takeaway: Data integrity issues can be proactively handled to ensure that operating data becomes a valuable asset. An asset that allows for visibility into actionable insights that drive trusted, fact-based decisions. The companies that take this seriously will consistently move ahead of their competition and drive additional cost reductions and profitable performance.

If you like this blog, please share it or comment.

All the best,

Richard Sharpe
CEO – Competitive Insights