Tesco PLC Case Study - Accounting and Finance Assignment Help

Assignment Task

Assurance of Learning
This assignment assesses following Graduate Learning Outcomes and related Unit Learning Outcomes:
Graduate Learning Outcome (GLO)

GLO1: Discipline-specific knowledge and capabilities: appropriate to the level of study related to a discipline or profession.
GLO2: Communication: using oral, written and interpersonal communication to inform, motivate and effect change
GLO3: Digital literacy: using technologies to find, use and disseminate information
GLO5: Problem Solving: creating solutions to authentic (real world and ill define) problems.
Unit Learning Outcome (ULO)

ULO1: To apply analytics models to a wide range of marketing activities
ULO2: Use computer software to analyse consumers’ data and understand the strength and limitations of each software
ULO3: Analyse and interpret the output of a range of Customer analytics modelsin
order to improve the decision making process ULO4: Demonstrate comprehensive understanding of Customer analyticsmodels
ULO5: Demonstrate ability to communicate the findings in writing in a way
that is useful for both academics and practitioners.

Feedback

Prior to submission
Students are able to seek assistance from the teaching staff to ascertain whether the assignment conforms to submission guidelines. 
After submission
In order to understand any areas of improvement, students are expected to refer, and compare, their answers to the suggested solutions.
Case Study

Tesco PLC is a British multinational supermarket chain headquartered in Welwyn Garden City, Hertfordshire, England, United Kingdom. It is the third largest retailer in the world measured by profits and second-largest retailer in the world measured by revenues. It has stores in 12 countries across Asia and Europe and is the grocery market leader in the UK, Ireland, Hungary, Malaysia, and Thailand. The company currently offers products in nine different categories including Apparel, Bakery, Deli, Dairy, Fresh Produce, General Merchandise, Grocery, Liquor, and Meat.
Tesco launched its customer loyalty scheme, the Tesco Clubcard, in 1995, with two levels (Silver and Gold). It has been cited as a pivotal development in Tesco's progress towards becoming the UK's largest supermarket chain and one that fundamentally changed the country's supermarket business. Cardholders can collect one Clubcard point for every £1 they spend in a Tesco store, or at Tesco.com. This enables the company to collect data on purchasebe haviour of customers and utilizeit to design customized offers and conduct targeted retention campaigns.
Data
The data of this assessment task relates to a random sample of 30,000 customers from Tesco Clubcard (20,000 training set & 10,000 test set) in a period from 1 January 2015 to 31 December 2015. The 18 variables in the data table are described below:

Analysis Tasks
1- Construct a model to predict customer churn using logistic regression and evaluate the performance of the constructed model on the hold outs ample provided (use metrics related to confusion matrix).
2- Evaluate the performance of the constructed model agains tthe RFM method (use lift chart-
i.e. concentration to make the comparison).
Report Tasks
1- Introduction and problemdefinition
2- Literature review: Use only academic journal articles. APA style should be used for referencing.
3- Methodology and empirical study: this should include a discussion of your analytical techniques, your model evaluation metrics, your working data, and your model building process.
4- Results: evaluate your analysis results to explain how your constructed models perform and also how they are positioned against a base model (randomguessing).
5- ConclusionandRecommendations:Thisshouldconsidertheimplicationsofyourresultsand how they may reduce marketing expenditure and contribute to customerretention.

Submission
The assignment consists of two parts: Analysis and Report.

You are required to submit both your written report (approx. 3000 words) and analysis file (conducted in Excel).

• Analysis
Students are expected to complete the analysis tasks in Excel and on the training and test datasets. The analysis file is expected to be a part of your submission.
Before submitting your analysis make sure it is logically organised and any incorrect or unnecessary output has been removed. In your Excel file all calculated figures are expected to be tied to appropriate Excel functions.

• Report
The report should be written based on your analysis output and be formatted as an academic report (journal/conference paper).
 

This Accounting and Finance Assignment has been solved by our Accounting and Finance Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.