Understanding the Employee Distribution Data

This problem requires us to analyze data presented in a table showing the number of employees in an organization distributed across different cities and departments. We are given the total number of employees and the percentage breakdown within each city for four departments: HR, Finance, IT, and Accounts. Some values are missing and need to be calculated based on the information provided and a specific condition given in the question.

Here is the relevant data from the table for the cities involved in the question (Mumbai and Gurgaon):

Step-by-Step Solution for Calculating Finance Employees in Mumbai

We need to find the number of employees in the Finance department in Mumbai. The question provides a condition relating the number of Accounts employees in Mumbai to the number of IT employees in Gurgaon.

Calculate IT Employees in Gurgaon

First, let's find the percentage of employees in the IT department in Gurgaon. The sum of percentages for all departments in a city must be 100%.

• Known percentages for Gurgaon: HR (20%), Finance (22%), Accounts (20%).
• Sum of known percentages = 20% + 22% + 20% = 62%.
• Missing percentage (IT) = 100% - Sum of known percentages
• IT percentage in Gurgaon = \(100\% - 62\% = 38\%\).

Now, we calculate the number of IT employees in Gurgaon.

• Total employees in Gurgaon = 700.
• IT employees in Gurgaon = 38% of 700.
• IT employees in Gurgaon = \(\frac{38}{100} \times 700 = 38 \times 7 = 266\).

Calculate Accounts Employees in Mumbai

The question states that the number of employees in the Accounts department in Mumbai is 38 more than the number of employees in the IT department in Gurgaon.

• IT employees in Gurgaon = 266 (calculated above).
• Accounts employees in Mumbai = IT employees in Gurgaon + 38.
• Accounts employees in Mumbai = \(266 + 38 = 304\).

Calculate the Percentage of Accounts Employees in Mumbai

We know the number of Accounts employees in Mumbai and the total number of employees in Mumbai. We can now find the percentage.

• Total employees in Mumbai = 760.
• Accounts employees in Mumbai = 304.
• Accounts percentage in Mumbai = \(\left(\frac{\text{Accounts employees in Mumbai}}{\text{Total employees in Mumbai}}\right) \times 100\%\).
• Accounts percentage in Mumbai = \(\left(\frac{304}{760}\right) \times 100\%\).
• \(\frac{304}{760} = \frac{30.4}{76} = \frac{15.2}{38} = \frac{7.6}{19} = 0.4\).
• Accounts percentage in Mumbai = \(0.4 \times 100\% = 40\%\).

Calculate the Percentage of Finance Employees in Mumbai

In Mumbai, the percentages for HR, Finance, IT, and Accounts must sum up to 100%.

• Known percentages for Mumbai: HR (15%), IT (30%), Accounts (40%) [calculated above].
• Sum of known percentages = 15% + 30% + 40% = 85%.
• Missing percentage (Finance) = 100% - Sum of known percentages.
• Finance percentage in Mumbai = \(100\% - 85\% = 15\%\).

Calculate Finance Employees in Mumbai

Finally, we calculate the number of Finance employees in Mumbai using the total number of employees in Mumbai and the calculated Finance percentage.

• Total employees in Mumbai = 760.
• Finance percentage in Mumbai = 15%.
• Finance employees in Mumbai = 15% of 760.
• Finance employees in Mumbai = \(\frac{15}{100} \times 760 = 0.15 \times 760\).
• \(0.15 \times 760 = 114\).

Therefore, the number of employees who work in the Finance department in Mumbai is 114.

Revision Table: Key Calculations

Additional Information on Data Interpretation

Data interpretation questions often require careful reading of tables, charts, and graphs to extract necessary information. Key skills involved include:

• Percentage Calculation: Understanding how to calculate a percentage of a number, or find the number corresponding to a percentage.
• Missing Values: Using the property that percentages within a category (like departments in a city) sum up to 100% to find missing values.
• Applying Conditions: Using specific conditions or relationships given in the question to link different data points.
• Step-by-Step Approach: Breaking down the problem into smaller, manageable steps to arrive at the final answer.
• Checking Units: Ensuring consistency in using percentages and absolute numbers.

Practicing with different types of data representation (tables, bar graphs, pie charts, line graphs) is crucial for mastering data interpretation skills for exams. Always double-check your calculations to avoid errors.