Ralph Lauren deep dive.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Label	Active	Sold Last 90	STR Last 90	Avg Active Price	Avg Sold Price	Premium Materials - Active	Premium Materials - Sold	Premium Materials - STR	Premium Materials - ASP	Premium Materials - STR vs Base	Vintage - Active	Vintage - Sold	Vintage - STR	Vintage - ASP	Vintage - STR vs Base	Oxford Cloth - Active	Oxford Cloth - Sold	Oxford Cloth - STR	Oxford Cloth - ASP	Oxford Cloth - STR vs Base	Flannel - Active	Flannel - Sold	Flannel - STR	Flannel - ASP	Flannel - STR vs Base

2	Ralph Lauren	260000	59000	22.7%	$48.54	$32.97
3	Purple Label	640	393	61.4%	$104.99	$81.04
4	Black Label	922	97	10.5%	$35.20	$36.01
5	RRL Double RL	1900	1000	52.6%	$251.16	$135.94
6	Polo Country	414	293	70.8%	$71.88	$86.19
7	Ralph Lauren Western Wear	4	1	25.0%	$135.05	$62.00
8	Polo Ralph Lauren	95000	29000	30.5%	$48.55	$34.58	4800	3000	62.5%	$37.11	2.05	18000	5800	32.2%	$43.46	1.06	17000	8400	49.4%	$30.01	1.62	5600	1600	28.6%	$44.20	0.94
9	Polo Sport	271	78	28.8%	$55.25	$37.66
10	RLX	567	53	9.3%	$45.04	$33.68
11	Polo Golf (pre-merger)	1500	134	8.9%	$33.16	$30.77
12	Rugby	322	177	55.0%	$63.95	$57.84
13	Polo Jeans Co	1600	160	10.0%	$29.83	$31.06
14	Denim and Supply	184	48	26.1%	$33.33	$31.15
15	Polo University Club	0	0		$0.00	$0.00
16	Chaps	18000	1600	8.9%	$30.29
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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