P&L Report project.xlsx

	B	C	D	E	F
1
2
3	FILTERS
4	region	All		P & L
5	sub_zone	All		for Markets
6	FY	2021		All values are in USD
7
8	Market	Net Sales	COGS	Gross Margin	GM %
9	Australia	20.99M	14.1M	6.9M	32.9%
10	Austria	2.84M	2.0M	0.9M	30.1%
11	Bangladesh	6.95M	4.5M	2.4M	34.5%
12	Canada	35.06M	21.7M	13.4M	38.2%
13	China	22.89M	13.5M	9.4M	41.1%
14	France	25.94M	14.7M	11.2M	43.2%
15	Germany	12.01M	8.9M	3.1M	26.2%
16	India	161.26M	109.7M	51.6M	32.0%
17	Indonesia	18.41M	11.3M	7.1M	38.4%
18	Italy	11.72M	8.2M	3.5M	30.1%
19	Japan	7.92M	4.2M	3.7M	46.5%
20	Netherlands	7.98M	4.6M	3.4M	42.0%
21	Newzealand	11.40M	5.9M	5.5M	48.2%
22	Norway	13.68M	9.6M	4.0M	29.5%
23	Pakistan	5.66M	3.6M	2.0M	36.2%
24	Philiphines	31.86M	19.4M	12.5M	39.1%
25	Poland	5.19M	3.0M	2.2M	42.6%
26	Portugal	11.83M	6.8M	5.0M	42.1%
27	South Korea	48.97M	31.4M	17.6M	35.9%
28	Spain	12.62M	8.4M	4.2M	33.1%
29	Sweden	1.77M	1.1M	0.7M	40.2%
30	United Kingdom	34.15M	18.7M	15.4M	45.1%
31	USA	87.78M	55.3M	32.5M	37.0%
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
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