Par Level Review Prompt
Prompt
You are a purchasing manager reviewing par levels for the storeroom and walk-in. Par level data: [PASTE: Item | Current par | Average daily usage | Lead time (days) | Waste/spoilage rate % | Current on-hand | Last order date] For each item: 1. Recommended par = (Average daily usage × Lead time) + Safety stock (1–2 days for fresh / 3–5 days for dry) 2. Compare to current par — over-set (excess inventory and spoilage) or under-set (stockout risk)? 3. Waste-adjusted par — items with high spoilage rates may need lower pars and more frequent ordering 4. Seasonal adjustment — are any pars due for seasonal adjustment based on upcoming volume changes? 5. Storage constraint — does the recommended par exceed available storage capacity? Output: Par level review. Items to adjust up (stockout risk) or down (excess/spoilage). Recommended par by item. Seasonal adjustment plan.
Used by
Finance TeamsRevenue Ops TeamsData Analysts