CAT 2021 Slot 2 DILR Q3

  • Data Interpretation and Logical Reasoning
  • Data Interpretation › Bar Graphs
  • Easy
  • Multiple choice
  • CAT_2021_SLOT2_DILR_Q03

Data set · questions 1–4

Diagram

The different bars in the diagram above provide information about different orders in various categories (Art, Binders, ....) that were booked in the first two weeks of September of a store for one client. The colour and pattern of a bar denotes the ship mode (First Class / Second Class / Standard Class). The left end point of a bar indicates the booking day of the order, while the right end point indicates the dispatch day of the order. The difference between the dispatch day and the booking day (measured in terms of the number of days) is called the processing time of the order.

For the same category, an order is considered for booking only after the previous order of the same category is dispatched. No two consecutive orders of the same category had identical ship mode during this period.

For example, there were only two orders in the furnishing category during this period. The first one was shipped in the Second Class. It was booked on Sep 1 and dispatched on Sep 5. The second order was shipped in the Standard class. It was booked on Sep 5 (although the order might have been placed before that) and dispatched on Sep 12. So the processing times were 4 and 7 days respectively for these orders.

Question 3

The sequence of categories Art, Binders, Paper and Phones in decreasing order of average processing time of their orders in this period is:

  1. A

    Paper, Binders, Art, Phones

    Answer A in PrepSoc practice
  2. B

    Phones, Art, Binders, Paper

    Answer B in PrepSoc practice
  3. C

    Art, Binders, Paper, Phones

    Answer C in PrepSoc practice
  4. D

    Phones, Binders, Art, Paper

    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)

Phones, Art, Binders, Paper

Solution

Concept: Discrete Duration Aggregation, Arithmetic Mean & Monotonic Sequence Ranking

Master State Table

CategoryStandard Class (Booked–Dispatched)First Class (Booked–Dispatched)Second Class (Booked–Dispatched)Total OrdersTotal Days
AccessoriesSep 1–19 (18d)——118
AppliancesSep 4–12 (8d)—Sep 2–4 (2d)210
ArtSep 1–3 (2d), Sep 13–21 (8d)Sep 4–6 (2d)Sep 3–4 (1d), Sep 6–13 (7d)520
BindersSep 1–2 (1d), Sep 4–5 (1d)Sep 2–4 (2d)Sep 5–16 (11d)415
Bookcases—Sep 4–6 (2d)Sep 3–4 (1d), Sep 6–7 (1d)34
ChairsSep 2–3 (1d)—Sep 3–9 (6d)27
EnvelopesSep 3–7 (4d)——14
FastenersSep 2–4 (2d), Sep 6–8 (2d)—Sep 4–6 (2d)36
FurnishingsSep 5–12 (7d)—Sep 1–5 (4d)211
LabelsSep 4–12 (8d)—Sep 1–3 (2d)210
Paper—Sep 4–7 (3d)Sep 2–4 (2d), Sep 7–12 (5d)310
PhonesSep 2–4 (2d), Sep 5–17 (12d)Sep 4–5 (1d)—315
StorageSep 7–22 (15d)—Sep 2–7 (5d)220
TablesSep 2–4 (2d)—Sep 4–10 (6d)28
Total17 Orders5 Orders13 Orders35148

Question Deduction

• Evaluation Metric & Formula:

• For category CC with nn orders, average processing time is:

$$\bar{T}_C = \frac{\sum (\text{Dispatch Day} - \text{Booking Day})}{n}$$

• Rank Art, Binders, Paper, and Phones in decreasing order of Tˉ\bar{T}.

• Average Processing Time per Target Category:

• Phones (n=3n = 3): Orders span 2,1,122, 1, 12 days   ⟹  Total=15\implies \text{Total} = 15 days.

• Average: $\bar{T}_{\text{Phones}} = \frac{15}{3} = 5.00$ days.

• Art (n=5n = 5): Orders span 2,1,2,7,82, 1, 2, 7, 8 days   ⟹  Total=20\implies \text{Total} = 20 days.

• Average: $\bar{T}_{\text{Art}} = \frac{20}{5} = 4.00$ days.

• Binders (n=4n = 4): Orders span 1,2,1,111, 2, 1, 11 days   ⟹  Total=15\implies \text{Total} = 15 days.

• Average: $\bar{T}_{\text{Binders}} = \frac{15}{4} = 3.75$ days.

• Paper (n=3n = 3): Orders span 2,3,52, 3, 5 days   ⟹  Total=10\implies \text{Total} = 10 days.

• Average: $\bar{T}_{\text{Paper}} = \frac{10}{3} \approx 3.33$ days.

• Decreasing Rank Ordering:

• Comparing calculated means:

$$5.00\text{ (Phones)} > 4.00\text{ (Art)} > 3.75\text{ (Binders)} > 3.33\text{ (Paper)}$$

• Sequence: Phones, Art, Binders, Paper.

• Option Matching:

• Matches Option 2 (Phones, Art, Binders, Paper).

Topper Take

• Benchmark Bounds: Phones has a 12-day order pulling its average to 15/3=5.015/3 = 5.0. Art is 20/5=4.020/5 = 4.0, Binders is 15/4=3.7515/4 = 3.75, and Paper is 10/3=3.3310/3 = 3.33. Decreasing order is Phones > Art > Binders > Paper.

Other questions in this set

  1. Q1. How many days between Sep 1 and Sep 14 (both inclusive) had no booking from this client considering all the above…
  2. Q2. What was the average processing time of all orders in the categories which had only one type of ship mode?
  3. Q4. Approximately what percentage of orders had a processing time of one day during the period Sep 1 to Sep 22 (both dates…

Bar Graphs questions from other CAT papers

  1. CAT 2025 Slot 2 DILR Q15
    What was the total number of two-author and three-author papers written by Brajen?
  2. CAT 2025 Slot 2 DILR Q16
    Which of the following statements is/are NECESSARILY true? i. Chintan wrote exactly three two-author papers.…
  3. CAT 2025 Slot 2 DILR Q17
    Which of the following statements is/are NECESSARILY true? i. Arman wrote three-author papers only with…
  4. CAT 2025 Slot 2 DILR Q18
    If Devon wrote more than one two-author papers, then how many two-author papers did Chintan write?
  5. CAT 2024 Slot 1 DILR Q14
    What was the total number of stars received by D?

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

Practise in PrepSoc