Caselets and Tables – Logical Reasoning and Data Interpretation (LRDI) in CAT or any other MBA entrance exam, is about analyzing and interpreting data and bringing it to a meaningful conclusion. The huge pile of data needs to be sanitized, categorized, and then simplified into some information that can help in decision making. As a future manager, you need to understand how to translate this data into relevant information and figures.
LRDI in CAT, SNAP, XAT, and other exams have questions on Caselets and Tables every year. Data is given in the form of statements in Caselets di questions, which is then converted into a table and then solved.
In the LRDI section, most of the questions are in the form of caselets. A single set of caselet may have 34 questions. Few direct sets on Tables may be present. The sets are designed such that 1 to 2 questions can be attempted from each set.
Year  No of Sets  No of Questions  Good attempt  Difficulty 
2020  3  10  6  Difficult 
2019  2  6  4  Moderate 
The pattern and difficulty level of MAT is different from all the abovementioned exams. There are no Caselet type questions. Data is usually given in the table itself. All the questions are pretty much straightforward.
Year  No of Sets  No of Questions  Good attempt  Difficulty 
2020  1  5  4  Easy 
2019  1  5  45  Easy 
There are two types in which Caselet examples are prepared. Di Caselets and Tables questions in CAT, XAT, SNAP, etc. are of the following types:
1. Reasoning based paragraph – Caselets di questions of this type tests the application of various Reasoning concepts. Few types of caselet examples within this category are:
1.1. Sitting Arrangement – In this type, few people or things are arranged, and information is given in the form of relative positioning. You are supposed to decode their positions and answer the questions based on that
1.2. Games and Tournaments – Caselet di questions with the information of different players, rules of the game, and the number of matches played or to be played are given. You must interpret this information and answer the questions that follow
2. Numerical Data based paragraph – This type of Caselet di questions usually comes under the Data Interpretation part of different exams. There are no set concept or type for such caselet examples, it can be any data from which information needs to be extracted. The next step is to form the Table and solve the question
Question 1 – A chain of departmental stores has outlets in Delhi, Mumbai, Bengaluru and Kolkata. The sales are categorized by its three departments – ‘Apparel’, ‘Electronics’, and ‘HomeDecor’. An Accountant has been asked to prepare a summary of the 2018 and 2019 sales amounts for an internal report. He has collated partial information and prepared the following table. [CAT 2020]
The following additional information is known.
1. The sales amounts in the Apparel departments were the same for Delhi and Kolkata in2018.
2. The sales amounts in the Apparel departments were the same for Mumbai and Bengaluru in 2018. This sales amount matched the sales amount in the Apparel department for Delhi in2019.
3. The sales amounts in the Home Decor departments were the same for Mumbai and Kolkata in 2018.
4. The sum of the sales amounts of four Electronics departments increased by the same amount as the sum of the sales amounts of four Apparel departments from 2018 to 2019.
5. The total sales amounts of the four Home Decor departments increased by Rs 70 Crores from 2018 to 2019.
6. The sales amounts in the Home Decor departments of Delhi and Bengaluru each increased by Rs 20 Crores from 2018 to 2019.
7. The sales amounts in the Apparel departments of Delhi and Bengaluru each increased by the same amount in 2019 from 2018. The sales amounts in the Apparel departments of Mumbai and Kolkata also each increased by the same amount in 2019 from 2018.
8. The sales amounts in the Apparel departments of Delhi, Kolkata and Bengaluru in 2019 followed an Arithmetic Progression.
1. In HomeDecor departments of which cities were the sales amounts the highest in 2018and 2019, respectively?
A) Mumbai and Mumbai B) Delhi and Delhi C) Bengaluru and Delhi D) Mumbai and Delhi
2. What was the increase in sales amount, in Crore Rupees, in the Apparel department of Mumbai from 2018 to 2019?
A) 10 B) 5 C) 8 D) 12
3. Among all the 12 departments (i.e., the 3 departments in each of the 4 cities), what was the maximum percentage increase sales amount from 2018 to 2019?
A) 75 B) 50 C) 28 D) 25
4. What was the total sales amount, in Crore Rupees, in 2019 for the chain of departmental stores?
A) 600 B) 150 C) 750 D) 900
Given:
From point 1) , 2) and 3 following table can be made where x , y and z are sales amount of respective department in corresponding years. From point 6.
Sales amount of HomeDecor in Delhi in 2018 = 100 – 20 = 80
Sales amount of HomeDecor in Bangaluru in 2018 = 80 – 20 = 60

Sales Amounts (Crore Rupees) 


Delhi 
Mumbai 
Bengaluru 
Kolkata 

2018 
2019 
2018 
2019 
2018 
2019 
2018 
2019 

Apparels 
x 
y 
Y 

y 

X 
54 
Electronics 
78 
98 
82 
102 
90 
70 
80 
100 
HomeDecor 
80 
100 
Z 
72 
60 
80 
z 
54 
From point 8.
If sales amount of Apparels in Bangaluru in 2019 was k then
k + y = 2*54 = 108
k = 108 – y

Sales Amounts (Crore Rupees) 


Delhi 
Mumbai 
Bengaluru 
Kolkata 

2018 
2019 
2018 
2019 
2018 
2019 
2018 
2019 

Apparels 
x 
y 
Y 
m 
y 
108 – y 
X 
54 
Electronics 
78 
98 
82 
102 
90 
70 
80 
100 
HomeDecor 
80 
100 
Z 
72 
60 
80 
z 
54 
From point 7.
Y – x = (108 –y )y
Or 3y – x = 108 ———1) and
m –y = 54 –x
m = 54 + y x

Sales Amounts (Crore Rupees) 


Delhi 
Mumbai 
Bengaluru 
Kolkata 

2018 
2019 
2018 
2019 
2018 
2019 
2018 
2019 

Apparels 
x 
Y 
Y 
54 + y x 
y 
108 – y 
X 
54 
Electronics 
78 
98 
82 
102 
90 
70 
80 
100 
HomeDecor 
80 
100 
Z 
72 
60 
80 
z 
54 
Now from point 4:
(98 78 + 102 82 +70 – 90 + 100 – 80) = (54 + 108 – y + 54+y –x+ y) – 2x 2y
40 = 216 3x – y
3x + y = 176 ————2)
From eq 1 and eq 2)
3y – x= 108
3x + y = 176
On solving
y = 50 and x = 42
From point 5.
(100+72+80+54) – (80+60+2z) = 70
166 – 2z = 70
Or z = 48
Thus the final table will look like ,

Sales Amounts (Crore Rupees) 


Delhi 
Mumbai 
Bengaluru 
Kolkata 

2018 
2019 
2018 
2019 
2018 
2019 
2018 
2019 

Apparels 
42 
50 
50 
62 
50 
58 
42 
54 
Electronics 
78 
98 
82 
102 
90 
70 
80 
100 
HomeDecor 
80 
100 
48 
72 
60 
80 
48 
54 
1. 3)
2. required increase = 62 – 50 = 12
3. maximum percentage increase is for HomeDecor , which is = (72 48)/48 *100 = 50%
4. Required sum = (50+98+100)+(62+102+72)+(58+70+80)+(54+100+54) = 90
Preparing any topic from the scratch requires patience, hard work, and above all commitment. Tables and Caselets, not only require a thorough knowledge of all the concepts, but they also require a few tricks and shortcuts to be followed. Here are some Levelwise preparatory guidelines to follow:
1. Know your basics. All the types of Logical Reasoning questions should be tried before coming to Caselets and Tables in Reasoning based Caselet
2. Learn Speed calculation: For an effective and quick calculation, be thorough with tables till 20, memorize squares till 30, and cubes till 15. Extracting data from caselets into a table consumes most of the time; speedy calculation tricks can help you analyze data in the table quickly
3. Fraction – Percentage relation: Most of the questions require approximate calculations, knowing the percentage – fraction conversion will help solve the problem quickly
4. Practice beginner level questions on Arrangements, Games and Tournaments, and numerical caselet di questions.
5. Take help of live lectures and lecture notes. Go through MBAP CAT E Book (Concept Theory) study material and MBAP CAT E Book (Practice Questions).
1. Move on to more complex problems, attempt beginner and intermediate level mock on Tables and Caselets
2. Solve previous year questions on Tables and Caselets and keep a watch on time. Be careful while going through each point, a slight mistake in analyzing a single point will lead to a completely wrong solution
3. Keep attempting mocks to check your performance
4. Topicwise mocks, provided by MBAP, can be utilized to enhance your performance. Start practicing from MBAP Topic wise CAT previous year question paper
1. For advanced level preparation, start practising questions from “How to prepare for Data Interpretation” and “How to prepare for Logical Reasoning” by Arun Sharma
2. Questions in the books are categorized into Level of Difficulty (LOD); based upon your preparation level, start attempting 3 or 4 questions daily. Also solve questions from MBAP CAT Advance E books.
Inspiring Education… Assuring Success!!
Ⓒ 2020 – All Rights Are Reserved