Please answer all parts as they are all part of Question 1. Thanks!

1. (6 points) You are given the following time series data for cotton. Calculate the 3-year moving averages in the table below (Round to the nearest ten thousandth or 4 decimal places) then answer the following questions. Year $ 3-Year Moving Average $/b Difference from Year Prior $/b $0.00 $0.09 2010 $0.846 2011 $0.935 $0.757 2012 ($0.18) $0.08 2013 $0.838 2014 $0.657 $0.645 ($0.18) ($0.01) 2015 2016 $0.06 $0.705 $0.719 2017 $0.01 2018 $0.723 $0.00 2019 $0.623 ($0.10) 2020 $0.550 ($0.07) 1b. Use basic extrapolation techniques to calculate the trend increase or decrease in s/lk per year over this one.Rediod (Round to four decimal places)? DO NOT USE EXCEL TRENDLINES TO MAKE THIS CALCULATION 1. Forecast the $/lb for 2021 using the trend you calculated and the extrapolation method (Round to four decimal places 2021 1d. Given the average price for cotton so far in 2021 has been above $0.80/tk explain why the extrapolation metho of forecasting is not recommended for use in strategic marketing plans. 1. (6 points) You are given the following time series data for cotton. Calculate the 3-year moving averages in the table below (Round to the nearest ten thousandth or 4 decimal places) then answer the following questions. Year $ 3-Year Moving Average $/b Difference from Year Prior $/b $0.00 $0.09 2010 $0.846 2011 $0.935 $0.757 2012 ($0.18) $0.08 2013 $0.838 2014 $0.657 $0.645 ($0.18) ($0.01) 2015 2016 $0.06 $0.705 $0.719 2017 $0.01 2018 $0.723 $0.00 2019 $0.623 ($0.10) 2020 $0.550 ($0.07) 1b. Use basic extrapolation techniques to calculate the trend increase or decrease in s/lk per year over this one.Rediod (Round to four decimal places)? DO NOT USE EXCEL TRENDLINES TO MAKE THIS CALCULATION 1. Forecast the $/lb for 2021 using the trend you calculated and the extrapolation method (Round to four decimal places 2021 1d. Given the average price for cotton so far in 2021 has been above $0.80/tk explain why the extrapolation metho of forecasting is not recommended for use in strategic marketing plans