Question: Develop a three-period moving average forecast for periods 13 - 15. Period Demand 10 243 11 401 12 412 13 270 14 499 Calculate the

Develop a three-period moving average forecastDevelop a three-period moving average forecastDevelop a three-period moving average forecast

Develop a three-period moving average forecast for periods 13 - 15. Period Demand 10 243 11 401 12 412 13 270 14 499 Calculate the forecasts for periods 13 - 15 by using a three-period moving average model (enter your responses rounded to the nearest whole number). Period Demand Forecast 10 243 11 401 12 412 13 270 385 - 385 14 499 15 Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.6 and 0.4, with the most recent observation weighted higher. Period Demand 10 254 11 407 12 402 13 272 14 440 Calculate the forecasts for periods 12-15 by using a two-period weighted moving average model (enter your responses rounded to the nearest whole number). Period Demand Forecast 10 254 11 407 12 402 13 272 14 440 15 Develop an exponential smoothing forecast (a = 0.50) for periods 11 through 15. Assume that your forecast for period 10 was 298. Period Demand 10 207 11 342 12 417 13 294 14 412 Calculate the forecasts for periods 11 through 15 (enter your responses rounded to two decimal places). Period Demand Forecast 10 207 298 11 342 12 417 13 294 14 412 15 Develop a three-period moving average and fill-in the table below (enter your responses rounded to one decimal place). Demand Forecast 125 Month January 2019 February March Apri 77 101 85 May 109 June 132 July 109 August 107 September 90 October 93 November 91 December 88 The forecast for January 2020 is (Enter your response rounded to one decimal place) The MFE is (Enter your response rounded to one decimal place and include a minus sign if necessary) The MAD is (Enter your response rounded to one decimal place) The MAPE is %. (Enter your response rounded to one decimal place) 1: More Info Month Demand 125 January 2019 February March 77 101 85 April May June 109 132 109 107 July August September October 90 93 November 91 December 88 Develop a wo-period weighted moving average forecast for March 2019 through January 2020. Use weights of 0.7 and 0.3, with the most recent observation weighted higher. Calculate the MFE, MAD, and MAPE values for March through December 2 Click the icon to view the time series data Develop a two-period weighted moving average and fill-in the table below (enter your responses rounded to one decimal place) Demand Forecast 100 Month January 2010 February March 79 107 Apri 90 May 98 June 138 July 100 August 117 September 85 October 90 November 80 December 92 The forecast for January 2020 is (Enter your response rounded to one decimal place) The MFE is (Enter your response rounded to one decimal place and include a minus sign if necessary) The MAD is (Enter your response rounded to one decimal place) The MAPE is %. (Enter your response rounded to one decimal place) D Month Demand January 2010 100 February 79 March 107 90 April May 98 June 136 100 July August September 117 85 October 90 November 80 December 92 Develop exponential smoothing forecast (a=0.4) for February 2019 through January 2020. Assume that your forecast for January 2019 was 60. Calculate the MFE, MAD, and MAPE values for February through December 2010 Click the icon to view the time series data. Find an exponential smoothing forecast for each period and fill-in the table below enter your responses rounded to one decimal place) Month Demand Forecast 99 60 January 2010 February 74 March 95 April 84 May 109 June 137 109 July August 119 September 87 October 98 November 93 December 92 The forecast for January 2020 is (Enter your response rounded to one decimal place) The MFE is (Enter your response rounded to one decimal place and include a minus sign if necessary) a The MAD is (Enter your response rounded to one decimal place) ) The MAPE is (Enter your response rounded to one decimal place) 3: More Info Month Demand 99 January 2019 February March 74 95 84 109 137 109 April May June July August September October November 119 87 98 93 December 92

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!