wowprompt

Stock reorder point and safety stock from daily sales

Calculates when to reorder each item and how much buffer to keep, from daily sales history and supplier lead times, so a shop or warehouse stops running out of fast sellers while cash is not locked in slow ones. Use it before a busy season or whenever stockouts and overstock happen together.

A table of items with average daily sales, lead time, safety stock, reorder point and order quantity, with flags for items at risk now
The output this prompt produced, unedited.

The prompt

Constraints first

  • Use only the sales and lead times given; never assume a demand figure.
  • Show the formula once, then apply it the same way to every item.
  • Round order quantities to the supplier's pack size.
  • Mark items with fewer than 30 days of history as low confidence.

Inputs

  • Daily sales per item: [paste rows: date, SKU, item name, units sold]
  • Supplier lead time per item, normal and worst case: [e.g. 5 days, 9 days]
  • Current stock on hand and on order: [paste rows]
  • Pack size or minimum order: [e.g. cartons of 24]
  • Service level wanted: [e.g. avoid stockouts on 95 percent of days]
  • Known events ahead: [e.g. Diwali week, a sale on 1 November]

Work

  1. Average and variation of daily sales for each item.
  2. Safety stock from the variation, the lead time and the service level.
  3. Reorder point equals lead time demand plus safety stock.
  4. Adjust for the listed events and explain the change.

Output format

  1. | SKU | Avg daily sales | Lead time | Safety stock | Reorder point | Stock now | Order now? | Order quantity |
  2. Items to order today, in one list.
  3. Items carrying more than 60 days of stock.
reorder pointsafety stock calculationinventory planningstockout preventionreorder quantitylead time demand

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