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

What is the focus of selling concept, What is the focus of selling concept?...

What is the focus of selling concept? Selling Concept: Focus: The focus of the firm subsequent selling concept is onto pushing the products through understanding aggres

Buying behaviour, Buying behaviour: Consumer decision making varies wit...

Buying behaviour: Consumer decision making varies with the types of the buying decision. The decisions to buy toothpaste, a tennis racket, a personal computer, and a new car ar

Marketing, Identify and briefly describe the four trends in the macro marke...

Identify and briefly describe the four trends in the macro market environment that will have or recently had an influence on the selected industry

Product life cycle strategies, Product life Cycle Strategies After lau...

Product life Cycle Strategies After launching a new product, management expects it will enjoy a long and profitable life. However, Management is also aware of that each of pro

International marketing logistics, difference between heavy lift surcharge ...

difference between heavy lift surcharge and long lift surcharge

Product mix, product mix of the lg company

product mix of the lg company

Inflation, Inflation The overall and general increment in price level f...

Inflation The overall and general increment in price level for goods and services in a particular economy. Inflation can be viewed by a raise in the general cost of living or a

Consumers confound marketers, Identify all the environment factors that can...

Identify all the environment factors that can affect the demand for consumer durables and assess the magnitude and direction for their impact

Statistics, 10% of inhabitants of a town are known to be suffering from a d...

10% of inhabitants of a town are known to be suffering from a disease. find the probability that in a random sample of 12 people from the town a. none will suffer from the disease

Ans me, consumer profile of typical buyer of rayban

consumer profile of typical buyer of rayban

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