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.
12 free inventory stock templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 12 spreadsheets from Inventory & Stock Management, Warehouse Management and IT & Asset Management. Start with Inventory Tracker with Reorder Alerts, Stock Count Sheet and IT Asset 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.
Lines counted
93%
Count accuracy
54%
Net variance value
-$67
Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.
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.
To reorder
1
Running low
4
Shopping list
$152
Keep stationery, kitchen and cleaning supplies stocked with par levels, monthly usage, weeks left, a priced shopping list and spend by area and month.
Replacement value
$15,123
Cover headroom
$9,877
Missing proof
5
Belongings by room and category with serial numbers, receipts, photos, warranty status and replacement value, plus totals to check against your insurance cover.
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
$8,664
Items to reorder
1
Log every receipt, issue and adjustment and see the running quantity on hand for each item.
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.
Items to order now
3
Units to order
4,361
Items tracked
5
Work out when to reorder each item from its demand, lead time and how variable both are.
Loss at cost
$321
Shrinkage rate
1%
Incidents
8
Record every loss by cause, value it at cost and see where theft, damage and waste are costing you most.
Overall sell-through
53%
Lines to reorder
4
Lines to mark down
4
Units received and sold by product, with sell-through rate, weeks of cover and a reorder or markdown call.