Rocky Mountain Adhesives produces adhesives for use in construction and home repair, often known as “liquid nails.” It also produces specially labeled ceramic and wood adhesives. Because the processes for making the various types of adhesives begin with the same base product, management at Rocky Mountain Adhesives has asked you to produce a report comparing two methods of joint cost allocation: the physical units method and the weighted average method. You have been provided with a dataset that includes two years of product data, as well as a data dictionary.
Using the provided dataset, follow the instructions to complete the following:
1. Produce a visualization in Tableau showing joint cost allocation by product using the physical units method.
2. Produce a visualization in Tableau showing joint cost allocation by product using the weighted average method.
3. Describe the insights these visualizations can provide to management.
4. Explain the cautions that should be provided to management in using this analysis.