AIA Automated Inventory Assistant™

by ATWILL HOLDINGS LLC · Demo data: Northgate Supply Co.

Reorder queue

$2,799 to place across 4 suppliers

Stockout risk

$1,120/week of margin at risk

Not selling

$4,130

5 SKUs · 45% of your stock value

Healthy

12/28

$9,156 total inventory at cost

Cover spectrum

Every SKU placed by how many days of stock is left at its current selling speed. Stockouts sit left, frozen cash sits right. Click a tick to jump to that item.

Reorder now

Watch

Healthy

Overstocked

0d7d14d30d60d120d365+d

← Running outHealthy windowCapital stuck on the shelf →

Grouped into one purchase order per supplier, most urgent first. Approve to lock a PO, then export.

Velocity Parts

5 lines · 12-day lead · first stockout in 0.0d

$1,472.00

Item	Status	On hand	Sells/wk	Cover	Reorder pt	Order	Line cost
Shift cable & housing set CABLE-SHIFT-SET	Out of stock Already out — every day costs sales.	0	3.4	0.0d	8	20	$220.00
700×25 Presta inner tube TUBE-700-PV	Stockout risk Runs dry in 3.2d but restock takes 5d.	18	39.5	3.2d	36	100	$310.00
16-function multitool MULTITOOL-16	Stockout risk Runs dry in 5.3d but restock takes 12d.	2	2.6	5.3d	6	10	$160.00
Gravel tire 700×40 TIRE-GRAVEL-40	Stockout risk Runs dry in 5.5d but restock takes 18d.	4	5.0	5.5d	16	20	$560.00
11-speed chain CHAIN-11S	Stockout risk Runs dry in 8.4d but restock takes 12d.	6	5.0	8.4d	11	12	$222.00

Northbeam Distribution

1 line · 21-day lead · first stockout in 3.3d

$350.00

Item	Status	On hand	Sells/wk	Cover	Reorder pt	Order	Line cost
Clip-on rear light LIGHT-REAR-CLIP	Stockout risk Runs dry in 3.3d but restock takes 21d.	3	6.4	3.3d	22	50	$350.00

Ridgeline Outfitters

2 lines · 28-day lead · first stockout in 13d

$592.80

Item	Status	On hand	Sells/wk	Cover	Reorder pt	Order	Line cost
Canister camp stove STOVE-CANISTER	Stockout risk Runs dry in 13d but restock takes 28d.	5	2.7	13d	13	12	$396.00
Iso-butane fuel 230g FUEL-ISO-230	Stockout risk Runs dry in 24d but restock takes 28d.	41	12.0	24d	57	48	$196.80

Crestline Gear

1 line · 30-day lead · first stockout in 23d

$384.00

Item	Status	On hand	Sells/wk	Cover	Reorder pt	Order	Line cost
Commuter helmet HELM-COMMUTE	Stockout risk Runs dry in 23d but restock takes 30d.	9	2.7	23d	14	12	$384.00

How the numbers are calculated. Velocity is a weighted daily sales rate — the last 7 days count 3×, the last 30 count 2×, the last 90 count 1× — so a SKU that just took off is treated as fast, not average. Reorder point = velocity × supplier lead time + safety stock, where safety stock = z(service level) × demand variability × √lead time. Order quantity covers lead time plus your review window, minus what's on hand and already on order, rounded up to the supplier's minimum. Nothing is ordered automatically — the queue is generated for you and waits for approval, so a bad forecast can't spend your money. Your data stays in this file; edits persist locally. Replace the sample data any time with Import your CSV.

AIA Automated Inventory Assistant™ © 2026 ATWILL HOLDINGS LLC. All rights reserved.
AIA Automated Inventory Assistant™, AIA™ and the AIA stock-column mark are trademarks of ATWILL HOLDINGS LLC.
Unauthorized reproduction, distribution, or modification of this software or its interface is prohibited.