Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2: Use the Sales 2 data to answer following questions (15 points). a. What is the forecast for January of the year 2016.2 6
Question 2: Use the Sales 2 data to answer following questions (15 points). a. What is the forecast for January of the year 2016.2 6 points) b. What is the forecast for June of the year 2020 (6 points) C. Comment on the appropriateness of this forecasting method (Explain). (3 points) F8 Jx D E F Clipb C 1 Monthly sales data 2 3 Month Sales 1 Sales 2 4 5 Jan-16 2568 3824 6 Feb-16 2580 3728 7 Mar-16 2606 4242 8 Apr-16 2639 4171 9 May-16 2674 4336 10 Jun-16 2699 4804 11 Jul-16 2728 4654 12 Aug-16 2741 4751 13 Sep-16 2770 4316 14 Oct-16 2808 4442 15 Nov-16 2832 3966 16 Dec-16 2861 3906 17 Jan-17 2901 3989 18 Feb-17 2932 4009 19 Mar-17 2958 4554 20 Apr-17 2974 21 May-17 3008 4569 22 Jun-17 3027 5007 23 Jul-17 3044 5271 24 Aug-17 3071 5088 25 Sep-17 3098 4667 26 Oct-17 3108 4780 27 Nov-17 3134 4218 28 Dec-17 3168 4133 29 Jan-18 3186 4133 30 Feb-18 3221 4170 31 Mar-18 3256 4942 32 Apr-18 3295 4938 23 May-18 3322 4878 Case-Data 4643 PAGE 1 OF 1 READY F8 XVfx B D E Clipbe A 33 May-18 34 Jun-18 35 Jul-18 36 Aug-18 37 Sep-18 38 Oct-18 39 Nov-18 40 Dec-18 41 Jan-19 42 Feb-19 43 Mar-19 44 Apr-19 45 May-19 46 Jun-19 47 Jul-19 48 Aug-19 49 Sep-19 50 Oct-19 51 Nov-19 52 Dec-19 53 Jan-20 54 Feb-20 55 Mar-20 56 Apr-20 57 May-20 58 Jun-20 59 Jul-20 60 Aug-20 61 Sep-20 62 Oct-20 63 Nov-20 Dec-20 BE 3322 3343 3368 3407 3426 3455 3483 3509 3538 3582 3600 3652 3686 3722 3747 3770 3811 3828 3862 3896 4878 5760 5416 5661 5037 5025 4390 4459 4413 4405 5149 5268 5332 5927 6088 6085 5285 5523 4635 4694 Question 2: Use the Sales 2 data to answer following questions (15 points). a. What is the forecast for January of the year 2016.2 6 points) b. What is the forecast for June of the year 2020 (6 points) C. Comment on the appropriateness of this forecasting method (Explain). (3 points) F8 Jx D E F Clipb C 1 Monthly sales data 2 3 Month Sales 1 Sales 2 4 5 Jan-16 2568 3824 6 Feb-16 2580 3728 7 Mar-16 2606 4242 8 Apr-16 2639 4171 9 May-16 2674 4336 10 Jun-16 2699 4804 11 Jul-16 2728 4654 12 Aug-16 2741 4751 13 Sep-16 2770 4316 14 Oct-16 2808 4442 15 Nov-16 2832 3966 16 Dec-16 2861 3906 17 Jan-17 2901 3989 18 Feb-17 2932 4009 19 Mar-17 2958 4554 20 Apr-17 2974 21 May-17 3008 4569 22 Jun-17 3027 5007 23 Jul-17 3044 5271 24 Aug-17 3071 5088 25 Sep-17 3098 4667 26 Oct-17 3108 4780 27 Nov-17 3134 4218 28 Dec-17 3168 4133 29 Jan-18 3186 4133 30 Feb-18 3221 4170 31 Mar-18 3256 4942 32 Apr-18 3295 4938 23 May-18 3322 4878 Case-Data 4643 PAGE 1 OF 1 READY F8 XVfx B D E Clipbe A 33 May-18 34 Jun-18 35 Jul-18 36 Aug-18 37 Sep-18 38 Oct-18 39 Nov-18 40 Dec-18 41 Jan-19 42 Feb-19 43 Mar-19 44 Apr-19 45 May-19 46 Jun-19 47 Jul-19 48 Aug-19 49 Sep-19 50 Oct-19 51 Nov-19 52 Dec-19 53 Jan-20 54 Feb-20 55 Mar-20 56 Apr-20 57 May-20 58 Jun-20 59 Jul-20 60 Aug-20 61 Sep-20 62 Oct-20 63 Nov-20 Dec-20 BE 3322 3343 3368 3407 3426 3455 3483 3509 3538 3582 3600 3652 3686 3722 3747 3770 3811 3828 3862 3896 4878 5760 5416 5661 5037 5025 4390 4459 4413 4405 5149 5268 5332 5927 6088 6085 5285 5523 4635 4694
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started