Author: Vincent Brunelle

  • Risk-Based Safety Stock: A Definitive Approach

    Risk-Based Safety Stock: A Definitive Approach

    In a world dominated by giants like Amazon, it’s increasingly critical for brick-and-mortar retailers to meet customer demands as quickly as possible. One way to achieve this is by ensuring that stock is readily available; otherwise, customers may turn to competitors. Deciding how much stock to keep on the floor is crucial and likely at the heart of a retailer’s operations. In this article, we’ll focus on the importance of considering safety stock determination as a risk mitigation analysis measure.

    A General Risk Analysis

    The first step in risk management analysis is simply identifying the risk. For retailers, the risk corresponds to running out of stock.

    Suppose you’re a company that manages operations very well, always orders on time, and has perfect inventory tracking. Let’s go even further: your minimum stock always matches your sales forecasts over your replenishment lead time. Well, guess what? That’s not enough to prevent you from occasionally running out of stock! It’s normal; inventory shortages are subject to random variables beyond your control. See where I’m going?

    Why do we run out of stock, you ask? There are two main causes, each requiring specific management:

    • Cause 1: Actual sales during the replenishment lead time exceeded expectations. This is a good problem to have but still carries a significant opportunity cost.
    • Cause 2: The replenishment delivery lead time was longer than promised.

    These are the only two causes I’ve observed. We’ll discuss possible mitigation measures in the following sections.

    Cause 1: Sales Were Higher Than Expected

    Why were sales higher than forecasted? The answer is simple: you’ll never achieve perfect forecasting. Of course, it’s always better to make higher-quality forecasts, but regardless of the reason, if there’s always a discrepancy between actual and forecasted sales, it indicates an inherent difficulty in making perfect predictions, and this difficulty is measurable. To protect against this, you should establish a safety stock.

    In this case, your reorder point should equal your sales forecast over the lead time plus what we call the safety stock (yes, using the well-known formula that accounts for the desired service level and your forecast error).

    Cause 2: Replenishment Lead Time Was Longer Than Expected

    Similar to Cause 1, this is again a variable dependent on the predictability of delivery lead time. Even with forecasts based on a specific lead time, if the duration of that lead time changes, the next replenishment might not arrive on time.

    You can probably see where this is going: we need to measure this unpredictability and convert it into the number of additional units to keep in stock. The conversion is straightforward: we transition from coverage in days to quantity. At this point, we take the sales forecast we plan to make over the coverage period to convert.

    You can follow the same approach as in the previous section and apply it to delivery lead times once all coverage components have been converted into quantities.

    Discussion

    From a practical standpoint, I’ve often been told that considering safety stock as a risk analysis approach is more burdensome than simply determining a desired coverage between replenishments, or just setting a fixed quantity as safety stock.

    The reasoning behind those who prefer these methods is simple: they claim they don’t really have the time (according to them) to manage the system’s deviations. To that, I respond that the system might be poorly tuned if they’re making such statements. It’s easier to input a coverage duration that’s a bit longer than the lead time. There’s only one figure to enter per product, which makes it easy for them to feel in control. Additionally, if sales are higher, the safety stock will also be higher, which is easy to explain, because sales are often easier to consult than sales forecast deviations. To those who bring up this argument, I reply that in a well-tuned system, they also have only one parameter per product (in our case, the desired level of confidence).

    However, the compelling argument I would give them isn’t related to ease of management. In fact, I would argue that a client using methods based on arbitrary coverage lacks information, namely whether the coverage entered is sufficient for the most problematic and hardest-to-forecast situations. I’ve often been given the example of products that are only sold on special order (typically large ones). These are the types of products that are difficult to forecast because the forecasted sales volume is low compared to the volume of confirmed sales. Let’s say it’s product A in the ABC class, because you can’t do without a sale. It’s highly likely that this product is hard to forecast. We don’t know when the exceptional sale will occur, but we know we are always at risk. So, what do we do in this case? We simply increase our reserves, which comes down to measuring our level of uncertainty regarding the sales forecasts and linking that information to our desired service level for that product. This approach is somewhat of a catch-all method, which helps identify products that need the most attention by applying the same rule to everyone.

    Conclusion

    This article has attempted to convince you that determining safety stock should be part of a risk management approach, and the risk in question is the risk of running out of stock when the customer is ready to buy your product. Two tools that help measure and address this risk have been presented: one to mitigate the risk of selling more stock than expected, and the other to protect against uncertainties in delivery time.

  • The Infamous Murphy’s Law

    The Infamous Murphy’s Law

    You’ve probably heard of Murphy’s Law. Phrases like “Of course, something always happens to me—it’s Murphy’s Law” or “If it can happen, it will happen” are ones you’ve certainly encountered. Naturally, Murphy’s Law is popular, but not for the right reasons.​

    That’s a problem—let’s talk about it.

    Most people see Murphy’s Law as a cosmic and magical force imposed upon them to ruin their lives. So much so that one might say people turn this law into a belief. Do you believe in this divine force that makes your life so miserable?​

    I dare to say that Murphy’s Law is actually beneficial. And I don’t mean that in a morbid or defeatist sense; in fact, I thank Mr. Murphy because it makes me see the world differently.​

    Let me explain. All the negativity surrounding this phenomenon stems from a lack of familiarity with it. Most pessimists have a very poor interpretation of this law. But what exactly is Murphy’s Law? It’s simply an extension of the law of large numbers, suggesting that the more a random phenomenon occurs, the greater the variety of observations you’ll see. Thus, you’ll have more chances to see the best scenario, but also—and especially—the worst.​

    Do you see the nuance?​

    Take, for example, a cyclist who commutes to work every day. The more often the cyclist does this, the more likely they are to encounter different things on their route. It could be seeing a cat, noticing flowers in the trees, maneuvering around different parked cars, catching a green light—or not. One can imagine an infinite number of scenarios.​

    Now, imagine this cyclist does it even more frequently. Over their lifetime, the cyclist will have experienced a greater variety of events while cycling. They might have ridden through rain, sunshine, and perhaps even had the best day of their life. But the time they had an accident that rendered them quadriplegic for the rest of their days could also happen—and coincidentally, that would be the last time.​

    Generally, people are already prepared to endure the consequences of the best-case scenario. It’s when the worst-case scenario occurs that it’s important in this case. And that’s what deserves the attention of this law.​vbrunelle.dev

    Murphy’s Law is a warning. If you don’t control the variability or the number of experiences, then you increase your chances of the worst-case scenario happening to you. And by the way, this worst-case scenario could very well be your last.​vbrunelle.dev

    You see, why do airplanes so rarely fall from the sky? Why do we hardly ever hear about a pharmaceutical company making a dosage error in a pill? For airplanes, there are thousands of different flights every day. The number of pills produced by the pharmaceutical industry is also enormous. How do they avoid making headlines every week?​

    The answer lies in risk management. These companies are well aware of the effects of Murphy’s Law and employ risk management principles—typically prevention and risk acceptance. Murphy’s Law calls for a precautionary exercise that may seem excessive but is necessary in most cases.​

    Personally, I use Murphy’s Law as an excellent excuse to perform sound risk management. When I tell my clients that I must be wary of the effects of Murphy’s Law, they often look at me with wide eyes, but once explained, it’s easily understood. Whether it’s to assess the long-term effects of a change in a program I’m developing or when it’s time to decide whether I should perform a maneuver on a bike.​

    Another surprising opinion: you can make Murphy’s Law work in your favor. Let me explain. If you’re conducting regression tests, make sure your sample is large enough to cover all cases, including the worst and least frequent. Does that ring a bell? In this case, Murphy’s Law will be of great help and will work in your favor.​

    I invite you, dear readers, to respect Murphy’s Law, because the worst-case scenario must not happen to you. And when the best-case scenario happens to you, please, recognize it and enjoy it!