Bins
8
Space used
71%
Empty bins
2
Warehouse Bin Location Map
Where every item lives: zone, aisle, rack and bin, with capacity used and empty locations.
SpreadsheetWarehouse ManagementFree
Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.
Shown with sample data
Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.
Run a clean stocktake or cycle count. Paste in system quantities, count each location and type what you find; the sheet works out the variance in units, percent and value, asks for a recount when a line is out by more than your tolerance, and uses the recount as the final figure. A location sheet shows progress and accuracy for each area, so you know when the count is finished and how much stock is missing or found.
When the first count differs from the system by more than the tolerance on the Settings sheet (5% by default) and no recount has been entered.
The share of counted lines whose final count matches the system quantity exactly.
Download a copy
Downloads need a free account.