Please calculate on paper and show steps. Can't use excel

n Use the dataset provided to complete this assignment (Show your work) Generate a forecast using the following algorithms O Nave: F - AN o Moving Average (MA): F4 = AuAtzA-+AR - 3 week MA o Weighted Moving Average (WMA): F, = W.A-1 + WgA++w.fr, Wi=0.50, W2 = 0.30, and W3 = 0.20 o Simple Exponential Smoothing (SES): F, = F,- + a(A4-F-.) or = a (...)+(1-0) F-1 a = 4 Initial forecast F1-850 Forecast Weighted Moving Average Week Sales Simple Moving Average Nave Simple Exponential Smoothing 1 2 3 4 5 930 870 940 920 870 910 930 870 940 920 6 Calculate the MAPE for each algorithm o Moving Average (MA): F ANTALYA ARA . 3 week MA o Weighted Moving Average (WMA): F1 = W.AC-K + W.A.W. - Wi=0.50, W2=0.30, and W=0.20 o Simple Exponential Smoothing (SES): F = + (-:-) or = a (A-+(1-of- a == .4 - Initial forecast Fi=850 Forecast Weighted Moving Average Week Sales Simple Moving Average Naive Simple Exponential Smoothing 1 2 3 4 5 930 870 940 920 870 910 930 870 940 920 870 6 lo Calculate the MAPE for each algorithm Forecast Accuracy Simple Weighted Moving Moving Average Average Week Sales Naive Simple Exponential Smoothing 4 5 6 920 870 910 What is the recommended algorithm? Simple Moving Average