課程練習:利用EXCEL進行大數量下的快速預測編制和維護 Practice and Exercise: EXCEL skills for Forecast maintenance for large data quickly and efficiently.
數據透視表的應用:供應鏈關鍵KPI分析——銷售與發(fā)貨分析,準時交付率,訂單完成率,提前期分析等對實際客戶服務水平的評估 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
課程練習:利用EXCEL進行準時交付率,訂單完成率和提前期等供應鏈關鍵KPI的計算 Practice and Exercise: EXCEL skills for supply chain management KPIs assessment: OTD, Order Fulfillment, Lead Time, etc.
線性規(guī)劃求解-生產計劃產排程優(yōu)化 Capacity Optimization with Linear Programming Skills
利用線性規(guī)劃求解計算和評估生產計劃排程最優(yōu)方案
課程練習:利用EXCEL進行粗產能分析,運用線性規(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
物料結構分析ABC-XYZ法, ABC-XYZ analysis
安全庫存策略與模型 Safety Stock Strategy and models
課程練習:利用EXCEL進行ABC-XYZ分析,及統計安全庫存計算和分析 Practice and Exercise: EXCEL skills for ABC-XYZ analysis and safety strategy