Please be reminded that this is an individual quiz. You should not give or receive any unauthorized aid or share your exam questions and answers with anyone.
- Name Page 1 as “Product cost per unit” and perform the following operations.
- Create a column chart to identify your best-seller (measured by sales revenue) in the South area. Sort your sales from the lowest to the highest by materials and by areas. (5 points)
- Create a measure of conversion cost per unit (Con$/u). (5 points)
- Create a measure of material cost per unit (DM$/u). (5 points)
- Create a column chart to show your team’s unit product cost (under US GAAP) of your best-seller in the South area. (5 points)
- Create a new page and name it “Market Share”.
- Create a chart to show your highest yield (production) product in the game. (5 points)
- Create a chart to show the market share (measured by sales revenue) of that highest-yield product. Format your market share to a percentage. (5 points)
- Create a chart to show the WACM% of that highest-yield product by rounds (R1 to R6). (5 points)
- Use the WACM% chart to explain whether your team made the right decision focusing on that product. (5 points for the write-up in the textbox)