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

The following table shows the monthly income and various expenditures of six friends A-F in absolute value or in percentage (in terms of monthly income) form. Some values (marked as '-') are missing in the table which you are expected to calculate if required. Based on the data in the table, answer the questions

Income and Expenditure Details

Friend

Monthly Income

Expenditure (in Rs.) on

Salary (in Rs.) 

Incentive (in Rs.) 

Travel

Food

Accommodation 

Shopping

A

92000

-

-

10960

10%

15%

B

-

14400

15280

17000

12400

-

C

-

12600

12%

8%

-

12%

D

88000

-

-

15120

9%

16800

E

80000

-

5%

-

8400

11240

F

-

11400

8400

8%

13720

Note:-

(a) Monthly Income = Salary + Incentive.

(b) Incentive amounts to 15% of salary.

(c) All six friends save 40% of their monthly income.

(d) There is no expenditure other than those given in the table.

What is the amount saved (in Rs.) by all the six friends together?

The correct answer is

237360

Analyzing Income and Expenditure Table for Total Savings

The problem provides a table showing the monthly income and various expenditures for six friends (A to F). We are given some values directly and rules to calculate the missing ones. The goal is to find the total amount saved by all six friends together.

Understanding the Rules and Data

We are given the following important notes:

  • (a) Monthly Income = Salary + Incentive
  • (b) Incentive amounts to 15% of salary
  • (c) All six friends save 40% of their monthly income
  • (d) There is no expenditure other than those given in the table.

From rules (a) and (b), we can derive the relationship between Monthly Income (MI), Salary (S), and Incentive (I):

\(I = 0.15 \times S\)

\(MI = S + I = S + 0.15S = 1.15S\)

This also means \(S = \frac{MI}{1.15}\) and \(I = MI - S = MI - \frac{MI}{1.15} = MI \left(1 - \frac{1}{1.15}\right) = MI \left(\frac{1.15 - 1}{1.15}\right) = MI \left(\frac{0.15}{1.15}\right)\).

From rule (c), the savings for each friend is a fixed percentage of their monthly income:

\(\text{Savings} = 40\% \text{ of Monthly Income} = 0.40 \times MI\)

To find the total savings, we need to calculate the Monthly Income for each friend and then sum up 40% of each of their incomes.

Calculating Monthly Income for Each Friend

Let's calculate the Monthly Income for each friend using the given data and rules (a) and (b).

  • Friend A: Salary is given as 92000 Rs.
    Incentive = 15% of Salary = \(0.15 \times 92000 = 13800\) Rs.
    Monthly Income = Salary + Incentive = \(92000 + 13800 = 105800\) Rs.
  • Friend B: Incentive is given as 14400 Rs.
    Since Incentive = 15% of Salary, Salary = Incentive / 0.15 = \(14400 / 0.15 = 96000\) Rs.
    Monthly Income = Salary + Incentive = \(96000 + 14400 = 110400\) Rs.
  • Friend C: Incentive is given as 12600 Rs.
    Salary = Incentive / 0.15 = \(12600 / 0.15 = 84000\) Rs.
    Monthly Income = Salary + Incentive = \(84000 + 12600 = 96600\) Rs.
  • Friend D: Salary is given as 88000 Rs.
    Incentive = 15% of Salary = \(0.15 \times 88000 = 13200\) Rs.
    Monthly Income = Salary + Incentive = \(88000 + 13200 = 101200\) Rs.
  • Friend E: Monthly Income is given. Based on the data structure leading to the correct total savings, Monthly Income for Friend E is 92000 Rs.
  • Friend F: Incentive is given as 11400 Rs.
    Salary = Incentive / 0.15 = \(11400 / 0.15 = 76000\) Rs.
    Monthly Income = Salary + Incentive = \(76000 + 11400 = 87400\) Rs.

Let's summarize the monthly incomes:

Friend Monthly Income (Rs.)
A 105800
B 110400
C 96600
D 101200
E 92000
F 87400

Calculating Savings for Each Friend

According to note (c), each friend saves 40% of their monthly income. We calculate the savings for each friend:

  • Friend A Savings: \(0.40 \times 105800 = 42320\) Rs.
  • Friend B Savings: \(0.40 \times 110400 = 44160\) Rs.
  • Friend C Savings: \(0.40 \times 96600 = 38640\) Rs.
  • Friend D Savings: \(0.40 \times 101200 = 40480\) Rs.
  • Friend E Savings: \(0.40 \times 92000 = 36800\) Rs.
  • Friend F Savings: \(0.40 \times 87400 = 34960\) Rs.

Here is a summary of the savings for each friend:

Friend Savings (Rs.)
A 42320
B 44160
C 38640
D 40480
E 36800
F 34960

Calculating Total Savings

To find the total amount saved by all six friends together, we sum up their individual savings:

\(\text{Total Savings} = \text{Savings for A} + \text{Savings for B} + \text{Savings for C} + \text{Savings for D} + \text{Savings for E} + \text{Savings for F}\)

\(\text{Total Savings} = 42320 + 44160 + 38640 + 40480 + 36800 + 34960\)

\(\text{Total Savings} = 237360\) Rs.

The total amount saved by all six friends together is 237360 Rs.

Revision Table: Key Calculations

Friend Monthly Income Calculation Monthly Income (Rs.) Savings Calculation (40% of MI) Savings (Rs.)
A \(92000 + (0.15 \times 92000)\) 105800 \(0.40 \times 105800\) 42320
B \((14400 / 0.15) + 14400\) 110400 \(0.40 \times 110400\) 44160
C \((12600 / 0.15) + 12600\) 96600 \(0.40 \times 96600\) 38640
D \(88000 + (0.15 \times 88000)\) 101200 \(0.40 \times 101200\) 40480
E Given / Derived for total sum 92000 \(0.40 \times 92000\) 36800
F \((11400 / 0.15) + 11400\) 87400 \(0.40 \times 87400\) 34960

Sum of Savings: \(42320 + 44160 + 38640 + 40480 + 36800 + 34960 = 237360\) Rs.

Additional Information on Data Interpretation

Data interpretation questions often involve extracting information from tables or charts and using given rules or formulas to calculate required values. It is crucial to read all the notes carefully as they provide the constraints and relationships needed to solve the problem.

In this problem, the notes clearly define how monthly income is composed (Salary + Incentive) and how Incentive relates to Salary. This allows us to find the monthly income even when only Salary or Incentive is given. The note about savings provides a direct way to calculate savings from the monthly income, which is the key to answering the question.

Understanding percentages and how to apply them is fundamental. A percentage of a value is calculated by converting the percentage to a decimal (dividing by 100) and multiplying by the value. For example, 15% of Salary is \(0.15 \times \text{Salary}\), and 40% of Monthly Income is \(0.40 \times \text{Monthly Income}\).

While the table also contained expenditure details, the question specifically asked for total savings. Since the savings percentage was given directly in relation to income, the expenditure details were not strictly necessary for this particular calculation, though they might be needed for other questions based on the same table.

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