Ch. 14

Identify different product cost patterns and theirimplications.

In a visualization regarding the cost composition of your company's five products, you can see the percentage of direct materials, direct labor and overhead percentages to total costs per unit. Based on this information, please answer the following questions. Click here to access a Tableau file, and here to access a Power BI file. (The Tableau and Power BI files contain the same data; you can use either to answer the questions in this assignment. Your instructor may specify which progrom they prefer you to use!) How to Access Tableau: You can open the Tableau file in this problem statement with Tableau Desktop software. If you don't have Tableau Desktop, you can download the most recent version of Tableau Reader, a free program that allows you to open Tableau visualizations. To get the most recent version, search for "Tableau Reader" in your internet browser, or click here. How to Access Power BI: You can open the Power BI file in this problem statement with Power BI Desktop. If you don't have it already, search for "Power BI download" in your internet browser, or click here for a free download. The workers' union is negotiating an increase in an hourly wage and an increase in health insurance coverage. If agreed by the management team, which product is more likely to be affected? Assume that your company always uses the following formula to determine the markup: "direct labor to total costs percentage * 50%. Does this make sense to you? What is the potential