✏️Prompts

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