Shifting gear with cutting-edge data analytics
To help drive its decision-making, FleetPride knew it needed to harness operational data from its warehouses and logistics network. The company teamed up with IBM Business Partner Cresco International, an expert provider of business analytics solutions, to implement a suite of IBM Analytics solutions, including IBM® Cognos® Analytics, IBM Planning Analytics (formerly known as IBM Cognos TM1®), IBM SPSS® Modeler and IBM ILOG® CPLEX® Optimization Studio.
Homarjun Agrahari comments: “The team from Cresco has been so supportive throughout the implementation and beyond. Not only did they lay the technical foundations for our new analytics team, they also provided in-depth training to help get us started. Analytics is a new venture for many of our in-house team, and we’re glad to have Cresco by our side.”
As a first step, FleetPride used IBM Cognos Analytics to design and distribute daily warehouse stock and inventory reports. This gives warehouse managers a comprehensive overview of the level and location of stock, and shows recommendations on where to store each type of item based on customer demand. Armed with this insight, managers can make sure that the most popular items are stored near the shipping dock—saving a great deal of time for warehouse staff and increasing productivity.
Next, FleetPride used IBM SPSS Modeler to build a model that uses three years of historical shipping data to predict the number of in- and outbound shipping orders per warehouse, over daily, weekly and monthly horizons. This makes it much easier for warehouse managers to adjust their labor planning and maintain the right level of staffing to deal with customer demand on any given day.
The company is also working closely with Cresco International to build an optimization model of its entire distribution network with IBM ILOG CPLEX Optimization Studio.
Haoming (Ryan) Tian, Data Science & Analytics Consultant at Cresco International, remarks: “With the decision optimization solution, FleetPride is able to solve complex distribution network problems and find the optimal answers within a given set of constraints.”
Homarjun Agrahari adds: “CPLEX can help us work out the optimal locations where we could position a warehouse to minimize delivery time and costs across the entire network. When we’re deciding whether to build or acquire new warehouses, this kind of insight can make a significant difference to our network design strategy.”
Haoming (Ryan) Tian adds: “Here at FleetPride, we leverage multiple analytics technologies in an integrated methodology. IBM Cognos Analytics acts as an enterprise reporting platform so business stakeholders can quickly access and evaluate their business stats. We use IBM SPSS Modeler as a data mining and predictive technology to generate statistical models that can drive future insights for the business and help solve the challenges identified during descriptive analysis. Finally, CPLEX plays a dual role of integrating with IBM SPSS to derive optimal business suggestions based on statistical modeling under real world constraints, and also working independently to solve other optimization problems.”
Revving up supply chain efficiency
With the IBM Analytics solutions in place, FleetPride has gained unprecedented insight into operational data—transforming its approach to supply chain management.
Homarjun Agrahari notes: “We no longer need to rely on hunches or best guesses to manage all the links in the supply chain. Our managers all have quick, easy access to the latest operational data via detailed reports that help them make better-informed decisions to improve the efficiency of the entire supply chain.
“For example, daily stock reports have enabled warehouse managers to optimize the layout of the products, reducing the amount of time employees spend walking around the different storage areas empty-handed. This helps to make the entire warehouse more efficient and productive.
“The shipping prediction model we designed in SPSS Modeler, meanwhile, has helped us to manage staffing levels much more accurately, helping to ensure that we only bring in as many people as we need.
“Knowing approximately how many staff we need to process in- and outbound shipping on any given day has also helped to reduce the number of employees working overtime. Spending on overtime was a significant expense in the past. Now that we’re able to plan staffing levels more accurately, overtime spend is negligible and we’ve been able to make substantial savings.”
He adds: “Another model we designed in SPSS Modeler predicts the likelihood of warehouse staff making picking mistakes, which has enabled managers to take measures to simplify product labeling—now 99.5 percent of packing is error-free. This is an especially valuable insight, as many of the components we offer come in different sizes or configurations, and the smallest dispatch error could prevent a customer from getting their vehicle repaired quickly.”
Armed with indisputable data-driven insight into operations, FleetPride is better-positioned than ever before to keep its supply chain running efficiently.
Haoming (Ryan) Tian comments: “Cresco’s goal is always to share the same business understanding as our clients—that’s how we can help to optimize our clients’ business analytics and decision-making processes. In our work with FleetPride, we understand our client is in a rapidly innovating environment, so we are trying our best to help them think and operate faster.”
Cresco International’s Practice Director, Sanjeev Datta, who has been instrumental in showing the analytics maturity path to FleetPride, says: “Our clients trust our industry knowledge and product experience. Building analytical solutions that prove high return on investment only works with step-by-step approaches that help to gain trust and prove excellence, providing a winning strategy and solution. The Cresco team has time and again proved to FleetPride our commitment through our technical capabilities, project delivery and exceptional team work.”
Homarjun Agrahari concludes: “Supported by IBM Analytics solutions and Cresco International, we’re highly confident that we can keep improving supply chain performance even as our distribution network grows in sophistication. Harnessing advanced analytics software helps us deliver parts to our customers on time—which helps them keep their vehicles on the road and their businesses running smoothly.”