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

A relatively recent firm has been active for the

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 2015 2016 2017 2018 2019 SUM 9.000 9.000 12.000 24.000 11.000 33.000 14.000 56.000 17.000 85.000 63.000 207.000 4 16 25 5 55 15 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.4, if the forecast for 2018 was 15,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 part c? (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 4500 units in the first quarter (Q1), 2200 units in the second quarter(Q2), 3500 units in the third quarter (Q3). and 2400 units in the fourth quarter(Q4). What are appropriate quarter(seasonal) relatives for this firm's sales? (4 pts)

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!