Please note most recent sales data for a hypothetical company:

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

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

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

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

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

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

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(4$ pts$)$