Automated Inventory Reorder Point Calculations
Build a system that calculates optimal reorder points and quantities for all SKUs based on demand variability, lead times, and service level targets.
Optimize inventory levels by calculating data-driven reorder points that balance stockout risk against carrying costs.
At a glance
Access
Free prompt
Open to copy — no account or payment needed.
Prompt objective
Optimize inventory levels by calculating data-driven reorder points that balance stockout risk against carrying costs.
Real use case
A distributor with 2,000 SKUs uses gut feeling for reorder points. They simultaneously have stockouts on fast-movers and excess inventory on slow-movers, tying up $500K in working capital.
Customize these fields first
Replace the placeholders with your own context before you run the prompt. That usually improves the first output more than adding more instructions later.
Prompt
Act as a supply chain analyst. Build an inventory optimization system for [COMPANY NAME] with [NUMBER] SKUs across [NUMBER] warehouses. **Context:** - SKU count: [NUMBER] active SKUs - Average monthly demand per SKU: [RANGE] - Supplier lead times: [MIN] to [MAX] days - Target service level: [PERCENTAGE]% - Carrying cost: [PERCENTAGE]% of inventory value per year - Stockout cost estimate: [AMOUNT] per incident **Deliverables (numbered):** 1. Demand analysis: calculate average demand, demand variability (standard deviation), seasonality patterns, and demand classification (fast/slow/intermittent) per SKU 2. Reorder point formula: ROP = (Average Daily Demand x Lead Time) + Safety Stock, with safety stock = Z-score x sigma_demand x sqrt(lead_time), calculated per SKU 3. Economic Order Quantity: EOQ = sqrt(2 x Demand x Order Cost / Carrying Cost), with adjustments for supplier minimums, case pack sizes, and storage constraints 4. ABC-XYZ classification: combine ABC (revenue impact) with XYZ (demand variability) to create 9 segments with different inventory policies per segment 5. Reorder schedule: generate a [WEEKS]-week forward-looking reorder plan showing which SKUs need ordering, when, and in what quantities 6. Exception report: flag SKUs with declining demand (potential dead stock), increasing lead times, demand spikes, and supplier reliability issues 7. Dashboard metrics: inventory turnover, days of supply, stockout rate, carrying cost as % of revenue, and working capital tied in inventory **Constraints:** - Must account for supplier MOQs (minimum order quantities) - Must handle seasonal demand patterns with adjustable safety stock - Must flag items approaching end-of-life or discontinuation
Open directly in an AI — the text is pre-filled:
How to use this prompt
- 1Replace the key placeholders first: COMPANY NAME, NUMBER, RANGE, MIN.
- 2Replace any bracketed placeholders like [this] with your own context.
- 3Add extra background information when you want more tailored results.
- 4Combine multiple prompts in one conversation when you need a richer output.
- 5Save your best-performing prompts so they are easy to reuse later.
Next best step
Open the guide first, then branch only if you still need more.
A fast starting guide for professionals who want to get AI working in the real world in less than a week.
If this prompt is close but not quite right, generate variants next. If the job is recurring, move into the course library after the guide.
Related prompts
View allAutomated Compliance Audit Preparation and Evidence Collection
Build a system that continuously collects compliance evidence, maps it to audit requirements, and generates audit-ready documentation packages.
Best for
Reduce audit preparation time from weeks to days by maintaining continuous evidence collection and mapping to framework requirements.
Automated Vendor Comparison and Selection Matrix
Create a system that evaluates multiple vendors across weighted criteria (price, features, support, security) and generates a decision-ready comparison matrix.
Best for
Standardize vendor evaluation with a data-driven scoring system that removes bias and creates audit trails for procurement decisions.
Automated Monthly Financial Close Checklist
Design a comprehensive month-end close automation system that tracks all closing tasks, reconciliations, and generates the financial close package.
Best for
Reduce month-end close time from 10 business days to 5 by automating task tracking, reconciliation reminders, and report generation.
Automated Board Report Generation Package
Create a system that pulls data from multiple sources to generate a comprehensive board report with financials, KPIs, risks, and strategic updates.
Best for
Reduce board report preparation from 3 days to 2 hours by automating data aggregation, visualization, and narrative generation.
Every prompt here is free. The course teaches the thinking behind them.
Copy as many prompts as you like. When you want to move from single prompts to a repeatable AI workflow, Learn AI in 30 Days walks through it, one day at a time.
Buy the course once ($15/$20 by length), or go all-access for $10/mo with a verifiable certificate.