11. The Bechtal Tire Company (BTC) is a supplier of automotive tires for U.S. car companies. BTC has hired you to analyze its sales. For this problem, do all the work in ForecastXTM and be sure to request the MAPE in the statistics tab. Data from 199501 through 2016Q4 are given in the following table (in thousands of units):

a. Write a report to Bechtal Tire Company in which you explain what a time-series decomposition analysis shows about its tire sales. Include in your discussion seasonal, cyclical, and trend components.

b. Show a time-series graph with the actual data and the values that the time-series decomposition model would predict for each quarter from 1995Q1 through 201704 (some data will be missing for certain historical quarters, and, of course for 2017, you will have only the forecast values).

c. If actual sales for 2017 were Q1 = 1,445.1, Q2 = 1,683.8, Q3 = 1,586.6, and Q4 = 1,421.3, what MAPE would result from your 2017 forecast? How does this MAPE compare to the MAPE ForecatsXTM calculated for the historic period?