Stock value
$894
Items to reorder
4
Out of stock
1
Inventory Tracker with Reorder Alerts
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.
5 free inventory management templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 5 spreadsheets from Inventory & Stock Management, IT & Asset Management and Clinic & Practice Management. Start with Inventory Tracker with Reorder Alerts, IT Asset Inventory and Medical Supplies Inventory: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Stock value
$894
Items to reorder
4
Out of stock
1
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.
Devices in use
9
Due for refresh
4
Out of warranty
8
Every laptop, phone and device with assignee, serial, warranty, age, refresh date and depreciated value, plus counts and spend by type.
Items to reorder
4
Expiring within 60 days
2
Expired
1
Stock on hand against par levels with expiry dates, reorder flags and the value of stock by storage area.
Items
10
Annual usage value
$102,618
A items
3
Rank every item by annual usage value and class it A, B or C so you know where control matters most.
Stock value
$27,060
Overall turnover
4.7
Slow or dead value
$14,060
Value stock by category and see turnover and days on hand so slow movers stand out.