CAT Previous Year Questions: Bar Graphs - Logical Reasoning (LR) and Data Interpretation (DI)

The total sales from products in the office supply category in 2019 is :
Sum of sales of :
Binders: 3.6 million
Art : 0.4 million.
Appliances:  1.9 million
Envelops: 0.3 million
Fasteners: 0.1 million
Labels: 0.2 million
Paper = 1.5 million.
Storage: 4.3 million.
Supplies: 1.1 million.
The sum of sales of these products = 3.6+0.4+1.9+0.3+0.1+0.2+1.5+4.3+1.1 = 13.4 million.
The closest among the option is 13.5 million.

The percentage increase in sales in the furniture category from 2019 to 2020 are :
Bookcases: 1.9 million in 2019 and 2.2 million in 2020.
Chairs: 6.2 million in 2019 and 7 million in 2020.
Furnishings: 2.05 million in 2019 and 2.1 million in 2020.
Tables: 4.4 million in 2019 and 4.5 million in 2020.
Hence the percentage increase is given by :

The improvement index for a category is the maximum percentage increase in sales from 2019 to 2020 among any of its subcategories.
Hence based on the information provided in the tabular data we need to look for the different subcategories where the rise in sales from 2019 to 2020 is higher.
Based on the visual data :
In the furniture category :
Bookcases and Chairs have a relatively high percentage increase :
Books cases: 1.9 million to 2.2 million (15.7 percent increase)
Chairs: 6.2 million to 7 million (12.9 percent increase)
In the office supply category :
Binders and Appliances have a relatively high percentage increase :
Binders: 3.6 million to 5.3 million (47 percent increase)
Appliances: 1.9 million to 3.15 million (65.7 percent increase)
In technology product category :
Accessories: 3.1 to 4.4 million. (41.9 percent increase)
Phones: 5.8 million to 7.7 million (32.7 percent increase)
Hence among the categories :
The highest increase among them is in the order :
Furniture < Technology product < office supply.

Accumulating all the data : 
We get the following table :

Note a-b : represents the duration where a is the day when order is booked and b is the day when it is dispatched.
Now taking average processing time per order for the above mentioned categories we get:

So in decreasing order we get Phones , Art ,Binder , Paper.

Accumulating all the data : 
We get the following table :

Note a-b : represents the duration where a is the day when order is booked and b is the day when it is dispatched .
Now from the table we observe that the total number of orders are 35 and 7 orders have a processing time of 1 unit 
The 7 orders are : Arts Standard class,Binders First class and standard class, Phones First class, Bookcases second class ( 2 orders)  and Chairs standard class.
So the percentage

The annual  completion index for different people is :
The weightage average of the completion percentage assigned from the different projects, with the weights being the corresponding number of months (s)he worked in these projects.
For Abani :

The descending order for the four people is :
Danni, Tinni, Abani, Bahni.

Abani, Banni, and Danni did not work on multiple projects simultaneously in a month
Tinni was the only person who worked on multiple projects which are project 4 and project 5 in the month of september.

The total project month is the number of months Abani, Bahni, Danni, and Tinni individually worked for all the projects combined :
Abani - 2+2+5 = 9 months
Bahni - 2+4+3 = 9 months
Danni - 3+3+2+1 = 9 months
Tinni - 2+2+3+2 = 9 months.
The total employee month for all the five projects is the sum of the total employee-month is the sum of the number of months four employees worked in this project.
Project -1 = 2+2+2 = 6 months
Project -2 = 3+2 = 5 months
Project - 3 = 2+4+3 = 9 months.
Project - 4 = 5+2+3 = 10 months.
Project - 5 = 3+1+2 = 6 months.
Only statement 1 is true.

Considering the information provided :
For project 1 : 3 months.
Project - 2: 3 months.
Project - 3: 5 months.
Project - 4: 5 months.
Project - 5: 4 months.
Among the given options option D is true which is project 3, project 4.