Data Interpretation – A large store has only three departments
Slot – 2 – DI
A large store has only three departments – Video Solution
A large store has only three departments, Clothing, Produce, and Electronics. The
following figure shows the percentages of revenue and cost from the three departments for
the years 2016, 2017 and 2018. The dotted lines depict percentage levels. So for example,
in 2016, 50% of store’s revenue came from its Electronics department while 40% of its
costs were incurred in the Produce department.
In this setup, Profit is computed as (Revenue – Cost) and Percentage Profit as Profit/Cost
× 100%.
It is known that
The percentage profit for the store in 2016 was 100%.
The store’s revenue doubled from 2016 to 2017, and its cost doubled from 2016 to
2018.
There was no profit from the Electronics department in 2017.
In 2018, the revenue from the Clothing department was the same as the cost incurred in
the Produce department.
Q.1 What was the percentage profit of the store in 2018?
Answer: 25
Q.2 What was the ratio of revenue generated from the Produce department in 2017 to that
in 2018?
4 : 3
16 : 9
9 : 16
8 : 5
Answer: 4
Q.3 What percentage of the total profits for the store in 2016 was from the Electronics
department?
Answer: 70
Q.4 What was the approximate difference in profit percentages of the store in 2017 and
2018?
25.0
33.3
15.5
8.3
Answer: 4
Solution:
Let the total revenue in 2016, 2017 and 2018 be 100x, 100y and 100z . The total cost in 2016, 2017 and 2018 be 100a, 100b and 100c.
The information given can be tabulated as below REVENUE
2016
2017
2018
Clothing
20x
30y
40z
Produce
30x
40y
40z
Electronics
50x
30y
20z
COST
2016
2017
2018
CLOTHING
30a
30b
20c
PRODUCE
40a
30b
30c
ELECTRONICS
30a
40b
30c
As revenue doubled in 2017 so 100y = 2(100x)
Or y = 2x
Also cost doubled in 2018 so 100c = 2(100a)
Or c = 2a
It is given that Profit in electronics in 2017 = 0
Which mean 30y = 40b
Percentage profit in 2016 = `100 -> x = 2a
In2018… -> 40z = 50c
Thus z =2.5a, x = 2a, y = 4a, b = 3a, c = 2a
profit in 2018 = (250a – 200a)/200a x 100 = 25
Rev produce in 2017/rev produce in 2018 = 40y/40z = 8/5
profit in 2016 = 100a. Profit from produce = 70a -> 70%
profit in 2017 = 400a – 300a / 300a = 33.33%
Profit in 2018 = 25%
Difference = 8.3