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

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 Sales 1 120 2 114 130 3 4 5 6 7 8 9 10 124 97 95 100 110 109 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 General Management 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...

If you thought a stock was fairly valued and its price would not change, how could you use a straddle to take advantage of your valuation? If you follow this strategy and the stocks price does not...

Suppose you are A (Female students consider it as female assessee and male students consider it as male assessee), having only one source of income from Agriculture : Sale of Tea. Total income for...

Which is a Limited recourse Borrowing Arrangement (LRBA). Select one: a. A loan to a Company b. A loan to a business c. A loan to a SMSF d. A Personal loan

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...