halloween

Order Your Assignment See Your Grades Improving...

300k+ Satisfied
Students.

Rated 4.8/5

Based On Overall
6989 Reviews.

Order Now

Amazing Features We Offer

24*7 Help Service

100% Satisfaction
No Privacy Infringement
Super-fast Services
Subject Experts
Professional Documents

Get Lowest Price

Get A+ Within Your Budget!

Total Price

USD 7.33

M/508/0495 - Technology In Communicating And Retrieving Data In Tesco

University: Regent College

  • Unit No: 12
  • Level: Undergraduate/College
  • Pages: 13 / Words 3136
  • Paper Type: Assignment
  • Course Code: M/508/0495 (RCF)
  • Downloads: 615
Question :
'

The objective of this report is to analyze data handling practices that can assist an organisation to manage its business activities in effective manner. Therefore, it is required for firm to pay their maximum attention towards:

  • Evaluate the manipulated data correctly by using fractions, decimals and percentage.
  • Define the basic techniques of sampling and statistical summary in the context of Tesco.
  • Determine the presented data by using spreadsheet software packages.
  • Identify the ability to use internet technology in communicating and retrieving data in TESCO.
'
Answer :

INTRODUCTION

Data handling is a process which is used to analyse the data with critical analysing approach and analytical approach. This is one of the essential aspects in terms of ensuring the structure of organisation in terms of developing strategies and plans (Rayegani and Onwubolu, 2014). There is a mathematical and strategic analytical tools are used to make the effective plans and management and operations. Data handling is a process which is mainly used in strategic planning and research project. Analysing data is evaluated on the basis of analysing the performance of TESCO and analysing the data on the basis of Data handling.

TASK 1

a) Description

This task is about a retail organization "TESCO" which is working in UK. It is related with regular brand of two reduced grocery store chains having in general of 10000 stores in just about 20 countries with the aggregate turnover of £50 billion. This specific organization bargains in sustenance, refreshments, clean articles and family unit items. The aggregate number of 104400 representatives are working with the organization to conveyance more suitable development risks in coming time. It has encounters extensive variety of development in UK by overwhelming the past outcomes keeping in mind the end goal to wind up most productive organization in coming time. Organisation is running successfully in West London and it is analyse that the organisation is seeking for expanding the scale of business at next level. There are type of strategies and plans are considered in this context related to define the organisational structure and boosting the structure of organisation (Lark, Craven and Bosworth, 2013).

As per analysis of case scenario it is seen that the organisation is required to Expand the business at next level. It is analysed that for further expansion and increasing the amount of business it is required to collect the amount of £10000 form Family and friends, 2500 in the form of capital and 50000 for the goods. Financial requirement is fulfilled with the help of goodwill and repayment capacity. There are some methods are analysed in terms of auto sum, Auto format, average formula, percentage, and in the form of spread sheet.

b) Graph of spreadsheet which contains of total sales and expenses

Sales figures

Particulars

April

May

June

July

August

September

October

November

December

January

Sales

575000

500000

595000

600000

675000

500000

625000

700000

575000

675000

Less: Cogs

-325000

-295000

-385000

-398500

-350750

-352000

-450000

-395750

-425000

-450500

Gross profit

250000

205000

210000

201500

324250

148000

175000

304250

150000

224500

Expenses

Administration expenses

-7500

-6500

-8500

-9850

-9350

-10750

-7500

-7650

-3650

-5500

Office expenses

-10800

-14600

-13600

-11000

-12750

-13870

-14890

-22500

-13500

-23660

Depreciation

-17500

-15700

-16700

-12500

-17900

-19000

-18500

-23500

-21470

-25400

Net profit before tax

214200

168200

171200

168150

284250

104380

134110

250600

111380

169940

Tax paid @ 15%

-32130

-25230

-25680

-25222.5

-42637.5

-15657

-20116.5

-37590

-16707

-25491

Profit after tax

182070

142970

145520

142927.5

241612.5

88723

113993.5

213010

94673

144449

Net profit percentage

31.66%

28.59%

24.46%

23.82%

35.79%

17.74%

18.24%

30.43%

16.46%

21.40%

Average Net profit

150994.85


The profitability graph of organisation shows the positive reflection and helps to analyse the data in various form (Ratrout, 2014). Cost of goods sold is recorded as for the month of April 325000, £295000 for may, £385000 for the month of June, £398500 for the month of July, £350750 for the month of August, £352000 for the month of September, £450000 for the month of October, £395750 for the month of November, £425000 for the month of December and £450500 for the month of January.

As per analysis of sales and profitability graph it is concluded that the turnover for the month of April was £575000, £500000 for may, £595000 for the month of June, £600000 for the month of July, £675000 for the month of August, £50000 for the month of September, £625000 for the month of £700000, £575000 for the month of December, £675000 for the month of January.

Expenses

Particulars

April

May

June

July

Aug

Sep

Oct

Nov

Dec

Jan

Administration expenses

7500

6500

13600

13500

13850

16480

19450

22500

19840

24500

Office expenses

10800

8600

16800

12000

12570

13690

15840

13900

13890

21600

Depreciation

17500

9400

9400

8500

9800

8700

8760

8630

9000

6800

From the above segment visit, it has been discover that all the those costs TESCO organization will contribute over the creation of items and administrations amid the time frame. Based on above examination, it has been break down that most extreme capital is contributed over organization costs and office costs (Parent, 2013). This will expand additional weight over the creation and aggregate deal amid the time. There are major three type of organisations are defined in this context in terms of expenses which are depreciation, administration expense, office expenses and depreciation.

As per expenditure graph the administration expenses for the 10 months are as follows 7500 for the month of April, 6500 for the month of may, 8500 for the month of June, 9850 for the month of July, 9350 for August month, 10750 for the month of September, 7500 for the month of October, 7650 for the month of November, 3650 the December, 5500 for the month of January.

Office expensed for the ten months are as follows; 10800 for the month of April, 14600 for the month of May, £13600 for the month of June, £11000 for the month of July, £12750 for the month of August, £13870 for the month of September, £14890 for the month of October, £22500 for the month of November, £13500 for the month of December and 23660 for the month of January.

Depreciation for the subsiding ten months which is as follows; 17500 for the month of April, 15700 for the month of May, 16700 for the month of June, 12500 for the month of July, 17900 for the month of August, 19000 for the month of September, 18500 for the month of October, 23500 for the month November, 21470 for the month of December and 25400 for the month of January.

Profitability in last three months

As indicated by the above graph, it has been discover that aggregate deals caused amid the time is fluctuating in following months. The most extreme deals is acquire in the long stretch of January with aggregate of £625000 and also in October. This will be fundamental to gathered important wellsprings of assets for the organization. Keeping in mind the end goal to get more supports, they have to make utilization of held gaining and proprietors value which is more secure and safe to raise capital for the organization (Richards, 2014).

Bifurcation of revenue through charts

Particular

Percentage

Investment

60

Capital

50

Operation money

10

Total

120

Special Offer

UPTO50% OFF

To view this & another 50000+ FREE

Download Full Sample

Cite This Work

To export references to this Sample, select the desired referencing style below:

Students sometimes cannot express their inability to work on assignments and wonder, "Who will do my assignment?" To help them understand the complexities of writing, we are providing "samples" on various subjects. Also, we have experienced assignment writers who can provide the best and affordable assignment writing services, essay writing services, dissertation writing services, and so on. Thus, don't wait any longer! Place your order now to take advantage of discounted deals and offers.