Total Ratings:
Total ratings of all employees:
\[ \text{Total} = 8 \times 30 = 240 \]
Top Five and Bottom Three Totals:
Total ratings of the top five employees:
\[ \text{Top Five Total} = 5 \times 38 = 190 \]
Total ratings of the bottom three employees:
\[ \text{Bottom Three Total} = 3 \times 25 = 75 \]
Verification of Totals:
The total ratings of all employees:
\[ \text{Sum of Top Five + Bottom Three} = 190 + 75 = 265 \]
This exceeds the total ratings of 240, so adjustments are required.
Analyze the Options:
(A) One of the top five employees has a rating of 50:
If one top employee has a rating of 50, the remaining total for the top four is:
\[ 190 - 50 = 140, \quad \text{Average for four} = \frac{140}{4} = 35 \]
This is possible, as the remaining ratings align with the data.
(B) The lowest rating among the bottom three employees is 20:
If one bottom employee has a rating of 20, the remaining total for the other two is:
\[ 75 - 20 = 55, \quad \text{Average for two} = \frac{55}{2} = 27.5 \]
This is possible, as the averages match.
(C) The highest rating among the top five employees is 40:
If the highest top employee rating is 40, then the remaining total for the other four is:
\[ 190 - 40 = 150, \quad \text{Average for four} = \frac{150}{4} = 37.5 \]
This contradicts the given average of 38, making this impossible.
(D) One of the bottom three employees has a rating of 24:
If one bottom employee has a rating of 24, the remaining total for the other two is:
\[ 75 - 24 = 51, \quad \text{Average for two} = \frac{51}{2} = 25.5 \]
This is possible, as it satisfies the conditions.
Thus, the correct answer is (C).
Light Chemicals is an industrial paint supplier with presence in three locations: Mumbai, Hyderabad and Bengaluru. The sunburst chart below shows the distribution of the number of employees of different departments of Light Chemicals. There are four departments: Finance, IT, HR and Sales. The employees are deployed in four ranks: junior, mid, senior and executive. The chart shows four levels: location, department, rank and gender (M: male, F: female). At every level, the number of employees at a location/department/rank/gender are proportional to the corresponding area of the region represented in the chart.
Due to some issues with the software, the data on junior female employees have gone missing. Notice that there are junior female employees in Mumbai HR, Sales and IT departments, Hyderabad HR department, and Bengaluru IT and Finance departments. The corresponding missing numbers are marked u, v, w, x, y and z in the diagram, respectively.
It is also known that:
a) Light Chemicals has a total of 210 junior employees.
b) Light Chemicals has a total of 146 employees in the IT department.
c) Light Chemicals has a total of 777 employees in the Hyderabad office.
d) In the Mumbai office, the number of female employees is 55.

An investment company, Win Lose, recruit's employees to trade in the share market. For newcomers, they have a one-year probation period. During this period, the employees are given Rs. 1 lakh per month to invest the way they see fit. They are evaluated at the end of every month, using the following criteria:
1. If the total loss in any span of three consecutive months exceeds Rs. 20,000, their services are terminated at the end of that 3-month period,
2. If the total loss in any span of six consecutive months exceeds Rs. 10,000, their services are terminated at the end of that 6-month period.
Further, at the end of the 12-month probation period, if there are losses on their overall investment, their services are terminated.
Ratan, Shri, Tamal and Upanshu started working for Win Lose in January. Ratan was terminated after 4 months, Shri was terminated after 7 months, Tamal was terminated after 10 months, while Upanshu was not terminated even after 12 months. The table below, partially, lists their monthly profits (in Rs. ‘000’) over the 12-month period, where x, y and z are masked information.
Note:
• A negative profit value indicates a loss.
• The value in any cell is an integer.
Illustration: As Upanshu is continuing after March, that means his total profit during January-March (2z +2z +0) ≥
Rs.20,000. Similarly, as he is continuing after June, his total profit during January − June ≥
Rs.10,000, as well as his total profit during April-June ≥ Rs.10,000.