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
Characteristics of the sales promotion: 1.       Sales promotion does not include advertisement, personal selling and publicity. 2.       Sales promotion activities are

how to make a project report in software development organisation?

How does cultural, social, personal and psychological factors influence buyer behaviour. Give examples

Characteristics of the New or Morden concept or product oriented concept of the marketing: Main characteristics of this concept of marketing are as follows: 1.      Accor

You are the Marketing Consultant working for a client in ANY ONE of the following firms: a soft drink manufacturer, a mobile telephone service provider, a bank, or a retail oper

Let the node at which we are starting be called the initial node. Let the distance of node Y be the distance from the initial node to Y. Dijkstra's algorithm will assign some initi

Introduction to Marketing Communications Marketing communications is a management process through which an organisation engages with its variety of audiences. Through understan

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

Question 1: (a) What is a communication brief (or a creative brief), and how is it typically outlined? (b) Why is an IMC campaign difficult to evaluate? (c) Explain how

Each country or region has a specific culture which is due to similarities in religion, language, beliefs and values. This could result in a "cultural challenge for international m