Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

RSI RSI RSI RSI RSI RSI RSI GBA_Q2_InputFile Year-Mont Industry 1989-1 Furniture & Household Equipmen 1989-2 Furniture & Household Equipmen 1989-3 Furniture & Household Equipmen

image text in transcribedimage text in transcribed

RSI RSI RSI RSI RSI RSI RSI "GBA_Q2_InputFile" Year-Mont Industry 1989-1 Furniture & Household Equipmen 1989-2 Furniture & Household Equipmen 1989-3 Furniture & Household Equipmen 1989-4 Furniture & Household Equipmen 1989-5 Furniture & Household Equipmen 1989-6 Furniture & Household Equipmen 1989-7 Furniture & Household Equipmen 1989-8 Furniture & Household Equipmen 1989-9 Furniture & Household Equipmen 1989-10 Furniture & Household Equipmen 1989-11 Furniture & Household Equipmen 1989-12 Furniture & Household Equipmen 1990-1 Furniture & Household Equipmen 1990-2 Furniture & Household Equipmen 1990-3 Furniture & Household Equipmen 1990-4 Furniture & Household Equipmen 1990-5 Furniture & Household Equipmen 1990-6 Furniture & Household Equipmen 1990-7 Furniture & Household Equipmen 1990-8 Furniture & Household Equipmen 1990-9 Furniture & Household Equipmen 1990-10 Furniture & Household Equipmen 1990-11 Furniture & Household Equipmen 1990-12 Furniture & Household Equipmen 1991-1 Furniture & Household Equipmen 1991-2 Furniture & Household Equipmen 1991-3 Furniture & Household Equipmen 1991-4 Furniture & Household Equipmen 1991-5 Furniture & Household Equipmen 1991-6 Furniture & Household Equipmen 1991-7 Furniture & Household Equipmen 1991-8 Furniture & Household Equipmen 1991-9 Furniture & Household Equipmen 1991-10 Furniture & Household Equipmen 1991-11 Furniture & Household Equipmen 1991-12 Furniture & Household Equipmen 1992-1 Furniture & Household Equipmen 1992-2 Furniture & Household Equipmen 1992-3 Furniture & Household Equipmen 1992-4 Furniture & Household Equipmen 1992-5 Furniture & Household Equipmen 1992-6 Furniture & Household Equipmen 1992-7 Furniture & Household Equipmen 1992-8 Furniture & Household Equipmen 1992-9 Furniture & Household Equipmen 1992-10 Furniture & Household Equipmen 1992-11 Furniture & Household Equipmen 1992-12 Furniture & Household Equipmen 1993-1 Furniture & Household Equipmen 1993-2 Furniture & Household Equipmen 1993-3 Furniture & Household Equipmen 1993-4 Furniture & Household Equipmen 1993-5 Furniture & Household Equipmen 1993-6 Furniture & Household Equipmen 1993-7 Furniture & Household Equipmen 1993-8 Furniture & Household Equipmen 1993-9 Furniture & Household Equipmen Sheet1 54.5 44.1 43.8 42.7 48.5 40.9 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 37.2 37.9 37 43.2 39.3 28.8 38.3 37.8 37.9 35.7 35.7 41.9 36.1 Year-Mo Industry 1993-10 Furniture & Household Equipmen 1993-11 Furniture & Household Equipmen 1993-12 Furniture & Household Equipmen 1994-1 Furniture & Household Equipmen 1994-2 Furniture & Household Equipmen 1994-3 Furniture & Household Equipmen 1994-4 Furniture & Household Equipmen 1994-5 Furniture & Household Equipmen 1994-6 Furniture & Household Equipmen 1994-7 Furniture & Household Equipmen 1994-8 Furniture & Household Equipmen 1994-9 Furniture & Household Equipmen 1994-10 Furniture & Household Equipmen 1994-11 Furniture & Household Equipmen 1994-12 Furniture & Household Equipmen 1995-1 Furniture & Household Equipmen 1995-2 Furniture & Household Equipmen 1995-3 Furniture & Household Equipmen 1995-4 Furniture & Household Equipmen 1995-5 Furniture & Household Equipmen 1995-6 Furniture & Household Equipmen 1995-7 Furniture & Household Equipmen 1995-8 Furniture & Household Equipmen 1995-9 Furniture & Household Equipmen 1995-10 Furniture & Household Equipmen 1995-11 Furniture & Household Equipmen 1995-12 Furniture & Household Equipmen 1996-1 Furniture & Household Equipmen 1996-2 Furniture & Household Equipmen 1996-3 Furniture & Household Equipmen 1996-4 Furniture & Household Equipmen 1996-5 Furniture & Household Equipmen 1996-6 Furniture & Household Equipmen 1996-7 Furniture & Household Equipmen 1996-8 Furniture & Household Equipmen 1996-9 Furniture & Household Equipmen 1996-10 Furniture & Household Equipmen 1996-11 Furniture & Household Equipmen 1996-12 Furniture & Household Equipmen 1997-1 Furniture & Household Equipmen 1997-2 Furniture & Household Equipmen 1997-3 Furniture & Household Equipmen 1997-4 Furniture & Household Equipmen 1997-5 Furniture & Household Equipmen 1997-6 Furniture & Household Equipmen 1997-7 Furniture & Household Equipmen 1997-8 Furniture & Household Equipmen 1997-9 Furniture & Household Equipmen 1997-10 Furniture & Household Equipmen 1997-11 Furniture & Household Equipmen 1997-12 Furniture & Household Equipmen 1998-1 Furniture & Household Equipmen 1998-2 Furniture & Household Equipmen 1998-3 Furniture & Household Equipmen 1998-4 Furniture & Household Equipmen 1998-5 Furniture & Household Equipmen 1998-6 Furniture & Household Equipmen 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 40.9 42.9 42.7 41.3 45.6 44 45.6 52 49.5 40.3 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 Year-Mo Industry 1998-7 Furniture & Household Equipmen 1998-8 Furniture & Household Equipmen 1998-9 Furniture & Household Equipmen 1998-10 Furniture & Household Equipmen 1998-11 Furniture & Household Equipmen 1998-12 Furniture & Household Equipmen 1999-1 Furniture & Household Equipmen 1999-2 Furniture & Household Equipmen 1999-3 Furniture & Household Equipmen 1999-4 Furniture & Household Equipmen 1999-5 Furniture & Household Equipmen 1999-6 Furniture & Household Equipmen 1999-8 Furniture & Household Equipmen 1999-9 Furniture & Household Equipmen 1999-10 Furniture & Household Equipmen 1999-11 Furniture & Household Equipmen 1999-12 Furniture & Household Equipmen 2000-1 Furniture & Household Equipmen 2000-2 Furniture & Household Equipmen 2000-3 Furniture & Household Equipmen 2000-4 Furniture & Household Equipmen 2000-5 Furniture & Household Equipmen 2000-6 Furniture & Household Equipmen 2000-7 Furniture & Household Equipmen 2000-8 Furniture & Household Equipmen 2000-9 Furniture & Household Equipmen 2000-10 Furniture & Household Equipmen 2000-11 Furniture & Household Equipmen 2000-12 Furniture & Household Equipmen 2001-1 Furniture & Household Equipmen 2001-2 Furniture & Household Equipmen 2001-3 Furniture & Household Equipmen 2001-4 Furniture & Household Equipmen 2001-5 Furniture & Household Equipmen 2001-6 Furniture & Household Equipmen 2001-7 Furniture & Household Equipmen 2001-8 Furniture & Household Equipmen 2001-9 Furniture & Household Equipmen 2001-10 Furniture & Household Equipmen 2001-11 Furniture & Household Equipmen 2001-12 Furniture & Household Equipmen 2002-1 Furniture & Household Equipmen 2002-2 Furniture & Household Equipmen 2002-3 Furniture & Household Equipmen 2002-4 Furniture & Household Equipmen 2002-5 Furniture & Household Equipmen 2002-6 Furniture & Household Equipmen 2002-7 Furniture & Household Equipmen 2002-8 Furniture & Household Equipmen 2002-9 Furniture & Household Equipmen 2002-10 Furniture & Household Equipmen 2002-11 Furniture & Household Equipmen 2002-12 Furniture & Household Equipmen 2003-1 Furniture & Household Equipmen 2003-2 Furniture & Household Equipmen 2003-3 Furniture & Household Equipmen 2003-4 Furniture & Household Equipmen 41.1 37.7 43.9 46 40.1 56.4 56.9 40.9 47.2 36.9 44.3 47.9 45.6 47.1 46.1 50.4 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 56.6 Year-Mo Industry 2003-5 Furniture & Household Equipmen 2003-6 Furniture & Household Equipmen 2003-7 Furniture & Household Equipmen 2003-8 Furniture & Household Equipmen & 2003-9 Furniture & Household Equipmen 2003-10 Furniture & Household Equipmen 2003-11 Furniture & Household Equipmen 2003-12 Furniture & Household Equipmen 2004-1 Furniture & Household Equipmen 2004-2 Furniture & Household Equipmen 2004-3 Furniture & Household Equipmen 2004-4 Furniture & Household Equipmen 2004-5 Furniture & Household Equipmen 2004-6 Furniture & Household Equipmen 2004-7 Furniture & Household Equipmen 2004-8 Furniture & Household Equipmen 2004-9 Furniture & Household Equipmen 2004-10 Furniture & Household Equipmen 2004-11 Furniture & Household Equipmen 2004-12 Furniture & Household Equipmen 2005-1 Furniture & Household Equipmen 2005-2 Furniture & Household Equipmen 2005-3 Furniture & Household Equipmen 2005-4 Furniture & Household Equipmen 2005-5 Furniture & Household Equipmen 2005-6 Furniture & Household Equipmen 2005-7 Furniture & Household Equipmen 2005-8 Furniture & Household Equipmen 2005-9 Furniture & Household Equipmen 2005-10 Furniture & Household Equipmen 2005-11 Furniture & Household Equipmen 2005-12 Furniture & Household Equipmen 2006-1 Furniture & Household Equipmen 2006-2 Furniture & Household Equipmen 2006-3 Furniture & Household Equipmen 2006-4 Furniture & Household Equipmen 2006-5 Furniture & Household Equipmen 2006-6 Furniture & Household Equipmen 2006-7 Furniture & Household Equipmen 2006-8 Furniture & Household Equipmen 2006-9 Furniture & Household Equipmen 2006-10 Furniture & Household Equipmen 2006-11 Furniture & Household Equipmen 2006-12 Furniture & Household Equipmen 2007-1 Furniture & Household Equipmen 2007-2 Furniture & Household Equipmen 2007-3 Furniture & Household Equipmen 2007-4 Furniture & Household Equipmen 2007-5 Furniture & Household Equipmen 2007-6 Furniture & Household Equipmen 2007-7 Furniture & Household Equipmen 2007-8 Furniture & Household Equipmen 2007-9 Furniture & Household Equipmen 2007-10 Furniture & Household Equipmen 2007-11 Furniture & Household Equipmen 2007-12 Furniture & Household Equipmen 2008-1 Furniture & Household Equipmen 59.2 64.9 69.2 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 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 75.4 52 61 60 61.2 63.3 62.5 61.5 58.6 68.5 75.8 95.1 76.3 Year-Mo Industry 2008-2 Furniture & Household Equipmen 2008-3 Furniture & Household Equipmen 2008-4 Furniture & Household Equipmen 2008-5 Furniture & Household Equipmen 2008-6 Furniture & Household Equipmen 2008-7 Furniture & Household Equipmen 2008-8 Furniture & Household Equipmen 2008-9 Furniture & Household Equipmen & 2008-10 Furniture & Household Equipmen 2008-11 Furniture & Household Equipmen 2008-12 Furniture & Household Equipmen 2009-1 Furniture & Household Equipmen 2009-2 Furniture & Household Equipmen 2009-3 Furniture & Household Equipmen 2009.4 Furniture & Household Equipmen 2009-5 Furniture & Household Equipmen 2009-6 Furniture & Household Equipmen 2009-7 Furniture & Household Equipmen 2009-8 Furniture & Household Equipmen 2009-9 Furniture & Household Equipmen 2009-10 Furniture & Household Equipmen 2009-11 Furniture & Household Equipmen 2009-12 Furniture & Household Equipmen 2010-1 Furniture & Household Equipmen 2010-2 Furniture & Household Equipmen 2010-2 Furniture & Household Equipmen 2010-3 Furniture & Household Equipmen 2010-4 Furniture & Household Equipmen 2010-5 Furniture & Household Equipmen 2010-6 Furniture & Household Equipmen 2010-7 Furniture & Household Equipmen 2010-8 Furniture & Household Equipmen 2010-9 Furniture & Household Equipmen 2010-10 Furniture & Household Equipmen 2010-11 Furniture & Household Equipmen 2010-12 Furniture & Household Equipmen 2011-1 Furniture & Household Equipmen 2011-2 Furniture & Household Equipmen 2011-3 Furniture & Household Equipmen 2011-4 Furniture & Household Equipmen 2011-5 Furniture & Household Equipmen 2011-6 Furniture & Household Equipmen 2011-7 Furniture & Household Equipmen 2011-8 Furniture & Household Equipmen 2011-9 Furniture & Household Equipmen 2011-10 Furniture & Household Equipmen 2011-11 Furniture & Household Equipmen 2011-12 Furniture & Household Equipmen 2012-1 Furniture & Household Equipmen 2012-2 Furniture & Household Equipmen 2012-3 Furniture & Household Equipmen 2012-4 Furniture & Household Equipmen 2012-5 Furniture & Household Equipmen 2012-6 Furniture & Household Equipmen 2012-7 Furniture & Household Equipmen 2012-8 Furniture & Household Equipmen 2012-9 Furniture & Household Equipmen 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 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 92.8 96.8 117.5 93.6 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 Year-Mo Industry 2012-10 Furniture & Household Equipmen 2012-11 Furniture & Household Equipmen 2012-12 Furniture Furniture & Household Equipmen 2013-1 Furniture & Household Equipmen & 2013-2 Furniture & Household Equipmen 2013-3 Furniture & Household Equipmen 2013-4 Furniture & Household Equipmen 2013-5 Furniture & Household Equipmen 2013-6 Furniture & Household Equipmen 2013-7 Furniture & Household Equipmen & 2013-8 Furniture Furniture & Household Equipmen 2013-9 Furniture & Household Equipmen 2013-10 Furniture & Household Equipmen 2013-11 Furniture & Household Equipmen 2013-12 Furniture & Household Equipmen 2014-1 Furniture & Household Equipmen & 2014-2 Furniture & Household Equipmen 2014-3 Furniture & Household Equipmen 2014-4 Furniture & Household Equipmen 2014-5 Furniture & Household Equipmen 2014-6 Furniture & Household Equipmen 2014-7 Furniture & Household Equipmen 2014-8 Furniture & Household Equipmen 2014-9 Furniture & Household Equipmen 2014-10 Furniture & Household Equipmen 2014-11 Furniture & Household Equipmen 2014-12 Furniture & Household Equipmen 2015-1 Furniture & Household Equipmen 2015-2 Furniture & Household Equipmen 2015-3 Furniture & Household Equipmen 2015-4 Furniture & Household Equipmen 2015-5 Furniture & Household Equipmen 2015-6 Furniture & Household Equipmen 2015-7 Furniture & Household Equipmen 2015-8 Furniture & Household Equipmen 2015-9 Furniture & Household Equipmen 2015-10 Furniture & Household Equipmen 2015-11 Furniture & Household Equipmen 2015-12 Furniture & Household Equipmen 2016-1 Furniture & Household Equipmen 2016-2 Furniture & Household Equipmen 2016-3 Furniture & Household Equipmen 2016-4 Furniture & Household Equipmen 2016-5 Furniture & Household Equipmen 2016-6 Furniture & Household Equipmen 2016-7 Furniture & Household Equipmen 2016-8 Furniture & Household Equipmen 2016-9 Furniture & Household Equipmen 2016-10 Furniture & Household Equipmen 2016-11 Furniture & Household Equipmen 2016-12 Furniture & Household Equipmen 2017-1 Furniture & Household Equipmen 2017-2 Furniture & Household Equipmen 2017-3 Furniture & Household Equipmen 2017-4 Furniture & Household Equipmen 2017-5 Furniture & Household Equipmen 2017-6 Furniture & Household Equipmen 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.7 99.4 105.5 103.1 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 Year-Mo Industry 2017-7 Furniture & Household Equipmen 2017-8 Furniture & Household Equipmen 2017-9 Furniture & Household Equipmen 2017-10 Furniture & Household Equipmen 2017-11 Furniture & Household Equipmen 2017-12 Furniture & Household Equipmen 2018-1 Furniture & Household Equipmen 2018-2 Furniture & Household Equipmen 2018-3 Furniture & Household Equipmen 2018-4 Furniture & Household Equipmen 2018-5 Furniture & Household Equipmen 2018-6 Furniture & Household Equipmen 2018-7 Furniture & Household Equipmen 2018-8 Furniture & Household Equipmen 2018-9 Furniture & Household Equipmen 2018-10 Furniture & Household Equipmen 2018-11 Furniture & Household Equipmen 2018-12 Furniture & Household Equipmen 2019-1 Furniture & Household Equipmen 2019-2 Furniture & Household Equipmen 2019-3 Furniture & Household Equipmen 2019-4 Furniture & Household Equipmen 2019-5 Furniture & Household Equipmen 2019-6 Furniture & Household Equipmen 2019-7 Furniture & Household Equipmen 2019-8 Furniture & Household Equipmen 2019-9 Furniture & Household Equipmen 2019-10 Furniture & Household Equipmen 2019-11 Furniture & Household Equipmen 2019-12 Furniture & Household Equipmen 2020-1 Furniture & Household Equipmen 2020-2 Furniture & Household Equipmen 2020-3 Furniture & Household Equipmen 2020-4 Furniture & Household Equipmen 2020-5 Furniture & Household Equipmen 2020-6 Furniture & Household Equipmen & 2020-7 Furniture & Household Equipmen 2020-8 Furniture & Household Equipmen 2020-9 Furniture & Household Equipmen 2020-10 Furniture & Household Equipmen 2020-11 Furniture & Household Equipmen 2020-12 Furniture & Household Equipmen 2021-1 Furniture & Household Equipmen 2021-2 Furniture & Household Equipmen 2021-3 Furniture & Household Equipmen 2021-4 Furniture & Household Equipmen 2021-5 Furniture & Household Equipmen 2021-6 Furniture & Household Equipmen 2021-7 Furniture & Household Equipmen 2021-8 Furniture & Household Equipmen 2021-9 Furniture & Household Equipmen 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 95 91.3 92.6 96.9 115.1 115.6 75.4 92.2 88.9 95.5 106.4 103.4 89.4 92 91.7 95.9 120.8 105.8 79.6 94.8 91.3 97.3 112.9 97.9 94.4 91.3 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 02_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) Note: Do provide proper and adequate in-text citations and referencing to content drawn from course materials and other credible sources. RSI RSI RSI RSI RSI RSI RSI "GBA_Q2_InputFile" Year-Mont Industry 1989-1 Furniture & Household Equipmen 1989-2 Furniture & Household Equipmen 1989-3 Furniture & Household Equipmen 1989-4 Furniture & Household Equipmen 1989-5 Furniture & Household Equipmen 1989-6 Furniture & Household Equipmen 1989-7 Furniture & Household Equipmen 1989-8 Furniture & Household Equipmen 1989-9 Furniture & Household Equipmen 1989-10 Furniture & Household Equipmen 1989-11 Furniture & Household Equipmen 1989-12 Furniture & Household Equipmen 1990-1 Furniture & Household Equipmen 1990-2 Furniture & Household Equipmen 1990-3 Furniture & Household Equipmen 1990-4 Furniture & Household Equipmen 1990-5 Furniture & Household Equipmen 1990-6 Furniture & Household Equipmen 1990-7 Furniture & Household Equipmen 1990-8 Furniture & Household Equipmen 1990-9 Furniture & Household Equipmen 1990-10 Furniture & Household Equipmen 1990-11 Furniture & Household Equipmen 1990-12 Furniture & Household Equipmen 1991-1 Furniture & Household Equipmen 1991-2 Furniture & Household Equipmen 1991-3 Furniture & Household Equipmen 1991-4 Furniture & Household Equipmen 1991-5 Furniture & Household Equipmen 1991-6 Furniture & Household Equipmen 1991-7 Furniture & Household Equipmen 1991-8 Furniture & Household Equipmen 1991-9 Furniture & Household Equipmen 1991-10 Furniture & Household Equipmen 1991-11 Furniture & Household Equipmen 1991-12 Furniture & Household Equipmen 1992-1 Furniture & Household Equipmen 1992-2 Furniture & Household Equipmen 1992-3 Furniture & Household Equipmen 1992-4 Furniture & Household Equipmen 1992-5 Furniture & Household Equipmen 1992-6 Furniture & Household Equipmen 1992-7 Furniture & Household Equipmen 1992-8 Furniture & Household Equipmen 1992-9 Furniture & Household Equipmen 1992-10 Furniture & Household Equipmen 1992-11 Furniture & Household Equipmen 1992-12 Furniture & Household Equipmen 1993-1 Furniture & Household Equipmen 1993-2 Furniture & Household Equipmen 1993-3 Furniture & Household Equipmen 1993-4 Furniture & Household Equipmen 1993-5 Furniture & Household Equipmen 1993-6 Furniture & Household Equipmen 1993-7 Furniture & Household Equipmen 1993-8 Furniture & Household Equipmen 1993-9 Furniture & Household Equipmen Sheet1 54.5 44.1 43.8 42.7 48.5 40.9 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 37.2 37.9 37 43.2 39.3 28.8 38.3 37.8 37.9 35.7 35.7 41.9 36.1 Year-Mo Industry 1993-10 Furniture & Household Equipmen 1993-11 Furniture & Household Equipmen 1993-12 Furniture & Household Equipmen 1994-1 Furniture & Household Equipmen 1994-2 Furniture & Household Equipmen 1994-3 Furniture & Household Equipmen 1994-4 Furniture & Household Equipmen 1994-5 Furniture & Household Equipmen 1994-6 Furniture & Household Equipmen 1994-7 Furniture & Household Equipmen 1994-8 Furniture & Household Equipmen 1994-9 Furniture & Household Equipmen 1994-10 Furniture & Household Equipmen 1994-11 Furniture & Household Equipmen 1994-12 Furniture & Household Equipmen 1995-1 Furniture & Household Equipmen 1995-2 Furniture & Household Equipmen 1995-3 Furniture & Household Equipmen 1995-4 Furniture & Household Equipmen 1995-5 Furniture & Household Equipmen 1995-6 Furniture & Household Equipmen 1995-7 Furniture & Household Equipmen 1995-8 Furniture & Household Equipmen 1995-9 Furniture & Household Equipmen 1995-10 Furniture & Household Equipmen 1995-11 Furniture & Household Equipmen 1995-12 Furniture & Household Equipmen 1996-1 Furniture & Household Equipmen 1996-2 Furniture & Household Equipmen 1996-3 Furniture & Household Equipmen 1996-4 Furniture & Household Equipmen 1996-5 Furniture & Household Equipmen 1996-6 Furniture & Household Equipmen 1996-7 Furniture & Household Equipmen 1996-8 Furniture & Household Equipmen 1996-9 Furniture & Household Equipmen 1996-10 Furniture & Household Equipmen 1996-11 Furniture & Household Equipmen 1996-12 Furniture & Household Equipmen 1997-1 Furniture & Household Equipmen 1997-2 Furniture & Household Equipmen 1997-3 Furniture & Household Equipmen 1997-4 Furniture & Household Equipmen 1997-5 Furniture & Household Equipmen 1997-6 Furniture & Household Equipmen 1997-7 Furniture & Household Equipmen 1997-8 Furniture & Household Equipmen 1997-9 Furniture & Household Equipmen 1997-10 Furniture & Household Equipmen 1997-11 Furniture & Household Equipmen 1997-12 Furniture & Household Equipmen 1998-1 Furniture & Household Equipmen 1998-2 Furniture & Household Equipmen 1998-3 Furniture & Household Equipmen 1998-4 Furniture & Household Equipmen 1998-5 Furniture & Household Equipmen 1998-6 Furniture & Household Equipmen 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 40.9 42.9 42.7 41.3 45.6 44 45.6 52 49.5 40.3 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 Year-Mo Industry 1998-7 Furniture & Household Equipmen 1998-8 Furniture & Household Equipmen 1998-9 Furniture & Household Equipmen 1998-10 Furniture & Household Equipmen 1998-11 Furniture & Household Equipmen 1998-12 Furniture & Household Equipmen 1999-1 Furniture & Household Equipmen 1999-2 Furniture & Household Equipmen 1999-3 Furniture & Household Equipmen 1999-4 Furniture & Household Equipmen 1999-5 Furniture & Household Equipmen 1999-6 Furniture & Household Equipmen 1999-8 Furniture & Household Equipmen 1999-9 Furniture & Household Equipmen 1999-10 Furniture & Household Equipmen 1999-11 Furniture & Household Equipmen 1999-12 Furniture & Household Equipmen 2000-1 Furniture & Household Equipmen 2000-2 Furniture & Household Equipmen 2000-3 Furniture & Household Equipmen 2000-4 Furniture & Household Equipmen 2000-5 Furniture & Household Equipmen 2000-6 Furniture & Household Equipmen 2000-7 Furniture & Household Equipmen 2000-8 Furniture & Household Equipmen 2000-9 Furniture & Household Equipmen 2000-10 Furniture & Household Equipmen 2000-11 Furniture & Household Equipmen 2000-12 Furniture & Household Equipmen 2001-1 Furniture & Household Equipmen 2001-2 Furniture & Household Equipmen 2001-3 Furniture & Household Equipmen 2001-4 Furniture & Household Equipmen 2001-5 Furniture & Household Equipmen 2001-6 Furniture & Household Equipmen 2001-7 Furniture & Household Equipmen 2001-8 Furniture & Household Equipmen 2001-9 Furniture & Household Equipmen 2001-10 Furniture & Household Equipmen 2001-11 Furniture & Household Equipmen 2001-12 Furniture & Household Equipmen 2002-1 Furniture & Household Equipmen 2002-2 Furniture & Household Equipmen 2002-3 Furniture & Household Equipmen 2002-4 Furniture & Household Equipmen 2002-5 Furniture & Household Equipmen 2002-6 Furniture & Household Equipmen 2002-7 Furniture & Household Equipmen 2002-8 Furniture & Household Equipmen 2002-9 Furniture & Household Equipmen 2002-10 Furniture & Household Equipmen 2002-11 Furniture & Household Equipmen 2002-12 Furniture & Household Equipmen 2003-1 Furniture & Household Equipmen 2003-2 Furniture & Household Equipmen 2003-3 Furniture & Household Equipmen 2003-4 Furniture & Household Equipmen 41.1 37.7 43.9 46 40.1 56.4 56.9 40.9 47.2 36.9 44.3 47.9 45.6 47.1 46.1 50.4 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 56.6 Year-Mo Industry 2003-5 Furniture & Household Equipmen 2003-6 Furniture & Household Equipmen 2003-7 Furniture & Household Equipmen 2003-8 Furniture & Household Equipmen & 2003-9 Furniture & Household Equipmen 2003-10 Furniture & Household Equipmen 2003-11 Furniture & Household Equipmen 2003-12 Furniture & Household Equipmen 2004-1 Furniture & Household Equipmen 2004-2 Furniture & Household Equipmen 2004-3 Furniture & Household Equipmen 2004-4 Furniture & Household Equipmen 2004-5 Furniture & Household Equipmen 2004-6 Furniture & Household Equipmen 2004-7 Furniture & Household Equipmen 2004-8 Furniture & Household Equipmen 2004-9 Furniture & Household Equipmen 2004-10 Furniture & Household Equipmen 2004-11 Furniture & Household Equipmen 2004-12 Furniture & Household Equipmen 2005-1 Furniture & Household Equipmen 2005-2 Furniture & Household Equipmen 2005-3 Furniture & Household Equipmen 2005-4 Furniture & Household Equipmen 2005-5 Furniture & Household Equipmen 2005-6 Furniture & Household Equipmen 2005-7 Furniture & Household Equipmen 2005-8 Furniture & Household Equipmen 2005-9 Furniture & Household Equipmen 2005-10 Furniture & Household Equipmen 2005-11 Furniture & Household Equipmen 2005-12 Furniture & Household Equipmen 2006-1 Furniture & Household Equipmen 2006-2 Furniture & Household Equipmen 2006-3 Furniture & Household Equipmen 2006-4 Furniture & Household Equipmen 2006-5 Furniture & Household Equipmen 2006-6 Furniture & Household Equipmen 2006-7 Furniture & Household Equipmen 2006-8 Furniture & Household Equipmen 2006-9 Furniture & Household Equipmen 2006-10 Furniture & Household Equipmen 2006-11 Furniture & Household Equipmen 2006-12 Furniture & Household Equipmen 2007-1 Furniture & Household Equipmen 2007-2 Furniture & Household Equipmen 2007-3 Furniture & Household Equipmen 2007-4 Furniture & Household Equipmen 2007-5 Furniture & Household Equipmen 2007-6 Furniture & Household Equipmen 2007-7 Furniture & Household Equipmen 2007-8 Furniture & Household Equipmen 2007-9 Furniture & Household Equipmen 2007-10 Furniture & Household Equipmen 2007-11 Furniture & Household Equipmen 2007-12 Furniture & Household Equipmen 2008-1 Furniture & Household Equipmen 59.2 64.9 69.2 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 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 75.4 52 61 60 61.2 63.3 62.5 61.5 58.6 68.5 75.8 95.1 76.3 Year-Mo Industry 2008-2 Furniture & Household Equipmen 2008-3 Furniture & Household Equipmen 2008-4 Furniture & Household Equipmen 2008-5 Furniture & Household Equipmen 2008-6 Furniture & Household Equipmen 2008-7 Furniture & Household Equipmen 2008-8 Furniture & Household Equipmen 2008-9 Furniture & Household Equipmen & 2008-10 Furniture & Household Equipmen 2008-11 Furniture & Household Equipmen 2008-12 Furniture & Household Equipmen 2009-1 Furniture & Household Equipmen 2009-2 Furniture & Household Equipmen 2009-3 Furniture & Household Equipmen 2009.4 Furniture & Household Equipmen 2009-5 Furniture & Household Equipmen 2009-6 Furniture & Household Equipmen 2009-7 Furniture & Household Equipmen 2009-8 Furniture & Household Equipmen 2009-9 Furniture & Household Equipmen 2009-10 Furniture & Household Equipmen 2009-11 Furniture & Household Equipmen 2009-12 Furniture & Household Equipmen 2010-1 Furniture & Household Equipmen 2010-2 Furniture & Household Equipmen 2010-2 Furniture & Household Equipmen 2010-3 Furniture & Household Equipmen 2010-4 Furniture & Household Equipmen 2010-5 Furniture & Household Equipmen 2010-6 Furniture & Household Equipmen 2010-7 Furniture & Household Equipmen 2010-8 Furniture & Household Equipmen 2010-9 Furniture & Household Equipmen 2010-10 Furniture & Household Equipmen 2010-11 Furniture & Household Equipmen 2010-12 Furniture & Household Equipmen 2011-1 Furniture & Household Equipmen 2011-2 Furniture & Household Equipmen 2011-3 Furniture & Household Equipmen 2011-4 Furniture & Household Equipmen 2011-5 Furniture & Household Equipmen 2011-6 Furniture & Household Equipmen 2011-7 Furniture & Household Equipmen 2011-8 Furniture & Household Equipmen 2011-9 Furniture & Household Equipmen 2011-10 Furniture & Household Equipmen 2011-11 Furniture & Household Equipmen 2011-12 Furniture & Household Equipmen 2012-1 Furniture & Household Equipmen 2012-2 Furniture & Household Equipmen 2012-3 Furniture & Household Equipmen 2012-4 Furniture & Household Equipmen 2012-5 Furniture & Household Equipmen 2012-6 Furniture & Household Equipmen 2012-7 Furniture & Household Equipmen 2012-8 Furniture & Household Equipmen 2012-9 Furniture & Household Equipmen 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 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 92.8 96.8 117.5 93.6 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 Year-Mo Industry 2012-10 Furniture & Household Equipmen 2012-11 Furniture & Household Equipmen 2012-12 Furniture Furniture & Household Equipmen 2013-1 Furniture & Household Equipmen & 2013-2 Furniture & Household Equipmen 2013-3 Furniture & Household Equipmen 2013-4 Furniture & Household Equipmen 2013-5 Furniture & Household Equipmen 2013-6 Furniture & Household Equipmen 2013-7 Furniture & Household Equipmen & 2013-8 Furniture Furniture & Household Equipmen 2013-9 Furniture & Household Equipmen 2013-10 Furniture & Household Equipmen 2013-11 Furniture & Household Equipmen 2013-12 Furniture & Household Equipmen 2014-1 Furniture & Household Equipmen & 2014-2 Furniture & Household Equipmen 2014-3 Furniture & Household Equipmen 2014-4 Furniture & Household Equipmen 2014-5 Furniture & Household Equipmen 2014-6 Furniture & Household Equipmen 2014-7 Furniture & Household Equipmen 2014-8 Furniture & Household Equipmen 2014-9 Furniture & Household Equipmen 2014-10 Furniture & Household Equipmen 2014-11 Furniture & Household Equipmen 2014-12 Furniture & Household Equipmen 2015-1 Furniture & Household Equipmen 2015-2 Furniture & Household Equipmen 2015-3 Furniture & Household Equipmen 2015-4 Furniture & Household Equipmen 2015-5 Furniture & Household Equipmen 2015-6 Furniture & Household Equipmen 2015-7 Furniture & Household Equipmen 2015-8 Furniture & Household Equipmen 2015-9 Furniture & Household Equipmen 2015-10 Furniture & Household Equipmen 2015-11 Furniture & Household Equipmen 2015-12 Furniture & Household Equipmen 2016-1 Furniture & Household Equipmen 2016-2 Furniture & Household Equipmen 2016-3 Furniture & Household Equipmen 2016-4 Furniture & Household Equipmen 2016-5 Furniture & Household Equipmen 2016-6 Furniture & Household Equipmen 2016-7 Furniture & Household Equipmen 2016-8 Furniture & Household Equipmen 2016-9 Furniture & Household Equipmen 2016-10 Furniture & Household Equipmen 2016-11 Furniture & Household Equipmen 2016-12 Furniture & Household Equipmen 2017-1 Furniture & Household Equipmen 2017-2 Furniture & Household Equipmen 2017-3 Furniture & Household Equipmen 2017-4 Furniture & Household Equipmen 2017-5 Furniture & Household Equipmen 2017-6 Furniture & Household Equipmen 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.7 99.4 105.5 103.1 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 Year-Mo Industry 2017-7 Furniture & Household Equipmen 2017-8 Furniture & Household Equipmen 2017-9 Furniture & Household Equipmen 2017-10 Furniture & Household Equipmen 2017-11 Furniture & Household Equipmen 2017-12 Furniture & Household Equipmen 2018-1 Furniture & Household Equipmen 2018-2 Furniture & Household Equipmen 2018-3 Furniture & Household Equipmen 2018-4 Furniture & Household Equipmen 2018-5 Furniture & Household Equipmen 2018-6 Furniture & Household Equipmen 2018-7 Furniture & Household Equipmen 2018-8 Furniture & Household Equipmen 2018-9 Furniture & Household Equipmen 2018-10 Furniture & Household Equipmen 2018-11 Furniture & Household Equipmen 2018-12 Furniture & Household Equipmen 2019-1 Furniture & Household Equipmen 2019-2 Furniture & Household Equipmen 2019-3 Furniture & Household Equipmen 2019-4 Furniture & Household Equipmen 2019-5 Furniture & Household Equipmen 2019-6 Furniture & Household Equipmen 2019-7 Furniture & Household Equipmen 2019-8 Furniture & Household Equipmen 2019-9 Furniture & Household Equipmen 2019-10 Furniture & Household Equipmen 2019-11 Furniture & Household Equipmen 2019-12 Furniture & Household Equipmen 2020-1 Furniture & Household Equipmen 2020-2 Furniture & Household Equipmen 2020-3 Furniture & Household Equipmen 2020-4 Furniture & Household Equipmen 2020-5 Furniture & Household Equipmen 2020-6 Furniture & Household Equipmen & 2020-7 Furniture & Household Equipmen 2020-8 Furniture & Household Equipmen 2020-9 Furniture & Household Equipmen 2020-10 Furniture & Household Equipmen 2020-11 Furniture & Household Equipmen 2020-12 Furniture & Household Equipmen 2021-1 Furniture & Household Equipmen 2021-2 Furniture & Household Equipmen 2021-3 Furniture & Household Equipmen 2021-4 Furniture & Household Equipmen 2021-5 Furniture & Household Equipmen 2021-6 Furniture & Household Equipmen 2021-7 Furniture & Household Equipmen 2021-8 Furniture & Household Equipmen 2021-9 Furniture & Household Equipmen 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 95 91.3 92.6 96.9 115.1 115.6 75.4 92.2 88.9 95.5 106.4 103.4 89.4 92 91.7 95.9 120.8 105.8 79.6 94.8 91.3 97.3 112.9 97.9 94.4 91.3 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 02_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) Note: Do provide proper and adequate in-text citations and referencing to content drawn from course materials and other credible sources

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Industrial Organizational Psychology An Applied Approach

Authors: Michael Aamodt

7th Edition

1111839972, 9781111839970

More Books

Students also viewed these Accounting questions

Question

Understand the basic theories and concepts of OD

Answered: 1 week ago