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

The following table shows the Income (in Rs. lakh) and percentage (%) profit of a company over the six years from 2017 to 2022. Based on the data in the table, answer the questions that follow.

Year-wise Income and Profit of a Company

YearIncome (in Rs. Lakh)Profit (%)
20171207.5
201816015
201913022.5
202017017.5
202119020
202215027.5

If the percentage profit in 2021 was 25% instead of 20% than what would have been the expenditure in that year?

The correct answer is

Rs. 152 lakh

Calculating Expenditure with Modified Profit Percentage

This problem requires us to determine the expenditure of a company in a specific year (2021) if its profit percentage were different from the actual value provided in the table. We are given the income for that year and the hypothetical new profit percentage. To solve this, we need to understand the relationship between income, expenditure, and profit.

Understanding the Relationship between Income, Expenditure, and Profit

The basic formula relating these three components is:

  • Income = Expenditure + Profit

This means that the profit is the difference between the income and the expenditure:

  • Profit = Income - Expenditure

The profit percentage is calculated based on the expenditure:

  • Profit % = \(\left( \frac{\text{Profit}}{\text{Expenditure}} \right) \times 100\)

Applying the Formula to the 2021 Data

We are given the following information for the year 2021 from the table:

  • Income in 2021 = Rs. 190 lakh
  • Actual Profit % in 2021 = 20%

However, the question asks us to consider a scenario where the profit percentage in 2021 was 25% instead of 20%. So, for our calculation:

  • Hypothetical Profit % in 2021 = 25%
  • Income in 2021 = Rs. 190 lakh
  • Expenditure in 2021 = Unknown (Let's call it \(E\))

Using the profit percentage formula and substituting \( \text{Profit} = \text{Income} - \text{Expenditure} \), we get:

\(\text{Profit} \% = \left( \frac{\text{Income} - \text{Expenditure}}{\text{Expenditure}} \right) \times 100\)

Now, let's plug in the values for 2021 with the hypothetical profit percentage:

\(25 = \left( \frac{190 - E}{E} \right) \times 100\)

Solving for Expenditure (E)

We need to solve this equation for \(E\):

Divide both sides by 100:

\(\frac{25}{100} = \frac{190 - E}{E}\)

\(0.25 = \frac{190 - E}{E}\)

Multiply both sides by \(E\):

\(0.25 \times E = 190 - E\)

Add \(E\) to both sides of the equation:

\(0.25 E + E = 190\)

\(1.25 E = 190\)

Divide both sides by 1.25 to find the value of \(E\):

\(E = \frac{190}{1.25}\)

\(E = 152\)

So, if the percentage profit in 2021 was 25%, the expenditure in that year would have been Rs. 152 lakh.

Comparing with Options

Let's compare our calculated expenditure with the given options:

  • Option 1: Rs. 130 lakh
  • Option 2: Rs. 148 lakh
  • Option 3: Rs. 120 lakh
  • Option 4: Rs. 152 lakh

Our calculated expenditure of Rs. 152 lakh matches Option 4.


Year Income (in Rs. Lakh) Profit (%)
2017 120 7.5
2018 160 15
2019 130 22.5
2020 170 17.5
2021 190 20
2022 150 27.5

The table shows the actual data, but for this specific question, we used the Income for 2021 from the table (Rs. 190 lakh) and a hypothetical profit percentage (25%) to calculate the expenditure.

Revision Table: Key Formulas

Concept Formula
Income Expenditure + Profit
Profit Income - Expenditure
Profit Percentage \(\left( \frac{\text{Profit}}{\text{Expenditure}} \right) \times 100\)
Profit Percentage (using Income & Expenditure) \(\left( \frac{\text{Income} - \text{Expenditure}}{\text{Expenditure}} \right) \times 100\)

Additional Information: Data Interpretation Tips

When solving problems based on tables showing financial data like income, expenditure, and profit percentages, keep the following tips in mind:

  • Always read the table headings and units carefully (e.g., Rs. lakh, %).
  • Understand the definitions of terms like income, expenditure, and profit in the context of the problem.
  • Pay close attention to whether the question asks about actual data from the table or a hypothetical scenario with modified values.
  • Use the correct formulas relating the given data points.
  • Be careful with percentage calculations; remember that profit percentage is usually calculated on expenditure unless stated otherwise.
  • Break down complex problems into smaller steps.
  • Double-check your calculations.
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