Distribution Network Planning & Inventory Optimization Supported by Simulation

Problem:




Diageo is a British multinational alcoholic beverages company. Diageo Russia is one of Russia’s top five wholesale alcoholic beverage distributors, which is traditionally a low margin business where the bottom line is sensitive to the customer service level and high logistics costs. Diageo sought assistance from the consulting companies Logistics Field Audit (business and supply chain management consulting) and Amalgama (simulation modeling consulting) when they experienced an increase in sales volume, but failed to realize larger profits due to logistics costs per unit. Other mounting concerns for Diageo were customer service level and cost of goods sold, combined with an increased inventory and future plans of development including a new warehouse in Russia and expansion to Urals and Siberia. The consultants were also assigned to manage Diageo’s big data with simulation-based decision support in order to show and prove ways to decrease logistics costs and choose a logistics configuration for the expanded client network.


Solution:




The supply chain model includes three existing and one perspective factory, three border crossing points, three existing and five perspective warehouses, two customs offices and up to 300 demand points grouped into 45 service groups. In addition, the supply chain model contains a replenishment algorithm, order aggregation algorithm, load baring algorithms and delays at border crossing points. Demand and sales forecasting accuracy for all 280 Diageo products in 6 types of warehouses were also built into the model.


Logic built behind the simulation model included a replenishment algorithm concerning a segment of the supply chain that begins at the consolidation warehouse, with five days of lead time to the central distribution center and five days of lead time to the original distribution center due to Russia’s large size and relatively slow transportation capacities. The replenishment algorithm takes into account a requirement diagram (planned sales diagram), current stock, lead time, and minimum order size, then generates the requirements for replenishment, identifies the coverage gaps, (time periods when stock will be lower than the lowest threshold), and takes action to prevent any gaps in coverage.

Supply Chain Structure in a Simulation Model


Supply chain elements simulated in the model


Model validation was imperative and began by comparing data from the previous year SAP ERP system data which assessment results gave less than 5% differential.

Supply Chain Simulation Model Results

Target stock level at different forecast precision

Outcome:




Initial value for Diageo included an increase in sales forecasting accuracy from 60%-80%, with a pay-off period of less than 2 years. This increase will allow Diageo to reduce their target stock level by 40% which will reduce logistic costs per unit by 7%, even with plans of sales growth. The research also denied the need for additional warehouse space, as the stock required to maintain the target service level was unreasonably high.


After running the simulation, the model provides the stock level forecast for each product (15 days ahead), a complete cost for each and every delivered product unit, and proves to the client what the target state of supply chain should be.


View Andrey A. Malykhanov’s entire presentation delivered at the AnyLogic Conference 2013:


More Case Studies

  • Rail Yard Capacity Modeling
    Aurizon is an Australia’s largest rail freight operator, managing more than 700 locomotives and more than 16,000 wagons. Aurizon is widely engaged in coal, iron ore, and mineral transportation. In order to increase operational efficiency the company decided to move one of their rail yards to other town. This rail yard was mainly engaged in wagon and locomotive maintenance and locomotive preparation.
  • Selecting the Best Inventory Policy Using Gojii
    Existing supply chain and S&OP tool sets do a great job of managing supply to meet a selected "forecast." However, there is no single "correct forecast" of future demand, and existing tools are not designed to select the best demand level for the business. There is a "tool gap" between forecast inputs and selection of the best demand signal (aka "forecast") to drive your S&OP system. Gojii is the tool created by DecisioTech that fills that gap.
  • Maximizing Push Boat Fleet’s Net Voyage Revenue
    InterBarge, a first-class waterway operator, affiliated with SCF Marine, a part of Seacor Holding Group, operates freight along the HPP Waterway (Hidrovia Parana Paraguay, located in Argentina, Paraguay, Brazil, and Uruguay) on a dedicated contract carriage. The company’s challenge was to use the boat capacity free from dedicated contract commitment as a fleet, maximizing net voyage revenue.
  • Customer-Centric Transportation Network Modelling
    The public transportation company employed PwC Australia to develop a solution that could provide a customer-centric view of their railway infrastructure and help the company understand the current incident effects on rail network operations and how to improve the situation. PwC consultants decided to build a model of the transportation network that would simulate train movements, incidents, and customers at stations and in trains.
  • CSX Solves Railroad Operation Challenges with and without AnyLogic Rail Library
    CSX is a US railroad company that operates about 21,000 route miles (34,000 km). AnyLogic allows the railroad industry users to simulate line-of-road, terminal, and yard problems. The following three projects, completed by CSX in 2014, covered a variety of tasks that were solved using AnyLogic software.
  • Preventing “Bus Bunching” with Smart Phone Application Implementation
    In public transport, bus bunching refers to a group of two or more transit vehicles (such as buses or trains), which were scheduled to be evenly spaced running along the same route, instead running in the same location at the same time. Dave Sprogis, Volunteer Software Developer, and Data Analyst in Watertown, MA, used AnyLogic to confirm his thesis that preventing "Bus Bunching" would improve the experience of public transit bus riders.
  • Emergency Evacuation Planning: Minimizing Gridlock and Improving Public Safety
    A typical rush hour impedes the mobility of individual vehicles and significantly slows the overall flow of traffic. This phenomenon is compounded by events of mass mobilization, such as during an evacuation due to a hurricane or other event. When this occurs, traffic can reach a state of gridlock. ITS researchers sought to understand how public safety could be improved during such events by incorporating communication among a percentage of the vehicle population.
  • Supply Chain Design for Vaccine Manufacturer
    GlaxoSmithKline (GSK) was the world’s sixth largest pharmaceutical company in 2014. The company was launching a new vaccine product on a new market that needed a distribution network different from what they had before. Therefore, the company needed to design a new supply chain and align manufacturing processes with it.
  • Apparel Company Chose Location for New Distribution Center Using Simulation Modeling
    Fruit of the Loom (FOTL) is one of the largest US apparel manufacturers and marketers. The company was expanding, and the executives wanted to know if it would be beneficial, in terms of shipping costs, to add a new distribution center (DC) on the east/west coasts of the US, or to redistribute products to a pre-existing DC. The contractors decided to simulate the whole supply chain in order to visualize DC locations on a GIS map, and the supply network between them.
  • Improving Mining Outbound Logistics with Agent-Based Simulation Modeling
    One of the largest resource companies in the world, with over $80 billion in sales, decided to enter a new market. It was planning to build a new potash mine with 90% of the resources exported. They wanted to design a reliable supply chain, with a high speed of supply replenishing, and the ability to recover from natural disasters and man-made crises benefiting from such volatility. Amalgama and Goldratt companies contracted this project to design the potash mining operations and a full supply chain of outbound logistics.