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 - Mare Payeur 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. PART III - Effective Rate of Interest (15 points) 1. The Raw Materials Marty McFly purchases cost $50 each. Using the units you determined in your Break Even Analysis for the $30,000 profit (from BE part #5). Calculate the total Marty McFly needs to spend each month in order to purchase those raw materials. 2. Marty McFly purchases these materials from Holomax Inc. under sales conditions of 3/10 N/30. a. What would the Effective Rate of Interest be if payment were made on day 10? b. Day 11? c. And on day 30