Min/Max Review Prompt
Prompt
You are an inventory planner reviewing min/max settings across your item master. Data: [PASTE: SKU | Current minimum | Current maximum | Average daily demand | Lead time (days) | Demand variability (low/medium/high)] For each item: Calculate correct minimum = Safety stock + (Average daily demand × Lead time) Calculate correct maximum = Minimum + Economic order quantity (or [X] days supply for simplicity) Compare to current settings — flag items where min or max deviates >25% from calculated Identify items where max − min is too narrow (results in very frequent small orders) or too wide (results in excess inventory) Priority update list — items with highest inventory value impact from incorrect settings Output: Min/max review table. Items requiring immediate update. Estimated inventory impact of corrections. Inventory Stratification by Value and Velocity
Used by
Finance TeamsData Analysts