How to Calculate Safety Stock

Save

Safety stock is a term in inventory management that stands for an amount of product ordered to account for a variety in consumer demand. When inventory is ordered, it is important to minimize the difference between the demand for your product and the amount of product you have, both in stock and on order. Therefore, an equation can be used to determine what a reasonable amount of safety stock should be ordered in addition to the quantity needed to maintain a base stock level. Below are instructions to calculate the safety stock on paper once you know all your variables, and a link to a safety stock calculator in Microsoft Excel.

Things You'll Need

  • Scientific calculator
  • Lookup table

How to Calculate a Standard Loss Function

  • Before you can calculate your safety stock, you must determine the standard loss function. Subtract the desired fill rate from 1.

  • Multiply this sum by the demand, which is the amount of items that will be consumed or bought.

  • Multiply this sum by the time between orders. Write this sum down and set aside.

  • Add the time between orders (from Step 3) with the lead time. This is the time between your reorder decision and renewed availability.

  • Take this sum to the 1/2 power.

  • Multiply this sum by the standard deviation. See the Resources section below for steps to calculate the standard deviation.

  • Divide the sum from Step 3 by the sum from Step 6. This is the standard loss function.

How to Calculate Safety Stock

  • Refer to a lookup table and determine what the variable "z" for the standard loss function is.

  • Take the sum from Step 5 in the previous section (which is the time between orders plus the lead replenishment time taken to the 1/2 power) and multiply it by the standard deviation.

  • Multiply the sum with variable "z" found in Step 1.

  • This sum is the safety stock.

References

Promoted By Zergnet

Comments

Resources

You May Also Like

  • What Is Safety Stock?

    Safety stock is the amount of overproduction held by a company to cover scheduled deliveries, delays in receiving new stock for production,...

  • How to Calculate a Moving Average in Excel

    A moving average is a statistic used to analyze parts of a large data set over a period of time. It is...

  • How to Calculate EOQ

    Just in time, total quality management and total cost of ownership are just a few of the myriad ways manufacturing companies have...

  • How to Calculate Unsystematic Risk

    Unsystematic risk refers to the organization risk that is inherent in an investment. The unsystematic risk is different for each investment for...

  • How to Calculate Lead Time

    Understanding the lead time required for your business to produce a product or prepare for a service is key to providing accurate...

  • How to Calculate Stock Index

    There are two major ways that stock indexes are calculated. One form of calculation is called a price-weighted index. The Dow Jones...

  • How to Calculate Reorder Quantity

    Reorder quantity is the point at which a business must buy more inventory so as to not run out during production. If...

  • How to Calculate Buffer Stock

    In some economic situations, like inelastic demand and variable supply, average prices can be maintained by holding a commodity. This is called...

  • How to Calculate Paper Stock Consistency

    Consistency is the term used within the pulping and paper making Industries to describe the dry solid content of a wood pulp...

  • How to Calculate a Required Inventory Level

    Inventory is the lifeblood of retails stores. Through the sale of goods, businesses earn profits that pay for operations and the salaries....

  • How to Calculate Safety Inventory

    The safety level of inventory is a specific dollar amount a company has at all times to meet consumer demand. Numerous methods...

Related Searches

Check It Out

Are You Really Getting A Deal From Discount Stores?

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!