Question 1: Which combination of Entities had the highest Revenue from sales of Muesli?
Question 2: What was the highest sale? (Hint: look for max.)
Question 3: What are the Key Influencers of Revenue?
Question 4: Is this what you would expect? Why or why not?
Question 5: Notice the Key Influencers are separated into assigned bins. Bins are ranges of values and the frequency of occurrences within those ranges is recorded as a Histogram.
Identify the most commonly occurring Revenue and Price bin. What are the values in the bin? What is this telling you?
Question 6: Which Price bin impacts average Revenue the most? Why does this make sense?
Question 7: Which Distribution Channel has the highest Average Revenue? Why use Average Revenue instead of Total Revenue?
Question 8: Examine the Simulation page. Take a screenshot of the initial values for the simulation.
- How does changing the Team affect the Expected Revenue?
- What are the effects of changing Price? Area? Distribution Channel?
- Take another screenshot to show some of the changes you made to the simulation.
Question 9: Which Team had the highest Total Revenue?
- What was the Revenue?
- Support your answer with a screenshot.
- (You will not be reminded again.)
Question 10: What Product had the highest Total Revenue? What was the revenue?
Question 11: Display the trend of Revenue over Rounds for each Team.
Question 12: What is the market share of each Team by Product?
Question 13: Are there any Products that do not sell in specific Distribution Channels? Explain.
Question 14: What was the highest priced Muesli on Day 18 of Round 1? What Team sold it? What was the Price?
Question 15: Which Team sold the highest Quantity of Muesli? For that Team, what was the most sold Product?
Question 16: Show the days on which individual Teams did not have any Revenue.
Question 17: What Product on what Day and Round brought the highest Revenue (for which Team)?