Please help me solve this question..

Question 1 : Use Forecast.3.xlxs (the picture above), to solve the following 3 questions on one excel file -- one sheet for each model:

a. AkPF//Arab-Kuwait Plastic Fibre// Co produced over past 6 seasons: 5, 9, 7, 12, 17, and 16 Tons. AKPF needs you to forecast following future cycle.

b. AKPF needs to calculate following future cycle given the following weights: 0.1, 0.2, 0.1, 0.3, 0.2, and 0.1

c. EAA//East Arabian Airways// started 4 months ago with sales: KWD100, 150, 200, and 600 thousand. EAA needs you to forecast following sales cycle.

C Cell Styles E2 fx 230 A B D E F G H I J K Linear data A3w+ + An wn 5xxx 1 SMA Simple Moving Average 2 Past cycles 200 220 210 230 Ikm. 3 w= w1 = w2= w4= 1 = 1/4 4 Forecast - F(n+1) = F(4+1) = F(5) - Al'w + A2'w + 5 6 Descriptior Cycles Activity/cycle weight/cycle 7 n (yrs) |A/yr w/yr = 1 A w 8 Yr1 1 200 0.25 50 9 Yr2 2 220 0.25 55 10 Yr3 3 210 0.25 52.5 11 Yr4 4 230 0.25 57.5 12 Yr5/Foreca 1 215 km 13 14 15 16 17 18 19 20 21 22 23 24 SMA WMA ESM ESM.2 Sheet3 +