Find the forecast of sales using exponential smoothing with smoothing constant 0.6 and 0.9 and infer the effect of exponential smoothing on forecast. Using MAD, determine the accurate forecast of exponential smoothing with given smoothing constant 0.3, 0.6 and 0.9. Introduction: A sequence of data points in successive order is known as time series. Time series forecasting is the prediction based on past events which are at a uniform time interval. Moving average method and trend projections are two of the time series methods which use weights to prioritize past data.

Question

Want to see the full answer?

Answer 1

Question

Chapter 4, Problem 17P

Summary Introduction

To determine: Find the forecast of sales using exponential smoothing with smoothing constant 0.6 and 0.9 and infer the effect of exponential smoothing on forecast. Using MAD, determine the accurate forecast of exponential smoothing with given smoothing constant 0.3, 0.6 and 0.9.

Introduction: A sequence of data points in successive order is known as time series. Time series forecasting is the prediction based on past events which are at a uniform time interval. Moving average method and trend projections are two of the time series methods which use weights to prioritize past data.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Consider the following time series data. Choose the correct time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Compare the three-week moving average forecast with the exponential smoothing forecast using Use trial and error to find a value of the exponential smoothing coefficient that results in a smaller MSE than what you calculated for = 0.2. Find a value of for the smallest MSE. Round your answer to three decimal places.

Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different forecasting models: Month Sales Forecast 1 Forecast 2 Jan 35 30 33 Feb 29 28 32 Mar 39 43 35 Apr 42 40 45 May 51 48 52 Jun 56 55 52 Which is the better forecasting model, based on the MAD criterion?

Since the beginning of the year, the purchase manager at a department store has been recording sales data to be used to compute 4-period moving averages to forecast sales for an upcoming month. Sales data for the months of January through September are reported in the table below. Month January February March April May June July August September Sales 21 20 39 22 29 14 42 28 27 Computed forecast values are not rounded. Compute the four-period moving average forecast for October. value as a whole number by rounding. Specify the Compute the mean absolute deviation (MAD) for the four-period moving average forecasts. Specify the MAD as a whole number by rounding. Compute the mean squared error (MSE) for the four-period moving average forecasts. Specify the MSE as a whole number by rounding. Compute the mean absolute percentage error (MAPE) for the four-period moving average forecasts. Specify the MAPE as a whole number by rounding. CHECK ANSWER