Data-based Decision Making in Business

This document provides insights into data-based decision making in business and its importance. It discusses the key sources and flows of data in the decision making process and explores how a big data analytics framework can be implemented in an organization. The document also focuses on Tesco's data analytics framework and its implementation, as well as the data protection and ethical considerations in data analytics. It concludes by discussing how big data can improve decision making in Tesco.

Arden University
1

Executive Summary
Data-based decision making (DDDM) is an approach that involves the collection of information that
relies on key performance indicators or measurable indicators, the dissemination of examples and
real from these experiences and the used to create techniques and exercises for the benefit of the
business in various sectors.
Be that as it may, in order to separate the qualified inspiration from your information, it must be
accurate as applicable to your points. Collecting, separating, sorting and analyzing pieces of
information to develop knowledge-based dynamics in the business world was at the same time a
largely inclusive enterprise, which is usually different from the overall dynamic approach.
2

1. What are the key sources and flows of data that are collected,
processed, stored and taken into account in the organisation’s
decision making process?
1.1. Background to the case
The organisation which is selected to be audited in this audit report is Tesco group. Tesco Group is a
group of organisations which includes retail company “Tesco PLC” and a financial institution named
Tesco Bank. Tesco PLC is a British multinational groceries and general merchandise retailer. This
company has its headquarters in England, United Kingdom and this company was formed in 1919.
The key products and services of this company include groceries, home appliances, general
merchandising and many more. The products and services of Tesco Bank includes saving and credit
of money along with products such as credit and debit cards (Ataman, Kulick and Sim, 2011).
There are two markets in which Tesco PLC operates; the first market is the retail industry in which
Tesco PLC operates. The countries to which operations of Tesco PLC are limited include United
Kingdom, United States of America, India, Spain, France, China and many more. The second market
in which Tesco operates is retail banking market. In this market, Tesco Bank operates and its
functions are limited to the region of United Kingdom only.
Instead of being operating in multiple countries, most of the operations of Tesco PLC are limited to
United Kingdom only and due to political stability of this region, there are various issues and
challenges which are being faced by Tesco(Arganda-Carreras and et. al., 2017). Tesco is a large scale
company which is impacted by every action of government. Due to BREXIT implementation,
improvement and growth ratio of Tesco has already been reduced till 2019. 2020 was the healing
year of TESCO, but due to current pandemic caused because of COVID 19, the declining of growth
continues in 2020 as well. This company is facing issues of increasing debts and reducing return on
capital employed. The revenues and profits of Tesco PLC are continuously increasing but these
profits are not compatible with the increasing number of stores of this company. The increment
trend of profits is positive but the pace of increment is decreasing.
1.2. Audit of key data sources
Financial data sources are the sourced which assist in gaining data regarding monetary
information of the company. On the other hand, non financial data sources are the sources which
helps in gaining managerial information. Tesco is a large scale company which uses annual report
and interim reports as key their key financial data sources. In addition, Tesco uses cost sheets and
inventory management report as their non financial data sources.
Table 1.1. Key financial and non-financial types of data in the case study
No Data source Data type Financial or non-financial Business units or departments
using this data
1 Annual
report
Income statement Financial Selling and Distribution
department, HR, Marketing
2 Annual
report
Balance sheet Financial Research and Development
department
3

3 Annual
report
Cash flows Financial Production department.
4 Annual
report
Statement of
changes in equity
Financial Public relations department
5 Annual
report
Statement of
comprehensive
income and loss
Financial Finance department
1.2. Mapping between business functions and data sources
1.3. Gaps in data integrity
Gap analysis is a procedure in which issues in the relevancy and validity of the data has been
analysed. In case of Tesco, the main gaps in the data integrity of this company are accuracy,
timeliness and completeness. As the equity sheet of this company presents data which has the
question of high accuracy. This analysis of data is further identified in below table:
Table 1.2. The identified gaps
Business unit or
department
Issues Data sources involved References
Finance
department
Timeliness Statement of comprehensive
income and loss (Annual
report)
(Team, 2016)
4

Public relations
department
Accuracy Statement of changes in
equity (Annual report)
Production
department
Completeness Statement of Cash flows
(Annual report)
2. How can a big data analytics framework be implemented in
the chosen organisation?
Tesco is the UK's largest food retailer and has been a pioneer in innovation and information for some
time. It was one of the key market chains that began following consumer action through its dietary
card framework and has effectively addressed the transition to web-based retail.
It is currently confronting the problems brought about by the latest breakthrough in innovation: the
quest for sustainable data analysis, Big Data and the effects that can be made by it the rise in the
Internet of Things.
Applying the first-line test and the latest information is the shop's response to the management of
barriers from improving consumer behaviour, to looking for more conventional competitors. A large
number of these (for example Amazon, which recently started carrying new food products) have
been developed from the outset by advanced and information-based societies.
Much of the business progress starts within the Tesco Labs division, which was set up to explore new
innovations that could benefit the market and its customers. Tesco Labs has up to 50 simultaneous
businesses and experiments with VR and AR, connected home appliances, close to managing
exchanges and portable applications. It also regulates the typical hackathon times in which software
engineers compete to develop new leases.
Tesco’s general store is facing a number of obstacles, ranging from improving consumer behaviour
and the need to cut down on food, to new competitors. Tesco's answer to these problems is at the
forefront, constant monitoring and the latest information.
For example, by reflecting patterns in consumer behaviour, some valuable knowledge is diminished,
similar to how individuals shop. "It's not just about how they shop in all stores," says Mike Moss,
Tesco's decision and analysis manager, "however, how they get it all. Study, origin and the like, we
found that the way we think that things come together - the way we buy products - is usually the
way things work. " Using this information, the organization can organize the items in the correct
way, ensuring their regular availability, while reducing waste.
5

Sensory information is also gradually used, for example, to monitor the temperature of coolers and
coolers through the source system. Each device is monitored midway and accurate calculations are
used to decide when a particular unit needs to be changed.
With 3,500 stores in the UK alone and each store that loads an average of 40,000 items, they are all
followed consistently once they contain over 100 million pieces of information. This is the place
where auditing within the database could be the most important feature: testing the innovation
where information is sent, rather than moving it in lumps for outdoor study. Tesco is moving from
information warehousing to an information lake model, based around the Hadoop structure. This
will be a concentrated, cloud-based vault for every one of its information, arranged in an approach
to make it available and usable by any arm of the organization, as and when it's required.
The business is likewise quickly getting increasingly engaged with open source advancement, and
Tesco's designers, specialists and information researchers are presently urged to utilize open source
innovation at every possible opportunity, and to offer back to OS people group.
2.1. The proposed data analytics framework
To fill the gap mentioned above; ERP system for financial module is proposed for the data analytics
framework; as this methodology integrates all different departments which could fill the gap of
accuracy, timeliness and completeness. To implement this system; the most important job is to
make sure that Tesco's business processes are well documented and put together in one place. This
includes the obvious key processes such as supply-to-pay and order-to-cash, but should also address
more granular recycling activities such as going aboard staff or approve schedules. In addition, this
document gives leadership a clear view of the scope, complexity and minimum requirements of the
project.
Table 2.1. Proposed data analytics
No Data source Specific organisational decisions Decision type
(strategic, tactical,
operational)
1
Annual report
Whether to focus on increasing the profit or
reducing overall costs of the business.
Operational
2 Annual report Whether to invest in merging or acquisition Strategic
3 Annual report Should price of the product should be reduced
to increase overall sales of the business.
Tactic
6

Etc.
2.2. Implementation of the data analytics
Implementation is the process of planned data analytics structure into real action.
Creation of the model is generally not the end of the project. Even if the purpose of the model is to
increase knowledge of the data, the knowledge gained will need to be organized and presented in a
way that the customer can use it. The suggested implementation process of CRISP-DM
METHODOLOGY has been shown in table 2.2 below:
Table 2.2. Data analytics implementation process
No Phase of the big data
analytics process
Activitiesto be implemented in the chosen organisation or project
1 Data Understanding The intelligence comprehension phase begins with a combination of basic
information and continues with exercises so that you become familiar with
the information, identify information quality problems, find the first parts of
knowledge in the information or identify interesting subsets to model
theories for hidden data.
2 Business Understanding This basic level is based on understanding the business objectives and
prerequisites of the business and subsequently converting this information
into a data mining case definition. An initial plan is intended to achieve the
goals. You can use an optional module; especially one built using the
decision model and the Note standard.
3 Data preparation Select and prepare data to be used • Takes usually over 90% of the
time
Covers all activities to construct the final dataset from the initial raw
data. Data preparation tasks are likely to be performed multiple
times and not in any prescribed order. Tasks include table, record
and attribute selection as well as transformation and cleaning of data
for modelling tools.
4. Modelling  . Select modelling technique
 Generate test design
 Build model
 Assess model
5. Evaluation More thoroughly evaluate model • Decide how to use results
• Interpretation of model: important or not, easy or hard depends on
algorithm • Thoroughly evaluate the model and review the steps
executed to construct the model to be certain it properly achieves
the business objectives. A key objective is to determine if there is6. Deployment Determine how the results need to be utilized • Who needs to use
them? • How often do they need to be used
 Plan development
 Plan monitoring and maintenance
 Produce a final report
 Review project
2.3. Data protection and ethics
It is the process of protecting the data and maintaining the ethical standard of the organization
through adopting different measures.
7

Depending on the type of information you collect, you should govern different laws. Although the
promulgation of intellectual property applies to all information, adherence to individual information
has its own laws. Basically, as of May 25, 2018, the General Data Protection Regulation (GDPR;
European Union, 2016a) applies to any EU analyst or expert in the European Economic Area (EEA)
who collects half individual information about a resident of any country, anywhere on the planet. ,
just like any scientist as a whole who collects individual information about EU residents.
Table 2.3.Data protection and ethical compliance
Data protection/ethics
requirement
Procedures to be implemented
in the chosen organisation or
project
Relevant data
protection
standard
References
1 Lawful, fair and
transparent processing
Process the personal data in
lawful manner. First to collect
genuine data and access this
data to particular user only.
IDDPS (GDPR)
2 Data subject rights Make a proper arrangement
where lodging complain with the
company must be easier for the
users or customers.
DPPs (GDPR)
3 Avoid personal data
breaches
Through adopting a high tech
systems and topology which can
protect data of each and every
employee profusely.
hexa-dimension
metric
operationalization
framework
(GDPR)
Etc.
3. Statement of a specific decision the organisation currently
needs to make, and how big data are expected to improve its
quality
Tesco is in its phase where the operations of this company are impacted due to strategic decisions
and policies of the government of the nations in which it operates. Government decisions and
policies are an external factor which cannot be controlled and in order to protect the operations, an
organisation must develop strategic and tactical plans. The major decisions which Tesco needs to
undertake includes open new stores in existing operating locations in order to fulfil their intention of
gaining higher profits and revenues. For this decision, the financial data of Tesco will be required
including variables of total number of stores, sales and profit (Bandaru, Ng and Deb, 2017).
Second decision is a strategic one which states that Tesco should increase their dividend per share so
that their return on capital employed can be improved as it will help in gaining the effective equity
position of this company. This decision will need financial data variables of dividend per share and
ratio of return on capital employed.
Third decision is to increase the number of employed in Tesco as it can help in increasing the sales
revenue of this company. For this sales value and number of employees will be required as the
financial data (Bondarenko, Bondarenko and Gonchar, 2020).
Table 3.1. Business decision
8

Business decision Related business question Decision type
(strategic, tactical,
operational)
Open new stores Is there is any relationship between
the number of stores and sales
revenue& profit?
Strategic
Increase dividend per share Can the return on capital employed be
increased by increasing dividend?
Strategic
Increasing human capital Can the sales be predicted based on
the number of employees employed?
Tactical
4.Description of a relevant data set
The data set which has been selected for the purpose of supporting the decision is the data of
“five year record”. This data is gathered from official website of Tesco PLC. This data contains
financial values and is a combined summarisation of all financial statements of Tesco. The data years
which are considered are 2016, 2017, 2018 and 2019.
The data set is first collected from the website and an Excel document is downloaded. The data
which was collected is then filtered to only consider 4-year data and exclude 2020. Lastly, the data is
then reduced to only those variables which will be required for making decisions (Chattamvelli,
2015).
The data set which has been collected is related to the annual report data and represents all the
financial statements including statement of financial position, statement of financial performance,
statement of cash flows, statement of changes in equity and statement of comprehensive profit and
loss. The data which is been collected is effective as the accuracy of the data can be ensured as it is
collected from the annual reports which are already audited. Along with this, there are also few
limitations to the data set which is collected. These limitations include the restriction of periodic
data. The data which has been collected only has the information for 5 years which can limit the
accuracy of results.
5. Discussion of data mining procedures with the data set(s) in
question
5.1. Descriptive statistics
Data mining is the procedure of analysing the cleansed data in order to mine much more useful
information from the raw financial data. In this audit report, the data mining procedure which has
been selected is SPSS (Hertrich and Mayrhofer, 2016). Statistical Package for the Social Sciences is a
software program which will help in Descriptive statistics and inferential statistics. Using the five-
year record of Tesco PLC, descriptive analysis has been conducted for the variables which are taken
into consideration for the decision making process. These considerations which are selected include
Group revenue, Profit/(loss) before tax, Dividend per share, return on capital employed (ROCE),
Number of storesand average employees. The output of the descriptive statistics is give below:
Statistics
9

Year
Group
revenue
Profit/(loss)
before tax
Dividend
per share
Return on
capital
employed
(ROCE)
Number of
stores
Average
employees
N Valid 4 4 4 4 4 4 4
Missing 0 0 0 0 0 0 0
Mean 2017.50 57813.50 816.00 8.300% 6892.00 463353.00
Median 2017.50 56705.00 751.00 8.000% 6901.00 464512.50
Mode 2016a 53933a 145a 6.2%a 6733a 448988a
Std. Deviation 1.291 4318.071 753.457 1.9916% 144.051 10865.056
Variance 1.667 18645739.667 567698.000 3.967 20750.667 118049444.667
Minimum 2016 53933 145 6.2% 6733 448988
Maximum 2019 63911 1617 11.0% 7033 475399
Sum 8070 231254 3264 33.2% 27568 1853412
a. Multiple modes exist. The smallest value is shown
The above table of descriptive analysis shows that the data which has been collected is a periodic
data which has data points for four years which are 2016, 2017, 2018 and 2019. The average group
revenue which this company has earned is 57813 million pounds and in year 2019, this company
earned its maximum revenue and minimum in 2016. So, it can be said that there is an increasing
pattern in the group revenue of Tesco. Another variable of this analysis is profit before taxation
which is showing again the same patterns as the revenue. This similar pattern provides an analysis
that group revenue and profit before tax are highly related to each other.
Another variable which is considered is dividend per share; from this variable’s descriptive analysis,
it has been analysed that Tesco does not provide any dividend in year 2016 and 2017. This variable
also shows an increasing pattern growth. ROCE is the capability of a company to earn the return
against the capital which has been invested by their shareholder. From these descriptive statistics of
this variable, it has been analysed that the average ROCE which has been earned by this company is
8.3% with minimum ROCE of 11% in the year 2018. The pattern of growth of ROCE is increasing until
2019. Number of stores is another variable that has been considered. This variable represents that
on an average Tesco has 6892 stores all over the world. The number of stores is growing
continuously until 2019 which represents that ROCE and number of stores is two related variables.
The maximum number of Tesco stores were in 2018 and minimum were in 2016. Another variable
considered is average number of employees which states that there are total of 463353 average
employees in Tesco and the number of employees in this company is substantially decreasing.
5.2. Justification of the inferential statistical model
Statistical models are the statistical assumptions which are developed to analyse the
relationships in a data set. These statistical models are a tool to approximate the reality. These
models include correlations, regression and many more. The benefit of inferential statistical models
is that these are easy to compute and successful in determining approximate relationships. A
limitation of this model is that the results gained from these models are not accurate and are not
predicted. All the inferential statistics models which are selected for present case are justified in a
table below:
10

Table 5.1. Comparison of different inferential statistical models
Model or
test
Advantages Limitations References
1 Correlation This method helps in
identifying the relationship
between two variables.
Along with this, correlation
is more applicable and
simpler procedure which
does not require additional
skills to be undertaken. The
results gathered from
correlation test are easier
to be classified as the
correlation coefficient value
is always between 1 to -1.
This method only identifies
that there is a relationship
between two variables and
it does not provide the
reason that why the
relationship exists. Also, it
does not automatically
provide the results
regarding which variable as
the most influence on the
dependent variable.
(Mission Australia
(Organisation),
2018)
2 ANOVA
test
This test benefits the
investigation by providing
the overall test of equality
of group means. This
method helps to ascertain
the impact of one variable
upon another variable along
with the extent of the
influence.
This test assumes that both
the groups selected have
same or similar standard
deviations. In the case
where there is high
difference of standard
deviation, such tests can be
inaccurate.
(PhanseandDeorah,
2011)
3 Regression Unlike correlation test,
regression model assists in
identifying the most related
variable. This model also
helps in providing a model
fir value as R square.
In case of linear regression,
it assumes that all the
variables have a straight
line relationship which in
few cases is incorrect.
(Team, 2016)
All the test which are critically analysed above are selected for the analysis of Tesco for their
decision making process. Each test has been selected for each decision which in our view is
appropriate for Tesco to undertake. The first test which is selected to undertake is correlation test.
This test will be used to decide that whether Tesco should open new stores or not in order to
increase their sales and profit. Correlation is most justified test in this situation as it can even show
that whether the relationships among variable is positive or negative.
The second test is ANOVA test which is justified to decide whether Tesco should increase their
dividend per share or not. This test can help to identify the difference between the equity means of
both the variables. The third model which has been selected is regression model which has been
chosen to decide that whether Tesco should hire additional human resources or not. Regression
model is justified for this situation as it can help in identifying that at what percentage sales of Tesco
are channelized to their number of employees by considering in the R square metric from case
summary.
5.3. Initial outcomes
Correlation
11

Correlations
Group revenue
Profit/(loss)
before tax
Number of
stores
Group revenue Pearson Correlation 1 .859 .721
Sig. (2-tailed) .141 .279
N 4 4 4
Profit/(loss) before tax Pearson Correlation .859 1 .929
Sig. (2-tailed) .141 .071
N 4 4 4
Pearson Correlation .721 .929 1
Sig. (2-tailed) .279 .071
N 4 4 4
ANOVA test
Case Processing Summary
Cases
Included Excluded Total
N Percent N Percent N Percent
Return on capital employed
(ROCE) * Dividend per
share
4 100.0% 0 0.0% 4 100.0%
Report
Return on capital employed (ROCE)
Dividend per share Mean N Std. Deviation
0 7.150% 2 1.3435%
3.00 11.000% 1 .
5.77 7.900% 1 .
Total 8.300% 4 1.9916%
Regression
Model Summary
Model R R Square Adjusted R Square
Std. Error of the
Estimate
1 .265a .070 -.394 5099.141
a. Predictors: (Constant), Average employees
12

6. Visualisation and interpretation of results as expected in
business reporting
Correlations
Group revenue
Profit/(loss)
before tax
Number of
stores
Group revenue Pearson Correlation 1 .859 .721
Sig. (2-tailed) .141 .279
N 4 4 4
Profit/(loss) before tax Pearson Correlation .859 1 .929
Sig. (2-tailed) .141 .071
N 4 4 4
Pearson Correlation .721 .929 1
Sig. (2-tailed) .279 .071
N 4 4 4
The above correlation test has been conducted is undertaken to identify the relationship between
revenue of the Tesco group which they earn, the profit or loss and the number of stores. The aim
behind conducting this analysis is to ascertain the relationship between revenue & profit and the
number of stores of Tesco which are currently being operated in global market. This correlation will
help in analyzing that if there is a positive relationship between these variables, then it is viable to
open more stores and more stores can help in generating higher revenue and profit.
The correlation coefficient between group revenue and number of stores is .721 which means there
is a strong relationship between these variables. On the other hand, the correlation coefficient
between group profit and number of stores is .929 which also shows strong and positive between
these variables. According to correlation test, closer the correlation coefficient is to 1, the stronger
the relationship is. Accord8ing to the above test results, the profit is more related with number of
stores than sales.
So, it has been concluded from above analysis that number of stores of Tesco is related with this
company’s revenue and profit. This implies that Tesco should open new stores as with the increasing
number of new stores, the profit and sales of this company will also increase that will eliminate their
issue of decline pace growth.
ANOVA Table
Sum of
Squares df
Mean
Square F Sig.
Return on capital
employed (ROCE) *
Dividend per share
Between
Groups
(Combined) 10.095 2 5.047 2.796 .389
Within Groups 1.805 1 1.805
Total 11.900 3
13

Return on investment or ROCE is an allowance that measures the extent to which an
organization can generate benefits from its capital by using a net operating profit other than
the capital used. 'Using. At the end of the day, a return on capital used shows financial
experts how many dollars of benefits each dollar of capital used generates.
ROCE is an allowance revoked because it demonstrates the adequacy of the
performance of resources while at the same time considering long-range financing. That's
why ROCE is a more useful contribution than a valuable product in assessing the lifespan of
an organization.
This proportion depends on two important assumptions: operating profit and invested
capital. Net operating profit is often referred to as EBIT or profit before information and
assessments are made. EBIT is regularly reported on the definition of payment because it
shows the organizational benefits created by the activities. EBIT can be determined by re-
entering interests and liabilities in full compensation if necessary.
Capital is actually a term used as it could also be used to refer to various contributions
related to money. Capital regularly refers to an organization's external resources without all
current liabilities. This could be considered as an investor value lower than long-term
liabilities. Both have a similar figure.
The result shows that relation between combined groups and within groups is .389;
which indicates not strong significance of both variables.
ROCE measures the amount of pre-tax benefits an organization can deduct from the
capital used in its business. All else being equal, a higher company will have a higher ROCE.
In the end, it is a useful but incomplete measure. Renowned risk scientist Michael
Mauboussin has suggested to high ROCE to show that “a dollar investing resources in the
group yields an estimate of more than one dollar”. ROCE can be useful when making
connections, for example, between comparable groups. Apparently, Tesco's ROCE is very
close to its average sales share of 8.3%. Separated from the way Tesco stacks its business, its
ROCE is in unacceptably high terms; relative to profits on government securities. It is
possible to think that there are additional compensation initiatives.
In our study, Tesco's ROCE appears to be, in all respects, at 7.4%, compared to 3 years
earlier, when its ROCE was at 3.0%. This will lead us to consider whether the organization is
skillfully reinvested. It is necessary to remember that ROCE appears in executions in the past
and is not looking ahead. ROCE can be attractive to structured organizations, as a product
can provide a spectacular outlook at times of explosiveness and scary low in drag. ROCE is
only a timely measure.
Current (or current) liabilities are factors such as supplier searches, current account
withdrawals or expenses that must be paid within one year. Due to the way the ROCE
14

situation works, with large bills being paid in the short term it can indicate that an
organization has less capital to use, and in this way higher ROCE than expected. To
counteract this, financial experts can examine whether an organization has high current
liabilities against available resources.All UK liabilities are £ 21 billion and UK facilities
total £ 49 billion. In this way, its current liabilities compare to approximately 42% of its
total resources. Tesco's ROCE is partly improved by the moderate amount of current
liabilities.
ANOVAa
Model
Sum of
Squares df Mean Square F Sig.
1 Regression 3934750.400 1 3934750.400 .151 .735b
Residual 52002468.600 2 26001234.300
Total 55937219.000 3
a. Dependent Variable: Group revenue
b. Predictors: (Constant), Average employees
Coefficientsa
Model
Unstandardized Coefficients
Standardized
Coefficients
t Sig.B Std. Error Beta
1 (Constant) 106653.761 125575.781 .849 .485
Average employees -.105 .271 -.265 -.389 .735
a. Dependent Variable: Group revenue
7. Recommendations for the decision-making process
Tesco is capable of quality of its operations in its constant effort to advance in inventory
management, internal customer support services and the legitimate treatment of producers as a
reflection of their operational capabilities, well-being and position in the organization. As a reseller,
Tesco does not face the challenges of ordinary activities in putting together a business and,
therefore, should decide to use ad lobbed of the inventory management framework on time. The
organization relies on many promotions to help with transportation, track products and customers
and improve the performance of agents' operations. The combination of promotions and the job
negotiation process will help Tesco move forward and earn higher revenues, despite the ease with
which it offers its customers.
15

Tesco expects its Tesco image elements to meet first-class and first-class requirements, both as an
organizational strategy and as a legitimate prerequisite. The organization manages Tesco's Food
Manufacturing Status (TFMS) strategy which monitors the direct relationship with suppliers and
their commitments to the organization. The advances used in Tesco allow the company to
coordinate the interest in the scenarios with the real needs of employees. He would therefore be
able to evaluate the performance of one shop against his wishes. The legitimate structure of the
shops, the coordination of employee demands and the provision of autonomous options to
customers are increasing employee performance, reducing downtime for retailers and significantly
reducing organizational plans. The research attempts to push the boundaries. TESCO must measure
the impact of its reliability program and assess whether these limits are valid. Safeway's unshakable
program (ABC Charter) got off to a great start, but was finally withdrawn four and a half years after
its show. ASDA is afraid to appear all over the country's reliability card for foreplay in several
sources. The Tesco Club Card has been many times more popular than the Sainsbury's savings card
and has outperformed the other cards. The method of connection helps to differentiate the
connection between two factors. Coupled with this are the incremental connection and a simpler
approach that requires no additional skills to experiment.
The Annova test benefits the study by passing a standardized mean equality test. This strategy helps
determine the effect of one variable on another variable relative to the effect level. The regression
model helps to differentiate the most connected variable. This model also helps provide men's
appreciation as an R square. The relationship test shows that the number of Tesco stores is related
to this organization's income and profitability. This suggests that Tesco should likewise open new
stores with the growing number of new stores, the benefits and conditions of this organization will
increase, which will eliminate their concern about the development of the rate of decay.
16

Reference list
Arganda-Carreras, I. and et. al., 2017. Trainable Weka Segmentation: a machine learning tool for
microscopy pixel classification. Bioinformatics. 33(15).pp.2424-2426.
Ataman, K., Kulick, G. and Sim, T., 2011.Teaching decision tree classification using Microsoft
Excel. INFORMS Transactions on Education. 11(3).pp.123-131.
Bandaru, S., Ng, A.H. and Deb, K., 2017. Data mining methods for knowledge discovery in multi-
objective optimization: Part A-Survey. Expert Systems with Applications. 70. pp.139-159.
Bondarenko, I., Bondarenko, B. and Gonchar, O., 2020. Expositional design of the Audi museum in
Ingolstadt: representation of the brand’s characteristics in automobile industry
history. Muzeológia a kultúrnededičstvo. 8(1).
Chattamvelli, R., 2015. Data mining methods.Alpha Science International.
Hertrich, S. and Mayrhofer, U., 2016. Audi and the Chinese Market: A Success Story. In Market Entry
in China (pp. 37-44).Springer, Cham.
Mission Australia (Organisation), 2018. Audi Women in Automotive project: evaluation report.
Phanse, V. and Deorah, S., 2011, December. Evaluation and Extension to the Duckworth Lewis
Method: A Dual Application of Data Mining Techniques. In 2011 IEEE 11th International
Conference on Data Mining Workshops (pp. 763-770).IEEE.
Team, R.C., 2016.foreign: read data stored by Minitab, S, SAS, SPSS, Stata, Systat, Weka, dBase. R
package version 0.8-67.
17

Appendices
Five year record of Tesco PLC
2016 2017
2018
(restated)(a)
2019
(restated)(b)
Financial statistics (£m)
SalesΔ
UK & ROI 37,189 37,692 38,656 44,883
Central Europe 5,268 5,977 6,343 6,030
Asia 4,447 5,186 4,947 4,873
Tesco Bank 955 1,012 1,047 1,097
Group sales(e) 47,859 49,867 50,993 56,883
Revenue
UK & ROI 43,080 43,524 44,914 51,643
Central Europe 5,451 6,195 6,585 6,298
Asia 4,447 5,186 4,947 4,873
Tesco Bank 955 1,012 1,047 1,097
Group revenue 53,933 55,917 57,493 63,911
Operating profit/(loss) before exceptional items and
amortisation of acquired intangiblesΔ(e)
UK & ROI 503 803 1,059 1,868
Central Europe 102 58 119 221
Asia 218 262 299 319
Tesco Bank 162 157 169 199
Group operating profit/(loss) before exceptional items and
amortisation of acquired intangiblesΔ(e) 985 1,280 1,646 2,607
Operating profit margin before exceptional items and
amortisation of acquired intangiblesΔ 1.8% 2.3% 2.9% 4.1%
Operating profit/(loss)
UK & ROI 597 519 1,205 1,949
Central Europe 111 190 212 279
Asia 203 231 277 252
Tesco Bank 161 77 145 169
Group operating profit/(loss) 1,072 1,017 1,839 2,649
Share of post-tax profits/(losses) of joint ventures and associates (21) (107) (6) 32
Net finance costs (849) (765) (533) (1,064)
Profit/(loss) before tax 202 145 1,300 1,617
Taxation 54 (87) (306) (347)
Profit/(loss) for the year from continuing operations 256 58 994 (1,270)
Discontinued operations (127) (112) 216 -
Profit/(loss) for the year 129 (54) 1,210 1,270
Attributable to:
Owners of the parent 138 (40) 1,208 1,272
Non-controlling interests (9) (14) 2 (2)
Profit before tax, exceptional items and amortisation of
acquired intangibles, net pension finance costs and fair
value remeasurements of financial instrumentsΔ(e) 509 781 1,284 1,806
Other financial statistics
Diluted earnings/(losses) per share – continuing operations 3.22p 0.81p 12.11p 13.04p
Diluted earnings per share – continuing operations before
exceptional items and amortisation of acquired intangibles, net
pension finance costs and fair value remeasurements of financial
instrumentsΔ(e) 5.79p 7.30p 11.90p 14.01p
18

Dividend per share(d) - - 3.00p 5.77p
Cash generated from retail operating activities (£m)Δ 2,581 2,278 2,773 3,637
Free cash flow (£m)Δ 1,482 1,288 1,388 889
Return on capital employed (ROCE)(e) 6.2% 8.1% 11.0% 7.9%
Total shareholder return(e) (11.8%) (7.5%) 8.7% 10.2%
Net debt (£m)Δ(e) 5,110 3,729 2,625 13,204
Discounted operating lease commitments - continuing operations 7,814 7,440 6,931 -
Pension deficit, net of deferred tax – Group (£m) 2,612 5,504 2,728 2,338
Total indebtedness (£m)Δ(e) 15,536 16,673 12,284 15,542
Enterprise value (£m)(e) 20,101 19,262 19,452 35,024
Group retail statistics
Number of stores(f) 6,733 6,809 7,033 6,993
Total sales area (’000 sq. ft.)(f) 91,195 89,041 92,983 91,298
Average employees 475,399 464,520 448,988 464,505
Average full-time equivalent employees (FTE) 351,289 342,770 327,916 321,490
UK & ROI Retail statistics
Number of stores(f) 3,743 3,739 3,952 3,961
Total sales area (’000 sq. ft.)(f) 45,253 43,610 42,032 50,521
Average full-time equivalent employees (FTE) 225,378 218,522 210,312 223,542
Revenue (exc. fuel) (per FTE – £) 165,007 172,486 183,804 200,781
Weekly revenue (exc. fuel) (per sq. ft. – £) 15.68 16.31 17.36 18.65
Pre-processed data
Year
Group
revenue
Profit/(loss)
before tax
Dividen
d per
share
Return on capital
employed (ROCE)
Number
of stores
Average
employee
s
2016 53,933 202 - 6.2% 6,733 475,399
2017 55,917 145 - 8.1% 6,809 464,520
2018 57,493 1,300 3.00p 11.0% 7,033 448,988
2019 63,911 1,617 5.77p 7.9% 6,993 464,505
19