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?

A E F K M 1 B D H 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 2. 3 4. EMA = 1 2 4 5 6 8 9 10 11 12 5 6 7 8 Period 9 Month 10 Previous Sales 11 2 Month Moving Average 12 3 Month Moving Average 13 4 Month Moving Average 14 EMA 15 January $89,500 February $74,300 3 March $82,650 April $87,900 May $98,630 June $115,450 7 July $120,874 August $68,452 September $59,852 October $71,456 November $98,456 December $87,285 16 17 18 19 20 21 Choice: 22 Explanation: 23