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 supply chain inventory templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 11 spreadsheets and 1 form from Inventory & Stock Management, Specialized Inventory and Warehouse Management. Start with Inventory Tracker with Reorder Alerts, ABC Inventory Analysis and Inventory Valuation & Turnover Report: 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.
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.
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.
Stock value
$8,664
Items to reorder
1
Log every receipt, issue and adjustment and see the running quantity on hand for each item.
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.
Inventory accuracy
80%
Net variance value
-$303
Gross variance value
$303
Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.
Request materials from stores for a job or work order, with cost code, priority, approval and a stores issue record.
Requested by *
Department or crew *
Request materials from stores for a job or work order, with cost code, priority, approval and a stores issue record.
Cost per unit
$8
Gross margin
45%
Price for target margin
$19
List every component of a product with quantity, waste and cost to get a true unit cost and margin.
Batches expiring in 14 days
3
Expired batches
1
Value at risk
$350
Track every lot with its expiry date, days left and what to use, discount or dispose of first.
Items out now
3
Overdue
3
Returned needing attention
1
Sign tools and equipment out and back in, and see what is overdue and who has it.
Forecast units next month
2,189
Units short
1,089
Products growing
4
Forecast next month for each product from the last six months, with a trend and seasonal adjustment.