Inventory Control Dashboard Overview

Desciption

Dashboard: Inventory Control

Overview:
This dashboard provides an overview of inventory control across three warehouses. It includes data on stock positions, item status distribution, and top 5 items. The dashboard also provides insights into positions trending, warehouse-level surplus cost, and missing stock cost.

What Insights Can Be Gained:
Understand stock positions and item status distribution by warehouse
Identify top 5 items and positions trending
Gain insight into warehouse-level surplus cost and missing stock cost

Who Can Benefit:
This dashboard can be used by warehouse managers, inventory control professionals, and supply chain managers to gain a better understanding of their inventory control processes. It can help them identify areas of improvement, optimize their inventory, and reduce costs.

How It Benefits Them:
Provides an overview of inventory control across multiple warehouses
Identifies top 5 items and positions trending
Gain insight into warehouse-level surplus cost and missing stock cost
Helps to optimize inventory and reduce costs

Data

Inventory Control | Overview
Powered by Snowflake
Click KPI cards to filter
56 Stock Postions
20 Positions
(35.7% of Total)
Positions Trending (as of 12/26/2021)
Furniture
Item Status Distribution by Warehouse
Over Stock
At-Stock
Under-Stock
Top 5 items
Item
30,2450OH
58.15% Within Target Range
Warehouse
FUR-BO-10000330 Warehouse 001
FUR-BO-10000330 Warehouse 002
FUR-BO-10000362 Warehouse 001
FUR-BO-10002206 Warehouse 001
FUR-BO-10002213 Warehouse 001
20
Warehouse 001 Warehouse 002 Warehouse 003
Positions
1
1
1
1
Office Supplies
$13.9M QOH Value
19.76% Within Target Range
Positions Trending (as of 12/26/2021)
Over-Stock
At-Stock
Item Status Distribution by Warehouse
Under-Stock
Out of Stock
11 Positions
(19.6% of Total)
Top 5 Items
Item
Warehouse 002
Warehouse
OFF-PA-10000418 Warehouse 002
OFF-PA-10000565 Warehouse 002
OFF-PA-10000994 Warehouse 002
OFF-PA-10003395 Warehouse 002
OFF-PA-10004359 Warehouse 002
Overview Planning
11
Missing
$262.6K Stock
Cost
Positions
1
1
1
1
1
25 Positions
(44.6% of Total)
Positions Trending (as of 12/26/2021)
Technology
Item Status Distribution by Warehouse
Warehouse 002
Over-Stock
At-Stock
$9.5M Surplus Cost
Under-Stock
Top 5 Items
Item
Warehouse
TEC-AC-10001606 Warehouse 003
TEC-AC-10001908 Warehouse 003
TEC-AC-10002647 Warehouse 003
TEC-AC-10003033 Warehouse 003
TEC-AC-10003174 Warehouse 003
25
Warehouse 003
Positions
1
1
1
1
1
Link to Original Tableau Accelerator