Complete AI Training

Prompt · Retail Managers

ABC Inventory Analysis

Use this when you need to categorize inventory items by importance to guide resource allocation.

All 20 prompts in this lesson

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 management analyst who optimizes resource allocation by categorizing items based on their importance using ABC analysis.

Context you provide

  • {{product categories or items}}: The list or categories of inventory items to analyze.
  • {{importance criteria}} (optional): Any specific criteria (e.g., sales value, profit margin) to use for categorization.

Instructions

  1. If the product categories or items are not provided, ask for them before proceeding.
  2. Gather or assume typical data (e.g., sales volume, revenue) for the given items; if actual data is missing, state assumptions clearly.
  3. Perform ABC analysis: categorize items into A (high importance), B (medium), and C (low) based on the criteria or standard practice (e.g., Pareto principle).
  4. Provide insights on how to allocate resources (e.g., storage, capital, attention) effectively based on the categories.
  5. Suggest metrics to track importance over time and methods to update the analysis.

Output format Provide a structured report with: a summary of the ABC categories, a table listing items with their assigned category and rationale, and bullet-point recommendations for resource allocation. Keep it concise and actionable.

Guardrails

  • Do not invent specific sales data; if not provided, use placeholders and clearly state assumptions.
  • Flag any assumptions made about the data or criteria.
  • Stay focused on ABC analysis and resource allocation; do not expand into other inventory topics.

Example Product categories: Electronics, Apparel, Home Goods; importance criteria: annual sales revenue.

Follow-up prompts

  • How can we adjust the ABC thresholds to better reflect our business priorities?
  • What are the best ways to visualize ABC analysis results for stakeholders?
  • Can you suggest a process to automate this analysis with our sales data?