ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Contoh Pengisian
2
ItemSTOK AWAL
STOK IN W 1
STOK IN W 2
STOK IN W 3
STOK IN W 4
STOK OUT W 1
STOK AKHIR W1
STOK OUT W 2
STOK AKHIR W2
STOK OUT W 3
STOK AKHIR W3
STOK OUT W 4
STOK AKHIR BULAN
TOTAL ITEM KELUAR
**
1. Total Item Keluar =Total dari SO W1 sampai W4.
2. Stock Akhir Bulan = Stok Awal + Total SI - Total SO
3
DIABETAMIL MILK VANILLA 12DX150G
2515201317101815153258
4
5
ITEM ASSORTMENTSTOK AWAL
STOK IN W 1
STOK IN W 2
STOK IN W 3
STOK IN W 4
STOK OUT W 1
STOK AKHIR W1
STOK OUT W 2
STOK AKHIR W2
STOK OUT W 3
STOK AKHIR W3
STOK OUT W 4
STOK AKHIR BULAN
TOTAL ITEM KELUAR
SO DAILY
6
HILO ACTIVE CHOCOLATE 12DX250G21120614212210110,3928571429
7
HILO ACTIVE CHOCOLATE 12DX500G101222021831511480,2857142857
8
HILO ACTIVE ES TELER 12DX175G512531401401430,1071428571
9
HILO ACTIVE VANILLA 12DX500G1412212391811970,25
10
HILO ES TELER FC 36PX10SX15GTIDAK MASUK00000
11
HILO GOLD CHOCOLATE 12DX250G1012103741501570,25
12
HILO GOLD CHOCOLATE 12DX500G1512114311122814130,4642857143
13
HILO GOLD PLAIN 12DX200G13310010191850,1785714286
14
HILO GOLD PLAIN 12DX500G90927072540,1428571429
15
HILO GOLD SWEET POTATO 12DX500G1501521311201230,1071428571
16
HILO GOLD VANILLA 12DX200G412016511-1123970,25
17
HILO GOLD VANILLA 12DX500G012127531411394200,7142857143
18
HILO PLATINUM SWISS CHOCO 12DX12SX35G
29821120-72702720,07142857143
19
HILO RTD CHOCOLATE TARO 24PX200ML048173152617963451,607142857
20
HILO RTD KACANG HIJAU 24PX200 ML1024430228-23042680,2857142857
21
HILO RTD MILKY BROWN SUGAR 24PX200 ML
10242325271512-213310,03571428571
22
HILO RTD THAI TEA 24PX200ML62424228325619835190,6785714286
23
HILO SCHOOL CHOCOLATE 12DX250G121212717227522418180,6428571429
24
HILO SCHOOL CHOCOLATE 12DX500G71212217512-12532290,3214285714
25
HILO SCHOOL CHOCOLATE CANDY 12SBX20SX8G
401525520020515250,8928571429
26
HILO SCHOOL HONEY 12DX250GTIDAK MASUK0
27
HILO SCHOOL HONEY 12DX500G2121211211518126200,7142857143
28
HILO SCHOOL RTD COKLAT 24PX200ML244836911581840733391,392857143
29
HILO SCHOOL RTD VEGIBERI 24PX200ML36242413472452520-1963210,75
30
HILO SCHOOL STRAW CHEESECAKE 12DX500G
10123721701711660,2142857143
31
HILO SCHOOL VANILLA 12DX250GTIDAK MASUK#VALUE!#VALUE!#VALUE!22-10#VALUE!#VALUE!
32
HILO SCHOOL VANILLA VEGIBERI 12DX500G
110110111101920,07142857143
33
HILO TEEN CHOCOLATE 12DX250G1612511122517314140,5
34
HILO TEEN CHOCOLATE 12DX500G1012319118414311110,3928571429
35
HILO TEEN POPCORN CARAMEL 12DX500G
1001010-111011-1-0,03571428571
36
HILO TEEN RTD COFFEE TIRAMISU 24PX200ML
24242424232525544068281
37
HILO TEEN RTD COKLAT 24PX200ML02404-4-4844-2088-64-2,285714286
38
HILO TEEN VANILLA CARAMEL 12DX250G412127945-16414140,5
39
HILO TEEN VANILLA CARAMEL 12DX500G1012121021417611110,3928571429
40
HILO TEEN YOGHURT BANANA 12DX250G1612313124-12532260,2142857143
41
HILO THAI TEA FC 36PX10SX15G28010010-61610640,1428571429
42
L-MEN PROTEIN CRUNCH BBQ BEEF 60BX20G
805755701060555250,8928571429
43
L-MEN PROTEIN BAR CHOCOLATE 6SBX12SX22G
24420317-193636240,8571428571
44
L-MEN DAILY CHOCOLATE 12DX250GTIDAK MASUK#VALUE!#VALUE!#VALUE!0#VALUE!#VALUE!
45
L-MEN DAILY POPCORN CARAMEL 12DX250G
812081721721550,1785714286
46
L-MEN GM CHOCOLATE 12DX225G60615053240,1428571429
47
L-MEN GM CHOCOLATE 6DX500G5605110371650,1785714286
48
L-MEN GM TARO 12DX225G70707070700
49
L-MEN LW CHOCOLATE CEREAL 6DX12SX25G
46622440401060,2142857143
50
L-MEN PLATINUM CHOCO LATTE 6DX6SX33.5G
330303060600
51
L-MEN RTD HI PROTEIN 2GO CHOCO 24PX200ML
10242424643251831352301,071428571
52
NS ASO FC 72OX10SX14G45540337-4411031140,5
53
NS JERUK PERAS 72GUSSETX5SX14G9388510752550-757361,285714286
54
NS JERUK PERAS REF 12BAGX500G1712017017017209200,7142857143
55
NS RTD JERUK MADU 24PX200ML23023023122-325-2-0,07142857143
56
NS W'DANK BAJIGUR 24DX4SX15G20713211-41521370,25
57
TS AVOCADO COFFEE 12DX4SX14G124223023815213120,4285714286
58
TS COOKIES KLEPON 12DX5SX20G1312223320515312130,4642857143
59
TS CORN OIL 12BTLX946ML71216151411540,1428571429
60
TS EXTRA VIRGIN OLIVE OIL 12BTLX500ML
1301321111001030,1071428571
61
TS GULA JAWA 12BX350ML191271266-121882290,3214285714
62
TS HOKKAIDO CHEESE COOKIES 12DX5SX20G
131224121247172318-131301,071428571
63
TS HONEY 12BTLX350ML11224130000241212250,8928571429
64
TS KOREAN GARLIC BUTTERCOOKIES12DX5SX20G
2112121325271821-526190,6785714286
65
TS KOREAN GOGUMA COOKIES 12DX5SX20G
13126716-111762320,07142857143
66
TS LOW FAT MILK VANILLA 12DX180G912185301501560,2142857143
67
TS MAYONNAISE ROASTED SESAME 24BTLX200G
80808081710,03571428571
68
TS RTD OAT DRINK VANILLICIOUS 24PX190ML
2244-22-4-1434430-4-0,1428571429
69
TS SALTY SOY SAUCE 24BTLX200ML28243495441826125270,9642857143
70
TS SANTAN 24DX5SX20G3303303342902940,1428571429
71
TS SHIRATAKI NOODLES 40PX71G111101001001010,03571428571
72
TS SOY SAUCE 24BTLX200ML7247024-1539162380,2857142857
73
TS SWT CLASSIC 12DX100SX2.5G2524126191920231025361,285714286
74
TS SWT CLASSIC 24DX25SX2.5G3324249244815571740411,464285714
75
TS SWT CLASSIC 24DX50SX2.5G46482414323212682666521,857142857
76
TS SWT DIABETICS 12DX100SX2G3224126262618322717511,821428571
77
TS SWT DIABETICS 12DX25SX2G2012.1212218#VALUE!#VALUE!25730#VALUE!#VALUE!
78
TS SWT DIABETICS 24DX50SX2G4636482416306632821789652,321428571
79
TS SYRUP COCOPANDAN 12BTLX750ML51212123214917128130,4642857143
80
TS SYRUP LYCHEE 12BTLX750ML1301313762490,3214285714
81
TS SYRUP ORANGE 12BTLX750ML17899-71621430,1071428571
82
NS JERUK MANIS BX 250210212102102100
83
NS MANIS JERUK BOX 50014014144101950,1785714286
84
NS MADU LEMON RCG 1071632122221737631240,8571428571
85
NS JERUK YUZU RCG10141616327271825025210,75
86
NS CINCAU RCG 1003232112121138733311,107142857
87
NS SEMANGKA RCG 1003232151717116335291,035714286
88
NS BLEWAH RCG 107163216023233421-1047240,8571428571
89
NS MAROKO RCG 10316161919-52493140,1428571429
90
NS MARKISA RCG 1017716161113131712-129270,9642857143
91
NS ES RUJAK RGLCG 10 2321692525619629210,75
92
NS JERUK PERES 5's807737373-5757230,8214285714
93
NS JERUK NIPIS 10's1821616133-99102-84-3
94
NS FLORIDA ORANGE 72197241515-722-7101-10-0,3571428571
95
NS BRAZILIAN SWEET ORANGE 72337213232428-210230,1071428571
96
MANGGA GANDARIA3232321945-348160,5714285714
97
TS CAFE LATTE1212-11310390,3214285714
98
HILO CHOC,R101530155401327180,6428571429
99
HILO YOGURT STRAWBERY66611101110,03571428571
100
TS GOLDENMILL66-1707-1-0,03571428571