You can set Excel or Google Sheets so that cells turn red when they hit a reorder point. This will effectively warn you when you need to start on a new purchase order. You can also set up a formula somewhere in your inventory list with the reorder point formula, so you can make quick calculations for your products individually. When the quantity on hand for Ghost glasses hits 38, Archon Optical knows to place a purchase order for more.

• When the quantity on hand for Ghost glasses hits 38, Archon Optical knows to place a purchase order for more.
• If you’re dealing with a product that has a shelf life, you should consider changing safety stock levels to days rather than weeks.
• You can set Excel or Google Sheets so that cells turn red when they hit a reorder point.
• For example, maybe you saw a random spike in your sales numbers, or there was an extreme delay in delivery times due to unforeseen circumstances.
• Unlike spreadsheets, inFlow was designed specifically for working with inventory.
• Quantity and reorder point fields are built into the software, which saves our customers a lot of setup time.

How to calculate safety stock quickly

InFlow has a Reorder Stock window, which identifies which products need reordering, and creates new purchase orders with just one click. If we total those numbers, we get 180 total units sold over the past 90 days. Something to note—reorder points are great, but they’re just one part of a much larger picture. For well-rounded inventory management, you should bookkeeping and payroll services also consider implementing things like cycle counts and barcodes.

Reorder faster with inFlow

• Safety stock is a surplus of products your business would keep in case of an emergency.
• First, multiply the maximum number of daily orders by the maximum lead time.
• InFlow has a Recommended Reorder Point report that examines your sales data and recommends reorder points for your products.
• For well-rounded inventory management, you should also consider implementing things like cycle counts and barcodes.
• Delivery times can vary based on your order quantity (larger orders could take longer to ship).
• Something to note—reorder points are great, but they’re just one part of a much larger picture.
• Another component of the reorder point formula you’ll need is the average delivery lead time.

Because they’ve built an average delivery lead time into the reorder point, the extra Ghost glasses should arrive before Archon dips into their safety stock. Reorder points are vital to keeping your business running smoothly, but they’ll only work if you’re prepared to reorder on time. You can setup a formula somewhere in your inventory list with the reorder point formula, so you can make quick calculations for your products individually. When you calculate a product reorder point, you’ll need to account for safety stock.

Setup reorder points in a spreadsheet

You can get more granular when calculating your safety stock, but here is a simplified way. First, multiply the maximum number of daily orders by the maximum lead time. A reorder point is based on your purchase and sales cycles and varies by product. However, once you have a handle on the inventory turnover patterns of a product, you’re ready to start putting the variables together. Unlike spreadsheets, inFlow was designed specifically for working with inventory. Quantity and reorder point fields are built into the software, which saves our customers a lot of setup time.

• You can get more granular when calculating your safety stock, but here is a simplified way.
• When you decide on a safety stock level, you’ll want to consider average daily sales and the daily average you use the product in work orders (if applicable).
• Reorder points are vital to keeping your business running smoothly, but they’ll only work if you’re prepared to reorder on time.
• InFlow has a Reorder Stock window, which identifies which products need reordering, and creates new purchase orders with just one click.

The reorder point formula video

If you’re dealing with a product that has a shelf life, you should consider changing safety stock levels to days rather than weeks. Check out this short clip from our new contra asset account podcast for a quick rundown of reorder points and safety stock and their importance in inventory management. InFlow has a Recommended Reorder Point report that examines your sales data and recommends reorder points for your products. It also factors in goods in transit (GIT), which are products that have been ordered from a vendor but haven’t been received yet.

Safety stock is a surplus of products your business would keep in case of an emergency. For example, maybe you saw a random spike in your sales numbers, or there was an extreme delay in delivery times due to unforeseen circumstances. Add the total delivery time (15 days ) and divide it by the number of orders (3). When you decide on a safety stock level, you’ll want to consider average daily sales and the daily average you use the product in work orders (if applicable). Whether you’ve just started a new business or sold products for years, anyone can benefit from using the reorder point formula. This post will show you what that is, why it’s useful, and which numbers you’ll need to generate a reorder point.