De slimme voorspeller

 Het nastreven van best practices op het gebied van vraagplanning,

prognoses en voorraadoptimalisatie

Software for inventory optimization is most often used to crank out the analytical results you need to run your day-to-day business, such as Reorder Points (also known as Mins) and Order Quantities. This specialized software helps you find the sweet spot that balances inventory costs against item availability during routine operations.

Inventory optimization software can also be used to perform “what-if” analyses on scenarios that describe changes from your current operating environment. What-if analysis (also called “sensitivity analysis”) lets you elevate your thinking from the tactical to the strategic. It helps you imagine how you should change your operations to adapt to potential changes in your operating environment. These changes might be negative pressures imposed on you from the outside, or they might result from your own positive actions. In this blog, we provide an example of how to conduct “what-analysis” on lead times and order quantities.  Outputs from the analysis can be used by the business to assess the impact of these changes on inventory costs and service level performance.

How Suppliers Limit Your Freedom of Maneuver


Discussing with our customers the data inputs required by inventory optimization software, we noted that suppliers are a prominent influence on their operations. We leave aside for now such important topics as sharing demand forecasts with suppliers and working out responses to supply chain disruptions, such as Hurricane Matthew last year in the southeastern US. Instead, we focus on two more common ways that suppliers influence producers’ inventory costs: replenishment lead times and restrictions on order quantities.

Replenishment lead time is the number of days that elapse between inventory reaching or breaching a reorder point and the appearance of replenishment units in stock. Some portion of lead time is internal to the producer, perhaps due to slow reactions in a purchasing department. The rest of lead time is down to the supplier. In this discussion, we assume that suppliers’ contribution to lead times might be changed, for better or for worse. (But the same results could apply to changes in producers’ contributions to lead times.)

The restrictions on order quantities that we consider are order minima and order multiples. You might want to order 3 units of some item, but the supplier might impose a minimum order size of 6 units, so your 3 unit order would have to become a 6 unit order. Or you might want to order 21 units, handily exceeding the minimum order size of 6 units, but if the supplier also has an order multiple of 6, meaning every order must be a multiple of 6 units, then your 21 unit order would have to be increased to 24 units.

Scenario Analyses


To illustrate the use of inventory optimization software for what-if analysis, we examine two sets of scenarios. In the first set, lead times are varied from -20% to +20% of their values in a baseline scenario. In the second set, results are computed first with no supplier restrictions, then with order minima only, and finally with a combination of order minima and order multiples. We use Smart Inventory Optimization software for the calculations.

The baseline scenario uses real-world data on 2,852 spare parts managed by a progressive public transit agency. These parts have an extremely heterogeneous mix of attributes. Their per unit costs range from $1 to $23,105, and their lead times vary between 1 day and 300 days. Over 24 months, the mean demand ranged from less than 1 unit per month to 1,508 units per month, with coefficients of variation ranging from a manageable 10% to a scary 2,171%. Furthermore, the supplier picture is also very complex, involving 293 unique vendors, supplying an average of about 10 parts each. This heterogeneity implies that a real-world optimization would pick and choose among items and vendors. However, for simplicity of exposition and to develop basic insights, our what-if scenarios in this example treat every item and vendor equally. Similarly, we assumed in the baseline that holding costs equaled 20% of the dollar value of an item and that every replenishment order had a fixed cost of $40.

We conducted two what-if experiments. The first examined the effects of changing lead times. The second examined the effects of introducing restrictions on order quantities. In each experiment, we recorded the effects of the changes on two operational metrics: average number of units in stock and average number of orders per year. In turn, these influenced four financial metrics: average dollar value of inventory, average holding cost, average ordering cost, and the sum of the last two, which is total inventory operating cost.

In all scenarios, reorder points were calculated so as to achieve 95% probability of avoiding stockouts while waiting for replenishment. Order quantities, in the absence of supplier restrictions, were computed as what we call “feasible EOQ”. EOQ is the classic “economic order quantity” taught in Inventory 101; it is computed from average demand, holding cost and ordering cost. Feasible EOQ adds an additional consideration: inventory dynamics. If the reorder point is very low, it is possible for EOQ to be too small to sustain a stable, positive level of inventory. In these cases, feasible EOQ increases the order quantity above the EOQ to insure that average inventory does not go negative.

Effects of Changing Lead Times

Table 1 shows the results of changing the lead times. Working around the base case, we changed every item’s lead time by -20%, -10%, +10% and +20%.

It is no surprise that reducing lead times reduced the required level of inventory and increasing them did the opposite. Both the average number of units and the associated dollar value behaved as expected. What may be surprising is that the effects were somewhat muted, i.e., an X percent change in lead time produced a less-than-X percent response. For instance, a 20% reduction in lead time produced only a 7.9% reduction in on-hand inventory and only a 12.0% reduction in the dollar value of those units. Furthermore, the effects of reductions and increases are asymmetric: a 20% increase in lead time led to just a 7.3% increase in units (vs 7.9%) and only a 9.6% increase in inventory value (vs 12.0%).

Similar attenuated and asymmetric results held for operating costs. A 20% reduction in lead time decreased total operating costs by 7.0%, but a 20% increase in lead time caused only a 5.1% increase in operating costs.

Now consider the implications of these results for practice. In a competitive world, cost reductions on the order of 10% or even 5% are significant. This means that efforts to reduce lead times can have important payoffs. In turn, this means that efforts to streamline purchasing processes may be worth doing. Likewise, there is a case for engaging suppliers about reducing their part of lead time, possibly by sharing the savings to incentive them.


Inventory Optimization - Effects of Changing Lead Times
Table 1: Effects of changing lead times

Effect of Order Quantity Restrictions


Table 2 shows the effect of imposing supplier restrictions on order quantities. In the base case, there are no restrictions, i.e., the order minimum is 0 and the order multiple is 1, implying that any order quantity is acceptable to suppliers. Working away from the base case, we first looked at imposing an order minimum of 5 units on all items, then adding an order multiple of 5 for all items.

Forcing orders to be larger than they otherwise would be had the expected impact on the average number of units on hand, increasing it by 0.9% with only an order minimum and by 3.4% with both a minimum and a multiple. The corresponding changes in the dollar value of the inventory were more dramatic: 22.4% and 23.3%. This difference in the size of the percentage response probably traces back to the large number of low-volume/high-cost replacement parts managed by the public transit agency.

Another surprise was the net reduction in operating costs when supplier restrictions were imposed. While holding costs went up by 22.4% and 23.3% in the two what-if scenarios, the larger order quantities allowed for fewer orders per year, resulting in offsetting reductions in ordering costs of, respectively, -24.4% and -32.7%. The net impacts on operating costs were then reductions of 3.7% and 7.9%.

In general, placing restrictions on producer actions would be expected to reduce performance. So the results in these scenarios were counter-intuitive. However, the real message here is that using EOQ, or even enhanced EOQ, to set an order quantity does not give optimum results. Paradoxically, the order quantity restrictions we investigated seem to have forced order quantities closer to optimal levels.


Inventory Optimization - Effect of Order Quantity Restrictions
Table 2: Effect of order quantity restrictions



The what-if analyses shown here do not lead to universal conclusions. For instance, changing the assumed cost per order from $40 to some smaller number could show that the supplier restrictions increased rather than decreased the producer’s inventory operating costs.

When doing what-if analysis in real-word situations, users would naturally craft scenarios at a lower level of detail. For instance, they might evaluate the effect of changes in supplier lead times on a supplier-by-supplier basis to find the ones that would have the highest potential payoffs. Or they might arrange for order minima, if they exist already for all items, to change by a specified percentage instead of a fixed amount, which might be somewhat more realistic.

The key takeaway is that inventory optimization software can be used in “what-if mode” to explore strategic issues, beyond its customary use to calculate reorder points, safety stocks, order quantities, and inventory transfers.

Laat een reactie achter

gerelateerde berichten

Smart Software leidt een webinar als onderdeel van het WERC Solutions Partner Program

Smart Software leidt een webinar als onderdeel van het WERC Solutions Partner Program

Smart Software, zal een webinar van 30 minuten leiden als onderdeel van het WERC Solutions Partner Program. De presentatie zal zich richten op hoe een toonaangevend elektriciteitsbedrijf Smart Inventory Planning and Optimization (Smart IP&O) implementeerde als onderdeel van het strategische supply chain-optimalisatie-initiatief (SCO) van het bedrijf.

Bel een Audible om proactief ruis in de supply chain tegen te gaan

Bel een Audible om proactief ruis in de supply chain tegen te gaan

U kent de situatie: u berekent de beste manier om elk voorraadartikel te beheren door de juiste bestelpunten en aanvullingsdoelen te berekenen, en vervolgens de gemiddelde vraag te verhogen of te verlagen, of de volatiliteit van de vraag te veranderen, of de doorlooptijden van leveranciers te veranderen, of uw eigen kosten te veranderen .

recente berichten

  • Supply Chain Math large-scale decision-making analyticsSupply Chain Math: Don’t Bring a Knife to a Gunfight
    Math and the supply chain go hand and hand. As supply chains grow, increasing complexity will drive companies to look for ways to manage large-scale decision-making. Math is a fact of life for anyone in inventory management and demand forecasting who is hoping to remain competitive in the modern world. Read our article to learn more. […]
  • Rijpe bebaarde monteur in uniform onderzoekt de machine en repareert deze in de fabriekPlanning voor verbruiksgoederen vs. herstelbare onderdelen
    Bij het bepalen van de juiste opslagparameters voor reserve- en vervangingsonderdelen, is het belangrijk om onderscheid te maken tussen verbruiks- en repareerbare onderdelen. Deze verschillen worden vaak over het hoofd gezien door software voor voorraadplanning en kunnen resulteren in onjuiste schattingen van wat er op voorraad moet worden gehouden. Er zijn verschillende benaderingen vereist bij het plannen van verbruiksartikelen versus herstelbare artikelen. […]
  • Vier veelgemaakte fouten bij het plannen van aanvullingsdoelenVier veelgemaakte fouten bij het plannen van aanvullingsdoelen
    Hoe vaak herkalibreert u uw voorraadbeleid? Waarom? Leer hoe u belangrijke fouten kunt vermijden bij het plannen van aanvullingsdoelen door het proces te automatiseren, onderdelen opnieuw te kalibreren, targeting-prognosemethoden te gebruiken en uitzonderingen te bekijken. […]
  • Smart Software introduceert met genoegen onze serie webinars, exclusief aangeboden voor Epicor-gebruikers.Breid de prognoses en min/max-planning van Epicor Kinetic uit met Smart IP&O
    Epicor Kinetic kan de aanvulling beheren door te suggereren wat te bestellen en wanneer via op bestelpunten gebaseerd voorraadbeleid. Het probleem is dat het ERP-systeem vereist dat de gebruiker deze bestelpunten handmatig specificeert, of een rudimentaire "vuistregel"-aanpak gebruikt op basis van dagelijkse gemiddelden. In dit artikel zullen we de functionaliteit voor het bestellen van voorraad in Epicor Kinetic bespreken, de beperkingen ervan uitleggen en samenvatten hoe de voorraad kan worden verminderd en de voorraad kan worden geminimaliseerd door de robuuste voorspellende functionaliteit te bieden die ontbreekt in Epicor. […]
  • Op scenario's gebaseerde prognoses versus vergelijkingenOp scenario's gebaseerde prognoses versus vergelijkingen
    Van oudsher heeft software gediend als een leveringsvehikel voor vergelijkingen. Dit is prima, voor zover het gaat. Maar wij bij Smart Software denken dat u er beter aan doet door uw vergelijkingen in te ruilen voor scenario's. Ontdek waarom op scenario's gebaseerde planning planners helpt om risico's beter te beheren en betere resultaten te behalen. […]

    Voorraadoptimalisatie voor fabrikanten, distributeurs en MRO

    • Algemene bestellingen Slimme softwarevraag en voorraadplanning HDAlgemene bestellingen
      Onze klanten zijn geweldige docenten die ons altijd hebben geholpen de kloof tussen leerboektheorie en praktische toepassing te overbruggen. Een goed voorbeeld gebeurde meer dan twintig jaar geleden, toen we kennismaakten met het fenomeen van intermitterende vraag, dat veel voorkomt bij reserveonderdelen, maar zeldzaam is bij de afgewerkte producten die worden beheerd door onze oorspronkelijke klanten die werkzaam zijn in verkoop en marketing. Deze onthulling leidde al snel tot onze vooraanstaande positie als leveranciers van software voor het beheren van voorraden reserveonderdelen. Ons laatste stukje scholing betreft 'algemene bestellingen'. […]
    • Plaats stukken met de hand om een pijl te bouwenProbabilistische prognoses voor intermitterende vraag
      De nieuwe prognosetechnologie is afgeleid van probabilistische prognoses, een statistische methode die zowel de gemiddelde productvraag per periode als de voorraadbehoeften op het niveau van de klantenservice nauwkeurig voorspelt. […]
    • Engineering op bestelling bij Kratos Space - beschikbaarheid van onderdelen een strategisch voordeel maken
      De Kratos Space-groep binnen National Security-technologie-innovator Kratos Defense & Security Solutions, Inc., produceert COTS-software en componentproducten voor ruimtecommunicatie - waardoor de beschikbaarheid van onderdelen een strategisch voordeel wordt […]
    • houten-figuren-van-mensen-en-een-magneet-team-management-magazijninventarisBeheer van de inventaris van gepromote artikelen
      In een eerder bericht besprak ik een van de neteligere problemen waarmee vraagplanners soms worden geconfronteerd: het werken met gegevens over productvraag die worden gekenmerkt door wat statistici scheefheid noemen - een situatie die kostbare voorraadinvesteringen kan vergen. Dit soort problematische gegevens is te vinden in verschillende scenario's. In ten minste één geval, de combinatie van intermitterende vraag en zeer effectieve verkoopacties, leent het probleem zich voor een effectieve oplossing. […]