Please write the formulas in excel and the steps

Use the data provided below to answer the questions Sales (in thousands) Nave Method Moving Average Weighted Average Exponential smoothening Jan-20 20 February 21 March 15 April 14 May 13 June 16 July 17 August 18 September 20 October 20 18.6 November 21 19 December 23 19.6 Jan-21 23 ? ? What is the forecast for January 2021 using the Naive Method What is the forecast for January 2021 using 4-month moving average? Forecast for January 2021, using a 5-month weighted average using 0.1, 0.1, 0.2, 0.2, and 0.3 with the heaviest weights applied to the most recent months. Forecast for January 2021, using Exponential smoothening using a = 0.3. (round up to 1 decimal point.) With only the data and the methods mentioned in the table, which method allows you to forecast next March's sales? Explain your rationale? Be specific