OrdersmithyFree toolsReorder Point CalculatorDownload
Free · Download

Your download is starting

Check your downloads folder. If nothing happens in a few seconds, use the button below.

Ordersmithy_Reorder_Point_Calculator.xlsx89 KB · Excel 2010 or later, Google Sheets, LibreOffice Download again

While it downloads

Three steps to your first answer

  1. 1

    Open it

    Double-click to open in Excel, or upload it to Google Drive and open with Google Sheets.

  2. 2

    Replace the sample

    Delete the sample products and type yours: lead time, stock on hand, and monthly sales.

  3. 3

    Filter by status

    Show only “Order now” and “Out of stock”. That's today's purchase list, with quantities.

New to the formulas? How to calculate a reorder point · Safety stock, four formulas compared

When you're ready for more

The Inventory Control Kit

This calculator plus ABC-XYZ, dead and excess stock, a supplier scorecard with real lead times, a purchase plan and PO drafts — one workbook, up to 500 products. One-time $39.

See the kit — $39 Free: Open PO Health Check