PART II. - McFly Hoverboards had the following sales figures for the past year. He would like you to forecast his sales based on the weighted average and on the linear regression, and decide which method is best. (40 points) Time Period 1 2 3 4 5 6 7 8 9 10 11 12 Actual Sales S 2,425,000 2,458,000 2,505,000 2,640,000 2,550,000 2,580,000 2,612,000 2,628,000 2,670,000 2,705,000 2.730,000 2,735,000 BU 3310 Business Finance - Marc Paveur 1. Using Excel recreate this spreadsheet and then do the following: a. Create two new columns and calculate and compare a 3 month moving average and a weighted average forecast for months 4 through 12, using the weights 3, 5, and 8. b. Create two new columns showing the AIA-FI of each method c. Determine the MAD for each forecast and note which is more accurate. d. Using the Linear Regression - forecast months 13-24. This is the forecast for the business WITHOUT the new product. e. In a column next to your 13-24 forecast, create a new forecast for 13-24 by adding Marty's desired increase in sales from the sale of new hoverboards in order to earn the extra $30,000 profit (Sales dollars from BE part #5). This is the forecast for the business WITH the new product