Tommy has recently graduated from SUSS and has joined a well-known retailer that operates 3 department...

60.1K

Verified Solution

Question

Basic Math

Tommy has recently graduated from SUSS and has joined awell-known retailer that operates 3 department stores in Singapore.His job function is that of a business analyst. It has beenwell-reported that retail business in Singapore is on the declineand his employer would like to determine if the forecast for thenext few years will be equally bad. Tommy has been tasked toperform the analysis and his output will provide insights in thecompany's hiring and expansion plan in Singapore.

The first thing Tommy did was to download the Retail Sales Indexdata from the Department of Statistics Singapore website. Hespecifically extracted the data for "Department Stores" from Q12008 to Q4 2018. (2017 is set as the base year with Index = 100).Refer to data below:

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

(a) Use the techniques of time series modelling and withjustifications, discuss the considerations on how Tommy wouldforecast the quarterly Retail Sales Index in 2019 and2020.

(b) Upon confirmation of the forecast technique to undertake inPart 3(a), determine the quarterlyRSI forecast in 2019 and 2020. You are required to showthe essential steps in deriving the forecast and comment on anylimitations of your technique.

Answer & Explanation Solved by verified expert
4.5 Ratings (1050 Votes)
aTommy can forecast the retail sales index by using theexponential smoothing forecasting    See Answer
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!
Become a Member

Other questions asked by students