Set inventory reorder points

Use your sales and supplier lead times to set reorder points and order quantities for your key items, so you stop running out or overbuying.

The prompt

Help me set reorder points for my inventory. I run a [TYPE OF BUSINESS].

For each key item: [item name, average units sold per week, supplier lead time in days, current stock, unit cost, minimum order quantity, shelf life if any]
[PASTE TABLE]

How many days of safety stock I want: [e.g. 7]
Cash I can tie up in inventory: [AMOUNT]

Please:
1. Calculate a reorder point for each item (average daily sales x lead time + safety stock). Show the formula.
2. Suggest an order quantity for each, considering minimums, shelf life and cash.
3. Flag items that are overstocked (more than [NUMBER] weeks of supply) and items at risk of running out now.
4. Give me a simple weekly routine for checking stock.
5. Note where seasonal demand could make these numbers wrong.

Replace every [BRACKETED] part with your own details before sending.

How to use it

Related prompts

• Compare vendor quotes side by side

  Paste several vendor quotes and get a fair side-by-side comparison of price, scope, terms and risks, plus questions to ask before you sign.

• Choose the KPIs to track every week

  Pick five to seven numbers that tell you whether your business is healthy, define each one clearly and set up a simple weekly scorecard.

• Create a meeting agenda and turn notes into action items

  Prepare a focused meeting agenda in advance, then turn rough meeting notes into decisions and action items with owners and due dates.

• Design a client intake form

  Design an intake or booking form that collects exactly what you need from new clients up front, with no unnecessary questions, in a sensible order.

More Operations prompts