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
What are the procedures of export under deferred paymente?

What is Marketing Audit, Marketing Audit is periodical assessment of marketing performance of a product. It is done with specific objectives in order to create awareness and improv

impact of having inadequate system design in the lead time and engineering cost

(a) The Marketing analysts Jim Sterne and Matt Cutler have developed a matrix that breaks the customer life into five distinct steps. Describe these five steps. (b) The CRM

State the Objectives of marketing communications Objectives of this module are to:   Examine concept of exchange in the marketing context;   Assess role of promotion in t

How should Shoppers? Stop develop its demand forecasts?

Explain the concept of Web marketing. Web Marketing: It is also termed as online marketing implies marketing the organizations products onto the virtual medium. In format

Management of marketing efforts: The company wants to design and put into action the marketing mix that will be the best achieve this objective in this target markets. The r

What are the Functions of Advertisement in Marketing? Functions of Advertisement: a) Enhance the market potential. b) Increase the sales. c) Communication to target

Creative Skills and New Ideas:- Creativity is the major element of advertising. If the ad-agency is competent of generating new ideas which are creative and profitable then such a