6 Table
6 Table
6 Table
S.No
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
PRODUCT
LAPTOP
DESKTOP
SPEAKER
MOUSE
PRINTER
DVD
PROJECTOR
SCANNER
LCDS
MONITORS
CASSING
KEYBOARDS
MOUSE
CABLES
SWITCH
STABILIZER
PROCESSOR
MODEM
RAM
MOTHERBOARD
CD - ROM
CDS
POUCH
UPS
POWERSUPPLY
Quarter 1
39,431
32,980
14,035
19,609
38,143
41,566
45,971
35,772
30,162
39,155
27,899
10,422
25,686
41,035
45,654
46,428
28,280
35,831
27,669
40,650
14,284
12,376
44,019
33,518
34,304
Quarter 2
23,281
36,487
41,527
42,537
17,302
37,859
34,585
21,445
40,344
19,024
37,552
42,750
21,819
23,373
15,973
21,210
35,356
30,520
26,995
33,970
30,905
49,921
38,950
49,158
30,503
LAHORE REGION
S.No
1
2
3
4
5
6
7
PRODUCT
POWERSUPPLY
UPS
POUCH
CDS
CD - ROM
MOTHERBOARD
RAM
Quarter 1
Quarter 2
32,306
34,950
42,219
11,850
14,467
35,188
37,959
39,594
38,060
26,547
27,519
42,870
14,727
30,847
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
MODEM
PROCESSOR
STABILIZER
SWITCH
CABLES
MOUSE
KEYBOARDS
CASSING
MONITORS
LCDS
SCANNER
PROJECTOR
DVD
PRINTER
MOUSE
SPEAKER
DESKTOP
LAPTOP
38,632
35,883
16,562
14,114
24,746
24,813
36,438
18,501
43,686
19,393
22,847
12,400
31,648
38,470
26,866
45,838
46,288
17,770
43,847
43,604
27,976
32,573
18,068
37,687
27,042
16,607
33,308
44,153
17,941
23,354
49,194
27,456
39,330
42,839
33,914
26,620
Quarter 3
49,527
14,250
46,724
14,470
47,443
44,563
24,752
23,151
38,108
28,386
35,212
29,088
23,485
16,783
47,975
40,503
44,120
23,430
27,508
22,394
29,922
27,835
16,514
23,660
17,578
Quarter 3
Quarter 4
23,384
39,313
14,582
29,732
48,427
19,926
44,094
47,540
23,792
39,729
30,953
10,133
39,492
22,294
22,172
24,877
11,483
17,305
22,303
25,721
16,608
13,409
14,880
45,460
38,151
Quarter 4
38,855
30,181
31,789
21,606
40,913
40,258
15,239
17,861
38,688
16,143
16,221
21,072
11,560
35,004
S.No
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
41,199
31,371
17,319
38,578
46,703
46,221
22,510
32,203
21,840
42,616
45,883
21,807
19,327
34,261
31,276
43,153
13,756
36,736
24,270
23,900
37,418
14,245
21,748
39,758
23,093
27,343
23,002
31,456
32,853
12,088
42,648
31,158
12,684
19,925
36,044
49,948
PRODUCT
LAPTOP
DESKTOP
SPEAKER
LAPTOP
PRINTER
LAPTOP
PROJECTOR
LAPTOP
LCDS
MONITORS
LAPTOP
KEYBOARDS
MOUSE
CABLES
SWITCH
STABILIZER
PROCESSOR
MODEM
RAM
MOTHERBOARD
CD - ROM
CDS
POUCH
LAPTOP
LAPTOP
Commission
LAPTOP
63
75
72
92
21
85
81
13
77
90
67
70
54
81
72
51
48
94
48
55
93
59
19
26
74
LAPTOP
LAPTOP
282
#NAME?
=SUMIF(PRODUCT,O13,Commission)