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

Ask an Expert

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

Write your message here..

Related Questions

Distribution, i want to know the type of distribution strategy that a compa... i want to know the type of distribution strategy that a company specialising in major appliance like refridgeration and washing machines can use?

Test Marketing, Explain the various approaches that are followed by FNCG co... Explain the various approaches that are followed by FNCG companies in test marketing

Selection of an advertising agency by rates charged, Q. Selection of an adv... Q. Selection of an advertising agency by Rates Charged? Rates Charged :- The rates offered by the advertising agency must be quite responsible. These rates must suits the pock

Cube of a binomial, (x+2)^2 (x+2)^2

Principal of marketing, place\distribution place\distribution

Relationship marketing, Relationship Marketing This approach is used to... Relationship Marketing This approach is used to marketing emphasizes the importance of personal relationship building with all parties among consumers, suppliers and distributo

Vals model, vals model on mobilink vals model on mobilink

Product positioning, what are product positioning concepts what are product positioning concepts

Marketing mix, what is the relationship between 4ps of marketing mix? what is the relationship between 4ps of marketing mix?

What is strategic control in MIVE, What is strategic control in MIVE? ... What is strategic control in MIVE? Strategic control: The balance of efficiency control is strategic control. This weighs the overall and long-term marketing plan in visi