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
Problem: After introducing a new product, management wants the product to enjoy a long and happy life. (a) How can the ‘life' of a product be conceptually analyses? (b) H

This debate requires you to show your understanding of consumer behaviour in designing promotion campaigns - the topic of the week. The case in point is the promotion of socially b

Question 1: Mc Donald is a leading fast food restaurant that operates worldwide. Mc Donald conducts environment analysis to adapt itself to different countries. a) Iden

What are main assets of brand equity? The main assets of brand equity are as given below: a. Brand Awareness: It refers to the strength of a brands presence within the min

Marketing planning: Through strategic planning, the company decides what it wants to do with each business unit. Marketing planning involves deciding on planning marketing s

What is life style in the consumer behaviour? Life Style: This is a pattern in that people live and spend their time and money. These are depends on consumer’s learning,

download here

Question 1: Discuss why new media will have to be created and conventional ones used differently to communicate with the rural consumer. Detailed explanation on ‘Advertis

What are the Intangible Goods Intangible goods refer to services provided to individual consumers or to organisational buyers (industrial, institutional, commercial, governm

What are the Credibility factors Public relations scores heavily on credibility factors. This is as receivers perceive the third party as unbiased and to be endorsing the offe