All Exams Test series for 1 year @ тВ╣349 only
Question

The following table shows the details of

(i) number of outlets,

(ii) average sales (in Rs. Lakh) per outlet, and

(iii) total profit (in Rs. lakh) of all the outlets of six HP-showrooms A-F selling Laptops in two years 2020 and 2021.

Based on the data in the table, answer the question.

H.P. Showroom wise Sales and Profit Figures in two Years.

HP-Showrooms

Number of Outlets

Average Sales

(in Rs. Lakh) per Outlet

Total Profit

(in Rs. Lakh) of all the Outlets

2020

2021

2020

2021

2020

2021

A

2

3

100

110

80

120

B

4

6

340

360

250

400

C

1

3

120

140

80

100

D

5

6

180

240

240

360

E

3

4

360

350

300

320

F

5

5

80

60

30

30

The ratio of percentage increase in sales to the percentage increase in profit for the HP-Showroom D in all the outlets in 2021 over 2020, was __________.

The correct answer is 6 ∶  5  

Analyzing Sales and Profit Increase for HP-Showroom D (2020-2021)

The question asks for the ratio of the percentage increase in sales to the percentage increase in profit for HP-Showroom D from 2020 to 2021. We need to use the data provided in the table for Showroom D.

Extracting Data for HP-Showroom D

Let's first pull the relevant figures for Showroom D from the table:

Metric 2020 2021
Number of Outlets 5 6
Average Sales per Outlet (Rs. Lakh) 180 240
Total Profit (Rs. Lakh) 240 360

Calculating Total Sales for HP-Showroom D

Total sales for a showroom is calculated by multiplying the number of outlets by the average sales per outlet.

  • Total Sales in 2020 = Number of Outlets (2020) $\times$ Average Sales per Outlet (2020)
  • Total Sales in 2021 = Number of Outlets (2021) $\times$ Average Sales per Outlet (2021)

Let's calculate the total sales for Showroom D:

  • Total Sales (2020) = $5 \times 180 = 900$ Rs. Lakh
  • Total Sales (2021) = $6 \times 240 = 1440$ Rs. Lakh

Calculating Percentage Increase in Sales

The percentage increase in sales is calculated using the formula:

$$ \text{Percentage Increase in Sales} = \left( \frac{\text{Sales}_{2021} - \text{Sales}_{2020}}{\text{Sales}_{2020}} \right) \times 100 $$

Let's calculate the percentage increase in sales for Showroom D:

$$ \text{Percentage Increase in Sales} = \left( \frac{1440 - 900}{900} \right) \times 100 $$

$$ \text{Percentage Increase in Sales} = \left( \frac{540}{900} \right) \times 100 $$

$$ \text{Percentage Increase in Sales} = \frac{54}{90} \times 100 $$

$$ \text{Percentage Increase in Sales} = \frac{6}{10} \times 100 $$

$$ \text{Percentage Increase in Sales} = 0.6 \times 100 = 60\% $$

Calculating Percentage Increase in Profit

The percentage increase in profit is calculated using the formula:

$$ \text{Percentage Increase in Profit} = \left( \frac{\text{Profit}_{2021} - \text{Profit}_{2020}}{\text{Profit}_{2020}} \right) \times 100 $$

We already have the total profit figures for Showroom D:

  • Total Profit (2020) = 240 Rs. Lakh
  • Total Profit (2021) = 360 Rs. Lakh

Let's calculate the percentage increase in profit:

$$ \text{Percentage Increase in Profit} = \left( \frac{360 - 240}{240} \right) \times 100 $$

$$ \text{Percentage Increase in Profit} = \left( \frac{120}{240} \right) \times 100 $$

$$ \text{Percentage Increase in Profit} = \frac{1}{2} \times 100 $$

$$ \text{Percentage Increase in Profit} = 0.5 \times 100 = 50\% $$

Calculating the Ratio of Percentage Increases

The question asks for the ratio of the percentage increase in sales to the percentage increase in profit.

$$ \text{Ratio} = \frac{\text{Percentage Increase in Sales}}{\text{Percentage Increase in Profit}} $$

$$ \text{Ratio} = \frac{60\%}{50\%} = \frac{60}{50} = \frac{6}{5} $$

The ratio is $6:5$.

Conclusion

The ratio of percentage increase in sales to the percentage increase in profit for HP-Showroom D in 2021 over 2020 is $6:5$. This corresponds to Option 4.

Revision Table: HP-Showroom D Analysis

Metric Formula/Calculation Value (2020) Value (2021) Change Percentage Increase
Total Sales Outlets $\times$ Avg. Sales $5 \times 180 = 900$ $6 \times 240 = 1440$ $1440 - 900 = 540$ $(540/900) \times 100 = 60\%$
Total Profit Given 240 360 $360 - 240 = 120$ $(120/240) \times 100 = 50\%$
Ratio (Sales % Inc : Profit % Inc) (Sales % Inc) / (Profit % Inc) - - - $60\% / 50\% = 6/5$

Additional Information: Data Interpretation and Percentage Change

Understanding how to interpret data from tables and calculate percentage changes is crucial for data interpretation questions. A percentage change tells us the relative increase or decrease of a value compared to its initial value.

  • The formula for percentage change is $\left( \frac{\text{New Value} - \text{Original Value}}{\text{Original Value}} \right) \times 100$.
  • A positive result indicates a percentage increase, while a negative result indicates a percentage decrease.
  • In this problem, we calculated the total sales based on the number of outlets and average sales, which is a common step in data interpretation problems involving aggregated data.
  • Ratios help compare two quantities. Here, we compared the magnitude of the percentage increase in sales relative to the percentage increase in profit for the same entity (HP-Showroom D) over the same period.
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