HalloweenHalloween

Why Are We Best for Assignment Help in Australia?

300k+ Satisfied
Customers

Star ratings
4.8/5

Based on 6989
Reviews of our
happy customers.

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: 731
    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

    Amazing Discount

    UPTO50% OFF

    Subscribe now for More Exciting Offers + Freebies

    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.

    Limited Time Offer

    Exclusive Library Membership + FREE Wallet Balance