Prompt · Retail Managers
ABC Inventory Analysis
Use this when you need to categorize inventory items by importance to guide resource allocation.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- 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
- If the product categories or items are not provided, ask for them before proceeding.
- Gather or assume typical data (e.g., sales volume, revenue) for the given items; if actual data is missing, state assumptions clearly.
- 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).
- Provide insights on how to allocate resources (e.g., storage, capital, attention) effectively based on the categories.
- 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?