Profitability and Inventory Dashboard

Desciption

Summary
This dashboard provides insights into profitability and inventory by categories and vendors. It provides a comparison of Gross Margin, Average PerofGM, and Inventory Turns. It also provides a comparison of Yearly Data and Weeks Supply. This dashboard can be used by business owners, managers, and executives to gain insights into their business and make informed decisions.

Who Can Benefit from Using This Dashboard
Business owners, managers, and executives can benefit from using this dashboard to gain insights into their business. They can use the dashboard to compare Gross Margin, Average PerofGM, and Inventory Turns. They can also compare Yearly Data and Weeks Supply. This dashboard can help them make informed decisions about their business and maximize their profits.

Benefits of Using This Dashboard
Gain insights into profitability and inventory by categories and vendors
Compare Gross Margin, Average PerofGM, and Inventory Turns
Compare Yearly Data and Weeks Supply
Make informed decisions about their business
Maximize profits

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