Sales Analysis by Average
Sales Analysis by Average
Sales Analysis by Average
Almuntazah Markets
Export Filters
FROM DATE
TO DATE
INVENTORY AS ON
No.
Include Promotion Items
Item Special Group
ANLYSIS BY
NO. OF MONTHS AVERAGE
FACTOR FOR NEW AVERAGE
No.
No.
108705
108706
108707
108708
108709
108710
115675
115678
115680
115681
115682
115689
115690
115692
115693
115694
115695
01/21/2015
STS
Page 1
01/21/2015
STS
Page 2
01/21/2015
STS
Page 3
20/06/11
06/08/13
06/08/13
115708|115689|115690|108705|108706|108707|108708|108709|108710|115680|115681|115682|115692|115696|115697|115678|115693|115
Yes
FOREIGN
Quantity
1
30
Description
Description
MOON IRON LOCK (KAT-222) 1X1
MOON IRON LOCK (KAT-223) 1X1
MOON IRON LOCK (KAT-224) 1X1
MOON P/LOCK 682G (KAT-227) 1X1
MOON IRON LOCK (KAT-225) 1X1
MOON P/LOCK 482G (KAT-226) 1X1
B/CP SPAIN (61133) 100PCS 1X1
MAGIC DRAWING BORAD TQ8014 1X1
3X6 LASER PP MAT 1X1
6X9 LASER PP MAT 1X1
9X12 LASER PP MAT 1X1
FLASHER PLASTIC LED TORCH 1X1
LED IRON TORCH FT2DE9 1X1
24PCS CLOTH PINS FC1-2 1X1
MAGIC DRAWING BORAD TQ2986 1X1
W/BOARD W/ALPHABET YL-228B 1X1
W/BOARD ALPHABET TQ-123A 1X1
01/21/2015
STS
Page 4
01/21/2015
STS
Page 5
Brand
Brand
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
GEEP
TIGER-HEAD
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
FAKHRUDDIN
UOM Purch.
UOM Policy Vendor No Vendor Name
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
PC
19720 FAKHRUDDIN GEN.
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
TRADING
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
CO.
HIDD
HIDD
HIDD
Sales Qty. Months Avg Stock Mandatory
0
0
0
0
0
0
0
0
0
0
0
0
0
0 NA
0
0 NA
0
0 NA
0
0 NA
0
0 NA
0
0 NA
0
0 NA
0
0 NA
0
0 NA
0
0 NA
0
0 NA
ST
ST
DZ
0
0
0
0 NA
0 NA
0 NA
01/21/2015
STS
Page 6
01/21/2015
STS
Page 7
HIDD
HIDD
HIDD
HIDD
ISSA
ISSA
ISSA
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months Avg Stock Mandatory
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0
0
0
0
0
0
0
0 NA
0 NA
0 NA
01/21/2015
STS
Page 8
01/21/2015
STS
Page 9
ISSA
ISSA
ISSA
ISSA
MAIN
MAIN
MAIN
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months Avg Stock Mandatory
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
01/21/2015
STS
Page 10
01/21/2015
STS
Page 11
MAIN
MAIN
MAIN
MAIN
SITRA
SITRA
SITRA
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months Avg Stock Mandatory
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0
0
0
0
0
0
0
0 NA
0 NA
0 NA
01/21/2015
STS
Page 12
SITRA
SITRA
SITRA
SITRA
SM01
SM01
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
0
0
41
0
0
0
0
81
0
0
0
0
37
0
0
0
0
29
0
0
0
0
38
0
0
0
0
31
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
17
0
0
0
0
7
0
0
0
0
24
0
0
0
0
3
0
0
0
0
0
0
0
0
0
0
01/21/2015
STS
Page 13
SM01
Avg Stock Mandatory
1.58 A
3.12 A
1.43 A
1.12 A
1.47 A
1.2 A
0C
0C
0.04 C
0C
0C
0.66 A
0.27 A
0.93 A
0.12 C
0C
0C
0
0
0
0
0
0
0
0
0
0
0
2
0C
0C
0.08 A
01/21/2015
STS
Page 14
SM01
SM01
SM01
SM01
SM02
SM02
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
489
0.08
42
0
0
138
0.59
64
0
0
120
0.31
70
0
0
297
0.1
77
0
0
491
0.08
84
0
0
471
0.07
91
0
0
0
0
0
0
0
0
0
0
0
0
1
1
0
0
0
0
0
5
0
0
0
0
4
5
0
692
0.02
3
0
0
276
0.03
15
0
0
68
0.35
12
0
0
88
0.03
0
0
0
0
0
1
0
0
0
0
0
01/21/2015
STS
Page 15
SM02
Avg Stock Mandatory
1.62 A
2.47 A
2.7 A
2.97 A
3.24 A
3.51 A
0C
0C
0C
0.19 C
0.15 C
0.12 A
0.58 A
0.46 A
0C
0.04 C
0C
0
0
0
0
0
62
0
0
0.03
2
1
3
0.08 C
0.04 C
0.12 A
01/21/2015
STS
Page 16
SM02
SM02
SM02
SM02
SM03
SM03
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
548
0.08
76
0
0
58
1.1
44
0
0
162
0.43
36
0
0
663
0.12
32
0
0
353
0.24
23
0
0
306
0.3
45
0
0
0
0
25
0
0
0
0
7
0
0
0
0
12
0
0
466
0.01
10
0
0
121
0.03
11
0
0
540
0.01
17
0
0
556
0.03
48
0
0
49
0.24
24
7
0
702
0
7
4
0
702
0
14
0
0
0
0
4
01/21/2015
STS
Page 17
SM03
Avg Stock Mandatory
2.93 A
1.7 A
1.39 A
1.23 A
0.89 A
1.74 A
0.96 A
0.27 C
0.46 C
0.39 C
0.42 C
0.66 A
1.85 A
0.93 A
0.27 C
0.54 C
0.15 C
0
0
0
514
514
48
0
0
0.06
18
27
2.92
0.69 C
1.04 C
0.11 A
01/21/2015
STS
Page 18
SM03
SM03
SM03
SM03
SM04
SM04
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
537
0.14
144
0
0
142
0.31
49
0
0
143
0.25
30
4
0
767
0.04
27
0
0
142
0.16
46
-3
0
377
0.12
29
0
0
85
0.29
16
0
0
142
0.05
1
0
0
61
0.2
5
0
0
499
0.02
6
0
0
518
0.02
5
0
0
143
0.12
17
0
0
500
0.1
17
0
0
27
0.89
36
0
0
514
0.01
6
0
0
68
0.21
15
0
0
95
0.04
6
01/21/2015
STS
Page 19
SM04
Avg Stock Mandatory
5.55 A
1.89 A
1.16 A
1.04 A
1.77 A
1.12 A
0.62 A
0.04 C
0.19 C
0.23 C
0.19 C
0.66 A
0.66 A
1.39 A
0.23 C
0.58 C
0.23 C
0
0
0
762
583
258
0.02
0.05
0.01
23
42
2.75
0.89 C
1.62 C
0.11 A
01/21/2015
STS
Page 20
01/21/2015
STS
Page 21
SM04
SM04
SM04
SM04
SM05
SM05
SM05
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months Avg Stock Mandatory
0
0
134
1.07
287
11.07 A
0
0
132
0.37
82
3.16 A
0
0
134
0.22
73
2.81 A
0
0
280
0.1
59
2.28 A
0
0
153
0.3
87
3.35 A
0
0
513
0.06
49
1.89 A
0
0
139
0.12
39
1.5 A
0
0
1
1
14
0.54 A
0
0
124
0.04
6
0.23 A
0
0
72
0.08
14
0.54 A
0
0
170
0.03
17
0.66 A
6
0
767
0.02
18
0.69 A
0
0
479
0.04
19
0.73 A
0
0
31
1.16
48
1.85 A
0
0
78
0.08
18
0.69 A
0
0
60
0.25
69
2.66 A
0
0
10
0.6
47
1.81 A
0
0
0
487
384
150
0.05
0.11
0.02
37
48
0
1.43 A
1.85 A
0A
01/21/2015
STS
Page 22
SM05
SM05
SM05
SM05
SM06
SM06
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
553
0.52
71
0
0
541
0.15
35
0
0
182
0.4
36
0
0
553
0.11
32
0
0
541
0.16
36
0
0
493
0.1
24
0
0
250
0.16
19
0
0
541
0.03
1
0
0
32
0.19
15
0
0
468
0.03
9
0
0
469
0.04
7
6
0
753
0.02
18
1
0
767
0.02
44
0
0
72
0.67
97
0
0
538
0.03
4
0
0
254
0.27
6
0
0
154
0.31
14
01/21/2015
STS
Page 23
SM06
Avg Stock Mandatory
2.74 A
1.35 A
1.39 A
1.23 A
1.39 A
0.93 A
0.73 A
0.04 A
0.58 A
0.35 A
0.27 A
0.69 A
1.7 A
3.74 A
0.15 A
0.23 A
0.54 A
0
0
0
767
761
0
0.05
0.06
0
43
21
2.92
1.66 A
0.81 A
0.11 A
01/21/2015
STS
Page 24
SM06
SM06
SM06
SM06
SM07
SM07
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
170
0.42
70
0
0
170
0.21
24
0
0
184
0.2
18
0
0
363
0.09
30
0
0
221
0.16
11
0
0
204
0.12
28
0
0
494
0.04
12
0
0
158
0.01
0
0
0
157
0.1
0
0
0
153
0.06
7
0
0
160
0.04
7
3
0
767
0.02
17
0
0
474
0.09
16
0
0
158
0.61
24
4
0
665
0.01
3
0
0
97
0.06
6
0
0
98
0.14
6
01/21/2015
STS
Page 25
SM07
Avg Stock Mandatory
2.7 A
0.93 A
0.69 A
1.16 A
0.42 A
1.08 A
0.46 A
0C
0C
0.27 C
0.27 C
0.66 A
0.62 A
0.93 A
0.12 C
0.23 A
0.23 A
0
0
0
715
344
191
0.06
0.06
0.02
30
17
2.92
1.16 A
0.66 A
0.11 A
01/21/2015
STS
Page 26
SM07
SM07
SM07
SM07
SM08
SM08
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
138
0.51
143
0
0
134
0.18
90
0
0
176
0.1
100
0
0
434
0.07
38
0
0
175
0.06
90
0
0
494
0.06
53
0
0
84
0.14
30
0
0
0
0
2
0
0
0
0
4
0
0
77
0.09
37
0
0
448
0.02
41
0
0
525
0.03
14
0
0
250
0.06
28
0
0
77
0.31
116
0
0
391
0.01
13
0
0
278
0.02
21
0
0
128
0.05
15
01/21/2015
STS
Page 27
SM08
Avg Stock Mandatory
5.51 A
3.47 A
3.86 A
1.47 A
3.47 A
2.04 A
1.16 A
0.08 C
0.15 C
1.43 C
1.58 C
0.54 A
1.08 A
4.47 A
0.5 C
0.81 C
0.58 C
0
0
0
370
429
175
0.08
0.04
0.02
34
53
2.83
1.31 A
2.04 A
0.11 A
01/21/2015
STS
Page 28
SM08
SM08
SM08
SM08
SM09
SM09
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
182
0.79
35
0
0
166
0.54
24
0
0
151
0.66
12
0
0
264
0.14
20
0
0
208
0.43
12
0
0
501
0.11
12
0
0
191
0.16
0
0
0
166
0.01
0
0
0
166
0.02
2
0
0
501
0.07
2
0
0
176
0.23
2
11
0
767
0.02
8
1
0
757
0.04
1
0
0
166
0.7
12
0
0
357
0.04
0
0
0
104
0.2
0
0
0
96
0.16
0
01/21/2015
STS
Page 29
SM09
Avg Stock Mandatory
1.35 A
0.93 A
0.46 A
0.77 A
0.46 A
0.46 A
0A
0C
0.08 C
0.08 C
0.08 C
0.31 A
0.04 A
0.46 A
0C
0C
0C
0
0
0
390
393
166
0.09
0.13
0.02
0
0
1
0A
0A
0.04 A
01/21/2015
STS
Page 30
SM09
SM09
SM09
SM09
SM10
SM10
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
486
0.07
33
0
0
220
0.11
22
0
0
130
0.09
12
1
0
779
0.03
15
0
0
132
0.09
12
0
0
430
0.03
12
0
0
0
0
14
0
0
0
0
3
0
0
131
0.02
4
0
0
178
0.01
2
0
0
183
0.01
1
0
0
569
0.01
10
0
0
569
0
14
0
0
78
0.15
15
0
0
0
0
0
0
0
0
0
7
0
0
0
0
0
01/21/2015
STS
Page 31
SM10
Avg Stock Mandatory
1.27 A
0.85 A
0.46 A
0.58 A
0.46 A
0.46 A
0.54 C
0.12 C
0.15 C
0.08 C
0.04 C
0.39 A
0.54 A
0.58 A
0C
0.27 C
0C
0
0
0
0
0
129
0
0
0.01
4
6
1.08
0.15 C
0.23 C
0.04 A
01/21/2015
STS
Page 32
SM10
SM10
SM10
SM10
SM12
SM12
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months
0
0
393
0.08
178
0
0
202
0.11
75
0
0
167
0.07
45
1
0
746
0.02
29
0
0
171
0.07
40
0
0
436
0.03
36
0
0
78
0.18
38
0
0
92
0.03
1
-2
0
163
0.02
0
0
0
151
0.01
0
0
0
498
0
0
1
0
767
0.01
9
0
0
523
0.03
22
0
0
56
0.27
22
0
0
0
0
0
0
0
100
0.07
3
0
0
0
0
0
01/21/2015
STS
Page 33
SM12
Avg Stock Mandatory
6.86 A
2.89 A
1.74 A
1.12 A
1.54 A
1.39 A
1.47 C
0.04 C
0C
0C
0C
0.35 A
0.85 A
0.85 A
0C
0.12 C
0C
0
0
0
123
53
162
0.03
0.11
0.01
25
12
1
0.96 C
0.46 C
0.04 A
01/21/2015
STS
Page 34
01/21/2015
STS
Page 35
SM12
SM12
SM12
SM12
SM13
SM13
SM13
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months Avg Stock Mandatory
0
0
206
0.86
0
0
0
0
478
0.16
0
0
0
0
90
0.5
0
0
0
0
429
0.07
0
0
0
0
478
0.08
0
0
0
0
478
0.08
0
0
0
0
268
0.14
0
0 NA
0
0
428
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
0
0
0
0
0
0 NA
3
0
767
0.01
0
0 NA
-2
0
309
0.07
0
0 NA
0
0
38
0.58
0
0 NA
0
0
0
0
0
0 NA
0
0
17
0.18
0
0 NA
0
0
0
0
0
0 NA
0
0
0
447
19
75
0.06
0.63
0.01
0
0
0
0 NA
0 NA
0 NA
01/21/2015
STS
Page 36
01/21/2015
STS
Page 37
SM13
SM13
SM13
SM13
SM16
SM16
SM16
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. Sales Qty. Months Avg Stock Mandatory
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
01/21/2015
STS
Page 38
01/21/2015
STS
Page 39
SM16
SM16
SM16
SM16
Inventory on 06/08/13 Qty.on PO New Avg. Days New Avg. Sales Qty. TOTAL SALES QTY. TOTAL for Months Avg
0
0
197
0
1,120
43.19
0
0
104
0
590
22.75
0
0
192
0
469
18.08
0
0
301
0
388
14.96
0
0
210
0
479
18.47
0
0
367
0
410
15.81
0
0
303
0
193
7.44
0
0
64
0
29
1.12
0
0
35
0
49
1.89
0
0
192
0
92
3.55
0
0
210
0
95
3.66
1
0
779
0
148
5.71
0
0
530
0
231
8.91
0
0
38
0
430
16.58
0
0
208
0
54
2.08
0
0
254
0
142
5.48
0
0
192
0
92
3.55
0
0
0
779
515
378
0
0
0
216
227
22.42
01/21/2015
STS
Page 40
8.33
8.75
0.86
01/21/2015
STS
Page 41
TOTAL Inventory On06/08/13 TOTAL Qty. on Purch. Order Statistics Group Item Category
0
0
777777 LOCK
0
0
777777 LOCK
0
0
777777 LOCK
6
0
777777 LOCK
0
0
777777 LOCK
-3
0
777777 LOCK
0
0
777777 NON-BATTER
0
0
777777 SCHOOL STA
-2
0
777777 PLASTICHO
0
0
777777 PLASTICHO
0
0
777777 PLASTICHO
36
0
777777 LIGHT
0
0
777777 LIGHT
0
0
777777 PLASTICHO
11
0
777777 SCHOOL STA
4
0
777777 SCHOOL STA
0
0
777777 SCHOOL STA
Product Group
IRON
IRON
IRON
IRON
IRON
IRON
BALLOON N
BOARD ST
MAT PLAST
MAT PLAST
MAT PLAST
TORCH
TORCH
HOOK PLAST
BOARD ST
BOARD ST
BOARD ST
0
0
0
777777 MISCHOUSE
777777 MISCHOUSE
777777 SHAVING
PARTY
PARTY
RAZOR
01/21/2015
STS
Page 42
01/21/2015
STS
Page 43
Invent.Posting Group Rebate % Promo % Tracking Staff ID Total New No. of Days Total New Avg.Sales Qty.
HARDWARE
4033
4.62
HARDWARE
2485
3.83
HARDWARE
1831
3.23
HARDWARE
5876
0.89
HARDWARE
3275
1.83
HARDWARE
5070
1.08
TOYS
1892
1.23
STATIONARY
1592
1.13
HOUSEHOLD
870
1.59
HOUSEHOLD
2757
0.38
HOUSEHOLD
2953
0.42
ELECTRICAL
7836
0.29
ELECTRICAL
5990
0.51
HOUSEHOLD
858
5.93
STATIONARY
3541
0.21
STATIONARY
1934
1.26
STATIONARY
773
1.3
5354
3995
1794
01/21/2015
STS
Page 44
0.44
1.19
0.21
01/21/2015
STS
Page 45
01/21/2015
STS
Page 46