# Inventory Reorder Automation Designer

Design a stock-replenishment workflow using demand, lead time, safety stock, supplier constraints, approvals, and exception handling.

## Prompt

You are a supply operations automation specialist who designs controlled inventory replenishment workflows.

Inputs:
1. Products, locations, inventory systems, and service targets: {{inventory_context}}
2. Demand history, forecasts, lead times, and variability: {{planning_data}}
3. Suppliers, pack sizes, minimums, prices, and delivery calendars: {{supplier_rules}}
4. Purchase authority, budgets, approvals, and receiving process: {{controls}}
5. Data quality, shelf-life, capacity, and operational constraints: {{constraints}}

Do the following:
1. Define the stock position using on-hand, allocated, in-transit, backordered, quarantined, expired, and expected demand data, including freshness requirements.
2. Design reorder triggers and quantities using approved policy for lead-time demand, safety stock, service level, order cycles, pack sizes, minimums, shelf life, storage, and budget.
3. Separate automatic recommendations, automatic orders, and mandatory human review based on value, uncertainty, novelty, supplier change, demand spike, and data confidence.
4. Specify supplier selection, approval, purchase-order creation, acknowledgement, delivery tracking, receiving reconciliation, substitutions, shortages, and cancellation behavior.
5. Produce a calculation table, workflow states, approval matrix, exception queue, alerts, reconciliation rules, simulation plan, and rollback controls. Do not invent forecasts or allow low-quality data to trigger irreversible orders.

## Best for

Operations teams automating routine replenishment while retaining control over costly, uncertain, or perishable orders.

## Compatible tools

- Claude
- ChatGPT

## How to use

- Define stock states and authoritative systems.
- Use approved service and safety-stock policies.
- List supplier pack and calendar constraints.
- Simulate the workflow before enabling automatic orders.

## Customization tips

- Start with recommendations before full automation.
- Route novel and low-confidence demand to review.
- Reconcile supplier acknowledgements and receipts.
- Protect cold-chain capacity and shelf life.

## Example input

Context: Five veterinary clinics stocking 420 medical and office items. Target: 98% availability for critical medicines and 95% for routine supplies. Data: daily inventory, usage history, supplier lead times of 1-12 days, and open purchase orders. Rules: cold-chain products have strict capacity and shelf life; controlled medicines require pharmacist approval; supplier packs vary. Constraints: orders above EUR 3,000 need finance approval and new substitutes cannot be ordered automatically.

## Example output

The workflow calculates net stock by clinic and excludes expired or quarantined units. Routine stable supplies create draft orders using lead-time demand, safety stock, packs, and minimums. Controlled, cold-chain, high-value, low-confidence, and substitute items route to specialized review. Supplier acknowledgement updates inbound stock, receiving reconciles quantity and expiry, and unconfirmed orders trigger escalation before another order can duplicate them.