Logility is working with a leader in the distribution and logistics space that provides delivery to auto dealers for the dealers’ parts and services business. 

This specialization allows them to be more efficient and knowledgeable about their customers and the specific parts they are delivering. Because these parts cannot be sold and services cannot be scheduled and performed until the parts are delivered, it is exceptionally important that they deliver on time and in full. 

The problem this organization faced was knowing which routes were responsible for delayed deliveries and what was causing the delays. The company felt their routes and stopping points caused inefficiency, but they also wanted to forecast the impact of extraneous factors such as weather, road construction, and traffic patterns. With this information, they could adjust schedules to proactively service their customers, adjust delivery times, and gain greater efficiencies from their fleet. In addition, they wanted to incorporate the inventories from their parts suppliers and their geographic locations so they could minimize empty return-trip trucks and duplicate runs, as well as minimize the inventory that they had to keep on hand in their distribution centers while knowing which suppliers had what parts in stock. 

Logistical Challenges 

With 10 distribution centers, each with over 100 routes, and each route with over 15 stops, this posed a significant logistics problem. Add to that over 2,500 parts from over 200 manufacturers and this became a significant supply chain opportunity. In addition, each truck itself – and there are over 1,000 of them – is a constant big data generator, capturing location, efficiency, speed, right turns, left turns, stop times and the length of each stop. How do you coordinate all this data against the business issue of on-time deliveries with the greatest efficiency? 

The Logility Difference 

Using Logility, they first aggregated their enterprise inventory and logistics data with two external data feeds. Then they created a series of operating metrics to be used by managers as well as KPIs for reporting to executives. An important feature of these reports was predictive metrics. These metrics, using Logility’s predictive modeling capabilities, identify routes with risk factors and suggest the likelihood of one or multiple delays in the near future (weeks). Lastly, they distribute these efficiency reports and interactive dashboards using the Logility® Digital Supply Chain Platform. An important feature of this approach was deploying mobile versions of each report for traveling executives. 

Today, everyone from the CEO down to the route dispatcher at each distribution center knows where any issues are and what needs to be done to correct them. It also allows our customer to be much more proactive in dealing with both the delivery points and their suppliers. As orders and inventory stocks can be readily shared, increasing parts production efficiency at the manufacturer and delayed delivery points can be more readily notified so they can more effectively reschedule their work loads. First-year savings from reduced inventory and greater fleet efficiencies are estimated at over $3 million

Read this similar story: 

The science and practice of predictive analytics is well established and rapidly gaining ground in the public and private sectors. It’s not magic anymore because we now have advanced analytics systems that harness and organize massive amounts of disparate data and model that data in ways that allow humans to be proactive and make informed decisions. Take a moment to read our extremely popular post on selecting the right descriptive, predictive, and prescriptive analytics here. To review: 

Type of analytics What does it do? 
Descriptive Analytics  Answers the question, “What happened?” Uses data aggregation and data mining techniques. 
Predictive  Analytics  Answers the question, “What could happen?” Uses statistical models and forecasting techniques to understand the future. 
Prescriptive  Analytics  Answers the question, “What should we do?” Uses optimization and simulation algorithms to suggest the best course of action. 

The Science of Predictive Analytics 

Predictive analytics encompasses a variety of statistical techniques from predictive modeling, machine learning, and data mining that analyze current and historical facts to make predictions about future or otherwise unknown events. 

Predictive models exploit patterns found in historical and transactional data to identify risks and opportunities. These models capture relationships amongst many factors to allow assessment of risk or potential associated with a set of conditions, guiding decision-making with better accuracy and significant cost savings. 

Who Knew Supply Chain Optimization and Crime Fighting Were Related? 

Let’s examine two popular applications: supply chain optimization and crime fighting. How can predictive analytics effectively address these seemingly unrelated topics? Because at a macro level the issues are identical. Consider this abbreviated chronology of our quest to make better, faster, data-driven decisions regardless of the setting and the objectives: 

  • We had no data. We used unstructured observations and gut feel 
  • We got some data, but it was incomplete and resided in silos 
  • We got more (and more comprehensive) data, eliminated silos, filled in the gaps, but lacked modeling tools. This was the era of data-rich but information-poor. 

Today, predictive analytics tools allow us to compare possible outcomes of events using scenario analysis and foresee challenges and potential disruptions before they happen.  

Supply Chain Optimization – Use Case for a Domestic Brewery 

Our supply chain optimization use case comes from a top-10 domestic brewery that used Logility to gain better insight into production. Before Logility, this brewery had plenty of data, but was unable to make sense of it and “make it tell us something useful about the future”. Sound familiar? 

The data needed to be more easily translated into actionable information for managers and executives. The company had a variety of tools in-house, but the fragmented technical environment was too difficult to manage for quick scalability. They needed a powerful, analytics-driven solution to integrate and transform the data from their disparate systems, along with a front end for visual analytics, designed for the specific challenges of the beverage industry. 

A key point of differentiation for Logility was the ability to link multiple data sources to a single supply chain planning platform with reporting and analytics capabilities built into the functionality. Logility’s rapid integration framework enables a one-time setup of the platform, followed by easy report creation and access to analytics by business users. An early win included creating a daily shipments and depletions report for the CFO. Using a mobile-ready interface, the CFO can quickly scan variances each morning and immediately drill down to SKU and account-level data to see what’s driving exceptions. 

Based on these early victories, the brewery believes that the early detection of production efficiencies will yield $550,000 to $800,000 savings within 18 months. In addition, the company points to a two full-time staffing equivalent reduction (about $300,000 annually), and the value of faster decision-making by business managers. 

The Crime Fighting Analogy 

Now let’s consider the case of crime fighting and a diagnostic technique called Risk Terrain Management (RTM). The premise of RTM is that location matters. However, it’s no secret that location matters. The question is: how do you utilize data that you currently have to assess spatial risks and prevent undesired outcomes? RTM helps in this process. With a diagnosis of how the environment correlates with certain behaviors or outcomes, you can make very accurate forecasts. 

The reason RTM is used by practitioners across many disciplines, not just law enforcement, is because it was originally developed to solve a problem faced by many: how to leverage data and insights from various sources, using readily accessible methods. RTM gained fame as a crime prevention tool, but today it’s being used in urban planning, injury prevention, public health, traffic safety, pollution, and stopping maritime piracy. (Note that this is at its core the same problem the brewery faced, only the vocabulary and the objectives are different.) 

In the context of crime prevention, the RTM process begins by selecting and weighting factors that are geographically related to crime incidents. Then a final model is produced that basically ‘paints a picture’ of places where criminal behavior is statistically most likely to occur. 

With knowledge of spatial risk factors, intervention activities can be designed to suppress crime in the short term and mitigate the risk factors at these areas so they are less attractive to criminals for the long term. For instance, in one National Institute of Justice (NIJ) study, a 42% (statistically significant) reduction in robberies was achieved by focusing on environmental features of high-risk places, not merely the people located there. With RTM, you can prioritize risk factors and prescribe actions to mitigate these factors, even within the confines of limited resources. 

As you can see, predictive analytics and the underlying tools that support the discipline can be applied in many settings. People like to solve problems, but they need the right information. As business leaders we need to make sure they have it and then set them free. 

Interested to know where your ROI from a supply chain analytics platform will come from? 

Read this great blog:  

This post has been prompted by conversations I’ve had recently with a client in the early stages of implementing a Sales and Operations Planning (S&OP) strategy. They had been relying on a phased approach and they knew that they needed an integrated set of business processes to go with their newly purchased technology. 

They understood that the focus needed to be on information, not just the volumes of data they had at hand. They knew that in order to implement a successful S&OP strategy, they needed clean, current, and accurate data. As with many organizations, time and effort was being wasted gathering data that had minimal importance to the overall project. But in this case, senior leadership was able to articulate the business problem they were trying to solve, and were able to help define, with some difficulty mind you, the minimum data necessary for the project. 

It all sounds wonderful on paper, and they were destined for success! But like other businesses, their attempts to implement S&OP were frustrated by internal tensions between departments. What followed was this seemingly innocent statement on my part: “Not everyone will be a convert immediately, so we watch for resistance and address it as part of our strategy. Push, but not too hard, or we will get resistance.” 

And that’s when the fireworks started. Or to be precise, my somewhat nonchalant mention of possible resistance sparked some great comments and questions. 

Dealing With the Resistance 

Classic best practice suggests that S&OP must ‘belong’ to the Chief Executive Officer. If that’s not possible then a strong, united coalition of department heads may be able to lead the process if they set clear ground rules and boundaries for working together. In this case, we had senior management buy-in and support, but what we really needed was their ‘ownership’ of the project. 

Some amount of resistance is inevitable, and it usually boils down to cultural or people issues, not in any way exclusive to S&OP implementations, but let’s go ahead and tackle them in the context of an S&OP project. Here are the two most prevalent issues: 

The internal obstructionist 
This is the presence of a few highly regarded and influential employees who either passively or actively undermine the changes in behavior that the new initiative requires. You know you have this problem if the water-cooler conversation sounds something like this: “That new analytics program won’t work for us…”; “We’ve always done it this way…”; or, “That new initiative will make us have to change.” (Basically, anything eluding to “change is bad”.) 

The dirty-data diversion 
This is the belief that there’s no use starting an analytics implementation until the company’s data is polished, scrubbed, cleaned, pressed and folded to perfection. It’s the same argument some use to avoid going to the gym: “I’ve got to get in shape first!” 

I’ll address the Internal Obstructionist in another post. Today, let’s grapple with #2. 

The evil genius of the dirty-data roadblock is its apparent logic and deceptive concern for company well-being. In an analytics context, artful proponents of this argument appear to have the best interests of the company in mind. “We don’t want the C-suite making decisions based on bad data; that’s bad for all of us. Let’s get it cleaned up first.” 

Of course what’s really at work here is what Seth Godin calls the assertiveness of the lizard brain, also known as ‘the resistance’, also known as fear. No one wants the bright light pointed at their bad data or poor processes. 

And since no data-scrubbing project has ever succeeded, there’s little risk in promising a thorough clean-up as a prelude to an S&OP kick-off. That’s the diversion. Confucius might say it like this: “If you think you need to finish before you can begin, you will never begin.” 

Here’s how to overcome this type of resistance in three steps: 

1. Inject some honesty. Everyone knows there are data quality issues. Yes, even management knows. In fact, they’ve known for a long time. That’s not news. The point is to work together to improve the speed and decision-making ability of the enterprise, not place blame. This gives everyone who needs it some ‘cover’ and puts the lizard back in its cage. 

2. As soon as possible, start reviewing some basic KPIs in the new S&OP system. 
Embrace the fact that the data isn’t where it needs to be. Make reliable data part of the project, not a prerequisite. Doing this will help everyone envision the desired future and will set the stage for some quick wins. And quick wins will unleash the dynamic duo of momentum and optimism. The system should be viewed as a catalyst for operational improvement, not a tyrant that demands operational perfection to function. 

3. Meet often, especially in the beginning. In fact, consider daily meetings. More importantly, set overall priorities in a way that gives the team the time and the freedom they need to make progress between meetings. This helps reinforce everyone’s commitment to a successful outcome. In every meeting talk about how awesome life will be when the system is trusted and providing accurate information. 

Nike got it right with its slogan, “Just do it”. Starting has its own virtues. 

For more information, check out this e-book: 

A Roadmap for Designing an Enterprise that Thrives During Supply Chain Disruptions 

Congratulations! You’ve made it to the final installment of our series on building a supply chain that can thrive, not merely survive, during crises and curve balls. That demonstrates a certain amount of resilience on your part! We know there’s a fierce, never-ending battle for attention out there, so thank you for giving Logility some of yours. 

In the first three posts I covered steps 1 through 9:  

  1. Assessment 
  1. Justification 
  1. Vision 
  1. Explore 
  1. Collaborate 
  1. Elevate 
  1. Business Continuity 
  1. Elevate IBP 
  1. Change Management 

Now let’s examine the final three steps.  
 

  1. Alignment. Alignment has been called a “high degree of difficulty move” under the umbrella of change management. Why? Because this journey will require a new shared vocabulary, updated process definitions, new clarity around roles and ongoing synchronization of metrics and compensation. And you need to be prepared for some to say I didn’t sign up for this.  
     
    An aligned, mature organization encourages team members to think like a CEO every day. Instead of sub-optimizing (AKA optimizing locally), you’ll be expected to evaluate potential actions in light of strategic goals like improved customer service, margin growth and time-to-market. (Independent study opportunity for those interested in avoiding the sub-optimization trap: How is Elon Musk able to launch the Falcon 9 at 20% of the cost of the Space Shuttle?)  
     
  1. Culture. Leadership sets the tone, as always. There are many ways to convey an “embrace change” message. Pick one and stick to it. View disruptions as growth opportunities. Run away from the status quo. Change is a tonic. But understand that if you don’t get alignment right, culture will stagnate or even deteriorate. 
     
  1. Celebrate. If you get the first 11 right, I promise you will have plenty to celebrate. Research shows that advanced use of IBP (see step 6) will put you in the upper echelon of your peers when grouped by key supply chain performance measures. Take the time in small and large groups, inside and outside the company, to reflect on success. This practice is a powerful momentum builder.  

When you’re done, you’ll have more than a Center of Excellence, which implies a preference for or superiority of a single physical location. In contrast, you’ll have created a Nexus of Excellence. A dynamic yet stateless collection of people, process and technology on a global scale.  

Guard against complacency by constantly checking your achievements against this list: 

  • Platform has transformed us from data rich to insight rich. 
  • Teams use guided workflows with contextual drill downs. 
  • Accountability is clear and includes actionable outcomes. 
  • Planning and execution are integrated to the point where they feel like a single function. 
  • The organization is at once empowered and hungry. Achievement has unleashed a sense of how much more can be done. 

That completes our series on the 12 steps necessary for building an agile, resilient enterprise that consistently leverages people, process and technology to translate actionable insights into marketplace success regardless of circumstances.  

Time to Adopt Next Genalytics

The pace of change in retail has never been faster than it is now. Couple that with disruptions, big and small, and it’s not surprising that consumers are now even more unpredictable than before. 

In a recent Logility blog post, Richie Proud, vice president of planning and inventory at Curaleaf, said this about the upheaval in the retail fashion sector: The digital transformation of the fashion industry has been immense over the past 6 months. Almost all companies that I speak with are ecstatic over their e-commerce sales, but readily admit that the growth in e-commerce does not offset the decline in brick & mortar stores. This divide will only increase as we enter the make-or-break time period of Q3 2020 and Q4 2020 – as we have never experienced a “COVID Black Friday.” Traditional thinking would have teams placing deep buys of highly promotional items to be ready for the onslaught of in-store shopping starting the week of November 22, 2020. But recent sales data has shown us the public is still hesitant to return to malls, however they fully embrace the digital experiences offered by many retailers. 

New market dynamics should spur the retail industry to seek new ways of measuring performance. It may not be the news you were hoping for, but traditional retail success metrics are fast becoming obsolete in today’s economy. The Internet has changed how business is done, but brick-and-mortar businesses remain. In fact, go-to-market strategists have elevated their game by adopting a channel-agnostic focus as opposed to a binary physical-versus-digital orientation.  

It’s difficult to state the case more clearly and succinctly than Matthew R. Shay, president and CEO of the National Retail Federation, does here: While retail continues to evolve and adapt to changing consumer preferences and new technologies, it is increasingly critical to develop newer, more relevant metrics to accurately value and measure retailers. The current suite of metrics were built for a time that no longer exists. The lines between channels have blurred beyond recognition, making it challenging to properly attribute a sale with these outdated metrics…we need a common set of updated metrics that more accurately measures retailer performance and captures the full value that retailers are creating.  

The processes, tools, and analytics that we’ve relied on in the past — like sales and inventory turns — will no longer be sufficient to move us forward. At the same time, our fundamental goals have remained constant: providing compelling customer offerings, optimizing inventory placement, and converting that inventory into cash.   

This predicament reminds me of the situation faced by Oakland A’s GM Billy Beane and his quant-jock sidekick Bill James in 2002, when the New York Yankees were spending $140M a year on players to the A’s $40M. Knowing they couldn’t match New York’s money, Beane and James attacked the problem with metrics. Throw in a Michael Lewis book and a Brad Pitt movie, and you have Moneyball.  

It’s become somewhat fashionable to find flaws with Lewis’s portrayal, but Beane’s creativity and bravery aren’t questioned. Without completely discarding traditional baseball performance measurements like home runs and RBIs, he set out to find new metrics that would help him build a competitive team of largely undervalued players. On-Base Percentage, for example, turned out to be a strong predictor of success. His commitment never wavered. When the A’s manager balked and played expensive, free agent veterans instead of Beane’s hand-picked “affordable” players with a knack for getting on base, Beane traded away the veterans.  

Retail needs a Moneyball moment. It’s time to leverage the vast amount of data available to us and create revolutionary ways of measuring value, gaining insights, and driving customer demand. Logility is at the forefront of this movement with its next generation of analytics, called Next Genalytics.  

Next Genalytics isn’t a one-size-fits-all prescription for retailers. There is no mandate to focus on X, ignore Y, etc. Rather, the concept has built-in flexibility. The metrics you choose to develop, and track will likely be based on corporate lifecycle stage (i.e. maturity) among other variables. A young business may determine that customer acquisition and sales per unique customer are critical drivers of success while a mature business might focus on free cash flow. 

The point and the promise of Next Genalytics is this: there are modern, proven tools to help deliver on your analytics needs. Technology is not the limitation. Imagination, creativity and perseverance constitute the first hurdle. The second is capturing the data you desire.  

Relying solely on traditional retail performance metrics won’t work. Time for action. Now, let’s play ball! 

Sources: 

The Future of Retail Metrics. Sides, Marsh, Hobbs, Furman. Deloitte Development LLC. 2019. 

Success story

Mitre 10 gains much-needed supply chain visibility.

Logility helped Mitre 10 consolidate multiple data sources into a single repository using data warehousing. Users can now analyze information according to specific departmental or functional requirements and reduce the burden on IT for reporting.

Challenges

Mitre 10 is a New Zealand-based chain of more than 80 home improvement and garden stores. Structured as a marketing and buying co-operative, storeowners across the country can respond to the unique demands of their individual communities while being supported by their Auckland-based corporate headquarters. 

With greater than 80,000 individual SKUs available at any one time, monitoring individual performance across categories and regions, tracking trends or preparing useful, timely reports was a huge challenge for Mitre 10. 

Data but no insight

Monthly sales figures, purchasing numbers and selling information was all available but not able to be analyzed in any meaningful way.

Supply chain complexity

In excess of 80,000 individual SKUs being available across 80 stores made monitoring individual store performance difficult, as well as tracking trends or preparing useful, timely reports.

Solutions

From a technical perspective, Logility arranges information into pre-defined ‘cubes’ — sets of information relevant to a particular department that can then be dynamically arranged and analyzed easily. Logility’s data warehousing solution extracts the data from Mitre 10’s source systems and transforms it into the more usable data warehouse format to build into the information cubes. 

“Pulling information into a cube improves accessibility. With other systems, you get the same reports but they’re very static, so you don’t get the answers you’re looking for. There’s no easy way to drill down into the data,” says McHugh. “Once the cubes are all set up, it’s really simple on a design level to make changes, so that you’re always looking at the information in the most useful format for you.” 

Data Management

Advanced Analytics

Another win for Mitre 10 was Logility’s compatibility with other systems. Logility was able to simply ‘sit’ on top of their SQL Server, with most of the data coming from their ERP system on IBM iSeries. This saved cost and time because the business didn’t need to implement whole new systems. 

Results

Mitre 10 was able to get up to speed quickly with Logility’s uniquely simple user interface. As one executive reports, “When you compare Logility with other systems, it’s so much quicker to bring people up to speed. In 10 or 15 minutes you can learn the basics. When someone new starts here, they’re always surprised at how simple Logility is to use.” 

Mitre 10 managers now make decisions based on timely, accurate information rather than on instinct. They can quickly access a “state of the nation” view which is crucial for monthly management meetings where they discuss overall performance and strategies. 

The category managers use Logility when they need to compare actual sales to predictions, allowing them to make adjustments on pricing and promotions. 

Beyond the system itself, Mitre 10 executives have high praise for the Logility team, who just seem to “get” Mitre 10’s business, and always be “one step ahead.” As one executive explains, “The Logility team was a big selling point for moving forward. They’re a real asset to the business.” 

Under our old system, to build a complex report on sales and performance, it would have taken me at least an hour to pull the data, make the calculations and then format. With Logility, I can do the exact same thing in a few minutes.