thinkhard.SI

Prompt repository Operations

Classify your stock with ABC analysis

You want to know which stock items carry most of your inventory value, so you can count and plan them more closely than the rest.

Registry no.
OPS-051
Collection
Operations
Laid out for
GPT
Score
10 out of 10
Blanks to fill
5

OperationsGPT

The prompt

Score 10 of 10, Excellent

Use it when You want to know which stock items carry most of your inventory value, so you can count and plan them more closely than the rest.

  • {{audience}}
  • {{item_data}}
  • {{cutoffs}}
  • {{critical_items}}
  • {{current_policy}}
Full prompt and why it works
Prompt
# Role
You help an inventory planner classify stock with ABC analysis and set a count and reorder policy for each class.

# Goal
Classify the items below by annual usage value, for {{audience}}, so that counting time and planning attention go to the few items that carry most of the value, and the rest are managed with simpler rules. A good result lets the planner see in one table where the value sits and what changes for each class.

# Material
Item data (item, description, annual quantity used or sold, unit cost):
"""
{{item_data}}
"""

Class cutoffs, as a share of cumulative annual value: {{cutoffs}}
Items that are critical whatever their value (safety spares, parts that stop a line, contract items): {{critical_items}}
Our current counting and reorder practice, and the options open to us: {{current_policy}}

# Method
1. Annual usage value = annual quantity x unit cost, for each item.
2. Sort from highest to lowest value and add a cumulative percentage of total value.
3. Assign classes with the cutoffs above. If none are given, use A up to 80% of cumulative value, B to 95% and C for the rest, and say this is a starting convention to adjust.
4. Move any critical item up to A for counting and planning, and mark it "critical".

# Output
1. A summary table with the columns Class, Items, Share of items, Annual value, Share of value.
2. An item table with the columns Item, Annual quantity, Unit cost, Annual value, Cumulative %, Class, Note. If there are more than 200 items, give the spreadsheet formulas for each column instead of the full table, plus the 20 highest-value items.
3. A policy table with one row per class and the columns Count frequency, Reorder method, Review frequency, Safety stock approach, Who reviews. Base it on our current practice and options; where you propose a change, mark it "(proposed)" with one line of reasoning.
4. Up to five observations, for example high-value items with no recent usage, or unit costs that look wrong.

# Constraints
- Show the arithmetic from the data given; do not estimate missing quantities or costs.
- Keep the prose under 250 words.
- Present the cutoffs as a choice the planner owns, not a rule.

# When data is missing
Items with a blank or zero quantity or cost go on a separate "Data to fix" list rather than into a class. If unit costs are in different currencies or units of measure, stop and ask which to use.

Variables

{{audience}}
Who will use the classes, for example "the inventory planner and the stores supervisor".
{{item_data}}
One row per item: code, description, annual quantity used or sold, unit cost, exported from your system.
{{cutoffs}}
Your cutoffs, for example "A to 75%, B to 95%", or "none" to use the starting convention.
{{critical_items}}
Items to treat as A whatever their value, with the reason, or "none".
{{current_policy}}
How often you count now and how you reorder (min and max, fixed period, order point), and what you are able to change.

Why it works

  • Format. A summary by class, the full item table or its spreadsheet formulas for large lists, and a policy row for each class.
  • If unsure. Items with missing quantities or costs go on a Data to fix list, and mixed currencies or units stop the work until you say which to use.
  • What to avoid. Critical low-value items are lifted to A, and the cutoffs are shown as your choice, so the method never overrides what you know about the stock.

How to use it

  1. Press Fill in blanks and type your details into each blank. What you type stays in this browser.
  2. Copy the filled prompt into the AI tool you already use, such as ChatGPT, Claude or Gemini, or open it in the Grader or the Prompt Tester here.
  3. Before you rely on it, try it on three or four real examples. The Prompt Tester runs them all at once and shows which ones go wrong.
Use it from code

Get this prompt as JSON from the free REST API, with your own text in the blanks, or let an AI assistant fetch it through the MCP server. No key.

curl -s https://thinkhard.si/api/v1/prompts/abc-inventory-classification

With the MCP server added to Claude, ChatGPT, Cursor or VS Code, call get_prompt with {"prompt": "abc-inventory-classification"}, or just ask for it by name.