Warid Main WH Dashboard Report

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 110

TRADE INVENTORY WAREHOUSE - WARID CENTRAL

Date 9-Oct-13 9 Month Oct-13 17

Inbound & Outbound Report as on - 09-Oct-13


INBOUND FOR THE DAY OUTBOUND FOR THE DAY
Products No. of GRNs Received Received GRN Qty Products No. of MTNs Issued Issued MTNs Qty
SCRATCH CARDS - SCRATCH CARDS 56 1,980,000
PREPAID 56 5 PREPAID 0 -
SIM 0 - SIM 2 1,000
POSTPAID 0 - POSTPAID 2 2,000
ACCESSORY 0 - ACCESSORY 0 -
HANDSET 0 - HANDSET 0 -
Total 56 5 Total 60 1983000

Pending GRNs Count 0 Pending MTNs Count 0


Reason to be Pending 0 Reason to be Pending 0

No. of GRNs Received No. of MTNs Issued


60 56 60

50 50

40 40

30 30

20 20

10 10
0 0 0 0 2
0 0

SCRATCH CARDS PREPAID SIM SCRATCH CARDS PREPAID SIM


POSTPAID ACCESSORY HANDSET POSTPAID ACCESSORY HANDSET

Inbound No. of GRNs Outbound No. of MTNS

100% 93%

3% 3%
TRADE INVENTORY WAREHOUSE - WARID CENTRAL

Month October-13 17

Inbound & Outbound Report as on - October-2013


INBOUND FOR THE MONTH OUTBOUND FOR THE MONTH
Products No. of GRNs Received Received GRN Qty Products No. of MTNs Issued Issued MTNs Qty
SCRATCH CARDS 0 - SCRATCH CARDS 27 4,280,012
PREPAID 0 - PREPAID 0 -
SIM 530 974,559 SIM 1,026 114,672
POSTPAID 0 - POSTPAID 3 3,000
ACCESSORY 0 - ACCESSORY 4 4,500
HANDSET 5 4,500 HANDSET 5 4,500
Total 535 979,594 Total 1,065 4,406,684

No. of GRNs Received No. of MTNs Issued


600 1,200
530 1,026
500 1,000

400 800

300 600

200 400

100 200
0 0 0 0 5 27 0 3
0 0

SCRATCH CARDS PREPAID SIM SCRATCH CARDS PREPAID SIM


POSTPAID ACCESSORY HANDSET POSTPAID ACCESSORY HANDSET

Inbound-No. of GRNs Outbound-No. of MTNs

99% 96%

1% 3%0%
0%
0%
TRADE INVENTORY WAREHOUSE - W

31
Wednesday
10,000,000

9,000,000
8,887,500
8,625,000
Inbound-Conne

8,000,000
31-March-2021
7,000,000

6,000,000
Inbound/Outbound
5,000,000 4,795,000
4,280,012
4,000,000
Select Product 3,000,000

2,000,000

Select Request or Quantity 1,000,000


-
-
Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 De
First Quarter Second Quarter

Outbound Request-Product-wise Breakup - Month: Jul-13 Outbound Re


555 48
SCRATCH CARDS 1%1%
1% 1,200
14%
S
PREPAID C
1,000
SIM 132 P
38%
POSTPAID S
800
P
ACCESSORY 149
43% A
HANDSET 600
H

400

200
48
Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14
-
200
48
Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14
-

Month SCRATCH CARDS PREPAID SIM POSTPAID ACCESSORY HA

Jul-13 48 149 132 5 -


Aug-13 36 1 39 7 -
Sep-13 52 29 206 11 -
Oct-13 27 - 1,026 3 -
Nov-13 - - - - -
Dec-13 - - - - -
Jan-14 - - - - -
Feb-14 - - - - -
Mar-14 - - - - -
Apr-14 - - - - -
May-14 - - - - -
Jun-14 - - - - -
REHOUSE - WARID CENTRAL

Inbound-Connections Request

4,280,012

- - - - - - - -
Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14
Second Quarter Third Quarter Fourth Quarter

Outbound Request Trends

1,200
SCRATCH
CARDS
1,000
PREPAID
SIM
800
POSTPAID
ACCESSORY
600
HANDSET

400

200

-
200

Outbound
POSTPAID ACCESSORY HANDSET Total Requests Month
Trends
5 - - 334 48 32%
7 - - 83 - 8%
11 - - 298 - 28%
3 - - 1,056 - 100%
- - - - - 0%
- - - - - 0%
- - - - - 0%
- - - - - 0%
- - - - - 0%
- - - - - 0%
- - - - - 0%
- - - - - 0%
Inbound Trade Inventory Warehouse - Warid Centr
SETUP The Category product data below shows daily receiving of each product in each product columns.

Product SCRATCH CARDS PREPAID SIM


Date GRN Count GRN Qty GRN Count GRN Qty GRN Count

1-Jul-13
2-Jul-13 1 25,000 3
3-Jul-13 2 35,000 1
4-Jul-13 4 33,000
5-Jul-13 19 4,055,000 4 33,393
6-Jul-13 2 38,000
7-Jul-13
8-Jul-13 8 41,649
9-Jul-13 3 40,275
10-Jul-13 3 295,000 7
11-Jul-13
12-Jul-13
13-Jul-13 6 59,029 1
14-Jul-13
15-Jul-13
16-Jul-13 1 2,040,000 3 33,201 2
17-Jul-13
18-Jul-13 10 50,000 2
19-Jul-13
20-Jul-13 11 50,162
21-Jul-13
22-Jul-13 2 24,066
23-Jul-13 4 28,353
24-Jul-13 3 28,561
25-Jul-13 3 41,998
26-Jul-13
27-Jul-13 14 87,437
28-Jul-13
29-Jul-13 2 42,327
30-Jul-13 5 51,725
31-Jul-13 9 40,544
1-Aug-13 3 36,674
2-Aug-13
3-Aug-13
4-Aug-13
5-Aug-13 2 450,000
6-Aug-13
7-Aug-13 16 245,696
8-Aug-13
9-Aug-13
10-Aug-13
11-Aug-13
12-Aug-13
13-Aug-13
14-Aug-13
15-Aug-13
16-Aug-13
17-Aug-13 6 74,971 26
18-Aug-13
19-Aug-13
20-Aug-13
21-Aug-13
22-Aug-13
23-Aug-13 1
24-Aug-13
25-Aug-13
26-Aug-13 4 4,910,000
27-Aug-13
28-Aug-13 1
29-Aug-13 1 1 5
30-Aug-13 2
31-Aug-13 1
1-Sep-13
2-Sep-13
3-Sep-13 9
4-Sep-13
5-Sep-13 2 1,225,000
6-Sep-13
7-Sep-13
8-Sep-13
9-Sep-13
10-Sep-13 5 10,035,000
11-Sep-13
12-Sep-13 6 19,880
13-Sep-13 5 30,120
14-Sep-13 159
15-Sep-13
16-Sep-13
17-Sep-13
18-Sep-13
19-Sep-13
20-Sep-13
21-Sep-13 1
22-Sep-13
23-Sep-13
24-Sep-13
25-Sep-13
26-Sep-13
27-Sep-13 1
28-Sep-13
29-Sep-13
30-Sep-13
1-Oct-13 135
2-Oct-13
3-Oct-13 392
4-Oct-13
5-Oct-13
6-Oct-13
7-Oct-13
8-Oct-13
9-Oct-13
10-Oct-13 3
11-Oct-13
12-Oct-13
13-Oct-13
14-Oct-13
15-Oct-13
16-Oct-13
17-Oct-13
18-Oct-13
19-Oct-13
20-Oct-13
21-Oct-13
22-Oct-13
23-Oct-13
24-Oct-13
25-Oct-13
26-Oct-13
27-Oct-13
28-Oct-13
29-Oct-13
30-Oct-13
31-Oct-13
1-Nov-13
2-Nov-13
3-Nov-13
4-Nov-13
5-Nov-13
6-Nov-13
7-Nov-13
8-Nov-13
9-Nov-13
10-Nov-13
11-Nov-13
12-Nov-13
13-Nov-13
14-Nov-13
15-Nov-13
16-Nov-13
17-Nov-13
18-Nov-13
19-Nov-13
20-Nov-13
21-Nov-13
22-Nov-13
23-Nov-13
24-Nov-13
25-Nov-13
26-Nov-13
27-Nov-13
28-Nov-13
29-Nov-13
30-Nov-13
1-Dec-13
2-Dec-13
3-Dec-13
4-Dec-13
5-Dec-13
6-Dec-13
7-Dec-13
8-Dec-13
9-Dec-13
10-Dec-13
11-Dec-13
12-Dec-13
13-Dec-13
14-Dec-13
15-Dec-13
16-Dec-13
17-Dec-13
18-Dec-13
19-Dec-13
20-Dec-13
21-Dec-13
22-Dec-13
23-Dec-13
24-Dec-13
25-Dec-13
26-Dec-13
27-Dec-13
28-Dec-13
29-Dec-13
30-Dec-13
31-Dec-13
e - Warid Central

SIM POSTPAID ACCESSORY HANDSET


GRN Qty GRN Count GRN Qty Request Count Request Qty Request Count

1,150,000 1
1,000 1

1 1,500
1 2,000

1,189,718 2

500,000 1 500

63

110 1
2 3,500

1
36,076

69,999

81
90 1 6,000
70,002
51

2,149

5
3 3,000

3
1

2,421

3
12,000

4
400,000 4
46,661

27,898
5

900,000
HANDSET Total Inbound GRN Pending GRNs
Request Qty Total GRN Total Qty Count

- -
257 5 1,175,257
257 4 36,257
4 33,000
24 4,089,893
3 40,000
- -
8 41,649
3 40,275
35 12 1,484,753
- -
- -
8 559,529
- -
- -
6 2,073,264
- -
1 13 50,111
- -
11 50,162
- -
2 24,066
4 28,353
3 28,561
3 41,998
- -
14 87,437
- -
2 42,327
5 51,725
9 40,544
3 36,674
- -
- -
- -
4 453,500
- -
16 245,696
- -
- -
- -
- -
- -
- -
- -
- -
1 1 1
32 111,047
- -
- -
- -
- -
- -
1 69,999
- -
- -
2 5 4,910,002
- -
1 81
7 6,091
2 70,002
1 51
- -
- -
9 2,149
- -
2 1,225,000
18 5 18
3 3,000
- -
- -
5 10,035,000
14 3 14
1 7 19,881
5 30,120
159 2,421
- -
- -
- -
2 1 2
- -
39 3 39
1 12,000
- -
- -
3 1 3
- -
3,850 4 3,850
5,350 5 405,350
- -
- -
- -
135 46,661
- -
392 27,898
4,500 8 904,500
- -
- -
- -
- -
- -
#REF! #REF!
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
Pending GRNs
Reason to be pending
Outbound Trade Inventory Warehouse - Warid Cen
SETUP The Category product data below shows daily distribution of each product in each product columns.

Product SCRATCH CARDS PREPAID SIM


Date Request Count Request Qty Request Count Request Qty Request Count

1-Jul-13 48 94,575
2-Jul-13 1 25,000 1
3-Jul-13 2 35,000 10
4-Jul-13 4 33,000 4
5-Jul-13 19 4,055,000 4 33,393 6
6-Jul-13 2 38,000 3
7-Jul-13
8-Jul-13 8 41,649 8
9-Jul-13 9 1,297,500 3 40,275 8
10-Jul-13 5 39,718 5
11-Jul-13
12-Jul-13
13-Jul-13 6 59,029 6
14-Jul-13
15-Jul-13
16-Jul-13 3 33,201 7
17-Jul-13
18-Jul-13 5 1,440,000 10 50,000 17
19-Jul-13
20-Jul-13 11 50,162 11
21-Jul-13
22-Jul-13 2 24,066 3
23-Jul-13 4 28,353 4
24-Jul-13 3 28,561 4
25-Jul-13 3 85,000 3 41,998 3
26-Jul-13
27-Jul-13 14 87,437 14
28-Jul-13
29-Jul-13 2 42,327 2
30-Jul-13 12 2,010,000 5 51,725 7
31-Jul-13 9 40,544 9
1-Aug-13 8 230,000 1 15,381
2-Aug-13
3-Aug-13
4-Aug-13
5-Aug-13 8 2,160,000 1
6-Aug-13
7-Aug-13 16
8-Aug-13
9-Aug-13
10-Aug-13
11-Aug-13
12-Aug-13
13-Aug-13 1
14-Aug-13
15-Aug-13 6 1,000,000 2
16-Aug-13 6
17-Aug-13
18-Aug-13
19-Aug-13
20-Aug-13
21-Aug-13 3
22-Aug-13
23-Aug-13 3 65,000
24-Aug-13
25-Aug-13
26-Aug-13 11 1,340,000
27-Aug-13
28-Aug-13 1
29-Aug-13 7
30-Aug-13 1
31-Aug-13 1
1-Sep-13
2-Sep-13 10 2,130,000
3-Sep-13 8 1,030,000 9
4-Sep-13
5-Sep-13 3
6-Sep-13
7-Sep-13 9
8-Sep-13
9-Sep-13 2
10-Sep-13 2
11-Sep-13 8 985,000
12-Sep-13 6 19,880 6
13-Sep-13 5 30,120 5
14-Sep-13 159
15-Sep-13
16-Sep-13
17-Sep-13 14 2,550,000
18-Sep-13
19-Sep-13 1
20-Sep-13
21-Sep-13 4
22-Sep-13
23-Sep-13 18 255,696 3
24-Sep-13 1
25-Sep-13
26-Sep-13
27-Sep-13 12 1,930,000 2
28-Sep-13
29-Sep-13
30-Sep-13
1-Oct-13 1 12 139
2-Oct-13
3-Oct-13 392
4-Oct-13 1
5-Oct-13
6-Oct-13
7-Oct-13 14 2,300,000 424
8-Oct-13
9-Oct-13 12 1,980,000 2
10-Oct-13 68
11-Oct-13
12-Oct-13
13-Oct-13
14-Oct-13
15-Oct-13
16-Oct-13
17-Oct-13
18-Oct-13
19-Oct-13
20-Oct-13
21-Oct-13
22-Oct-13
23-Oct-13
24-Oct-13
25-Oct-13
26-Oct-13
27-Oct-13
28-Oct-13
29-Oct-13
30-Oct-13
31-Oct-13
1-Nov-13
2-Nov-13
3-Nov-13
4-Nov-13
5-Nov-13
6-Nov-13
7-Nov-13
8-Nov-13
9-Nov-13
10-Nov-13
11-Nov-13
12-Nov-13
13-Nov-13
14-Nov-13
15-Nov-13
16-Nov-13
17-Nov-13
18-Nov-13
19-Nov-13
20-Nov-13
21-Nov-13
22-Nov-13
23-Nov-13
24-Nov-13
25-Nov-13
26-Nov-13
27-Nov-13
28-Nov-13
29-Nov-13
30-Nov-13
1-Dec-13
2-Dec-13
3-Dec-13
4-Dec-13
5-Dec-13
6-Dec-13
7-Dec-13
8-Dec-13
9-Dec-13
10-Dec-13
11-Dec-13
12-Dec-13
13-Dec-13
14-Dec-13
15-Dec-13
16-Dec-13
17-Dec-13
18-Dec-13
19-Dec-13
20-Dec-13
21-Dec-13
22-Dec-13
23-Dec-13
24-Dec-13
25-Dec-13
26-Dec-13
27-Dec-13
28-Dec-13
29-Dec-13
30-Dec-13
31-Dec-13
e - Warid Central

SIM POSTPAID ACCESSORY HANDSET


Request Qty Request Count Request Qty Request Count Request Qty Request Count

25,000
40,000 4
33,000 1 1,000 8
50,893
40,000

41,649 7
42,775 1 1,000
39,718 6

1
59,029

33,327 1

52,720 3 2,500 1

50,162

24,566 1
28,353
30,061
41,998

87,437
42,327
56,225
40,544 1

500 1 500

245,696

20,000

2,500 2
5,000 1

21,000 1 500

1 500 1

81 3 1,500
6,590 1 1,000 2
2
51

17,149 3 2,000 1

9,000
5
68,000 3 3,000

250
50,000
3
19,880 2
30,120
2,421

2 2,000
1
4,000
3
8,000

1,750 2
10,000 2 2,000 1

4
1,500 1 1,000 4

36,741
27,898
2,000 1 1,000 5

45,033 4 4,500

1,000 2 2,000
2,000
HANDSET Total Product Requests Request after Cut-off Time & Pending

Request Qty Request Count Request Qty In Time After Cutt-off Pending Count

48 94,575
2 50,000
273 16 75,273
17 17 67,017
29 4,139,286
5 78,000
- -
141 23 83,439
21 1,381,550
35 16 79,471
- -
15 1 15
12 118,058
- -
- -
2 11 66,530
- -
1 36 1,545,221
- -
22 100,324
- -
5 6 48,637
8 56,706
7 58,622
9 168,996
- -
28 174,874
- -
4 84,654
24 2,117,950
2 19 81,090
9 245,381
- -
- -
- -
10 2,161,000
- -
16 245,696
- -
- -
- -
- -
- -
1 20,000
- -
15 10 1,002,515
1 7 5,001
- -
- -
- -
- -
4 21,500
- -
2 5 65,502
- -
- -
2 12 1,340,002
- -
4 1,581
61 10 7,651
1 2
1 51
- -
10 2,130,000
5 21 1,049,154
- -
3 9,000
18 5 18
12 71,000
- -
2 250
2 50,000
14 11 985,014
4 14 39,764
10 60,240
159 2,421
- -
- -
16 2,552,000
2 1 2
1 4,000
39 3 39
4 8,000
- -
10 23 257,456
3 4 12,003
- -
3,850 4 3,850
5,350 19 1,937,850
- -
- -
- -
140 36,753
- -
392 27,898
4,500 7 7,500
- -
- -
442 2,349,533
- -
16 1,983,000
68 2,000
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
after Cut-off Time & Pending

Reason to be pending

You might also like