Published 06-08-2020
| Article appears in August 2020 Issue



One unusual side effect of the COVID-19 pandemic has been panic buying, which began in March amid talk of self-isolation and lockdowns.

As a result, March saw retail trade surge by 8.5 per cent according to the ABS; the rise was the strongest charted by the ABS since it began tracking retail trade.

While the panic buying saw empty shelves in supermarkets across the country, 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 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 to avoid stockouts.

Stockouts stem from factors such as fluctuating customer demand, as we’ve seen during the pandemic, forecast inaccuracy, and variability in lead times for raw materials or manufacturing.

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,” Martins says.

“And how to determine the appropriate levels.”

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 per cent.

While they are easy to execute, these techniques generally result in poor performance or leave you with other stock management issues.

The food and beverage industry can pose unique challenges for inventory management such as spoilage, seasonality and volatile customer 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 rationalise the required levels of inventory to the business while balancing the need to deliver on customer service and minimising costs of higher stock on hand levels.

So it’s 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 into account seasonality, trends, cost of production and carrying costs.

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. If you set a product to have five days of supply, expect the safety stock to be equal to the sum of the next five 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 – 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 benefits 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 the software suite, the team at Nukon made sure safety days of supply was one of the features.

TilliT Planner can draw on 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 customisable as well, solving a number of complex supply chain problems.


  1. A worthy nomination for the Hunter Manufacturing Awards, Central Coast-based 4id Solutions opens the door to the true potential of the connected world, delivering leading-edge technologies that enable customers to track, trace, and protect important assets.
    The Hunter Manufacturing Awards (HMA)...
  2. With customers increasingly requesting simulation as part of the tender process, engineering company Products for Industry (PFi) has realised significant benefits through the use of digital twin visualisation software.
    Based in Queensland, PFi is a locally owned and operated business servicing the...
  3. RS Components have introduced FlexiPay+, a rent-to-own platform that will be available to selected customers across AUS & NZ. This solution will allow approved businesses to access a huge range of products from leading global suppliers.
    The introduction of FlexiPay+ comes after the recognition...