Forecasting method, Marketing Management

Assignment Help:

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)?


Related Discussions:- Forecasting method

Explain about the straight rebuy purchase, Explain about the straight rebuy...

Explain about the straight rebuy purchase. A straight rebuy purchase: It is a routine purchase of similar products under roughly the same terms of role. The buyers choose

What are the important facts of marketing, What are the Important facts of ...

What are the Important facts of marketing Marketing identifies consumers' needs and supplies different goods and services to satisfy those needs most effectively. So businessma

State what is meant by perceived risk, Question: Consumers have to cons...

Question: Consumers have to constantly make decisions regarding what products or services to buy and where to buy them. Because the outcomes of such decisions are often uncerta

What is economic utility of marketing, What is economic utility of marketin...

What is economic utility of marketing? Economic Utility of Marketing: The extent to that, a product satisfied customer requirements and wants is called utility. The amount

Check, Explain the involving marketing tourism using diagram

Explain the involving marketing tourism using diagram

Product policy, Explain product policy in relation to agriculture

Explain product policy in relation to agriculture

Enumerate in detail about the communication process, Enumerate in detail ab...

Enumerate in detail about the communication process At a higher level, the communication process not only supports the transaction, by informing, persuading, reinforcing or di

What is operational crm?, Operational CRM technique is the element of Custo...

Operational CRM technique is the element of Customer Relationship Management that handles the actual interactions with customers, characteristically in the form of call centers, bl

Digital marketing strategy, Do some industry research as to educational lea...

Do some industry research as to educational lead generating. Determine a target market for this type of biz Find unrelated sites that have much of the targeted demographic as

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd