Where next? Identifying new supermarket locations for the Dairy Farm Group

• Main Authors: ANG, Marcus, CHEN, Yongchang, FOO, Yong Long
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 2020
• Subjects: Analytics; Predictive analytics; Big data; Retail; Consumer markets analysis; Business Administration, Management, and Operations; Operations and Supply Chain Management; Sales and Merchandising
• Online Access: https://ink.library.smu.edu.sg/cases_coll_all/320; https://smu.sharepoint.com/sites/admin/CMP/cases/SMU-20-BATCH%20%5BPDF-Pic%5D/SMU-20-0024%20%5BDairy%20Farm%5D/SMU-20-0024%20%5BDairy%20Farm%5D.pdf?CT=1599122331688&OR=ItemsView
• Institution: Singapore Management University

In its 2017 annual report, the Dairy Farm Group had reported a decline in sales and profits for its Singapore Supermarket and Hypermarket business, with increasing competition cited as the key reason for the lacklustre performance. Peter Goh, an analyst at Singapore Management University’s Institute of Service Excellence (ISE) has been tasked with preparing a business pitch to the Supermarkets and Hypermarkets division of the company’s Singapore office to help it address some of the challenges it faces. To help raise the performance of the service sector in Singapore, ISE conducts and releases the results of the Customer Satisfaction Index of Singapore (CSISG) to both the media and industry, as well as provides research and consulting services. The 2018 CSISG study had revealed “Ease of Getting to Stores” as one of the lowest-rated attributes for the supermarket industry, and Goh believes that rationalising store locations could be a possible answer to the challenges the Dairy Farm Group faced. In his opinion, a geospatial analysis of the company’s customers’ demographic profile relative to its current store locations would provide some key insights. Discussing the case will reinforce the students’ skills in data processing and data visualisation. Specifically, students will solve the problems using Tableau. After completing the student assignment questions, the students will be able to (a) understand the impact of data analysis in making decisions; (b) propose an explanation to the data using appropriate data visualisation tools; and (c) evaluate and derive insights from the given business problem.