task 879 1 intelligent demand aggregation and forecasting
play

Task 879.1: Intelligent Demand Aggregation and Forecasting Task - PowerPoint PPT Presentation

SRC Project 879 Progress Report March 2003 Task 879.1: Intelligent Demand Aggregation and Forecasting Task Leader: Argon Chen Co-Investigators: Ruey-Shan Guo Shi-Chung Chang Students: Chris Hsu, Tony Huang 1 Outline Most Significant


  1. SRC Project 879 Progress Report March 2003 Task 879.1: Intelligent Demand Aggregation and Forecasting Task Leader: Argon Chen Co-Investigators: Ruey-Shan Guo Shi-Chung Chang Students: Chris Hsu, Tony Huang 1

  2. Outline � Most Significant Outcomes and Deliverables � System Architecture of DPH Planner � DPH Planner Documentations � UML System Design � Demand Data Source Schema � Product Info Database Schema � OLAP Demand Dimension Example � Product Hierarchy DB Schema Example � User Tutorial � Future Direction 2

  3. 879.001 Most Significant Outcomes and Deliverables � Defined and developed an optimum Demand Planning Hierarchy (DPH) to support different granularities of planning activities. � Provided guidelines to help practitioners determine the appropriate aggregated levels to make demand forecasts. � Developed optimum methodologies to estimate the product-mix and the methodologies to predict the disaggregated demands. � Designed and developed a DPH Planner software system that can be used to find the optimum DPH for hierarchical products and perform what-if analysis. 3

  4. Outline � System Architecture of DPH Planner � DPH Planner Documentations � UML System Design � Demand Data Source Schema � Product Info Database Schema � OLAP Demand Dimension Example � Product Hierarchy DB Schema Example � User Tutorial � Future Direction 4

  5. DPH Planner – System Architecture Demand P and Planni anning ng Data Mart Data Mart Hierarchy erarchy P Planner anner (OLTP) (OLTP) MDX Query Demand-info DPH Result Dataset (OLAP) Optimization Data Mart Dimension Information Data (OLTP) Warehouse DPH Analysis T-SQL Other Sources Pre-process of Product-info of Demand- product data (OLTP) Related Data Result Dataset 5

  6. Outline � DPH Planner Documentations � UML System Design � Demand Data Source Schema � Product Info Database Schema � OLAP Demand Dimension Example � Product Hierarchy DB Schema Example � User Tutorial � Future Direction 6

  7. DPH System Design UML (Unified Modeling Language) System Design (see the attached document) 7

  8. Demand Data Source Schema 8

  9. Product Info Database Schema 9

  10. Example – OLAP Demand Dimension 10

  11. Example – Product Hierarchy and Info Tables 11

  12. DPH User Tutorial DPH User Tutorial (see the attached document) 12

  13. Outline � Most Significant Outcomes and Deliverables � System Architecture of DPH Planner � DPH Planner Documentations � UML System Design � Demand Data Source Schema � Product Info Database Schema � OLAP Demand Dimension Example � Product Hierarchy DB Schema Example � User Tutorial � Future Direction 13

  14. Future Direction � Investigating different DPH evaluation metrics � Incorporating business constraints and rules into the optimum DPH � Implementing DPH planners in actual business settings 14

Recommend


More recommend