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

1

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

SRC Project 879 Progress Report March 2003

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

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.

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

5

DPH Planner – System Architecture

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

• f Demand-

Related Data

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

7

DPH System Design

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

8

Demand Data Source Schema

9

Product Info Database Schema

10

Example – OLAP Demand Dimension

11

Example – Product Hierarchy and Info Tables

12

DPH User Tutorial

DPH User Tutorial (see the attached document)

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

14

Future Direction

Investigating different DPH evaluation metrics Incorporating business constraints and rules into

the optimum DPH

Implementing DPH planners in actual business

settings