BY EXCEL

For the following data are the sales of mattress during the last 24 Periods. (by using Microsoft excel ) 1. Use simple moving with N=2 to forecast the demand for previous 24 periods, what is the forecast for Mar (2023) 2. Use exponential smoothing with (with =0.1 ) to forecast the demand for previous 24 periods, given that F(1)=3000, what is the forecast for Jan(2023) 3. Use regression analysis tool to fit a line to your data and write the line equation what is the forecast for April (2023)