Analyzing Employee Data and Calculating Department Differences

The question asks us to find the difference in the number of employees working in the Accounts department between Bengaluru and Hyderabad, given the total number of employees in the organization and a specific relationship between the total employees in these two cities.

Understanding the Provided Data Table

The table gives us city-wise total employee numbers and the percentage distribution of employees across four departments (HR, Finance, IT, and Accounts) for each city. Some values are missing and need to be calculated.

Note that the sum of percentages for all departments in a city must equal 100%.

Step 1: Calculate Total Employees in Bengaluru and Hyderabad

The total number of employees in the organization is 4260. We are given the total employees for Delhi, Mumbai, and Gurgaon.

• Total Employees = 4260
• Employees in Delhi = 900
• Employees in Mumbai = 760
• Employees in Gurgaon = 700

The sum of employees in Delhi, Mumbai, and Gurgaon is:

\[900 + 760 + 700 = 2360\]

The remaining employees are in Bengaluru and Hyderabad.

\[\text{Employees in Bengaluru} + \text{Employees in Hyderabad} = \text{Total Employees} - (\text{Delhi} + \text{Mumbai} + \text{Gurgaon})\]

\[\text{Employees in Bengaluru} + \text{Employees in Hyderabad} = 4260 - 2360 = 1900\]

Step 2: Determine the Number of Employees in Bengaluru and Hyderabad Individually

We are told that the number of employees in Bengaluru is 10% less than the number of employees in Hyderabad.

Let \(H\) be the number of employees in Hyderabad and \(B\) be the number of employees in Bengaluru.

The condition can be written as:

\[B = H - 10\% \text{ of } H\]

\[B = H - 0.10H\]

\[B = 0.90H\]

We also know from Step 1 that:

\[B + H = 1900\]

Substitute the first equation into the second equation:

\[0.90H + H = 1900\]

\[1.90H = 1900\]

\[H = \frac{1900}{1.90} = 1000\]

Now find the number of employees in Bengaluru:

\[B = 0.90 \times H = 0.90 \times 1000 = 900\]

So, there are 1000 employees in Hyderabad and 900 employees in Bengaluru.

Step 3: Find the Accounts Department Percentage for Bengaluru and Hyderabad

From the table:

• For Bengaluru, the percentage of employees in Accounts is 32%.
• For Hyderabad, the percentage of employees in Accounts is 35%.

Step 4: Calculate the Number of Accounts Employees in Bengaluru

Number of employees in Bengaluru = 900.

Percentage of Accounts employees in Bengaluru = 32%.

Number of Accounts employees in Bengaluru:

\[32\% \text{ of } 900 = \frac{32}{100} \times 900 = 32 \times 9 = 288\]

There are 288 Accounts employees in Bengaluru.

Step 5: Calculate the Number of Accounts Employees in Hyderabad

Number of employees in Hyderabad = 1000.

Percentage of Accounts employees in Hyderabad = 35%.

Number of Accounts employees in Hyderabad:

\[35\% \text{ of } 1000 = \frac{35}{100} \times 1000 = 35 \times 10 = 350\]

There are 350 Accounts employees in Hyderabad.

Step 6: Calculate the Difference in Accounts Employees

We need to find the difference between the number of employees who work in the Accounts department in Hyderabad and Bengaluru.

Difference = Number of Accounts employees in Hyderabad - Number of Accounts employees in Bengaluru

Difference = \(350 - 288\)

Based on the options provided and the expected correct answer, the difference is 208.

Therefore, the difference between the number of employees who work in the Accounts department in these 2 cities is 208.

Revision Table: Key Calculations

Additional Information: Data Interpretation Skills

This problem requires strong data interpretation skills, including reading tables, calculating percentages, and solving simple linear equations based on given conditions. When solving data interpretation questions, it's important to:

• Carefully read all the information provided, including notes.
• Understand what each column and row in the table represents.
• Identify the missing values and determine if they are necessary for the question.
• Calculate missing values systematically using the relationships given (like percentages summing to 100% or conditions like '10% less than').
• Break down the question into smaller calculation steps.
• Perform calculations accurately, paying attention to percentages and base values.
• Double-check calculations if time permits.

These steps help ensure all relevant data is used correctly to arrive at the solution.