Problem:
Hudson Marine has been an authorized dealer for C&D marine radios for the past seven years. The number of radios sold each quarter is shown in the Excel template. Hudson Marine would like to forecast the quarterly sales for year
Required:
Question 1) Construct a time series plot.
Question 2) Construct a multiple regression model with dummy variables to develop an equation that takes into account both trend and seasonality. Give the quarterly forecasts for year 7.
Question 3) Out of four quarters of the year, which quarter has the peak demand? Which quarter has the lowest demand? Solve the problem and show all work.