Small Wonder, an amusement park, experiences seasoned attendance. It has collected two years of quarterly attendance data and made a forecast of annual attendance for the upcoming year. Compute the seasonal indexes for the four quarters and generate quarterly forecasts for the coming year, assuming annual attendance for the coming year to be 1525.
Quarter Park Attendance Year 1 Park Attendance Year 2
Fall 352 391
Winter 156 212
Spring 489 518
Summer 314 352
This solution is comprised of detailed step-by-step calculation of the given problem in EXCEL and provides students with a clear perspective of the underlying concepts.