Understanding the Employee Data

The question provides a table showing the number of employees in an organization across five cities: Delhi, Mumbai, Bengaluru, Hyderabad, and Gurgaon. It also gives the percentage distribution of employees within four departments: HR, Finance, IT, and Accounts for each city. Some values are missing and need to be calculated. The total number of employees in the organization is 4260, but this total is not directly needed to answer this specific question, which focuses only on employees in Mumbai and Gurgaon.

The task is to find the total number of employees working in the IT department in Mumbai and Gurgaon combined.

Analyzing the Data Table for Mumbai and Gurgaon

Let's look at the relevant parts of the table for Mumbai and Gurgaon:

For Mumbai, the total number of employees is 760. The percentage of employees in the IT department is directly given as 30%.

For Gurgaon, the total number of employees is 700. The percentage of employees in the IT department is missing ('-'). We are given the percentages for HR (20%), Finance (22%), and Accounts (20%). Since each employee works in only one department, the sum of percentages for all departments in a city must be 100%.

Step-by-Step Calculation of IT Employees

Calculating IT Employees in Mumbai

The total number of employees in Mumbai is 760.

The percentage of employees in the IT department in Mumbai is 30%.

Number of IT employees in Mumbai = Total employees in Mumbai × Percentage of IT employees in Mumbai

Number of IT employees in Mumbai = $760 \times 30\%$

Number of IT employees in Mumbai = $760 \times \frac{30}{100}$

Number of IT employees in Mumbai = $76 \times 3 = 228$

So, there are 228 employees in the IT department in Mumbai.

Calculating IT Employees in Gurgaon

The total number of employees in Gurgaon is 700.

The percentages for HR, Finance, and Accounts in Gurgaon are 20%, 22%, and 20% respectively.

The sum of known percentages = Percentage in HR + Percentage in Finance + Percentage in Accounts

Sum of known percentages = $20\% + 22\% + 20\% = 62\%$

The percentage of employees in the IT department in Gurgaon is the remaining percentage to reach 100%.

Percentage of IT employees in Gurgaon = $100\% - \text{Sum of known percentages}$

Percentage of IT employees in Gurgaon = $100\% - 62\% = 38\%$

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

Number of IT employees in Gurgaon = Total employees in Gurgaon × Percentage of IT employees in Gurgaon

Number of IT employees in Gurgaon = $700 \times 38\%$

Number of IT employees in Gurgaon = $700 \times \frac{38}{100}$

Number of IT employees in Gurgaon = $7 \times 38 = 266$

So, there are 266 employees in the IT department in Gurgaon.

Calculating Total IT Employees in Mumbai and Gurgaon

To find the total number of employees in Mumbai and Gurgaon who work in the IT department, we add the number of IT employees from both cities.

Total IT employees = IT employees in Mumbai + IT employees in Gurgaon

Total IT employees = $228 + 266$

Total IT employees = $494$

Final Answer

The total number of employees in Mumbai and Gurgaon who work in the IT department is 494.

Revision Table: Key Concepts and Calculations

Additional Information: Data Interpretation Skills

This question is an example of data interpretation based on tables. Such questions often require calculating values from percentages or finding missing data points based on given totals or sums. Key skills needed include:

• Carefully reading the table and understanding the data presented.
• Identifying the specific information required by the question.
• Understanding the relationship between total values and percentage distributions.
• Performing basic arithmetic operations (multiplication, addition, subtraction) accurately.
• Calculating missing values when necessary, often using the fact that percentages for departments in a city sum up to 100%.

Practice with different types of tables and charts helps improve data interpretation skills for exams.