Future of Fashion Merchandising FMM 605
Assignment 1: October 2007
Assignment Briefing:
Attached and in Exel spreadsheets loaded on to Blackboard are a series of tables with raw data that has been produced by a fashion retailers’ Management Information System. The tables include :- customer information, records of transactions, sales and stock information. The information has been collected over the last 8 years, reflects 67 993 customer records of which 34, 856 have made a purchase of some sort.
You have been asked by your Head of Merchandising to interpret, explain and analyse each table and consider what this set of data as a whole can tell the company about its sales and customers and how it can be used to improve sales and profit in the future.
The report (1500-2000 words max) should include charts, diagrams or graphs to illustrate your answer. Ensure the report shows you understand each set of data, any weaknesses in the data and the cumulative impact of all the information derived.
Table 1.
Combinations of Product Areas
Number of Customers
Casual wear, Evening wear and any Accessories
728
Casual wear and Evening wear
1,321
Casual wear and any Accessories
713
Evening wear and any Accessories
2,209
Any Accessories only
22,536
Evening wear only
5,376
Casual wear only
1,973
Total casual wear (past and active)
4,735
Tables 2 and 3 are concerned with how long customers are retained
Set up Year
0
1
2
3
4
5
6
7
8
1998
3
24
27
7
24
6
3
20
33
1999
5
19
15
19
48
10
56
56
2000
3
25
22
26
19
34
48
2001
31
52
40
35
231
51
2002
30
70
60
239
289
2003
33
85
242
461
2004
19
86
204
2005
186
219
2006
17
Total
327
580
610
787
611
101
107
76
33
Set up Year
0
1
2
3
4
5
6
7
8
1998
111
399
800
1086
1436
1850
2262
2650
2868
1999
144
364
713
1110
1444
1848
2233
2502
2000
141
347
723
1079
1417
1872
2151
2001
105
376
728
1095
1507
1753
2002
107
358
721
1141
1377
2003
99
375
814
1005
2004
121
469
647
2005
85
299
2006
31
ΣAvg
105
373
735
1086
1436
1831
2215
2576
2868
.
Table 4s show how many customers increased and decreased respectively their monthly spend over their first 36 months starting in their 3rd month
Table 4.
Month
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Increase
84
90
74
83
103
67
74
114
54
90
106
96
93
101
86
104
98
Decrease
51
104
96
70
71
100
77
73
77
46
80
76
48
70
68
73
83
Month
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
Increase
74
81
70
74
83
68
77
87
78
71
90
58
67
80
66
77
76
Decrease
71
73
103
56
54
73
54
57
60
51
77
70
48
56
47
66
54
Market Basket Analysis
The provided data set (Excel spreadsheet) shows a summary of sales by transaction and stock position for the first 10 days of September across 9 product lines.
Data sample
The provided data set (Excel spreadsheet) shows a sample of customer name and address data.
0 comments:
Post a Comment