Historical demand for a product is as follows. The sales manager wants to test various forecasting methods to see which method works better during this period. Month Demand January 110 February 130...


answer part b only


Historical demand for a product is as follows. The sales manager wants to test various forecasting<br>methods to see which method works better during this period.<br>Month<br>Demand<br>January<br>110<br>February<br>130<br>March<br>150<br>April<br>170<br>May<br>160<br>June<br>180<br>July<br>140<br>August<br>130<br>September<br>140<br>a. Forecast April through September using a three-month moving average (3-MAD).<br>b. Use simple exponential smoothing with an alpha of 0.3 to estimate April through September,<br>using the average of January through March as the initial forecast for April.<br>c. Use 3-MAD from part (a) above to decide which method produced the better forecast over<br>the six-month period.<br>d. Follow part (b) above but using an alpha of 0.8 this time. Discuss the forecasting errors<br>produced by using the two different exponential smoothing constants.<br>

Extracted text: Historical demand for a product is as follows. The sales manager wants to test various forecasting methods to see which method works better during this period. Month Demand January 110 February 130 March 150 April 170 May 160 June 180 July 140 August 130 September 140 a. Forecast April through September using a three-month moving average (3-MAD). b. Use simple exponential smoothing with an alpha of 0.3 to estimate April through September, using the average of January through March as the initial forecast for April. c. Use 3-MAD from part (a) above to decide which method produced the better forecast over the six-month period. d. Follow part (b) above but using an alpha of 0.8 this time. Discuss the forecasting errors produced by using the two different exponential smoothing constants.

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here