Create a graph of widget sales, Marketing Management

Assignment Help:

Q1 Create a graph of widget sales on the tab "Q1-Graph" and characterize the time series.  That is, does the time series appear to include the effects of (1) cyclicality, (1) seasonality, (1) trend, (1) irregular variation and, or (1) noise?  Please characterize each effect as appropriate.

Q2 Prepare the following forecasting methods using the template provided on "Data" tab and assess how well each method is performing (RSFE, MAD, MSE, and MAPE using the appropriate columns from I-AF) and indicate which method is performing the best and why:

A. 3-month moving average (use "Data" tab, column C)

B. 6-month moving average (use "Data" tab, column D)

C. 3-month weighted moving average (.65, .2, .15) (use "Data" tab, column E)

D. Single exponential smoothing (α=.3), enter smoothing constant into cell F2 and use this cell in the calculations for SES (Use "Data" tab, column F)

Q3:  Create a graph of widget Sales on tab "Q3-Graph" and then add to the graph the forecasts that you calculated in Q2.


Related Discussions:- Create a graph of widget sales

What is introductory stage in marketing strategies, What is Introductory St...

What is Introductory Stage in marketing strategies? Introductory Stage: a. Rapid skimming strategy : New product launch at high rate and a high promotion level. High pri

What is concluded by definition of consumer behaviour, What is concluded by...

What is concluded by definition of consumer behaviour? The definition of consumer behaviour conclude that this behaviour is the study of consumer about what they buy, while the

Agriculture marketing, Discuss the importance of strategy and good leadersh...

Discuss the importance of strategy and good leadership in marketing

Financial plan, The financial plan consists of a 12-month profit and loss p...

The financial plan consists of a 12-month profit and loss projection, a four-year profit and loss projection (optional), a projected balance sheet, a cash flow projection and a bre

What are the credibility factors, What are the Credibility factors Pub...

What are the Credibility factors Public relations scores heavily on credibility factors. This is as receivers perceive the third party as unbiased and to be endorsing the offe

Primary grouping of direct marketing, Primary grouping of direct marketing ...

Primary grouping of direct marketing 4Cs framework  signifies the key characteristics and shows relative effectiveness of the tools of promotion across various different charac

Back to nature case study, 1. Describe Back to Nature’s target market. [5 m...

1. Describe Back to Nature’s target market. [5 marks] 2. Outline Back to Nature’s (business and marketing) objectives. [5 marks] 3. Describe and evaluate the promotional strategies

Differance between low-context and high-context cultures, Questions ...

Questions Explain how an overseas nation's level of economic infrastructure can influence an international marketer's decision as to the viability of marketing to that count

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