In: Advanced Math
Sales of roof material, by quarter, since 2005 for Carolina Home Construction 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 the ratio-to-moving-average method. (PLEASE DONOT USE EXCEL. PLEASE SHOW 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 YOU GET ANSWER IN THE TABLE)
3. Project the sales for 2012, and then seasonally adjust each quarter.