wareliumtoolsImport SKU demand, lead times, stock, open orders and backorders. Calculate reorder points and pack-rounded suggested orders with MOQ; export a local CSV.
Review one proposed order per SKU before you buy.
Synthetic example · click Create plan. Up to 2,000 rows; XLSX first worksheet, 5 MB file limit. Data stays in your browser.
Share the tool address. Your entered values are not included.
Inventory position = on-hand + on-order − backorders. Reorder point = daily demand × lead days + safety stock. Target = daily demand × (lead + review days) + safety stock. A position at or below the point triggers review; only a positive target shortage creates an order.
Suggested order rounds the larger of shortage and MOQ up to a full pack. MOQ does not create a purchase above the trigger. Open orders are assumed usable; the tool does not time-phase receipts or forecast demand.
Use the template’s eleven headers and one row per SKU. Demand may have up to six decimals; other quantities, lead/review days and packs are whole numbers. Lead 1–365 days; review 0–365 days. Do not add quantities from unlike units together.
Read the reorder planning workflowIllustrative inputs and outputs to help you check your own task.
The 52-unit shortage rounds up to five packs. Review incoming dates before ordering.
MOQ does not create an order when stock is above the reorder point.
Try the free Excel sample for product setup, stock balances and pack-rounded reorder suggestions. The full AUD29 kit adds the overview and stocktake, with 200 product rows and 2,000 movement rows.
No email required. The sample is a working file with synthetic data. The full kit is a blank template; applicable taxes are included in AUD29.
These tools run in your browser. They do not upload your entries or store them after you leave. Downloads are created on your device. Hosting providers may process standard access logs.