Accounting Question

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.

1. 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)