Create a graph of widget sales, Marketing Management

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.

Posted Date: 2/25/2013 6:03:22 AM | Location : United States







Related Discussions:- Create a graph of widget sales, Assignment Help, Ask Question on Create a graph of widget sales, Get Answer, Expert's Help, Create a graph of widget sales Discussions

Write discussion on Create a graph of widget sales
Your posts are moderated
Related Questions
Normal 0 false false false EN-IN X-NONE X-NONE

Question : The Australian wool industry was facing serious difficulties in marketing its product since the last two decades. Synthetic materials were slowly replacing wool so

Factors affecting marketing planning: a large number of factors affect the long term marketing planning. These factors can be grouped under four categories: Internal factors:

#what is personal selling,direct marketing,exhibitions?

Explain about the decline stage of product life cycle. Decline Stage: A stage when sales demonstrate a downfall producer decides to abandon the market except only enough.

Explain the key function of marketing communication Many organisations have evolved without marketing being recognised as a key function, let alone as a core philosophy. There

Channels of distribution Meaning and definition: a major focus of channels of distribution is delivery. It is only through distribution that public and private goods and serv

Discuss the importance of strategy and good leadership in marketing


“Market Share is the best indicator of company performance.” Is this a reasonable statement?