A1 N 4 A x fx A B D E F G H 1 J K L M 1 Alpha = 0.3 2 Year Quarter Profit ($1,000) Exponential Smoothing Absolute Deviation 3 1 1 45 4 1 2 51 5 1 3 72 6 1 50 7 2 1 49 8 2 2 45 9 2 3 79 10 2 4 54 11 3 1 42 12 3 2 58 13 3 3 70 14 3 4 56 15 4 1 ? 16 17 Q2: The quarterly profits (in thousands of dollars) for "Royale Beverages" headquartered in Casey Illinois, about 80 miles southeast of Urbana-Champaign, are listed in the table above. 18 2a. (15 pts) Forecast year 4 quarter 1 profit using Exponential Smoothing with alpha = 0.3 19 Fill out the light gree cells in colume D 20 21 2b. (15 pts) Compute the mean absolute deviation (MAD). Show your steps in colume E. 22 MAD 23