In 2005, Xerox Corporation's revenue fromcolor products and services was $4.6 billion,30%of Xerox's total revenue.following data show the quarterly percentagechange in revenue for 12 quarters.orTheYear Quarter %Growth2003 11521931514202004 126173184212005 1152.17322417(a)Use exponential smoothing to forecast thistime series. Consider smoothing constants ofa=0.2, and a=0.3.What value of thesmoothingconstant provides thebestforecast?(b)What is the forecast of the percentagechange for the first quarter of 2006?

Solution: This exponential smoothing is performed on Microsoft Excel. a) Step 1 : Open the…

In 2005, Xerox Corporation's revenue from color products and services was $4.6 billion, or 30%of Xerox's total following data show the quarterly percentage change in revenue for 12 quarters. revenue. The Year Quarter %Growth 2003 1 15 2 19 3 15 4 20 2004 1 26 2 17 3 18 4 21 2005 1 15 2 17 3 22 4 17 (a)Use exponential smoothing to forecast this time series. Consider smoothing constants of a=0.2, and a=0.3.What value of the smoothing constant provides the best forecast? (b)What is the forecast of the percentage change for the first quarter of 2006?

In 2005, Xerox Corporation's revenue from color products and services was $4.6 billion, or 30%of Xerox's total following data show the quarterly percentage change in revenue for 12 quarters. revenue. The Year Quarter %Growth 2003 1 15 2 19 3 15 4 20 2004 1 26 2 17 3 18 4 21 2005 1 15 2 17 3 22 4 17 (a)Use exponential smoothing to forecast this time series. Consider smoothing constants of a=0.2, and a=0.3.What value of the smoothing constant provides the best forecast? (b)What is the forecast of the percentage change for the first quarter of 2006?

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

Consider the following time series data for the real consumption of households and government, at current PPPS (in billions 2017US$). In year 2018, the first lagged value of the real consumption is L, and the first difference is Year 2015 2016 2017 2018 2019 1 3 4 5 rcont 1267 1307 1375 1413 O A. unknown; unknown. O B. 1413; unknown O C. 1375; 38. O D. 1307; -38 Reset Selection
Consider the following time series data. month 1 2 3 4 5 6 7 8 value |18|16 20 18 22 20 15 22 a. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month9. b. Using a=0.2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for month9. c. Which method appears to provide the better forecast?
Based on the following demand data, Glass Inc Company performs double exponential smoothing. Period 1 180 Demand 2 3 4 5 6 7 125 150 146 155 149 154 150 Assume the value a = 0.1, B = 0.15 Also assume the initial forecast value Fo = 135, Go = 20. Use double exponential smoothing. a. Find the following forecast values. F3 = F4 = Fs = F6 = b. Find the following if F1 = 145 and a = 0.2. F2,5 = F7,10 = c. Find the forecast error of first 6 values, then find MAD using these values. ej = e2 = ez = e4 = es = e6 = MAD =
b. Use a = 0.2 to compute the exponential smoothing forecasts for the time series (to 2 decimals). Time-Series Value Month Forecast 1 110 2 130 120 4 110 5 95 6. 125 7 140 8 140 9 105 10 80 11 100 12 110 13
QUESTION 1 Assume that sales for year “n" were 12 units and a forecast of sales for that year had been 10 units and you want to make a simple exponential smoothing forecast of sales for period “n+1." If alpha equals 0.6 the forecast for year "n+1" would be 11 11.2 10.8 11.5 12.2
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
1 - A simple exponential smoothing model has a current mean of 156.8. Assuming demand for next period is 170, update the value of the smoothing statistic. Let a = 0.1. 2- An electronics company has sold 145, 157, 124, 169,179, 201, 197, and 230 units of a certain stereo system quarterly for the past two years. Plot the data and fit an appropriate model. Forecast sales for the next two quarters.
the following information, Find the forecast for period two using exponential smoothing and a = 0.3. Period 2 Demand 64 70 A Forecast 59
The following data represent a portion of quarterly net sales (in $ millions) of Lowe's Companies, Inc., over five years. Net Sales 8861 10169 1 9984 Source: All data retrieved from Annual Reports for Lowe's Companies, Inc. Click here for the Excel Data File a-1. Estimate an exponential trend model with seasonal dummy variables. (Round your answers to 4 decimal places.) Year 2004 2004 2008 Intercept d1 d2 d3 t Variable Quarter 1 2 1 1 Se Exponential Trend A 1 Year 2 2004 3 2004 4 2004 5 2004 6 2005 7 2005 8 2005 9 2005 10 2006 11 2006 12 2006 13 2006 14 2007 15 2007 16 17 2007 2007 2008 18 19 2008 2008 20 21 2008 B Quarter 123-AWNA W NAWN-AW23 4 4 3 4 4 4 C Net Sales 8861 10169 9064 8550 9913 11929 10592 10808 11921 13389 11211 10406 12172 14167 11565 10379 12009 14509 11728 9984
When a time series is stationary, the appropriate forecasting technique(s) is (are). Multiple Cholce O simple exponential smoothing only simple moving averages or simple exponential smoothing simple moving averages only regression analysis or seasonal indexing
Six years of quarterly data of a seasonally adjusted series are used to estimate a linear trend model as T t=181.60 + 1.44t. In addition, quarterly seasonal indices are calculated as § 1= 0.85, § 2= 0.91, Ŝ 3 = 116, and § 4= 119. a-1. Interpret the first quarterly index. In other words, what is the value of the series in the first quarter as compared to the average? 15% above O 85% below O 15% below 85% above a-2. Interpret the fourth quarterly index. In other words, what is the value of the series in the fourth quarter as compared to the average? O 81% above O 19% above 19% below O 81% below b. Make a forecast for all four quarters of next year. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Quarter 1 Quarter 2 Quarter 3 Quarter 4