Forecasting method, Marketing Management

Q :  Regress widget sales on time and add the (a) line, (b) linear equation and (c) R2 (variance explained) to the graph you created in Q3.  Please explain the meaning of each.   Also, please characterize the trend if one appears to exist in the data (be specific).

Q:  Take your understanding of seasonality from Q1 and use this understanding to employ a 3 month moving average to capture this seasonality effect.  Please describe your forecasting method in words (8) and then implement this forecasting method (forecast through period 33) in Excel (10) (use "Data" tab, column G).  Once you have completed implementing this method, assess its performance (RSFE, MAD, MSE, and MAPE using the appropriate columns I-AF). 

For example, suppose that you observe an 8 period season (see Figure 1).  You might develop a forecasting model for the NEXT SEASON that is based on observations from the PREVIOUS SEASON!  For a more specific example, (see Figure 1) a 3-period moving average forecast for period 13 might appropriately be based on an average of periods (4,5 & 6)!  To visualize this example, please see Figure 1.

 

Figure 1: Example of Seasonality (for example purposes only - - graph not based on actual exam data)

Q Consider both the forecasting method that you examined in Q5 in combination with the forecasting method that you examined in Q4.  Combine these two methods to create a new forecasting method.  Both describe this method in words (8) and implement this new forecasting method (forecast through period 33) in Excel (10) (use "Data" tab, column h). Once you have completed implementing this method, assess its performance (RSFE, MAD, MSE, MAPE using the appropriate columns I-AF) in comparison to the forecasts in Q2 and Q5 (1).  Why is this (or is this not) a better forecasting method (2)?

Posted Date: 2/25/2013 6:06:17 AM | Location : United States







Related Discussions:- Forecasting method, Assignment Help, Ask Question on Forecasting method, Get Answer, Expert's Help, Forecasting method Discussions

Write discussion on Forecasting method
Your posts are moderated
Related Questions
download here http://helpfinalexams.com/exam/91/MKT-421-Final-Exam----2014


Q. Evaluation of advertising media - Magazines and Journals? Are one more form of print media. These are published regularly at regular intervals like fortnightly as well month

Question: ‘The basic differences between goods and services offer the biggest challenges to Service marketers'. With reference to services you are familiar with, discuss th

What is the role of marketing information system in marketing environment? The subsystem of Marketing Information System is interrelated and interdependent so as to meet the ne

What is Growth Stage of Product Life Cycle? Growth Stage: A period of quick market acceptance of product and substantial profit enhancement also. Throughout this stage pr

Objectives/Learning Outcomes The module coursework assessment is designed to enable you to partially demonstrate the learning outcomes required for the successful completion of

Define the term total quality management. TQM is stands for total quality management: In a strategic context, QM is most accurately categorized as a tactic for carrying o

Question : (a) "There are those-usually who have never experienced a crisis- who say that planning for a crisis is a waste of time because it is planning for something that wil

Question 1 (a) Relate the importance of well linking any visual aid to its specific message and explain the functions that visual aids can have. (b) The marketing officer of