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.
4 free reports inventory templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 4 spreadsheets from Inventory & Stock Management, Pricing & Merchandising and Hospitality Operations. Start with Inventory Valuation & Turnover Report, Sell-Through & Stock Cover Report and Bar Inventory and Pour Cost: 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.
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.
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.