✏️Prompts

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