Q1: Platinum Seating had been had been using an averaging forecasting model. They thought they should try something different for next years forecast. They recognized that sales were increasing and they felt that they could apply a trend analysis for yearly forecasting and then apply a seasonal index by quarter. The following chart represents the sales history over the last 3 years. (The last quarter is the sales forecast as the sales figures are not in yet.) Calculate next years forecast using a trend line of y = 1807 x + 4772; see if you can get that trend line on excel for a bonus of 2 marks. Using the yearly forecast calculate the forecast by quarter using the seasonal index technique. (5 marks) Prepare a forecast for the next year by quarter by product family. Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 1 1450 1240 1000 3000 2 1750 1430 1235 3750 3 2150 1740 1605 4809