Inventory & Reorder Analyst
What to reorder, what to stop buying, and what it is assuming
8 of 13 SKUs need an order now; 3 will run out before it arrives.
Stock on hand is worth $42.1K across 13 SKUs, with 7 safety days.
Ordering up to lead time + safety + 30 days costs $61.1K.
3 SKUs hold over 120 days of stock: $8,830 sits above what the next 30 days need.
1 SKUs with no sales were left out. Demand is taken as flat: seasonality is not in the data.
Days of cover, lowest first
- SKU-1005 Webcam HD4 d
- SKU-1010 Monitor arm4.5 d
- SKU-1003 Laptop stand6.9 d
- SKU-1009 HDMI cable12 d
- SKU-1002 USB-C cable15 d
- SKU-1011 Keyboard18.3 d
- SKU-1001 Wireless charger20 d
- SKU-1007 Bluetooth speaker21.4 d
Stock value by status
- Runs out first7%
- Reorder40%
- Fine19%
- Overstock34%
Order list
| SKU | On hand | Days of cover | Lead time | Order qty | Order value |
|---|---|---|---|---|---|
| SKU-1005 Webcam HD | 36 | 4 | 16 | 441 | $13.7K |
| SKU-1010 Monitor arm | 18 | 4.5 | 25 | 230 | $8,740 |
| SKU-1003 Laptop stand | 55 | 6.9 | 21 | 409 | $8,998 |
| SKU-1009 HDMI cable | 300 | 12 | 8 | 825 | $2,393 |
| SKU-1002 USB-C cable 2m | 900 | 15 | 10 | 1920 | $2,304 |
| SKU-1011 Keyboard | 220 | 18.3 | 15 | 404 | $6,868 |
| SKU-1001 Wireless charger | 400 | 20 | 14 | 620 | $5,890 |
| SKU-1007 Bluetooth speaker | 300 | 21.4 | 20 | 498 | $12.2K |
Overstock
| SKU | Days of cover | Excess value |
|---|---|---|
| SKU-1004 Desk lamp | 140 | $5,950 |
| SKU-1006 Mouse pad XL | 130 | $1,847 |
| SKU-1013 Notebook A5 | 187.5 | $1,033 |
What to do this week
- Order the 3 SKUs that will run out first today: SKU-1005 Webcam HD, SKU-1010 Monitor arm, SKU-1003 Laptop stand. Even so they will be short for part of the lead time.
- Place the full order list (8 SKUs, $61.1K) this week.
- Stop reordering SKU-1004 Desk lamp, SKU-1006 Mouse pad, SKU-1013 Notebook A5: $8,830 of stock sits above what the next 30 days need.
Do
- Order the shortest cover first and ask suppliers whether they can ship part of it sooner.
Don't
- Don't read the order quantity as a forecast: it assumes today's daily sales continue.
How to improve
- Add monthly sales so the next report can apply seasonality instead of flat demand.
- Add supplier minimum order quantities so the next report can round orders to what can really be bought.
Demo
Overview
Two things quietly kill a small retailer: running out of the lines that sell, and burying cash in the lines that do not. Both are arithmetic, and both get done badly because doing them properly means maintaining a spreadsheet nobody maintains.
This agent does that arithmetic on your own data. For each line: how fast it is selling, how many weeks of cover you hold, when to reorder given the supplier's lead time, and how much cash is sitting in stock that has not moved.
What makes it usable is what it refuses to do. It states the assumptions behind every number, and it says plainly when your history is too short or too erratic to support a recommendation — with eight weeks of data there is no seasonality to find, and a confident reorder quantity built on that is how a shop ends up holding a year of stock. It never places an order, and never contacts a supplier.
Benefits
Stop selling out of your best lines
The stock-outs that cost most are the predictable ones.
Free the cash
See exactly which stock is holding your working capital.
Numbers you can challenge
Assumptions stated, so you can correct them.
What it does
Cover and reorder points
Weeks of stock remaining and when to reorder, using each supplier's actual lead time.
Finds the cash you have buried
Lines that have not moved, with the money sitting in them.
States its assumptions
Every number says what it assumed. A figure whose basis is hidden cannot be argued with.
Admits when it cannot tell
Too little history, or demand too erratic, is reported as low confidence — not smoothed into a recommendation.
Flags the lines about to hurt
What will stock out before a reorder could arrive, ranked by what it costs you.
Orders nothing
No purchase orders, no supplier contact. It produces the analysis.
What this changes
What this changes about your week
- It takes over
- The reorder spreadsheet nobody maintains.
- Done today by
- The owner, from memory.
- How often
- Weekly buying decisions.
- Typical manual effort
- Cover and reorder points across a real catalogue is a day.
Why Retail in particular. It states its confidence and says when your history is too short. A confident reorder quantity built on twelve weeks is how a shop ends up holding a year of stock.
Runs unattended
Started by you or by an event, and it finishes on its own. Nothing waits for someone to be at a desk.
The same standard every time
The two-hundredth item is held to the bar the first one was. Consistency is the part people cannot sustain.
It cannot act on its own
Inventory & Reorder Analyst has no path to sending, spending or committing. That limit is why its output is safe to act on.
How it runs
This agent runs server-side through the PROMIVO runtime. Each run is logged step by step and every tool call is permission-checked before it executes.
- 1InputValidated against the agent input schema
- 2Modelclaude-sonnet-5 with automatic fallback
- 3Toolsextract_structured_data
- 4PermissionsRuns READ actions automatically; anything higher waits for approval
- 5OutputStructured result matching the output schema
- 6LoggingTokens, duration and every step recorded
Requirements
Integrations
No integrations required.
Before you start
- Sales history per product
- Current stock levels
- Supplier lead times, where known
- Requires the Starter plan or higher
Use cases
Weekly buying decisions
What to order this week, and how much.
Before a peak season
What will run out, and what to order now.
A cash squeeze
Find the stock that has stopped earning its shelf space.
Pricing
Starter
Billed monthly through your PROMIVO subscription. Cancel at any time.
Runs consume your plan allowance for agent executions and tokens. See plan limits
FAQ
Can it place orders?
No, and it cannot contact a supplier. Spending money is not something an agent should do on its own, and a wrong quantity is expensive in a way a wrong report is not.
How much history does it need?
It works with what you have and says how confident that makes it. Under about twelve weeks it will tell you the recommendation is directional, and it will not claim to see seasonality that short a history cannot show.
Does it handle seasonal products?
Only where your history actually covers the season. Otherwise it says so rather than assuming last month repeats.
Reviews
Reviews open once customers have run this agent.
Need this agent to work differently?
Tell us what to change and our team will scope a customised version for your business.
Customize this agent