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
Market Defense  is the strategic actions that try to minimize or deter threatening activities by existing or potential competitors. Strategic moves can deter all or a few of the p

What is marketing audit in MIVE? Marketing audit: The marketing audit is, within some respects, where the raw material for the strategic control. Its function is to perio

Question 1: (a) ‘Knowledge is more than just an accumulation of bits of information.' Explain this statement in the light of the knowledge pyramid and the different types of

Q. Show the advertising effects on Employment? Effect on Employment: - Advertising has created together direct and indirect employment to various persons in the society. Thes


Q.   Described different levels of market segmentation? Ans.: The beginning point for segmentation is mass marketing. In mass marketing,  the  seller  engages in  mass produc

Question 1: Describe the marketing audit in detail. Characteristics of marketing audit Components of marketing audit Question 2: Explain consumer research p

1)What is the LA Galaxy "product"? 2)Which of the seven elements of the service marketing mix are most important in the LA Galaxy marketing program? 3)How is promotion (advertising

various approaches that are followed by FMCG companies test marketing in marketing management

You can get solutions of you marketing management homework on www.onlinesolutionproviders.com