A pharmaceutical company would like to make an accurate forecast about vitamins sales in 2022. Using sales as the Y variable and time ( year) as the x variable,1.Determine the slope and the intercept...

A pharmaceutical company would like to make an accurate forecast about vitamins sales in 2022.

Using sales as the Y variable and time ( year) as the x variable,
1.Determine the slope and the intercept of the trend equation.

2. Provide a forecast of the sales for the period 2015-2022 using the 3 year moving average method.

3. Compute the accuracy measure MAPE for the naïve and the 3-year moving
average. Conclude about which method to advise.

Extracted text: Ten-year sales data Year Sales ($millions) 2012 7.84 2013 12.26 2014 13.11 2015 15.78 2016 21.29 2017 25.68 2018 23.80 2019 26.43 2020 29.16 2021 33.06 2022