1. Revenue by Team Question: What is the highest revenue? (Include the team name in your answer)
a. Answer: Team RR had the highest revenue. The revenue was $32,297,798 Euro
2. Revenue by Product Question: What product had the highest revenue?
a. Answer: 500g Nut Muesli had the highest revenue. The revenue was $24,445,957
3. Revenue by Team and Round Question: Display the trend of revenue over rounds for each team.
Which team has the largest difference (highest point – lowest point) in revenue across multiple rounds.
a. Answer: Team NN (from round 1 to round 4, the difference is: $ 4,508,939.85 Euro)
4. Revenue by Team and Product Question: Observe the market share of each team by product (show
only the graph). Name the teams that don’t have any revenue in five or more product categories?
a. Answer: Teams that have no revenue in five or more product categories are: LL, OO, and TT
5. Revenue by Distribution Channel and Product Question: Are there any products that don’t sell in
specific distribution channels? If so, then list the products along with their respective distribution
channel. Answer:
a. Distribution Channel 10: 500g Blueberry Muesli, 500g Mixed Fruit Muesli, 500g Nut
Muesli, 500g Original Muesli, 500g Raisin Muesli, and 500g Strawberry Muesli
b. Distribution Channel 12: All products sold
c. Distribution Channel 14: 1kg Blueberry Muesli, 1kg Mixed Fruit Muesli, 1kg Nut Muesli,
1kg Original Muesli, 1kg Raisin Muesli, and 1kg Strawberry Muesli
6. Price by Product and Team Question: What were the highest prices paid for a Muesli product for each
team? Which team paid the most towards all the Muesli product bought? Answers:
a. NN: 500g Raisin, paid $1514
b. OO: 500g mixed fruit, paid $993
c. KK: 500g Nut, paid $947
d. SS: 500g Raisin, paid $701
e. RR: 1kg Blueberry, paid $920
f. TT: 500g Nut, paid $741
g. QQ: 500g Nut, paid $680
h. PP: 500g Blueberry, paid $488
i. LL: 500g Raisin, paid $515
j. MM: 500g Strawberry, paid $239
k. Team NN paid the most for all the Muesli products bought by a team - $4,229.
8. Revenue and Price by Product Question: What product has highest price and highest revenue?
a. Answer: 500g Nut Muesli, Price: $4979, Revenue: $24,445,957
9. Highest Revenue on a day Question: Overall, What team made the highest revenue in a single round?
a. Answer: Team NN has the highest revenue ($496,640) on Day 18 Round 4.
