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

S&OP with Profit
tackle supply chain stress

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

Do you have trusted analytical insights to recommend dropping 50% of your product portfolio?

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 [email protected]

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 [email protected]

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 [email protected]

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 [email protected]

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 [email protected]

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 [email protected]

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 [email protected]

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

Artificial Intelligence/Machine Learning to enhance Supply Chain Resilience and Effectiveness

artificial intelligence machine learning to enhance supply chain resilience and effectiveness
Georgia Tech Supply Chain and Logistics Institute Georgia AI Manufacturing AIM Grant CI.RADAaR Competitive Insights

Are you struggling with:

  • Reconciling multiple sources of supply chain data coming from a host of different systems?
  • Cost and profit performance insights that are not specific and accurate enough to make critical decisions?
  • Where to start with advances in Artificial Intelligence and Machine Learning applications that have a rapid ROI?

Georgia Tech Supply Chain & Logistics Institute (SCL) and Competitive Insights, LLC (CI) are proud to announce a new industry collaborative program offered through a recently awarded GA-AIM Grant.

Not limited to Manufacturing companies, this collaboration focuses on companies with operations in Georgia by providing subsidized and free training on the latest Artificial Intelligence (AI) & Machine Learning (ML) methodologies and technologies.

Richard Sharpe, CEO of CI, added “it is exciting to see how AI and ML developments are allowing a company’s resources to focus on strategic and operational actions versus dealing with fragmented data and the lack of one source of accurate and trusted information. We are honored to be working with SCL on this critical AI/ML initiative.”

Data Governance and Fruitcake

S&OP with Profit
tackle supply chain stress

Data Governance and Fruitcake

data governance and fruitcake

“Bad data is the fruitcake nobody eats.” Fruitcake gets put in the corner. Nobody serves it. Everybody hates fruitcake and everybody hates dirty data. As SteveMo shares, “At least fruitcake is good for re-gifting. You can’t re-gift dirty data.”

Big Data is something that companies are trying to define with regard to what it means to their operation and to their competitive landscape. When considering the growing number of sources of unstructured data (e.g. social media) and structured data, just defining the landscape of what you are talking about can be difficult. In this blog we have provided a framework for how to define Big Data, getting value from Big Data and now providing actionable points on how to turn a three headed monster into something that adds significant and ongoing business value.

In an earlier posting we identified the requirement to gain cross functional consensus with regard to how Big Data solutions are created to serve the intended purpose of solving a business problem(s). We also focused on why it is so important to take an enterprise wide perspective to maximize the value of the investment. In this posting, we will focus on the importance of data governance.

What does data governance have to do with Big Data?

Everything. Effective solutions take time and resources to build correctly. The question is do you want that investment to solve a business problem one time or to continue to support solving the business problem over time.

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.

Ok, so what does that have to do with Data Governance?

Let’s say that you have a significant business problem to solve. The information that you have in front of you is known to be consistently accurate and specific to the problem area. This is a function of the information coming from the same source, that the information has been verified by Subject Matter Experts (SMEs) and the way that it has been processed is consistent to provide the information you need. What did I just describe? Data Governance; the insurance policy for Big Data, and this insurance policy continues to provide returns as you measure the impact of those decisions over time.

Data Governance provides the rules for which you are obtaining, organizing, validating and processing the vast amounts of structured and unstructured data to gain competitive advantage. Without it, your Big Data investments are a waste of time.

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

All the best,

Richard Sharpe
CEO – Competitive Insights