Accounting - Explore and apply the basic multidimensional

Accounting Question

Explore and apply the basic multidimensional analysis by linking multiple cubes.

Requirements: Create visualizations to answer the following questions.

1) Compute your team's unit product cost by materials and by rounds (assuming the building is 100% for production).

2) Compute your team's market share (in % of sales revenue) of the top three sellers in the market (measured by sales revenue) by rounds.

3) Compute your team's productivity by rounds .

4) Compute your team's R2 inventory turnover.

5) Compute your team's gross margin (US GAAP) by rounds.

6) Create a visualization to understand the relationship between your inventory available for sale and your sales for each products.

Here's a walkthrough video recording for your reference.

https://SDSU.zoom.us/rec/share/Fwk4GXpFhx_7iZXXstP...