Dashboard: Inventory Control
Overview:
This dashboard provides insights into inventory control across 56 stock positions, furniture, office supplies, and technology. It provides a visual overview of the value of stock, item status distribution by warehouse, and top 5 items. It also provides a value trending chart as of 12/26/2021.
Benefits:
This dashboard can help businesses make more informed decisions about their inventory. It can provide insights into which items are over-stocked, at-stock, under-stock, and out of stock. It can also help businesses identify which warehouses are most efficient in managing their inventory.
Who Can Benefit:
This dashboard can be used by business owners, managers, and analysts to gain insights into their inventory control. It can help them make better decisions about their inventory and help them identify areas of improvement.
How It Can Benefit:
This dashboard can help businesses identify which items they need to restock and which items they need to reduce their inventory of. It can also help them identify which warehouses are most efficient in managing their inventory. This can help them save time and money by reducing the amount of time spent managing inventory.
Inventory Control | Overview
Click KPI cards to filter
56 Stock Pastions
Furniture
Value Trending (as of 12/26/2021)
Item Status Distribution by Warehouse
Over Stock
At-Stock
Under-Stock
$2,260,767 value
(16.3% of Total)
Top 5 Items
Item
30,2450OH
58.15% Within Target Range
Warehouse
FUR-CH-10001394 Warehouse 001
FUR-BO-10004834 Warehouse 003
FUR-CH-10002331 Warehouse 001
FUR-CH-10002073 Warehouse 001
FUR-BO-10002545 Warehouse 001
$2,260,767
Warehouse 001 Warehouse 002 Warehouse 003
Value
$672,953
$344,023
$265.632
$224,957
$183,599
Office Supplies
$13.9M OHV
19.76% Within Target Range
Value Trending (as of 12/26/2021)
Over-Stock
At-Stock
Under-Stock
Out of Stock
Top 5 Items
Item
$1,020,855 value
(7.4% of Total)
Item Status Distribution by Warehouse
QOH Value
Warehouse 002
Warehouse
OFF-PA-10004359 Warehouse 002
OFF-PA-10000565 Warehouse 002
OFF-PA-10003395 Warehouse 002
OFF-SU-10002881 Warehouse 002
OFF-SU-10000151 Warehouse 002
Overview Planning
$262.6K
$1,020,855
Value
$366,136
$234,388
$152,662
$147,241
$93,012
Missing
Stock
Cost
Technology
$9.5M Surplus Cost
Value Trending (as of 12/26/2021)
Over-Stock
At-Stock
Under-Stock
$10,570,709 value
(76.3% of Total)
Item Status Distribution by Warehouse
Warehouse 002
Top 5 Items
Item
Warehouse
TEC-MA-10004125 Warehouse 003
TEC-MA-10002927 Warehouse 003
TEC-AC-10004666 Warehouse 003
TEC-PH-10002584 Warehouse 003
TEC-AC-10004145 Warehouse 003
$10.570,709
Warehouse 003
Value
$8.963,978
$435,126
$187,643
$146,482
$89,196
Link to Original Tableau Accelerator