Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Question 2 The Singapore Furniture Association has engaged your team service as there is an on-going sentiment within the board that the business for furniture

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Question 2 The Singapore Furniture Association has engaged your team service as there is an on-going sentiment within the board that the business for furniture retailers in Singapore is declining due to the increasingly preferred way of shopping for furniture directly from overseas via online shopping platforms such as Taobao, Lazada and Shopee, where consumers can ship their furniture directly from China. Your team has been engaged to provide insights based on data. Your team is provided with the retail sales(index (RSI) that the association tracks regularly. Please refer to the Excel file GBA Q2_Input File. (a) Using an appropriate forecasting method, forecast the RSI from October 2021 to June 2022. You are required to provide comments on the data, justification for the method used and the essential steps in the forecasting process. (25 marks) (b) Examine on your results in Question 2(a), provide the management a summary of the insight and highlight any concerns in your forecasting approach. (35 marks) Note: Do provide proper and adequate in-text citations and referencing to content drawn from course materials and other credible sources. A1 B Retail Sales Index (RSI) 54.5 44.1 43.8 42.7 48.5 40.9 A 1 Year Month lindustry 2 1989-1 Furniture & Household Equipment 3 1989-2 Furniture & Household Equipment 4 1989-3 Furniture & Household Equipment 5 1989-4 Furniture & Household Equipment 6 1989-5 Furniture & Household Equipment 7 1989-6 Furniture & Household Equipment 8 1989-7 Furniture & Household Equipment 9 1989-8 Furniture & Household Equipment 70 1989-9 Furniture & Household Equipment 11 1989-10 Furniture & Household Equipment 12 1989-11 Furniture & Household Equipment 13 1989-12 Furniture & Household Equipment 14 1990-1 Furniture & Household Equipment 15 1990-2 Furniture & Household Equipment 16 1990-3 Furniture & Household Equipment 17 1990-4 Furniture & Household Equipment 18 1990-5 Furniture & Household Equipment 19 1990-6 Furniture & Household Equipment 20 1990-7 Furniture & Household Equipment 21 1990-8 Furniture & Household Equipment 22 1990-9 Furniture & Household Equipment 23 1990-10 Furniture & Household Equipment 24 1990-11 Furniture & Household Equipment 25 1990-12 Furniture & Household Equipment 26 1991-1 Furniture & Household Equipment 27 1991-2 Furniture & Household Equipment 28 1991-3 Furniture & Household Equipment 29 1991-4 Furniture & Household Equipment 30 1991-5 Furniture & Household Equipment 31 1991-6 Furniture & Household Equipment 32 1991-7 Furniture & Household Equipment 33 1991-8 Furniture & Household Equipment 34 1991-9 Furniture & Household Equipment 35 1991-10 Furniture & Household Equipment 36 1991-11 Furniture & Household Equipment 37 1991.12 Furniture & Household Equipment 38 1992-1 Furniture & Household Equipment 39 1992-2 Furniture & Household Equipment 40 1992 3 Furniture & Household Equipment 41 1992-4 Furniture & Household Equipment 42 1992-5 Furniture & Household Equipment 43 1992-6 Furniture & Household Equipment 44 1992-7 Furniture & Household Equipment 45 1992-8 Furniture & Household Equipment Sheet1 36.9 33.8 35.2 33.9 37.3 45.7 43.4 36.1 35.1 30.2 34.1 35.1 32.6 25 29 34.4 29.2 36 35.9 33.8 36.1 33.3 35.7 38.9 35.2 37.2 34.5 36.8 37.2 40.3 38.2 31.7 36.3 36.8 36.6 35.4 35.9 37.1 Ready A1 X I fx Year-Month C D E 37.1 37.2 37.9 37 43.2 39.3 28.8 38.3 37.8 37.9 35.7 35.7 41.9 A 45 1992 8 Furniture & Household Equipment 46 1992-9 Furniture & Household Equipment 47 1992-10 Furniture & Household Equipment 48 1992-11 Furniture & Household Equipment 49 1992-12 Furniture & Household Equipment 50 1993-1 Furniture & Household Equipment 51 1993-2 Furniture & Household Equipment 52 1993-3 Furniture & Household Equipment 53 1993-4 Furniture & Household Equipment 54 1993-5 Furniture & Household Equipment 55 1993-6 Furniture & Household Equipment 56 1993-7 Furniture & Household Equipment 57 1993-8 Furniture & Household Equipment 58 1993-9 Furniture & Household Equipment 59 1993-10 Furniture & Household Equipment 60 1993-11 Furniture & Household Equipment 61 1993-12 Furniture & Household Equipment 62 1994-1 Furniture & Household Equipment 63 1994-2 Furniture & Household Equipment 64 1994-3 Furniture & Household Equipment 65 1994 4 Furniture & Household Equipment 66 1994-5 Furniture & Household Equipment 67 1994-6 Furniture & Household Equipment 68 1994-7 Furniture & Household Equipment 69 1994-8 Furniture & Household Equipment 70 1994-9 Furniture & Household Equipment 71 1994-10 Furniture & Household Equipment 72 1994-11 Furniture & Household Equipment 73 1994-12 Furniture & Household Equipment 74 1995-1 Furniture & Household Equipment 75 1995-2 Furniture & Household Equipment 76 19953 Furniture & Household Equipment 77 1995-4 Furniture & Household Equipment 78 1995-5 Furniture & Household Equipment 79 1995-6 Furniture & Household Equipment 80 1995-7 Furniture & Household Equipment 81 1995 8 Furniture & Household Equipment 82 1995-9 Furniture & Household Equipment 83 1995-10 Furniture & Household Equipment 84 1995-11 Furniture & Household Equipment 85 1995-12 Furniture & Household Equipment 86 1996-1 Furniture & Household Equipment 87 1996-2 Furniture & Household Equipment 88 1996-3 Furniture & Household Equipment 89 1996-4 Furniture & Household Equipment Sheet1 36.1 37.6 49.5 55.3 44.3 38.1 40.9 40.6 42. 37.4 39.1 39.5 39.3 43.1 43.2 60.2 49.1 35.9 42.6 43.4 45.6 43.6 43.8 41 41.6 47.3 46.4 57.3 54.8 39.8 49.6 45,9 Ready Type here to search . LE 111 Paste = = Font a Clipboard A1 Year-Month Xfx D E 45.9 40.9 42.9 42.7 41.3 45.6 44 45.6 52 49.5 B A 89 1996-4 Furniture & Household Equipment 90 1996-5 Furniture & Household Equipment 91 1996-6 Furniture & Household Equipment 92 1996-7 Furniture & Household Equipment 93 1996-8 Furniture & Household Equipment 94 1996-9 Furniture & Household Equipment 95 1996-10 Furniture & Household Equipment 96 1996-11 Furniture & Household Equipment 97 1996-12 Furniture & Household Equipment 98 1997-1 Furniture & Household Equipment 99 1997-2 Furniture & Household Equipment 100 1997-3 Furniture & Household Equipment 101 1997-4 Furniture & Household Equipment 102 1997-5 Furniture & Household Equipment 103 1997-6 Furniture & Household Equipment 104 1997-7 Furniture & Household Equipment 105 1997-8 Furniture & Household Equipment 106 1997-9 Furniture & Household Equipment 107 1997-10 Furniture & Household Equipment 108 1997-11 Furniture & Household Equipment 109 1997-12 Furniture & Household Equipment 110 1998-1 Furniture & Household Equipment 111 1998-2 Furniture & Household Equipment 112 1998-3 Furniture & Household Equipment 113 1998 4 Furniture & Household Equipment 114 1998-5 Furniture & Household Equipment 115 1998-6 Furniture & Household Equipment 116 1998-7 Furniture & Household Equipment 117 1998-8 Furniture & Household Equipment 118 1998-9 Furniture & Household Equipment 119 1998-10 Furniture & Household Equipment 120 1998-11 Furniture & Household Equipment 121 1998-12 Furniture & Household Equipment 122 1999-1 Furniture & Household Equipment 123 1999-2 Furniture & Household Equipment 124 1999-3 Furniture & Household Equipment 125 1999-4 Furniture & Household Equipment 126 1999-5 Furniture & Household Equipment 127 1999-6 Furniture & Household Equipment 128 1999 7 Furniture & Household Equipment 129 1999-8 Furniture & Household Equipment 130 19999 Furniture & Household Equipment 131 1999-10 Furniture & Household Equipment 132 1999-11 Furniture & Household Equipment 133 1999-12 Furniture & Household Equipment Sheet1 Ready 50.1 38.6 44.1 40.2 47.2 44.9 44.1 49 47.9 64.9 62.2 45.7 71 32.8 34 39.8 41.1 37.7 43.9 46 40.1 56.4 56.9 40.9 47.2 36.9 44,3 47.9 46.4 45.6 47.1 46.1 50.4 65.6 Type here to search = Clipboard Font A A1 X fx Year-Month D E B 133 1999-12 Furniture & Household Equipment 134 2000-1 Furniture & Household Equipment 135 2000-2 Furniture & Household Equipment 136 2000 3 Furniture & Household Equipment 137 2000-4 Furniture & Household Equipment 138 2000-5 Furniture & Household Equipment 139 2000 6 Furniture & Household Equipment 140 2000-7 Furniture & Household Equipment 141 2000-8 Furniture & Household Equipment 142 2000.9 Furniture & Household Equipment 143 2000-10 Furniture & Household Equipment 144 2000-11 Furniture & Household Equipment 145 2000-12 Furniture & Household Equipment 146 2001-1 Furniture & Household Equipment 147 2001-2 Furniture & Household Equipment 148 2001-3 Furniture & Household Equipment 749 2001-4 Furniture & Household Equipment 150 2001-5 Furniture & Household Equipment 151 2001-6 Furniture & Household Equipment 152 2001-7 Furniture & Household Equipment 153 2001-8 Furniture & Household Equipment 154 2001-9 Furniture & Household Equipment 155 2001-10 Furniture & Household Equipment 156 2001-11 Furniture & Household Equipment 157 2001-12 Furniture & Household Equipment 158 2002-1 Furniture & Household Equipment 159 2002-2 Furniture & Household Equipment 150 2002-3 Furniture & Household Equipment 161 2002-4 Furniture & Household Equipment 152 2002-5 Furniture & Household Equipment 163 2002-6 Furniture & Household Equipment 164 2002-7 Furniture & Household Equipment 165 2002-8 Furniture & Household Equipment 166 2002-9 Furniture & Household Equipment 167 2002-10 Furniture & Household Equipment 168 2002-11 Furniture & Household Equipment 169 2002-12 Furniture & Household Equipment 170 2003-1 Furniture & Household Equipment 171 2003-2 Furniture & Household Equipment 172 2003-3 Furniture & Household Equipment 173 2003-4 Furniture & Household Equipment 174 20035 Furniture & Household Equipment 175 2003-6 Furniture & Household Equipment 176 2003-7 Furniture & Household Equipment 177 2003-8 Furniture & Household Equipment Sheet1 65.6 63.9 48.6 47.4 44.8 49.3 51.7 54.3 45.7 52.2 50.6 61.5 75 76.5 45.6 53.7 48.4 53.8 64.8 58.9 53.8 56.1 56.6 65.2 73.7 75.4 48.7 57.7 51.5 59 55.7 56.6 54.9 50.9 54.7 59.6 81.5 81.5 54.4 55.6 59.2 64.9 69.2 59.3 Ready Type here to search A1 fx Year-Month D 59.3 62.2 65 67.1 82.3 87.7 56.4 68.5 63.3 63.6 65.8 73.4 60.4 64.7 69 72.6 91.3 72.3 54.4 59.4 57.9 A B 177 2003-8 Furniture & Household Equipment 178 2003-9 Furniture & Household Equipment 179 2003-10 Furniture & Household Equipment 180 2003-11 Furniture & Household Equipment 181 2003-12 Furniture & Household Equipment 182 2004-1 Furniture & Household Equipment 183 2004-2 Furniture & Household Equipment 184 2004-3 Furniture & Household Equipment 185 2004 4 Furniture & Household Equipment 186 2004-5 Furniture & Household Equipment 187 2004-6 Furniture & Household Equipment 188 2004-7 Furniture & Household Equipment 189 20048 Furniture & Household Equipment 190 2004-9 Furniture & Household Equipment 191 2004-10 Furniture & Household Equipment 192 2004-11 Furniture & Household Equipment 193 2004-12 Furniture & Household Equipment 194 2005-1 Furniture & Household Equipment 195 2005-2 Furniture & Household Equipment 196 2005-3 Furniture & Household Equipment 197 2005-4 Furniture & Household Equipment 198 2005-5 Furniture & Household Equipment 199 2005-6 Furniture & Household Equipment 200 2005-7 Furniture & Household Equipment 201 2005-8 Furniture & Household Equipment 202 2005-9 Furniture & Household Equipment 203 2005-10 Furniture & Household Equipment 204 2005-11 Furniture & Household Equipment 205 2005-12 Furniture & Household Equipment 206 2006-1 Furniture & Household Equipment 207 2006-2 Furniture & Household Equipment 208 2006-3 Furniture & Household Equipment 209 2006-4 Furniture & Household Equipment 210 2006-5 Furniture & Household Equipment 211 2006-6 Furniture & Household Equipment 212 2006-7 Furniture & Household Equipment 213 2006-8 Furniture & Household Equipment 214 2006-9 Furniture & Household Equipment 215 2006-10 Furniture & Household Equipment 216 2006-11 Furniture & Household Equipment 217 2006-12 Furniture & Household Equipment 218 2007-1 Furniture & Household Equipment 219 2007-2 Furniture & Household Equipment 220 2007-3 Furniture & Household Equipment 221 20074 Furniture & Household Equipment Sheet1 61.1 64.4 66.3 62.9 60.1 63.3 76.1 90.9 80.6 55.9 65.4 61.7 65 65.8 74.9 62.5 62,5 69,5 81.2 96.1 25.4 52 61 60 Ready Type here to search D E B 221 2007-4 Furniture & Household Equipment 222 2007-5 Furniture & Household Equipment 223 2007-6 Furniture & Household Equipment 224 2007-7 Furniture & Household Equipment 225 2007-8 Furniture & Household Equipment 226 2007-9 Furniture & Household Equipment 227 2007-10 Furniture & Household Equipment 228 2007-11 Furniture & Household Equipment 229 2007-12 Furniture & Household Equipment 230 2008-1 Furniture & Household Equipment 231 2008-2 Furniture & Household Equipment 232 2008-3 Furniture & Household Equipment 233 2008-4 Furniture & Household Equipment 234 2008-5 Furniture & Household Equipment 235 2008-6 Furniture & Household Equipment 236 2008-7 Furniture & Household Equipment 237 2008-8 Furniture & Household Equipment 238 2008-9 Furniture & Household Equipment 239 2008-10 Furniture & Household Equipment 240 2008-11 Furniture & Household Equipment 241 2008-12 Furniture & Household Equipment 242 2009-1 Furniture & Household Equipment 243 2009-2 Furniture & Household Equipment 244 2009-3 Furniture & Household Equipment 245 2009-4 Furniture Household Equipment 246 2009-5 Furniture & Household Equipment 247 2009-6 Furniture & Household Equipment 248 2009-7 Furniture & Household Equipment 249 2009-8 Furniture & Household Equipment 250 2009-9 Furniture & Household Equipment 251 2009-10 Furniture & Household Equipment 252 2009-11 Furniture & Household Equipment 253 2009-12 Furniture & Household Equipment 254 2010-1 Furniture & Household Equipment 255 2010-2 Furniture & Household Equipment 256 2010-3 Furniture & Household Equipment 257 2010-4 Furniture & Household Equipment 258 2010-5 Furniture & Household Equipment 259 2010-6 Furniture & Household Equipment 260 2010-7 Furniture & Household Equipment 261 2010-8 Furniture & Household Equipment 262 2010-9 Furniture & Household Equipment 263 2010-10 Furniture & Household Equipment 264 2010-11 Furniture & Household Equipment 265 2010-12 Furniture & Household Equipment 266 2011-1 Furniture & Household Equipment 267 2011-2 Furniture & Household Equipment 268 2011-3 Furniture & Household Equipment 269 20114 Furniture & Household Equipment 270 2011-5 Furniture & Household Equipment 271 2011-6 Furniture & Household Equipment 272 2011-7 Furniture & Household Equipment 273 2011-8 Furniture & Household Equipment Sheet1 60 61.2 63.3 62.5 61.5 58.6 68.5 75.8 95.1 76.3 60.1 66.9 65.8 67.3 72.2 74.6 69.6 66.3 73.9 81.1 99.3 90.2 66.7 82.7 76 78.2 77.1 82.3 73.1 75.4 88.1 83.5 103.6 93.6 70.1 82.1 78.6 84.9 78.3 81.5 76.6 82.8 90.9 85.8 116.6 107.9 84.7 97.2 928 96.8 117.5 93.6 85.8 Ready Clipboard Font A2 fx 1989-1 C D E B A 273 2011-8 Furniture & Household Equipment 274 2011-9 Furniture & Household Equipment 275 2011-10 Furniture & Household Equipment 276 2011-11 Furniture & Household Equipment 277 2011-12 Furniture & Household Equipment 278 2012-1 Furniture & Household Equipment 279 2012-2 Furniture & Household Equipment 280 2012-3 Furniture & Household Equipment 281 2012-4 Furniture & Household Equipment 282 2012-5 Furniture & Household Equipment 283 2012-6 Furniture & Household Equipment 284 2012-7 Furniture & Household Equipment 285 2012-8 Furniture & Household Equipment 286 2012-9 Furniture & Household Equipment 287 2012-10 Furniture & Household Equipment 288 2012-11 Furniture & Household Equipment 289 2012-12 Furniture & Household Equipment 290 2013-1 Furniture & Household Equipment 291 2013-2 Furniture & Household Equipment 292 2013-3 Furniture & Household Equipment 293 2013-4 Furniture & Household Equipment 294 2013-5 Furniture & Household Equipment 295 2013-6 Furniture & Household Equipment 296 2013-7 Furniture & Household Equipment 297 2013-8 Furniture & Household Equipment 298 2013-9 Furniture & Household Equipment 299 2013-10 Furniture & Household Equipment 300 2013-11 Furniture & Household Equipment 301 2013-12 Furniture & Household Equipment 302 2014-1 Furniture & Household Equipment 303 2014-2 Furniture & Household Equipment 304 2014-3 Furniture & Household Equipment 305 2014-4 Furniture & Household Equipment 306 2014-5 Furniture & Household Equipment 307 2014-6 Furniture & Household Equipment 308 2014-7 Furniture & Household Equipment 309 2014-8 Furniture & Household Equipment 310 2014-9 Furniture & Household Equipment 311 2014-10 Furniture & Household Equipment 312 2014-11 Furniture & Household Equipment 313 2014-12 Furniture & Household Equipment 314 2015-1 Furniture & Household Equipment 315 2015-2 Furniture & Household Equipment 316 2015-3 Furniture & Household Equipment 317 2015-4 Furniture & Household Equipment 318 2015-5 Furniture & Household Equipment 319 2015-6 Furniture & Household Equipment 320 2015-7 Furniture & Household Eguipment 321 2015-8 Furniture & Household Equipment 322 2015-9 Furniture & Household Equipment 323 2015-10 Furniture & Household Equipment 324 2015-11 Furniture & Household Equipment 325 2015-12 Furniture & Household Equipment Sheet1 85.8 93.2 99.5 95.8 122.5 119.7 87.2 112.9 93.7 97.4 99 101.8 90.4 99 93.4 84.9 107.1 91.1 73.2 87.6 85.5 90.2 93.9 98.7 90 97.9 90.5 92.2 110.8 110.1 76.1 97.3 95.7 98.8 100.5 103.3 102.6 101.2 99.5 104.1 127.3 119,5 82.5 102.4 96.9 104.4 103.6 107.4 105.2 99.4 105,5 103.1 129.7 Ready I V - = = Clipboard Font A2 fx 1989-1 C D E B A 325 2015-12 Furniture & Household Equipment 326 2016-1 Furniture & Household Equipment 327 2016-2 Furniture & Household Equipment 328 2016-3 Furniture & Household Equipment 329 2016-4 Furniture & Household Equipment 330 2016-5 Furniture & Household Equipment 331 2016-6 Furniture & Household Equipment 332 2016-7 Furniture & Household Equipment 333 2016-8 Furniture & Household Equipment 334 2016-9 Furniture & Household Equipment 335 2016-10 Furniture & Household Equipment 336 2016-11 Furniture & Household Equipment 337 2016-12 Furniture & Household Equipment 338 2017-1 Furniture & Household Equipment 339 2017-2 Furniture & Household Equipment 340 2017-3 Furniture & Household Equipment 341 2017-4 Furniture & Household Equipment 342 2017-5 Furniture & Household Equipment 343 2017-6 Furniture & Household Equipment 344 2017-7 Furniture & Household Equipment 345 2017-8 Furniture & Household Equipment 346 2017-9 Furniture & Household Equipment 347 2017-10 Furniture & Household Equipment 348 2017-11 Furniture & Household Equipment 349 2017-12 Furniture & Household Equipment 350 2018-1 Furniture & Household Equipment 351 2018-2 Furniture & Household Equipment 352 2018-3 Furniture & Household Equipment 353 2018-4 Furniture & Household Equipment 354 2018-5 Furniture & Household Equipment 355 2018-6 Furniture & Household Equipment 356 2018-7 Furniture & Household Equipment 357 2018-8 Furniture & Household Equipment 358 2018-9 Furniture & Household Equipment 359 2018-10 Furniture & Household Equipment 360 2018-11 Furniture & Household Equipment 361 2018-12 Furniture & Household Equipment 362 2019-1 Furniture & Household Equipment 363 2019-2 Furniture & Household Equipment 364 2019-3 Furniture & Household Equipment 365 2019-4 Furniture & Household Equipment 366 20195 Furniture & Household Equipment 367 2019-6 Furniture & Household Equipment 368 2019 7 Furniture & Household Equipment 369 2019-8 Furniture & Household Equipment 370 2019-9 Furniture & Household Equipment 371 2019-10 Furniture & Household Equipment 372 2019-11 Furniture & Household Equipment 373 2019-12 Furniture & Household Equipment 374 2020-1 Furniture & Household Equipment 375 2020-2 Furniture & Household Equipment 376 2020-3 Furniture & Household Equipment 377 2020-4 Furniture & Household Equipment Sheet1 G 129.7 117.7 93.4 110.8 100.8 106.1 108.7 109 109.8 104 107.2 106.6 132.1 120.4 87.7 103.8 98.7 95.5 105.9 108.6 103.4 100.4 100.2 101.5 127.1 117.4 79.4 96.8 95.2 94.5 105 111.4 91.1 93.5 98.1 96.9 120.6 114.8 85.7 88.5 91.5 93.6 100.9 105,9 91.3 92.6 96.9 115.1 115.6 92.2 88.9 Ready Type here to search X A A Calibri Paste BI UP 2) Clipboard Font A2 V fx 1989-1 A 95.5 106.4 103.4 89.4 92 378 2020-5 379 2020-6 380 2020-7 381 2020-8 382 2020-9 383 2020-10 384 2020-11 385 2020-12 386 2021-1 387 2021-2 388 2021-3 389 2021-4 390 2021-5 391 2021-6 392 2021-7 393 2021-8 394 2021-9 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 B Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment 91.7 95.9 120.8 105.8 79.6 94.8 91.3 97.3 112.9 97.9 94.4 91.3 412 413 414 416 417 Question 2 The Singapore Furniture Association has engaged your team service as there is an on-going sentiment within the board that the business for furniture retailers in Singapore is declining due to the increasingly preferred way of shopping for furniture directly from overseas via online shopping platforms such as Taobao, Lazada and Shopee, where consumers can ship their furniture directly from China. Your team has been engaged to provide insights based on data. Your team is provided with the retail sales(index (RSI) that the association tracks regularly. Please refer to the Excel file GBA Q2_Input File. (a) Using an appropriate forecasting method, forecast the RSI from October 2021 to June 2022. You are required to provide comments on the data, justification for the method used and the essential steps in the forecasting process. (25 marks) (b) Examine on your results in Question 2(a), provide the management a summary of the insight and highlight any concerns in your forecasting approach. (35 marks) Note: Do provide proper and adequate in-text citations and referencing to content drawn from course materials and other credible sources. A1 B Retail Sales Index (RSI) 54.5 44.1 43.8 42.7 48.5 40.9 A 1 Year Month lindustry 2 1989-1 Furniture & Household Equipment 3 1989-2 Furniture & Household Equipment 4 1989-3 Furniture & Household Equipment 5 1989-4 Furniture & Household Equipment 6 1989-5 Furniture & Household Equipment 7 1989-6 Furniture & Household Equipment 8 1989-7 Furniture & Household Equipment 9 1989-8 Furniture & Household Equipment 70 1989-9 Furniture & Household Equipment 11 1989-10 Furniture & Household Equipment 12 1989-11 Furniture & Household Equipment 13 1989-12 Furniture & Household Equipment 14 1990-1 Furniture & Household Equipment 15 1990-2 Furniture & Household Equipment 16 1990-3 Furniture & Household Equipment 17 1990-4 Furniture & Household Equipment 18 1990-5 Furniture & Household Equipment 19 1990-6 Furniture & Household Equipment 20 1990-7 Furniture & Household Equipment 21 1990-8 Furniture & Household Equipment 22 1990-9 Furniture & Household Equipment 23 1990-10 Furniture & Household Equipment 24 1990-11 Furniture & Household Equipment 25 1990-12 Furniture & Household Equipment 26 1991-1 Furniture & Household Equipment 27 1991-2 Furniture & Household Equipment 28 1991-3 Furniture & Household Equipment 29 1991-4 Furniture & Household Equipment 30 1991-5 Furniture & Household Equipment 31 1991-6 Furniture & Household Equipment 32 1991-7 Furniture & Household Equipment 33 1991-8 Furniture & Household Equipment 34 1991-9 Furniture & Household Equipment 35 1991-10 Furniture & Household Equipment 36 1991-11 Furniture & Household Equipment 37 1991.12 Furniture & Household Equipment 38 1992-1 Furniture & Household Equipment 39 1992-2 Furniture & Household Equipment 40 1992 3 Furniture & Household Equipment 41 1992-4 Furniture & Household Equipment 42 1992-5 Furniture & Household Equipment 43 1992-6 Furniture & Household Equipment 44 1992-7 Furniture & Household Equipment 45 1992-8 Furniture & Household Equipment Sheet1 36.9 33.8 35.2 33.9 37.3 45.7 43.4 36.1 35.1 30.2 34.1 35.1 32.6 25 29 34.4 29.2 36 35.9 33.8 36.1 33.3 35.7 38.9 35.2 37.2 34.5 36.8 37.2 40.3 38.2 31.7 36.3 36.8 36.6 35.4 35.9 37.1 Ready A1 X I fx Year-Month C D E 37.1 37.2 37.9 37 43.2 39.3 28.8 38.3 37.8 37.9 35.7 35.7 41.9 A 45 1992 8 Furniture & Household Equipment 46 1992-9 Furniture & Household Equipment 47 1992-10 Furniture & Household Equipment 48 1992-11 Furniture & Household Equipment 49 1992-12 Furniture & Household Equipment 50 1993-1 Furniture & Household Equipment 51 1993-2 Furniture & Household Equipment 52 1993-3 Furniture & Household Equipment 53 1993-4 Furniture & Household Equipment 54 1993-5 Furniture & Household Equipment 55 1993-6 Furniture & Household Equipment 56 1993-7 Furniture & Household Equipment 57 1993-8 Furniture & Household Equipment 58 1993-9 Furniture & Household Equipment 59 1993-10 Furniture & Household Equipment 60 1993-11 Furniture & Household Equipment 61 1993-12 Furniture & Household Equipment 62 1994-1 Furniture & Household Equipment 63 1994-2 Furniture & Household Equipment 64 1994-3 Furniture & Household Equipment 65 1994 4 Furniture & Household Equipment 66 1994-5 Furniture & Household Equipment 67 1994-6 Furniture & Household Equipment 68 1994-7 Furniture & Household Equipment 69 1994-8 Furniture & Household Equipment 70 1994-9 Furniture & Household Equipment 71 1994-10 Furniture & Household Equipment 72 1994-11 Furniture & Household Equipment 73 1994-12 Furniture & Household Equipment 74 1995-1 Furniture & Household Equipment 75 1995-2 Furniture & Household Equipment 76 19953 Furniture & Household Equipment 77 1995-4 Furniture & Household Equipment 78 1995-5 Furniture & Household Equipment 79 1995-6 Furniture & Household Equipment 80 1995-7 Furniture & Household Equipment 81 1995 8 Furniture & Household Equipment 82 1995-9 Furniture & Household Equipment 83 1995-10 Furniture & Household Equipment 84 1995-11 Furniture & Household Equipment 85 1995-12 Furniture & Household Equipment 86 1996-1 Furniture & Household Equipment 87 1996-2 Furniture & Household Equipment 88 1996-3 Furniture & Household Equipment 89 1996-4 Furniture & Household Equipment Sheet1 36.1 37.6 49.5 55.3 44.3 38.1 40.9 40.6 42. 37.4 39.1 39.5 39.3 43.1 43.2 60.2 49.1 35.9 42.6 43.4 45.6 43.6 43.8 41 41.6 47.3 46.4 57.3 54.8 39.8 49.6 45,9 Ready Type here to search . LE 111 Paste = = Font a Clipboard A1 Year-Month Xfx D E 45.9 40.9 42.9 42.7 41.3 45.6 44 45.6 52 49.5 B A 89 1996-4 Furniture & Household Equipment 90 1996-5 Furniture & Household Equipment 91 1996-6 Furniture & Household Equipment 92 1996-7 Furniture & Household Equipment 93 1996-8 Furniture & Household Equipment 94 1996-9 Furniture & Household Equipment 95 1996-10 Furniture & Household Equipment 96 1996-11 Furniture & Household Equipment 97 1996-12 Furniture & Household Equipment 98 1997-1 Furniture & Household Equipment 99 1997-2 Furniture & Household Equipment 100 1997-3 Furniture & Household Equipment 101 1997-4 Furniture & Household Equipment 102 1997-5 Furniture & Household Equipment 103 1997-6 Furniture & Household Equipment 104 1997-7 Furniture & Household Equipment 105 1997-8 Furniture & Household Equipment 106 1997-9 Furniture & Household Equipment 107 1997-10 Furniture & Household Equipment 108 1997-11 Furniture & Household Equipment 109 1997-12 Furniture & Household Equipment 110 1998-1 Furniture & Household Equipment 111 1998-2 Furniture & Household Equipment 112 1998-3 Furniture & Household Equipment 113 1998 4 Furniture & Household Equipment 114 1998-5 Furniture & Household Equipment 115 1998-6 Furniture & Household Equipment 116 1998-7 Furniture & Household Equipment 117 1998-8 Furniture & Household Equipment 118 1998-9 Furniture & Household Equipment 119 1998-10 Furniture & Household Equipment 120 1998-11 Furniture & Household Equipment 121 1998-12 Furniture & Household Equipment 122 1999-1 Furniture & Household Equipment 123 1999-2 Furniture & Household Equipment 124 1999-3 Furniture & Household Equipment 125 1999-4 Furniture & Household Equipment 126 1999-5 Furniture & Household Equipment 127 1999-6 Furniture & Household Equipment 128 1999 7 Furniture & Household Equipment 129 1999-8 Furniture & Household Equipment 130 19999 Furniture & Household Equipment 131 1999-10 Furniture & Household Equipment 132 1999-11 Furniture & Household Equipment 133 1999-12 Furniture & Household Equipment Sheet1 Ready 50.1 38.6 44.1 40.2 47.2 44.9 44.1 49 47.9 64.9 62.2 45.7 71 32.8 34 39.8 41.1 37.7 43.9 46 40.1 56.4 56.9 40.9 47.2 36.9 44,3 47.9 46.4 45.6 47.1 46.1 50.4 65.6 Type here to search = Clipboard Font A A1 X fx Year-Month D E B 133 1999-12 Furniture & Household Equipment 134 2000-1 Furniture & Household Equipment 135 2000-2 Furniture & Household Equipment 136 2000 3 Furniture & Household Equipment 137 2000-4 Furniture & Household Equipment 138 2000-5 Furniture & Household Equipment 139 2000 6 Furniture & Household Equipment 140 2000-7 Furniture & Household Equipment 141 2000-8 Furniture & Household Equipment 142 2000.9 Furniture & Household Equipment 143 2000-10 Furniture & Household Equipment 144 2000-11 Furniture & Household Equipment 145 2000-12 Furniture & Household Equipment 146 2001-1 Furniture & Household Equipment 147 2001-2 Furniture & Household Equipment 148 2001-3 Furniture & Household Equipment 749 2001-4 Furniture & Household Equipment 150 2001-5 Furniture & Household Equipment 151 2001-6 Furniture & Household Equipment 152 2001-7 Furniture & Household Equipment 153 2001-8 Furniture & Household Equipment 154 2001-9 Furniture & Household Equipment 155 2001-10 Furniture & Household Equipment 156 2001-11 Furniture & Household Equipment 157 2001-12 Furniture & Household Equipment 158 2002-1 Furniture & Household Equipment 159 2002-2 Furniture & Household Equipment 150 2002-3 Furniture & Household Equipment 161 2002-4 Furniture & Household Equipment 152 2002-5 Furniture & Household Equipment 163 2002-6 Furniture & Household Equipment 164 2002-7 Furniture & Household Equipment 165 2002-8 Furniture & Household Equipment 166 2002-9 Furniture & Household Equipment 167 2002-10 Furniture & Household Equipment 168 2002-11 Furniture & Household Equipment 169 2002-12 Furniture & Household Equipment 170 2003-1 Furniture & Household Equipment 171 2003-2 Furniture & Household Equipment 172 2003-3 Furniture & Household Equipment 173 2003-4 Furniture & Household Equipment 174 20035 Furniture & Household Equipment 175 2003-6 Furniture & Household Equipment 176 2003-7 Furniture & Household Equipment 177 2003-8 Furniture & Household Equipment Sheet1 65.6 63.9 48.6 47.4 44.8 49.3 51.7 54.3 45.7 52.2 50.6 61.5 75 76.5 45.6 53.7 48.4 53.8 64.8 58.9 53.8 56.1 56.6 65.2 73.7 75.4 48.7 57.7 51.5 59 55.7 56.6 54.9 50.9 54.7 59.6 81.5 81.5 54.4 55.6 59.2 64.9 69.2 59.3 Ready Type here to search A1 fx Year-Month D 59.3 62.2 65 67.1 82.3 87.7 56.4 68.5 63.3 63.6 65.8 73.4 60.4 64.7 69 72.6 91.3 72.3 54.4 59.4 57.9 A B 177 2003-8 Furniture & Household Equipment 178 2003-9 Furniture & Household Equipment 179 2003-10 Furniture & Household Equipment 180 2003-11 Furniture & Household Equipment 181 2003-12 Furniture & Household Equipment 182 2004-1 Furniture & Household Equipment 183 2004-2 Furniture & Household Equipment 184 2004-3 Furniture & Household Equipment 185 2004 4 Furniture & Household Equipment 186 2004-5 Furniture & Household Equipment 187 2004-6 Furniture & Household Equipment 188 2004-7 Furniture & Household Equipment 189 20048 Furniture & Household Equipment 190 2004-9 Furniture & Household Equipment 191 2004-10 Furniture & Household Equipment 192 2004-11 Furniture & Household Equipment 193 2004-12 Furniture & Household Equipment 194 2005-1 Furniture & Household Equipment 195 2005-2 Furniture & Household Equipment 196 2005-3 Furniture & Household Equipment 197 2005-4 Furniture & Household Equipment 198 2005-5 Furniture & Household Equipment 199 2005-6 Furniture & Household Equipment 200 2005-7 Furniture & Household Equipment 201 2005-8 Furniture & Household Equipment 202 2005-9 Furniture & Household Equipment 203 2005-10 Furniture & Household Equipment 204 2005-11 Furniture & Household Equipment 205 2005-12 Furniture & Household Equipment 206 2006-1 Furniture & Household Equipment 207 2006-2 Furniture & Household Equipment 208 2006-3 Furniture & Household Equipment 209 2006-4 Furniture & Household Equipment 210 2006-5 Furniture & Household Equipment 211 2006-6 Furniture & Household Equipment 212 2006-7 Furniture & Household Equipment 213 2006-8 Furniture & Household Equipment 214 2006-9 Furniture & Household Equipment 215 2006-10 Furniture & Household Equipment 216 2006-11 Furniture & Household Equipment 217 2006-12 Furniture & Household Equipment 218 2007-1 Furniture & Household Equipment 219 2007-2 Furniture & Household Equipment 220 2007-3 Furniture & Household Equipment 221 20074 Furniture & Household Equipment Sheet1 61.1 64.4 66.3 62.9 60.1 63.3 76.1 90.9 80.6 55.9 65.4 61.7 65 65.8 74.9 62.5 62,5 69,5 81.2 96.1 25.4 52 61 60 Ready Type here to search D E B 221 2007-4 Furniture & Household Equipment 222 2007-5 Furniture & Household Equipment 223 2007-6 Furniture & Household Equipment 224 2007-7 Furniture & Household Equipment 225 2007-8 Furniture & Household Equipment 226 2007-9 Furniture & Household Equipment 227 2007-10 Furniture & Household Equipment 228 2007-11 Furniture & Household Equipment 229 2007-12 Furniture & Household Equipment 230 2008-1 Furniture & Household Equipment 231 2008-2 Furniture & Household Equipment 232 2008-3 Furniture & Household Equipment 233 2008-4 Furniture & Household Equipment 234 2008-5 Furniture & Household Equipment 235 2008-6 Furniture & Household Equipment 236 2008-7 Furniture & Household Equipment 237 2008-8 Furniture & Household Equipment 238 2008-9 Furniture & Household Equipment 239 2008-10 Furniture & Household Equipment 240 2008-11 Furniture & Household Equipment 241 2008-12 Furniture & Household Equipment 242 2009-1 Furniture & Household Equipment 243 2009-2 Furniture & Household Equipment 244 2009-3 Furniture & Household Equipment 245 2009-4 Furniture Household Equipment 246 2009-5 Furniture & Household Equipment 247 2009-6 Furniture & Household Equipment 248 2009-7 Furniture & Household Equipment 249 2009-8 Furniture & Household Equipment 250 2009-9 Furniture & Household Equipment 251 2009-10 Furniture & Household Equipment 252 2009-11 Furniture & Household Equipment 253 2009-12 Furniture & Household Equipment 254 2010-1 Furniture & Household Equipment 255 2010-2 Furniture & Household Equipment 256 2010-3 Furniture & Household Equipment 257 2010-4 Furniture & Household Equipment 258 2010-5 Furniture & Household Equipment 259 2010-6 Furniture & Household Equipment 260 2010-7 Furniture & Household Equipment 261 2010-8 Furniture & Household Equipment 262 2010-9 Furniture & Household Equipment 263 2010-10 Furniture & Household Equipment 264 2010-11 Furniture & Household Equipment 265 2010-12 Furniture & Household Equipment 266 2011-1 Furniture & Household Equipment 267 2011-2 Furniture & Household Equipment 268 2011-3 Furniture & Household Equipment 269 20114 Furniture & Household Equipment 270 2011-5 Furniture & Household Equipment 271 2011-6 Furniture & Household Equipment 272 2011-7 Furniture & Household Equipment 273 2011-8 Furniture & Household Equipment Sheet1 60 61.2 63.3 62.5 61.5 58.6 68.5 75.8 95.1 76.3 60.1 66.9 65.8 67.3 72.2 74.6 69.6 66.3 73.9 81.1 99.3 90.2 66.7 82.7 76 78.2 77.1 82.3 73.1 75.4 88.1 83.5 103.6 93.6 70.1 82.1 78.6 84.9 78.3 81.5 76.6 82.8 90.9 85.8 116.6 107.9 84.7 97.2 928 96.8 117.5 93.6 85.8 Ready Clipboard Font A2 fx 1989-1 C D E B A 273 2011-8 Furniture & Household Equipment 274 2011-9 Furniture & Household Equipment 275 2011-10 Furniture & Household Equipment 276 2011-11 Furniture & Household Equipment 277 2011-12 Furniture & Household Equipment 278 2012-1 Furniture & Household Equipment 279 2012-2 Furniture & Household Equipment 280 2012-3 Furniture & Household Equipment 281 2012-4 Furniture & Household Equipment 282 2012-5 Furniture & Household Equipment 283 2012-6 Furniture & Household Equipment 284 2012-7 Furniture & Household Equipment 285 2012-8 Furniture & Household Equipment 286 2012-9 Furniture & Household Equipment 287 2012-10 Furniture & Household Equipment 288 2012-11 Furniture & Household Equipment 289 2012-12 Furniture & Household Equipment 290 2013-1 Furniture & Household Equipment 291 2013-2 Furniture & Household Equipment 292 2013-3 Furniture & Household Equipment 293 2013-4 Furniture & Household Equipment 294 2013-5 Furniture & Household Equipment 295 2013-6 Furniture & Household Equipment 296 2013-7 Furniture & Household Equipment 297 2013-8 Furniture & Household Equipment 298 2013-9 Furniture & Household Equipment 299 2013-10 Furniture & Household Equipment 300 2013-11 Furniture & Household Equipment 301 2013-12 Furniture & Household Equipment 302 2014-1 Furniture & Household Equipment 303 2014-2 Furniture & Household Equipment 304 2014-3 Furniture & Household Equipment 305 2014-4 Furniture & Household Equipment 306 2014-5 Furniture & Household Equipment 307 2014-6 Furniture & Household Equipment 308 2014-7 Furniture & Household Equipment 309 2014-8 Furniture & Household Equipment 310 2014-9 Furniture & Household Equipment 311 2014-10 Furniture & Household Equipment 312 2014-11 Furniture & Household Equipment 313 2014-12 Furniture & Household Equipment 314 2015-1 Furniture & Household Equipment 315 2015-2 Furniture & Household Equipment 316 2015-3 Furniture & Household Equipment 317 2015-4 Furniture & Household Equipment 318 2015-5 Furniture & Household Equipment 319 2015-6 Furniture & Household Equipment 320 2015-7 Furniture & Household Eguipment 321 2015-8 Furniture & Household Equipment 322 2015-9 Furniture & Household Equipment 323 2015-10 Furniture & Household Equipment 324 2015-11 Furniture & Household Equipment 325 2015-12 Furniture & Household Equipment Sheet1 85.8 93.2 99.5 95.8 122.5 119.7 87.2 112.9 93.7 97.4 99 101.8 90.4 99 93.4 84.9 107.1 91.1 73.2 87.6 85.5 90.2 93.9 98.7 90 97.9 90.5 92.2 110.8 110.1 76.1 97.3 95.7 98.8 100.5 103.3 102.6 101.2 99.5 104.1 127.3 119,5 82.5 102.4 96.9 104.4 103.6 107.4 105.2 99.4 105,5 103.1 129.7 Ready I V - = = Clipboard Font A2 fx 1989-1 C D E B A 325 2015-12 Furniture & Household Equipment 326 2016-1 Furniture & Household Equipment 327 2016-2 Furniture & Household Equipment 328 2016-3 Furniture & Household Equipment 329 2016-4 Furniture & Household Equipment 330 2016-5 Furniture & Household Equipment 331 2016-6 Furniture & Household Equipment 332 2016-7 Furniture & Household Equipment 333 2016-8 Furniture & Household Equipment 334 2016-9 Furniture & Household Equipment 335 2016-10 Furniture & Household Equipment 336 2016-11 Furniture & Household Equipment 337 2016-12 Furniture & Household Equipment 338 2017-1 Furniture & Household Equipment 339 2017-2 Furniture & Household Equipment 340 2017-3 Furniture & Household Equipment 341 2017-4 Furniture & Household Equipment 342 2017-5 Furniture & Household Equipment 343 2017-6 Furniture & Household Equipment 344 2017-7 Furniture & Household Equipment 345 2017-8 Furniture & Household Equipment 346 2017-9 Furniture & Household Equipment 347 2017-10 Furniture & Household Equipment 348 2017-11 Furniture & Household Equipment 349 2017-12 Furniture & Household Equipment 350 2018-1 Furniture & Household Equipment 351 2018-2 Furniture & Household Equipment 352 2018-3 Furniture & Household Equipment 353 2018-4 Furniture & Household Equipment 354 2018-5 Furniture & Household Equipment 355 2018-6 Furniture & Household Equipment 356 2018-7 Furniture & Household Equipment 357 2018-8 Furniture & Household Equipment 358 2018-9 Furniture & Household Equipment 359 2018-10 Furniture & Household Equipment 360 2018-11 Furniture & Household Equipment 361 2018-12 Furniture & Household Equipment 362 2019-1 Furniture & Household Equipment 363 2019-2 Furniture & Household Equipment 364 2019-3 Furniture & Household Equipment 365 2019-4 Furniture & Household Equipment 366 20195 Furniture & Household Equipment 367 2019-6 Furniture & Household Equipment 368 2019 7 Furniture & Household Equipment 369 2019-8 Furniture & Household Equipment 370 2019-9 Furniture & Household Equipment 371 2019-10 Furniture & Household Equipment 372 2019-11 Furniture & Household Equipment 373 2019-12 Furniture & Household Equipment 374 2020-1 Furniture & Household Equipment 375 2020-2 Furniture & Household Equipment 376 2020-3 Furniture & Household Equipment 377 2020-4 Furniture & Household Equipment Sheet1 G 129.7 117.7 93.4 110.8 100.8 106.1 108.7 109 109.8 104 107.2 106.6 132.1 120.4 87.7 103.8 98.7 95.5 105.9 108.6 103.4 100.4 100.2 101.5 127.1 117.4 79.4 96.8 95.2 94.5 105 111.4 91.1 93.5 98.1 96.9 120.6 114.8 85.7 88.5 91.5 93.6 100.9 105,9 91.3 92.6 96.9 115.1 115.6 92.2 88.9 Ready Type here to search X A A Calibri Paste BI UP 2) Clipboard Font A2 V fx 1989-1 A 95.5 106.4 103.4 89.4 92 378 2020-5 379 2020-6 380 2020-7 381 2020-8 382 2020-9 383 2020-10 384 2020-11 385 2020-12 386 2021-1 387 2021-2 388 2021-3 389 2021-4 390 2021-5 391 2021-6 392 2021-7 393 2021-8 394 2021-9 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 B Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment Furniture & Household Equipment 91.7 95.9 120.8 105.8 79.6 94.8 91.3 97.3 112.9 97.9 94.4 91.3 412 413 414 416 417

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas

10th edition

978-1260481952

Students also viewed these Accounting questions