# Optimize inventory and safety stock

Reviews stock levels, reorder points, and safety stock to balance cost and availability.

- Topic: Projects & Operations
- Framework: RCTFVV
- Level: Advanced
- Tags: Productivity, Analyze, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/optimize-inventory-and-safety-stock

## Prompt

```text
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.
```

## What to fill in

- INVENTORY_DATA
- SERVICE_TARGETS
- HOLDING_STORAGE
- OBSOLESCENCE
- CONSTRAINTS

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.