Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use quantitative forecasting method, Time-series model to answer the below question Question 2 The Singapore Furniture Association has engaged your team service as there is
Use quantitative forecasting method, Time-series model to answer the below question
Question 2 The Singapore Furniture Association has engaged your team service as there is an ongoing sentiment within the board that the business for lmiture retailers in Singapore is declining due to the increasineg preferred wag,r of shopping for furniture directly 'om overseas via online shopping platforms such as Taobao, Lazada and Shopee, where consumers can ship their lrniture 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 (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) Note: Do provide proper and adequate inntext citations and referencing to content drawn from course materials and other credible sources. "GBA_Q2_InputFile RSI RSI RSI RSI BSI RSI RSI Year-Mont Industry Year-Mo Industry Year-Mo Industry Year-Mo Industry Year-Mo Industry Year-Mo Industry Year-Mo Industry 1989-1 54.5 1993-10 Furniture & Household Equipmen 37.6 1998-7 Furniture & Household Equipmen 41.1 2003-5 Furniture & Household Equipmen 59.2 2008-2 Furniture & Household Equipmen 60.1 2012-10 Furniture & Household Equipmen 93.4 7 Furniture & Household Equipmen 108.6 Furniture & Household Equipmen 1989-2 Furniture & Household Equipmen 44.1 1993-11 Furniture & Household Equipmen 49.5 1998-8 Furniture & Household Equipmen 37.7 2003- Furniture & Household Equipmen 64.9 2008-3 Furniture & Household Equipmen 66. 2012-11 Furniture & Household Equipmen 84. 2017-8 Furniture & Household Equipmen 103.4 989-3 Furniture & Household Equipmen 43.8 1993-12 Furniture & Household Equipmen 65.3 1998-9 Furniture & Household Equipmen 43.9 2003-7 Furniture & Household Equipmer 69.2 2008-4 Furniture & Household Equipmen 65.8 12 Furniture & Household Equipmen 107.1 2017-9 Furniture & Household Equipmen 100.4 989-4 Furniture & Household Equipmen 42.7 1994-1 Furniture & Household Equipmen 14 3 1998-10 Furniture & Household Equipmen 46 2003-8 Furniture & Household Equipmen 59.3 2008-5 Furniture & Household Equipmen 67.3 2013-1 Furniture & Household Equipmen 91.1 2017-10 Furniture & Household Equipmen 100.2 1015 989-5 Furniture & Household Equipmen 48.5 1994-2 Furniture & Household Equipmen 381 1998-11 Furniture & Household Equipmen 40.1 2003-9 Furniture & Household Equipmen 2008-6 Furniture & Household Equipmen 25 2013-2 Furniture & Household Equipmen 73.2 2017-11 Furniture & Household Equipmen Furniture & Household Equipmen 40.9 1994-3 Furniture & Household Equipmen 40.9 1998-12 Furniture & Household Equipmen :003-10 Furniture & Household Equipmer 65 2008-7 Furniture & Household Equipmen 74. 2013-3 Furniture & Household Equipmen 87.6 2017-12 Furniture & Household Equipmen 1271 1989-7 Furniture & Household Equipmen 36.9 1994-4 Furniture & Household Equipmen 40.6 1999-1 Furniture & Household Equipmen 16.9 2003-11 Furniture & Household Equipmen 67.1 2008-8 Furniture & Household Equipmen 2013-4 Furniture & Household Equip Uipmen 85. 2018-1 Furniture & Household Equi 117.4 989-8 Furniture & Household Equipmen 33 8 994-5 Furniture & Household Equipmen 42 1999-2 Furniture & Household Equipmen 409 2003-12 Furniture & Household Equipmen 82.3 2008-9 Furniture & Household Equipmen 2013-5 Furniture & Household Equipmen 90.: 2018-2 Furniture & Household Equipmen 79.4 1989-9 35.2 1994-6 Furniture & Household Equipmen 17.4 1999-3 Furniture & Household Equipmen 472 2004-1 Furniture & Household Equipmen 87 7 2008-10 Furniture & Household Equipmen 73.9 2013-6 Furniture & Household Equipmer 93.9 2018-3 Furniture & Household Equipmen Furniture & Household Equipmen 96.8 1989-10 hold Equipmen 33.9 1994-7 Furniture & Household Equipmen 39.1 1999-4 Furniture & Household Equipmen 36.9 2004-2 Furniture & Household Equipmen 56.4 2008-11 Furniture & Household Equipmen 2013-7 Furniture & House hold Equipmen 98.7 2018-4 Furniture 95.2 989-11 Furniture & Household Equipmen 37.3 1994-8 Furniture & Household Equipmen 395 1999-5 Furniture & Household Equipmen 14.3 2004-3 Furniture & Household Equipmen 68 5 2008-12 Furniture & Household Equipmen 19.3 2013-8 Furniture & Household Equipmen 90 2018-5 Furniture & Household Equipmen 94.5 189-12 Furniture & Household Equipmen 45.7 1994-9 Furniture & Household Equipmer 39.3 1999-6 Furniture & Household Equipme 47.9 2004-4 Furniture & Household Equipmen 63.3 2009-1 Furniture & Household Equipmen 10.2 2013-9 Furniture & Household Equipmen 97.9 2018-6 Furniture & Household Equipmen 105 Furniture & Household Equipmen 43.4 1994-10 Furniture & Household Equipmen 43.1 999-8 Furniture & Household Equipmen 45.6 2004-5 Furniture & Hous old Equipmen 63.6 2009-2 Furniture & Hou: hold Equipmer 6.7 2013-10 Furniture & Hous hold Equipmer 90. 2018-7 Furniture hold Equipmen 111.4 1990-2 36.1 994-11 Furniture & Household Equipmen 32 999-9 Furniture & Household Equipmen 2004-6 Furniture & Household Equipmen 65 8 2009-3 Furniture & Household Equipmen 827 2013-11 Furniture & Household Equipmen 92 2 2018-8 Furniture & Household Equipmen Furniture & Household Equipmen 91.1 1990-3 Furniture & Household Equipmen 35.1 1994-12 Furniture & Household Equipmen 0.2 899-10 Furniture & Household Equipmen 16.1 2004-7 Furniture & Household Equipmen 73.4 2009-4 Furniture & Household Equipmen 76 2013-12 Furniture & Household Equipmen 110.8 2018-9 Furniture & Household Equipmen 93.5 1990-4 old Equipmen 10.2 1995-1 Furniture & Household Equipmen 19.1 1999-11 Furniture & Household Equipmen 0.4 2004-8 Furniture & Household Equipmen 60.4 2009-5 Furniture & Household Equipmen 2014-1 Furniture & Household Equipmen 110.1 2018-10 old Equipmen 981 1990-5 Furniture & Household Equipmen 341 1995-2 Furniture & Household Equipmen 35.9 1999-12 Furniture & Household Equipmen 65 6 2004-9 Furniture & Household Equipmen 4 7 2009-6 Furniture & Household Equipmen 77. 2014-2 Furniture & Household Equipmen 76.1 2018-11 Furniture & Household Equipmen 96.9 1990-6 930- Furniture & Household Equipmen 35.1 1995-3 Furniture & Household Equipmen 42.6 2000-1 Furniture & Household Equipmen 63.9 2004-10 Furniture & Household Equipmen 69 2009-7 Furniture & Household Equipmen :2.3 2014-3 Furniture & Household Equipmen 97.3 2018-12 Furniture & Household Equipmen 120. 1990-7 Furniture & Household Equipmen 26 1995-4 Furniture & Household Equipmen 13.4 2000-2 Furniture & Househol old Equipmen 48.6 2004-11 Furniture & House old Equipmen '2.6 2009-8 Furniture & Household Equipmer 2014-4 Furniture & Househo Id Equipmen 95.7 2019-1 Furniture hold Equipmen 114.8 98 8 85.7 1990-8 Furniture & Household Equipmen 25 1995-5 Furniture & Household Equipmen 56 2000-3 Furniture & Household Equipmen 47.4 2004-12 Furniture & Household Equipmen 91.3 2009-9 Furniture & Household Equipmen 75.4 2014-5 Furniture & Household Equipmen 2019-2 Furniture & Household Equipmen 1990-9 29 1995-6 Furniture & Household Equipmen 43.6 2000-4 Furniture & Household Equipmen 44.8 2005-1 Furniture & Household Equipmen 72.3 2009-10 Furniture & Household Equipmen 2014-6 Furniture & Household Equipmen 100.5 Furniture & Household Equipmen 2019-3 Furniture & Household Equipme 88.5 1990-10 Furniture & Household Equipmen 1995-7 Furniture & Household Equipmen 43.8 2000-5 Furniture & Household Equipmen 9.3 2005-2 Furniture & Household Equipmen 4.4 2009-11 Furniture & Household Equipmen 83.5 2014-7 Furniture & Household Equipmen 103.3 2019-4 Furniture & Household Equipmen 90-11 Furniture & Household Equipmen 9.2 1995-8 Furniture & Household Equipmen 41 2000-6 Furniture & Household Equipmen 51.7 2005-3 Furniture & Household Equipmen 59 4 2009-12 Furniture & Household Equipmen 03.6 2014-8 Furniture & Household Equipmen 102 6 2019-5 Furniture & Household Equipmen 93.6 1990-12 Furniture & Household Equipmen 36 1995-9 Furniture & Household Equipmer $1.6 2000-7 Furniture & Household Equipmen 54.3 2005-4 Furniture & Household Equipmen 57 9 2010-1 Furniture & Household Equipmen 93.6 2014-9 Furniture & Household Equipmen 101.2 2019-6 Furniture & Household Equipmen 100.9 991-1 Furniture & Household Equipmen 35.9 1995-10 Furniture & Household Equipmen 2000-8 Furniture & Household Equipmen 45.7 2005-5 Furniture & Household Equipmen 2010-2 Furniture & Household Equipmen 70.1 2014-10 Furniture & Household Equipmen 99 5 2019-7 Furniture & Household Equipmen 105.9 991-2 1995-11 46.4 2000-9 Furniture & Household Equipmen 52 2 2005-6 Furniture & Household Equipmen 64.4 2010-2 Furniture & Household Equipmen 70.1 2014-11 Furniture & Household Equipmen 104 1 Furniture & Household Equipmen 33.8 Furniture & Household Equipmen 2019-8 Furniture & Household Equipmen 95 931-3 Furniture & Household Equipme 361 1995-12 Furniture & Household Equipmen 57.3 2000-10 Furniture & Household Equipmen 50.6 2005-7 Furniture & Household Equipmen 66.3 2010-3 Furniture & Household Equipmen 2014-12 Furniture & Househ 127.3 2019-9 91.3 1991-4 Furniture & Household Equipmen 33.3 1996-1 Furniture & Household Equipmen 54.8 2000-11 Furniture & Household Equipmen 615 2005-8 Furniture & Household Equipmen 2010-4 Furniture & Household Equipmen 8.6 2015- Furniture & Household Equipmen 2019-10 Furniture & Household Equipmen 92.6 1991-5 1996-2 Furniture & Household Equipmen 398 2000-12 Furniture & Household Equipmer 75 2005-9 Furniture & Household Equipmen 60.1 2010-5 Furniture & Household Equipmen 4.9 2015-2 Furniture & Household Equipmen 825 Furniture & Household Equipmen 35.7 2019-11 Furniture & Household Equipmen 96.9 931-6 Furniture & Household Equipmen 38.9 1996-3 Furniture & Household Equipmen 49.6 2001-1 Furniture & Household Equipmen '6.5 2005-10 Furniture & Household Equipmen 63.3 2010-6 Furniture & Household Equipmer 78.3 2015-3 Furniture & Househo quipmen 102.4 2019-12 Furniture & Household E pmen 115.1 991-7 Furniture & Household Equipmen 35.2 1996-4 Furniture & Household Equipmen 45 9 2001-2 Furniture & Household Equipmen 45.6 2005-11 Furniture & Household Equipmen 761 2010-7 Furniture & Household Equipmen 81. 2015-4 Furniture & Household Equipmen 96.9 2020-1 Furniture & Household Equipmen 115.6 991-8 Furniture & Household Equipmen 7.2 1996-5 Furniture & Household Equipmen 40.9 2001-3 Furniture & Household Equipmen 537 2005-12 Furniture & Household Equipmen 90.9 2010-8 Furniture & Household Equipmen 76.6 2015-5 Furniture & Household Equipmen 104.4 2020-2 Furniture & Household Equipmen 75.4 103.6 92.2 991-9 Furniture & 34.5 1996-6 Furniture & Household Equipmen 2.9 2001-4 Furniture & Household Equipmen 8.4 2006-1 Furniture & Household Equipmen 80.6 2010-9 Furniture & Household Equipmen 32.8 2015-6 Furniture & Hous ehold Equipmen 2020-3 Furniture & Househ 36.8 1996-7 Furniture & Household Equipmen 12.7 2001-5 Furniture & Household Equipmen 53.8 2006-2 Furniture & Household Equipmen 55.9 2010-10 Furniture & Household Equipmen 90.9 2015-7 Furniture & Household Equipmen 107.4 88.9 1991-10 Furniture & Household Equipmen 2020-4 Furniture & Household Equipmen 1991-11 Furniture & Household Equipmen 37.2 1996-8 Furniture & Household Equipmen 41.3 2001-6 Furniture & Household Equipmen 54.8 2006-3 Furniture & Household Equipmen 65.4 2010-11 Furniture & Household Equipmen 85.8 2015-8 Furniture & Household Equipmen 105.7 2020-5 Furniture & Household Equipmen 95.5 Furniture & Household Equipmen 40.3 1996-9 Furniture & Household Equipmen 5.6 2001-7 Furniture & Household Equipmen 58.9 2006-4 Furniture & Household Equip 517 2010-12 Furniture & Household Equ 16.6 2015-9 Furniture & Househ wipmen 99.4 2020-6 Furniture 106.4 992-1 Furniture & Household Equipmen 38.2 996-10 Furniture & Household Equipmen 2001-8 Furniture & Household Equipmen 53.8 2006-5 Furniture & Household Equipmen 65 2011-1 Furniture & Household Equipmen 07.9 2015-10 Furniture & Household Equipmen 105. 2020-7 Furniture & Household Equipmen 103.4 1992-2 Furniture & Household Equipmen 31.7 1996-11 Furniture & Household Equipmen 5.6 2001-9 Furniture & Household Equipmen 561 2006-6 Furniture & Household Equipmen 65.8 2011-2 Furniture & Household Equipmen 4.7 2015-11 Furniture & Household Equipmen 103.1 2020-8 Furniture & Household Equipmen 89 4 1992-3 Furniture & d Equipmen 36.3 1996-12 Furniture & Household Equipmen 2001-10 Furniture & Household Equipmen 56.6 2006-7 Furniture & Household Equipmen 74 9 2011-3 Furniture & Household Equipmen 97.2 2015-12 Furniture & Househ Equipmen 129.7 2020-9 92 992-4 Furniture & Household Equipmen 36.8 1997-1 Furniture & Household Equipmen 495 2001-11 Furniture & Household Equipmen 2006-8 Furniture & Household Equipmen 62.5 2011-4 Furniture & Household Equipmen 128 2016-1 Furniture & Household Equipmen 117.7 2020-10 Furniture & Household Equipmen 91.7 992-5 36.6 1997-2 Furniture & Household Equipmen 2001-12 Furniture & Household Equipmer 62.5 Furniture & Household Equipmen 96.8 2016-2 Furniture & Household Equipmen 93.4 Furniture & Household Equipmen 40.3 73.7 2006-9 Furniture & Household Equipmen 2011-5 2020-11 Furniture & Household Equipmen 95.9 1954-6 Furniture & Household Equipmen 35.4 1997-3 Furniture & Household Equipmen 501 2002-1 Furniture & Household Equi 75.4 2006-10 Furniture & Household Equipmen 69.5 2011-6 Furniture & Hous hold Equipmer 17.5 2016-3 Furniture & Household Equipmer 110.8 2020-12 Fu hold Equipmen 120.8 992-7 Furniture & Household Equipmen 35.9 1997-4 Furniture & Household Equipmen 38.6 2002-2 Furniture & Household Equipmen 48 7 2006-11 Furniture & Household Equipmen 2011-7 Furniture & Household Equipmen 3.6 2016-4 Furniture & Household Equipmen 100.8 2021-1 Furniture & Household Equipmen 105.8 1992-8 Furniture & Household Equipmen 37.1 1997-5 Furniture & Household Equipmen 441 2002-3 Furniture & Household Equipmen 57.7 2006-12 Furniture & Household Equipmen 96.1 2011-8 Furniture & Household Equipmen 5.8 2016-5 Furniture & Household Equipmen 106.1 2021-2 Furniture & Household Equipmen 79.6 1934-3 Furniture & Household Equipmen 37.2 1997-6 Furniture & Household Equipmen 0.2 2002-4 Furniture & Household Equipmen 515 2007-1 Furniture & Household Equipmen 2001-3 Furniture & Household Equipmen 3.2 2016-6 Furniture & Household Equipmen 108.7 2021-3 Furniture & Househ old Equipmen 392-10 Furniture & Household Equipmen 37 9 1997-7 Furniture & Household Equipmen $7.2 2002-5 Furniture & Household Equipmen 59 2007-2 Furniture & Household Equipmen 52 2011-10 Furniture & Household Equipmen 95 2016-7 Furniture & Household Equipmen 109 2021-4 Furniture & Household Equipmen 913 1992-11 Furniture & Household Equipmen 37 997-8 Furniture & Household Equipmen 14 9 2002-6 Furniture & Household Equipmen 55.7 2007-3 Furniture & Household Equipmen 2011-11 Furniture & Household Equipmen 95.8 2016-8 Furniture & Household Equipmen 109.8 2021-5 Furniture & Household Equipmen 97 3 1992-12 Furniture & Household Equipmen 43.2 1997-9 Furniture & Household Equipmen 2002-7 Furniture & Household Equipmen 56.6 2007-4 Furniture & Househol old Equipmen 2011-12 Furniture & Household Equipmer 2.5 2016-9 Furniture & Household Equipment 10 2021-6 Furniture & Household Equipmen 112.9 1995 1 Furniture & Household Equipmen 39.3 997-10 Furniture & Household Equipmen 49 2002-8 Furniture & Household Equipmen 54.9 2007-5 Furniture & Household Equipmen 61.2 2012-1 Furniture & Household Equipmen 97 2016-10 Furniture & Household Equipmen 107. 2021-7 Furniture & Household Equipmen 97.9 1993-2 Furniture & Household Equipmen 28.8 1997-11 Furniture & Household Equipmen 47.9 2002-9 Furniture & Household Equipmen 50.9 2007-6 Furniture & Household Equipmen 63.3 2012-2 Furniture & Household Equipmen 87.2 2016-11 Furniture & Household Equipmen 106.6 2021-8 Furniture & Household Equipmen 94.4 1935-3 Furniture & Household Equipmen 38.3 1997-12 Furniture & Household Equipmen 64.9 2002-10 Furniture & Household Equipmen 2007-7 Furniture & Household Equipmen 62 6 2012-3 Furniture & Household Equipmen 2.9 2016-12 Furniture & Household Equipmen 1321 2021-9 Furniture & Household Equipmen 913 993-4 37.8 1998-1 Furniture & Household Equipmen 2002-11 Furniture & Household Equipmen 59.6 2007-8 Furniture & Household Equipmen 615 2012-4 Furniture & Household Equipmen 93.7 2017-1 Furniture & Household Equipmen 120.4 Furniture & Household Equipmen 17.4 87.7 993-5 Furniture & Household Equipmen 37.9 1998-2 Furniture & Household Equipmen 5.7 2002-12 Furniture & Household Equipmen 81.5 2007-9 Furniture & Household Equipmen 58.6 2012-5 Furniture & Household Equipmen 2017-2 Furniture & Household Equipmen Furniture & Household Equipmen 35.7 1998-3 Furniture & Household Equipmen 2003-1 Furniture & Household Equipmen 15 2007-10 Furniture & Household Equipmen 68 5 2012-6 Furniture & Household Equipmen 2017-3 Furniture & Household Equipmen 103.8 993-7 Furniture & Household Equipmen 35.7 1998-4 Furniture & Household Equipmen 2.8 003-2 Furniture & Household Equipmen 54.4 2007-11 Furniture & Household Equipmen 75.8 2012-7 Furniture & Household Equipmen 18 2017-4 Furniture & Household Equipmen 98.7 Furniture & Household Equipmen 41.9 1998-5 Furniture & Household Equipmen 2003-3 Furniture & Household Equipmen 5.6 2007-12 Furniture & Household Equipmen 35.1 2012-8 Furniture & Household Equipmen 30.4 2017-5 Furniture & Household Equipmen 95.5 395-6 1993-9 Furniture & Household Equipmen 36 1 1998-6 Furniture & Household Equipmen 39 8 2003-4 Furniture & Household Equipmen 56 6 2008-1 Furniture & Household Equipmen 76.3 2012-9 Furniture & Household Equipmen 2017-6 Furniture & Household Equipmen Sheet 1 (+)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started