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

Diagram

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:

  1. A

    Danni, Tinni, Bahni, Abani

    Answer A in PrepSoc practice
  2. B

    Danni, Tinni, Abani, Bahni

    Answer B in PrepSoc practice
  3. C

    Tinni, Danni, Abani, Bahni

    Answer C in PrepSoc practice
  4. D

    Bahni, Abani, Tinni, Danni

    Answer D in PrepSoc practice

Answer this questionOr tap an option. Opens in practice mode, free, no sign-in.

Show answer and solution

Answer: (B)

Danni, Tinni, Abani, Bahni

Solution

Concept: Weighted Average Calculation, Performance Index Ranking & Common Denominator Simplification

Master State Table

ProjectActive SpanDurationAbaniBahniDanniTinniTotal Emp-Mo
Project 1Jan 1 – Apr 13 MonthsFeb–Apr (2 mo, 100%)Feb–Apr (2 mo, 100%)—Jan–Mar (2 mo, 80%)6 Months
Project 2Feb 1 – May 13 Months——Feb–May (3 mo, 90%)Mar–May (2 mo, 100%)5 Months
Project 3Apr 1 – Sep 15 MonthsMay–Jul (2 mo, 100%)Apr–Aug (4 mo, 75%)Jun–Sep (3 mo, 100%)—9 Months
Project 4Jul 1 – Dec 15 MonthsJul–Dec (5 mo, 80%)—Sep–Nov (2 mo, 100%)Jul–Oct (3 mo, 100%)10 Months
Project 5Sep 1 – Jan 14 Months—Oct–Jan (3 mo, 90%)Dec–Jan (1 mo, 100%)Sep–Nov (2 mo, 100%)6 Months
Total Project-Months——9 Months9 Months9 Months9 Months36 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 (99) 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 =2(100)+2(100)+5(80)=800  ⟹  Index=8009≈88.89%= 2(100) + 2(100) + 5(80) = 800 \implies \text{Index} = \frac{800}{9} \approx 88.89\%.

• Bahni: Weighted sum =2(100)+4(75)+3(90)=770  ⟹  Index=7709≈85.56%= 2(100) + 4(75) + 3(90) = 770 \implies \text{Index} = \frac{770}{9} \approx 85.56\%.

• Danni: Weighted sum =3(90)+3(100)+2(100)+1(100)=870  ⟹  Index=8709≈96.67%= 3(90) + 3(100) + 2(100) + 1(100) = 870 \implies \text{Index} = \frac{870}{9} \approx 96.67\%.

• Tinni: Weighted sum =2(80)+2(100)+3(100)+2(100)=860  ⟹  Index=8609≈95.56%= 2(80) + 2(100) + 3(100) + 2(100) = 860 \implies \text{Index} = \frac{860}{9} \approx 95.56\%.

• Ordering Employees by Annual Completion Index:

• Comparing numerators: 870(Danni)>860(Tinni)>800(Abani)>770(Bahni)870 (\text{Danni}) > 860 (\text{Tinni}) > 800 (\text{Abani}) > 770 (\text{Bahni}).

• In percentages: 96.67%>95.56%>88.89%>85.56%96.67\% > 95.56\% > 88.89\% > 85.56\%.

• 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

  1. Q13. Which of the following statements is/are true? I: The total project-month was the same for the four employees. II: The…
  2. Q14. Which employees did not work in multiple projects for any of the months in 2020?
  3. 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

  1. CAT 2025 Slot 1 DILR Q1
    How much is Japan's export to India worth?
  2. CAT 2025 Slot 1 DILR Q2
    Which among the following is the highest?
  3. CAT 2025 Slot 1 DILR Q3
    What is the trade surplus/trade deficit of India with UK?
  4. CAT 2025 Slot 1 DILR Q4
    Among France and UK, who has/have trade surplus(es) with US?
  5. CAT 2025 Slot 3 DILR Q6
    Who had solved the largest number of puzzles by the 20-th minute from the start of the competition?

Practise this question with timing, notes and your mistake notebook.

Practise in PrepSoc