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
Question 1: "Relationship Marketing is a new marketing paradigm which challenges the straight-jacket marketing mix approach." Evaluate this statement and illustrate with examp

1. Consider an economy in which George and Harriet consume only ale and bread. Georgeís utility function is UG = aG(bG 1) where aG and bG are his consumption of ale and bread

How should Shoppers’ Stop develop its demand forecasts?

Explain the term Business-to-Business Advertisement with examples. Business-to-Business Advertisement: • Promote plant & machinery, raw materials, spares etc. • Technic

Illustrate the term price leadership strategy. he presence of a leader assists to regulate the market and ignore too many price changes oligopolistic markets, in that the numbe

1. Using recent and current examples, explain how a marketer would decide whether a penetration or skimming pricing strategy would be more appropriate for a new product or service.

I WANT TO KNOW THAT WHAT IS INTERNET OF THE FUTURE WHAT IS WHAT I AM CURRENTLY STUDING IN MY MASTERS OF BUSINESS ADMINISTRATION ABOUT CUSTOMIZATION WOULD YOU KINDLY PROVIDE ME SOME

Brand equity: to understand the dynamics of brand, Aaker provides a framework called equity. Brand equity refers to a "set of assets and liabilities of a brand, its name and symbo

The DD drinks company was founded over one hundred years ago by a deeply religious family and has been recognised as being a good employer ever since. The company has a long histor

Maturity Stage In the product life cycle the maturity stage is that stage where sales growth slows or levels off. Product managers can have to do more than easily defend their