Month 2019 2020 2021 January 243 263 282 February 235 238 255 March 232 247 265 April 178 193 205 May 184 193 210 June 140 149 260 July 145 157 266 August 152 161 174 September 110 122 126 October 130 130 148 November 152 167 173 December 256 230 235 4. Managerial report Use Microsoft Excel to perform an analysis of the sales data for the Buzbey restaurant. Prepare a report for Mrs Azola Nkota that includes: a) A graph of the time series to represent sales for Buzbey Restaurant. Comment. (5 marks) b) A least-square regression method to derive a forecasting equation for the Buzbey restaurant's sales. (10 marks) c) An analysis of the seasonality of the data. Indicate the seasonal indexes for each month, and comment on the high and low seasonal sales months. (30 marks) d) A multiplicative forecasting model (combining trend and seasonal components) to estimate sales for the Buzbey restaurant from 2019 to 2021. e) A forecasting % error using MAPE. f) A seasonally adjusted forecast for 2022. (36 marks) (7 marks) (12 marks)