CAT 2025 Lesson : Line & X-Y - Case 7

Directions for questions 23 to 27:Answer the questions on the basis of the information given below.

Ellen Inc. is a Mumbai based company which sells five products branded as A, B, C, D and E in India. Anita looks after entire sales of North India working from regional office in Delhi. She was preparing for annual review meeting scheduled next day in Mumbai. She was attempting to analyse sales in North India for the seven year period from 2009 to 2015. She first calculated average sales in rupees of all the five brands and constructed a table exhibiting the difference between average sales of each pair of brands as shown in the following table:

Difference Between Average Sales of Products for the 7 year period 2009-15 in Rs Crores



After taking a print out of the above table, she attempted to look at the trend of sales and plotted a graph in MS Excel. Later she took a print out of the graph and left for a meeting. While on her way she figured out that due to some printer cartridge problem sales of Product A in 2013, Product C in 2010, and Product D in 2012 were not visible in the graph as reproduced below. Anita had to make some quick calculations to arrive at the information outlined in the following questions:

23) What are the sales of Product A in 2013, Product C in 2010 and Product D in 2012?

(1) Rs. 550 Crores, Rs. 800 Crores and Rs. 500 Crores
(2) Rs. 500 Crores, Rs. 700 Crores and Rs. 600 Crores
(3) 55
(4) 64

24) Annual sales average of all products is the least in which year?

(1) 2010
(2) 2011
(3) 2012
(4) 2013

25) Which product has the least average sales for the seven year period 2009-15?

(1) Product A
(2) Product B
(3) Product D
(4) Product E

26) The difference between average sales of products for the period 2009-15 is the least for which pair of products?

(1) Product A and Product B
(2) Product B and Product C
(3) Product C and Product D
(4) Product D and Product E

27) If Year on Year (YoY) Growth is $\dfrac{\mathrm{Current \ Year \ Sales – Previous \ Year \ Sales}}{\mathrm{ Previous \ Year \ Sales}}$ then the YoY growth of combined sales of all products has suffered maximum decline in which year?

(1) 2010
(2) 2011
(3) 2013
(4) 2015

Solution

Answer:
23) (3) Rs. 500 Crores, Rs. 800 Crores and Rs. 600 Crores
24) (1) 2010
25) (2) Product B
26) (4) Product D and Product E
27) (2) 2011