Question: Question 2: Use the Sales 2 data to answer the following questions (20 points). Decide which forecasting method best fits the given data and explain

Question 2: Use the Sales 2 data to answer the following questions (20 points).

  1. Decide which forecasting method best fits the given data and explain why. (8 points).
  2. What is the forecast for January of the year 2021? (6 points)
  3. What is the forecast for June of the year 2021 (6 points)
Month Sales 1 Sales 2
Jan-17 2568 3824
Feb-17 2580 3728
Mar-17 2606 4242
Apr-17 2639 4171
May-17 2674 4336
Jun-17 2699 4804
Jul-17 2728 4654
Aug-17 2741 4751
Sep-17 2770 4316
Oct-17 2808 4442
Nov-17 2832 3966
Dec-17 2861 3906
Jan-18 2901 3989
Feb-18 2932 4009
Mar-18 2958 4554
Apr-18 2974 4643
May-18 3008 4569
Jun-18 3027 5007
Jul-18 3044 5271
Aug-18 3071 5088
Sep-18 3098 4667
Oct-18 3108 4780
Nov-18 3134 4218
Dec-18 3168 4133
Jan-19 3186 4133
Feb-19 3221 4170
Mar-19 3256 4942
Apr-19 3295 4938
May-19 3322 4878
Jun-19 3343 5760
Jul-19 3368 5416
Aug-19 3407 5661
Sep-19 3426 5037
Oct-19 3455 5025
Nov-19 3483 4390
Dec-19 3509 4459
Jan-20 3538 4413
Feb-20 3582 4405
Mar-20 3600 5149
Apr-20 3652 5268
May-20 3686 5332
Jun-20 3722 5927
Jul-20 3747 6088
Aug-20 3770 6085
Sep-20 3811 5285
Oct-20 3828 5523
Nov-20 3862 4635
Dec-20 3896 4694
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21

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 General Management Questions!

Q:

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...

Q:

Please answer/show work for parts D and E for this question. ( Calculate down to the third decimal points) This was the only information that was provided to solve the problem. The Monthly-Sales data...

Q:

Use data below to create a file with monthly data from January 2015 to December 2017 for Hansen Company. The first variable is Time. The second variable, Sales 1, has data on sales of a product 1....

Q:

There is a case question (very last question) in the document below and i would like to know how to resolve it properly University of Toronto Faculty of Arts and Science and Rotman School of...

Q:

Key Success Factors and Current Industry Prospects: Key Success Factors Key success factors (KSFs) are the competitive factors in the marketplace that affect an industry member's ability to survive...

Q:

5. Firm ABC is expecting a significant growth in revenue in the next few years. Before conducting a financial forecast, Firm ABC would like to analyze its internal growth rate and external funding...

Q:

Background Your company has been granted an exclusive license to sell ice cream in Odiorne Point State Park, NH. No one has ever sold ice cream here before, so you have no idea what the demand will...

Q:

Investment Clues From the Past ASSET 20 YEARS RETURN RANK 10 YEARS RETURN RANK 5 YEARS RETURN RANK 1 YEAR RETURN RANK Stocks 12.2% 1 14.8% 1 15.1% 1 11.6% 2 Bonds 9.8 2 13.2 2 13.1 2 14.8 1 Stamps...

Q:

Based on your knowledge of the Quantity Theory of Money and the Equation of Exchange, answer the following questions. (20 points) Assume the Bank of Canada has been instructed by the government to...

Q:

please provide all work! Thanks b. On June 1, 2021 XYZ purchased a year fire insurance policy from HIJ Company for $18,000. (10 points) Copy the entire question (1, 2 and 3) along with the tables...

Q:

Explain two contingency plans that PU could undertake to prepare for the possibility of a similar accident happening. (Unit 5) (6 marks) Contingency plans are actions that PU can undertake to respond...

Q:

The following tentative auditor's report was drafted by a staff accountant and submitted to a partner in the accounting firm of Better & Best, CPAs: AUDIT REPORT To the Audit Committee of American...

Q:

5 0 . Larry borrowed shares in Good Humor Ice Cream Co . from Moe and sold them to Curly Joe. During this time, Good Humor declared a dividend. Who pays the dividend to whom? I Good Humor pays to...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...