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
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 131.875 (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 71 67 67 72 69.25 0.5251 1 Quarter 194 187 210 200 197.75 1.4995 2 Quarter 188 179 184 186 184.26 1.3972 3 Quarter 79 76 80 70 76.25 0.5782 4PART B Suppose actual quarterly sales (in thousands) for Year 5 are 52, 199, 202, and 84 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 = 27.3062 x thousand Quarter 2 forecast = 298 4005 x thousand Quarter 3 forecast = 282 2344 x thousand Quarter 4 forecast = |48.5672 x 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 = 44.84 * %
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance