FIWH4 — WH & MFG Inventory management report

FIWH4—WH & MFG Inventory management report CET/CIC/CIT 2007/05/14

MME WH & MFG Inventory management report

FIWH4.1: Slow moving report (全廠/T001) (weekly)

Slow moving logic:(after discuss with Account) 1. what is slow moving: 2. Slow moving date define: if the location has moving type 261 transition, the slow moving date will be defined is the last one 261 transition date. if the location has no moving type 261 transition, the slow moving date will be defined is the stock(現有庫存)moving in to this location transition date. By location & By material type to define stock’s slow moving date Slow moving report

Reports: 1. Slow moving basic data report: (from ZMMR122+BI分析) (1) 從ZMMR122資料中挑選符合以下標準的data, 組合成Slow moving basic data. a>. Material type: UNBW, ROH, INDR. b>. S_Day>180 & Slot=TFRU S_Day>90 & Function=warehouse but Slot<>TFRU S_Day>90 & Function=MFG S_Day>90 & Function=RMA S_Day>90 & Function=間接部門周轉測試材料 (2) 透過BI 分析給出Buyer Group/MRP demand/Model/Customer/GMS date/有多長時間未消耗/組成分類等欄位. 具體logic請見下一頁表格or 本頁附件. (3)ZMMR122+BI support欄位=slow moving basic data report. (詳見本頁附件). Slow moving report

Slow moving report

Slow moving report • MME support report: • Charge List (已要到錢) (正在要錢): • Plant, Customer, Model, Material, Qty. • Location priority: • Plnt, Site, Priority, Function, Owner, Manager, Purpose, MRP,材料/週轉庫 • 3. ZMMR123 upload: (wait for co-work with Tim & IT) • Material, Substitude, MP Customer, MP Model, Service Customer, Service Model, • GMS date, Vendor code, R1&R3 group.

Reports: 2. Moving report Slow moving report

Reports: Slow movingSummary report & Logic 3. SLM weekly Amount report & Chart 4. Weekly SLM In out balance report & Chart 5. SLM where from report & Chart 6. SLM按未消耗的時間長短分析report & Chart 7. SLM按半年未消耗的時間長短weekly分析report & Chart 8. SLM Over GMS date Amount report & Chart 9. Excess parts 處理進度 ( Manual finish by MME, then upload to analysis 報表) Slow moving report

FIWH4.2: Inventory report

DSI report (weekly) : 1. Material Inventory report 2. Monthly 銷售成本 report (cost provide by Account &FO provide by PMC weekly, and MME manual maintain the report) 3. Report 1 : MP analysis 4. Report 2 : Non-MP analysis 5. Report 3 : by customer analysis FIWH4.2

MFG block material list : 1. Material Inventory report (M??9 all type material+不以9結尾的M* location Block type Inventory) 2. M* location 測試週轉材Amount Goal report (MME manual maintain the report) 3. Where use define (6類) 4. MFG block type material Amount by location analysis report 5. MFG block type material Amount by where use analysis report 6.非周轉使用材料處理進度跟催 report 7. KPI待調整 report FIWH4.2

NPI material tracking report: TNPI/TSP1/TFES/TFRE NPI location material list Excess analysis NPI excess action analysis FIWH4.2

FIWH4.3: Material transition report

Weekly material scrap report: (MB51: moving type: 55*, Z2*, by weekly data) Scrap material detail report (MB51: material SMT production Qty report Scrap type define Scrap by reason analysis Scrap by department analysis Scrap material for MP 制損 analysis Scrap material for PE repair analysis Scrap material for turn parts analysis Scrap material for RMA department analysis FIWH4.3

Defect parts control report: (TGV1/TGV2/TGR1/TGB1) material stock list Owner rule material In-Out list KPI stock summary report KPI summary analysis Over 30days Amount analysis in out weekly summary report in out department report FIWH4.3

TGH1/TNB1 control report: TGH1/TNB1 material stock list TGH1/TNB1 material in-out list TGH1/TNB1 This week stock amount report TGH1/TNB1 weekly stock amount analysis report TGH1/TNB1 material amount by mateiral group analysis report TGH1/TNB1 material amount by department analysis in-out status FIWH4.3

FIWH4 — WH & MFG Inventory management report