Tommy has recently graduated from SUSS and has joined a well-known retailer that operates 3...
70.2K
Verified Solution
Link Copied!
Question
Accounting
Tommy has recently graduated from SUSS and has joined a well-known retailer that operates 3 department stores in Singapore. His job function is that of a business analyst. It has been well-reported that retail business in Singapore is on the decline and his employer would like to determine if the forecast for the next few years will be equally bad. Tommy has been tasked to perform the analysis and his output will provide insights in the companys hiring and expansion plan in Singapore. The first thing Tommy did was to download the Retail Sales Index data from the Department of Statistics Singapore website. He specifically extracted the data for Department Stores from Q1 2008 to Q4 2018. (2017 is set as the base year with Index = 100). Refer to file: BUS107_GBA_RSIData.xls.
Use the techniques of time series modelling and with justifications, discuss the considerations on how Tommy would forecast the quarterly Retail Sales Index in 2019 and 2020.
Year/Quarter
Retail Sales Index (Department Stores)
2008 1Q
92.4
2008 2Q
93
2008 3Q
84.9
2008 4Q
105.3
2009 1Q
87.1
2009 2Q
88.6
2009 3Q
83.2
2009 4Q
103.6
2010 1Q
94.3
2010 2Q
93.9
2010 3Q
90.7
2010 4Q
109.3
2011 1Q
99.6
2011 2Q
99
2011 3Q
95.8
2011 4Q
119.3
2012 1Q
104.9
2012 2Q
99.9
2012 3Q
95
2012 4Q
117
2013 1Q
106.1
2013 2Q
100.9
2013 3Q
97.5
2013 4Q
118.6
2014 1Q
107.1
2014 2Q
98.7
2014 3Q
95.7
2014 4Q
117.6
2015 1Q
108.2
2015 2Q
101.1
2015 3Q
98.8
2015 4Q
114.4
2016 1Q
103.8
2016 2Q
93.9
2016 3Q
93.2
2016 4Q
112.9
2017 1Q
100.3
2017 2Q
93
2017 3Q
94.6
2017 4Q
112.1
2018 1Q
102.7
2018 2Q
92.3
2018 3Q
93.6
2018 4Q
112.8
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!