a) Create 2019 and 2020 forecasts using a 4-month weighted moving average where the weight of the most recent month is 50%, followed by 20% for the two months before that, and 10% for the latest month. Transfer the forecast values to the appropriate table above. (5) b) Create 2019 and 2020 forecasts using exponential smoothing with a smoothing constant of 0.65. Transfer the forecast values to the appropriate table above. (5) c) Develop 2019 and 2020 forecast formulas using liner regression. What are the formulas? (Round variable coefficients to 2 decimal places.) (4) d) Use the formulas created in part (c) to generate the linear trend line forecasts and transfer the forecast values generated using the formulas to the appropriate table above. (4) e) Calculate the MAPD for each of the forecasts resulting from the answers to parts (a), (b), and (d). Transfer the answers to the correct cells above. Round each percentage to 2 decimal places. (4) f) Based on the results of (e), which forecast is the most accurate for 2019 and 2020, respectively? (4) g) Which year did the forecasts best represent? Explain your answer. (4)