Create a graph of widget sales, Marketing Management

Assignment Help:

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.


Related Discussions:- Create a graph of widget sales

Discuss the formulation of sales strategy, Problem 1: Discuss the formu...

Problem 1: Discuss the formulation of Sales strategy in brief. Definition of sales Strategy Formulation of Sales Strategy Transportation Problem 2: Compa

Test marketing, various approches followed by FMCG companies in test market...

various approches followed by FMCG companies in test marketing

General marketing and marketing budget, 1. General Admin costs cover the ge...

1. General Admin costs cover the general running of the organisation. It includes rates, electricity and maintenance recovered from Council - see Income. 2. The high cost of a

Market analysis, Carrying out a market analysis The marketplace is con...

Carrying out a market analysis The marketplace is continuously changing and a business must be constantly updating to the changes or it will not remain in business for longtim

Development of relationship marketing, Question 1: (a) Discuss the infl...

Question 1: (a) Discuss the influences that led to the development of relationship marketing. (b) Using appropriate theories, discuss why the marketing mix paradigm and the

Nelson mathematics sharing and grouping, use the equation of 42 divded by 7...

use the equation of 42 divded by 7 to write 2 promblems one about sharing the other about grouping

Identify the knowledge needs of an organisation, Question 1: (a) ‘Know...

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

Mis, what is mis

what is mis

Sara, what''s Challenges in Implementing E-CRM?

what''s Challenges in Implementing E-CRM?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd