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
Product mix strategies: A  company has several major strategic at its disposal, with respect to the width, depth and consistency of its product mix. One major management aspe

Problem : a) A Mauritian consumer goods firm is deciding whether to enter the United States market or the Asian market. Show why it should take into account different marketing

What is a media plan? A media plan is a comprehensive plan of all the outside advertising and promotional activities of the business for a particular period. Generally the peri

Marketing mix communication Organisations now accept that tools of the promotional mix are not the only way in which brands communicate. All parts of the marketing mix communic

Explain in detail about the Direct marketing Direct marketing seeks to target individual customers with intention of delivering personalised messages and building a relationshi

At this point, PP's bottled water business has shown operating losses of nearly $300(000), which does not include the initial investment of more than $800(000). Management is now t

Question 1: What role does copy play in a campaign? Why copy has to be written with great knowledge and skill. All relevant points needs to be addressed from Unit 6 compl

Explain Henry Assael Model of buying decision behaviour along with the diagram


What is the role of advertising agencies in distribution channels? Advertising agencies: Such facilitating agencies help within facilitating negotiation, through creating