Data on demand over the last few years are available as follows: What are this and next year's forecasts using the linear trend forecast for these data?

Write down the linear trend equation and the final answer in the text box below.

Submit an Excel file to indicate your calculation and final answers.

-

Linear Trend Equation:

This year forecast:

Next year forecast:

Data on demand over the last few years are available as follows: What is this year's forecast using a four-year simple moving average?

Write down the final answer in the text box below and submit an Excel file to indicate the calculation and the final answer.

What is this year's forecast using exponential smoothing with alpha = .25, if last year's smoothed forecast was 45?

Write down your final answer in the text box below. Submit an Excel file to indicate your calculation and the final answer.