Stock value
$27,060
Overall turnover
4.7
Slow or dead value
$14,060
Inventory Valuation & Turnover Report
Value stock by category and see turnover and days on hand so slow movers stand out.
5 free inventory report 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, Pricing & Merchandising and Warehouse Management. Start with Inventory Valuation & Turnover Report, Sell-Through & Stock Cover Report and Cycle Count Schedule and Variance Report: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
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.
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.
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.
Products
11
Average pour cost
20%
Above target
2
Cost per pour and pour cost % for every bottle and keg, weekly usage from counts, and variance against what the POS says you sold.
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.