West Virginia Virtuoso Widgets has produced the following numbers of its worsted widgets over the pa
Question: West Virginia Virtuoso Widgets has produced the following numbers of its worsted widgets over the past four and one-half years, with data reported quarterly:
| Year #1 | Q1 | 561 |
| Q2 | 588 | |
| Q3 | 609 | |
| Q4 | 576 | |
| Year #2 | Q1 | 483 |
| Q2 | 507 | |
| Q3 | 615 | |
| Q4 | 567 | |
| Year #3 | Q1 | 429 |
| Q2 | 597 | |
| Q3 | 642 | |
| Q4 | 573 | |
| Year #4 | Q1 | 492 |
| Q2 | 531 | |
| Q3 | 693 | |
| Q4 | 558 | |
| Year #5 | Q1 | 537 |
| Q2 | 585 |
Provide as much quarterly forecasting information about anticipated production levels of worsted widgets as possible, based upon this available data. Determine forecast values using (a) three-quarter centered moving averages, (b) five-quarter centered moving averages, (c) four-quarter centered weighted moving averages, with corresponding weights of 50%, 30%, 15%, and 5%, in reverse chronological order, and (d) exponential smoothing, given a smoothing constant of 40%. Then, compare the accuracy of each forecast by computing the measures (e) MAD, (f) MSE, and (g) MAPE, being sure to identify if any forecasting technique seems most accurate or reasonable based upon these measures. Finally, use seasonal trend analysis to determine the percentage change for the (h) third quarters and (i) fourth quarters from their respective average quarterly production levels for the worsted widgets; to do so, compute all possible four-quarter centered moving averages in order to calculate the corresponding seasonal effects.
Type of Deliverable: Word Document
