Year201320142015201620172018201920202021202220233. A firm experienced the demand shown in the following table.5-year 3-yearMoving MovingExponential ExponentialSmoothing Smoothing(w=0.9) (w=0.3)AverageAverageActualDemand8009259001025115011601200115012701290a. Fill in the table by preparing forecasts based on a five-year moving average, a three-yearmoving average, and exponential smoothing (with a w=0.9 and a w = 0.3).Note: The exponential smoothing forecasts may be begun by assuming(Ye+1) = (Y₂)b. Using the forecasts from 2018 through 2022, compare the accuracy of each of theforecasting methods based on the RMSE criterion.c. Which forecast would you have used for 2023? Why?

Answered: Year 3. A firm experienced the demand…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 31 2 34 3 33 4 35 5 37 6 36 7 38 8 40 9 40 10 41 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast ( F1�1 ) of 31. Note: Round your intermediate calculations and answers to 2 decimal places. b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.30, a δ of 0.30, an initial trend forecast ( T1�1 ) of 1, and an initial exponentially smoothed forecast ( F1�1 ) of 30. Note: Round your intermediate calculations and answers to 2 decimal places. c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. Note: Round your intermediate calculations and answers to 2 decimal places. c-2. Which is best? multiple choice Exponential smoothing with trend forecast Single exponential smoothing forecast
Month Actual demand Forecasted Demand 1 950 1000 2 1070 1000 3 1100 1000 4 960 1000 5 1090 1000 6 1050 1000 For the dataset above, compute the overall MAPE.
6. The Motion Picture Association of America reports a drop-off of video disc sales. The data in the table below shows consumer spending on video discs (DVD, Blue-ray, and UltraHD Blu-ray) in the United States in the years 2015-2018. Year Consumer Spending on video discs (in billions of dollars) 2015 9.1 2016 8.0 2017 6.8 2018 5.8 (a) What was the average rate of change in consumer spending from 2015 to 2018? (Be sure to include units.) (b) Use the average rate of change calculated above to predict consumer spending on video discs in 2020?
Period 1 2 3 4 5 6 7 Actual 42 41 39 43 45 F ? ? 2 2. Using the same table above, compute the weighted moving average forecast for demand for four latest period. With data using a weight of .40 for the most recent, .30 for the next recent, .20 the next, and .10 for the oldest. Assume actual demand for period 6 is 44, what is the forecast for period 7?
Table 1. DEMOGRAPHY OF COUNTRY X 2020 2018 2015 Total population 109,035,343 100,981,437 92,337,852 Average annual population growth rate 1.63 (2015- 2020) 1.72 (2010- 2015) 1.90 (2000- 2010) Population density (persons per square kilometer) 363 337 308 Births (Based on civil registration) Male 990,390 750,871 632,870 Female 952,126 972,802 487,798 Deaths (Based on civil registration) Timely 506,530 509,762 473,987 Late 106,820 110,382 116,803 2012 2009 2005 Total population by sex 102,303,977 93,114,333 89,088,544 Male 51,962,069 46,257,634 44,788,757 Female 50,341,908 46,856,699 44,299,787 Proportion of total population by sex Male 50.79 49.68 50.27 Female 49.21 50.32 49.73 Total population by age group 0-4 years 10,931,818 10,784,233 10,656,575 0-14 years 32,793,155 30,937,734…
Based on the following graph, what is the year when the largest decrease in GDP took place ? GDP (change YoY) 6% 5% 4% 4% 3% 3% 3% 3% 2% 2% 1% -1% -1% -8% 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010o 2011 2012 2013 2009 2001 2005 2007
Below is a table containing data on product demand for the most recent five months along with the forecasts that had been made for those 5 previous months. Use the exponential smoothing method to forecast the number of sales to expect next month. Use the following value of alpha: 0.2. Month Demand Forecast 1 308 349.2 2 388 340.9 3 344 350.3 4 400 349.1 5 341 359.3
#8
Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. Thesmoothing constant is 0.2, and the old forecast for month 1 is 245.
Need a Net balance graph for the given data

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS