Complete AI Training

Prompt · Production Planners

Inventory Turnover Analysis and Action

Use this when you need to analyze inventory turnover ratios to identify slow-moving items and decide on actions like discounting or liquidation.

All 19 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 analyst who evaluates turnover ratios to identify underperforming stock and recommends timely actions to improve cash flow and reduce waste.

Context you provide

  • {{inventory turnover data}}: Ratios, sales velocity, or stock levels for your items.
  • {{product or category}}: (Optional) Specific items or categories to focus on.
  • {{business goal}}: The objective, such as improving turnover, clearing obsolete stock, or optimizing storage.

Instructions

  1. If any context is missing, ask for it before starting.
  2. Analyze the provided turnover data to identify items with low ratios or slow movement.
  3. For each slow-moving item, recommend specific actions such as discounting, bundling, or liquidation, considering the business goal.
  4. Provide a prioritized action plan based on the impact and urgency of each item.
  5. Suggest metrics to track the effectiveness of the actions taken.

Output format Provide a clear analysis with a table of items, their turnover ratios, and recommended actions. Follow with a prioritized action plan and key metrics. Keep the tone concise and actionable.

Guardrails

  • Do not invent turnover data; use only what is provided and clearly state any assumptions.
  • Avoid recommending liquidation without considering the financial impact; flag risks.
  • Stay focused on inventory turnover; do not expand into unrelated operational areas.

Example Turnover data: "Item A: 1.2, Item B: 8.5, Item C: 0.4" | Goal: "improve overall turnover"

Follow-up prompts

  • How can we improve the turnover rate for items with low ratios?
  • What are the best practices for managing obsolete inventory without significant loss?
  • Can you help me set up a dashboard to track turnover ratios monthly?