- This article introduces the dynamic safety stock calculation and reviews the current safety stock calculation explanations.
- There is a common preference for talking about the standard dynamic safety stock calculation rather than diving into its math.
Introduction to Calculating Safety Stock
This dynamic safety stock calculation article has two purposes:
- To calculate safety stock.
- To explain the logic behind the mathematics or the safety stock equation of the dynamic safety stock calculator.
Reviewing the Current Safety Stock Calculation Explanations
Before writing this article and creating this calculator I reviewed quite a few of the available safety stock calculation spreadsheets available from the Internet. I found all to be deficient in not fully explaining the formula.
- Almost every one of them asked for a service level input. They did not even explain what the definition of the service level calculation definition to be used.
- The vast majority ignored the lead time component of the formula. They only provided input for sales/forecast variability (error).
This is not a good way to explain how dynamic safety stock works. Those that left out part of safety stock calculation formulas or safety stock equation did not even explain that it was left out — giving any person who is trying to understand the entire formula a difficult time! How can one know the right for calculating safety stock without showing those assumptions?
The Preference for Talking About the Dynamic Safety Stock Rather than Diving into the Math
It seems as if many people want to talk about dynamic safety stock. No one was interested in making a clear calculator that explains calculating safety stock in clear terms.
There is a broader problem with the formula in that most of the explanations of the formula are not specific enough as to what the author is referring to.
- For instance, what is “Average Demand.” Without knowing the duration, this does not mean very much of anything.
- Is this the average over lead time, or the monthly average, the yearly average?
This safety stock calculator provides the intermediate values. It also provides explanations so that the overall logic of the dynamic safety stock calculator can be understood by both students and practitioners.
Basic Concept of Dynamic Safety Stock
The basic concept of the dynamic safety stock calculation is to adjust the safety stock per multiple factors.
Often the explanation of dynamic safety stock is that it is to adjust for both supply and demand variability — as is expressed in the graphic below:
The Uses of Dynamic Safety Stock
The nice thing about the dynamic safety stock calculation or safety stock equation is that it adjusts across the following dimensions:
- Service level
- Lead time
- Forecast error both in variability (regarding lead time and forecast error) as well as lead time duration.
Dynamic safety stock analysis can be used for an SKU or any aggregation level. For instance, this form can be used to model the inventory and supply chain of an entire company.
That is instead of entering the values for a single SKU; the average values can be used. This helps one see the relationships between things like service level and the total amount of stock carried.
This can create a service level to inventory curve. This is something that many companies do not have. It will not, of course, include the total stocking level. So the total stocking level should be estimated and added. Only the safety stock should flex — while the cycle stock should stay the same.
Using Dynamic Safety Stock in Production Systems
While dynamic safety stock is quite valuable for analysis, one of the problems with dynamic safety stock is that it will often calculate a value that companies consider too high. Typically companies will not hold this level of safety stock as is explained in this article. This is because of the fact that the standard dynamic safety stock formula in textbooks does not work, and consistently overestimates the safety stock required.
What This Calculation Is
- The standard dynamic safety stock calculator is problematic in actual usage. For this reason, I created this safety stock calculator which adopts some of the same concepts but provides more consistent output.
- Currently, the calculator does not include lead time variability. In most cases, the vast majority of variability is from the demand rather than lead time side.
How the Brightwork Safety Stock Calculation Form Works
This safety stock calculation is not the standard dynamic safety stock. It is instead of our own customized dynamic safety stock.
This form requires input to provide output. However, it also has default values. You can change any input value and the rest of the formula — the output will change immediately. You can continue making changes, and the form will always update without having to press any button or refresh. This will accurately support you in calculating safety stock.
Note: For some reason, the drop-down field below does not appear to work in Firefox – so if you are using that browser try a different one. Second, when you enter a decimal into the Standard Deviation of Demand and Standard Deviation of Lead Time, you may receive a message “Please enter only digits.” You can ignore that message. The calculator works fine with a decimal point.
For the reverse safety stock calculator sees this link.
The Necessity of Fact Checking
We ask a question that anyone working in enterprise software should ask.
Should decisions be made based on sales information from 100% financially biased parties like consulting firms, IT analysts, and vendors to companies that do not specialize in fact-checking?
If the answer is “No,” then perhaps there should be a change to the present approach to IT decision making.
In a market where inaccurate information is commonplace, our conclusion from our research is that software project problems and failures correlate to a lack of fact checking of the claims made by vendors and consulting firms. If you are worried that you don’t have the real story from your current sources, we offer the solution.
Brightwork MRP & S&OP Explorer for Safety Stock
Safety Stock Calculation
The way safety stock is set and sometimes calculated is highly imprecise and problematic. What is needed is a way of calculating safety stock dynamically that is performed in an integrated manner with both constraints and service levels. The Brightwork MRP & S&OP Explorer does exactly this, and it is free to use in the beginning until it sees “serious usage.” It is permanently free to academics and students. See by clicking the image below:
Safety Stock and Service Level Book
Important Features About Safety Stock
How Systems Set Safety Stock
The vast majority of systems allow the setting of safety stock by multiple means (static, dynamic, adjustable with the forecast in days’ supply, etc..). However, most systems do not allow the safety stock to be set in a way that is considerate of the inventory that is available to be applied.By reading this book you will:
- Understand the concepts and formula used for safety stock and service level setting.
- Common ways of setting safety stock.
- Service levels and inventory optimization applications.
- The best real ways of setting both service levels and safety stock.
Chapter 2: Safety Stock and Service Levels from a Conceptual Perspective
Chapter 3: The Common Ways of Setting Safety Stock
Chapter 4: The Common Issues with Safety Stock
Chapter 5: Common Issues with Service Level Setting
Chapter 6: Service Level Agreement
Chapter 7: Safety Stock and Service Levels in Inventory Optimization and Multi-Echelon Software
Chapter 8: A Simpler Approach to Comprehensively Setting Safety Stock and Service Levels