Case Study
Questions
Case Study (Background to Furphy)
Furphy is one of Australia's leading supermarket chains. There are 700 stores in the chain. Originating from a family based chain of general stores, Furphy now has stores all over Australia, with the first one being established 27 years ago. Regarding operation, individual store management has wide-ranging powers about the day-to-day operations of their stores. However, Furphy’s strategic planning and direction take place in the company Head Office in Melbourne. In 2016, Furphy Head Office asked all store managers to add an online channel to their stores to enable customers, in their suburbs, to make their purchase online. Despite their successful operations and solid financial turnovers in the last two years, Furphy is forecasting a shift in the business climate within the next five years. This is a result of ever-increasing competition in the grocery supermarket sector. Now more than ever, Furphy management feels the need to ensure a good understanding of their business performance. The Furphy Head Office is slightly confused about the lack of enthusiasm of store managers to open their online sales channel given that Furphy Head office has invested heavily on a digital platform and distribution partnership with a transport company. Also, they are planning to put in place a formal procedure to forecast their Sales. Subsequently, Furphy has approached BEAUTIFUL-DATA (a market research company) and asked them to conduct a study to understand the characteristics of Furphy’s stores and their business performance.
The Data For this study, BEAUTIFUL-DATA has collected two sets of Data:
1. The data related to stores were extracted from the Furphy’sdatamarts. It is a random sample of 150 stores in the Furphy chain. A complete listing of variables, their definitions, and an explanation of their coding are provided in Working Sheet “Stores-Variable Description. 2. Time-series data is available on Working Sheet “Quarterly Sales”.
Your Role as a BEAUTIFUL-DATA Data Analyst Intern
- You are a Master of Business Analytics student doing an internship at BEAUTIFUL-DATA. The research team manager (Todd Nash, with a PhD in Data Science and a Master Degree in Digital Marketing) has asked you to lead the data analysis process for the Furphy project and directly report the results to him. You and Todd just finished a meeting wherein he briefed you on the vital purpose of the project. Todd explained that a model should be built to estimate Furphy’s Sales. Therefore, the first goal is to identify key factors that influence Sales. The second goal is to understand the relationship between number of competitors and Sales. He is also interested in gaining insights into factors that influence Furphy stores to open online sales channels. The final goal is to construct a forecasting model, which forecast Furphy’s Sales in the upcoming four quarters. From these insights, Todd and consequently Furphy will be in an excellent position to develop plans for the next financial year.
- MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018
- Todd also allocated relevant research tasks and explained his expectations from your analysis in the meeting. Minutes of this meeting are available on the next page. Now, your job is to review and complete the allocated tasks as per this document
2. Identify potential factors that may influence Sales: 2.1. An appropriate statistical technique could be used here to identify a list of possible factors. 2.2. Build a model (through a model building process) to estimate Sales. 2.3. Todd has done a regression analysis to predict sales using number of competitors and stores open on Sundays. He believes that the relationship between number of competitors and sales should be weaker for those stores that are open on Sundays. Your task here is to test Todd’s assumption by modelling the interaction between the predictors mentioned above and the target variable. Comment whether there is sufficient evidence that the interaction term makes a significant contribution to the model.
3. Finalise the model to predict the likelihood of opening an online sales channel: 3.1. Todd has already done an initial analysis for this task. Based on his analysis, Todd has narrowed down the key predictors of the likelihood of opening an online sales channel to “Manager’s Age, Experience and Gender”. Your task now is to continue his work and develop a predictive model to ascertain the
Solution
INTRODUCTION
Furphy is Australia’s leading market chain which consists of almost 700 stores in different countries of Australia. Furphy has many stores in all over Australia, which was being established 27 years ago.
In 2016, Furphy Head Office requested that all store chiefs add an online channel to their stores to empower clients, in their rural areas, to make their buy on the web.
Regardless of their fruitful activities and strong money related turnovers over the most recent two years, Furphy is anticipating a move in the business atmosphere inside the following five years. This is a consequence of consistently expanding rivalry in the basic need grocery store part. Presently like never before, Furphy administration wants to guarantee a decent comprehension of their business execution. The Furphy Head Office is marginally confounded about the absence of energy of store chiefs to open their online deals channel given that Furphy Head office has contributed vigorously on a computerized stage and circulation organization with a vehicle organization. Likewise, they are intending to set up a formal technique to figure their Sales.
Planning for efficient supermarket sales must be based on valid data. Economic data such as gross sales, gross profits, and other indicators of store productivity are gathered internally by management. The computer age allows management to generate numerous data characteristics and statistics.
Mail and phone reviews of buyers, both among a store's clients and its noncustomers, are another wellspring of data helpful in making and checking the promoting plan. Review information encourage the assurance of purchaser mindfulness, mentalities and shopping exercises.
Food merchant affiliations, exchange magazines, specialists and others lead ventures which create industry information. This auxiliary information could conceivably be relevant to a particular general store in its arranging procedure. Both essential and auxiliary information are required for successful market arranging.
This report depicts a pilot venture which executed client perception philosophy and broke down information utilizing a smaller than expected PC and a factual programming bundle.
ANALYSIS
There are points of interest to disentangling the accumulation of research information. However there is additionally a need to keep up a level of legitimacy in the examination resulta. Ordinarily there is a need or want for general store administration as well as workers to lead examine so as to acquire data in an opportune and compelling design.
Perception research can be defended as far as its opportunity and cost. Store workers can be prepared to lead perception inquire about. Modern investigation or basic counts of the information can be made. Each outcome can be a significant snippet of data which administration can use to decide shopping designs, portray customers, profile showcase fragments, and gain understanding into store format, publicizing and limited time methodologies.
Client perceptions ought to be viewed as a methods for setting up correspondence with the buyer. Correspondence uses and transports data starting with one chief then onto the next. Correspondence is a basic instrument in administration basic leadership. Coordinate perception of unmistakable conduct can be translated and "encoded" to encourage correspondence among purchaser and onlooker.
Correspondence with purchasers is basic to productive business administration. Two way correspondence is critical. However, does this correspondence need to be immediate? Would it be able to be watched, deciphered and responded to so as to finish the correspondence cycle?
In general stores today, customers respond to numerous components high costs, low quality and poor administration. Administration needs to decide issues in some way and afterward to find a way to diminish the quantity of protests or perhaps dispense with them. This procedure includes the nearness of two-way correspondence. This two-way correspondence can be expert by implication by the two gatherings. The client can convey through activities which are detectable. Administration, thusly, can impart through its response to the watched activities of the buyer.
Project Goal
The objective of this examination venture was "to decide the potential part of the perception technique in creating market arranging data."
The exploration destinations of this undertaking were
