Demand Planning.Net: Are you Planning By Exception?
Demand Planning.Net
demand planning, forecasting, and exception management

Preparation for Workshop

We would like you to set up your laptop for data analysis, and also understand how to use Pivot Tables in Excel

You MUST follow video before the beginning of day one.
Please see videos below

One of the Forecast Modeling topics is Forecast Decomposition using Excel. For this, you need to set up some Add-ins.

The following video is a quick overview of how to add the ‘Analysis ToolPack’ add-in. This will add the ‘Data Analysis’ tool which we will use to calculate the level, trend and seasonal components of the data. This video covers both Office 2003, 2007 and 2010. We do NOT support previous versions of Office.

Download Video



One of the handy tools in Excel is the Pivot Table. If you are new to the pivot table analysis in excel, please see this video. We will be using Pivots in the class, so please be prepared to do this ahead of the workshop.

Download Video

 

To help you set up software at the end of day one, the following video should be helpful.

Please see video below

We will distribute trial software to demonstrate forecast modeling in our workshop. This video is step by step approach to install the software at the end of day one. You need the CD, which will be handed out at the beginning of class. Our analyst will be on-site if you need help. But please ensure that you have administrative access to your computer to add software.

Download Video

Materials for Workshop

Feedback Form
Sales Data (Required to answer the Questionnaire)

©2004-2018. by Demand Planning, LLC. All rights reserved. Privacy policy | Refund and Exchange policy | Terms of Service | FAQ
Demand Planning, LLC is based in Boston, MA , USA| Phone: (781) 995-0685 | Email us!

Consulting

Diagnostic |  DP Design |  Exception Management |  S&OP |  Solutions

Training

Demand Planning |  S&OP |  Retail Forecasting |  Supply Chain Analysis:  » Value Chain Metrics  » Inventory Optimization |  Supply Chain Collaboration

Industry

CPG/FMCG |  Food and Beverage |  Retail |  Pharma |  High Tech |  Other

Knowledge Base

Planning:  » Budgeting » S&OP |  Metrics: » Demand Metrics » Inventory  » Customer Service |  Collaboration:  » VMI & CMI » Account Based Forecasting
Forecasting:  » Causal Modeling  » Market Modeling  » Ship to Share |  For Students