Please post excel screenshots (list formulas, if used please)

South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. The following data show quarterly sales revenues (in $'000s) for the past 5 years. Year 1 20 Quarter 1 2 3 4 Year 2 37 136 245 26 100 Year 3 75 155 326 48 Year 4 92 202 384 82 Year 5 176 282 445 3 175 13 181 Question 3 (15 pts) Suppose the company uses exponential smoothing to make forecasts. a. What are the forecasts for periods Q2 Year 1 through Q4 Year 5 assuming alpha = 0.15? Assume forecast for period Q1 Year 1 was 30 units. (5 pts) b. What are the forecasts for periods Q2 Year 1 through Q4 Year 5 assuming alpha = 0.60? Assume forecast for period Q1 Year 1 was 30 units. (5 pts) c. Based on Mean Absolute Percent Error, which of these two values of alpha would you use? (5 pts) South Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. The following data show quarterly sales revenues (in $'000s) for the past 5 years. Year 1 20 Quarter 1 2 3 4 Year 2 37 136 245 26 100 Year 3 75 155 326 48 Year 4 92 202 384 82 Year 5 176 282 445 3 175 13 181 Question 3 (15 pts) Suppose the company uses exponential smoothing to make forecasts. a. What are the forecasts for periods Q2 Year 1 through Q4 Year 5 assuming alpha = 0.15? Assume forecast for period Q1 Year 1 was 30 units. (5 pts) b. What are the forecasts for periods Q2 Year 1 through Q4 Year 5 assuming alpha = 0.60? Assume forecast for period Q1 Year 1 was 30 units. (5 pts) c. Based on Mean Absolute Percent Error, which of these two values of alpha would you use? (5 pts)