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