do this question in excel and please share all steps

Question$1$

The Source is an electronic retail chain that, among other products, sells portable Bluetooth speakers. Monthly sales at a local The Sources store for the last $7$ months of $2023$ were as follows:

Month Sales

Jun. $19$

Jul. $18$

Aug. $15$

Sept. $20$

Oct. $18$

Nov. $22$

Dec. $25$

$1\mathrm{.}1.$ Plot the monthly sales numbers in a line chart.

$1\mathrm{.}2.$ Forecast the sales volume for January $2024$ using each of the following methods and round each result to whole numbers:

$1\mathrm{.}2\mathrm{.}1.$ Na$$ve method considering both Nov. and Dec. data.

$1\mathrm{.}2\mathrm{.}2.$ A five$-$month simple moving average.

$1\mathrm{.}2\mathrm{.}3.$ A weighted average using $0\mathrm{.}60$ for Dec., $0\mathrm{.}30$ for Nov. and $\mathrm{.}10$ for Oct.

$1\mathrm{.}2\mathrm{.}4.$ Exponential smoothing using a smoothing constant equal to $0\mathrm{.}20$ and a monthly forecast of $26.$