PROMPT BRO
Purchase desk

Reorder suggestions from consumption and lead time

Out of stock of the one thing needed today

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

By handGut feel
With AI30 min
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get consumption and stock figures

Use SKU, average daily use, lead days, safety stock and available stock. Confirm all values and units.

First time? Try it on fake data first:

Privacy Remove bank account numbers, PAN, personal phone numbers and emails. Use vendor business names or codes, item codes and approved commercial details.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
reorder.xlsx

Approved rule: [Approved rule] As on: [As on] I'm attaching reorder.xlsx. A. Calculate level and shortage per SKU; hold missing or negative inputs. B. Count below level and held, list proposed quantities; no order or assumed pack sizes. C. Questions to check demand, lead time and physical stock. For a held row (for example a unit mismatch or missing count), do not state a converted, implied or indicative quantity or value, even as a hypothesis; say what is needed to resolve it. Use only supplied facts, quotes and approved terms. Flag missing GST, freight, payment days or delivery instead of assuming. Check stock against physical count or software before ordering. A person checks before sending, ordering, paying or posting. Show every total as explicit working (e.g. 15,000 + 2,700 = 17,700) and check that each total equals the sum of its rows before reporting.

Which model? Use your tool's strongest model with thinking turned on.

In your AI tool: attach the files with the + button, paste, send.

What you'll get back (example, from the practice files)
2below level
1held
15P1 shortage
  • P1Level 25. 5 × 4 + 5; stock 10.
  • P2Level 20. Stock 25, no shortage.
  • P4Lead missing. No calculation.
Before you trust it

Then send this: Recalculate each level and shortage; verify missing inputs held.

If it goes wrong
Invents lead time

Reply: "Hold missing."

Orders automatically

Reply: "Proposed shortage only."

Ignores stock

Reply: "Subtract verified available stock."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?