Inventory Reorder Point Calculator
$7.00
Never run out of stock — or over-order. Reorder point, safety stock and order quantity for up to 20 products, from your usage and lead times.
Description
Run out of stock and you lose sales; over-order and your cash sits on a shelf. The reorder point is the stock level that tells you exactly when to order — with enough safety stock to cover the days your supplier takes to deliver. WHO IT’S FOR: Small shops, makers and resellers who hold stock. WHAT REORDER POINT AND SAFETY STOCK MEAN: Your reorder point is the stock you will use during the supplier’s lead time, plus safety stock — a buffer for days when demand is higher than usual. Safety stock grows with demand variability and with the service level you want: aiming to meet demand 95% of the time needs more buffer than 90%. The order quantity (EOQ) balances ordering costs against holding costs, so you order an amount that keeps both low. WHAT’S INSIDE: An Excel workbook with live formulas: reorder point, safety stock and EOQ for up to 20 products, with a reorder alert column. A self-contained web calculator (one HTML file, works offline in any browser) with the same maths. A worked example with known-correct answers: 10 units a day, 7-day lead time, demand variability of 3 units, 95% service level, $25 order cost, $2 holding cost → safety stock 13.1 units, reorder point 84 units, order quantity 302.1 units. A README explaining every input and output. HOW TO USE IT: Enter each product’s daily usage, lead time, demand variability and current stock. The calculator gives the reorder point and order quantity, and flags any product at or below its reorder point with a REORDER alert. LICENCE: Personal Use — one buyer, unlimited personal prints/copies; no resale, no redistribution, no sharing of files.






Reviews
There are no reviews yet.