E-Commerce project.xlsx

	A	B	C	E	F	G	I
1	KPIS
2
3
4
5	T. Net Sales		T. Profit	T. Quantity		T. Shipping Cost	Avg of Aging
6	5.4M		3.6M	128.4K		361.2K	5
7
8
9
10
11
12	VISUALIZATION
13
14
15
16	T. Net Sales Over Months				T. Net Sales By Categories
17	T. Net Sales Over Months				T. Net Sales By Categories
18
19	Row Labels	T. Net Sales			Row Labels	T. Net Sales
20	January	$262,247			Electronic	$331,692
21	February	$230,718			Auto & Accessories	$863,541
22	March	$300,415			Home & Furniture	$1,411,492
23	April	$414,043			Fashion	$2,799,359
24	May	$571,538			Grand Total	$5,406,084
25	June	$442,386
26	July	$559,308
27	August	$458,885
28	September	$510,264
29	October	$514,514
30	November	$610,561
31	December	$531,205
32	Grand Total	$5,406,084
33
34
35
36	T. Discount Over Year				Avg Profit Over Months
37	T. Discount Over Year				Avg Profit Over Months
38
39	Row Labels	T. Discount			Row Labels	Avg Profit
40	2018	$15,583			August	$70
41	Grand Total	$15,583			July	$70
42					September	$70
43					April	$71
44					June	$71
45					November	$72
46					Grand Total	$71
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100