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
Do you think Jack is equipped with the managerial skills needed to head up a team that develops strategies for adapting existing company products into new products for sales

What is Negative communications Number of people affected by a dissatisfied consumer, and thus negative marketing communication messages, is limited. Implications of a poor p

what is text marketing and explain the various approaches that are followed by FMCG companies in Test marketing

Select THREE of the godrej consumer products ltd. SBUs and undertake a PEST analysis with regard to its business. Identify products which can be considered for launch by the select

You are the Marketing Consultant working for a client in ANY ONE of the following firms: a soft drink manufacturer, a mobile telephone service provider, a bank, or a retail oper

Broad Cast Media:- It includes advertisement in television , ratio and cable etc. It varies from print advertising media as it has both audio and visual effect. Broadcast is a med

Explain in role of managers in marketing communication Managers are now required not only to find new ways to communicate but also to do so on reduced budgets and they should a

What is Multi Segment Approach for selecting target markets? Multi segment Approach: As an organization directs its marketing attempts at two or more segments through dev

Define the Exchange process Exchange process is developed and managed by researching consumer/ stakeholder needs, identifying, selecting and targeting particular groups of stak

Various approaches by FMCG companies ..