For this assignment, please submit an Excel file with three tabs for each method and with embedded formulas. While this assignment is not graded, it's essential for practice, as similar questions may appear in your quizzes or exams. It will also contribute to your class participation grade.

Please note most recent sales data for a hypothetical company:

Period $1($Q$1,$ Y$1))$ actual sales $=155$ units

Period $2($Q$2,$ Y$1)$ actual sales $=152$ units

Period $3($Q$3,$ Y$1)$ actual sales $=157$ units

Period $4($Q$4,$ Y$1)$ actual sales $=153$ units

Period $5($Q$1,$ Y$2)$ actual sales $=155$ units

Here are the tasks:

Use exponential smoothing $($alpha $=0\mathrm{.}4)$ to forecast sales for Periods $2-6.$ Make a reasonable assumption for Period $1$ and explain your choice.

Forecast sales for Period $6$ using a $3-$point weighted moving average $($weights: $0\mathrm{.}5,0\mathrm{.}3,0\mathrm{.}2).$

Find the trend line for the provided data and use it to extrapolate Period $6$ sales using Excel.

Add seasonal component to your trend based sales forecast above and adjust your period $6$ forecast accordingly. Assume quarterly relatives: Q$1=1\mathrm{.}4,$ Q$2=1\mathrm{.}0,$ Q$3=0\mathrm{.}8,$ Q$4=1\mathrm{.}1$