The following table contains the demand from the last 10 months:MONTH ACTUAL DEMAND1267103456789a. Calculate the single exponential smoothing forecast for these data using an a of 30 and an initial forecast (F of 31. (Round youranswers to 2 decimal places)Month50Month314567b. Calculate the exponential smoothing with trend forecast for these data using and of 0:30, a 5 of 0.30, an initial trend forecast (Tof1, and an initial exponentially smoothed forecast (F3 of 30. (Round your answers to 2 decimal places)B9ExponentialSmoothing1031343335FITI373638404041e-2. Which is best?c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts (Round your answers to 2 decimal places)MADSingle exponential smoothing forecastExponential amoothing with trend forecastSingle exponential smoothing forecastO Exponential smoothing with trend forecast

Single exponential smoothing-Ft+1= Ft+α (At-Ft)Here, α = Smoothing Constant = 0.30At = Actual demand…

Answered: The following table contains the demand…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 120 February 145 March 146 April 171 May 154 June 182 July 138 August 135 September 146 a. Forecast April through September using a three-month moving average. b. Use simple exponential smoothing with an alpha of 0.20 to estimate April through September, using the average of January through March as the initial forecast for April. c-1. Calculate MAD for Three-month moving average and Exponential smoothing. c-2. Use MAD to decide which method produced the better forecast over the six-month period.
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two moving average forecasting methods to see which one was better over this period. Month Actual Demand Jan 120 Feb 140 March 160 April 180 May 170 June 190 July 150 August 160 September 170 a. Forecast April through September using a three-month moving average and calculate MAD for the forecasts. b. Forecast May through September using a four-month moving average and calculate MAD for the forecasts.
Asvnch Problem - Statistical Forecasting Data Set – Eunice BC Fashion Monthly Sales, in million units. Year Total Sales Year Total Sales 2010 38 2016 43 2011 41 2017 40 2012 40 2018 45 2013 45 2019 47 2014 50 2020 42 2015 42 2021 48 Questions: a. Find the naïve forecast. b. Use the 3 years moving average forecast. c. Have a 5 years weighted moving average. d. Develop forecast using exponential smoothing with a = 0.2. e. Determine the trend line equation and present the forecast. f. Find the best forecast for year 2022. Note: Use the first 5 years as the training samples and the last 5 years as the forecasting samples. Solve it in Excel Sheet/Sheet with Equations as possible.
The following data shows sales forecast of Axis Dealer for motorbikes. Month Demand 1 650 700 3 810 4 800 5 900 6. 700 7 i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month Wt. Moving Average (weights: 0.2, 0.3, 0.5) for months 4, 5, 6 & 7? iii. Calculate an exponential smoothing forecast for the given data with an alpha of 0.1 for months 2, 3, 4, 5, 6 & 7. Assume a forecast of 650 for month 1. Show the formula and working method.
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 7 11 7 13 12 10 13 8 This exercise contains only parts b, c, and d. Part 2 b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Part 3 c) Using the 3-year weighted moving average with weights 0.10, 0.30, and 0.60, using 0.60 for the most recent period, provide the forecast from periods 4 through 12 (round your responses to two decimal places). Part 4 d) Mean absolute deviation for the forecast developed…
a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week weighted moving average, with weights of .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. c) compute the forecast for the week of Oct 12 using exponential smoothing with a forecast for august 31 of 360 and alpha 0.2
Weekly income for Quiet Mental Breakdown, an online psychology firm, is provided below. Determine, on the basis of minimizing the mean square error, whether a three-period or four-period simple moving average gives a better forecast. Week Income 1 980 2 1040 3 1120 4 1050 5 960 6 990 7 1030 8 1260 9 1240 10 1100 Group of answer choices Both the four-period & three-period simple moving averages have the same forecast accuracy in terms of their MSE There is not enough information to determine the answer The four-period simple moving averages gives a better forecast because it has the smallest MSE The three-period simple moving average gives a better forecast because it has the smallest MSE
The Toro Cutlery Company has collected monthly sales information below: MONTH January February March April 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): 87667 Forecast (January, 4-month MA): 72500 Forecast (January, 5-month MA): 69600 b. What will the forecast be for January the following year using exponential smoothing with a = 0.6? Assume the forecast for February this year is 25,000. Do not round intermediate calculations. Round your answer to the nearest whole number. SALES 25,000 18,000 43,000 110,000 MONTH May June July August SALES MONTH 84,000 September 28,000 October 97,000 November 58,000 December SALES 27,000 105,000 82,000 76,000
41) A medium-term forecast is considered to cover what length of time? A) 2-4 weeks B) 1 month to 1 year C) 2-4 years D) 5-10 years E) 20 years 42) When is the exponential smoothing model equivalent to the naÃ¯ve forecasting model? A) ? = 0 B) ? = 0.5 C) ? = 1 D) during the first period in which it is used E) never 43) Enrollment in a particular class for the last four semesters has been 120, 126, 110, and 130. Suppose a one-semester moving average was used to forecast enrollment (this is sometimes referred to as a naÃ¯ve forecast). Thus, the forecast for the second semester would be 120, for the third semester it would be 126, and for the last semester it would be 110. What would the MSE be for this situation? A) 196.00 B) 230.67 C) 100.00 D) 42.00 E) None of the above 44) Which of the following methods tells whether the forecast tends to be too high or too low? A) MAD B) MSE C) MAPE D) decomposition E) bias 45) Assume that you have tried three different…
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS