Reading this table:In-Transit Arrival โ goods you entered in "In-Transit" above; non-zero only on the arrival day (ETA days from today; the table Day column is day 1โ90, so an ETA of 15 appears on Day 16).
Replenishment In โ recommended order from the Shipping Plan below, placed on the day that matches production lead time + shipping time (sea batches include their ship delay).
Every row subtracts Avg Daily Sales from running inventory.
๐ 90-Day Dynamic Inventory Forecast
Day
Date
Start Inventory
In-Transit Arrival
Replenishment In
Avg Daily Sales
End Inventory
Days of Supply
Status
Sufficient (>30 days)
Tight (15-30 days)
Critical (<15 days)
Shipping Plan (Long-Term Storage Optimized)
Batch
Shipping Method
Ratio
Quantity
Ship Date
ETA
Cost
Total
$0
โ Zero Long-Term Storage Fee Guaranteed
This plan uses multi-batch JIT replenishment to ensure inventory turnover < 60 days, avoiding long-term storage fees