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
(a) How can a firm's security policies contribute and relate to the six main business objectives? Give examples. (b) Define and discuss the use of cross-functional business pr

States the term Product Line and discuss in brief. Product Line: This is a group of products which is closely related since they perform a similar function, targeted at s

How should Shoppers? Stop develop its demand forecasts? Caselet 2 The

The motor car retail industry is one that is always facing numerous challenges. For car dealer businesses to survive, they must clearly demonstrate to consumers that they represen

Three stage channel of distribution When number of wholesalers used is large and they are scattered throughout the country, manufacturers often use the services of mercant

Question : (a) Differentiate between the terms "efficiency and "effectiveness" within the management context. (b) Identify and clearly explain the four most common chall

What are sabmiller interfaces with loqgistics, marketing, distribution

explain service marketing and give a company''s example?