Web Page Inventory Control Dashboard

Desciption

Dashboard Title: Inventory Control
Subtitle: Overview, Planning, and Technology

Overview:
This dashboard provides an overview of inventory control across three warehouses. It includes key performance indicators (KPI) cards that can be used to filter the data, as well as visualizations of stock pastions, item status distribution, top 5 items, and value trending. It provides insight into the value of inventory and its distribution across warehouses, as well as the status of individual items.

What Insights Can Be Gained:
– Track inventory value and distribution across warehouses
– Monitor item status and identify over-stock, at-stock, under-stock, and out of stock items
– Identify top 5 items and their associated warehouses
– Monitor value trending over time

Who Can Benefit:
Businesses of all sizes can benefit from using this dashboard to gain insight into their inventory control. It can be used to identify areas of improvement and help managers make better decisions when it comes to stocking, ordering, and distributing inventory.

How It Can Benefit:
– Improve inventory control and reduce waste
– Identify inefficiencies and cost savings opportunities
– Monitor trends and adjust stocking levels accordingly
– Make better decisions when it comes to ordering and distributing inventory

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