PART A The following table shows quarterly sales (in thousand units) for a product over 4...

Transcribed Image Text:

PART A 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 155.5625 (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 Year Seasonal Year 3 Year 4 Average 1 2 Index Quarter 134 147 148 139 1 Quarter 167 187 189 1.1587 2 Quarter 3 137 127 144 0.8823 Quarter 170 149 169 163 4 PART B Suppose actual quarterly sales (in thousands) for Year 5 are 140, 182, 140, and 171 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 % PART A 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 155.5625 (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 Year Seasonal Year 3 Year 4 Average 1 2 Index Quarter 134 147 148 139 1 Quarter 167 187 189 1.1587 2 Quarter 3 137 127 144 0.8823 Quarter 170 149 169 163 4 PART B Suppose actual quarterly sales (in thousands) for Year 5 are 140, 182, 140, and 171 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 %