Archived Newsletters
Email:
info@psq.co.za

Phone:
021 557 2491


Subscribe to our Newsletters


Newsletter
 

Eliminating the Bullwhip Effect

by Sviatoslav Oliinyk
 


The bullwhip effect is one of the common problems of supply chains, affecting manufacturers, distributors, and retailers alike.

The cause of the bullwhip effect is difficult to recognize in a large, rapidly growing company. Pay attention to the symptoms. Some of the most common are inventory oscillations between stock outs and over stocks.

Such an ambivalent state of stocks does not allow the company to use its resources in full. The idea of ​​balancing the system in the those conditions seems difficult to achieve.

Let’s start the problem analysis with retail. Generally, when forecasting sales for the periods between deliveries and analyzing the accuracy of historical demand forecasts, a safety stock is calculated, which is a percentage of sales for the forecast period. In other words, as sales forecasts increase, the more errors they contain, requiring the addition of more safety stock.


Unpacking Bullwhip Effect Examples

Sales forecast for the period = 1 pallet. Safety stock = 50% of demand forecast for the period. Balance at the beginning = 0 pallets. Order quantity = sales forecast + safety stock – current stock. The order is rounded to pallets.

In the first week, we order 1+(0.5 x 1) – 0 (balance) = 1.5 pallets. But since it is necessary to place an order in multiples of a pallet, it is equal to 2 pallets. Actual sales turned out to be lower than forecast by 20% or 0.8 pallets. Balance at the end of the period: 2- 0.8 = 1.2 pallets.

In the second week, we recalculated the sales forecast. Now it is 0.8 pallets. We calculate the order again: 0.8 + (0.5 x 0.8) – 1.2 (balance) = 0. We do not place an order. The current stocks will cover the projected sales and forecast error. But actual sales appeared higher than forecast, and we sold 1.2 pallets.

In the third week we’ll order 2 pallets again.

How accurate are your forecasts? Obviously, the scale of the problem is far beyond the issue with the forecast.

If the company is just starting to work on the forecast, then by improving the accuracy of the forecast, it’s possible to slightly reduce the level of safety stocks. The management then sets the goal to improve the forecast constantly. But the fact is that improvement has its own limits and feasibility. If the cost of calculating the forecast exceeds the profit, then it becomes useless.

But, even if the goal is achieved, after increasing the accuracy of the forecast, there remains a “system error” of multiplying sales fluctuations further down the supply chain. This approach may show improvement but does not solve the original problem.

Let’s consider how this affects the distributor who receives our orders (2, 0, and then 2 pallets). Naturally, the distributor has many retailers. The order logic remains the same for everyone. A company must keep much more stock as fluctuation amplitude is bigger (e.g. from 0 to 30 pallets).

As it’s known from the previous example, an order from a distributor is not exactly a demand. Rather, it is a rough estimate of future sales, distorted by the conditions of purchase and incorrect purchases in the past.

In order to cover such fluctuations in demand, the manufacturer needs to constantly store at least 30 pallets of goods, since it is not known when and what amount is going to be an order from the distributor. It must be considered that manufacturers have dozens, or even hundreds of such customers.

In addition, it is impossible to produce 30 pallets at any time, since the manufacturer has its own limitations that cannot be ignored. For example, equipment capacity, scheduling intervals, optimal order quantity, long lead times, sequencing constraints, etc.

If the minimum manufacturing batch is 100 pallets, then the manufacturer will keep a stock from 0 to 100 pallets.

After the production of this batch size, the stock of products becomes more than needed. In this case, within a few weeks of the planning horizon, as a rule, something will not go according to plan. An urgent order will appear from the sales department, equipment will break down, there will be an unexpected peak in demand for one of the manufactured products, etc. Any event like that will shift the production schedule. There is a high probability that when the manufacturer receives an order from distributors, the products will not be produced in time. Therefore, the manufacturer, as well as the retailer, will increase its safety stocks, which will lead to an additional increase in orders and lengthening the periods of no orders, which means that information about real demand will be distorted even more.

As a result, a “bullwhip effect” will appear in the supply chain. This is a situation when even the smallest deviations and fluctuations in the supply chain lead to uncontrolled significant changes on its other end.

Perhaps the example of stock fluctuations in the retailer-distributor-manufacturer supply chain seems overly simplified. Below is a graph of a FMCG product with stable demand.



A high level of inventory is needed to smooth out acute problems and create the illusion of reliability. But it does not solve the problem of stock fluctuations from artificially high levels to shortages since this is a natural consequence of planning on distorted information.

The bullwhip effect is an old phenomenon. Earlier it was believed that the problem would be solved with powerful computing technology, which would allow storing and processing large amounts of data. Despite the fact that today we have many tools for processing and storing data, the problem has not gone away but, on the contrary, has even worsened. Product variety is growing, the life cycle is decreasing, the variability of demand is less and less predictable. It becomes obvious that we need to radically revise the approach to supply chain management. This is what the DDMRP methodology can solve.

Eliminate the Bullwhip Effect with DDMRP


The key inventory management tool in DDMRP is the buffer. The buffer consists of 3 zones: red, yellow and green. Each zone has its own purpose and calculation logic.

The red zone is a flow safety and is designed to protect against variability.

The yellow zone is a “cycle stock” that provides consumption for the replenishment time.

The green zone is a flow controller. It includes all sorts of logistical restrictions and determines the average order and how often it will be generated. And all together they make up a buffer.


The graph shows the fluctuation of the information flow (Average Net Flow Range), which is responsible for the information transfer further along the supply chain without distortion.

At the bottom of the yellow zone, the physical flow will fluctuate by the size of the green zone (Average on Hand Inventory Range). Thus, the system is initially set up to allow neither stock outs nor over stocks. Using a buffer according to this methodology helps all links of the supply chain to manage even drastic variations in demand. It also provides an opportunity to balance orders and make them regular.


The graph shows how the distribution of inventory levels looks before and after the use of the methodology. On its left side we see a bimodal distribution of stocks as described at the beginning of the article. There is either too much or too little. Having the optimal stock level is an exception to the rule. The right side of the graph shows that there can be stock outs and over stocks, but most are in the optimal range.

In summary, no matter where your company is in the supply chain, the “bullwhip effect” affects everyone. The supply chain needs to be balanced. The DDMRP methodology will help to cope with this problem.

Get in Touch

For more information, contact Colin Seftel.


About the Author
Sviatoslav Oliinyk is the co-founder of Representative office of Demand Driven Institute in CIS region, business trainer and supply chain management consultant at ABM Cloud. Experienced in business process re-engineering, project management using Lean, 6 Sigma and TOC in retail, distribution and production. Certified expert in Innovative Solutions for Supply Chain optimization, specialized in DDMRP methodology education and implementation. Author of various case studies and business media publications, event speaker, founder and coordinator of business training clubs, practicing expert in corporate culture development, coaching, team building.



Copyright © 2022 PSQ