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
WV8 is a large not for profit (NFP) public sector organisation responsible for organising the operation of publicly financed schools within its region. WV8 receives its income sole

Q. How agencies gain clients? 1) Acquire new clients as a result of referrals from existing clients. 2) Searching of new clients by making calls, writing letters and visitin

Question: Consumers have to constantly make decisions regarding what products or services to buy and where to buy them. Because the outcomes of such decisions are often uncerta

Why are firms utilizing Green Marketing? There are five probable purposes for firms raised use of green marketing. And these are: a) Organizations observe environmental mark

What is the focus of marketing concept? Marketing Concept: Focus: The focus of the firm subsequent the marketing concept is on the improvement of those products or serv

Question 1: a) What is meant by Customer Relationship Management (CRM)? b) Nestlé's products include baby food, bottled water, breakfast cereals, coffee, confectionery, da

Question 1 (a) Define Business Ethics. (b) Critically explain how Business Ethical considerations will help in the Marketing Communication of a product or service. Suppor

Should video game companies continue to alter their products to include other functions such as email?

A student can play 0,1, 2 hours of racquet ball on any given night. Construct a tree diagram to determine the number of ways that three night he can play for a total of five hours

Importance of the marketing in a Seller's or Buyer's market : A seller's market is one in which the demand for goods and in the services exceeds to the supply. In such a situati