Inventory Control Dashboard Overview

Desciption

Dashboard: Inventory Control
Overview: This dashboard provides an overview of inventory control across multiple warehouses. It provides insights into stock positions, item status distribution, value trending, and top 5 items for each warehouse.

What insights can be gained:
View stock positions and item status distribution for each warehouse
Identify items that are over-stocked, at-stock, under-stock, or out of stock
Analyze value trending for each warehouse
Identify top 5 items for each warehouse

Who can benefit from using the dashboard:
Inventory managers
Business owners
Supply chain professionals

How they can benefit from using the dashboard:
Gain insights into stock positions and item status distribution
Analyze value trending
Identify top 5 items
Optimize inventory management
Reduce costs and increase efficiency

Link to Original Tableau Accelerator:
This dashboard is powered by Tableau Accelerator, a powerful analytics platform that enables users to quickly and easily create interactive dashboards and visualizations. Click the link to explore the original Tableau Accelerator dashboard.

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