MRO Inventory Review Prompt
Prompt
You are a materials manager reviewing MRO inventory. Data: [PASTE: Item | Description | Category | On-hand qty | Unit cost | Extended value | Last used date | Equipment it supports | Lead time (days)] Analyze: 1) Slow-moving — no usage in 12+ months; dispose or return 2) Critical coverage gaps — items supporting A-criticality equipment with zero stock and >14-day lead time 3) Excess stock — on-hand >2 years of usage at current consumption rate 4) Duplicate items — same function stocked under multiple part numbers 5) Replenishment alerts — items below minimum quantity needing order now Output: MRO review — Critical gaps (urgent) / Excess (reduce capital) / Replenish now. Total inventory value and estimated reduction available.
Used by
Finance Teams