Please show work in Excel. I will rate!

Scenario The last 30 weeks of demand is given in the table below for a 3 1/2 horsepower replacement motor that is carried in stock at a distribution warehouse. The distributor competes for commercial customers by having the requested items delivered to their location within 24 hours. To do that they want a high service level of 90% To achieve the high service level at the lowest cost they want an accurate forecast. Their lead time to obtain the motor once they place the order is 2 weeks Nave Moving Average (MA) Weighted Moving Average (WMA) Exponential Smoothing a =0.7 Exponential Smoothing a =0.8 Actual Nave Forecast Absolute MA Forecast Absolute WMA Forecast Absolute Forecast Absolute Forecast Absolute (t) Demand Forecast Error Value Forecast Error Value Forecast Error Value Forecast Forecast Error Value Forecast Error Value Week Dt Ft E=(D- Ft) , Ft Ex=(D:- Ft) |E1| Ft EF(D.- Ft) Et Ft Ei=(D-Ft |EU| Ft E=(D-Ft |EU| 1 50 2 53 3 56 4 59 5 62 6 65 7 68 8 56 59 10 62