Doar Comer M N P A D 1 CHAPTER 4: Example 7 F H 2 3 Forecasting Trend adjusted exponential smoothing 4 Enterpha and be between ander the past demands in the shaded cum 5 entera sing forecast. If the starting forecastines the fest period then delete the analysis for rows above the starting forecast 5 7 Aph 02 8 Beto 04 9 Data Forecasts and Error Analyst Forecast Smoothed Including Forecast Smoothed Trend 10 Period Demand Trend TFT Tror Atria Swed AP 11 Month 12 11 2 13 1 1 3 ON 12 Month 12 12.10 1.0 1721 10 17 M. 1 Month 20 158 2:10 172 12 42 2123 2017 14 Month 10 17 713 2014 1 TIN 1 000 15 Months 24 1991 >2 210 400 400 16 1 16 Months 21 2251 15 2.29 0x210 17 Month 31 2011 201 4243 > 111 MB 2714 245 30 0 0.73 01. 19 Month 29.24 2.1 150 6 62 45211 20 Nest period 3240 260 35.16 21 Total 220 11 155 BESAN 22 Averar 1.14 14 17:10 14.62N 23 Blas MAD MAPE 24 4.715566 25 Sheet1 Sheet Sheet2 Sheet 40 Forecasting 15 30 MS 100 COLE 26 12:54 AM 4.19 Income at the architectural firm Spraggins and Yunes for the period February to July was as follows: MONTH FEBRUARY MARCH APRIL MAY JUNE JULY I Income (in $ thousand) 70.0 68.5 64.8 71.7 71.3 72.8 EXCEL Use trend-adjusted exponential smoothing to forecast the firm's August income. Assume that the initial forecast average for February is $65,000 and the initial trend adjustment is 0. The smoothing con- stants selected are a = 1 and B = .2. Px (MyLab Operations Management also includes a shorter (brief) version of this problem.) ...4.20 Resolun