simple exponential smoothing.

i need to calculate simple exponential smoothing from the info provided.

month #

sales units

base index

Calculate an SES+MA+BI forecast using the information below. Make sure to show your work. Forecast Analysis F Initial Forecast 500,000 BI Simple Exponential Smothing A A Month # Sales Units BI 1 WN 1,217,200 1,031,755 1,301,484 4 1,290,700 (a=.4, 3M- MA with BI) 0.50 0.67 0.83 F4 = 1.4 1.12 (A3+A2+A1)/B3+B2+B1) 6 (Initial Forecast/B3)] * | F5 - 1.4 1.17 (A4+A3+A2)/B4+B3+B2) .6 (F4/B4)] ' BIS 2.00 1.50 0.95 0.90 0.89 0.80 0.67 un 1,342,500 67899 1,067,000 1.393,500 1,158,900 714,700 1,028,004 1,090,978 1,189,200 11 12