data analytics Archives - LMA-Consulting Group, a supply chain consulting firm https://www.lma-consultinggroup.com/tag/data-analytics/ Sat, 30 Mar 2024 06:31:04 +0000 en-US hourly 1 https://wordpress.org/?v=6.5 Business Value of Data Analysis & Predictive Analytics https://www.lma-consultinggroup.com/business-value-of-data-analysis-predictive-analytics/ https://www.lma-consultinggroup.com/business-value-of-data-analysis-predictive-analytics/#respond Thu, 12 Oct 2023 15:46:08 +0000 https://www.lma-consultinggroup.com/?p=21998 In working across company sizes, industries, and geographies, in almost 20 years of business consulting, every single client without exception needed to better utilize data to improve customer service and bottom line results. Smart clients are turning data into insights so that they can pinpoint where to focus quickly.

The post Business Value of Data Analysis & Predictive Analytics appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

In working across company sizes, industries, and geographies, in almost 20 years of business consulting, every single client without exception needed to better utilize data to improve customer service and bottom line results. Smart clients are turning data into insights so that they can pinpoint where to focus quickly.

Data Analysis vs Predictive Analytics

There is a lot of conversations about data analysis and predictive analytics. What is the difference? Data analysis is using data (from your ERP system, related technologies such as CRM (customer relationship management) and MES (manufacturing execution system) along with manual inputs and spreadsheets to analyze data to understand past performance, see future requirements, and make decisions. Predictive analytics takes it a step further and uses data to predict future outcomes. Both are essential for survival, let alone for growth and success.

Data Analysis

If your business is growing and profitable, you are performing data analysis. Resources are limited, high-skilled talent is scarce. For that reason alone, smart executives are using data to make decisions. No one can afford to fumble their way through daily execution and expect to have happy customers. On the other hand, very few clients have this down to an art. Unfortunately, data integrity issues abound, data sources do not align (misleading teams of people to focus on incorrect priorities), and executives can focus on the wrong information and reports (therefore wasting precious resources and time).

Client Example Using Data Analysis

Before you can leap to predictive analytics, you have to ensure your data is directionally correct and would lead you to reasonable decisions. Take an 80/20 approach in reviewing, updating, and analyzing data. For example, we are working with an industrial manufacturer on a supply chain consulting project to develop a production schedule, evaluate capacity constraints and rapidly provide realistic projected ship dates to customers and resurrect service levels, and data was at its cornerstone. The client went live on a new ERP system a month before we started working with them and were struggling to sift through the data to provide answers on customer orders. Although they had several high-skilled resources working 24/7 to figure it out and determine order status and availability, they were drowning in data with no way out. They couldn’t work through the data integrity issues and lack of viable information to make sense of sales orders in order to schedule work orders, review capacity, and ship orders.

Thus, we had to jump into the abyss of data, determine which fields were directionally correct, which fields to prioritize, who owned which fields, and who knew how to address which issues. Also, we had to determine which sales orders reconciled to the ones on the schedule, in the production area, on the heijunka board, and which had materials available, which had shipped, and which orders had data issues and were stuck in the system so that we could determine where to start. If we had waited for each of these data integrity issues to be resolved, our customers would have left. Instead, we prioritized, made assumptions to refine the data, reconciled critical data, and addressed the largest issues quickly. Although it took longer than expected, we took a six month task, and completed it within a few weeks with this approach. Data analysis was paramount to getting to the point where we could communicate dates. Refer to our article, “Cleansing, Connecting & Consolidating Data to Support SIOP/ S&OP and a Superior Customer Experience” for additional examples and solutions.

Predictive Analytics

As your data starts to provide directionally correct information for decision-making, smart clients are moving towards predictive analytics. It makes sense to look forward instead of backwards when making decisions. In essence, transitioning from reactive to proactive from a data standpoint can provide valuable visibility for making strategic decisions for demand and supply. Data is often integral to the SIOP (Sales Inventory Operations Planning) processes as you forecast future customer needs, evaluate capacity and production sourcing options, and assess logistics capabilities to serve customers.

At its core, demand planning / sales forecasting uses predictive analytics. Depending on your process and technologies utilized, you can be performing simple forecasting or using advanced predictive analytics. The outcome is to forecast what your customers will need in the future. Listen to our podcast interview with WBS for more insights on this topic. From a capacity planning viewpoint, it makes the most sense to look forward and project capacity using predictive analytics. For example, if you can use recent performance of an item or work center to predict run rates and downtime, it will yield a far better result than referring to a standard set the year before. Depending on the sequence of items and the machine performance, the output can vary widely. This is especially relevant in engineer-to-order businesses as similar combinations and/or setups are difficult for a person to remember. Taking it a step further, as production starts running, it is better to look forward and predict machine breakdowns, thereby resolving those issues before they occur than incurring downtime with preventative maintenance.

Predictive analytics is gaining momentum in business circles as executives prefer to look forward instead of to the past. Thus, according to Statista, the predictive analytics market revenue worldwide will grow from $5.29 Billion in 2020 to $41.5 Billion in 2028.

The Bottom Line

Data can make or break your business. Clients that utilize data for strategic insights and to proactively manage the business achieve far higher customer performance with higher profitability. On the other hand, those clients that get caught up in their shorts can let data negatively impact the customer and bottom line. Which approach will you use?

Continue reading on this topic:
Achieving Customer Growth by Turning Data into Insights

The post Business Value of Data Analysis & Predictive Analytics appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/business-value-of-data-analysis-predictive-analytics/feed/ 0
Lisa Anderson, Manufacturing & Supply Chain Expert Issues Supply Chain Special Report https://www.lma-consultinggroup.com/lisa-anderson-manufacturing-supply-chain-expert-issues-supply-chain-special-report/ https://www.lma-consultinggroup.com/lisa-anderson-manufacturing-supply-chain-expert-issues-supply-chain-special-report/#respond Tue, 09 May 2023 08:01:33 +0000 https://www.lma-consultinggroup.com/?p=18884 As originally published in Cision PR Newswire on May 9, 2023 CLAREMONT, Calif., May 9, 2023 /PRNewswire/ -- Manufacturing and Supply Chain Expert Lisa Anderson, MBA, CSCP, CLTD, known as the Strongest Link in Your Supply Chain® and President of LMA Consulting Group Inc., has published a Special Report - The Road Ahead: Business, Supply Chain [...]

The post Lisa Anderson, Manufacturing & Supply Chain Expert Issues Supply Chain Special Report appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

As originally published in Cision PR Newswire on May 9, 2023

CLAREMONT, Calif., May 9, 2023 /PRNewswire/ — Manufacturing and Supply Chain Expert Lisa Anderson, MBA, CSCP, CLTD, known as the Strongest Link in Your Supply Chain® and President of LMA Consulting Group Inc., has published a Special Report – The Road Ahead: Business, Supply Chain & The World Order. LMA Consulting Group works with manufacturers and distributors on strategy and end-to-end supply chain transformation to maximize the customer experience and enable profitable, scalable, dramatic business growth.

“While the visible signs of supply chain chaos have dissipated, business volatility and disruptions remain high. With the world order in a state of flux, risk is high. Yet because everything is interconnected, companies have an opportunity to stay ahead of their ideal customers’ needs. They can do this by reconfiguring their supply chains, leveraging technology and attracting and continually developing talent to leapfrog their competitors to secure a lead position in their marketplace,” commented Lisa Anderson.

The Road Ahead: Business, Supply Chain & The World Order is a special report that captures comments from trusted advisors and experts from various disciplines about what their most successful clients are doing and what companies should do to take advantage of opportunities in 2023 and beyond. “In talking with my colleagues, it became apparent that the same challenges, issues and opportunities resonate among business disciplines. Each discipline requires attention. Making required changes is not for the faint of heart. The opportunity in front of companies today is the greatest since the Great Depression,” she said.  

From cybersecurity, logistics, insurance and talent acquisition to nearshoring, reshoring and friendshoring, the tasks are many, but the opportunity is significant. “The only question will be whether your company is ready to take advantage of the opportunities to grow profitably or if you’ll struggle for survival. I hope that our Special Report sheds light on these opportunities,” she concluded.

Ms. Anderson also recently released: SIOP (Sales Inventory Operations Planning): Creating Predictable Revenue and EBITDA Growth to help organizations understand the value of a proven processThe book is complimentary on the LMA Website. It can also be found on Amazon digitally and on-demand print at:  SIOP at amazon.com and on iTunes: Apple. Ms. Anderson also provides supply chain updates through Supply Chain Chats, a series of short videos that address current topics, issues and challenges related to supply chains.

About LMA Consulting Group – Lisa Anderson, MBA, CSCP, CLTD
Lisa Anderson is the founder and president of LMA Consulting Group, Inc., specializing in manufacturing strategy and end-to-end supply chain transformation. She focuses on maximizing the customer experience and enabling profitable, scalable, dramatic business growth. Ms. Anderson is a recognized Supply Chain thought leader by SelectHub, named a Top 40 B2B Tech Influencer by arketi group, a Top 16 ERP Expert to Follow by Washington-Frank, in the Top 10 Women in Supply Chain by Warner PR, in the top 55 Supply Chain & Logistics Experts by flexport, and a woman leader in Supply Chain by RateLinx. She has been interviewed by Fox News, published the special report: Thriving in 2022: Learning from Supply Chain Chaos – Insights from 22 Trusted Advisors and the eBook, Future-Proofing Manufacturing & the Supply Chain Post COVID-19, Her primer, I’ve Been Thinking, provides strategies for creating bold customer promises and profits. An expert on the SIOP process (Sales, Inventory Operations Planning), advancing innovation, and making the supply chain resilient, Ms. Anderson is regularly interviewed and quoted by publications such as Industry Week, Bloomberg, and The Wall Street Journal. For information, sign up for her Profit Through People® Newsletter or for a copy of her book, visit LMA-ConsultingGroup.com. 

Media Contact
Kathleen McEntee
Kathleen McEntee & Associates, Ltd.
760-262-4080
358715@email4pr.com 

The post Lisa Anderson, Manufacturing & Supply Chain Expert Issues Supply Chain Special Report appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/lisa-anderson-manufacturing-supply-chain-expert-issues-supply-chain-special-report/feed/ 0
Geoff Michalak – Integrated Business Planning Manager, Armacell LLC https://www.lma-consultinggroup.com/geoff-michalak-integrated-business-planning-manager-armacell-llc/ https://www.lma-consultinggroup.com/geoff-michalak-integrated-business-planning-manager-armacell-llc/#respond Mon, 12 Sep 2022 15:39:58 +0000 https://www.lma-consultinggroup.com/?p=17967 The LMA Experience: Geoff Michalak, Integrated Business Planning Manager, Armacell LLC discusses their experience with LMA Consulting.

The post Geoff Michalak – Integrated Business Planning Manager, Armacell LLC appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

The LMA Experience: Geoff Michalak, Integrated Business Planning Manager, Armacell LLC discusses their experience with LMA Consulting.

The post Geoff Michalak – Integrated Business Planning Manager, Armacell LLC appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/geoff-michalak-integrated-business-planning-manager-armacell-llc/feed/ 0
ERP & Related Technology to Manage High Complexity with High OTIF Levels https://www.lma-consultinggroup.com/erp-related-technologies-managing-increased-complexity-with-high-otif-efficiencies-using-technology/ https://www.lma-consultinggroup.com/erp-related-technologies-managing-increased-complexity-with-high-otif-efficiencies-using-technology/#respond Mon, 02 May 2022 14:47:47 +0000 https://www.lma-consultinggroup.com/?p=16801 If there is one thing in common with every client (big or small) in the current business environment which is characterized by significant volatility and uncertainty, it is the increased level of complexity of supply chains. As the old saying goes, you are only as strong as your weakest link in your supply chain! That [...]

The post ERP & Related Technology to Manage High Complexity with High OTIF Levels appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

If there is one thing in common with every client (big or small) in the current business environment which is characterized by significant volatility and uncertainty, it is the increased level of complexity of supply chains. As the old saying goes, you are only as strong as your weakest link in your supply chain! That has proven true and has led to unfettered complications in successfully navigating the current supply chain environment. In fact, it is why we are have been focused on helping clients become “the strongest link in your supply chain”.

Customers do not care about the complexities of our supply chains. They want the “right” products delivered at the “right” place at the “right” time at the “right” price. In fact, during this volatile post/emerging from pandemic timeframe, customers are laser focused on which suppliers can provide solid delivery performance as measured by high levels of OTIF (on-time-in-full) and a superior customer experience. They will give volume to customers that can deliver!

On the other hand, companies are laser focused on increasing operational efficiencies so that they can deliver to customer expectations while meeting profit objectives. Because of the significant level of supply chain disruptions and increased money supply, costs are escalating. Companies want to limit the price increases they have to pass on to customers as they will lose the business if substantially more expensive than competitors without a commensurate increase in product quality or service. Thus, there is an increased interest in increasing efficiencies, automation, and “doing more with less”.

Utilizing ERP to Improve Service & Decrease Costs

Almost every client has an ERP system; however. ERP systems perform the transactions required to support taking orders, purchasing materials, planning production, picking and shipping product, handling returns, and invoicing customers. NOT every client has a modern ERP system. In today’s world of global, complex supply chains and increasing customer requirements, advanced functionality is needed to support customers without adding armies of people to support the processes. Additionally, modern ERP systems provide additional opportunities to automate, digitize, predict what needs focus (example: predictive maintenance vs. preventative maintenance), and they enable the collection, assimilation and analysis of data for decision-making.

Performing a quick assessment of your business needs as compared with your system functionality and capabilities is a great place to start. When evaluating whether an ERP upgrade is needed to support customer and profit objectives, we recommend starting with a comprehensive yet directionally correct assessment of business process requirements. For example, when working with a control panel manufacturer, we quickly determined that their current ERP system would not meet their growth plans. Not only were they struggling with multiple add-on software options that didn’t seamlessly connect, resulting in double keying and a hodgepodge of data, but they also needed advanced functionality with customer relationship management (CRM), configure-to-order (CTO) and engineer-to-order (ETO) and related customer interfaces, and advanced reporting and analytics. Thus, an upgrade was required.

Therefore, we started a deep dive of business requirements to select the appropriate software. We talked through and observed the business process requirements that would support sales and customer relationship management, engineering design, order entry, configure-to-order, production planning, purchasing, operations, shipping, invoicing, accounting, quality control, data management, and reporting/ data analysis. Based on that, we documented business requirements and, most importantly, identified the critical success factors that were unique to their industry, company, specialized process, and /or unique system requirement. Armed with this data, we were able to develop a request for proposal, demo ERP systems, compare pricing, and decide upon the best fit system to meet their objectives for the best return on investment.

Utilizing Other Technologies to Increase OTIF, Reduce Costs & Inventory

In addition to utilizing an ERP system, to meet the increasingly complex customer requirements without adding overhead, other technologies will add value. Similarly to evaluating business requirements for ERP systems, start by evaluating your needs to support customer and profitability objectives. Some of the technologies required to support success in the current volatile and uncertain business environment are as follows:

  • CRM (customer relationship management) software to proactively manage customers and potential leads
  • Forecasting software to forecast customer demand
  • Advanced planning software to go beyond traditional MRP and simple planning systems to better navigate complex supply chains
  • Warehouse management software (WMS) and warehouse execution system (WES) to increase warehouse efficiencies and achieve fulfillment objectives
  • Transportation management software (TMS) to optimize transportation planning and freight costs, lead times and service objectives
  • Predictive maintenance systems (using artificial intelligence and internet of things (IoT) to predict maintenance needs to target resources
  • Manufacturing execution systems (MES) to monitor manufacturing performance and tied to machines with IoT
  • E-commerce systems to support B2C and robust B2B effectiveness
  • Business intelligence systems (BI) to analyze data and consider what if scenarios
  • Predictive analytics to take BI and data to the next level
  • Blockchain although this type of software remains in an R&D phase for the majority of businesses
  • Additive manufacturing/ 3D printing to print products on the fly
  • Digital twins, robots, drones, RFID, autonomous vehicles, virtual reality, and more

The key is not to get caught up in fads. Start with your business requirements and determine the “right” place to invest to support your business objectives where the efforts and investment will support critical customer requirements and/or provide a significant return on investment.

Turn Data into Insights

Data is especially essential to driving OTIF and efficiency improvements. Simply tracking information in your ERP system and related technologies is not enough. It is more important to use your data to evaluate progress towards objectives and make directionally correct decisions to move the business forward. The key is to turn data into insights.

When your data analysis is achieving directionally correct results, it will make sense to take it to the next level with dashboards and slicing and dicing ability with a business intelligence solution. Once you can slice and dice data and have a dashboard available with the push of a button, consider moving on to advanced data topics such as predictive analytics. Instead of solely using data for decision-making, you can take it to the next level and predict your future so you can get ahead of the competition.

The Bottom Line

To succeed in these volatile and uncertain times, there is no doubt you’ll need a modern ERP system and related technologies to automate, digitize, meet customer expectations, accomplish more with less, and make directionally correct decisions rapidly by turning data into insights. Don’t go overboard and do everything and accomplish nothing, but get started on your journey with an assessment of your needs immediately before your competition passes you by.

Did you like this article?  Continue reading on this topic:
Achieving Customer Growth by Turning Data into Insights

The post ERP & Related Technology to Manage High Complexity with High OTIF Levels appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/erp-related-technologies-managing-increased-complexity-with-high-otif-efficiencies-using-technology/feed/ 0
Cleansing, Connecting & Consolidating Data to Support SIOP / S&OP and a Superior Customer Experience https://www.lma-consultinggroup.com/cleansing-connecting-consolidating-data-to-support-siop-sop-and-a-superior-customer-experience/ https://www.lma-consultinggroup.com/cleansing-connecting-consolidating-data-to-support-siop-sop-and-a-superior-customer-experience/#respond Fri, 01 Apr 2022 14:09:04 +0000 https://www.lma-consultinggroup.com/?p=16200 One issue of significant importance during the current volatile times that was also key during previous periods (aggressive growth prior to the pandemic, the downturn of the Great Recession, etc.) is the critical importance of providing a superior customer experience. It is evergreen for companies that want to grow and succeed. This metric is measured [...]

The post Cleansing, Connecting & Consolidating Data to Support SIOP / S&OP and a Superior Customer Experience appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

One issue of significant importance during the current volatile times that was also key during previous periods (aggressive growth prior to the pandemic, the downturn of the Great Recession, etc.) is the critical importance of providing a superior customer experience. It is evergreen for companies that want to grow and succeed. This metric is measured in various ways including OTIF (on-time-in-full), OTD (on-time-delivery), lead times, perfect order (no errors/ quality issues from order to invoice), easy returns, and more.

During periods of volatility, customer service becomes more challenging because customer requirements constantly change and evolve, and supply can also change and evolve. Thus, a SIOP/ S&OP (Sales and Operations Planning) process becomes essential to keep up with these changes and proactively adjust sales forecasts, production strategies, supply plans, inventory strategies, etc. If SIOP/ S&OP were cookie cutter, every client would have it in place. Instead, it should be tailored to each company’s unique situation, objectives, people, processes, systems, and data.

Data is a particularly key element for SIOP/ S&OP because cleansing, connecting, consolidating, checking, and charting data is frequently not nearly as easy as it appears. If not done properly, you will make decisions based on incorrect data. Perfection isn’t required or even encouraged; however, directionally correct results are of paramount importance. For example, an industrial manufacturing client wanted to forecast long lead-time material purchases. Unfortunately, their sales quotes (forecasts) were in one system, and their sales orders, manufacturing, and engineering specs were in a different system. The two did not connect. Additionally, there were several data integrity issues and no field in common to connect the two systems. Yet, it was critical to look into the future to avoid critical supply disruptions. They quickly started down a path to get directionally correct data for analysis and decision-making.

Cleansing Data

Every client has an overload of data. The key is whether the data is directionally correct in supporting decision-making. One of the first steps is to cleanse the data. Every client believes their data is reasonably correct until the reports compiled show strange results. Unfortunately, the key is not to overreact and cleanse every piece of data 100% before proceeding as that will likely put you WAY behind your competition. Instead, use the pareto principle. Start with the data that is most meaningful to your decision. Work with broad groups of products and cleanse with directionally correct updates. This is where the saying “garbage in, garbage out” comes into play. If you don’t cleanse your data, all you will achieve is getting garbage quicker. For example, the industrial manufacturing client had to clean up their master records (starting by focusing on the 20% that drove 80% of the volume) to make sense of their data. It would have taken years to fully cleanse data, but it took weeks to start with a pilot set of items and cleanse critical fields.

Connecting & Consolidating Data

Once your data is cleansed, it is likely you’ll have to connect your data from multiple sources, tables, or databases. It is also far more complex than it appears. If you don’t join the data properly, it will appear correct but you’ll get inaccurate results. Bringing a data analyst or systems analyst into the mix to assist in connecting data properly will go a long way. This is often the single largest client issue. For example, the industrial manufacturer had to develop a link between the two data bases so that they could successfully connect the records.

Checking

Certainly, once you’ve consolidated data into one source or report, you would check and validate the accuracy. This is also an often overlooked yet critical step. Clients frequently spend days developing reports to get a result that doesn’t add up. Because they get so lost in the data and it took a long time to develop, they immediately share these incorrect results proudly. For example, the industrial manufacturing client spent many hours developing a purchase report. However, the results didn’t add up to a number that made sense. Upon further review, it turned out that one of the processes put into place to dig out the appropriate dollars didn’t add up in terms of the quantities. They changed the report design, and the results became directionally correct.

Charting

The final step is to turn an overload of data into an easy-to-understand chart that provides immediate insights. These charts are incorporated into a SIOP/ S&OP process to quickly assess the situation and trend, and the discussion will lead to the evaluation of options and decisions. For example, the industrial manufacturing client was able to make reasonable assumptions and purchase ahead for long lead-time materials months before getting the details squared away by seeing the percentages by material type in a pie chart, and then making educated assumptions when placing orders.

Turn Data Into Insights

By following the process of cleansing, connecting, consolidating, checking and charting data, the industrial manufacturing client was able to get ahead of its competition because it had materials available for production once the increased level of sales quotes were turned into sales orders and engineering specifications were completed. They were able to turn data into insights and achieve record sales during a time when companies struggled with supply chain disruptions because they placed orders for long lead-time materials proactively (in addition to other proactive steps).

When your data analysis is achieving directionally correct results, it will make sense to take it to the next level with dashboards and slicing and dicing ability with a business intelligence solution. Once you can slice and dice data and have a dashboard available with the push of a button, consider moving on to advanced data topics such as predictive analytics. Instead of solely using data for decision-making, you can take it to the next level and predict your future to get ahead of pack.

Did you like this article?  Continue reading on this topic:
Achieving Customer Growth by Turning Data into Insights

The post Cleansing, Connecting & Consolidating Data to Support SIOP / S&OP and a Superior Customer Experience appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/cleansing-connecting-consolidating-data-to-support-siop-sop-and-a-superior-customer-experience/feed/ 0
Achieving Customer Growth by Turning Data Into Insights https://www.lma-consultinggroup.com/achieving-customer-growth-by-turning-data-into-insights/ https://www.lma-consultinggroup.com/achieving-customer-growth-by-turning-data-into-insights/#respond Tue, 22 Feb 2022 18:08:59 +0000 https://www.lma-consultinggroup.com/?p=16094 Every client has an overload of data. Whether using a modern ERP system or struggling with a complex maze of manual spreadsheets, the one item in common is an abundance of data. We have worked with clients with archaic ERP systems, but so long as we can extract data, progress can be made.

The post Achieving Customer Growth by Turning Data Into Insights appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

Every successful client is experiencing rapid growth and changing customer requirements. To support this growth in a scalable, profitable manner, turning data into insights is of paramount importance.

Data Overload

Every client has an overload of data. Whether using a modern ERP system or struggling with a complex maze of manual spreadsheets, the one item in common is an abundance of data. We have worked with clients with archaic ERP systems, but so long as we can extract data, progress can be made. On the other hand, we have worked with clients with Tier 1 ERP systems such as SAP or Oracle, but if they cannot get data out of their systems, the client is in a worse situation than the one with an archaic ERP system. Every manufacturer has products, defines how to produce those products (whether captured in someone’s head, in spreadsheets, or via an ERP system), has customers, receives orders, purchases from suppliers and so on. Each of those transactions and associated data is stored somewhere.

Data and related transactions adds up quickly. If you think about your typical day, you receive an overload of data before you even arrive at work. Your phone gives you the latest news and alerts. The news provides additional insights into key events. You drive by billboards and listen to the radio or talk with people on your way to work. You receive automated reports in your inbox. You most likely receive thousands of inputs before even arriving at work. Its no wonder we are overloaded! Since the pandemic might have cut out your drive, you might have replaced it with a walk or workout although you are still receiving data via the radio, a podcast or on the phone. To make matters worse, we employ people to run reports and track metrics on spreadsheets. Every time corporate, a Board member or a customer asks a question, another metric is created. Soon, we employ loads of people to publish data that no one uses to make decisions. How do we throw a line to save ourselves from drowning in data?

Take Stock of Your Data

Collect your data. It is likely to be an eye opening exercise. Take stock of standard reports your ERP system provides. Find out which reports are run frequently, and ask those people what they do with the information. Find out if the reports have to be massaged or adjusted to provide useful information. What has to be changed and why? Take a survey of the metrics your organization is collecting, tracking, or publishing. Ask who is using the metrics and what decisions are made based on the information.

In addition to understanding the volume and use of data, check into your data accuracy. Can folks make directionally correct decisions with your data? Or are there several exceptions that have to be discussed before taking action? If someone not intimately familiar with the data evaluated the report or dashboard, could he/she make a decision?

Reduce the Number of Reports to the Meaningful

We have not yet met a client that wasn’t collecting too much data. It is easy to get too ambitious and lose track of what is meaningful. Ask who would notice if the reports weren’t completed for a week? Go talk to that person and find out why. If no one knows or has a compelling reason to review the report, turn it off or tell the person compiling the information to stop compiling it for the next week or month. See if anyone asks about it.

Attend the meetings where data is discussed. Are people arguing about data or having meaningful discussions about what to do based on the data? If they are debating the accuracy, get the group together to develop ONE report that everyone agrees upon to illustrate the data. Eliminate the rest. For example, a building products manufacturer had several nuances to how they calculated OTIF (on-time-in-full), and so the team would debate the way the data was captured at each meeting instead of acting upon the data. We took a step back and aligned on the meaning of fields, how the data was captured and used, and we consolidated several reports into one cross-functional process to collect and analyze a single source of data. Although it certainly wasn’t the only reason, having meaningful reporting supported key decisions and actions which led to an increase in OTIF by 30%.

Turn Data Into Insights

Simply reducing the number of reports isn’t enough. It is essential to make the information meaningful for decision-making. Understand your sources of data. Connect the data. Cleanse the data. And turn data into insights with dashboards, data models or simply by retrieving the appropriate data for decision-making. It sounds much easier to do than it is in reality. For example, an aerospace client captured open orders and shipment data. Because they selected the data by the order creation date instead of the shipped date, the reports didn’t contain the correct information and didn’t reconcile to the invoicing data. Additionally, because they didn’t have their customer segregated in a key field they used to pull the report, the records that were blank didn’t get captured. Both were easy fixes but poor decisions were being made until the data was reconciled and cleansed. On the other hand, once the data was directionally-correct, they used it to determine the machine capabilities, capacities and staffing required to support their growth plans so they could get in front of their demand.

In another client, they had a proactive executive team for a small, rapidly growing building products company. They tracked potential sales leads, probability of success, sales history by geography and much more in their CRM system. Thus, they knew they needed to focus efforts on a key product line in the northeast because sales were lower than expected. By having this key information at their fingertips, they could target their sales efforts on the customers, products, and locations that would make a meaningful difference to their growth plans. They were recognized as the fastest growing company for several years in a row due to the expert ability to turn data into insights and take appropriate action.

You can turn data into insights no matter what systems you have supporting your business. It is far more important to have the appropriate processes and to focus people’s attention on how to dig into data and use it to make meaningful decisions. With that said, if you can support your data efforts with a business intelligence solution, you will gain a leg up on the competition. The great news is that BI tools are scalable; start small and scale up with complexity as it makes sense to support your business. Once you can slice and dice data and have dashboard available with the push of a button, consider moving on to advanced data topics such as predictive analytics. Instead of solely using data for decision-making, you can take it to the next level and predict your future to get ahead of pack.

Did you like this article?  Continue reading on this topic:
Thriving Post-Pandemic: Turning Data into Insights

The post Achieving Customer Growth by Turning Data Into Insights appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/achieving-customer-growth-by-turning-data-into-insights/feed/ 0
Baking Business: Companies Get Strategic to Pull Ahead of Supply Chain Crunch https://www.lma-consultinggroup.com/baking-business-companies-get-strategic-to-pull-ahead-of-supply-chain-crunch/ https://www.lma-consultinggroup.com/baking-business-companies-get-strategic-to-pull-ahead-of-supply-chain-crunch/#respond Wed, 02 Feb 2022 15:16:51 +0000 https://www.lma-consultinggroup.com/?p=16744 In this episode of Since Sliced Bread, Lisa Anderson, president of LMA Consulting Group, explains where the supply chain stands now, how it got this way and what she sees successful companies doing to get through the crisis.

The post Baking Business: Companies Get Strategic to Pull Ahead of Supply Chain Crunch appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

In this episode of Since Sliced Bread, Lisa Anderson, president of LMA Consulting Group, explains where the supply chain stands now, how it got this way and what she sees successful companies doing to get through the crisis. In the second half, she discusses the use of data.

Companies get strategic to pull ahead of supply chain crunch

Despite the opportunities for growth wholesale bakers have had due to increased consumer demand, the coronavirus (COVID-19) pandemic exposed weaknesses in the supply chain that are hindering the industry to fully take advantage of those opportunities. Bakers and suppliers — both ingredients and equipment — are struggling to source raw materials and find reliable transportation necessary to meet customer orders. In this episode of Since Sliced Bread, Lisa Anderson, president of LMA Consulting Group, explains where the supply chain stands now, how it got this way and what she sees successful companies doing to get through the crisis.

“Right-sizing or realigning your supply chain, those companies that are doing that are taking additional volume that their competition cannot supply and pulling away in the positive direction,” she said. “The ones that are hoping and waiting for things to get better are pulling away in the negative because others are taking the volume.”

Ms. Anderson outlines how she believes this situation will reshape the supply chain for good and what will eventually pull the economy out of the crunch. Labor remains at the heart of the issue, slowing down transportation both at ports and in the trucking sector.

Ms. Anderson explains how shortening supply chains can provide relief and digital tools can help bakers become more strategic about their inventories. These strategies can help bakers move through the current supply chain crisis and adapt to the future. Listen to this episode to find out what she thinks it will take for all this to be over.

 

Originally published on Baking Business.

The post Baking Business: Companies Get Strategic to Pull Ahead of Supply Chain Crunch appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/baking-business-companies-get-strategic-to-pull-ahead-of-supply-chain-crunch/feed/ 0
Thriving Post-Pandemic: Turning Data Into Insights https://www.lma-consultinggroup.com/thriving-post-pandemic-turning-data-into-insights/ Mon, 08 Nov 2021 19:40:12 +0000 https://www.lma-consultinggroup.com/?page_id=15258 The pandemic has spurred on the need to work smarter, not harder. In our Brushware article, the Digital Transformation Fueled with Business Intelligence, we talk about the critical importance of making meaningful decisions with data. As discussed in the SIOP client success story, data was a key driver of SIOP results. The key was in understanding data, the sources of data, cleansing data [...]

The post Thriving Post-Pandemic: Turning Data Into Insights appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

The pandemic has spurred on the need to work smarter, not harder. In our Brushware article, the Digital Transformation Fueled with Business Intelligence, we talk about the critical importance of making meaningful decisions with data. As discussed in the SIOP client success story, data was a key driver of SIOP results. The key was in understanding data, the sources of data, cleansing data, connecting data, utilizing data, predicting with data and more.

Since the pandemic (although largely pre-pandemic as well), EVERY single client’s situation and path forward had some relation to data and business intelligence. As discussed in a client panel at a global consulting conference, the use of data is strategic. The Global CIO of Abbott talked about turning data into insights. That is exactly what successful clients are doing! For example, another client took at look ahead to evaluate storage needs to get ahead of the supply chain surge and secure additional warehouse space while also reevaluating their sourcing data and deciding to reshore/ near-shore 70% of their production within the next year. Another client analyzed data and decided which items and/or customers to prioritize during the post-pandemic surge so that they maximize customer value and bottom line results.

From the technical side, we have been working with clients to create data models to support this type of analysis as well as evaluating and selecting business intelligence software as well as other data-rich software options (forecasting, SIOP, CRM, etc.). There is NO need to wait for technology solutions unless you’d like to be left in the dust. Start digging into your data and look for meaningful insights for decision-making and strategy setting.

As we are famous for saying to clients, don’t worry about perfection; directional analysis is the way to go. It is better to start moving in the right direction than to sit on the sidelines crunching data. After almost 17 years of consulting, it is absolutely clear that analysis paralysis can create confusion and leads to changes in leadership whereas the leader willing to absorb directional insights and make decisions thrives.

From a process side, there is no doubt about it that you should jump into data. There is more data available than at any time in history; in fact, there is too much data. Clients end up with information overload and do nothing. Stay calm. Think logically. Access whether your conclusions make sense, tweak as needed and move forward. If there is another thing all clients have in common it is that they get so buried in data that it can convey entirely incorrect conclusions and everyone misses it because they are so focused on data instead of common sense. Before publishing data insights, review from a common sense point-of-view. You’ll leapfrog the competition with a few powerful insights instead of a mountain of information that may or may not make sense.

Did you like this article? Continue reading on this topic:
The Digital Transformation Fueled with Business Intelligence

The post Thriving Post-Pandemic: Turning Data Into Insights appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
The Digital Transformation Fueled with Business Intelligence https://www.lma-consultinggroup.com/the-digital-transformation-fueled-with-business-intelligence/ https://www.lma-consultinggroup.com/the-digital-transformation-fueled-with-business-intelligence/#respond Tue, 31 Aug 2021 21:33:26 +0000 https://www.lma-consultinggroup.com/?p=14917 According to McKinsey surveys of global Supply Chain leaders (May 15-May 22, 2020, n=60), 85% struggled with insufficient digital technologies in the supply chain. One of the key digital technologies is business intelligence (BI) and analytics. According to Tableau, the projected return on investment of BI in a 3-year period is 127%. Clients and colleagues are seeing the importance of adopting BI and predictive analytics to proactively manage the company and make critical decisions. Are you on a roadmap to adopting BI?

The post The Digital Transformation Fueled with Business Intelligence appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

According to McKinsey surveys of global Supply Chain leaders (May 15-May 22, 2020, n=60), 85% struggled with insufficient digital technologies in the supply chain. One of the key digital technologies is business intelligence (BI) and analytics. According to Tableau, the projected return on investment of BI in a 3-year period is 127%. Clients and colleagues are seeing the importance of adopting BI and predictive analytics to proactively manage the company and make critical decisions. Are you on a roadmap to adopting BI?

A recent Google-commissioned study by IDG showed that the role of data analytics and intelligent solutions will be important to helping businesses separate from their competition. Insights from data will be crucial in carving out winners in the post pandemic era. BI was gaining in popularity prior to the pandemic, but it skyrocketed during COVID as companies realized they had to get insights to get ahead of the curve. For example, they needed to figure out the answers to questions such as how customers’ buying behaviors are changing and what types of new products and services will best serve their most profitable customers.  

For example, a client had unprecedented demand coming down the pike and wanted to better forecast sales so that they could prepare for the surge. The issue is that they had multiple systems and data sources that didn’t connect to one another. Sales used one source, and Operations used a different source. Although their business is custom and engineered-to-order, we found predictable patterns in their historical sales, and we discovered that their quotes could be data mined to capture key information that would be instrumental in preparing their operations and extended supply chain.

However, to extract the information and connect the data to be able to gain insights to make directionally correct decisions, a significant deep dive into data was required. The client worked for months to delve into business processes to understand how to cleanse the data, connect the data, fill in data gaps and create a repeatable and sustainable process to manage the data. Of course, although centered on data; the key to success was working with the people to understand what was relevant and how to account for key conditions and build them into the data model. Instead of waiting for perfection, the client started to utilize the directionally correct information to order long lead-time materials, to plan capacity and to evaluate offloading opportunities to get a jump on critical decisions.

In this situation, the client started with a simple BI solution as time was of the essence. They created dashboards and visualizations to better align Sales with Operations and demand with supply as part of their Sales, Inventory and Operations Planning (SIOP) process. While building the data model, the client started to document the data maps and data integrity process disciplines required to ensure sustainability. This resulted in a BI roadmap to create a business analytics and intelligence platform to grow sales and scale the business successfully.

BI was a priority prior to the pandemic; in the post-pandemic, it is has transitioned from a priority to critical and essential to survival. According to 451 Research, the ability of business leaders to quickly use data from operational applications to make strategic decisions and deliver on strategic outcomes will rapidly be seen not just as a potential competitive differentiator, but also as a fundamental requirement and strategic imperative. Yet BI alone isn’t enough. According to Gartner, 75% of enterprises will shift from piloting to operationalizing artificial intelligence (AI). Predictive analytics will become the norm. If you don’t yet have a roadmap, jump in the fast lane, and make sure you are in control of the car.

 

As originally published in Brushware Magazine on September-October 2021

The post The Digital Transformation Fueled with Business Intelligence appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/the-digital-transformation-fueled-with-business-intelligence/feed/ 0
9 Big Ideas from Women in Supply Chain Leadership https://www.lma-consultinggroup.com/9-big-ideas-from-women-in-supply-chain-leadership/ https://www.lma-consultinggroup.com/9-big-ideas-from-women-in-supply-chain-leadership/#respond Wed, 20 May 2020 14:50:22 +0000 https://www.lma-consultinggroup.com/?p=13668 The landscape for supply chain leaders is getting more complex each year – and that’s before taking into account the current global pandemic. We’re facing unprecedented challenges, and there are no easy answers.  Thankfully, despite growing headwinds and current conditions, there is no shortage of industry voices with insights, ideas, and actionable advice to get [...]

The post 9 Big Ideas from Women in Supply Chain Leadership appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>

The landscape for supply chain leaders is getting more complex each year – and that’s before taking into account the current global pandemic. We’re facing unprecedented challenges, and there are no easy answers. 

Thankfully, despite growing headwinds and current conditions, there is no shortage of industry voices with insights, ideas, and actionable advice to get us through it. Not only do the women in this post have a clear vision of the supply chain landscape today, they’re at the forefront of trends shaping its future. 

Here are some thought-provoking ideas from women in supply chain leadership who are helping lead the industry through a turbulent and uncertain time

Skills Required for Supply Chain Digitization

Lisa Anderson, Supply Chain Expert and Consultant, and President of LMA Consulting, recognizes the importance of agile supply chain digitization done right. She’s an expert on end-to-end supply chain transformation, especially as it pertains to scalability. Ratelinx has been fortunate enough to sit down with Lisa in the past to talk digitization. Her insights aren’t just practical—they’re actionable. Here’s what she has to say about the skills required for supply chain modernization. 

“Business leaders should be hiring and training for data analytics, the ability to leverage ERP systems and think through down-the-line impacts as well as tying business processes to systems design. We should also look at the soft skill requirements, such as collaboration. I’ve found that a more dramatic ROI can occur by aligning the people, even more than the data and the process.”

Anderson reminds us that despite all the tech and transformation in the logistics industry, it’s still powered by people.

“Forgetting about the people element is a major risk factor for businesses. To implement high tech successfully, you need to accompany it with high touch!”

 

Click here to read more.

 

Published in Ratelinx on May 20, 2020

The post 9 Big Ideas from Women in Supply Chain Leadership appeared first on LMA-Consulting Group, a supply chain consulting firm.

]]>
https://www.lma-consultinggroup.com/9-big-ideas-from-women-in-supply-chain-leadership/feed/ 0