Question: Given Table has data pertaining to the actual sales for 10 months in the past. Calculate forecasts for months 2 to 10 using an exponential

Given Table has data pertaining to the actual sales for 10 months in the past. Calculate forecasts for months 2 to 10 using an exponential smoothing forecast with an alpha of 0.3. Assume a forecast of 109 for month 1. Also compute the forecast accuracy using MSE, MAD and MAPE.

MOnth Actual sale

1 120

2 114

3 130

4 124

5 97

6 95

7 100

8 110

9 109

10 123

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Marketing Questions!

1.Given Table has data pertaining to the actual sales for 10 months in the past. Calculate forecasts for months 2 to 10 using an exponential smoothing forecast with an alpha of 0.3. Assume a forecast...

In the Table has data pertaining to the actual sales for 10 months in the past. Calculate forecasts for months 2 to 10 using an exponential smoothing forecast with an alpha of 0.3. Assume a forecast...

Question 3 Demand data for a product over the last 5 months are given below. Calculate forecasts for months 3 through 6 using two-month moving averages. Do not round answers. Month Demand Forecast 1...

Homework Assignment-Chapter 18 6 Saved Helps The following table contains the demand from the last 10 months ACTUAL DEMAN points References a. Calculate the single exponential smoothing forecast for...

A) Omar has heard from some of his customers that they will probably cut back on order sizes in the next quarter. The company he works for has been reducing its sales force due to falling demand and...

Month 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Jan 104 101 88 132 125 111 127 119 147 145 Feb 100 96 110 109 118 123 129 147 146 149 Mar 99 82 129 101 121 121 132 164 133 148 Apr 88 84 113...

Actual sales of a product for the past 6 months were the following: Actual MA Forecast WMA Forecast Exp Smoothing Forecast January 72 February 75 71.3 March 77 April 78 ? May 81 ? June 83 ? ? July ?...

Data collected from a single entities across a given period called: A. Cross-sectional data B. Time series data C. Categorical and quantitative data D. Random data E. None of the choices 2. Which of...

Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 23 29 38 24 28 37 24 26...

Consider the publicly-traded company your CLC group analyzed in the Environmental and Industry Analysis assignment. In a paper of 1,000-1,200 words, discuss potential growth opportunities and...

Marble Corporation had the following balances in its stockholders' equity accounts at December 31, 2012: Common Stock, $10 par, 50,000 shares authorized, 20,000 shares issued Contributed Capital in...

Select all that apply What assumption underlies net present value analysis? Multiple select question. All cash flows other than the initial investment occur at the end of periods. All cash flows...

Superior Corps direct materials costs are as follows: Quantities purchased and used 20,100 pounds Actual costs $429,500 Standard price per pound $23.40 Standard quantity allowed 18,500 pounds There...

3. Calculate total-revenue data from the demand schedule in review question 1. Graph total revenue below your demand curve. Generalize about the relationship between price elasticity and total...

5. In 2015, Paul Gauguins painting When Will You Marry sold for $300 million. Portray this sale in a demand and supply diagram and comment on the elasticity of supply. Comedian George Carlin once...

LO6.5 Apply cross elasticity of demand and income elasticity of demand.