Question: Question 1 A relatively recent firm has been active for the last five years and now wants to forecasts for the current year 2021, based

Question 1 A relatively recent firm has been active for the last five years and now wants to forecasts for the current year 2021, based on the following historical data YEAR t Sales y 2016 1 15.000 15.000 1 2017 2 16.000 32.000 4 2018 3 18.000 54.000 9 2019 4 20.000 80.000 16 2020 5 21.000 105.000 25 SUM 15 90.000 286.000 55 a. What is the forecast for this year, 2021, using a tour year simple moving average? (4 pts) b. What is the forecast for this year using exponential smoothing with alpha=0.5, the forecast for 2019 w 19 was 15,00074 pts) c. What is the least squares trend equation that shows the best relationship between demand and year? (4 ptx) d. What is the forecast for this year, 2021, using the least squares trendline you found in parte? (2 pts) A B 7

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!

Not yet answered Marked out of 14.00 Question 1 A relatively recent firm has been active for the last five based on the following historical data: YEAR t Sales-y t*y t 2 2016 2017 2018 2019 2020 SUM...

Qul navigation Question 5 160 Flag question A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year. 2020, based on the following...

urgent RODO TE ODO Te.S0.00 SLIM O 717.000 .. What is the forecast for this year, 2020, si a four year simple moving average pts) What is the forecast for this year using exponential smoothing with...

WEBCAM RECORD A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2021. based on the following historical data YEAR Sales- ty...

A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2021, based on the following historical data: YEAR t Sales-y 1*y 2016...

remember: using a (three) year average A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2021, based on the following...

A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2021, based on the following historical data: YEAR 9.000 t Sales y ty 1...

Question 5 Not yet answered Marked out of 160 Flag question A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2020, based...

Sales (y) YEAR t ty 1 2015 2016 2 3 2017 9.000 9.000 12.000 24.000 11.000 33.000 14.000 56.000 17.000 85.000 63.000 207.000 2018 4 4 9 16 25 55 2019 5 SUM 15 Question 5 Marted out of 16.0 P Flag...

A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current year, 2020, based on the following historical data: YEAR t Sales (y) t*y t? 1 1...

ons Dogs 4U Supplies Inc. is a popular chain of stores in the region and its finance department has asked for your help. The firm has provided the information shown below. Rounding to the nearest...

Two scores, X and Y, are recorded for each of n = 4 subjects. For these scores, find the value of each expression. r4752 X3011 2 bje A B C D ab c

b . Which of the following is an example of this type of cost ? A . materials used in production B . rent for a store or warehouse C . wages D . utilities

What is an example of constructive feedback? provide reference