310 likes | 502 Views
QAD Demand Management. Patrick Grace, QAD Solutions Consultant September 27th , 2011. 2011 Fall MWUG Session. 2011 Fall MWUG Session. Agenda. Forecasting Goals Solution Overview Basic Forecasting Demand Management Demonstration Summary. Demand Management. Forecasting Definition.
E N D
QAD Demand Management Patrick Grace, QAD Solutions Consultant September 27th , 2011 2011 Fall MWUG Session
2011 Fall MWUG Session Agenda • Forecasting Goals • Solution Overview • Basic Forecasting • Demand Management • Demonstration • Summary
Demand Management Forecasting Definition • Comprised of Two Words • Fore • Casting • Look Out • Throw Out
2011 Fall MWUG Session Value Chain
2011 Fall MWUG Session Typical Demand Forecasting Goals • Reduce forecast error • At SKU Level • More time spent in analysis versus hunting for issues • Exception based • Provide an easy, consistent method for capturing inputs to the forecast • Know accuracy by sources of input • Capture thoughts on adjustments • Use the forecast and customer orders to drive planning
2011 Fall MWUG Session Sample Requirements • Twelve to Eighteen Month Visibility • More Process Automation • Takes 10 hours to compile data to get to the sales staff and Export to Excel. • Ability to Handle Growth • What happens if we double our business? • Getting forecasts from new acquisitions? • What if we decide to drive MRP with forecast? • It has to be easy enough for the sales force to use and provide input.
QAD Basic Forecasting 2011 Fall MWUG Session
2011 Fall MWUG Session QAD Basic Forecasting
2011 Fall MWUG Session QAD Basic Forecasting
2011 Fall MWUG Session QAD Basic Forecasting
2011 Fall MWUG Session QAD Demand Management The Solution
2011 Fall MWUG Session Demand Management Defined • Demand Management: • Extensive statistical forecasting based on history, forecast, or other data series • Alerts to notify of exceptional circumstances • Inventory policies based on forecast variability and service level • Collaborative forecasting between suppliers and customers • Sales and Operations Planning “…actively managing demand signals to better sense demand (think of monitoring consumption instead of orders), [and] incorporating downstream data with a higher frequency of modeling (weekly or daily)” -- Source: AMR
2011 Fall MWUG Session QAD’s Demand-Driven Suite • Demand Management Engine • Collaborative Portal • Inventory Optimization • Rough-cut Planning • Sales & Operations Planning
2011 Fall MWUG Session Demand Management
2011 Fall MWUG Session QAD’s Demand Driven Suite Collaborative Portal Informal ERP Excel SQL Access QAD Other ERP SCM BI S&OP Inventory Optimization Demand Management Engine Rough Cut
2011 Fall MWUG Session Sales & Operations Planning Demand Planners Sales & Marketing Category Management Product Management Demand Forecast Demand Executive Review Resolve Issues Set Direction Determine Strategic Impact Consensus Supply Chain Operations Engineering Logistics Supply Forecast Supply Actual Results Reviewed & Analyzed Re-Forecast & Consensus Meeting Executive Review Meeting
2011 Fall MWUG Session Assisting the Supply Chain • Forecasting • Communicating • Life Cycle Management • Optimizing • Balancing • Planning • Measuring
2011 Fall MWUG Session Forecasting • Robust statistical engine • Error tracking • Allocation • EDI, POS, and on-line data • Planning bills
2011 Fall MWUG Session Statistics, Methods & Techniques
2011 Fall MWUG Session Hierarchies SBU FAMILY • Top Down • Bottom Up • Middle Out PRODUCT PRODUCT DIST CENTER PRODUCT CUST DIST CENTER SUPPLY-SIDE HIERARCHY MARKET FAMILY MARKET PRODUCT CUST DIST CENTER DEMAND-SIDE HIERARCHY
2011 Fall MWUG Session Communicating • Share information • Exceptions • Promotions or events • Reporting • Security
2011 Fall MWUG Session Life Cycle Management • Specific calculations • Profiles • Cloning/same as • Collaborate
2011 Fall MWUG Session Optimizing Optimize: • Safety Stocks • Service Levels • Order Points • Periods of Coverage • Lead Times
2011 Fall MWUG Session Balancing • Balance Supply & Demand through key resources • Equipment • Raw Materials • Labor • Subcontracting • What-if Analysis
2011 Fall MWUG Session Planning • Link medium to long term operations • Business goals • Operational planning • Financial planning • Model effect on supply capabilities and financials
2011 Fall MWUG Session Measuring • Improved visibility • Enhanced decision making • Reporting and analysis capabilities for all levels of the enterprise.
2011 Fall MWUG Session Standard Reports
2011 Fall MWUG Session Comparison Excel Output
2011 Fall MWUG Session Demonstration QAD Demand Management
2011 Fall MWUG Session Summary • More sophisticated forecasting techniques • Forecast collaboration tool • Changes to forecast easily uploaded • Measure Actual to Forecast accuracy • Exceptions and Filters • Document reasons for forecast adjustments • At series level or individual observations • Aggregate Forecasts different views • Hierarchy Manager • Help with setting safety stock levels • Rough Cut Capacity Planning • Planning for projected warehouse requirements
QAD Demand ManagementThank youFor Attending!! 2011 Fall MWUG Session