Skip to content
PromptReady to runFinanceDocuments

Restock Planner Pro

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Aug 16, 2026

Editorially graded · Aug 16, 2026

Produces a prioritized, printable PDF list of items to reorder, specifying optimal order quantities based on current stock, usage rate, safety stock, and supplier lead times. Use when you need a quick restocking plan without building a full spreadsheet. Deliverable: One‑page PDF (A4) restock list with columns: Item, Current Qty, Recommended Qty, Supplier (optional), Reason (Low Stock / Safety Stock) Rigor: Employs standard inventory formulas: Reorder Point = (Avg Weekly Usage × Lead Time) + Safety Stock (based on desired service level). Includes a brief methodology note and confidence rating. Edge: A free prompt might only list items low in stock. This prompt adds quantitative order quantities, safety‑stock calculations, and a polished PDF ready for printing or email.

What you get

A ready-to-paste prompt you can drop into your AI. Produces a PDF and an Excel workbook (.xlsx).

Works in
Claude · ChatGPT · Gemini
Paste it in, fill the [brackets]
Any AI assistant
Works anywhere you can paste text

See it in action

A real input → output sample

Sample input
Here's my inventory list, can you generate the restock report?

| SKU | Current Stock | Avg Usage | Lead Time | Safety Stock | MOQ | Order Multiple | On-Order | Backorder |
|---|---|---|---|---|---|---|---|---|
| 10mm Steel Bolts | 150 | 50/week | 2 weeks | — | 100 | 50 | — | — |
| Packaging Foam Sheets | 500 | 5/day | — | 40 | — | — | 30 | 10 |
| Cardboard Boxes - Medium | 190 | 260/month | 10 days | — | — | — | — | — |
| Packing Tape - 2in | 80 | — | 10 days | — | — | — | — | — |
Sample output
Sample output produced by the Restock Planner Pro prompt
Produced by an AI assistant following this prompt on the sample input above.
View the full output as text
Example Output
Restock Report generated. Review the PDF for recommendations and the XLSX for detailed data.

Primary Report (PDF):
- 2 items flagged for reorder
- 1 item requires no action

Action Required:
| # | Item / SKU | Current Qty | Net Available | Avg Weekly Usage | Lead Time | Safety Stock | ROP | Days of Supply | Rec. Order Qty | Status | Confidence |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 10mm Steel Bolts | 150 | 150 | 50 | 2 weeks | 75 | 175 | 21.0 days | 100 | **Below ROP** | **Medium** |
| 2 | Cardboard Boxes - Medium | 190 | 190 | 60 | 10 days | 90 | 176 | 22.2 days | 0 | **Approaching ROP** | **Medium** |

Data Assumptions & Gaps:
- Packaging Foam Sheets: lead time not supplied; defaulted to 7 days.
- 10mm Steel Bolts: safety stock not supplied; applied the 1.5 × avg weekly usage heuristic.
- Cardboard Boxes - Medium: safety stock not supplied; applied the 1.5 × avg weekly usage heuristic.
- Packing Tape - 2in: average weekly usage not provided; excluded from Section 1.

Related