Store & Region Sales Database
ID
Store No
Sales Region
Item No
Item Description
Unit Price
Units Sold
Week Ending
1
1
South
2005
17″ Monitor
$229.00
28
10/27/2012
2
1
South
2005
17″ Monitor
$229.00
30
11/24/2012
3
1
South
2005
17″ Monitor
$229.00
9
12/29/2012
1
South
3006
101 Keyboard
$19.95
30
10/27/2012
1
South
3006
101 Keyboard
$19.95
35
11/24/2012
1
South
3006
101 Keyboard
$19.95
39
12/29/2012
7
1
South
6050
PC Mouse
28
10/27/2012
8
1
South
6050
PC Mouse
$8.95
3
11/24/2012
9
1
South
6050
PC Mouse
38
12/29/2012
10
1
South
8500
Desktop CPU
25
10/27/2012
11
1
South
8500
Desktop CPU
27
11/24/2012
12
1
South
8500
Desktop CPU
33
12/29/2012
13
2
South
2005
17″ Monitor
8
10/27/2012
14
2
South
2005
17″ Monitor
$229.00
8
11/24/2012
15
2
South
2005
17″ Monitor
$229.00
10
12/29/2012
16
2
South
3006
101 Keyboard
$19.95
8
10/27/2012
17
2
South
3006
101 Keyboard
$19.95
8
11/24/2012
18
2
South
3006
101 Keyboard
$19.95
8
12/29/2012
19
2
South
6050
PC Mouse
$8.95
9
10/27/2012
20
2
South
6050
PC Mouse
9
11/24/2012
21
2
South
6050
PC Mouse
8
12/29/2012
22
2
South
8500
Desktop CPU
$849.95
18
10/27/2012
23
2
South
8500
Desktop CPU
18
11/24/2012
24
2
South
8500
Desktop CPU
20
12/29/2012
25
3
South
2005
17″ Monitor
38
10/27/2012
26
3
South
2005
17″ Monitor
$229.00
30
11/24/2012
27
3
South
2005
17″ Monitor
$229.00
3
12/29/2012
28
3
South
3006
101 Keyboard
30
10/27/2012
29
3
South
3006
101 Keyboard
$19.95
32
11/24/2012
30
3
South
3006
101 Keyboard
$19.95
33
12/29/2012
31
3
South
6050
PC Mouse
$8.95
25
10/27/2012
32
3
South
6050
PC Mouse
$8.95
5
11/24/2012
33
3
South
6050
PC Mouse
$8.95
26
12/29/2012
34
3
South
8500
Desktop CPU
$849.95
28
10/27/2012
35
3
South
8500
Desktop CPU
$849.95
27
11/24/2012
36
3
South
8500
Desktop CPU
29
12/29/2012
37
4
North
2005
17″ Monitor
18
10/27/2012
38
4
North
2005
17″ Monitor
20
11/24/2012
39
4
North
2005
17″ Monitor
$229.00
4
12/29/2012
40
4
North
3006
101 Keyboard
12
10/27/2012
Store & Region Sales Database
ID
Store No
Sales Region
Item No
Item Description
Unit Price
Units Sold
Week Ending
43
4
North
6050
PC Mouse
$8.95
29
10/27/2012
44
4
North
6050
PC Mouse
$8.95
11
11/24/2012
45
4
North
6050
PC Mouse
$8.95
38
12/29/2012
46
4
North
8500
Desktop CPU
$849.95
21
10/27/2012
47
4
North
8500
Desktop CPU
$849.95
24
11/24/2012
48
4
North
8500
Desktop CPU
$849.95
30
12/29/2012
49
5
North
2005
17″ Monitor
27
10/27/2012
50
5
North
2005
17″ Monitor
$229.00
25
11/24/2012
51
5
North
2005
17″ Monitor
23
12/29/2012
52
5
North
3006
101 Keyboard
80
10/27/2012
53
5
North
3006
101 Keyboard
82
11/24/2012
54
5
North
3006
101 Keyboard
75
12/29/2012
55
5
North
6050
PC Mouse
65
10/27/2012
56
5
North
6050
PC Mouse
$8.95
24
11/24/2012
57
5
North
6050
PC Mouse
$8.95
55
12/29/2012
58
5
North
8500
Desktop CPU
$849.95
55
10/27/2012
59
5
North
8500
Desktop CPU
$849.95
57
11/24/2012
60
5
North
8500
Desktop CPU
$849.95
47
12/29/2012
61
6
East
2005
17″ Monitor
$229.00
24
10/27/2012
62
6
East
2005
17″ Monitor
85
11/24/2012
63
6
East
2005
17″ Monitor
56
12/29/2012
64
6
East
3006
101 Keyboard
52
10/27/2012
65
6
East
3006
101 Keyboard
58
11/24/2012
66
6
East
3006
101 Keyboard
69
12/29/2012
67
6
East
6050
PC Mouse
35
10/27/2012
68
6
East
6050
PC Mouse
$8.95
39
11/24/2012
69
6
East
6050
PC Mouse
$8.95
44
12/29/2012
70
6
East
8500
Desktop CPU
78
10/27/2012
71
6
East
8500
Desktop CPU
$849.95
88
11/24/2012
72
6
East
8500
Desktop CPU
$849.95
99
12/29/2012
73
7
East
2005
17″ Monitor
$229.00
34
10/27/2012
74
7
East
2005
17″ Monitor
$229.00
36
11/24/2012
75
7
East
2005
17″ Monitor
$229.00
35
12/29/2012
76
7
East
3006
101 Keyboard
49
10/27/2012
77
7
East
3006
101 Keyboard
47
11/24/2012
78
7
East
3006
101 Keyboard
48
12/29/2012
79
7
East
6050
PC Mouse
45
10/27/2012
80
7
East
6050
PC Mouse
42
11/24/2012
81
7
East
6050
PC Mouse
$8.95
45
12/29/2012
82
7
East
8500
Desktop CPU
55
10/27/2012
Store & Region Sales Database
Page 3
ID
Store No
Sales Region
Item No
Item Description
Unit Price
Units Sold
Week Ending
85
8
East
2005
17″ Monitor
$229.00
18
10/27/2012
86
8
East
2005
17″ Monitor
$229.00
17
11/24/2012
87
8
East
2005
17″ Monitor
$229.00
23
12/29/2012
91
8
East
6050
PC Mouse
14
10/27/2012
92
8
East
6050
PC Mouse
16
11/24/2012
93
8
East
6050
PC Mouse
17
12/29/2012
Best Performing Regions by Total Sales
Sales Region
Weekly Sales
East
$529,124.80
North
$233,832.75
Best Performing Stores by Total Sales
Page 1
Store No
Weekly Sales
6
$267,648.90
7
$170,040.85
5
$158,334.00
4
2
Best Selling Products by Quantity
Page 1
Item No
Item Description
Unit Price
Units Sold
Week Ending
Weekly Sales
2005
17″ Monitor
$229.00
85
11/24/2012
$19,465.00
2005
17″ Monitor
$229.00
24
10/27/2012
$5,496.00
2005
17″ Monitor
$229.00
23
12/29/2012
$5,267.00
2005
17″ Monitor
$229.00
23
12/29/2012
$5,267.00
2005
17″ Monitor
$229.00
20
11/24/2012
$4,580.00
2005
17″ Monitor
$229.00
18
10/27/2012
$4,122.00
2005
17″ Monitor
$229.00
18
10/27/2012
$4,122.00
2005
17″ Monitor
$229.00
17
11/24/2012
$3,893.00
2005
17″ Monitor
$229.00
10
12/29/2012
$2,290.00
2005
17″ Monitor
$229.00
12/29/2012
$2,061.00
2005
17″ Monitor
$229.00
11/24/2012
$1,832.00
2005
17″ Monitor
$229.00
10/27/2012
$1,832.00
2005
17″ Monitor
$229.00
12/29/2012
$916.00
2005
17″ Monitor
$229.00
12/29/2012
$687.00
3006
101 Keyboard
$19.95
82
11/24/2012
$1,635.90
3006
101 Keyboard
$19.95
80
10/27/2012
$1,596.00
3006
101 Keyboard
$19.95
75
12/29/2012
$1,496.25
3006
101 Keyboard
$19.95
69
12/29/2012
$1,376.55
3006
101 Keyboard
$19.95
58
11/24/2012
$1,157.10
3006
101 Keyboard
$19.95
52
10/27/2012
$1,037.40
3006
101 Keyboard
$19.95
49
10/27/2012
$977.55
3006
101 Keyboard
$19.95
48
12/29/2012
$957.60
3006
101 Keyboard
$19.95
47
11/24/2012
3006
101 Keyboard
$19.95
39
12/29/2012
3006
101 Keyboard
$19.95
36
12/29/2012
3006
101 Keyboard
$19.95
35
11/24/2012
$698.25
3006
101 Keyboard
$19.95
33
12/29/2012
3006
101 Keyboard
$19.95
32
11/24/2012
$638.40
3006
101 Keyboard
$19.95
30
10/27/2012
3006
101 Keyboard
$19.95
30
10/27/2012
3006
101 Keyboard
$19.95
22
10/27/2012
$438.90
2005
17″ Monitor
$229.00
56
12/29/2012
2005
17″ Monitor
$229.00
38
10/27/2012
$8,702.00
2005
17″ Monitor
$229.00
36
11/24/2012
$8,244.00
2005
17″ Monitor
$229.00
35
12/29/2012
$8,015.00
2005
17″ Monitor
$229.00
34
10/27/2012
$7,786.00
2005
17″ Monitor
$229.00
30
11/24/2012
$6,870.00
2005
17″ Monitor
$229.00
30
11/24/2012
$6,870.00
2005
17″ Monitor
$229.00
28
10/27/2012
$6,412.00
2005
17″ Monitor
$229.00
27
10/27/2012
$6,183.00
2005
17″ Monitor
$229.00
25
11/24/2012
$5,725.00
Best Selling Products by Quantity
Page 2
Item No
Item Description
Unit Price
Units Sold
Week Ending
Weekly Sales
3006
101 Keyboard
$19.95
22
12/29/2012
$438.90
6050
PC Mouse
$8.95
42
11/24/2012
$375.90
6050
PC Mouse
$8.95
39
11/24/2012
$349.05
6050
PC Mouse
$8.95
38
12/29/2012
$340.10
6050
PC Mouse
$8.95
38
12/29/2012
$340.10
6050
PC Mouse
$8.95
35
10/27/2012
$313.25
6050
PC Mouse
$8.95
29
10/27/2012
$259.55
6050
PC Mouse
$8.95
28
10/27/2012
$250.60
6050
PC Mouse
$8.95
26
12/29/2012
$232.70
6050
PC Mouse
$8.95
25
10/27/2012
$223.75
6050
PC Mouse
$8.95
24
11/24/2012
$214.80
6050
PC Mouse
$8.95
17
12/29/2012
$152.15
6050
PC Mouse
$8.95
16
11/24/2012
$143.20
6050
PC Mouse
$8.95
14
10/27/2012
$125.30
6050
PC Mouse
$8.95
11
11/24/2012
$98.45
6050
PC Mouse
$8.95
9
10/27/2012
$80.55
6050
PC Mouse
$8.95
9
11/24/2012
$80.55
6050
PC Mouse
$8.95
8
12/29/2012
$71.60
6050
PC Mouse
$8.95
5
11/24/2012
$44.75
6050
PC Mouse
$8.95
3
11/24/2012
$26.85
8500
Desktop CPU
$849.95
99
12/29/2012
$84,145.05
8500
Desktop CPU
$849.95
88
11/24/2012
$74,795.60
8500
Desktop CPU
78
10/27/2012
8500
Desktop CPU
57
11/24/2012
8500
Desktop CPU
57
11/24/2012
8500
Desktop CPU
$849.95
55
10/27/2012
$46,747.25
8500
Desktop CPU
55
12/29/2012
8500
Desktop CPU
$849.95
55
10/27/2012
$46,747.25
8500
Desktop CPU
47
12/29/2012
8500
Desktop CPU
33
12/29/2012
8500
Desktop CPU
$849.95
30
12/29/2012
$25,498.50
3006
101 Keyboard
18
11/24/2012
$359.10
3006
101 Keyboard
$19.95
12
10/27/2012
$239.40
3006
101 Keyboard
8
12/29/2012
$159.60
3006
101 Keyboard
8
11/24/2012
$159.60
3006
101 Keyboard
8
10/27/2012
$159.60
6050
PC Mouse
$8.95
65
10/27/2012
$581.75
6050
PC Mouse
$8.95
55
12/29/2012
$492.25
6050
PC Mouse
$8.95
45
10/27/2012
$402.75
6050
PC Mouse
$8.95
45
12/29/2012
$402.75
6050
PC Mouse
$8.95
44
12/29/2012
$393.80
Best Selling Products by Quantity
Page 3
Item No
Item Description
Unit Price
Units Sold
Week Ending
Weekly Sales
8500
Desktop CPU
$849.95
30
12/29/2012
$25,498.50
8500
Desktop CPU
$849.95
18
11/24/2012
$15,299.10
8500
Desktop CPU
$849.95
28
10/27/2012
$23,798.60
8500
Desktop CPU
$849.95
28
11/24/2012
$23,798.60
8500
Desktop CPU
$849.95
25
10/27/2012
$21,248.75
8500
Desktop CPU
$849.95
21
10/27/2012
$17,848.95
Best Selling Products by Units Sold
Page 1
Item No
Item Description
SumOfUnits Sold
8500
Desktop CPU
981
6050
PC Mouse
670
Best Selling Products by Weekly Sales
Page 1
Item No
Item Description
Weekly Sales
8500
Desktop CPU
$833,800.95
3006
101 Keyboard
Strongest Sales Region by Product Quantity
Page 1
Item No
Item Description
SumOfUnits Sold
Sales Region
2005
17″ Monitor
328
East
2005
17″ Monitor
164
South
2005
17″ Monitor
117
North
6050
PC Mouse
297
East
6050
PC Mouse
222
North
6050
PC Mouse
151
South
Strongest Sales Regions by Product Sales
Page 1
Item No
Item Description
Weekly Sales
Sales Region
2005
17″ Monitor
$75,112.00
East
2005
17″ Monitor
$37,556.00
South
2005
17″ Monitor
$26,793.00
North
6050
PC Mouse
East
6050
PC Mouse
North
6050
PC Mouse
South
Strongest Selling Periods (by Product)
Page 1
Item No
Item Description
Week Ending
SumOfUnits Sold
2005
17″ Monitor
11/24/2012
251
2005
17″ Monitor
10/27/2012
195
2005
17″ Monitor
12/29/2012
163
6050
PC Mouse
12/29/2012
271
6050
PC Mouse
10/27/2012
250
6050
PC Mouse
11/24/2012
149
Strongest Selling Periods (by Sales Region)
Page 1
Sales Region
Week Ending
SumOfUnits Sold
East
12/29/2012
543
East
11/24/2012
531
East
10/27/2012
458
South
10/27/2012
275
South
12/29/2012
256
South
11/24/2012
232
Strongest Selling Periods (by Store)
Page 1
Store No
Week Ending
SumOfUnits Sold
1
12/29/2012
119
1
10/27/2012
111
1
11/24/2012
95
2
12/29/2012
46
2
10/27/2012
43
6
11/24/2012
270
6
12/29/2012
268
6
10/27/2012
189
7
10/27/2012
183
7
12/29/2012
183
7
11/24/2012
182
8
12/29/2012
92
8
10/27/2012
86
8
11/24/2012
79
2
11/24/2012
43
3
10/27/2012
121
3
11/24/2012
3
12/29/2012
91
4
12/29/2012
108
4
10/27/2012
80
4
11/24/2012
79
5
10/27/2012
227
5
12/29/2012
200
5
11/24/2012
188
Strongest Stores by Product Quantity
Page 1
Item No
Item Description
SumOfUnits Sold
Store No
2005
17″ Monitor
165
6
2005
17″ Monitor
105
7
2005
17″ Monitor
75
5
2005
17″ Monitor
71
3
2005
17″ Monitor
67
1
2005
17″ Monitor
58
8
2005
17″ Monitor
42
4
2005
17″ Monitor
26
2
6050
PC Mouse
118
6
6050
PC Mouse
78
4
6050
PC Mouse
69
1
6050
PC Mouse
56
3
6050
PC Mouse
47
8
6050
PC Mouse
26
2
8500
Desktop CPU
265
6
8500
Desktop CPU
167
7
8500
Desktop CPU
159
5
8500
Desktop CPU
90
8
8500
Desktop CPU
85
1
8500
Desktop CPU
84
3
8500
Desktop CPU
75
4
8500
Desktop CPU
56
2
3006
101 Keyboard
237
5
3006
101 Keyboard
179
6
3006
101 Keyboard
144
7
3006
101 Keyboard
1
3006
101 Keyboard
95
3
3006
101 Keyboard
72
4
3006
101 Keyboard
62
8
3006
101 Keyboard
24
2
6050
PC Mouse
144
5
6050
PC Mouse
132
7
Strongest Stores by Product Sales
Page 1
Item No
Item Description
Weekly Sales
Store No
2005
17″ Monitor
$37,785.00
6
2005
17″ Monitor
$24,045.00
7
2005
17″ Monitor
$17,175.00
5
3006
101 Keyboard
$1,436.40
4
3006
101 Keyboard
$1,236.90
8
3006
101 Keyboard
$478.80
2
6050
PC Mouse
$1,288.80
5
6050
PC Mouse
$1,181.40
7
6050
PC Mouse
$1,056.10
6
6050
PC Mouse
4
6050
PC Mouse
1
6050
PC Mouse
3
6050
PC Mouse
$420.65
8
6050
PC Mouse
$232.70
2
8500
Desktop CPU
6
8500
Desktop CPU
7
8500
Desktop CPU
5
8500
Desktop CPU
$76,495.50
8
8500
Desktop CPU
$72,245.75
1
8500
Desktop CPU
$71,395.80
3
8500
Desktop CPU
$63,746.25
4
8500
Desktop CPU
$47,597.20
2
2005
17″ Monitor
$16,259.00
3
2005
17″ Monitor
$15,343.00
1
2005
17″ Monitor
$13,282.00
8
2005
17″ Monitor
$9,618.00
4
2005
17″ Monitor
$5,954.00
2
3006
101 Keyboard
$4,728.15
5
3006
101 Keyboard
$3,571.05
6
3006
101 Keyboard
$2,872.80
7
3006
101 Keyboard
1
3006
101 Keyboard
$1,895.25
3
Best Performing Regions by Total Sales
Weekly Sales
Sales Region
$529,124.80
East
Page 1 of 1