PLEASE SHOW ALL WORK AND STEPS. USE EXCEL

Forecasting Techniques Homework Problem

You have collected data on a firm's sales $($in units$)$ for a product line during the past $16$ weeks. Using the following forecasting techniques, determine the forecast demand for periods $17,18,19,$ and $20.$

$-$ Exponential smoothing with optimized $\backslash (\backslash$alpha $\backslash )$ value

$-$ Additive seasonality $($assume $\backslash (5^\{\backslash$text $\{$th $\}\}\backslash )$ month demand to be $240$ units

$-$ Multiplicative Seasonality using trend line

$-$ Which method would you use in the future if the period $17-20$ actual sales are $42,50,62,$ and $86$ units? Provide your rationale to support your answer.