Analyzing Employee Distribution Across Cities and Departments

The question asks us to determine the number of cities where the combined count of employees in the Finance and Accounts departments is more than 415. To solve this, we first need to find the total number of employees in Bengaluru and Hyderabad, as these values are missing from the table. Then, we need to calculate the number of employees working in the Finance and Accounts departments for each city using the given percentage distributions.

Step 1: Calculate the Number of Employees in Bengaluru and Hyderabad

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

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

The sum of employees in these three cities is: \[ \text{Sum} = 900 + 760 + 700 = 2360 \] The remaining employees are in Bengaluru and Hyderabad: \[ \text{Employees in Bengaluru} + \text{Employees in Hyderabad} = 4260 - 2360 = 1900 \] Let \(B\) be the number of employees in Bengaluru and \(H\) be the number of employees in Hyderabad. So, \(B + H = 1900\). We are also told that the number of employees in Bengaluru is 10% less than in Hyderabad. \[ B = H - 10\% \text{ of } H = H - 0.10H = 0.90H \] Substitute this into the sum equation: \[ 0.90H + H = 1900 \] \[ 1.90H = 1900 \] \[ H = \frac{1900}{1.90} = 1000 \] Now find \(B\): \[ B = 0.90 \times 1000 = 900 \] So, the number of employees in Bengaluru is 900, and in Hyderabad is 1000.

The updated employee counts per city are:

• Delhi: 900
• Mumbai: 760
• Bengaluru: 900
• Hyderabad: 1000
• Gurgaon: 700

Total employees = \(900 + 760 + 900 + 1000 + 700 = 4260\). This matches the given total.

Step 2: Calculate Employees in Finance and Accounts Departments per City

We need to calculate the total number of employees in Finance and Accounts departments for each city. The sum of percentages for all four departments (HR, Finance, IT, Accounts) in a city must equal 100%.

• Delhi: Total Employees = 900. Percentages: Finance=18%, Accounts=28%. Combined percentage (Finance + Accounts) = \(18\% + 28\% = 46\%\). Number of employees (Finance + Accounts) = \(46\% \text{ of } 900 = 0.46 \times 900 = 414\).
• Mumbai: Total Employees = 760. Percentages: HR=15%, IT=30%. Finance and Accounts percentages are missing. The combined percentage for Finance and Accounts is \(100\% - (\text{HR}\% + \text{IT}\%) = 100\% - (15\% + 30\%) = 100\% - 45\% = 55\%\). Number of employees (Finance + Accounts) = \(55\% \text{ of } 760 = 0.55 \times 760 = 418\).
• Bengaluru: Total Employees = 900. Percentages: Finance=18%, IT=20%, Accounts=32%. HR percentage is missing. Combined percentage (Finance + Accounts) = \(18\% + 32\% = 50\%\). Number of employees (Finance + Accounts) = \(50\% \text{ of } 900 = 0.50 \times 900 = 450\).
• Hyderabad: Total Employees = 1000. Percentages in the table are listed as --, 25%, 18%, 35% under HR, Finance, IT, Accounts headers. Assuming the order corresponds to the headers (HR, Finance, IT, Accounts), the percentages are: HR(-), Finance(25%), IT(18%), Accounts(35%). Combined percentage (Finance + Accounts) = \(25\% + 35\% = 60\%\). Number of employees (Finance + Accounts) = \(60\% \text{ of } 1000 = 0.60 \times 1000 = 600\).
• Gurgaon: Total Employees = 700. Percentages: HR=20%, Finance=22%, Accounts=20%. IT percentage is missing. Combined percentage (Finance + Accounts) = \(22\% + 20\% = 42\%\). Number of employees (Finance + Accounts) = \(42\% \text{ of } 700 = 0.42 \times 700 = 294\).

Step 3: Identify Cities with More Than 415 Employees in Finance and Accounts

Now, we compare the calculated number of employees in Finance and Accounts for each city with the value 415.

• Delhi: 414. Is \(414 > 415\)? No.
• Mumbai: 418. Is \(418 > 415\)? Yes.
• Bengaluru: 450. Is \(450 > 415\)? Yes.
• Hyderabad: 600. Is \(600 > 415\)? Yes.
• Gurgaon: 294. Is \(294 > 415\)? No.

The cities where the total number of employees in Finance and Accounts departments is more than 415 are Mumbai, Bengaluru, and Hyderabad.

Step 4: Count the Number of Such Cities

There are 3 cities (Mumbai, Bengaluru, and Hyderabad) that satisfy the condition.

Therefore, the total number of employees who work in Finance and Accounts departments of the organization is more than 415 in exactly three cities.

Revision Table: Key Calculations

Additional Information on Percentage Distribution

Data interpretation questions often involve calculating values based on percentages. A percentage represents a part of a whole, expressed as a fraction of 100. In this problem, the percentage distribution shows how the total number of employees in a city is divided among different departments.

Key concepts used:

• Percentage Calculation: To find a percentage of a number, convert the percentage to a decimal (divide by 100) and multiply it by the number. For example, 46% of 900 is \(0.46 \times 900\).
• Sum of Percentages: In a distribution covering all categories (like departments in a city), the percentages must add up to 100%. This allows us to find missing percentages if the others are known. For instance, in Mumbai, Finance + Accounts percentage is 100% minus the sum of HR and IT percentages.
• Solving Linear Equations: To find the missing total number of employees in Bengaluru and Hyderabad, we set up a linear equation based on the total number of employees and the relationship between Bengaluru and Hyderabad employees.

Careful reading and interpretation of the table data, including how missing values and given percentages correspond to the departments, are crucial for accurately solving such problems. Pay close attention to notes provided alongside the table.