Question: THE QUESTION: Do a multiplicative forecasting model (combining trend and seasonal components) to estimate sales for the Buzbey restaurant from 2018 to 2020. (36 marks)
THE QUESTION:
Do a multiplicative forecasting model (combining trend and seasonal components) to estimate sales for the Buzbey restaurant from 2018 to 2020. (36 marks)
Mrs Azola Nkota has the following data (R1000s) on total food and beverage sales for the three years of operation: Month 2018 2019 2020 243 235 232 282 255 265 January February March April May June July August September October November December 178 184 140 145 152 110 130 152 256 263 238 247 193 193 149 157 161 122 130 167 230 205 210 260 266 174 126 148 173 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 includesStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
