The Bechtal Tire Company (BTC) is a supplier of automotive tires for U.S. car companies. BTC has…

The Bechtal Tire Company (BTC) is a supplier of automotive tires for U.S. car companies. BTC has hired you to analyze its sales. Data from 1976Q1 through 2007Q4 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. Show the raw data, the deseasonalized data, and the long-term trend on one time-series plot. Also provide a plot of the cycle factor with a projection through 2008.

b. In the last section of your report, show a time-series graph with the actual data and the values that the time-series decomposition model would predict for each quarter from 1986Q3 through 2007Q4, along with a forecast for 2008. If actual sales for 2008 were Q1 1,445.1, Q2 1,683.8, Q3 1,586.6, and Q4 1,421.3, what RMSE would result from your 2008 forecast?

 

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Order Over WhatsApp Place an Order Online

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Similar Paper