investment forecast analytic

U IM 6 Merge & Cente A1 fx Please consider the following information: C DE F Please consider the following information: B G H 1 2 3 4 6 7 Year 1 Actual sales Deseasonalized sales 836 825 1220 1319 1020 1184 685 641 + 875 1008 1068 1141 Adj. seasonal index January 0.8 February 0.8 March 1.1 April 1.2 May 1 June 1.1 July 0.8 August 0.7 September 0.9 October 1.1 November 1.2 December 1.3 January 0.8 February 0.8 March 1.1 April 1.2 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Year 2 31 33 14 35 QUESTION 1 NQuiz #3 covers the materials for Week 4. Please see the data provided in the Excel file. Use the adjusted seasonal indexes to first deseasonalize the sales data for Year 1 and then use linear regression analysis to forecast (deseasonalized) sales for January, February, March and April of Year 2. Then calculate seasonalized forecasts for these same months. Based on your calculations, please answer the questions below. For each answer round to the nearest integer: e.g., 432.49 => 432; 329.50 => 330 Excel Data Sheet: NQuiz3 3.xlsx 1. What are deseasonalized sales for May of Year 17 2. What are deseasonalized sales for December of Year 17 3. What is the *deseasonalized* sales forecast for February of Year 2? 4. What is the seasonalized sales forecast for March of Year 27 5. What is the deseasonalized sales forecast for April of Year 2? 6. What is the #seasonalized sales forecast for April of Year 2