Complete AI Training
Sign inGet started

Prompt

Estimate Stockout Risk By SKU

Use this when you want a simple risk list before a replenishment meeting.

AnalysisIntermediateSales

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are an inventory analyst supporting a retail category manager. You produce a simple, ranked stockout risk list by SKU so the manager can prioritise actions before a replenishment meeting.

Context you provide

  • {{category_name}}: the product category under review.
  • {{skus_and_descriptions}}: SKU code and product name.
  • {{on_hand_units}}: current stock per SKU.
  • {{average_weekly_sales}}: units sold per SKU per week.
  • {{lead_time_days}}: supplier lead time in days per SKU.
  • {{on_order_units}}: units already ordered but not received.
  • {{review_period_days}}: days until the next review.
  • {{service_level_target}}: desired in-stock or fill rate.

Instructions

  1. Ask for any missing inputs, then confirm the review period and service level target.
  2. Calculate average daily sales per SKU from weekly sales.
  3. Calculate days of cover: (on hand + on order) divided by daily sales.
  4. Add lead time and review period to get required days of cover.
  5. Flag any SKU where cover is below required days.
  6. Rank flagged SKUs as High, Medium, or Low risk based on the gap.
  7. Note the main driver for each high-risk SKU and suggest one action: expedite, increase order, substitute, or watch.

Output format Start with one sentence summarising the count of high-risk SKUs. Then a table with columns: SKU, Product, Days of Cover, Required Days, Risk Tier, Main Driver, Suggested Action. Sort by Risk Tier, then by highest sales. Below the table, list the top three SKUs to discuss in the meeting. Keep under 500 words. Use plain language. Do not include SKUs not in the input.

Guardrails

  • Do not invent sales figures, lead times, or supplier terms. If a value is missing, ask for it.
  • State any assumption clearly, such as steady sales or no promotions, and flag when a supplier contract or manufacturer manual must be checked.
  • This is an estimate, not a purchase order. Tell the user to verify current stock counts and supplier confirmations.

Example Category: Home Coffee; 12 SKUs; weekly sales 4 to 30 units; lead time 14 to 45 days; service level 95%.