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
Assume that you are James Peterson and you have just hired a new management team composed of highly qualified executives from outside companies.

Enumerate about the Objective Based Pricing This method is applicable to introduction of new (innovative) products. If, at introductory stage of the products, organisation wish

Problem 1: Using examples and illustrations, elaborate on the stages of business buying process and its influences. Problem 2: (i). Describe the distribution channel.

how should shoppers'' stop develop its demand forecasts?

Question 1: What role does copy play in a campaign? Why copy has to be written with great knowledge and skill. All relevant points needs to be addressed from Unit 6 compl

What are Marketing-Service Agencies? Marketing-service agencies: Advertising agencies, marketing research firms, marketing consulting firms and other service providers w

Tata Motors recently introduced the nano,the world''s least expensive car for the indian market.Can Tata succeed in targeting both the very low end of the auto market as well as th

Factors affecting overall marketing strategies : 1.       Competitors counter moves: this differ with the various marketing inputs. Most competitors can easily and quickly mat

INTRODUCTION -MIS The term Management Information System (MIS) is of relatively recent origin and is widely adopted following  the accelerated use of computers in the early 19

How is impact of promotional efforts determined? Find out the impact of promotional efforts: Marketing research facilitates appraising and improving the methods of sales p