🇺🇸
Upload your Excel or CSV file with sales data and lead times to automatically calculate the Reorder Point, Safety Stock and insights by product.
Most supply chain teams calculate the reorder point in their own Excel. Row by row, SKU by SKU. And for a while, it works. The problem comes when you have 300 references with different lead times, variable demand and three suppliers that don't deliver within the same deadlines as the contract says. Problems accumulate, emergencies arise and calculating it manually becomes a burden that can lead to errors.
For that, we created this calculator, it saves manual work time and advances your daily operations in an agile way. You upload your file with sales and lead times data, you map the columns once, and in seconds you have the reorder point, safety stock and replacement alerts for each product.
You need an Excel (.xlsx, .xls) or CSV file with at least these four columns:
Optionally you can include Actual_Stock And Inventory_Transit. If you include them, the tool tells you exactly how many units you need to order today, not just when you should start to worry.
You can upload the file directly or copy the range from Google Sheets or Excel and paste it with the “Paste table” button. The headers must be included in the selection.
When uploading the file, The calculator should automatically detect the columns and connect them to the variables you need for the calculation. If the names don't exactly match the example, you can reassign them from the selectors. When all the columns are correctly assigned, the confirmation “All columns detected!” appears and you can continue.
When you calculate, for each SKU in your file, a card is generated with all indicators. The results are updated in real time if you modify the stock or inventory values in transit directly in the tool, allowing you to test quick scenarios without reloading the file.
The inventory level at which you have to place a new purchase order so you don't run out of stock for the time it takes for the replenishment to arrive. It is expressed in units.
The mattress that protects your operation against variations in demand or in the supplier's delivery time. It is calculated as the difference between the maximum demand scenario with maximum lead time and the average scenario. It's not a conservative or aggressive estimate: it's the real delta between your reasonable worst case and your base case.
The average daily demand calculated from your historical data. It is the basis for calculating the ROP.
The average replenishment days used in the calculation, as you uploaded them to your file.
How many days of sale does your current stock cover at the current demand rate. Useful for prioritizing: Not all products with alerts are equally urgent, and this indicator tells you who has the tightest margin.
Each SKU is qualitatively classified according to the relationship between safety stock and ROP:
The tool calculates if you need to reorder now and by how many units:
Quantity to reorder = ROP − Current stock − Inventory in transit
If the result is positive, an orange alert appears with the exact amount. If you have sufficient coverage, the card shows a green confirmation. And for transparency, each card includes the full breakdown of the calculation with the real numbers of that SKU, so you can verify it or explain it to whoever needs to approve it without having to open anything in Excel.
So that the numbers are not left in the abstract, here is a case with data from an auto parts distributor:
The full analysis took less than 60 seconds since the file was uploaded. The most urgent product is DOT4 Brake Fluid: 7 days of coverage with a lead time of 5. Minimum margin. Any supplier delay or a three-day peak in demand puts you in bankruptcy. It's exactly the kind of situation that goes unnoticed when you check the inventory above.
You should keep in mind that the calculator processes data with constraints of model assumptions, before making decisions with this information, you must take this into account.
For a good result you need good data. A lead time agreed with the supplier only with words, without anyone having checked with the real history produces an underestimated ROP. We recommend that you use the average lead time of the last actual deliveries, not what the contract says.
The analysis period is important. Thirty days of off-season data doesn't capture the variability of a seasonal product. For references with marked peaks, you either calculate the ROP per season or use the period of highest demand as a conservative basis.
The model assumes stable SKUs. For SKUs with highly volatile demand, the safety stock calculated by maximums may fall short or be excessive. In those cases, use the calculator as an order of magnitude reference and adjust for operational criteria.
Inventory in transit discounts the need for reorder. If you have orders on the way, include them in the Inventory_Transit column. The tool discounts them from the calculation to avoid overbuying. If you omit them, the system will ask you to reorder units that are already en route.
This calculator solves a specific problem well: calculating the ROP for any volume of SKUs in seconds, with traceability of the calculation and without relying on an Excel sheet that only the person who built it understands.
The reorder point is a part of the system, not the entire system. For operations that require automatic replenishment, integration with ERP, demand planning, or inventory analysis by location, Datup offers a complete Supply Chain Analytics system powered by AI. If you want to see it working with the real data of your operation, you can schedule a live demo with the team.
