JX C D E 1 Date MSFT Sales 2 7/1/09 3 10/1/09 1/1/10 4/1/10 7/1/10 10/1/10 8 1/1/11 9 4/1/11 10 7/1/11 11 10/1/11 12 1/1/12 13 4/1/12 14 7/1/12 15 10/1/12 16 1/1/13 17 4/1/13 18 7/1/13 19 10/1/13 20 1/1/14 21 4/1/14 22 7/1/14 23 10/1/14 24 1/1/15 25 4/1/15 26 7/1/15 27 10/1/15 28 1/1/16 29 4/1/16 30 7/1/16 31 10/1/16 32 1/3/17 33 4/1/17 34 7/1/17 35 10/1/17 36 1/1/18 37 4/1/18 38 39 40 41 14503 16039 16195 19953 16428 17367 17372 20885 17407 18059 16008 21456 20489 19896 18529 24519 20403 23000 23201 26470 21729 22180 20379 23796 20531 20614 21928 25826 23212 25605 24538 28918 26819 30085 29084 32471 MSFT Income Before Date Extraordinary Items 7/1/09 10/1/09 1/1/10 4/1/10 7/1/10 10/1/10 1/1/11 4/1/11 7/1/11 10/1/11 1/1/12 4/1/12 7/1/12 10/1/12 1/1/13 4/1/13 7/1/13 10/1/13 1/1/14 4/1/14 7/1/14 10/1/14 1/1/15 4/1/15 7/1/15 10/1/15 1/1/16 4/1/16 7/1/16 10/1/16 1/1/17 4/1/17 7/1/17 10/1/17 1/1/18 4/1/18 4006 4518 5410 6634 5232 5874 5738 6624 5108 492 4466 6377 6055 4965 5244 6558 5660 4612 4540 5863 4985 -3195 4902 5018 3756 3122 5667 6267 5486 8069 6576 -6302 7424 8873 8824 8420 Required: 1. What is the Microsoft forecast sales for the 2018 Quarter 3 (using the defaults without last quarter? 30,486 32,695 29.215 30,048 2. What is the Microsoft forecast sales for the 2019 quarter 2 (using the defaults without last quarter? 33,966 32,695 30.048 30,400 3. By the looks of the graph and breadth of the confidence intervals, which come harder to predict, sales or income bofore extraordinary Items? Income before Extraordinary Items Sales Income before Extraordinary items Sales 4. What is the Microsoft actual sales for the 2015 quarter 17 16,428 17,372 16,195 20.379 5. What is the Microsoft actual sales for the 2015 quarter 3? 17,372 20,531 16,195 16,428 JX C D E 1 Date MSFT Sales 2 7/1/09 3 10/1/09 1/1/10 4/1/10 7/1/10 10/1/10 8 1/1/11 9 4/1/11 10 7/1/11 11 10/1/11 12 1/1/12 13 4/1/12 14 7/1/12 15 10/1/12 16 1/1/13 17 4/1/13 18 7/1/13 19 10/1/13 20 1/1/14 21 4/1/14 22 7/1/14 23 10/1/14 24 1/1/15 25 4/1/15 26 7/1/15 27 10/1/15 28 1/1/16 29 4/1/16 30 7/1/16 31 10/1/16 32 1/3/17 33 4/1/17 34 7/1/17 35 10/1/17 36 1/1/18 37 4/1/18 38 39 40 41 14503 16039 16195 19953 16428 17367 17372 20885 17407 18059 16008 21456 20489 19896 18529 24519 20403 23000 23201 26470 21729 22180 20379 23796 20531 20614 21928 25826 23212 25605 24538 28918 26819 30085 29084 32471 MSFT Income Before Date Extraordinary Items 7/1/09 10/1/09 1/1/10 4/1/10 7/1/10 10/1/10 1/1/11 4/1/11 7/1/11 10/1/11 1/1/12 4/1/12 7/1/12 10/1/12 1/1/13 4/1/13 7/1/13 10/1/13 1/1/14 4/1/14 7/1/14 10/1/14 1/1/15 4/1/15 7/1/15 10/1/15 1/1/16 4/1/16 7/1/16 10/1/16 1/1/17 4/1/17 7/1/17 10/1/17 1/1/18 4/1/18 4006 4518 5410 6634 5232 5874 5738 6624 5108 492 4466 6377 6055 4965 5244 6558 5660 4612 4540 5863 4985 -3195 4902 5018 3756 3122 5667 6267 5486 8069 6576 -6302 7424 8873 8824 8420 Required: 1. What is the Microsoft forecast sales for the 2018 Quarter 3 (using the defaults without last quarter? 30,486 32,695 29.215 30,048 2. What is the Microsoft forecast sales for the 2019 quarter 2 (using the defaults without last quarter? 33,966 32,695 30.048 30,400 3. By the looks of the graph and breadth of the confidence intervals, which come harder to predict, sales or income bofore extraordinary Items? Income before Extraordinary Items Sales Income before Extraordinary items Sales 4. What is the Microsoft actual sales for the 2015 quarter 17 16,428 17,372 16,195 20.379 5. What is the Microsoft actual sales for the 2015 quarter 3? 17,372 20,531 16,195 16,428