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
Define about the corporate advertising Many organisations recognise usefulness and significance of good public relations. This is due to the high credibility attached to messa

Assess the conceptual framework of market orientation that is presented in the article. Account for the five recently advanced perspectives on market orientation that are integrate


Q. Examples of Unfair Trade Practices? (i) Advertisement concerning weight-loss-claims of any medicine without proper test.  (ii) Using the words 'Government Supported', 'Go

How is an aging work force worked in Demographic Trends? An aging work force: Several impacts of aging work are which the work force will before experience, reliable and

i do not understand multiplying, dividing, subtracting, and adding fractions

How is forecast sale in marketing research? Forecast Sale in Marketing Research: Marketing research assists in marketing planning and sales forecasting. The researchers c

Question:   XYZ Company is producing and marketing cotton textiles to local markets. Currently, because of stiff competition its sales volume is decreasing from time to time.

Meaning of price: Price is the marketing mix element that product revenue, the other producer costs. Price is also one of the most flexible elements: it can be changed quickly

I''m looking for a Marketing Ph.D. student or a graduate to help me understand Cannibalization Analysis. You can be a Marketing undergrad or an MBA with the knowledge. As long as y