All Exams Test series for 1 year @ ₹349 only
Question

Study the table carefully and answer the questions that follow

Given below is a table that shows the expenditure of a company (in Lakh Rupees) per annum over the given years

Expenditure Item

Salary

Travel

Hospitality

Interest on Loans

Taxes

Year

2016

330

70

30

28

80

2017

380

65

33

31

87

2018

420

72

35

33

91

2019

450

75

40

36

94

2020

480

84

43

39

97

In which year is the ratio of Salary to Hospitality maximum?

The correct answer is

2018

Analyzing Company Expenditure Data

The question asks us to identify the year in which the ratio of Salary expenditure to Hospitality expenditure is maximum based on the provided table.

Expenditure Item 2016 2017 2018 2019 2020
Salary 330 380 420 450 480
Travel 70 65 72 75 84
Hospitality 30 33 35 40 43
Interest on Loans 28 31 33 36 39
Taxes 80 87 91 94 97

To find the year with the maximum ratio of Salary to Hospitality, we need to calculate this ratio for each given year.

The ratio for each year is calculated as:

$$\text{Ratio} = \frac{\text{Salary Expenditure}}{\text{Hospitality Expenditure}}$$

Let's calculate the ratio for each year:

  • Year 2016: Salary = 330, Hospitality = 30. Ratio = $$\frac{330}{30} = 11$$
  • Year 2017: Salary = 380, Hospitality = 33. Ratio = $$\frac{380}{33} \approx 11.515$$
  • Year 2018: Salary = 420, Hospitality = 35. Ratio = $$\frac{420}{35} = 12$$
  • Year 2019: Salary = 450, Hospitality = 40. Ratio = $$\frac{450}{40} = 11.25$$
  • Year 2020: Salary = 480, Hospitality = 43. Ratio = $$\frac{480}{43} \approx 11.163$$

Let's summarize the ratios in a table:

Year Ratio of Salary to Hospitality
2016 11
2017 $\approx$ 11.515
2018 12
2019 11.25
2020 $\approx$ 11.163

Comparing the calculated ratios (11, $\approx$ 11.515, 12, 11.25, $\approx$ 11.163), the maximum ratio is 12.

This maximum ratio of 12 occurred in the year 2018.

Revision Table: Key Data and Ratios

Year Salary (Lakh ₹) Hospitality (Lakh ₹) Salary / Hospitality Ratio
2016 330 30 11.00
2017 380 33 11.52 (approx)
2018 420 35 12.00
2019 450 40 11.25
2020 480 43 11.16 (approx)

The table clearly shows that the ratio of Salary to Hospitality is highest in 2018.

Additional Information on Data Interpretation

Data interpretation questions often require careful reading of tables, graphs, or charts to extract relevant information and perform calculations or comparisons. Key skills involved include:

  • Identifying the specific data points needed for the calculation.
  • Understanding the units and scales used in the data.
  • Performing basic arithmetic operations accurately (addition, subtraction, multiplication, division).
  • Calculating ratios, percentages, averages, etc.
  • Comparing values or trends across different categories or time periods.
  • Analyzing the results to answer the specific question asked.

In this problem, we focused on calculating a simple ratio between two specific expenditure items across different years to find the maximum value.

Was this answer helpful?

Important Questions from Tabulation

  1. The table shows District-wise data of a number of primary school teachers posted in schools of a city.

    Study the table and answer the question:

    District

    Male teachers

    Female teachers

    East

    1650

    2375

    North

    1075

    2651

    West

    1280

    1520

    South

    1170

    1085

    Central

    690

    859


    What is the difference between the total number of male teachers in the districts East, North, West taken together and the total number of female teachers in the districts East and South?
  2. Table shows income (in Rs. ) received by 4 employees of a company during the month of December 2020 and all their income sources.

    Source

    Amit

    Suresh

    Nitin

    Varun

    Salary

    35000

    38500

    29000

    42000

    Arrears

    6000

    6300

    5000

    7500

    Bonus

    1000

    1100

    1000

    1240

    Overtime

    1800

    1950

    1400

    1500


    What is the ratio of salary of Varun to his income other than salary?
  3. Study the table and answer the question:

    Income (Rs.)

    No. of persons

    Less than 200

    12

    Less than 250

    26

    Less than 300

    34

    Less than 350

    40

    Less than 400

    50


    What is the percentage of persons earning Rs. 250 or more?
  4. The following table shows the annual profit of a company (in Rs. lakh).

    2014-2015

    2015-2016

    2016-0217

    2017-2018

    2018-2019

    625

    690

    725

    775

    815

    The period which has the maximum percentage increase in profit over the previous year is:

  5. The table given below shows the number of persons participating in a survey from 6 different states.

    States Persons 
    S1100
    S2200 
    S3400 
    S4500 
    S5600 
    S6800

    What is the ratio of number of person participating in a survey from state S3 to the number of person participating in a survey from state S4?

Need Expert Advice?

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App