The following tabulations are actual sales of units for six months and a starting forecast in January. FORECAST 85 January February March April May June February March April May June ACTUAL 100 96 a. Calculate forecasts for the remaining five months using simple exponential smoothing with a = 0.4. Note: Round your answers to the nearest whole number. 103 82 66 90 MAD Forecasts b. Calculate the MAD for all the forecasts, including January's. Note: Round your answer to 1 decimal place. 9.7

The following tabulations are actual sales of units for six months and a starting forecast in January. FORECAST 85 January February March April May June February March April May June ACTUAL 100 96 a. Calculate forecasts for the remaining five months using simple exponential smoothing with a = 0.4. Note: Round your answers to the nearest whole number. 103 82 66 90 MAD Forecasts b. Calculate the MAD for all the forecasts, including January's. Note: Round your answer to 1 decimal place. 9.7

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 4P: Consider the following time series data: Compute MSE using the most recent value as the forecast...

See similar textbooks

Similar questions

The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 20 21 17 12 15 15 15 19 22 22 23 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied the most recent month = sales (round your response to one decimal place). Using exponential smoothing with a = 0.35 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…
Refer to the time series data in Problem 1. Using the average of all the historical data as a forecast for the next period, compute the following measures of forecast accuracy: a. Mean absolute error b. Mean squared error c. Mean absolute percentage error d. What is the forecast for week 7? 1. Consider the following time series data: Using the nave method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error b. Mean squared error c. Mean absolute percentage error d. What is the forecast for week 7?
Consider the following time series data: Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: Mean absolute error Mean squared error Mean absolute percentage error What is the forecast for week 7?
Give typed explanation The demand for a product in the past 10 months were: 636, 463, 738, 744, 555, 486, 667, 518, 450, 682 Suppose a four-month moving average method is used to generate forecasts. What is the forecasted demand in month 6? Use at least 4 decimal places.
Monthly sales of storage sheds at Wallace Garden supply are shown in the following table. Using the 3-month moving average forecasting method (simple average), what is your forecast of December sales? Actual Month Sales January February March April May June July August September October November December? O 15.2 16.7 20.67 O None of the above 10 12 16 13 17 19 15 20 22 19 21
The following monthly sales (in thousands of AUS dollars) of chocolate boxes have been recorded for January, February, March, and April, respectively: 8, 8, 5, 9. Focusing on sales forecast accuracy for the month of April only, explain which of the following forecasting method would you recommend: the Naïve method, the Average method, or the Simple exponential smoothing method (assuming alpha=0.8 and initial state of 7)?
(b) Develop three-month and four-month moving averages for this time series. If required, round your answers to two decimal places. Enter the Mean Square Errors for the three-month and the four-month moving average forecasts. If needed, round your answers to three decimal digits.
A firm uses simple exponential smoothing with "a = 0.5" to forecast demand. The forecast for the 1st week of January was 505 units whereas the actual demand turned out to be 452 units. Calculate the demand forecast for the 2nd week. note: write the number with at most 2 decimal places without the unit (eg. 75.17 and NOT Php 75.17)
The monthly sales for Yazici Batteries, Inc., were asfollows: a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3,with the heaviest weights applied to the most recent months.iv) Exponential smoothing using an a = .3 and a Septemberforecast of 18.v) A trend projection. c) With the data given, which method would allow you to fore-cast next March’s sales?
The Toro Cutlery Company has collected monthly sales information below: MONTH MONTH May January February June March April SALES 15,000 18,000 33,000 115,000 SALES 77,000 30,000 80,000 44,000 MONTH September October November December SALES 34,000 101,000 68,000 84,000 July August The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): Forecast (January, 4-month MA): Forecast (January, 5-month MA): b. What will the forecast be for January the following year using exponential smoothing with a = 0.4? Assume the forecast for February this year is 15,000. Do not round intermediate calculations. Round your answer to the nearest whole number.
QWE Inn has recorded the following number of rooms sold for the first quarter of the year: January 2100 February 2500 March 2550 Assume that you found an average monthly geometric rate of change in rooms sales from the month of January to March be equal to 5%. What would be your forecast of rooms sales for the month of April if sales are expected to continue increasing at the same rate?
Bell Greenhouses has estimated its monthly demand for potting soil to be the following: Assume this trend factor is expected to remain stable in the foreseeable future. The following table contains the monthly seasonal adjustment factors, which have been estimated using actual sales data from the past five years: MONTH ADJUSTMENT FACTOR (%) March +2 June +15 August +10 December -12 Forecast Bell Greenhouses' demand for potting soil in March, June, August, and December 2007. If the following table shows the forecasted and actual potting soil sales by Bell Greenhouses for April in five different years, determine the seasonal adjustment factor to be used in making an April 2008 forecast. YEAR FORECAST ACTUAL 2007 500 515 2006 452 438 2005 404 420 2004 356 380