The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 126.0625 (thousand units). Fill in the missing values assuming there is no trend. Round seasonal indexes to 4 decimal places. Report Averages accurate to at most 2 decimal places. Report Actual sales ('000) accurate to the nearest integer. Year 1 Year 2 Year 3 Year 4 Average Seasonal Index Quarter 1 92 93 95 106 Quarter 2 105 106 105 101 Quarter 3 197 187 196 1.5211 Quarter 4 106 116 121 0.8865 PART B Suppose actual quarterly sales (in thousands) for Year 5 are 93, 123, 206, and 126 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5. Use seasonal indexes (rounded to 4 decimal places) from Part A. Report forecast answers as integers accurate to the nearest thousand. Quarter 1 forecast = thousand Quarter 2 forecast = thousand Quarter 3 forecast = thousand Quarter 4 forecast = thousand Calculate the mean absolute percent error (MAPE) for the four forecasts. Use the integer forecast values you reported above. Report MAPE as percent accurate to 2 decimal places. Do not round intermediate values. MAPE = %
The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 126.0625 (thousand units).
Fill in the missing values assuming there is no trend.
Round seasonal indexes to 4 decimal places.
Report Averages accurate to at most 2 decimal places.
Report Actual sales ('000) accurate to the nearest integer.
Year 1 | Year 2 | Year 3 | Year 4 | Average | Seasonal Index | |
---|---|---|---|---|---|---|
Quarter 1 | 92 | 93 | 95 | 106 | ||
Quarter 2 | 105 | 106 | 105 | 101 | ||
Quarter 3 | 197 | 187 | 196 | 1.5211 | ||
Quarter 4 | 106 | 116 | 121 | 0.8865 |
PART B
Suppose actual quarterly sales (in thousands) for Year 5 are 93, 123, 206, and 126 respectively. Assuming there is no trend,
Use seasonal indexes (rounded to 4 decimal places) from Part A.
Report forecast answers as integers accurate to the nearest thousand.
Quarter 1 forecast = thousand
Quarter 2 forecast = thousand
Quarter 3 forecast = thousand
Quarter 4 forecast = thousand
Calculate the mean absolute percent error (MAPE) for the four forecasts. Use the integer forecast values you reported above. Report MAPE as percent accurate to 2 decimal places. Do not round intermediate values.
MAPE = %
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images