Read the following information, graph and table and answer the questions that follow.
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:
Average Sales of Product A minus Average Sales of Product B
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 question.
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
Create a FREE account and get: