Question: I need help on part B. I keep getting the same answer for month 2 on part b. Let me explain my process I dont

I need help on part B. I keep getting the same answer for month 2 on part b. Let me explain my process 
I dont understand what I am doing wrong? Also, I cannot use excel
Problem 18-7 (Algo) The following table contains the demand from the last 10 months: MONTH 1 2 3 4 5 6 7 8 9 ACTUAL DEMAND 32 35 36 38 41 39 39 41 44 40 10 a. Calculate the single exponential smoothing forecast for these data using an a of 0.30 and an initial forecast (F) of 32. (Round your answers to 2 decimal places.) Month Exponential Smoothing 32.00 1 2 3 32.00 32.90 33.83 4 5 35.08 36.86 6 7 37.50 8 37.95 9 10 b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a 8 of 0.20, an initial trend forecast (T1) of 1.00, and an initial exponentially smoothed forecast (F) of 31. (Round your answers to 2 decimal places.) Month FITT 1 32.00 2 32.16 3 4 5 6 7 8 9 10 month forecast 31 31.3 trend 1 .800 FIT 32 32.lle 2 1 0 3 O 5 actual 32 35 3le 38 41 39 39 41 44 40 L : 7. 8 9 2 27 Q mand optic a=3 5 = 2 F2 = (-3)(32) + (1-3)/30 = 31.3 +32.16 T2= 1.2) (31.3-31)+ (1-2)(1) = 80 How Is it wrong?Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
