a) Compute the 3-term (3-quarter) moving average, the error, and the absolute error for 2016 Q4 to 2019 Q1.

Autosave OFF Chap15PS S$20 Home Insert Draw Page Layout Formulas Data Review View Shape Format Tell me Share Comments 11 > v AP ab Wron Text Insert Genere LO Pasic v D Delete B 1 U A Merge & Center S Ideas Conditional Format Cell Formatting as Teble Styles Sort & Fille Sensitivity DE! Farmat Find & Select Y T TextBox 1 D E F G H 1 J K L M N 0 P R 5 U V W Part ) Parta) 3 04 Moving Aveva Part b) 5-Qir Moving Average Absaule Error Error Absolute Ero Absolute Error Linear Trend Error Error Derrand 105 150 #1. The Festero Fertilizer Company distributes fertilizer to various lawn and garden shops. The company must base ils quarterly production schedule va a curcast olbow many toas ollectilior will be dccanded Lion itThe company has gathered this data for the past 3 years a) Compute the arm (-quarter) moving avempe, the error, nnd the absolute error for 2016 04 to 2019 01. b) Compate the S-team (5-quarter) moving average, the error, and the absolute are for 2017 02 to 2019 01. c) Compute the linear trend line using a regression model for 2016 QI in 2019 QI. Also compute the error and the absolulu TTCIT. d) Compare the forecasts developed in parts a), b), and c) using cumulative error, MAD and MAPD. Which mctbod appears to be the most accuratci Do any of the mctbods exhibit may bins Slow your answers in the spaces below the table. e) Graph the decand data and include ilue graph below. Can you identify any cycles or seasonal patterns 17 121 140 170 105 10 150 150 170 110 13:1 Trending Intercept Sope A B 1 Question 1 2 Instructions to the right 2 4 5 B Dule Querley 7 2016.01 1 B 2016.02 2 2016.03 3 10 2016.04 4 11 2017.01 5 12 2017.02 6 13 2017.03 7 14 201704 8 15 2018 Q1 9 16 2018 Q2 10 17 2018 Q9 11 . 18 2018 Q4 12 19 2X11901 13 20 21 22 Part ) 23 24 3- MAE 25 26 5 termo MAE 27 28 Linear rendre E- 29 30 31 32 3-lerm MAMMAD 33 34 5-term MA IMAD - 35 36 Liear trend Me MMAD = 37 38 39 40 3- MAMAMD = 41 47 5-tom MA MAM) = 42 44 Linea trand Ano APD = 45 4B 47 Instructions Parte) Can you identify any cycles or secaral patterns in the demand cata? Which method appears to be the most accurate? Du any of the methods exibl bias? (Yes or No) Question1 Question2 Questiona + # 2 110%