Overview
SAC 2.1
Using the “Contribution margin percentage” measure, demonstrate how dicing can inform decision-making in the ERPSim game (ie… dice the chart to show how the top 2 items compare in 2 regions). Once the chart is created, analyze the chart and provide management with a summary of the trends you are noticing and what is influencing those trends (ie.. top seller was produced more, has lower costs, etc…). Please include your discussion directly on the story in a text box.
SAC 2.2
Create the calculated measure "Weighted Average Selling Price" (WASP) of the products sold and demonstrate how nesting of dimensions or pivoting can inform decision-making. Once you have created the chart, analyze the chart and provide management with a summary of what is influencing the WASP for the top 2 sellers. You will also need to provide management with feedback on whether prices should be raised or lowered. (You may have to create a chart to analyze units sold.) Please include your discussion directly on the story in a text box.
SAC 2.3
Create a chart to calculate the "Weighted Average Contribution Margin" (WACM) of your team by rounds. Once your chart is created, analyze the chart and provide management with details on what is influencing the change for your team's WACM each round (additional charts may be required). If your team's WACM is low, you may want to make a suggestion to management on how it can be improved and or the steps your team is taking to improve it. Please include your discussion directly on the story in a text box.
Answer all parts separately