Assume that the data in columns A and B report the new constructions of residential homes, per month, in thousands, from 2015 to 2020 in the state of Oregon. a) Chart the data. Discuss any apparent trend and seasonal patterns. b) Use the "Tahoe Salt" method with linear trend to forecast new constructions for the 12 months of 2021. c) Add your model values and forecast to the data chart. d) Compute the MAD of your model. e) Compute and plot the tracking signal in a new chart. f) Discuss the quality of this model. What is the flagrant flaw? g) Suggest an approach that would yield better results in terms of forecast values, MAD, and tracking signal. An appropriate narrative argument is sufficient (i.e., one or two sentences). You do not need to do calculations for this part.
Assume that the data in columns A and B report the new constructions of residential homes, per month, in thousands, from 2015 to 2020 in the state of Oregon.
a) Chart the data. Discuss any apparent trend and seasonal patterns.
b) Use the "Tahoe Salt" method with linear trend to
c) Add your model values and forecast to the data chart.
d) Compute the MAD of your model.
e) Compute and plot the tracking signal in a new chart.
f) Discuss the quality of this model. What is the flagrant flaw?
g) Suggest an approach that would yield better results in terms of forecast values, MAD, and tracking signal. An appropriate narrative argument is sufficient (i.e., one or two sentences). You do not need to do calculations for this part.
![44 Jul-2018
44
45 Aug-2018
46 Sep-2018
48
45
47 Oct-2018
44
48 Nov-2018
40
49 Dec-2018
37
50 Jan-2019
45
51 Feb-2019
49
52 Mar-2019
62
53 Apr-2019
54 May-2019
62
58
55 Jun-2019
59
56 Jul-2019
64
57 Aug-2019
58 Sep-2019
62
50
59 Oct-2019
52
60 Nov-2019
50
61 Dec-2019
44
62 Jan-2020
51
63 Feb-2020
56
64 Mar-2020
60
65 Apr-2020
66 May-2020
65
64
67 Jun-2020
63
68 Jul-2020
63
69 Aug-2020
70 Sep-2020
72
61
71 Oct-2020
65
72 Nov-2020
51
73 Dec-2020
47](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F04f05893-d429-4fa8-9df3-cdeeb9f5dbe8%2F96dbd484-9ca6-4b9e-afd8-0f1a14c7763b%2Fqikkoub_processed.png&w=3840&q=75)
![A
B
New constructions
Month
1
(thousands)
2
Jan-2015
29
Feb-2015
32
4
Mar-2015
41
5 Apr-2015
6 May-2015
44
49
7
Jun-2015
47
Jul-2015
46
9 Aug-2015
10 Sep-2015
11 Oct-2015
47
43
45
12 Nov-2015
34
13 Dec-2015
31
14 Jan-2016
35
Feb-2016
43
16 Mar-2016
46
17 Apr-2016
18 May-2016
46
43
19 Jun-2016
41
20 Jul-2016
44
21 Aug-2016
22 Sep-2016
47
41
23 Oct-2016
40
24 Nov-2016
32
25 Dec-2016
32
26 Jan-2017
34
27 Feb-2017
40
28 Mar-2017
43
29 Apr-2017
30 May-2017
42
43
31 Jun-2017
44
32 Jul-2017
39
33 Aug-2017
34 Sep-2017
40
33
35 Oct-2017
32
36 Nov-2017
31
37 Dec-2017
28
38 Jan-2018
34
39 Feb-2018
29
40 Mar-2018
36
41 Apr-2018
42 May-2018
42
43
43 Jun-2018
44](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F04f05893-d429-4fa8-9df3-cdeeb9f5dbe8%2F96dbd484-9ca6-4b9e-afd8-0f1a14c7763b%2Fc99guh_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)