A42 fx A B C D E F G H I J K L M N 0 P Q R S T U V W X Y Z AA AB Question 1 Instructions to the right. Part a) Part b) Part c #1. The Fastgro Fertilizer Company distributes fertilizer to various lawn and garden shops. The company must 3-Qtr 5-Qtr base its quarterly production schedule on a forecast of how many tons of fertilizer will be demanded from it. The Moving Absolute Moving Absolute Linear Absolute company has gathered this data for the past 3 years. HOW VOU A WN Date Quarter # Demand Average Error Error Average Error Error Trend Error Error a) Compute the 3-term (3-quarter) moving average, the error, and the absolute error for 2016 Q4 to 2019 Q1. 2016.Q1 105 2016.Q2 150 b) Compute the 5-term (5-quarter) moving average, the error, and the absolute error for 2017 Q2 to 2019 Q1. 2016.Q3 94 CI A W N 121 c) Compute the linear trend line using a regression model for 2016 Q1 to 2019 Q1. Also compute the error and 2016.Q4 the absolute error. 11 2017.Q1 140 12 2017.Q2 6 170 d) Compare the forecasts developed in parts a), b), and c) using MAD. Which method appears to be the most 13 2017.Q3 7 105 accurate? Do any of the methods exhibit any bias? Show your answers in the spaces below the table. 14 2017.Q4 8 150 15 9 e) Graph the demand data and include the graph below. Can you identify any cycles or seasonal patterns? 2018.Q1 150 16 2018.Q2 10 170 17 2018.Q3 11 110 18 2018.Q4 12 130 19 2019.Q1 13 20 21 Trend Line: 22 Part d) Intercept = 23 Slope = Part e) 24 Can you identify any cycles or seasonal patterns in the demand data? (yes or no) 25 3-term MA MAD = 26 Which method appears to be the most accurate? (3-term MA, 5-term MA, linear) 27 5-term MA MAD = 28 Place graph here: 29 Linear trend line MAD = 30 Do any of the methods exhibit bias? (Yes or No) 31 32 33 34 Note: Only the yellow shaded boxes are autograded. 35 36 37 38 39 40