Retail Stores: Generate Reviewable Replenishment Suggestions
Organize inventory, average daily sales, and in-transit quantities into a replenishment table, preserving the calculation basis and items requiring store manager confirmation.
Fictional store: Qinghe Convenience Target coverage: 7 days; order packaging: 6 units per box SKU R-101: current stock 12 units, average daily sales 5 units, in transit 6 units SKU R-102: current stock 30 units, average daily sales 3 units, in transit 0 units Excludes safety stock and promotional factors.
Read both input and output
Input
Fictional store: Qinghe Convenience Target coverage: 7 days; order packaging: 6 units per box SKU R-101: current stock 12 units, average daily sales 5 units, in transit 6 units SKU R-102: current stock 30 units, average daily sales 3 units, in transit 0 units Excludes safety stock and promotional factors.
Output
Preset replenishment suggestions R-101: target 35 units; gap = 35-12-6 = 17 units; rounded up by 6 units/box, suggested 18 units (3 boxes). R-102: target 21 units; gap = 21-30 = -9 units; suggested 0 units. To be confirmed: arrival date of 6 units in transit, shelf capacity, promotion arrangements. This table is a planning draft and has not been submitted as a purchase order.
Use Cases
Organize inventory, average daily sales, and in-transit quantities into a replenishment table, preserving the calculation basis and items requiring store manager confirmation.
This demo uses fictional business data and pre-prepared outputs to showcase a customizable workflow. It is not a client case, live AI execution, or actual business result.
Work Steps
- Standardize product codes, inventory units, and statistical periods.
- Generate gaps using checkable calculation rules, then round up by pack size.
- List in-transit and promotion assumptions, and output a suggestion table for store manager sign-off.
Human Review and Boundaries
The store manager confirms arrival times, near-expiry inventory, and promotion needs; if negative sales or unit conflicts occur, stop the calculation for that row.
Customizable Elements
Connect inventory export files, configure safety stock, order packaging, and supplier lead times; retain the source and formula for each calculation.
How to Validate
Test separately with normal inputs, missing fields, and conflicting data; check that key fields can be traced back to inputs, missing content is clearly marked, and numerical calculations are completed by reviewable rules. The agreed samples and delivery scope shall prevail.
Platform and Delivery
Custom instructions, templates, auxiliary scripts, and review steps can be tailored for Codex or Claude. Specific product versions, tool permissions, and system interfaces are confirmed during the requirements phase and tested separately. Deliverables include source files, test samples, and usage documentation; this page does not connect to external systems, send notifications, or execute business operations.