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

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 historical data: NEM YEAR t Sales ty! t? 1 2 2015 2016 2017 2018 2019 SUM 4 5 15 15.000 16.000 18.000 20.000 21.000 90.000 15.000 32.000 54.000 80.000 105.000 286.000 1 4 9 16 25 55 a. What is the forecast for this year, 2020, using a four-year simple moving average? (2 pts) b. What is the forecast for this year using exponential smoothing with alpha -0.5, if the forecast for 2018 was 19,000? (4 pts) c. What is the least squares regression equation that shows the best relationship between demand and year? (4 pts) d. What is the forecast for this year using the least squares trend line you found in parte? (2 pts) e. In fact, within a year, demand changes over four quarters of a year. Over the past five years, the firm's sales have averaged 5500 units in the first quarter (Q1), 3000 units in the second quarter(Q2). 6000 units in the third quarter (Q3). and 3500 units in the fourth quarter(Q4). What are appropriate quarter(seasonal) relatives for this firm's sales? (4 pts) A B / II MacBook Pro 8: 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 historical data: NEM YEAR t Sales ty! t? 1 2 2015 2016 2017 2018 2019 SUM 4 5 15 15.000 16.000 18.000 20.000 21.000 90.000 15.000 32.000 54.000 80.000 105.000 286.000 1 4 9 16 25 55 a. What is the forecast for this year, 2020, using a four-year simple moving average? (2 pts) b. What is the forecast for this year using exponential smoothing with alpha -0.5, if the forecast for 2018 was 19,000? (4 pts) c. What is the least squares regression equation that shows the best relationship between demand and year? (4 pts) d. What is the forecast for this year using the least squares trend line you found in parte? (2 pts) e. In fact, within a year, demand changes over four quarters of a year. Over the past five years, the firm's sales have averaged 5500 units in the first quarter (Q1), 3000 units in the second quarter(Q2). 6000 units in the third quarter (Q3). and 3500 units in the fourth quarter(Q4). What are appropriate quarter(seasonal) relatives for this firm's sales? (4 pts) A B / II MacBook Pro 8

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

please explain fully Questions Not yet answered Marked out of 16.0 p Hay que A relatively recent firm has been active for the last five years and now wants to forecast annual sales for the current...

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: Sales YEAR t 1 1 4 2 9 3...

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

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

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: Sales YEAR t (y) t*y t? 1...

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) t2 2015...

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

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

A company had the following transactions during the month of January: Sales revenue of $10,000 Cost of goods sold of $6,000 Rent expense of $1,500 Salaries expense of $2,000 Depreciation expense of...

Consider the following economic events. a. Political turmoil in the Middle East causes oil prices to skyrocket, acting as a negative supply shock on the US economy. This negative supply shock makes...

1. Create a Visual Basic Windows application. Use the following names for the solution and project, respectively: Warren Solution and Warren Project. Save the application in the VB2015\Chap01 folder....

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...