inventory-01

Metro Supplier Handbook

METRO CENTRALIZED WAREHOUSE INVENTORY PROCESS


AGENDAN

1. SUMMARY INVENTORY MANAGEMENT

2. BOOKING OPERATION

3. DATA MANAGEMENT

4. CENTRALIZED STOCK MANAGEMENT


OPERATION PROCESS INVENTORY MANAGEMET

SYSTEM RECEIVE AND ALLOCATE

Prepare load manifest

BOOKINGCHECK IN

Filling Document

Checking good in transit

Receiving Return RTV, Claim

Checking In, out data`

Transfer data store to Store

Cycle countingAdjusted System

Metro Supplier Handbook Customer Delivery

BOOKING PROCESS

TRANSPORTATION

Suppliers sending Delivery notice

3

BOOKIING

Checking information Delivery notice

Sending booking

RECEIVING

PICIKING

2

1

4


Checking In, out data

Adjusted System

SYSTEM RECEIVE AND ALLOCATE

Transfer data store to Store

Filling Document

1. Check in out document and compare with system for all RI mode (BBXD; PAXD,CS,RTV)

2. Input data Scale system for all RI mode (BBXD; PAXD,CS,RTV)

3. Do adjusted System for issue mode (Claim , Wrong part ,damage , transfer store ,Varian ..)

4. Do transaction store to store for mode(BBXD)

5.Filling all document relate receiving and shipping (RTV, cycle counting ,adjusted ..)

DATA MANAGEMENT


CETRALIZED STOCK MANAGEMENT

RECEIVING Key In SystemChecking information

Delivery notice

Input racking and floor Shorting Damage

Damage Location Adjusted System

Input Information


WAREHOUSE OPERATION – EDI FLOW

MT- ORDER DESK

SEND ORDER REQUEST

MT GMS SYSTEM - ORDER GENERATE

DHL WM300I SYSTEM

PO/SO - EDI

DN- EDI

GR - EDI


DateCount of Late

Time/hour/day Count Of Booking Case

1-Nov 111 973-Nov 60 504-Nov 101 855-Nov 76 666-Nov 74 517-Nov 87 728-Nov 143 10410-Nov 236 16411-Nov 86 7712-Nov 130 10713-Nov 69 5914-Nov 164 13415-Nov 164 13417-Nov 100 9019-Nov 57 4820-Nov 98 8521-Nov 202 172

Total hour/case 1958 1595

Chart control late time booking

Detail late time booking per day


Chart control Wrong time booking

Date Sum of Booking Case Count Of Wrong Time Target/Hour Picking Time Refill1-Nov 12728 154 150 84.93-Nov 10619 61 150 70.84-Nov 3684 70 150 24.65-Nov 9139 41 150 60.96-Nov 83 34 150 0.67-Nov 14940 152 150 99.68-Nov 9738 215 150 64.910-Nov 11347 262 150 75.611-Nov 6243 99 150 41.612-Nov 4514 51 150 30.113-Nov 9800 116 150 65.314-Nov 18213 96 150 121.415-Nov 18213 96 150 121.417-Nov 16438 117 150 109.619-Nov 10403 54 150 69.420-Nov 15268.8 145 150 101.821-Nov 26053.5 344 150 173.7

Name incorrect Define Measure Analyze Implement ControlWrong time booking The supplier wrong time

delivery goodsSummary time wrong ,measure loss working time

Cuonting total loss time , manpower and area

Inform for CS and supplier Setup plan reduce wrong time

Audit weekly report

Detail wrong time booking


Store -10 Store-11 Store-12 Sore-13 Store-14 Store-15 Store-16 Store-17 Store-18 Store-19 Store-20 Store-21 Store-22 Store-23 Store-24 Store-25 Store-26 Sore-27 Store-28 Store-4031-Oct -1904 -1745 -1274 -997 -342 -376 -450 -1249 -854 -499 -166 -358 -265 -132 -228 -163 -243 -212 -266 -351-Nov -2068 -663 -1288 -347 -320 -436 -656 -272 -157 -243 -304 -92 -495 -52 -366 -194 -311 -292 -1824-Nov -881 -1107 -171 -68 -24 -917 -108 -286 -912 -466 -335 -177 -78 -18 -6 -414 -12 -297 -846-Nov -1949 -1315 -621 -221 -307 -253 -50 -335 -599 -685 -258 -67 -266 -28 e -72 -152 -138 -202 -108-Nov -2215 -1553 -998 -1507 -757 -667 -1306 -1097 -1012 -303 -589 -202 -884 -660 -473 -550 -1410 -474 -292 -45

10-Nov -2313 -667 -776 -322 -226 -92 -308 -590 -356 -151 -262 -146 -641 -42 -112 -119 -98 -60 -128 -1011-Nov -60 -221 -100 -20 -4 -46 0 -4 -48 -26 -290 0 -60 0 0 -2 0 -47 -20 013-Nov -1647 -1837 -765 -1025 -426 -502 -116 -540 -282 -160 -404 -571 -405 -472 -297 -407 -47 -304 -136 -814-Nov -135 -200 -100 -2 -120 -10 -10 -2 -220 -10 -85 -1 -80015-Nov -2078 -1916 -1992 -2500 -1238 -3755 -174 -1482 -898 -743 -683 -1306 -337 -393 -169 -430 -424 -837 -442 -7117-Nov -1860 -1016 -184 -390 -474 -582 -292 -726 -424 -184 -10342 -164 -358 -120 -470 -396 -104 -540 -560 -13818-Nov -1262 -827 -1471 -398 -207 -706 -166 -422 -103 -212 -241 -446 -248 -230 -108 -198 -206 -50 -148 019-Nov -722 -212 -410 -120 -12 -218 -218 -164 -128 -94 -58 -128 -4 -22 -82 -10 -168 -13620-Nov -1240 -1375 -494 -459 -329 -480 -20 -1267 -114 -464 -1546 -12674 -187 -219 -752 -88 -252 -60 -51121-Nov -5351 -646 -1439 -1036 -250 -1846 -255 -2472 -576 -1781 -568 -10253 -1229 -51 -446 -7153 -128 -13187 -5232 -30

Grand Total -25685 -15300 -12083 -9412 -5036 -10886 -4129 -10908 -6683 -6021 -16131 -26585 -5457 -2417 -3449 -11068 -3397 -16666 -8339 -347Manpower loss -142.6944 -85 -67.12778 -52.2889 -27.97778 -60.47778 -22.93889 -60.6 -37.12778 -33.45 -89.61667 -147.6944 -30.31667 -13.42778 -19.16111 -61.48889 -18.87222 -92.5889 -46.32778 -1.927778

STORE NUMBERDate

Chart control short Receipt of WH Southern

Detail short receipt per day


Store -10 Store-11 Store-12 Sore-13 Store-14 Store-15 Store-16 Store-17 Store-18 Store-19 Store-20 Store-21 Store-22 Store-23 Store-24 Store-25 Store-26 Sore-27 Store-2831-Oct -12 0 0 -3585 0 0 0 0 0 0 0 0 0 -120 -34 0 0 0 01-Nov -240 -132 -36 -174 -288 -12 -36 -12 -16 -714 -2584-Nov -98 -120 -72 -24 -1566-Nov -120 -72 -3879 -226 -24 -317 -25 -24 -24 -48 -248 -368 -24 -3148-Nov

10-Nov -392 -100 -12 -892 -30011-Nov 0 0 0 -3600 0 0 0 0 0 0 0 0 -2 0 -16 0 -720 0 013-Nov -1 -52 0 -1671 -342 -25 -433 -44 -43 -4 -1 -1 -1 -61 -56 0 -240 -1 014-Nov15-Nov -100 -116 -80 -14 -114 -52 -2 -2 -2 -120 -24 -217-Nov -768 -2152 -924 -966 -960 -960 -504 -420 -960 -1564 -3418-Nov 0 0 0 -124 -41 0 -24 0 0 0 0 0 0 -24 -548 0 -64 0 019-Nov -594 -178 -132 -2420-Nov -2 -51 -1324 -91 -12 -1508 -1 -1426 -121-Nov -24 -268 -424 -562 -72 -16 -1250 -104 -478

Grand Total -1167 -356 -87 -17977 -2636 -87 -4210 -168 -70 -42 -987 -17 -1027 -2351 -3321 -984 -5544 -37 -1Manpower loss -6.483333 -1.97778 -0.483333 -99.8722 -14.64444 -0.483333 -23.38889 -0.933333 -0.388889 -0.233333 -5.483333 -0.094444 -5.705556 -13.06111 -18.45 -5.466667 -30.8 -0.20556 -0.005556

STORE NUMBERDate

Chart control short Receipt of WH Northern

Detail short receipt per day


Chart control without booking

Date Receiving Total without booking/PO1-Nov 83-Nov 54-Nov 25-Nov 26-Nov 17-Nov 78-Nov 710-Nov 1312-Nov 413-Nov 714-Nov 815-Nov 417-Nov 318-Nov 419-Nov 420-Nov 921-Nov 1

1-Name incorrect.With out booking

2-Define.N/A booking report3-Analyze.Supplier4-Measure.Counting .5-Implement.Sending information for supplier must follow up Metro process6-Control.Summary date and make chart control and setting target reduce

Summary without booking Solution close without booking


Date ACTIVITY_DATE TIME WAREHOUSETRANSACTION

TYPE Q'ty adj (MU) LOCATION REFERENCE TYPE1-Nov-14 11/1/14 11:16 AM 71 40 -35 MT-DMG L21-Nov-14 11/1/14 11:16 AM 71 40 -10 MT-LOSS L95-Nov-14 11/5/14 11:31 AM 71 40 -170 CLAIM-ACCEPT L25-Nov-14 11/5/14 10:21 AM 71 40 -1 RTV-DMG L25-Nov-14 11/5/14 10:21 AM 71 40 -4 RTV-PST L211-Nov-14 11/11/14 11:11 AM 71 40 (-97) CLAIM-ACCEPT L211-Nov-14 11/11/14 11:14 AM 71 40 -847 CLAIM-ACCEPT L211-Nov-14 11/11/14 10:42 AM 71 40 -1 CLAIM-REJECT L212-Nov-14 11/12/14 12:44 PM 71 40 -2 CLAIM-CANCEL L213-Nov-14 11/13/14 4:41 PM 71 40 -174 CLAIM-ACCEPT L227-Nov-14 11/27/14 11:35 AM 71 40 -110 DMG L2

Chart control Adjustment

Solution reduce adjustment

Name incorrect Define Measure Analyze Implement ControlReport monthly Ajustment report Summary Ajustment code Make chart and report Checking and maintains Audit weekly reportWrong Code Adjustment Adjustment wrong code on system Wrong key in adjustment code Verify the reason wrong code Trainning Adjustment on system CheckingPending Adjustment Waitting approval Aging time waitting Summary aging time Do adjustment Check status waitting approval


Name of department and/or name of presenter

THANK YOU FOR YOUR ATTENTIONTHANK YOU

inventory-01

Documents

transfer store

transaction store

daydate store numberstore

time refill1

data managementchecking

data management4

implement controlwrong

input data scale system