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
can you guys do an essay for my marketing class?

David Ricardo''s theory of comparative advantage is an improvement over Adam Smith''s theory of absolute advantage.

Question 1: What are the purposes of a Food & Beverage control system for a first class medium-size hotel running 3 (three) Food & Beverage outlets including room service?

Promotion Modern marketing calls for more than only develop a good product, pricing it pleasingly, and making it available to focused customers. Companies ought to also commun

A World of Marketing Communications All organisations - small and large, commercial, government, charities, educational and other not-for-profit organisations - need to communi

What decisions do companies face in designing a sales force? How can marketing decision support system help marketing manager towards making better decisions?

Demand Based Pricing : Described methods belong to the category of demand / market based pricing:- 1. What the Traffic can Bear' Pricing 2. Skimming Pricing 3. Penetration

Management of marketing efforts: The company wants to design and put into action the marketing mix that will be the best achieve this objective in this target markets. The r

Q. Illustrate the Effect on Consumer Choice? Effect on Consumer Choice:- Advertising has favourable consequence on consumer-choice. Advertising give information about a variety

Value  Pricing   :  Value  pricing  is  a  modern  innovative  and  individual method of pricing. Value pricing rests on the principle that the reason of pricing is not to recover