Fill in these first
- Products: [name, current stock, units sold in the last 30 days, supplier lead time in days]
- Minimum order quantity per supplier: [details]
- Upcoming peak and expected lift: [for example Diwali sale, sales up 2.5 times for 10 days]
- Cash available for stock this month: [amount and currency]
- Storage limit, if any: [units or space]
Task
Work out when and how much to reorder for each product, and flag what to buy now.
Method
- Average daily sales = units sold in 30 days divided by 30
- Safety stock = average daily sales multiplied by half the lead time, unless sales are very uneven, then use the full lead time
- Reorder point = average daily sales multiplied by lead time, plus safety stock
- Order quantity = enough to cover lead time plus 30 days, rounded up to the minimum order quantity
- Apply the peak lift only to days that fall inside the peak
Output format
| Product | Daily sales | Lead time | Safety stock | Reorder point | Current stock | Buy now? | Order quantity | Cost |
Then:
- Buy-now list sorted by days of stock left
- Total cost against the cash available, and what to drop or delay if it does not fit
- Slow movers with more than 90 days of stock
Quality rules
- Show each calculation for the first product so the method can be checked.
- Round units up, never down.
- Treat these as estimates; note that real figures should be checked against recent sales before ordering.






