Posted By
Blog Categories

Calculating Safety Stock Is the Key to Minimizing Supply Chain Risk

PostedThursday, August 13,2020 at 2:47 PM

Calculating Safety Stock Is the Key to Minimizing Supply Chain Risk

The retail surge of March saw a rise of 8.5% in retail trade according to the ABS, the strongest rise since it began tracking retail trade. Whilst the panic buying saw empty shelves in supermarkets across Australia, what often goes unseen are the Australian manufacturers behind the scenes struggling to fill this unprecedented demand.

“Determining appropriate inventory levels is one of the most important and most challenging tasks faced by supply chain managers,” says Levi Martins, SAGE Group company Nukon’s senior consultant and support lead.

“If you carry too much inventory, you tie up money in working capital and risk writing off perishable goods; if you don’t carry enough inventory, you face stockouts.”

What Is Safety Stock?

In any supply chain planning, safety stock (sometimes known as buffer stock) is extra stock to cover demand or supply variability and avoid stockouts.

Stockouts stem from factors such as:

  • fluctuating customer demand, as we’ve seen during the pandemic
  • forecast inaccuracy
  • variability in lead times for raw materials or manufacturing

Having adequate safety stock levels enables business operations to continue production according to their plans.

Think of safety stock as serving as a type of insurance against unplanned supply chain events. For example, a supplier may deliver their product late, the warehouse may be understaffed or items may be received that are below the usual level of quality.

There’s also the chance that a competitor may be sold out on a product line, which leads to increasing demand for your own product.

“The cycle stock portion of the inventory equation might be straightforward. But what really keeps people up at night is safety stock, and how to determine the appropriate levels,” says Levi. 

Safety stock enables organizations to satisfy customer demand in the event of these variables.

Panic buying during March and April 2020 saw many manufacturers facing high levels of variables, forcing rapid changes to the planning process to meet increased demand.

Some operations managers rely on gut feelings or hunches to set safety stock levels, while others base them on a portion of cycle stock levels — such as 15 or 25 percent. While they are easy to execute, these techniques generally result in poor performance or lead to other stock management issues.

The food and beverage industry can pose unique challenges for inventory management such as spoilage, seasonality and volatile consumer demand.

Perishable products make the game even more challenging because they are particularly susceptible to spoilage, especially if there are improper storage conditions.

Safety stock determinations are not intended to eliminate all stockouts — but they can reduce many of them. While designing for a higher service level would result in fewer stockouts, this requires significantly more safety stock.

There must be a balance between inventory costs and customer service. By using different methods and equations, you can still find safety stock levels that help you achieve your desired customer service levels.

Safety Days of Supply

Being profitable in these scenarios is reliant on the proper management of inventory, and this is where supply chain planners are the behind-the-scenes rock stars.

Using a formulaic approach to safety stock helps rationalize the required levels of inventory to the business, while balancing the need to deliver on customer service and minimizing costs of higher stock-on-hand levels.

So, its obvious planners and decision makers need to be on the same page when it comes to inventory policy. Inventory issues are one of the biggest problems impacting profitability in manufacturing.

Developing production plans by simply dividing annual demand by the number of forecast periods has been the approach for many food and beverage companies, but this doesn’t take seasonality, trends, cost of production and carrying costs into account.

Other companies will base their figures on "safety days of supply” (or safety coverage). The days of supply refers to the number of days of demand that your safety stock can service. The days of supply may include the inventory held to satisfy certain and uncertain demands.

To calculate how much you should produce or purchase against safety days of supply, you need to sum the projected demand for the next “safety days” number of days. So, if you set a product to have 5 days of supply, expect the safety stock to be equal to the sum of the next 5 days of demand.

Once you’ve set a safety days coverage, you should also calculate your number of days of supply. This is calculated against your current holdings, asking the question “If I didn’t receive any other supply, how many days would I have before running out of stock?”

Sadly, Excel (which is the number one tool used by supply chain planners) doesn’t have the simplest formulas to calculate safety days or days’ supply. This means planners tend to use static approximate safety stock calculations, since this is what they can produce in a spreadsheet.

Supply chain planners need an easy-to-use system that can perform the calculations quickly and generate credible results. The results of having an effective system, combined with the forecasting and planning knowledge within your team are significant.

Improving the Supply Chain Planning Process

One way to simplify the process around safety stock and general stock planning is to use the right tools. That way, you can not only stay on top of planning, but take advantage of other features to fine-tune your forecasting.

The biggest benefit of having a tool for supply chain planning, among other features, is being able to clearly see the stock levels and quickly calculating safety days in one application.

SAGE Group company Nukon have a number of clients who already use their advanced planning solution called TilliT Planner to address their production planning challenges. When developing this part of software suite, the team at Nukon made sure safety days of supply was one of the features.

TilliT Planner can draw on the real-time existing stock levels and customer demand to calculate the correct stock you will need to be covered. All calculations are made for you, instead of having to refer to multiple spreadsheets and formulas. TilliT Planner has been developed to be customizable as well, solving a number of complex supply chain problems.