B D E F G . 1 j Date MSFT Sales 4/1/2011 7/1/2011 10/1/2011 1/1/2012 4/1/2012 7/1/2012 10/1/2012 1/1/2013 4/1/2013 7/1/2013 10/1/2013 1/1/2014 4/1/2014 7/1/2014 10/1/2014 1/1/2015 4/1/2015 7/1/2015 10/1/2015 1/1/2016 4/1/2016 7/1/2016 10/1/2016 1/1/2017 4/1/2017 7/1/2017 10/1/2017 1/1/2018 4/1/2018 20885 17407 18059 16008 21456 20489 19896 18529 24519 20403 23000 23201 26470 21729 22180 20379 23796 MSFT Income Before Date Extraordinary Items 4/1/2011 7/1/2011 10/1/2011 1/1/2012 4/1/2012 7/1/2012 10/1/2012 1/1/2013 4/1/2013 7/1/2013 10/1/2013 1/1/2014 4/1/2014 7/1/2014 10/1/2014 1/1/2015 4/1/2015 7/1/2015 10/1/2015 1/1/2016 4/1/2016 7/1/2016 10/1/2016 1/1/2017 4/1/2017 7/1/2017 10/1/2017 1/1/2018 4/1/2018 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 20531 20614 21928 25826 23212 25605 24538 28918 26819 30085 29084 32471 Required: 1. What is the Microsoft forecast sales for the 2018 Quarter 3 (using the defaults without last quarter)? O 29.215 O 30.486 O 32.695 O 30.048 2. What is the Microsoft forecast sales for the 2019 quarter 2 (using the defaults without last quarter)? 30.486 32.695 O 33.966 O 30.048 3. By the looks of the graph and breadth of the confidence intervals, which seems harder to predict, sales or income before extraordinary items? O Sales Income before Extraordinary Items 4. What is the Microsoft actual sales for the 2015 quarter 12 O 16.195 O 16.428 O 17,372 O 20.379 5. What is the Microsoft actual sales for the 2015 quarter 3? O 16.195 O 16.428 17.372 O 20.531 B D E F G . 1 j Date MSFT Sales 4/1/2011 7/1/2011 10/1/2011 1/1/2012 4/1/2012 7/1/2012 10/1/2012 1/1/2013 4/1/2013 7/1/2013 10/1/2013 1/1/2014 4/1/2014 7/1/2014 10/1/2014 1/1/2015 4/1/2015 7/1/2015 10/1/2015 1/1/2016 4/1/2016 7/1/2016 10/1/2016 1/1/2017 4/1/2017 7/1/2017 10/1/2017 1/1/2018 4/1/2018 20885 17407 18059 16008 21456 20489 19896 18529 24519 20403 23000 23201 26470 21729 22180 20379 23796 MSFT Income Before Date Extraordinary Items 4/1/2011 7/1/2011 10/1/2011 1/1/2012 4/1/2012 7/1/2012 10/1/2012 1/1/2013 4/1/2013 7/1/2013 10/1/2013 1/1/2014 4/1/2014 7/1/2014 10/1/2014 1/1/2015 4/1/2015 7/1/2015 10/1/2015 1/1/2016 4/1/2016 7/1/2016 10/1/2016 1/1/2017 4/1/2017 7/1/2017 10/1/2017 1/1/2018 4/1/2018 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 20531 20614 21928 25826 23212 25605 24538 28918 26819 30085 29084 32471 Required: 1. What is the Microsoft forecast sales for the 2018 Quarter 3 (using the defaults without last quarter)? O 29.215 O 30.486 O 32.695 O 30.048 2. What is the Microsoft forecast sales for the 2019 quarter 2 (using the defaults without last quarter)? 30.486 32.695 O 33.966 O 30.048 3. By the looks of the graph and breadth of the confidence intervals, which seems harder to predict, sales or income before extraordinary items? O Sales Income before Extraordinary Items 4. What is the Microsoft actual sales for the 2015 quarter 12 O 16.195 O 16.428 O 17,372 O 20.379 5. What is the Microsoft actual sales for the 2015 quarter 3? O 16.195 O 16.428 17.372 O 20.531
