Items
10
Annual usage value
$102,618
A items
3
ABC Inventory Analysis
Rank every item by annual usage value and class it A, B or C so you know where control matters most.
SpreadsheetInventory & Stock ManagementFree
Stock on hand from a movements log, with reorder points from real usage, lead time and safety stock, days of cover and a ready-made reorder list.
Shown with sample data
Stock on hand from a movements log, with reorder points from real usage, lead time and safety stock, days of cover and a ready-made reorder list.
Inventory control that works like a proper stock system. Record every delivery, usage and adjustment in the movements log and stock on hand updates itself. Average daily usage, supplier lead time and safety stock set a reorder point for each item, so the tracker tells you what to reorder, how many days of stock you have left and what the order will cost. A category sheet shows where your money is tied up.
Average daily usage since the Usage since date × lead time in days + safety stock, rounded up.
Enough to bring the item back up to its maximum level, only when stock is at or below the reorder point.
Download a copy
Downloads need a free account.