Showing Page:
1/2
PRACTICAL ANALYTICS Chapter 5 | Exercise 2 | Edition 2
Nitin Kalé & Nancy Jones © 2019
Submission Document for ERPSim Data Manipulation Assignment
Please use a font color other than red to differentiate your answers from the questions. Black should
default.
Question Set A (no screen shot required.)
Q1A. Examine the Distribution Channel Properties panel (to the right of the screen). Which Distribution
Channel has the highest number of stores?
Q2A. Which combination of distribution channel and Area had the highest revenue from sales of muesli?
How much more than average were these sales? What caused (contributed to) the sales to be higher
than average?
Q3A. What was the highest sale? (Hint: look for max.)
Q4A. What are the key influencers of Revenue? Is this what you would expect? Why or why not?
Q5A. Notice that the key influencers are separated into 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?
Q6A. Which price bin impacts average Revenue the most? Why does this make sense?
Q7A. Which distribution channel has the highest Average Revenue? Why use average revenue instead of
total revenue?
Q8A. Examine the simulation page. How does changing the team affect the Expected Revenue? What
are the affects of increasing Price? Area? Distribution Channel?
Question Set B (include a screen shot of the visualization that led you to your answer.)
Q1B. Which team had the highest revenue in total? What was the revenue?
Showing Page:
2/2
PRACTICAL ANALYTICS Chapter 5 | Exercise 2 | Edition 2
Nitin Kalé & Nancy Jones © 2019
Q2B. What product had the highest revenue in total? What was the revenue?
Q3B: Display the trend of revenue over rounds for each team.
Q4B: What is the market share of each team by product?
Q5B: Are there any products that do not sell in specific distribution channels? Explain.
Q6B: What was the highest priced muesli on day 18 of round 1? What team sold it? What was the price?
Q7B: Which team sold the most quantity of muesli? For that team, what was the most sold product?
Q8B: Show the days on which individual teams did not have any revenue.
Q9B: What product on what day and round brought the highest revenue (for which team)?

### Unformatted Attachment Preview

PRACTICAL ANALYTICS Chapter 5 | Exercise 2 | Edition 2 Submission Document for ERPSim Data Manipulation Assignment Your Name: Please use a font color other than red to differentiate your answers from the questions. Black should default. Question Set A (no screen shot required.) Q1A. Examine the Distribution Channel Properties panel (to the right of the screen). Which Distribution Channel has the highest number of stores? Q2A. Which combination of distribution channel and Area had the highest revenue from sales of muesli? How much more than average were these sales? What caused (contributed to) the sales to be higher than average? Q3A. What was the highest sale? (Hint: look for max.) Q4A. What are the key influencers of Revenue? Is this what you would expect? Why or why not? Q5A. Notice that the key influencers are separated into 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? Q6A. Which price bin impacts average Revenue the most? Why does this make sense? Q7A. Which distribution channel has the highest Average Revenue? Why use average revenue instead of total revenue? Q8A. Examine the simulation page. How does changing the team affect the Expected Revenue? What are the affects of increasing Price? Area? Distribution Channel? Question Set B (include a screen shot of the visualization that led you to your answer.) Q1B. Which team had the highest revenue in total? What was the revenue? Nitin Kalé & Nancy Jones © 2019 PRACTICAL ANALYTICS Chapter 5 | Exercise 2 | Edition 2 Q2B. What product had the highest revenue in total? What was the revenue? Q3B: Display the trend of revenue over rounds for each team. Q4B: What is the market share of each team by product? Q5B: Are there any products that do not sell in specific distribution channels? Explain. Q6B: What was the highest priced muesli on day 18 of round 1? What team sold it? What was the price? Q7B: Which team sold the most quantity of muesli? For that team, what was the most sold product? Q8B: Show the days on which individual teams did not have any revenue. Q9B: What product on what day and round brought the highest revenue (for which team)? Nitin Kalé & Nancy Jones © 2019 Name: Description: ...
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4