ps 5, #8

Problem Sets 8 10 points References y Abad Le et Check my work Here are the actual tabulated demands for an item for a nine-month penod Lanuary through September Your supervisor wants to st two forecasting methods to see which method was better over this period MONTH ACTUAL 110 January February March 134 158 378 April May 170 166 June 178 July 144 August 130 September 146 a. Forecast April through September using a three-month moving average. (Round your answers to 2 decimal places.) Month Three-Month Moving Average April May June July August September Okuyog Problem Setes 8 10 ponts book H PHO Mences mheducation.com/ext/p/descontrow-ac A Hp Save & Check my b. Use simple exponential smoothing with an alpha of 0.20 to estimate Agri hrough September, using the average of January through March as the initial forecast for April (Round your answers to 2 decimal places) Mont Exponential Smoothing Apr May June July August September c-1. Calculate MAD for each method (Round your answers to 2 decimal places) MAD Three month moving average Exponential smoothing @ Law artikes shagant Problem Setes 8 10 A May June Wy Augal September e-1. Calculate MAD for each method (Round your answers to 2 decimal places) MAD average e-2. Use MAD to decide which method produced the better forecast over the six-month period O Exponential smoothing O Three-month moving average 30 Next >