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

HP-Showroom _________ experienced the highest percentage increase in average profit per outlet in 2021 over  that in 2020.

The correct answer is D

Understanding the Laptop Showroom Data and Profit Calculation

The question asks us to determine which HP-Showroom experienced the highest percentage increase in average profit per outlet from the year 2020 to 2021. We are provided with a table containing the number of outlets, average sales per outlet, and total profit for all outlets for six showrooms (A to F) for both years.

To find the average profit per outlet for each showroom, we need to divide the Total Profit of all Outlets by the Number of Outlets for that specific showroom and year.

The formula is:

\(\text{Average Profit per Outlet} = \frac{\text{Total Profit of all Outlets}}{\text{Number of Outlets}}\)

Calculating Average Profit per Outlet (2020 & 2021)

Let's calculate the average profit per outlet for each showroom in 2020 and 2021 using the data from the table:

HP-Showroom Number of Outlets (2020) Total Profit (Rs. Lakh) (2020) Average Profit per Outlet (Rs. Lakh) (2020) Number of Outlets (2021) Total Profit (Rs. Lakh) (2021) Average Profit per Outlet (Rs. Lakh) (2021)
A 2 80 \(\frac{80}{2} = 40\) 3 120 \(\frac{120}{3} = 40\)
B 4 250 \(\frac{250}{4} = 62.5\) 6 400 \(\frac{400}{6} \approx 66.67\)
C 1 80 \(\frac{80}{1} = 80\) 3 100 \(\frac{100}{3} \approx 33.33\)
D 5 240 \(\frac{240}{5} = 48\) 6 360 \(\frac{360}{6} = 60\)
E 3 300 \(\frac{300}{3} = 100\) 4 320 \(\frac{320}{4} = 80\)
F 5 30 \(\frac{30}{5} = 6\) 5 30 \(\frac{30}{5} = 6\)

Calculating Percentage Increase in Average Profit

Next, we calculate the percentage increase in average profit per outlet from 2020 to 2021 for each showroom. The formula for percentage increase is:

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

Let's apply this formula to each showroom:

  • Showroom A: Average Profit in 2020 = 40, Average Profit in 2021 = 40.
    Percentage Increase = \(\left( \frac{40 - 40}{40} \right) \times 100 = \left( \frac{0}{40} \right) \times 100 = 0\%\)
  • Showroom B: Average Profit in 2020 = 62.5, Average Profit in 2021 \(\approx\) 66.67.
    Percentage Increase = \(\left( \frac{66.67 - 62.5}{62.5} \right) \times 100 = \left( \frac{4.17}{62.5} \right) \times 100 \approx 6.67\%\)
  • Showroom C: Average Profit in 2020 = 80, Average Profit in 2021 \(\approx\) 33.33.
    Percentage Increase = \(\left( \frac{33.33 - 80}{80} \right) \times 100 = \left( \frac{-46.67}{80} \right) \times 100 \approx -58.34\%\) (This is a decrease)
  • Showroom D: Average Profit in 2020 = 48, Average Profit in 2021 = 60.
    Percentage Increase = \(\left( \frac{60 - 48}{48} \right) \times 100 = \left( \frac{12}{48} \right) \times 100 = \left( \frac{1}{4} \right) \times 100 = 25\%\)
  • Showroom E: Average Profit in 2020 = 100, Average Profit in 2021 = 80.
    Percentage Increase = \(\left( \frac{80 - 100}{100} \right) \times 100 = \left( \frac{-20}{100} \right) \times 100 = -20\%\) (This is a decrease)
  • Showroom F: Average Profit in 2020 = 6, Average Profit in 2021 = 6.
    Percentage Increase = \(\left( \frac{6 - 6}{6} \right) \times 100 = \left( \frac{0}{6} \right) \times 100 = 0\%\)

Comparing Percentage Increases in Average Profit

Let's summarize the percentage increase (or decrease) in average profit per outlet for each showroom:

HP-Showroom Percentage Increase in Average Profit (2021 over 2020)
A 0%
B \(\approx\) 6.67%
C \(\approx\) -58.34% (Decrease)
D 25%
E -20% (Decrease)
F 0%

Comparing the positive percentage increases (Showrooms B and D), Showroom D has a 25% increase, while Showroom B has approximately a 6.67% increase. Showrooms A and F had no change, and Showrooms C and E experienced decreases.

Therefore, Showroom D experienced the highest percentage increase in average profit per outlet in 2021 over that in 2020.

Revision Table: Key Data Points for HP Showrooms

HP-Showroom Avg Profit/Outlet (2020) Avg Profit/Outlet (2021) Percentage Change (2020-2021)
A 40 40 0%
B 62.5 \(\approx\) 66.67 \(\approx\) 6.67%
C 80 \(\approx\) 33.33 \(\approx\) -58.34%
D 48 60 25%
E 100 80 -20%
F 6 6 0%

Additional Information on Data Interpretation and Profit Analysis

Data interpretation questions often require careful reading of the tables or charts provided. In this case, it was crucial to distinguish between 'average sales per outlet' and 'average profit per outlet' and also between 'total profit of all outlets' and 'average profit per outlet'.

Key steps in solving such data analysis problems:

  • Understand exactly what is being asked (e.g., total vs. average, percentage change vs. absolute change).
  • Identify the relevant data points in the table or chart needed for the calculation.
  • Perform the necessary calculations accurately (like division for average, and percentage change formula).
  • Compare the results to answer the specific question asked.

Understanding profit metrics like total profit and average profit per outlet helps assess the performance efficiency of individual units (outlets) within a business.

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