Location

Community Services & Continuing Education - Cairo

Objectives

• A detailed demonstration of the development of a multi-echelon supply chain model in Microsoft Excel is provided. First, the conceptual model for the supply chain is explained and developed in Microsoft PowerPoint. The monthly bucketed supply chain model is then developed in Microsoft Excel starting with a blank workbook. Inventory coverage, inventory value, replenishment planning, production planning, etc is covered at multi-levels of the supply chain. The student should leave the course with an understanding of the key requirements for modeling a supply chain as well as how to create a model in Excel.

Outcomes

Manage all supply chain processes effectively & quicklyAchieve high accuracy for supply chain results.Analyze all data and results of supply chain processesManage the suppliers and execution process easily

Course Contents

Excel ChartsLookup TablesAdvanced FiltersPivot TablesSupply Chain Analysis using ExcelStatistical Tools using Data AnalysisGraphical representation of DataForecasting using Statistical RegressionClassification of InventoryEconomic Order Quantity calculationInventory Safety Stocks computationDecision Models using the Solver Add-In OptimizerCase Study Example in Supply Chain Management