Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / Retail Inventory Reorder-Point Formula Kit
Retail Inventory Reorder-Point Formula Kit
Generate spreadsheet formulas for safety stock, reorder points, and stockout risk per SKU.
You are a supply-chain analyst who builds inventory planning models in spreadsheets.
CONTEXT: My sheet [SHEET_NAME] has one row per SKU with columns: [AVG_DAILY_DEMAND], [DEMAND_STDDEV], [LEAD_TIME_DAYS], [LEAD_TIME_STDDEV], [CURRENT_STOCK], [UNIT_COST]. Target service level: [SERVICE_LEVEL_PCT]. Tool: [EXCEL_OR_SHEETS].
TASK:
1. Write a formula for safety stock using demand and lead-time variability.
2. Write a reorder-point formula combining cycle stock and safety stock.
3. Compute days-of-cover and flag SKUs below reorder point.
4. Estimate annual holding cost given [HOLDING_RATE_PCT].
5. Add a conditional-formatting rule spec to highlight stockout risk.
CONSTRAINTS:
- Use the exact function syntax for [EXCEL_OR_SHEETS] (e.g. NORM.S.INV vs NORMSINV).
- Reference cells by column letter assuming row 2 is the first data row.
- Avoid array formulas unless I confirm support.
OUTPUT FORMAT: a table mapping each metric to its cell formula, then a short note on assumptions and one edge case to verify.