Profitability and Inventory Dashboard

Desciption

Summary
This dashboard provides insights into the profitability and inventory of categories and vendors. It provides a comparison of group by PL/TY/LY, GM comparison of category by year, inventory turns by category, and weeks supply by category. This dashboard is ideal for businesses that want to gain insights into their profitability and inventory levels.

Who Can Benefit
This dashboard is ideal for businesses that want to gain insights into their profitability and inventory levels. It can be used by sales, marketing, and finance teams to make informed decisions about their products, pricing, and inventory. It can also be used by supply chain teams to optimize inventory levels and ensure the right products are in the right place at the right time.

Benefits
Gain insights into profitability and inventory levels
Make informed decisions about products, pricing, and inventory
Optimize inventory levels
Ensure the right products are in the right place at the right time

Data

Top5-Category by Amount and %
Sales
Avg. PerofGM
60.00%-
GM
40.00%-
20.00% –
0.00%
10M-
Blou..
5M-
OM
11
15M
m
Blous.. Fragra..
10M
Bottom5-Category by Amount
and % Sales
5M
OM
60.00%
-40.00%
-20.00%
PROFITABILITY – INVENTORY DashBoard (Categories)
GM comprasion of group by PL/TY/LY
14M
60.00%
GM
Avg. PerofG.
Vendor by GM amount high to
-60.00%
25M-
GM
12M-
GM
10M-
8M-
7.90M 7.91M 8.41M
2011 2012 2013
YearlD
CAT_GRP_N… Group 1
4M
12.67M
3M-
2M-
49M
GM comprasion of category by
#
3.34M 3.33M
3.54M
-40.00%
2011 2012 2013
YearlD
-20.00%
0.00%
Grc
60.00%
-40.00%
-20.00%
Avg. PerofGM
0.00%
Avg. PerofGM
Inventory Truns By Category
High to Low
Tums
Tums
20-
SOM
9
10.853
500-
0
9.175
11.855
100.00-
50.00-
0.00
9.623
9.198
Inventroy Turns By vendor High
to Low
Weeks supply by
1,000.00
8.244
12.646
8.875
8.703
9.378
Hand.. Dres… Pettite Hosi..
vendor3 vendor4 vendor1 vendor5
51.24
50.19
48.66
category low to
high EOP6
39.97
P. 31.03
5.771
S. 26.02
58.30
78.16
15.36
7.57
1.78
30
157.7
is
<IIa Weeks supply by category low to high EOP12 29 3 In.. 17.43 J. 17.05 M… Ye… â˜â˜â˜â˜â˜â˜â˜ OOO