CAT 2021 Slot 3 DILR Q16
- Data Interpretation and Logical Reasoning
- Data Interpretation › Other Charts
- Easy
- Multiple choice
- CAT_2021_SLOT3_DILR_Q16
Data set · questions 13–16
The figure above shows the schedule of four employees – Abani, Bahni, Danni and Tinni –whom Dhoni supervised in 2020. Altogether there were five projects which started and concluded in 2020 in which they were involved. For each of these projects and for each employee, the starting day was at the beginning of a month and the concluding day was the end of a month, and these are indicated by the left and right end points of the corresponding horizontal bars. The number within each bar indicates the percentage of assigned work completed by the employee for that project, as assessed by Dhoni.
For each employee, his/her total project-month (in 2020) is the sum of the number of months(s)he worked across the five project, while his/her annual completion index is the weight age average of the completion percentage assigned from the different projects, with the weights being the corresponding number of months she worked in these projects. For each project, the total employee-month is the sum of the number of months four employees worked in this project, while its completion index is the weight age average of the completion percentage assigned for the employees who worked in this project, with the weights being the corresponding number of months they worked in this project.
Question 16
The list of employees in decreasing order of annual completion index is:
Show answer and solution
Answer: (B)
Danni, Tinni, Abani, Bahni
Solution
Concept: Weighted Average Calculation, Performance Index Ranking & Common Denominator Simplification
Master State Table
| Project | Active Span | Duration | Abani | Bahni | Danni | Tinni | Total Emp-Mo |
|---|---|---|---|---|---|---|---|
| Project 1 | Jan 1 – Apr 1 | 3 Months | Feb–Apr (2 mo, 100%) | Feb–Apr (2 mo, 100%) | — | Jan–Mar (2 mo, 80%) | 6 Months |
| Project 2 | Feb 1 – May 1 | 3 Months | — | — | Feb–May (3 mo, 90%) | Mar–May (2 mo, 100%) | 5 Months |
| Project 3 | Apr 1 – Sep 1 | 5 Months | May–Jul (2 mo, 100%) | Apr–Aug (4 mo, 75%) | Jun–Sep (3 mo, 100%) | — | 9 Months |
| Project 4 | Jul 1 – Dec 1 | 5 Months | Jul–Dec (5 mo, 80%) | — | Sep–Nov (2 mo, 100%) | Jul–Oct (3 mo, 100%) | 10 Months |
| Project 5 | Sep 1 – Jan 1 | 4 Months | — | Oct–Jan (3 mo, 90%) | Dec–Jan (1 mo, 100%) | Sep–Nov (2 mo, 100%) | 6 Months |
| Total Project-Months | — | — | 9 Months | 9 Months | 9 Months | 9 Months | 36 Months |
| Annual Completion Index | — | — | 88.89% | 85.56% | 96.67% | 95.56% | — |
Question Deduction
• Understanding Annual Completion Index:
• The annual completion index is the weighted average of completion percentages assigned to an employee, weighted by months worked:
$$\text{Annual Completion Index} = \frac{\sum (\text{Months Worked} \times \text{Completion } \%)}{\text{Total Project-Months Worked}}$$
• Because every employee worked exactly 9 project-months, the denominator () is identical for all four.
• Ranking employees is thus mathematically equivalent to comparing their weighted numerators.
• Computing the Annual Completion Index for Each Employee:
• Abani: Weighted sum .
• Bahni: Weighted sum .
• Danni: Weighted sum .
• Tinni: Weighted sum .
• Ordering Employees by Annual Completion Index:
• Comparing numerators: .
• In percentages: .
• The decreasing order is Danni, Tinni, Abani, Bahni.
• Option Matching / Numerical Answer:
• Matches Option 2 (Danni, Tinni, Abani, Bahni).
Topper Take
• Common Denominator Shortcut: With all denominators equal to 9, avoid division. Compare numerators directly: Danni (870) > Tinni (860) > Abani (800) > Bahni (770) locks Option 2 in seconds.
Other questions in this set
- Q13. Which of the following statements is/are true? I: The total project-month was the same for the four employees. II: The…
- Q14. Which employees did not work in multiple projects for any of the months in 2020?
- Q15. The project duration, measured in terms of the number of months, is the time duringwhich at least one employee worked…
Other Charts questions from other CAT papers
- CAT 2025 Slot 1 DILR Q1
- CAT 2025 Slot 1 DILR Q2
- CAT 2025 Slot 1 DILR Q3
- CAT 2025 Slot 1 DILR Q4
- CAT 2025 Slot 3 DILR Q6
Practise this question with timing, notes and your mistake notebook.
Practise in PrepSoc