wowprompt

Inventory reorder plan with reorder points and safety stock

A reorder table for each product with daily sales rate, lead time, safety stock, reorder point, and suggested order quantity, plus festive season adjustments. Use it to avoid running out of best sellers or overbuying slow stock before a peak.

An inventory table showing each product's sales rate, lead time, safety stock, reorder point, current stock and a buy-now flag
The output this prompt produced, unedited.

The prompt

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

  1. Average daily sales = units sold in 30 days divided by 30
  2. Safety stock = average daily sales multiplied by half the lead time, unless sales are very uneven, then use the full lead time
  3. Reorder point = average daily sales multiplied by lead time, plus safety stock
  4. Order quantity = enough to cover lead time plus 30 days, rounded up to the minimum order quantity
  5. 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.
inventory reorder pointsafety stock calculationstock planninginventory managementecommerce restock plan

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity