Optimize inventory and safety stock
Reviews stock levels, reorder points, and safety stock to balance cost and availability.
The prompt
Role: Act as an inventory planner reviewing stocking policy.
Context: Inventory data by SKU (on-hand, on-order, average demand and variability, unit cost, lead time, current safety stock and reorder point, ABC/XYZ class if known): [INVENTORY_DATA]. Service-level targets by class: [SERVICE_TARGETS]. Holding cost rate and any storage limits: [HOLDING_STORAGE]. Obsolescence risk items: [OBSOLESCENCE]. Constraints: [CONSTRAINTS].
Task: Produce: (1) a classification (ABC by value, XYZ by variability) if not provided; (2) per SKU, the recommended safety stock and reorder point for its class and service target, vs the current setting, with the gap; (3) excess stock (above what the policy needs) and shortage risk, with the working capital tied up in excess; (4) slow-moving / obsolescence candidates and a disposition suggestion; (5) the prioritised changes with estimated cash freed and any service risk.
Format: Sections: Classification | Policy review (table: SKU | current SS/ROP | recommended | gap) | Excess & shortage (with cash) | Slow-movers | Prioritised changes & cash freed. ~500 words.
Verification: Show the formula and inputs for each recommended safety stock; flag SKUs where demand variability data is missing or the class is uncertain.
Validation: Check the biggest proposed reductions against recent demand spikes: would the new setting have stocked out? Keep more buffer where it would.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Projects & Operations prompts
What to fill in
- INVENTORY_DATA
- SERVICE_TARGETS
- HOLDING_STORAGE
- OBSOLESCENCE
- CONSTRAINTS
How this prompt is built
This prompt follows the RCTFVV structure (Role, Context, Task, Format, Verification, Validation). RCTFVV extends RCTF with two checking steps. Verification asks the model to review its own draft against your requirements; Validation asks it to flag assumptions and gaps you should confirm.
Related prompts
- Analyze spend and find savingsCategorizes spend and identifies cost-saving opportunities.
- Resolve conflicting stakeholder priorities on my projectLays out where stakeholders' demands on one project clash, what each choice costs, and a clear decision request for whoever can settle it.
- Run a community health needs assessmentA step-by-step plan to assess a population's health needs, set priorities, and turn findings into a program and evaluation plan.
- Build a RAID log (risks, assumptions, issues, dependencies)Captures and tracks the risks, assumptions, issues, and dependencies on a project.