Create an Excel spreadsheet that begins with inputs of the four fore casts from the Time Series Forecasting module. Its purpose is to de velop a combination forecast that will serve as your team’s forecasts for each period. Assign a weight to each forecast model (the sum of all four forecast weights for one period should equal 1.0) and develop a “combination forecast” by multiplying each forecast by its weight. Keep the weights constant for the whole history file as you search for the best set of weights. If you do not like a particular model, give it a weight of 0. Calculate appropriate forecast error measures for your combination forecast in your Excel spreadsheet..