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

Test marketing, explain the various approaches that are followed by fmcg co...

explain the various approaches that are followed by fmcg companies in test marketing

Explain the product life cycle concept, Problem : a) A Mauritian consum...

Problem : a) A Mauritian consumer goods firm is deciding whether to enter the United States market or the Asian market. Show why it should take into account different marketing

Global markets, Understanding other cultures is vital to success in the glo...

Understanding other cultures is vital to success in the global marketplace. Refer to Table 21-3 which lists some blunders in International Marketing. One of my favorite blunders ha

Explain the term - promotion, Explain the term - Promotion Promotion re...

Explain the term - Promotion Promotion refers to process of informing and persuading the consumers to buy certain product. By using this process, marketers convey persuasive me

Determination process of a product, Determination process: Estimating ...

Determination process: Estimating the demand for the product: the first step in determining the price of a new product is to estimate the anticipated demand of the product. H

Properties of triangle, properties of triangles. in the following problem...

properties of triangles. in the following problem, In a triangle ABC,if r1 is the exradius of the excircle opposite to A,r2 is the exradius of the excircle opposite to B and r3i

Branding, The Boeing Company makes a number of different types of aircraft ...

The Boeing Company makes a number of different types of aircraft for the commercial airline industry, e.g., the 727, 747, 757, 767, and 777 jet models. Is there any way for Boeing

Describe the marketing audit in detail, Question 1: Describe the market...

Question 1: Describe the marketing audit in detail. Characteristics of marketing audit Components of marketing audit Question 2: Explain consumer research p

Case study, How should Shoppers? Stop develop its demand forecasts?

How should Shoppers? Stop develop its demand forecasts?

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