課程練習(xí):利用EXCEL進(jìn)行大數(shù)量下的快速預(yù)測(cè)編制和維護(hù) Practice and Exercise: EXCEL skills for Forecast maintenance for large data quickly and efficiently.
數(shù)據(jù)透視表的應(yīng)用:供應(yīng)鏈關(guān)鍵KPI分析——銷售與發(fā)貨分析,準(zhǔn)時(shí)交付率,訂單完成率,提前期分析等對(duì)實(shí)際客戶服務(wù)水平的評(píng)估 Pivot Skills for analyzing SCM KPI measurements: OTD, Order Fulfillment, Lead Time, etc.
準(zhǔn)時(shí)交付率 OTD
訂單完成率 Order Fulfillment rate
實(shí)際提前期vs標(biāo)準(zhǔn)提前期 Actual lead time vs standard lead time
課程練習(xí):利用EXCEL進(jìn)行準(zhǔn)時(shí)交付率,訂單完成率和提前期等供應(yīng)鏈關(guān)鍵KPI的計(jì)算 Practice and Exercise: EXCEL skills for supply chain management KPIs assessment: OTD, Order Fulfillment, Lead Time, etc.
主計(jì)劃分析與決策 Master Production Scheduling
主生產(chǎn)計(jì)劃的概念、策略與應(yīng)用
主生產(chǎn)計(jì)劃排程表應(yīng)用 Mater Production Scheduling table
課程練習(xí):利用EXCEL進(jìn)行粗產(chǎn)能分析,運(yùn)用線性規(guī)劃求解進(jìn)行主計(jì)劃最優(yōu)規(guī)劃 Practice and Exercise: EXCEL skills for rough-cut-capacity-planning analysis, optimal calculation for master planning with LP.
主計(jì)劃案例分享 Case study
物料計(jì)劃分析評(píng)估 Material Analysis
物料需求計(jì)劃與采購(gòu)策略 MRP and procurement stragety
物料結(jié)構(gòu)分析ABC-XYZ法, ABC-XYZ analysis
安全庫(kù)存策略與模型 Safety Stock Strategy and models
課程練習(xí):利用EXCEL進(jìn)行ABC-XYZ分析,及統(tǒng)計(jì)安全庫(kù)存計(jì)算和分析 Practice and Exercise: EXCEL skills for ABC-XYZ analysis and safety strategy