Please show me the correct formuals and calculations for these tables in excel, and explain how they work

Data Set 1
Period	Actual
1	200
2	200
3	600
4	300
5	100
6	400
7	600
8	600
9	400
10	470
11	430
12	440
Using data set 1, next sheet titled HW1, calculate the following forecasts thru period 13.
A Nave forecast
B 3 period simple moving average forecast
C 4 period simple moving average forecast
D 3 period weighted moving average forecast with weights of 0.2, 0.3, 0.5 from oldest to newest
E an exp. smoothing forecast with alpha = 0.3
F an exp. smoothing forecast with alpha = 0.2
(note for E and F, start with period 1 forecast = 200.)
Then for each forecast, calculate the RSFE, the MAD, the MSE and the MAPE. Do this in the spreadsheet in the areas provided.
Then tell me, based on the MAD, MSE, MAPE, and TS in the summary area, which forecast you prefer.

H.1. H.1