WEEK 26 Practice
WEEK 26 Practice
If the shape was modified in an earlier version of Excel, or if the workbook was saved in Excel
2007 or earlier, the slicer can't be used.
18,605,052 16,702
FRANCHISE PHV01 - PH WS 0 -
METRO MANILA PH046 - MEGA A-C1 1,061,696 957
METRO MANILA PH100 - E-Commerce 0 -
LUZON PH069 - PAMPANGA 865,739 810
LUZON PH010 - SOA-L1 771,669 744
VISAYAS PH021 - AYALACBU-V 715,752 690
SOUTH PH130 - ACIENDA-S2 610,234 661
SOUTH PH054 - FESTIVL-S1 609,274 538
LUZON PH090 - CLARK-L1 586,600 478
MINDANAO PH076 - SMDAVAO-M1 556,034 434
SOUTH PH024 - GREENFIELD 514,773 554
MINDANAO PH019 - ABREEZA-M1 493,535 455
METRO MANILA PH144 - GLORIETTA4 466,273 503
MINDANAO PH106 - KCCZAMBO-M 449,549 380
VISAYAS PH017 - P-VERDE-V 436,311 483
FRANCHISE PHCSL - Corp Sales 0 -
METRO MANILA PH142 - SMGRAND-C1 428,390 422
LUZON PH009 - MARQUEE-L1 419,525 397
LUZON PH083 - BAGUIO-L3 410,928 329
MINDANAO PH030 - CENTRIO 409,901 311
METRO MANILA PH012 - NEWPORT-C2 397,626 331
METRO MANILA PH097 - MRIKINA-N3 392,205 325
VISAYAS PH119 - SMBACOLOD 375,780 340
METRO MANILA PH091 - MOA-C2 368,607 347
METRO MANILA PH118 - GATEWAY-N2 353,305 281
METRO MANILA PH066 - MANILA-C1 350,751 308
SOUTH PH050 - SMLUCEN-S3 344,609 313
LUZON PH104 - SMCAB-L2 340,077 316
LUZON PH008 - TARLAC-L3 331,666 319
SOUTH PH071 - SUCAT-S3 328,489 295
SOUTH PH053 - SMNAGA-S3 319,559 268
METRO MANILA PH147 - GREENHILLS 305,758 267
VISAYAS PH020 - ILOILO-V 295,022 304
VISAYAS PH150 - SSIDECEBU 286,264 263
METRO MANILA PH146 - ONE AYALA 241,691 250
METRO MANILA PH143 - MITSUKO-C2 239,609 220
MINDANAO PH007 - GENSAN-M2 225,549 223
SOUTH PH149 - SMDAET 215,840 198
SOUTH PH056 - ALABANG-S1 203,647 153
METRO MANILA PH049 - MAGNOLI-C1 202,817 181
MINDANAO PH101 - BUTUAN-M2 201,526 205
LUZON PH084 - MARILAO-L1 200,776 189
MINDANAO PH148 - SMBUTUAN 196,298 197
LUZON PH005 - ROSALES-L3 189,624 168
SOUTH PH041 - BACOOR-S1 181,647 181
METRO MANILA PH089 - VALENZU-N2 176,853 156
METRO MANILA PH037 - CASH CARRY 176,098 174
METRO MANILA PH027 - ALIMALL-N2 172,773 174
METRO MANILA PH135 - VENICE-C2 146,754 153
METRO MANILA PH141 - CLOVERLEAF 125,389 138
METRO MANILA PH151 - SMCAL-C1 121,464 120
LADIES PHL05 - PODIUM 375,550 66
LADIES PHL03 - LADIESMEGA 245,850 83
LADIES PHL11 - MITSUKOSHI 169,400 30
LADIES PHL12 - NEWPORT 0 20
LANDMARK PH139 - LM Makati 0 -
LANDMARK PH140 - LM Trinoma 0 -
WH PHW01 - Warehouse
WH PHW02 - WH SALE
WH PHW06 - WH LADIES
WH PHW07 - WH UNIFORM 0.00 -
ved in Excel
8,259
3,591 10,773 12,304 120
4,937 14,812 - 165
4,219 12,658 10,414 141
3,322 9,965 9,566 111
3,142 9,426 8,871 105
1,795 5,386 8,499 60
2,514 7,541 6,917 84
2,873 8,618 6,146 96
2,244 6,733 5,580 75
2,289 6,868 7,123 76
2,244 6,733 5,850 75
1,436 4,309 6,467 48
2,155 6,464 4,886 72
2,065 6,194 6,210 69
60 -1,761 -644
57 -1,716 -1,460
47 672 -350
44 -391 -1,509
47 -2,136 -3,536
46 -1,708 -2,377
49 -1,628 -1,566
50 -1,748 -2,673
40 -2,822 -3,787
44 -839 -515
45 -493 -1,047
45 -1,126 -1,911
46 -521 -1,806
42 -1,702 -1,141
38 217 -377
38 -1,420 -1,488
43 -2,540 -2,401
38 -1,407 -2,066
36 -1,457 -398
31 6 -127
32 -2,023 -1,849
28 -704 -582
22 -663 -1,120
26 -1,138 -1,639
29 -786 -1,920
27 -1,015 -2,625
28 -629 -1,597
24 -642 -1,040
26 -1,632 -2,267
22 -1,436 -1,585
25 -1,876 -2,332
25 -1,169 -1,087
22 -362 -819
20 -1,284 -1,126
17 -670 -2,359
9 6,834 -666
12 3,862 -457
4 -18 -593
3 -296 -712
0 577 0
0 625 0
TIGER SYSTEM ACTUAL
Shop Sales Qty Stock DOI ACTUAL
PHV01 - PH WS 2,524,661 2,791 4,604 6 0
PH046 - MEGA A-C1 1,061,696 957 12,224 93 1,061,696
PH100 - E-Commerce 1,034,201 1,263 13,778 77 0
PH069 - PAMPANGA 865,739 844 10,975 89 865,739
PH010 - SOA-L1 771,669 759 14,762 122 771,669
PH021 - AYALACBU-V 715,753 693 10,613 112 715,752
PH130 - ACIENDA-S2 609,435 661 11,469 140 610,234
PH054 - FESTIVL-S1 609,274 539 8,617 118 609,274
PH090 - CLARK-L1 586,598 492 10,001 137 586,600
PH076 - SMDAVAO-M1 556,034 434 8,575 145 556,034
PH024 - GREENFIELD 514,773 554 12,955 170 514,773
PH019 - ABREEZA-M1 493,535 455 9,607 133 493,535
PH144 - GLORIETTA4 466,273 468 4,600 78 466,273
PH106 - KCCZAMBO-M 449,549 398 8,260 150 449,549
PH017 - P-VERDE-V 438,711 483 11,730 170 436,311
PHCSL - Corp Sales 429,468 419 234 8 0
PH142 - SMGRAND-C1 428,390 422 5,824 114 428,390
PH009 - MARQUEE-L1 419,525 397 7,143 121 419,525
PH083 - BAGUIO-L3 410,928 332 6,889 130 410,928
PH030 - CENTRIO 409,901 311 5,185 136 409,901
PH012 - NEWPORT-C2 397,626 331 6,685 145 397,626
PH097 - MRIKINA-N3 392,205 325 6,645 151 392,205
PH119 - SMBACOLOD 375,780 340 7,129 162 375,780
PH091 - MOA-C2 368,607 348 6,874 137 368,607
PH118 - GATEWAY-N2 353,305 281 5,489 128 353,305
PH066 - MANILA-C1 350,751 308 4,791 123 350,751
PH050 - SMLUCEN-S3 344,609 313 5,317 121 344,609
PH104 - SMCAB-L2 340,077 317 6,609 141 340,077
PH008 - TARLAC-L3 331,666 319 7,209 180 331,666
PH071 - SUCAT-S3 328,489 295 4,288 100 328,489
PH053 - SMNAGA-S3 319,559 263 4,455 114 319,559
PH147 - GREENHILLS 305,758 267 4,398 122 305,758
PH020 - ILOILO-V 295,022 304 7,651 182 295,022
PH150 - SSIDECEBU 286,264 263 5,856 158 286,264
PH146 - ONE AYALA 241,691 250 2,829 98 241,691
PH143 - MITSUKO-C2 239,609 220 3,418 127 239,609
PH007 - GENSAN-M2 225,549 223 5,485 196 225,549
PH149 - SMDAET 215,840 198 3,725 169 215,840
PH056 - ALABANG-S1 203,647 158 3,769 171 203,647
PH049 - MAGNOLI-C1 202,817 181 3,895 144 202,817
PH101 - BUTUAN-M2 201,526 221 5,021 167 201,526
PH084 - MARILAO-L1 200,776 189 5,809 232 200,776
PH148 - SMBUTUAN 196,298 197 4,802 166 196,298
PH005 - ROSALES-L3 189,624 168 4,640 193 189,624
PH041 - BACOOR-S1 181,647 181 5,198 179 181,647
PH089 - VALENZU-N2 176,853 156 3,414 163 176,853
PH037 - CASH CARRY 176,098 174 4,171 174 176,098
PH027 - ALIMALL-N2 172,773 174 3,400 131 172,773
PH135 - VENICE-C2 146,754 153 2,452 123 146,754
PH141 - CLOVERLEAF 125,389 138 2,544 150 125,389
PH151 - SMCAL-C1 121,464 120 3,660 193 121,464
PHL05 - PODIUM 375550 68 1,512 116 375,550
PHL03 - LADIESMEGA 245850 34 1,589 397 245,850
PHL11 - MITSUKOSHI 169,400 30 998 250 169,400
PHL12 - NEWPORT 40,100 20 988 247 0
PH139 - LM Makati 0 0 7,405 7405 0
PH140 - LM Trinoma 0 0 7376 7376 0
PHW01 - Warehouse 0 0 83,991 83,991
PHW02 - WH SALE 0 0 46,807 46,807
PHW06 - WH LADIES 0 0 141 141
PHW07 - WH UNIFORM 0 0 3,742 3,742
TOTAL 22,635,086 21,199 480,480 159 18,605,052
ASP 1067.74
ADS 3,028.43
75 65 -611 -1,475
48 72 -836 1,334
72 54 -846 -2,405
69 69 -3,237 -3,204
#N/A 0 #N/A 0
48 60 -1,773 -644
54 57 -1,730 -1,460
58 47 657 -350
57 44 -405 -1,509
63 47 -2,152 -3,536
54 46 -1,722 -2,377
48 49 -1,640 -1,566
60 50 -1,763 -2,673
51 40 -2,835 -3,787
40 44 -849 -515
51 45 -506 -1,047
54 45 -1,140 -1,911
60 46 -536 -1,806
36 42 -1,711 -1,141
45 38 205 -377
39 38 -1,430 -1,488
42 43 -2,550 -2,401
45 38 -1,419 -2,066
24 36 -1,464 -398
33 31 -2 -127
30 32 -2,030 -1,849
27 28 -711 -582
27 22 -670 -1,120
31 26 -1,146 -1,639
42 29 -796 -1,920
45 27 -1,027 -2,625
39 28 -639 -1,597
28 24 -649 -1,040
33 26 -1,640 -2,267
24 22 -1,443 -1,585
30 25 -1,883 -2,332
24 25 -1,176 -1,087
27 22 -369 -819
18 20 -1,289 -1,126
60 17 1,469 -2,359
30 10 1,171 -641
21 5 356 -1,087
18 4 632 -593
36 3 2,254 -712
93 0 8,325 0
60 0 5,371 0
TOTAL Sales SO
SM Mega 245,850.00 34
PHL03 - LADIESMEGA
Podium PHL05 - PODIUM 375,550.00 68
Mitsukoshi PHL11 - MITSUKOSHI 169,400.00 30
Newport PHL12 - NewPort 0 20
PH139 - LM Makati
PH140 - LM Trinoma
PH100 - E-Commerce
PHV01 - PH WS
PHW01 - Warehouse
PHW02 - WH SALE
PHW07 - WH UNIFORM
PHW06 - WH LADIES
PHCSL - Corp Sales
PHL10 - E_Commerce
PH042 - Caravan
TOTAL PREVIOUS INVENTORY
INVENTORY PREVIOUS SALES
11,355 11,355 1,061,695.65 0.00
3,966 3,966 202,816.85 0.00
4,475 4,475 350,751.20 0.00
2,900 125,389.20
2,900 0.00
3,591 3,591 176,852.90 0.00
6,070 428,389.55
6,070 0.00
4,921 4,921 305,758.10 0.00
3,902 3902 121,463.60 0.00
0.00
5,133 5,133 466,273.00 0.00
0 0 0 0.00
7,792 397,626.00
7,792 0.00
4,569 176,097.60
4,569 0.00
2,786 2,786 146,753.80 0.00
2,956 2,956 239,609.40 0.00
7,134 7,134 368,607.30 0.00
3,612 3,612 241,690.50 0.00
0.00
3,324 3,324 172,773.20 0.00
7,400 353,304.90
7,400 0.00
6,556 6,556 392,204.90 0.00
0.00
3,087 203,646.80
3,087 0.00
8,529 8,529 609,274.20 0.00
4,594 4,594 181,646.90 0.00
4,934 4,934 328,488.55 0.00
10,131 514,772.90
10,131 0.00
10,707 10,707 610,233.70 0.00
5,071 344,608.60
5,071 0.00
3,823 3,823 319,559.40 0.00
3,128 3,128 215,839.80 0.00
0.00
5,055 5,055 200,776.10 0.00
8,494 8,494 865,739.20 0.00
9,291 9,291 586,599.60 0.00
6,564 419,524.70
6,564 0.00
12,885 12,885 771,669.30 0.00
5,974 5,974 340,077.40 0.00
0.00
4,580 4,580 410,927.55 0.00
3,200 3,200 189,623.90 0.00
5,907 5,907 331,666.30 0.00
0.00
8,444 715,752.15
8,444 0.00
9,414 9,414 436,310.80 0.00
6,310 6,310 295,021.50 0.00
5,937 5,937 375,779.65 0.00
5,447 5,447 286,264.30 0.00
0.00
5,508 5,508 409,900.60 0.00
3,795 3,795 201,526.40 0.00
3,454 3,454 196,297.60 0.00
4,716 4,716 225,548.85 0.00
5,264 449,549.00
5,264 0.00
7,418 7,418 556,033.80 0.00
7,325 493,535.15
7,325 0.00
1,524 245,850.00
1,524
1,515 1,515 375,550.00
979 979 169,400.00
969 969 40,100.00
1,929 84776.9
1,663 112316
13,905 1035365
1,143 2528508.85
74,442
18,166
3,742
294
134 432581
35,000,000.00
30,000,000.00
25,000,000.00
20,000,000.00
15,000,000.00
10,000,000.00
5,000,000.00
0.00
1 3 5 7 9
21-Oct-23
25-Oct-23
3-Nov-23
6-Nov-23
18-Nov-23
28-Nov-23
29-Nov-23
23-Dec-23
3-Jan-24
9-Jan-24
10-Jan-24
16-Jan-24
20-Jan-24
29-Jan-24
5-Feb-24
12-Feb-24
17-Feb-24
16-Mar-24
16-Mar-24
16-Mar-24
31-Mar-24
31-Mar-24
12-Apr-24
1-Apr-24
11-May-24
Container Category Quantity Status
KHK264 GJ 8,497 Complete
KHK265 GJ 5,286 Complete
LHK289 GL 1,091 Complete
KHK266 GJ 1,856 Complete
KHK269 GJ 3,050 Complete
KHK267 GJ 35 Complete
KHK268 GJ 2,452 Complete
MHK890 GIO 194,245 Complete
MHK893 GIO 79,329 Complete
MHK891 GIO 78,373 Complete
MHK892 GIO 64,126 Complete
LHK290 GL 273 Complete
MHK894 GIO 4,061 Complete
MHK895 GIO 115,602 Complete
MHK896 GIO 92,016 Complete
MHK897 GIO 37,399 Complete
MHK898 GIO 13,033 Complete
MHK899 GIO 15,275 Complete
MHK900 GIO 3,000 Complete
MHK901 GIO 21,305 Complete
MHK902 GIO 35,615 Complete
MHK903 GIO 76,775 Complete
MHK904 GIO 351 Complete
MHK905 GIO 11,084 Complete
MHK906 GIO 18,473 Complete
MHK907 GIO 26,016 Complete
MHK908 GIO 25,040 Complete
MHK909 GIO 42,318 Complete
MHK910 GIO 8,902 Complete
MHK911 GIO 40,004 Complete
KHK270 GJ 3,244 Complete
LHK296 GL 169 Complete
MHK912 GIO 70,824 Complete
KHK271 GJ 3,015 Complete
LHK297 GL 232 Complete
MHK912 GIO 14664 Complete
MHK913 GIO 74,582 Complete
MHK914
MHK915
NO. STYLE D. DESC. Qty Sales
13 5420256 GW W CTN TWL MD RSE RLX TPR ELSTC WST 855 1,297,939
ADRY
15 1093242 GC CTN JRSY CRW NCK SS SLM PRNT PRNT 1674 1,206,083
TE (SGNTRE TE)
16 1093308 GC CTN JRSY CRW NCK SS SLM PRNT PRNT 2319 1,262,106
TE (WWS 3G)
19680 113
9985 69
10094 106
16955 183
34709 381
1592 23
3925 43
15392 120
14667 167
10776 134
3641 98
11410 238
6052 204
4001 75
5979 73
3904 33
1140 27
5855 203
1334 16
3274 96
NO. STYLE D. DESC. Qty Sales Stock Local Transit WH.Stock O/S
CTN/LYCRA OXFRD FL
OPNNG SS SLM EMBRDRY
11 1044210 GC GRMNT WSH OXFRD (FRG 256 348,189 6696 2,066 2,807 0
BTN)
CTN/LYCRA OXFRD FL
OPNNG LS SLM EMBRDRY
12 1044010 GC GRMNT WSH OXFRD (FRG 214 290,598 4190 1,825 382 0
BTN)
CTN/PLYSTR/LYCL JRSY
18 1024212 GC CRW NCK SS SLM 198 197,003 3143 501 357 0
EMBRDRY TE
LNN/CTN PLN WVE FL
19 1044207 GC OPNNG SS SLM BTN FRNT 128 204,698 3096 357 188 0
GRMNT WSH LNN CTN
Ladies
SM Megamall D - Ladies PHL03 - LADIESMEGA 2,000,000
The Podium - Ladies PHL05 - PODIUM 3,100,000
Mitsukoshi - Ladies PHL11 - MITSUKOSHI 1,000,000
Newport - Ladies PHL12 - NewPort 700,000
Total 6,800,000
Distribution
Landmark Makati PH139 - LM Makati 600,000
Landmark Trinoma PH140 - LM Trinoma 650,000
Total 1,250,000
Ecom PH100 - E-Commerce 5,500,000
Subfranchise PHV01 - PH WS 9,200,000
Other
Overall Total National 108,000,000