IIFT 2015 Question Paper

Let's calculate the different WAC types during April 2014 - March 2015 and tabulate it as follows 

Average number of 11⁄2 ton Window ACs sold by Torrent Enterprises during April 2014 - March 2015=

=(727.7+1275.12+757.34+1296.24)/12

=338

Hence B is the correct answer.

Let's calculate the different WAC types during April 2014 - March 2015 and tabulate it as follows 

Let's solve the options one by one,

Option A :The absolute difference between average annual sales of  1 Ton and 1⁄2 Ton = 338.03-281.37 = 56.66

Option B: The absolute difference between average annual sales of 1 Ton and 2 Ton = 329.138-281.37 = 47.768

Option C: The absolute difference between average annual sales of 2 Ton and 1⁄2 Ton = 352.128-329.138 = 22.99

Option D:The absolute difference between average annual sales of 11⁄2 Ton and 1⁄2 Ton = 352.128-338.03 = 14.098

The absolute difference between average annual sales of  1 Ton and 1⁄2 Ton is the highest.

Hence A is the correct answer.

Let's calculate the different WAC types during April 2014 - March 2015 and tabulate it as follows 

Let's calculate Half yearly Sales for Various WAC types:

Let's calculate the different WAC types during April 2014 - March 2015 and tabulate it as follows 

Monthly Sales Performance in May 2014 =(1268-1266)/1266 = 0.00128

Monthly Sales Performance in June 2014=(1272-1268)/1268 = 0.0032

Monthly Sales Performance in October 2014 =(1298-1296)/1296  = 0.00154

Monthly Sales Performance in February 2015 =(1340-1330)/1330 = 0.0075

So the Monthly Sales Performance in February 2015 is the highest. 

Hence D is the correct answer.

Let's calculate the different WAC types during April 2014 - March 2015 and tabulate it as follows 

Sales Volatility can be calculated by the formula (Maximum Monthly Sales - Minimum Monthly sales )/ Average Monthly sales

1⁄2 Ton = 609-207/352.128 = 1.14

1 Ton =459-153/281.37 = 1.09

11⁄2 Ton = 439-241/338.03 = 0.59

2 Ton = 419-253/ 329.138 = 0.5

Among the different WAC types 2 Ton has the lowest Sales volatility.

Hence D is the correct answer.

Let's tabulate  the chart ,

Since difference in average sales is given , Difference in sales can be found  by multiplying it by 7

For example 

Let the sales of A be $$a_1,a_2,a_3,a_4,a_5,a_6,a_7$$ in 2009 - 2015 respectively.

Let the sales of B be $$b_1,b_2,b_3,b_4,b_5,b_6,b_7$$

Given that $$\frac{\left(a_1+a_2+a_3+a_4+a_5+a_6+a_7\right)}{7}-\frac{\left(b_1+b_2+b_3+b_4+b_5+b_6+b_7\right)}{7}=214.29$$

Hence A- B = 214.29 * 7 = 1500

Similarly, all the remaining differences in sales can be calculated

Let the sales of A in 2013 be 'a', C in 2010 be 'c', D in 2012 be 'd' .

Total sales of A  = (6800+a)

B = 5800

C = (7400+c)

D = (5700+d)

E = 7000

A - B = 6800+a - 5800 = 1500 =>  a = 500 crores

B - C = 5800 - 7400 - c = -2400  => c = 800 crores

D - E = 5700 + d - 7000 = -700 => d = 600 crores

Hence C is the correct answer.

On Tabulating the chart , we get 

from the previous question value of a=500,c=800,d=600

The product having the least sales value will obviously have the least avg sales value 

Sales in the year 2010=4700

Sales in the year 2011=4200

Sales in the year 2012=4500

Sales in the year 2013=4400

Hence in 2011 average of all the products sold is the least 

So B is the correct answer

On Tabulating the chart , we get 

Since difference in average sales is given 

Difference in sales can be found out by multiplying it by 7

Let the sales of A in 2013 be a , C in 2010 be c, d in 2012 be d 

Total sales of A  = (6800+a)

B = 5800

C = (7400+c)

D = (5700+d)

E = 7000

On evaluating we get value of a = 500,c=800,d= 600 crores 

Sales of product A = 7300 

Sales of product B = 5800

Sales of product D = 6300

Sales of product E = 7000

Product B has the least average sales.

Hence B is the correct answer.

On Tabulating the chart , we get

Since difference in average sales is given 

Difference in sales can be found out by multiplying it by 7

Let the sales of A in 2013 be a , C in 2010 be c, d in 2012 be d 

Total sales of A = (6800+a)

B = 5800

C = (7400+c)

D = (5700+d)

E = 7000

On evaluating we get value of a = 500,c=800,d= 600 crores 

On substituting all the values in the tables ,

Option A: The difference between the average sales of products A and B = 7300-5800 = 1500

Option B: The difference between the average sales of products B and C = 8200 - 5800 =2400

Option C: The difference between the average sales of products C and D= 8200 - 6300 = 1900

Option D: The difference between the average sales of products D and E= 7000 - 6300 = 700

The difference between the average sales of products D and E is the least.

Hence option D is the correct answer.

Let's tabulate  the chart ,

Since difference in average sales is given , Difference in sales can be found  by multiplying it by 7

Let the sales of A in 2013 be 'a', C in 2010 be 'c', D in 2012 be 'd' .

Total sales of A  = (6800+a*1000

B = 5800

C = (7400+c)

D = (5700+d)

E = 7000

On evaluating we get value of a = 500,c=800,d= 600 crores 

On finding the unknown values , we get the below table 

Let's evaluate the options one by one,

Option A: YoY growth of combined sales of all products in 2010 = 4700-4900/4900 = -0.0408

Option B: YoY growth of combined sales of all products in 2011 = 4200-4700/4700 = -0.1064

Option C: YoY growth of combined sales of all products in 2013 = 4400-4500/4500 = -0.0222

Option D: YoY growth of combined sales of all products in 2015 = 6000-5900/5900 = 0.0169

Among the above values, it is clear that the YoY growth of combined sales of all products in 2011 had a maximum decline.

Hence B is the correct answer.