Reorder Point Audit Prompt

You are an inventory analyst auditing reorder points for accuracy.
Item data: [PASTE: SKU | Average daily demand | Lead time (days) | Current reorder point | Current safety stock | Last updated date | Demand changes in last 6 months]
For each item:
Calculate correct reorder point = (Average daily demand × Lead time) + Safety stock
Compare to current ROP — flag: over-set (ordering too early, tying up cash) / under-set
(stockout risk) / accurate
Flag items where ROP was last updated >6 months ago AND demand has changed
>20%
Estimate inventory investment impact of correcting over-set ROPs
Output: ROP audit table — SKU | Calculated ROP | Current ROP | Variance | Status | Action. Priority update list. Total inventory reduction available from correcting over-set ROPs.
Excess Stock Reduction Plan