REFERENCES
Amir, M. T., 2005, Manajemen Ritel, Jakarta: Penerbit PPM. Lamba, A. J., 2003, The Art of Retailling, New Delhi: Tata Mcgraw-Hill, Vol. 6, p. 253. Levy, M. and Weitz, B.A., 2004, Retailing Management, Singapore: McGraw-Hill. Heizer, J., and Render, B., 2006, Operations Management, New Jersey: Pearson Education. Raman, A., Dehoratius, N., and Ton, Z., 2001, “Execution: The Missing Link in Retail Operations”, California Management Review, Vol. 43, No. 3, pp. 136-141. Daugherty, P. J., Myers, M. B., and Autry, C. W., 1999, "Automatic Replenishment Programs: An Empirical Examination," Journal of Business Logistics, Vol. 20, No. 2, pp. 63-82. Retaileconomics.com, 2007, Automatic replenishment, retrieved on March 2007 from http://www.retaileconomics.com/publications.html Wikipedia .org, 2007, Key performance indicator, retrieved on March 2007 from http://en.wikipedia.org/wiki/Key_performance_indicators Wikipedia .org, 2007, Service level, retrieved on March 2007 from http://en.wikipedia.org/wiki/Service_level
53
54
APPENDIX
55
56
Appendix A (Sales Data)
SKU 91100008 91100017 91100026 91100035 91100044 91100053 91100062 91100071 91100080 91100099 91100142 91100151 91100160 91100179 91100188 91100197 91100204 91100213 91100222 91100231 91100302 91100311 91100320 91100339 91100348 91100357 91100366 91100375 91100428 91100437 91100446 91100455 91100464 91100482 91100491 91100544 91100553 91100562 91100571
SKU Description COAX MEN'S JEAN 602 6874 COAX MEN'S JEAN 602 6813 COAX MEN'S JEAN 602 6820 COAX MEN'S JEAN 602 6822 COAX MEN'S JEAN 602 6823 COAX MEN'S JEAN 602 6801 COAX LADIES JEAN 507 6801 COAX LADIES JEAN 507 6820 COAX LADIES JEAN 507 6822 COAX LADIES JEAN 507 6874 GT MAN SINGLET DEWASA 302 B (S) 32 GT MAN SINGLET DEWASA 302 B (S) 34 GT MAN SINGLET DEWASA 302 B (S) 36 GT MAN SINGLET DEWASA 302 B (S) 38 GT MAN SINGLET DEWASA 302 B (S) 40 GT MAN SINGLET DEWASA 302 B (S) 42 GT MAN BOY SINGLET 302B ( K ) 24 GT MAN BOY SINGLET 302B ( K ) 26 GT MAN BOY SINGLET 302B ( K ) 28 GT MAN BOY SINGLET 302B ( K ) 30 GT MAN CELANA DALAM SPANDEX PTH 704 B S GT MAN CELANA DALAM SPANDEX PTH 704 B M GT MAN CELANA DALAM SPANDEX PTH 704 B L GT MAN CELANA DALAM SPANDEX PTH 704 B XL GT MAN CELANA DALAM SPANDEX WARNA 704 GT MAN CELANA DALAM SPANDEX WARNA 704 GT MAN CELANA DALAM SPANDEX WARNA 704 GT MAN CELANA DALAM SPANDEX WARNA704B GT MAN BOY BRIEF BOY COLOR 504BW 24 GT MAN BOY BRIEF COLOR 504BW 26 GT MAN BOY BRIEF COLOR 504BW 28 GT MAN BOY BRIEF COLOR 504BW 30 GT MAN BOY BRIEF WHT 504SP 24 GT MAN BOY BRIEF WHT 504SP 28 GT MAN BOY BRIEF WHT 504SP 30 T-SHIRT COTTON V-NECK WARNA DEWASATSGV T-SHIRT COTTON V-NECK WARNA DEWASATSGV T-SHIRT COTTON V-NECK WARNA DEWASATSGV T-SHIRT COTTON V-NECK WARNADEWASATSGV
SOH 120 100 71 89 58 26 23 36 28 42 54 74 22 42 10 62 29 33 8 11 86 33 39 37 213 21 28 26 84 98 42 100 59 56 77 19 19 6 1
Qty Sales 9 11 20 2 4 28 5 1 1 4 12 55 12 17 9
8 17 8 15 5 11 7 13
3 1
Unit Cost 40000 40000 40000 40000 40000 40000 40000 40000 40000 40000 9764 9764 9764 10309 10309 10309 7364 7364 7364 7364 9218 9218 9218 9218 9218 9218 9218 9218 7364 7364 7364 7364 7364 7364 7364 20455 20455 20455 20455
Unit Retail 54900 54900 54900 54900 54900 54900 54900 54900 54900 54900 14900 14900 14900 14900 14900 14900 11900 11900 11900 11900 14900 14900 14900 14900 14900 14900 14900 14900 11900 11900 11900 11900 11900 11900 11900 34900 34900 34900 34900
57
Appendix B (Order Schedule)
No
Department
SUPPLIER NAME
Ladies
Trans Nusantara Sejati
31421
S1
2
Man
RICKY PUTRA GLOBALINDO, PT
31459
S1
GTMan U/wear
3
Children/Man
PRASASTI BALADEWA, PT
32333
S1
Ant Boy / Mushroom
4
Man/Ladies/Home Txt
INDAH JAYA, PT - JBTK
32788
P1
Bougainville Towel / Claents
5
Baby
SURYANA (proses not-active)
32862
S1
Kunang-Kunang
6
Home Textile / Man
LIE ALI PANGEABEAN/UD VARIA
33085
S1
VR Kitc. Acc / Swan
7
Man & Ladies
TRITUNGGAL SEJAHTERA IND , PT
33168
S1
Basic Element U/wear
8
Man & Ladies
Alex Bambang Budiman
33174
S1
Cristal
9
Baby
VIDYATI TEDJA
33178
S1
Bubble bee
10
Home Textile
INTINUSA SAGGA ABADI, PT
33369
S1
Futon Mattrass
11
Home Textile
CIPTA KREASINDO
33480
P1
Wonderfull Pillow
12
Shoes
LIE ALI GUNAWAN ( kons )
33526
S1
ZANDILAC
13
Man
FECEKRAN SANDANG JAYA, PT
33562
S1
SRP T-shirt
14
Ladies
LENNY TANUBRATA
33564
S1
Asst Lds t-shirt
15
Home Textile/Baby
DIALOGUE GARMINDO UTAMA, PT
33590
S1
Dialogue
16
Baby
CHANDRAYANTI SUTANTO
33592
S1
Baby Carrot
17
Man & Ladies
LIM KOEI JOE
33596
S1
Frisbee Swim Wear
18
Man & Ladies
WANTO HAMDANI / TRIMITRA SEJATI
33597
S1
Fesmy
19 Man & Ladies / Baby / Shoes
SHELLY AGUSTIN
33601
S1
Marvelino / Baby Duck
20
Baby
RYAN COLLECTION
33604
S1
Ryan
21
Baby
INDOTOYS
33609
S1
Baby Toys
22
Baby
TEDY IRAWAN
33611
S1
Teeny Weeny
23
Man/Ladies/Chd
U.D Jakarta
33616
S1
Belt
24
Man & Ladies
TAN TJOEI JIN
33617
S1
Nadier U/wear
25
Baby
MENSA BINA SUKSES, PT LYNEA
33620
S1
Lynea
26
Ladies/Children
MELLY LATUHERU
33623
S1
Skyle / Girl Short Pants
27
Man & Ladies
EVI DEWIJANTI .T
33624
S1
Bianchino
1
SUPPLIER CODE ATRIBUTTE
BRAND Rider U/wear
28
Man
William
33630
S1
Stude Baker T-hirt
29
Children
KAPASINDO PRIMA, PT
33632
P1
Ideal/Ichiban
30
Children/Man/Ladies
MULTI ARTHA MUNDO
33657
P1
Mundo Sock
31
Baby
DAYA MULIA SEJAHTERA, PT
33670
S1
Pupu
32
Baby/Child
WENNY ISKANDAR
33673
S1
M-Kids
33
Home Textile / Ladies
MITRAMAS ARTHA GRIYA, PT
33686
S1
Mag Kitchen Acc / Arthy
34
Home Textile
ANUGERAH KARYA MEGAH
33698
S1
Miracle Bed Sheet
35
Man & Ladies
TACKY TJAKRA
33712
S1
ABBA Tie
58
ORDER DAYS Senin Selasa Rabu kamis Jumat Sabtu
Appendix B (Cont’)
36
Shoes
DUNIA SEPATU RITELINDO, PT (kons)
33776
S1
KASOGI
37
Home Textile/Ladies
AWEI
33867
S1
SM Kitc. Acc
38
Man & Ladies
IIN YUSIANA SANTOSO
33997
S1
Marvels
39
Ladies /Children
TJOA MEI SIU / RINA
34086
S1
EXTRA / Honey Kids
40
Man & Ladies
TARGET MAKMUR SENTOSA, PT
34166
S1
Emberlly U/wear
41
Ladies
CALCRIS (new)
34189
S1
SRP T-shirt
42
ladies
KORNELI (kons)
34221
S1
REVITA ACC
43
Home Textile
HILON INDONESIA, PT
34290
S1
Hilon Mattrass
44
Man & Ladies
C.V Lyra
34434
S1
Hard Top
45
Man & Ladies
TRANS NUSANTARA SEJATI, PT
34478
P1
Rider U/wear
46
Baby / Children
CIPTA KREASINDO ABADI, CV
34479
S1
Colorado
47
Man/Ladies/Baby
SUMBER JAYA GARMENTS, PT
34497
S1
Top Knit / Chocoby
48
Home Textile
JOEMARJAJA LOEKMAN
34571
S1
Silver Sring Cushion
49
Man & Ladies
MEGARIAMAS SENTOSA, PT (Regular)
34665
S1
Sorella U/wear
50
baby
BAYI KIDDY INDONESIA, PT (kons)
34702
S1
kiddy
51
Ladies
TARGET MAKMUR SENTOSA, PT(kons)
34775
S1
Infinity
52
baby
KIRANA PACIFIK LUAS, PT PUKU2 (kons)
34790
S1
puku-puku
53
Baby
KIRANA PACIFIK LUAS, PT CLARIS
34796
P1
Claris/Kiramas
54
Man & Ladies
PANCA TALENTAMAS, PT
34868
S1
Vidal Comb
55
Shoes
DWI NAGA SAKTI ABADI, PT (kons)
34926
S1
HOMYPAD
56
Ladies
HANDOKO SUBALI
35006
S1
Elyzabeth Bag( toko tertentu)
57
Baby
DISTRIVERSA BUANAMAS, PT HUKI
35044
S1
Huki
58
Baby
MULTI INDOCITRA, PT PIGEON
35089
S1
Pigeon
59
Ladies
TITIEK JULIANA H /C-BESS (kons)
35139
S1
C-BESS (toko jawatengah)
60
Shoes
SPECTRA PANCA MITRA, PT (kons)
35293
S1
BATA
61
Baby
MENSA BINA SUKSES, PT CHICCO
35506
S1
Chicco
62
Ladies
PANCABUSANA ASRILARAS, PT HOME
35575
S1
Heaven lend
63
Children/ Baby
MAUREEN SUBRATA
35673
S1
Color baby wear
64
Ladies
ANA MULYATI SUPANGKAT
36457
S1
Apple Lds Pyjamas
65
Home Textile
KINERJA SELARAS UTAMA
36483
S1
Elyse /Venisia Towel
66
Shoes
CV. SEPATU SANI(kons)
36487
S1
Marvelino
67
baby
JAKARTA TUNGGAL CITRA PT (FAMILY)
36489
S1
family
68
Man & Ladies
CV. MITRA INDO PRIMA
36497
P1
MIP SOCK
69
Shoes
PANATRADE CARAKA (kons)
36563
S1
Specs
70
Home Textile
LANDRA
36564
S1
Homemate
71
Shoes
SINAR PRATAMA AGUNG
37152
S1
MICKEY
72
Ladies
CANG KOK TIE (ATIE)
37169
S1
jas hujan (batam only)
73
Shoes
Mamat Hidayat (New)
37262
S1
Sepatu OTOSAN
74
Home Textile
CEMERLANG ABADI RAYA "LELAP" (New)
37373
S1
Pilow/ bloster Lelap Spangle lds T-shirt
75
Ladies
RANCANG KENCANA (New)
37375
S1
76
Childdren
TRIDENT NUSANTARA (new)
37379
S1
"@KIDS
77
Childdren
JUVI TEDDY (New)
37382
S1
Singlet FORKIDS
78
Home Textile
WENINDO PRATAMA, CV
1032425
P1
Calmas Kitc. Acc
79
Man & Ladies
Multi Garment Jaya
10033999
S1
cardinal
80
Home Textile
ANUGERAH KARYA MEGAH (new)
100033698
S1
m- dream
81
Home Textile
PARADIGMA PERKASA, PT
100034804
P1
Pim Pillow Case (IP)
82
Shoes
SPECTRA PANCA MITRA, PT (kons)
100035293
S1
COHEN
83
Ladies
PANCABUSANA ASRILARAS, PT (IMPORT P1) HOME100035575
S1
Cushion Cover
84
Ladies/ Man
S1
Coax Man/ Lds
PANCABUSANA ASRILARAS, PT COAX LAD
200035575
59
Appendix C (Planogram)
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK MEDIUM
STOCK MEDIUM
STOCK MEDIUM
STOCK MEDIUM
91117965 FACE 1 PCS
91110720 FACE 3 PCS
91117938 FACE 1 PCS
91110695 FACE 3 PCS
91117947 FACE 1 PCS
91110702 FACE 3 PCS
91117983 FACE 1 PCS
91110748 FACE 3 PCS
91110784 BOUGANVILLE 34X80 SPORT
91110757 BBOUGANVILLE 34X80 SPORT
91110766 BOUGANVILLE 34X80 SPORT
91110800 BOUGANVILLE 34X80 SPORT
91110668 BOUGANVILLE 50X100 MEDIUM
91110631 BOUGANVILLE 50X100 MEDIUM
91110640 BOUGANVILLE 50X100 MEDIUM
91110686 BOUGANVILLE 50X100 MEDIUM
91110604 BOUGANVILLE 70X140 BATH BLUE
91110579 BOUGANVILLE 70X140 BATH YELLOW
91110588 BOUGANVILLE 70X140 BATH PEACH
91110622 BOUGANVILLE 70X140 BATH L.GREEN
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK BATH
STOCK MEDIUM
STOCK MEDIUM
STOCK MEDIUM
STOCK MEDIUM
91117974 FACE 1 PCS
91110739 FACE 3 PCS
91167045 FACE 1 PCS
91167027 FACE 3 PCS
91117956 FACE 1 PCS
91110711 FACE 3 PCS
91167036 FACE 1 PCS
91167018 FACE 3 PCS
91110793 BOUGANVILLE 34X80 SPORT
91167063 BOUGANVILLE 34X80 SPORT
91110775 BOUGANVILLE 34X80 SPORT
91167054 BUGAINVILLE 34X80 SPORT
91110677 BOUGANVILLE 50X100 MEDIUM
91167009 BOUGANVILLE 50X100 MEDIUM
91110659 BOUGANVILLE 50X100 MEDIUM
91166993 BOUGANVILLE 50X100 MEDIUM
91110613 BOUGANVILLE 70X140 BATH WHITE
91166984 BOUGAINVILLE 70X140 BATH NV. BL;UE
91110597 BOUGANVILLE 70X140 BATH RED
91166975 BOUGAINVILLE 70X140 BATH MAROON
60
Appendix C (Cont’)
91181994 MIP 91174000 Man 91103649 MIP 91156753 MIP 91103658 MIP 91156780 MIP 91140644 MIP Man formal
Sock Argyle
men casual
Twist sock
men casual
3,s Rp 9,900
9,900
9,900
9,900
9,900
men short toe Men comp 3's 19,900
24,900
91181994 MIP 91174000 Man 91103649 MIP 91156753 MIP 91103658 MIP 91156780 MIP 91140644 MIP Man formal
Sock Argyle
men casual
Twist sock
men casual
3,s Rp 9,900
9,900
9,900
9,900
9,900
91181994 MIP 91174019 MIP 91103649 MIP 91173994 MIP 91156771 MIP Man formal 3,s Rp 9,900
Man sock Thermal secret 9,900 Man sock
12,900
MAN 17,900
MAN 22,900
91102220 GT
91169936 GT
91169945 GT
Man sock
Man Sock Rib
men sport
MIPlong toe
MUNDO
Mundo sport
9,900
9,900
sock 9,900
19,900
21,900
13,900
sock 14,900
MAN 11,900
MAN 16,900
MAN 20,900
91156995
91173985 MIP
91110177
91213664
91102220 GT
91169936 GT
91169945 GT
MIPlong toe
Man sock
MUNDO
mundo sport
13,900 91199663
sock 14,900 91213664
MUNDO
mundo sport
7,900
sock 14,900
MAN 8,900
MAN 15,900
MAN
91199663
91110211
91102195 GT
91102248 GT
91215242 GT
MUNDO
MUNDO
7,900
17,900
MAN 8,900
MAN 15,900
MAN
91213940
91137541 GT
91122057
91122066
91199690
mundo lds
MAN LDS
men casual
Man Sock Rib
men sport
men toe sock
9,900
19,900
jacquard 3's
cas 3's 21,900
91181994 MIP 91151810 MIP 91103649 MIP 91173994 MIP 91103630 MIP 91103676 MIP 91134295 Man Man formal
Man sock rb
men casual
Man Sock Rib
men cas sock
3,s Rp 9,900
BUM
9,900
9,900
9,900
school sock bsr 3's 19,900 cas 3's 21,900
91157369 MIP 91140653 MIP 91148342 MIP 91148333 MIP 91148324 MIP 91157350 MIP 91103694 MIP LDS PLAIN
LDS SLOUGH LDS STRIPE
LDS PLAIN
SARUNG
SOCK 3'S TCM 3'S TANGAN 7,900 SOCK 9,900 9,900 LDS 9,900 19,900 24,900 ANTI SLIP 91157369 MIP 91140653 MIP 91148342 MIP 91148333 MIP 91148324 MIP 91157350 MIP 91103694 MIP LDS PLAIN
LDS SLOUGH LDS STRIPE
LDS PLAIN
SARUNG
SOCK 3'S TCM 3'S TANGAN SOCK 9,900 9,900 LDS 9,900 19,900 24,900 ANTI SLIP 91173976 MIP 91103578 MIP 91148342 MIP 91148333 MIP 91148324 MIP 91157350 MIP 91103694 MIP 7,900
LDS PLAIN
LDS STRIPE
LDS PLAIN
SARUNG
SOCK 3'S TCM 3'S TANGAN 9,900 LDS 9,900 T 9,900 19,900 24,900 ANTI SLIP 91173976 MIP 91103578 MIP 91148315 MIP 91157403 MIP 91157029 MIP 91157010 MIP 91157412 MIP 9,900
LDS SPORT
LDS SPORT 9,900
9,900
LDS SPORT 9,900
9,900
LDS SPORT MTF 9,900
9,900
9,900
MAN 16,900
MAN 20,900
91102248 GT
91215242 GT
MUNDO LAD MUNDO LAD MUNDO LAD
MOESLIM
STOCKING
STOCKING
ARMCOVER
14,900 91213940
10,900 91137550 GT
12,900 91122057
KNEE HIGH 91122066
12,900 91199690
mundo lds
MAN LDS
MUNDO LAD MUNDO LAD MUNDO LAD
sport sock
MUSLIM
STOCKING
STOCKING
ARMCOVER
14,900 91213940
13,900 91137550 GT
12,900 91122057
KNEE HIGH 91122066
12,900 91199681
mundo lds
MAN LDS
MUNDO LAD MUNDO LAD MUNDO LAD
sport sock
MUSLIM
STOCKING
STOCKING
ARMCOVER
14,900 91213959
13,900 91213968
12,900 91122057
KNEE HIGH 91122066
11,900 91199681
LDS stripe
LDS STRIPE
mundo lds
SOCK 3'S
sock 3'S
TOOSOCK
sport sock 14,900 91213959
LDS PLAIN
LDS stripe
LDS STRIPE
mundo lds
SOCK 3'S
sock 3'S
TOOSOCK
sport sock
19,900 21,900 19,900 91157047 MIP 91103541 MIP 91148315 MIP 91157403 MIP 91157029 MIP 91157010 MIP 91157412 MIP
MAN 11,900 91102195 GT
sport sock
LDS PLAIN
T 9,900 19,900 21,900 19,900 91157047 MIP 91103541 MIP 91148315 MIP 91157403 MIP 91157029 MIP 91157010 MIP 91157412 MIP
lds sock 9,900
GT.MAN
91213655
men cas sock
MTF 9,900
MAN 22,900 91169954 GT
91110177
9,900
lds sock 9,900
MAN 17,900 91102239 GT.
91173985 MIP
Man Sock Rib
9,900
12,900 91169927
91156995
9,900
SOCK/BALLE
14,900 91213646
sock 14,900
men casual
LDS
14,900 91116886
Mundo sport
BUM
LDS SPORT
91169954 GT
14,900
Man sock rb
SOCK/BALLE
91102239 GT.
MUNDO
Man formal
LDS
GT.MAN
24,900
3,s Rp 9,900
LDS SPORT
91169927
MUNDO
19,900
3,s Rp 9,900 Thermal 9,900 9,900 sock 9,900 19,900 jacquard 3's 91181994 MIP 91151810 MIP 91103649 MIP 91173994 MIP 91103630 MIP 91148299 MIP 91134295 Man
LDS SPORT
91116895
MUNDO
men casual
91181994 MIP 91174019 MIP 91103649 MIP 91173994 MIP 91156771 MIP Man formal
men short toe Men comp 3's
91116886
14,900 91213959
LDS PLAIN
LDS stripe
LDS STRIPE
mundo lds
SOCK 3'S
sock 3'S
TOOSOCK
sport sock
19,900
21,900
19,900
14,900
Arabina lds tumb 91213977 arabina lds tumb 91213977 arabina lds tumb
MUNDO LAD MUNDO LAD MUNDO LAD STOCKING
STOCKING
ARMCOVER
12,900 91122057
KNEE HIGH 91122066
11,900 91199672
MUNDO LAD MUNDO LAD MUNDO LAD STOCKING
STOCKING
ARM COVER
12,900 91122057
KNEE HIGH 91122066
10,900 91199672
MUNDO LAD MUNDO LAD MUNDO LAD STOCKING
STOCKING
ARM COVER
12,900
KNEE HIGH
10,900
61
Appendix D (Laporan Penerimaan Barang)
Periode : 1 - 30 APRIL 2007 Store : Hypermart BIP Div
MD
BEGINNING
es eri oc Gr
35 36 37 68
Total
n No
34 91 98
od
Fo
Total
Fre
61 69 96 97
sh
Total
Grand Total
DAMAGE
%
TRX_IN
TRX_OUT
M_UP
M_DOWN
BHU
RTV
1,171,942,579 1,188,680,920 1,020,078,470 -
358,524,810 109,808,925 88,403,330 62,196,900
317,100 270,000 -
4,378,372 13,425,300 4,426,985 127,696
4,485,850 2,487,715 53,435 28,500
4,255,907,616
3,380,701,969
618,933,965
587,100
22,358,353
7,055,500
2,313,812,100 1,446,543,693 4,304,025,487
344,167,000 229,678,806 1,075,305,300
1,042,553,500 329,882,900 645,181,000
5,753,600 699,600 -
10,858,700 2,579,828 11,088,600
2,512,900 1,430,500 2,390,500
14,554,200 3,182,500 27,116,000
8,064,381,280
1,649,151,106
2,017,617,400
6,453,200
24,527,128
6,333,900
44,852,700
79,302,623 119,020,286 101,341,797 46,899,337 346,564,043
188,047,200 221,745,380 546,719,530 303,205,795 1,259,717,905
17,930,430 6,999,000 301,331,400 7,641,550 333,902,380
913,070 615,415 3,763,061 1,502,276 6,793,822
407,018 146,221 5,415,487 843,326 6,812,052
-
4,189,800 1,991,000 643,500 1,502,911 8,327,211
12,666,852,939
6,289,570,980
2,970,453,745
53,679,303
20,201,452
-
234,030,246
CADANGAN DISCOUNT
-
7,040,300
NET SALES
ENDING
27,303,745 42,830,690 110,715,900 -
TO
180,850,335
PH
Budget
1,371,560 3,542,005 3,750,070 96,250
0.09 0.30 0.37 0.13
7,420,172 5,524,433 4,805,097 374,586
68,004,110 69,350,137 50,809,442 684,300
1,484,034,454 1,104,886,567 961,019,468 74,917,196
1,904,857,328 1,274,795,588 929,551,424 139,614,781
0.78 0.87 1.03 0.54
39 35 29 56
8,759,885
0.23
18,124,288
188,847,989
3,624,857,685
4,248,819,121
0.85
35
2,511,800 169,600 584,100
0.24 0.03 0.04
4,257,892 2,785,214 5,663,280
205,441,852 32,446,863 255,978,518
851,578,328 557,042,739 1,132,656,082
2,624,780,728 1,410,928,211 4,611,211,907
0.32 0.39 0.25
92 76 122
12,706,386
493,867,233
2,541,277,149
8,646,920,846
0.29
102
65
880,419 1,032,775 2,854,408 1,240,095 6,007,697
8,045,063 16,963,747 161,773,038 66,247,984 253,029,832
176,083,769 206,555,024 570,881,665 248,018,924 1,201,539,382
93,642,059 121,269,184 156,206,726 33,508,610 404,626,579
1.88 1.70 3.65 7.40 2.97
16 18 8 4 10
14
36,838,371 935,745,054
7,367,674,216
13,300,366,546
0.55
54
38
3,265,500
62
REC
1,962,631,458 1,191,819,090 948,066,051 153,391,017
2,945,195 422,130 55,380,963 7,887,109 66,635,397
1.60 0.19 7.56 2.51 4.58
78,660,782
0.95
30
Appendix D (Cont’)
Periode : 1 - 30 MEI 2007 Store : Hypermart BIP Div
MD
BEGINNING
ies cer Gro
35 36 37 68
Total
n No
34 91 98
d Foo
Total
sh
Fre
61 69 96 97
Total
Grand Total DAMAGE
REC
TRX_IN
TRX_OUT
M_UP
M_DOWN BHU
RTV
1,783,069,788 1,293,451,507 900,447,784 145,546,221
1,434,006,201 1,204,342,407 1,616,142,550 -
452,057,784 73,830,065 80,844,870 82,576,950
3,888,000 445,500 -
13,411,331 29,179,068 25,051,695 143,850
47,143,701 44,057,055 22,521,700 46,550
4,122,515,300
4,254,491,158
689,309,669
4,333,500
67,785,944
113,769,006
2,530,623,702 1,420,264,211 4,664,650,737
350,241,150 319,189,750 1,355,272,450
1,072,327,300 335,289,800 709,137,000
-
8,046,300 1,272,027 3,942,100
311,200 1,657,902 5,942,000
171,400 93,617,600 36,834,500
8,615,538,650
2,024,703,350
2,116,754,100
-
13,260,427
7,911,102
130,623,500
78,910,606 120,215,475 92,700,982 33,508,610 325,335,673
215,284,180 224,470,850 531,264,405 280,836,596 1,251,856,031
22,179,190 5,616,000 348,557,100 11,550,500 387,902,790
-
625,219 542,819 13,334,564 1,927,433 16,430,035
933,366 37,311 18,043,550 117,139 19,131,366
-
3,515,950 843,700 808,275 5,167,925
13,063,389,623
7,531,050,539
3,193,966,559
97,476,406 140,811,474
-
255,128,536
% CADANGAN DISCOUNT
4,333,500
NET SALES
ENDING
11,084,860 46,090,101 62,162,150 -
TO
119,337,111
PH Budget
1,509,550 2,455,505 13,818,930 21,850
0.09 0.20 1.19 0.03
8,457,418 5,909,741 5,734,743 381,350
63,372,125 59,972,015 16,508,460 391,600
1,691,483,535 1,181,948,263 1,146,948,695 76,270,043
1,855,605,915 1,260,370,367 1,354,346,721 151,155,628
0.91 0.94 0.85 0.50
34 33 37 61
17,805,835
0.42
20,483,253
140,244,200
4,096,650,536
4,621,478,630
0.89
35
2,173,720 67,700 722,500
0.16 0.01 0.04
4,868,734 2,629,398 7,876,767
363,732,649 22,635,100 359,431,571
973,746,761 525,879,540 1,575,353,429
2,616,233,988 1,429,528,548 4,746,841,520
0.37 0.37 0.33
83 84 93
15,374,899
745,799,320
3,074,979,730
8,792,604,056
0.35
89
65
944,589 974,720 2,814,019 1,169,450 5,902,777
14,142,174 12,467,953 95,227,554 43,739,081 165,576,762
188,917,722 194,943,917 562,803,825 233,889,986 1,180,555,450
106,112,771 141,194,253 250,217,141 37,972,483 535,496,648
1.78 1.38 2.25 6.16 2.20
17 22 14 5 14
14
41,760,929 1,051,620,282
8,352,185,716
13,949,579,335
0.60
52
38
2,963,920 2,432,623 383,290 56,750,962 10,126,725 69,693,600
1.20 0.18 8.62 3.65 5.18
90,463,355
0.96
30
63
Appendix D (Cont’)
Periode : 1 - 30 Juni 2007 Store : Hypermart BIP Div
MD
BEGINNING
ies cer Gro
35 36 37 68
Total
n No
34 91 98
od
Fo
Total
sh
Fre
61 69 96 97
Total
Grand Total
DAMAGE
%
TRX_IN
TRX_OUT
M_UP
M_DOWN BHU
RTV
1,854,910,124 1,260,550,816 1,361,061,834 153,397,621
1,346,280,025 1,211,577,837 837,705,355 -
658,624,720 95,162,360 135,611,745 67,668,200
3,888,000 -
5,646,815 28,114,832 13,176,935 587,150
779,530 1,804,410 284,210 700
4,629,920,395
3,395,563,217
957,067,025
3,888,000
47,525,732
2,868,850
2,388,625,694 1,428,953,764 4,745,200,989
557,751,100 232,641,300 967,143,600
922,994,220 350,694,000 303,929,100
2,578,400 -
22,352,980 1,656,600 4,260,080
1,588,350 2,773,500 19,435,480
13,392,200 1,742,100 96,560,500
8,562,780,447
1,757,536,000
1,577,617,320
2,578,400
28,269,660
23,797,330
111,694,800
108,064,317 143,457,185 113,082,460 82,727,815 447,331,777
158,323,955 194,679,740 519,851,642 258,008,150 1,130,863,487
25,705,395 1,890,000 60,555,700 20,782,850 108,933,945
4,063,925 2,007 9,490,964 1,164,749 14,721,645
1,714,204 91,756 10,178,433 3,091,194 15,075,587
-
7,317,795 955,300 3,842,800 865,800 12,981,695
13,640,032,619
6,283,962,704
2,643,618,290
90,517,037
41,741,767
-
381,801,096
CADANGAN DISCOUNT
-
6,466,400
NET SALES
ENDING
20,386,675 23,097,196 213,640,730 -
TO
257,124,601
PH Budget
1,834,675 6,078,380 3,298,065 120,950
0.09 0.48 0.29 0.15
9,282,462 6,085,726 5,577,285 391,884
106,961,464 45,584,693 16,064,045 724,150
1,856,492,382 1,217,145,125 1,115,457,005 78,376,750
1,865,836,496 1,295,610,315 993,234,529 142,038,537
0.99 0.94 1.12 0.55
30 32 27 54
11,332,070
0.26
21,337,356
169,334,352
4,267,471,262
4,296,719,878
0.99
30
3,983,000 4,111,800
0.29 0.30
4,898,488 2,822,699 5,522,782
394,101,500 30,675,302 251,364,394
979,697,624 564,539,880 1,104,556,406
2,491,484,432 1,411,392,183 4,538,982,407
0.39 0.40 0.24
76 75 123
13,243,970
676,141,196
2,648,793,910
8,441,859,021
0.31
96
65
8,094,800
64
REC
30
3,131,385 704,845 77,406,201 4,972,876 86,215,307
1.55 0.36 14.91 1.70 7.12
973,536 926,386 2,207,116 1,212,534 5,319,573
7,013,486 12,880,349 77,755,767 49,327,874 146,977,476
194,707,288 185,277,114 441,423,268 242,506,851 1,063,914,521
81,299,898 139,193,182 90,167,181 60,706,435 371,366,695
2.39 1.33 4.90 3.99 2.86
13 23 6 8 10
14
105,642,177
1.18
39,900,898
992,453,024
7,980,179,693
13,109,945,595
0.61
49
38
Appendix E (Supplier Service Level)
65
Appendix E (Cont’)
66
Appendix E (Cont’)
67
Appendix E (Cont’)
68
Appendix F (Out of Stock)
Dept 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91 91
SKU 91100786 91100820 91100973 91100982 91101007 91101016 91101025 91103658 91106075 91106299 91106422 91106459 91106495 91106593 91106655 91106833 91106986 91107065 91107172 91108395 91110257 91110300 91110328 91110533 91110917 91111078 91111158 91113816 91113843 91113889 91114244 91114397 91114404 91114422 91114459 91114477 91114940 91116331 91116359 91116377 91117778 91117787 91117796 91117803 91117812 91117830 91117849 91121530 91121638 91121781 91123903 91123921 91123930 91123949 91123958 91125643 91125787 91127687 91129425 91129434 91129443 91129461 91129498 91129505 91129550 91129569 91129578 91130351 91133269 91134017 91134991 91136435 91136471 91137550
SKU Description SOH Qty Sales C- Man Formal Shirt S/S-L/S 49.9 0 C- Man Formal Shirt S/S-L/S 59.9 0 BE Man Brief BE 03 117 L 0 BE Man Brief BE 03 117 XL 0 BE Man Brief BE 03 115 M3 0 BE Man Brief BE 03 115 L 0 BE Man Brief BE 03 115 XL 0 MIP Mens Cassual Socks Twist PJG M-409 0 MARVELINO Man Formal Shirt L/S Wht 0 Baby Toys Duck 7 Pcs T005W 0 Slaber Plastik Sablon SPS 09 0 Topi Lipat Handuk TLH 12 0 Topi Set Fleece TSF 16 0 Popok Kaos Print Double Isi 6 DLP3204 0 Sarung Tangan Kaki Rip DLS7101 0 C- Man Jeans Shirt 59.9 0 BD Baby Cln Pj BD 53002 CLR 0 CHC Btl 150 Ml Seri Sea 80011 0 CHC Baby Gift CB004 NTR 0 RYAN Baby Jacket Wht 18000 0 MUNDO School Flat HE3-P601 0 PUPU Perlak PP678 0 PUPU Potie PP65TP 0 PUPU Teether P137wt 0 TEENY WEENY Sarung Bantal Guling 0 PIGEON Btl RP-4 Mag2 Wildlife G00232 0 PIGEON Btl RP-8 Mag2 Sealife G00237 0 DIALOGUE TPLK VB PLS KTK 28X28 PRV1401 0 DIALOGUE TAPLAK VB PLS BULAT 28 PRV 1601 0 DIALOGUE Tplk RD Polos 90x90TNP IMT1420 0 UB Cushion Insert 45x45 0 MIRACLE DREAM Bed Sheet Ftd PL BL120x200 0 MIRACLE DREAM Bed Sheet Ftd PL Gr120x200 0 MIRACLE DREAM Bed Sheet Ftd PL YL120x200 0 MIRACLE DREAM Bed Sheet Ftd PL Gr100x200 0 MIRACLE DREAM Bed Sheet Ftd PL YL100x200 0 Mag Lap Tangan Hd Tenun Buah 04/Lth/Tpk 0 CALMASS Tutup Aqua TA-04 0 CALMASS Celemek A/B CLM-07 0 CALMASS Serbet Double SD-09 0 ELLEN Bra Set Assorted Motif 1 PR 0 ELLEN Bra Set Assorted Motif 2 PR 0 ELLEN Bra Set Assorted Motif 3 PR 0 ELLEN Korset+Long Torso/Set 1 PR 0 ELLEN Torso Assorted Motif 1 PR 0 ELLEN Korset Assorted Motif 2 PR 0 ELLEN Korset Assorted Motif 3 PR 0 C- Sepatu Cassual Pria I 0 C- Sepatu Sport Dewasa VI 0 GT Child Sock Htm Polos Large BTS-06B 0 COAX Men's Bermuda Krt 5/6 B 0 COAX Men's Bermuda Krt 5/6 D 0 COAX Men's C.Pjg karet twill CX 75 D 0 COAX Men's C.Pjg karet twill CX 75 B 0 COAX Men's C.Pjg karet twill CX 75 E 0 SKYLE Ladies Formal Skirts WR 08 0 BLAST Men's T-Shirt S/S BA 8 0 ACCAPELA Ladies Panties 3.75 PR 0 C-MARVELINO Men's Casual Shoes 121 0 C- MARVELINO Men's Formal Shoes 130 0 C- MARVELINO Men's Casual Shoes 131 0 C- MARVELINO Men's Bustong 210 0 C- MARVELINO Men's Sandal Trendy 231 0 C- MARVELINO Ladies Shoes Formal 310 0 C- MARVELINO Ladies Sandal C 422 0 C-MARVELINO Ladies Sandal A 430 0 C- MARVELINO Ladies Sandal B 431 0 C- EVITA Kacamata 17.9 0 B.MAN Men's Formal PantsUnpleatedCBB8022 0 MEDAL COMB BC 501 0 CHC Polycarbonate Breast Pump 61735 0 C-KASOGI Sandal Basica 0 C-KASOGI Sendal Anak 23.9 0 GT MAN Ladies Moslem Sock GTKMM 04 0
In Transit 0 4 0 0 0 0 0 0 0 0 2 0 0 8 0 0 0 0 0 0 1 0 0 7 0 0 0 0 0 0 0 0 1 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 4 0 3 0 0 0 0 0 0 0
On Order 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 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
Stat A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A A
Unit Cost Unit Retail 37198 49900 44653 59900 17077 27900 17077 27900 17668 29900 17668 29900 17668.18 29900 5000 9900 35000 64900 19950 32900 4840 7900 4400 7900 9515 12900 17145 27900 2927 4900 44653 59900 11400 17900 23400 34900 81000 119900 32000 49900 8127 13900 43875 59900 33750 47900 5216 11900 12323 19900 15624 22900 16600.5 24900 1255 4900 1255 3900 6273 12900 9000 14900 85000 119900 85000 119900 85000 119900 75000 99900 75000 99900 11604 21900 32800 54900 20550 34900 15550 27900 16200 22500 18000 25000 19800 27500 140400 195000 43200 60000 13680 19000 16200 22500 122659.09 179900 81750 119900 6491 10900 29545 49900 29545 49900 36000 59900 36000 59900 36000 59900 29000 49900 16750 27900 2550 3750 95925 135900 90935 139900 90935 139900 84435 129900 41925 55900 58435 89900 40677 55900 38935 59900 38935 59900 11814 17900 67500 109900 2806 4900 42503 59900 15377.27 19900 16295.45 23900 7581.82 13900
69
