Sales of roof material, by quarter, since 2005 for Carolina HomeConstruction Inc. are shown below (in $ thousands).
| Quarter |
| |
| Year | I | II | III | IV |
| 2004 | 210 | 180 | | 60 | | 246 |
| 2005 | 214 | 216 | | 82 | | 230 |
| 2006 | 246 | 228 | | 91 | | 280 |
| 2007 | 258 | 250 | | 113 | | 298 |
| 2008 | 279 | 267 | | 116 | | 304 |
| 2009 | 302 | 290 | | 114 | | 310 |
| 2010 | 321 | 291 | | 120 | | 320 |
1. Determine the typical seasonal patterns for sales using theratio-to-moving-average method. (PLEASE DONOT USE EXCEL. PLEASESHOW ALL MANUAL WORKINGS HOW DID YOU GET ANSWER IN THE TABLE)
2. Deseasonalize the data and determine the trend equation.PLEASE DONOT USE EXCEL. PLEASE SHOW ALL MANUAL WORKINGS HOW DID YOUGET ANSWER IN THE TABLE)
3. Project the sales for 2012, and then seasonally adjust eachquarter.
