20180418032133mis_655_rs_wholesale_customers.xlsxQW WQ
The purpose of this assignment is to perform cluster analysis and analyze clusters in a data set to determine whether or not the information generated can be used to address a specific business problem.
For this assignment, you will use the “Wholesale Customers” data set from the Topic Materials. Most data categories are self-explanatory. Clarifying notes are as follows.
- Fresh: Annual spending (in $1000s) on fresh products
- Milk: Annual spending (in $1000s) on milk products
- Grocery: Annual spending (in $1000s) on grocery products
- Frozen: Annual spending (in $1000s) on frozen products
- Detergents_Paper: Annual spending (in $1000s) on detergents and paper products
- Delicatessen: Annual spending (in $1000s) on delicatessen products
- Client_Type: Type of client – either HoReCa (Hotel/Restaurant/Café) or Retail
- Region: Region of client – either Lisbon, Oporto, or Other
A wholesale distributor wants to understand the purchasing profiles of its clients. If a finite set of distinct profiles were defined, then a marketing strategy could be designed specifically for each set of similar clients. The company has compiled a data set that includes annual client spending on diverse product categories. You have been tasked with analyzing the data to determine what patterns emerge and how these patterns can be used to create specific client marketing profiles.
Use k-means clustering to explore and analyze the data set by using only the quantitative variables to cluster the clients.
Question 1: Explain the process you used to define the clusters such as the number of clusters formed, the specific variables used, etc. Include the “Cluster Sizes” and “Predictor Importance” outputs when submitting the answer.
Question 2: Interpret the clusters with respect to the quantitative variables that were used in forming the clusters. Include the “Clusters” output when submitting the answer.
Question 3: Discuss whether there is a pattern in the clusters with respect to the qualitative variables (i.e., Client_Type or Region). Include the charts illustrating these patterns when submitting the answer.
Question 4: Provide an appropriate name for each cluster using any or all of the variables in the data set.
Question 5: Based upon your analysis, what patterns emerged and how can these patterns be used to create specific client marketing profiles? Include discussion of the characteristics for each profile. Present your finding in the form of a 250-word executive summary that includes relevant data, charts, and tables.
General Requirements:
Submit the answers to Questions 1-4 and the executive summary as Word documents.
APA format is not required, but solid academic writing is expected.
This assignment uses a grading rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion
>Wholesale
6 6
1
3 3
3
8
05
2 96
1
4
7
0
8
15
7
5
13
9
26
6
5
51
6
0
56
6
1
6
48
6
06
9
98
66
03
74
0
7
4
0
7
7
81
1
95
07
53
4
21
0
6
9
0
8
01
99
7
0
5
669 6
9
67
0
3
6
7
9
1
3
4
23
19
3
7
6
92
5
8
5
201 3
57 8
1
6
5
100 518 84
4
88
0
0
8
3
2
2
6
9
361 2
9
425 1
833 8
9
8
56
7
0
6
714 9
09
33 2
2
212 5
7
5
3
5
2
188 46 8
72 0
71
65 4
31
0
3
9
55
8
66
7
1
6
2
21
8
83
3
1095 0
0
609 7
6
239 8
6
5 7
3
744 1
29
9
7
6
204 4
5
4
8
92
66
0
3
38 2
436 129 4
3
3045 96 225 2
9
8
01
4
4
4
1
7
0
7
0
4
1247 1145 59
36 7
175 8
27 1
3
6
1
6
5
0
779 144 2
116 5
1
6
3
2
0
1
181 9
2
648 0
3 3 7
529 5
301 167 0
868 829 9
430 529 0
7
2
67
7
120 17
25
8
14
65
5
7
51
542 2
165 46 4
3836 8
596 3 69 360 4
0
72
2
6
6
0
206 8
244 0
440 145 4
217 56 132 8
215 323 4
9
Other Retail 1 8
7677 6
2
4
8 28
0
0
2
87
139 7
133 1
247 5
6
6
836 3 8
4
169 4
1519 0
483 8
0
5
118 1266 4
5
276 610 222 1647 319 1160 1
2
933 Other HoReCa 8
6
266 60
1200 2
2417 174 264 255 2
201 245 1991 25 860 143 0
500 2
778 918 0
349 483 5
880 3
142 3 410 699 395 346 70 310 955 1042 436 256 396 47 537 1170 199 326 9
661 721 36 155 249 825 5
2616 79
321 51 3
6
2
5
20 3 5
399 318 7
118 516 201 42 9
6
926 73 526 4
584 542 283 434 113 5
853 170 531 255 5
352 184 0
779 302 0
317 3
811 2
398 303 1
540 283 3 2024 0
232 610 1
6
446 4
238 3
993 7
405 693 735 803 79 717 69 750 323 2
6
651 9
333 0
707 5
5
153 5
4
52 6536 1532 230 9
3
20 120 395 7
273 5
402 1
443 156 74 334 11 1
58 247 Other HoReCa 3009 521 854 Other HoReCa 6269 9
3 9
404 275 6
6250 1981 118 64 295 890 43 84 547 187 409 5
959 4
355 0
330 HoReCa 4
7
763 6
4
1468 592 697 0
2
520 402 347 1
9
9
9
284 685 469 954 18 5 6
955 710 780 288 285 120 Lisbon HoReCa 8
806 9
864 0
797 244 2100 1012 240 7
2
1215 5957 8
8 9
179 8
674 2532 130 367 86 130 899 1382 1765 56 749 10646 91 7
239 256 375 788 659 784 70 659 3
660 786 1553 2204 1563 263 577 572 950 203 6
5
694 980 5615 955 1439 490 638 284 834 937 409 7 3
0
325 295 820 2312 415 225 3838 593 28 1215 475 585 72 216 9
828 6
5
343 9
1801 2216 412 1047 659 586 561 1682 1970 6
230 2428 1777 1777 430 610 346 489 44 659 562 572 Lisbon HoReCa 8040 918 291 234 710 3
86
5121 3
205 1693 1
432 363 1391 9
489 111 615 453 373 987 730 967 818 2157 327 780 548 49 287 1372 429 655 4
411 61 1265 9
830 2563 737 1069 698 8
258 333 204 975 197 56 1563 147 529 93 1040 3045 210 744 759 223 862 96 379 603 829 683 9
621 139 274 9694 1293 977 167 7108 Other HoReCa 0
314 8692 2406 4
640 1042 436 18 1242 128 4
386 594 445 258 286 471 32 22 502 965 1522 Other HoReCa 212 686 3838 825 Retail 741 2013 909 811 417 254 3045 710 898 531 1037 264 290 259 824 172 5
364 555 492 59 799 211 Oporto Retail 925 Oporto HoReCa 1020 416 257 656 806 299 1117 371 117 Oporto Retail 2137 142 925 2405 183 297 857 662 83 978 821 51 514 275 834 5
1897 228 1113 713 3703 229 944 915 573 3587 140 1092 1610 387 834 414 88 522 2209 210 1534 492 182 1
1447 2208 178 131 1215 332 6817 1330 650 146 778 1
8170 442 868 15 550 5332 573 767 349 1328 6964 37 Other HoReCa 217 379 2602 402 303 1115 665 2005 445 173 995 8
830 90 195 228 1111 245 184 127 134 218 9 548 137 110 6114 536 340 232 776 468 503 864 159 405 560 179 712 997 4438 191 314 1103 514 468 1619 1664 1173 222 447 894 534 252 342 2406 2046 101 558 337 683 41 296 1364 523 716 790 876 397 1492 311 686 1450 597 476 70 96 1242 Other HoReCa 282 68 10391 130 813 179 944 600 270 4591 246 532 2540 1711 1364 397 361 3
282 5
1614 192 1068 353 967 Other HoReCa 1916 231 961 848 1172 1677 200 406 1422 227 684 1181 1328 311 1000 2313 907 95 659 122 654 385 819 865 149 452 1263 841 290 3378 64 743 1032 582 74 247 577 935 1601 469 375 906 1238 3576 153 1014 92 1902 220 10 340 Other HoReCa 127 632 288 4324 914 715 593 378 1092 960 553 344 2096 4563 1860 1535 235 98 62 6633 290 Other Retail 1691 848 993 364 133 776 633 1521 25 6818 1393 Other Retail 830 948 1218 Other Retail 1059 668 0
2884 874 249 2408 108 439 1163 850 317 47 84 2501 575 241 1377 1498 1162 269 1328 395 1493 356 688 838 182 2204 1431 764 93 1981 2232 168 1698 65 477 52
ID
Region
Client_Type
Fresh
Milk
Grocery
Frozen
Detergents_Paper
Delicassen
1
Other
Retail
12
6
9
96
5
7
56
21
4
26
74
1
3
8
2 Other Retail
70
57
98
10
95
68
17
62
3
29
17
76
3 Other Retail
6
35
8
80
76
84
24
35
16
78
44
4 Other
HoReCa
13
65
11
4
22
6
40
50
1
7
88
5 Other Retail
226
15
5
41
7
19
39
1
77
5
18
6 Other Retail
94
8
25
51
66
1
79
14
7 Other Retail
1
212
31
99
69
75
48
3
140
5
45
8 Other Retail
7579
49
9
42
1
669
3
32
256
9 Other HoReCa
59
63
36
61
92
425
1
71
750
10 Other Retail
60
110
93
188
81
115
7425
20
11 Other Retail
33
54
129
440
5
97
1
744
12 Other Retail
131
46
112
45
23
142
549
497
13 Other Retail
31
714
12
319
1
175
28
38
293
14 Other Retail
21
217
6
208
149
82
30
67
602
15 Other Retail
246
53
9465
120
91
294
50
58
2
168
16 Other HoReCa
102
111
3
821
397
9
64
412
17 Other Retail
1020
8816
121
1
34
4508
108
18 Other HoReCa
5
87
6
157
2
933
83
37
4
47
19 Other Retail
1
86
63
27
100
2
205
276
3
181
20 Other HoReCa
778
249
9464
2
518
501
21 Other Retail
17546
4519
4602
106
225
2
124
22 Other HoReCa
55
871
201
338
375
569
23 Other HoReCa
3
127
191
446
9
408
238
43
24 Other Retail
263
73
364
220
5
154
4
337
16
52
25 Other Retail
2
264
977
137
291
4482
577
26 Other Retail
16
165
4
230
759
400
27 Other HoReCa
9
89
961
286
3
151
242
833
28 Other HoReCa
1
427
803
304
4
85
29 Other Retail
4
113
204
2
5957
1
158
860
5
206
30 Other HoReCa
430
210
2
609
1
200
1
107
823
31 Other HoReCa
18815
361
1
1107
114
2
134
296
32 Other HoReCa
261
4
339
3
133
2088
820
985
33 Other HoReCa
2
163
1
318
288
266
918
405
34 Other HoReCa
29
72
4
786
7
326
6
130
1083
35 Other HoReCa
150
197
2
262
483
395
36 Other Retail
688
5
491
1
109
4
239
436
37 Other HoReCa
29
955
4
362
542
172
862
4626
38 Other Retail
1
516
105
1
247
192
650
39 Other Retail
4591
1
572
167
6956
433
40 Other HoReCa
56
159
555
90
1000
2916
41 Other HoReCa
2
402
4
332
475
9510
1
145
5
864
42 Other HoReCa
19
176
306
5956
203
257
280
43 Other Retail
10
850
7555
14961
6
899
44 Other Retail
630
1
1095
2
399
787
9
529
45 Other Retail
967
7027
104
541
4618
46 Other Retail
5181
2204
215
174
735
4985
47 Other Retail
3
103
1
406
219
166
6792
1
452
48 Other Retail
444
54
259
55571
7782
241
6465
49 Other Retail
1
1519
6
152
10
868
584
5121
147
50 Other Retail
4967
2
141
289
179
135
116
51 Other HoReCa
6
269
198
386
2
162
52 Other HoReCa
334
4051
699
153
301
53 Other Retail
40
721
391
876
532
258
1
278
54 Other Retail 491
1047
1
1532
561
224
55 Other HoReCa
273
144
194
243
1
333
56 Other HoReCa
526
3
683
500
1057
202
1130
57 Other Retail
409
298
268
2616
1
774
1
340
58 Other Retail
5
417
993
10487
7572
128
59 Other HoReCa
13
779
1970
1
648
596
227
60 Other HoReCa
6137
5
360
8040
308
160
61 Other Retail
8590
7
854
4095
62 Other Retail
3
594
3
836
5
959
3
254
267
2017
63 Other Retail
7823
6
245
654
415
407
964
64 Other Retail
9
396
1160
15775
2896
767
1
295
65 Other HoReCa
476
122
325
372
66 Other Retail 85
209
4
5
828
24
231
1
423
67 Other HoReCa 9
1
534
741
346
68 Other Retail
199
6759
13462
125
514
834
69 Other HoReCa
244
7
260
3993
5870
788
309
70 Other HoReCa
8
352
282
1293
656
71 Other HoReCa
16705
2037
320
10643
136
72 Other HoReCa
1
829
126
2
1042
537
4
173
1
447
73 Other HoReCa
442
5
139
2
661
8872
132
74 Other Retail
1989
5332
8
713
813
764
75 Other Retail
8
190
6
343
9794
1
285
1901
178
76 Other HoReCa
20
398
1137
4407
975
77 Other HoReCa
717
358
6532
7530
894
78 Other Retail
12205
12
697
28
540
869
12034
1009
79 Other HoReCa
10766
117
2067
2096
80 Other HoReCa
164
3259
3
655
1202
1653
81 Other HoReCa
7005
300
610
82 Other Retail 219
954
14
403
283
7
818
156
83 Other Retail
10362
9
232
11009
737
353
234
84 Other HoReCa
20
874
1563
1783
2320
550
772
85 Other Retail
118
3
327
4814
1178
383
86 Other Retail
161
46197
92
780
1026
40827
2
944
87 Other Retail
229
7
349
321
987
20070
903
88 Other HoReCa
432
502
811
6
312
1579
143
89 Other HoReCa
7864
404
9735
90 Other HoReCa
2
490
5
330
3
443
454
317
91 Other HoReCa
11405
1
638
347
92 Other HoReCa
1
275
2762
253
8
693
627
1117
93 Other Retail
9198
274
32034
323
1
890
5130
94 Other Retail
562
1
222
11323
503
95 Other HoReCa 3
292
6
252
223
709
96 Other Retail 23 2616
8118
387
97 Other HoReCa 403 254 610 774 54 63
98 Other HoReCa 503 112 778
895
99 Other HoReCa
965
2
182
1
909
5639
100 Other Retail
11594
7779
1
214
3252
8035
302
101
420
10810
16267
1
593
6766
183
102 Other Retail
2932
6459
2561
4
573
138
103 Other HoReCa
5
608
350
906
180
148
2498
104 Other HoReCa
1
410
213
3
445
1
336
1491
548
105 Other HoReCa
155
1014
3970
910
1
378
106 Other Retail
1454
633
10704
6
830
1831
107 Other Retail
8
797
10646
14886
2
471
8969
1438
108 Other Retail
1
531
8397
698
250
123
109 Other Retail 1406
16729
2
898
673
110 Other HoReCa
1181
1648
169
2276
1647
111 Other Retail
12579
1111
17569
805
6457
112 Other HoReCa
19046
277
2
469
8
853
270
113 Other HoReCa
1
4438
2295
1733
322
585
1561
114 Other HoReCa
18044
1080
2000
255
115 Other HoReCa
1113
793
2988
271
116 Other HoReCa
1
1173
2
521
3
355
1517
310
117 Other HoReCa
6990
3
880
5
380
118 Other HoReCa
20049
189
236
5343
411
119
825
2
344
2147
389
635
120 Other HoReCa
171
341
1136
121 Other HoReCa
4020
3234
1498
2395
122 Other HoReCa
1
221
123 Other Retail
1
1
170
10769
8814
2194
1976
124 Other HoReCa
3605
1642
2961
4787
1
621
125 Other HoReCa
76
237
3473
710
16538
126 Other HoReCa
19219
184
1658
8
195
127 Other Retail
2
146
7243
10
685
2386
2
749
128 Other HoReCa 140
8847
382
1062
129 Other HoReCa
4
2312
926
1510
1718
1
819
130 Other HoReCa
7149
2
428
6
316
911
131 Other HoReCa
2101
589
314
132 Other HoReCa
14903
2032
2479
576
328
133 Other HoReCa
9
434
1
235
134 Other HoReCa
7
388
1882
2174
720
135 Other HoReCa
6300
1289
2591
136 Other HoReCa
4625
857
7030
4
575
2447
1542
137 Other HoReCa
3087
8080
8282
138 Other HoReCa
13537
4257
5034
3271
139 Other HoReCa
5387
4979
3343
637
929
140 Other HoReCa
17623
4280
730
2
279
960
141 Other HoReCa
303
13252
5189
1450
142 Other HoReCa
370
715
8253
299
143 Other HoReCa
1040
1596
1096
8425
144 Other HoReCa
18827
367
1988
145 Other Retail
22039
8
384
34792
12591
4430
146 Other HoReCa
776
193
2
177
520
147 Other HoReCa
9203
3
373
2
707
1286
1082
148 Other HoReCa
592
4052
149 Other HoReCa
31812
1433
1
651
800
1440
150 Other HoReCa
1
622
1825
1765
1067
151 Other HoReCa 1289
3328
2022
1774
152 Other HoReCa
18840
1
371
313
3001
153 Other HoReCa
3463
925
2
368
1627
154 Other HoReCa 622 55 137 75 7 8
155 Other Retail 1989
1069
19460
233
11577
2153
156 Other Retail
3830
5291
14855
6
694
3182
157 Other HoReCa
1777
1
366
2474
3378
418
158 Other Retail 2861
6570
9618
930
4004
1682
159 Other Retail 355
7704
1
468
8077
160 Other Retail
1725
365
12822
824
4
424
2157
161 Other HoReCa
12434
1092
2233
162 Other HoReCa
15177
381
2
665
163 Other Retail
553
15726
26870
2367
1372
164 Other Retail
522
7
603
8584
2540
3
674
165 Other Retail
1
5
615
1
265
19858
4425
7108
2
379
166 Other Retail
4822
6721
9170
4973
363
167 Other HoReCa
2926
3195
3268
1
680
168 Other HoReCa
5809
1
393
429
169 Other HoReCa
5
414
2155
2399
170 Other Retail 260
8675
13430
1116
7015
171 Other Retail 200
2
586
1981
8773
6250
172 Other HoReCa 955
547
6
536
284
173 Other Retail 514 7677
1
980
937
9836
716
174 Other HoReCa 286
1208
5241
251
1442
175 Other Retail
2343
784
1
187
4
196
1697
176 Other HoReCa
45
640
6958
7368
177 Other HoReCa
1275
7330
453
1752
2631
178 Other HoReCa
11002
7075
4945
1152
179 Other HoReCa
315
4888
2500
4
477
216
180 Other HoReCa
12
356
6036
8887
1382
2794
181 Other HoReCa
1
1215
29627
18148
16745
4
948
8550
182 Other HoReCa 694
8533
10518
6
907
183 Other HoReCa 327 918
4710
184 Other HoReCa
8170
6448
1139
218
185
3470
949
727
186
2438
8002
9819
345
187 Other Retail 8040
763
11687
2758
6839
188 Other Retail 834 11577
1
1522
4027
1856
189 Other HoReCa
1693
7332
190 Other HoReCa
13624
1381
191 Other HoReCa
5509
1461
2251
192 Other Retail 180
348
20292
5618
666
193 Other HoReCa
7107
1012
297
806
1142
194 Other HoReCa
17023
5139
523
7888
1755
195
Lisbon
3062
7209
489
18711
287
196 Lisbon Retail
2427
7097
10391
1127
431
197 Lisbon HoReCa
11
686
2154
6824
3527
198 Lisbon HoReCa
9670
228
211
199 Lisbon Retail
3067
13
240
23127
394
995
731
200 Lisbon Retail
4484
1
439
24708
354
14235
1681
201 Lisbon HoReCa
25203
11487
9490
5065
6854
202 Lisbon HoReCa
583
2216
203 Lisbon HoReCa
1956
891
5226
1383
1328
204 Lisbon Retail 1107
1
1711
2
359
9265
205 Lisbon HoReCa
6373
950
878
206 Lisbon Retail
2541
4737
6089
2946
5316
207
1537
374
5
838
1859
3381
208 Lisbon Retail
5550
1
272
16767
1242
209 Lisbon HoReCa
18567
1895
1393
1801
210 Lisbon Retail
12119
28326
3
9694
4736
19410
2870
211 Lisbon HoReCa
7291
2062
1291
1775
212 Lisbon HoReCa
331
660
6861
1
329
3961
213 Lisbon Retail 2362
6551
1
1364
913
791
214 Lisbon HoReCa
2806
10765
1553
1374
582
2388
215 Lisbon Retail
2532
1
659
36486
1330
216 Lisbon HoReCa 18044
1475
2046
1158
217 Lisbon Retail 18
7504
15205
1285
4797
6372
218 Lisbon HoReCa
4155
1
390
2306
219 Lisbon HoReCa
14755
220 Lisbon HoReCa
5396
7503
416
221 Lisbon HoReCa
5041
1115
2856
7496
222 Lisbon Retail
2
790
2527
5265
5612
1360
223 Lisbon HoReCa
7274
1499
224 Lisbon HoReCa
12680
324
4157
761
225 Lisbon Retail
20782
5921
9212
1759
2568
226 Lisbon HoReCa
4042
2286
689
227 Lisbon HoReCa
1869
4762
228 Lisbon HoReCa
865
2746
2501
684
229 Lisbon Retail
11072
5989
8321
2137
230 Lisbon HoReCa 2344
10678
3828
1566
231 Lisbon HoReCa
25962
1780
3838
232 Lisbon HoReCa 964
4984
3316
233 Lisbon HoReCa
1
560
2703
3833
426
2563
234 Lisbon HoReCa
1838
6380
2824
1218
1216
235 Lisbon HoReCa
8635
3047
236 Lisbon HoReCa
1
8692
4634
237 Lisbon HoReCa
7363
1112
238 Lisbon HoReCa
47493
2567
377
5243
2253
239 Lisbon HoReCa
2209
357
7041
1
1
422
2564
240 Lisbon HoReCa
2
492
2475
241 Lisbon HoReCa
18226
2
914
3752
578
242 Lisbon HoReCa
1
1210
3576
5119
2398
243 Lisbon HoReCa
6202
7775
10817
1183
3143
244 Lisbon Retail 3062
6154
1391
8933
2784
245 Lisbon HoReCa
8885
246 Lisbon HoReCa
13569
2077
247 Lisbon HoReCa
15671
5279
2406
559
248
3795
2070
6340
249 Lisbon HoReCa
3191
1993
1
799
1730
250 Lisbon Retail
6134
2313
335
6746
18594
251 Lisbon HoReCa
662
1860
4740
7683
252 Lisbon HoReCa
29526
796
16966
253 Lisbon HoReCa
1037
17972
4748
4686
1547
3265
254 Lisbon HoReCa
3
1614
1495
3242
255 Lisbon HoReCa
11092
5008
5249
392
256 Lisbon HoReCa
8475
1931
1883
5004
3593
257 Lisbon HoReCa
56083
4563
2124
6422
3321
258 Lisbon HoReCa
53205
4959
7336
3012
259 Lisbon HoReCa
9193
4885
260 Lisbon HoReCa
7858
1110
1094
6818
261 Lisbon HoReCa
23257
1677
982
262 Lisbon HoReCa 2153 1115
668
4324
2894
263 Lisbon Retail
1073
9679
15445
5980
264 Lisbon HoReCa
5909
23527
1
369
10155
3636
265 Lisbon Retail 572
9763
22182
2221
4882
266 Lisbon HoReCa
20893
1222
2576
3975
3628
267 Lisbon Retail
11908
8053
19847
6374
268 Lisbon HoReCa
1521
1138
2516
269 Lisbon HoReCa
4720
1032
5500
270 Lisbon HoReCa
2083
5007
1120
1550
271 Lisbon HoReCa 514
8323
6869
272 Other HoReCa
3
6817
1493
4802
1824
273 Other HoReCa 894
1703
1
841
1153
274 Other HoReCa 680
1610
275 Other HoReCa
27901
3749
6964
4479
2503
276 Other HoReCa
9061
1691
277 Other HoReCa
11693
2317
2543
5845
1409
278 Other Retail
17360
6200
3620
1721
279 Other HoReCa
3366
2884
2431
1104
280 Other Retail
12238
6235
1093
2328
2079
281
49063
3965
4252
597
1041
1404
282 Other HoReCa
25767
3613
2013
10303
1384
283 Other HoReCa
68951
4411
12609
751
284 Other HoReCa
4025
3
600
285 Other HoReCa 7149
2247
1619
1226
286 Other HoReCa
1535
2102
2828
8366
1027
287 Other HoReCa
16260
1296
848
288 Other HoReCa
42786
1388
289 Other HoReCa
2708
2160
2642
290
6022
3354
3261
2507
291 Other HoReCa
2838
3086
4329
1060
292
Oporto
3996
1
1103
12469
902
5952
293 Oporto HoReCa
21273
6550
1854
294 Oporto Retail
7588
1897
5234
2208
295 Oporto HoReCa
19087
1304
3643
296 Oporto Retail
8090
3199
6986
1455
3
712
297 Oporto Retail
6758
4560
9965
934
4538
298 Oporto HoReCa 444
879
2060
299 Oporto Retail
16448
6243
6360
2662
2005
300 Oporto Retail
5283
13316
20399
1809
8752
301 Oporto Retail
2886
5302
978
6236
302 Oporto Retail
2599
3688
13829
10069
303 Oporto Retail 161
7460
24773
617
11783
2410
304 Oporto Retail 243
12939
8852
3909
305
6468
12867
21570
1840
7
558
1543
306 Oporto HoReCa
17327
2374
2842
1149
351
307
6987
3007
308 Oporto Retail 918
20655
13567
1465
6846
309 Oporto HoReCa
7034
1492
2405
12569
310 Oporto HoReCa
29635
2335
8280
3046
311
3737
19172
1274
17120
312 Oporto HoReCa
9784
4447
313 Oporto HoReCa
10617
1795
7647
1483
1233
314 Oporto Retail
1479
14982
11924
3891
3508
315 Oporto HoReCa
7127
1375
2201
2679
1059
316 Oporto HoReCa
1182
3088
6114
1637
317 Oporto HoReCa
11800
2713
3558
2121
706
318 Oporto Retail
9759
25071
17645
1128
1
2408
1625
319 Oporto HoReCa 1774
3696
2280
320 Oporto HoReCa
915
5167
2714
321 Oporto HoReCa
15881
3315
1470
322 Oporto HoReCa
13360
11593
1679
323 Oporto HoReCa
25977
2464
2369
324 Oporto HoReCa
4414
1431
3498
325 Oporto HoReCa 542 899
1664
326 Oporto HoReCa
16933
3389
7849
327 Oporto HoReCa
5113
1486
4583
5127
739
328 Oporto HoReCa
9790
1786
5109
3570
1043
329 Oporto Retail
11223
14881
26839
1234
9606
1102
330 Oporto HoReCa
2232
3216
2602
331 Oporto Retail
8565
4980
67298
38102
332 Oporto Retail
16823
928
2
743
11559
3486
333 Oporto Retail
27082
10790
1365
4111
2139
334 Oporto HoReCa
13970
1511
335 Oporto HoReCa
935
1347
2611
336 Oporto HoReCa 3 333
7021
15601
337 Oporto HoReCa
2617
1188
9584
1942
338 Other Retail 381 4025 9670 388
7271
1371
339 Other Retail 2320
5763
1
1238
5162
2158
340 Other HoReCa 255
5758
5923
4595
341 Other Retail
1689
26316
1456
15469
342
3043
1172
1763
2234
343 Other HoReCa
1198
8335
3843
344 Other Retail
2771
6939
15541
2693
6600
345 Other Retail
27380
7184
12311
2809
4621
1022
346 Other HoReCa
3428
2380
2028
1341
1184
347 Other Retail
5981
14641
20521
12218
348 Other HoReCa
3521
1099
1
997
1796
349 Other Retail 1210
10044
22294
1741
1263
3137
350 Other HoReCa 608
1106
1533
351 Other Retail 117
6264
21203
8682
352 Other HoReCa
14039
7393
2548
6386
1333
2341
353 Other HoReCa 190 727
2012
354 Other HoReCa
22686
3157
355 Other Retail 37 1275
22272
6747
356 Other HoReCa 759
18664
1660
4100
357 Other HoReCa 796
5878
2109
358 Other HoReCa
19746
2872
2006
2601
359 Other HoReCa
4734
607
1206
360 Other HoReCa 2121
1601
2453
361 Other HoReCa
4627
1335
362 Other HoReCa
2615
873
1524
363 Other Retail
4692
6128
8025
4515
3105
364 Other HoReCa
9561
2217
365 Other HoReCa
3477
1457
366 Other HoReCa
22335
1196
367 Other HoReCa
6211
1089
368 Other Retail
39679
3944
4955
2235
369 Other HoReCa
20105
1887
1939
8164
370 Other HoReCa
3884
3801
1641
4829
371 Other Retail
15076
6257
7398
1504
1916
3113
372 Other HoReCa
6338
2256
1668
373 Other HoReCa
5841
1162
374 Other Retail
3136
8630
13586
5641
4666
1426
375 Other HoReCa
38793
3154
2648
1034
376
3225
3294
1902
1114
377 Other Retail
4048
5164
378 Other HoReCa
2
8257
2146
3881
379 Other HoReCa
17770
1617
9927
380 Other HoReCa
34454
7
435
8469
2893
381 Other HoReCa
1821
3450
4006
382 Other HoReCa
1068
21858
15400
3635
5120
383 Other HoReCa
1163
922
2583
384 Other HoReCa 1206 3620
2857
1945
385
20918
1573
1960
386 Other HoReCa
9785
387 Other HoReCa
9385
1530
3019
388 Other HoReCa
3352
5502
389 Other HoReCa
2647
2761
1827
390 Other HoReCa 518
4180
3600
391 Other HoReCa
23
632
6730
3842
8620
392 Other HoReCa
12377
3204
1398
393 Other HoReCa
9602
1316
2921
394 Other Retail 4515
11991
9345
2644
2213
395 Other HoReCa
11535
1666
1428
6838
396 Other HoReCa
11442
5390
397 Other HoReCa
9612
398 Other HoReCa
4446
399 Other HoReCa
27167
2801
2128
13223
400 Other HoReCa
26539
4753
5091
401
25606
11006
4604
402 Other HoReCa
18073
4613
3444
403 Other HoReCa
6884
1046
1167
2069
404 Other HoReCa
25066
5010
5026
9806
405 Other Retail
7362
12844
18683
2854
7883
406 Other Retail 8257
3880
6407
1646
2730
407 Other HoReCa
8708
3634
6100
2349
2123
5137
408 Other HoReCa
6633
1389
1892
409 Other HoReCa
2126
3289
3281
4365
410 Other HoReCa 97 3605
12400
2970
411 Other HoReCa
4983
4859
17866
912
2435
412 Other HoReCa
5969
1990
3417
5679
1135
413
7842
6046
8552
3540
1874
414 Other Retail
4389
10940
10908
6728
415 Other HoReCa 5065
5499
11055
3485
1063
416 Other Retail 660
8494
18622
6740
417 Other HoReCa
8861
3783
2223
1580
418 Other HoReCa
4456
5266
13227
419
17063
4847
9053
1031
3415
1784
420 Other HoReCa
26400
1377
4172
421
17565
3686
4657
1803
422 Other Retail
1698
12232
3213
423 Other HoReCa
11243
2593
15348
1886
424 Other HoReCa
13134
9347
14316
3141
5079
1894
425 Other HoReCa
31012
16687
5429
15082
426 Other HoReCa 3047
5970
4910
2198
427 Other HoReCa
8607
1750
3580
428 Other HoReCa
3097
4230
16483
2080
429 Other HoReCa 8533
5506
5160
13486
430 Other HoReCa
21117
4754
431 Other HoReCa
1982
3218
1541
1449
432 Other HoReCa
16731
3922
7994
2371
433 Other HoReCa
29703
12051
16027
13135
434 Other HoReCa
39228
4510
2346
435 Other Retail
14531
15488
30243
437
14841
1867
436 Other HoReCa
10290
1038
2125
437 Other HoReCa
2787
2510