Solve this using clear and consice formatting in excel. Please show values and formulas step by step.

The monthly salos for Yanci Battenes, Inc, were as follows. This exescise contains onty parts B and C. b) Forecast January sales using each of the following mathods: i) Comquite the January sales forecast using naive method The danuary sales forecast using the nave mothod =23 sales. (Enter your response as a whole number.) i) Compute the January sales forecast using a 3 month moving average. The dankary sales forocast using a 3 month moving awerage approach = sales. (Round your response to fwo decimal placess) i) Comgute the January sales forecast using a 3 month weightod avorage with woights of 0.10,0.30, and 0.60 with the heaviest woights applied to the most recent montis The Jaruary sales forecast using a 3 month weighted average = sales (Round your response to two decimal places) iv) Compute the January sales forecast using exponential smoothing with =0.30 and a starting forecast for September being 18 . The danuary saies forecast using exponontial smoothing = sales. (Round your responso to ho docimal places.) v) Compite the January sabes forecast using a trend projection. Using a mithod of trend piojoction, the forecast for January sales =23.50 salos. (Round your response to fwo decinal places) c) The method that can be used for making a forecast for the month of March is