Complete the excel sheet that can be found below and also answer the following questions:

1. Once you've completed building your models on the spreadsheet below; which forecast model would you choose?

2. Why would you choose the model you've selected?

3. What type of business intelligence analysis is this?

Forecast Planning Using the previous sales data below, create forecast models and determine which model you feel could be considered a "best fit" Explain the criteria you used to make your recommendation EMA = 1 3 4 6 7 8 January $89,500 2 February $74,300 March $82,650 April $87,900 5 May $98,630 June $115,450 July $120,874 August $68,452 9 September $59,852 10 October $71,456 11 November $98,456 12 December $87,285 Period Month Previous Sales 2 Month Moving Average 3 Month Moving Average 4 Month Moving Average EMA Choice: Explanation: Forecast Planning Using the previous sales data below, create forecast models and determine which model you feel could be considered a "best fit" Explain the criteria you used to make your recommendation EMA = 1 3 4 6 7 8 January $89,500 2 February $74,300 March $82,650 April $87,900 5 May $98,630 June $115,450 July $120,874 August $68,452 9 September $59,852 10 October $71,456 11 November $98,456 12 December $87,285 Period Month Previous Sales 2 Month Moving Average 3 Month Moving Average 4 Month Moving Average EMA Choice: Explanation