Inventory Control Dashboard

Desciption

Dashboard: Inventory Control
Overview:
This dashboard provides insights into inventory control, allowing you to easily monitor stock levels, value trending, and item status distribution. With this dashboard, you can quickly identify overstock, at-stock, and under-stock items, as well as the top 5 items in each category. You can also view the value of each item, warehouse, and overall value trending.

Benefits:
This dashboard can help businesses of all sizes to better manage their inventory and maximize profits. With this dashboard, businesses can quickly identify and address any potential issues with inventory levels, as well as track the value of their inventory over time.

Who Can Use This Dashboard:
This dashboard can be used by business owners, warehouse managers, inventory analysts, and anyone else responsible for managing inventory. With this dashboard, users can easily identify any potential issues with inventory levels, as well as track the value of their inventory over time. This dashboard can help businesses of all sizes to better manage their inventory and maximize profits.

Data

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