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
Boston Consulting Group By using the matrix, four kinds of SBUs can be identified as: a).   Stars   refer to   high- growth, high-share businesses or (they require a lar

Question 1: Mc Donald is a leading fast food restaurant that operates worldwide. Mc Donald conducts environment analysis to adapt itself to different countries. a) Iden


Discuss about the Holistic Marketing approach of marketing. The Holistic concept is depends on the design, implementation and development of marketing activities, processes and

What is Message reception Contextual conditions in which messages are received and ascribed meanings are very different. In organisational setting the context is more formal

Explain the stages in the Product Life Cycle with examples.

Product related segmentation: Product use situations: one of the important bases is the product use situations. Different customers may use the same product in different use

Describe the concept of market segmentation, targeting and positioning (STP''s) with a typical example of either a product or an organization you are familiar with.

What are the advantages of exporting in marketing? The advantages of exporting are illustrated in below: • Manufacturing is home based therefore, this is less risky than ove

How should Shoppers? Stop develop its demand forecasts?