Question: 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

2016.2 6 points) b. What is the forecast for June of the

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

2) Use the following infomiation to answer the following questions (25 points) An urban socrologist interested in neighborluiess collected data for a sample of 10 adults on (X) how many years they...

I just want answer for Question 10 Question 2 Use the below budget data to answer questions #2 #104 Mazzei provides the following information about budgeted and actual activities, costs, and revenues...

Please only answer Question 9 Question 2 Use the below budget data to answer questions #2 #104 Mazzei provides the following information about budgeted and actual activities, costs, and revenues from...

The table below shows the effect of changes in various economic variables in the countries of Beckland and Heineken. 00000000000 Beckland | Heineken | For every $18 million change Interest rates...

QUESTION 4 Use the information provided to answer the following questions: 4.1 Calculate the following ratios for 2021. Express answers to two decimal places. 4.1.1 Gross margin (2 marks) 4.1.2...

Can you help me to solve this question? I appreciate your help! Question 1. (Interest Rates and Bond Valuation) Solve the following questions (30 points) (1) Find out values of following bonds. YTM...

Question 1. (Interest Rates and Bond Valuation) Solve the following questions (30 points) (1) Find out values of following bonds. YTM is 7%, and Time to maturity is 10 years (15 points) Bond A: 3.5%...

QUESTION 2 Use the information given below to answer the following questions. Where applicable, express answers to ratios to two decimal places. Will the company be able to fund its short-term...

QUESTION 2 Use the information given below to answer the following questions. Where applicable, express answers to ratios to two decimal places. 2.1 Will the company be able to fund its short-term...

(a) A streamlined high-speed train is 100 m long, 2.5 m wide and has sides 2.5 m high. The train moves at 200 km/hr through air with density 1.23 kg/m and dynamic viscosity 1.77x10$ Pa-s. The total...

Excel has many functions, that can do most of the calculationsyou'll want to use. However, there's one very useful and importantfunction lacking: simple linear interpolation. The easiest way to do...

Which of the following is required for bringing criminal action against fraud perpetrators?

Find the radius of gyration of a plate covering the region bounded by x=3, x=5, y=0, and y=4 with respect to the y-axis.

The Social Justice case for D&I has been argued in strategic human resource management literature as having longer term impact in building an inclusive culture, as opposed to the Business Case,...

As stated in the case, Therese strongly believes that the changes she was seeking for women in the workplace, were the dual responsibility of organizations and women themselves. Critically evaluate...

1-2 What is an information system? How does it work? What are its management, organization, and technology components? Why are complementary assets essential for ensuring that information systems...