Understand how predetermined overhead may affect job cost. There are five ongoing jobs for your team. Given the uniqueness of these jobs, your team uses job costing when maintaining records. This visualization lists total materials to total costs percentage, total labor to total costs percentage, and predetermined overhead to total costs percentage. 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 program 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. Which job has the highest proportion of direct materials percentage to total costs? O J102 O J103 O J104 O J105 By hovering over the figure, what is the base when calculating the predetermined overhead rate and what is the rate? O Direct materials, 80% Direct labor, 80% O Direct labor, 60% O Direct materials, 60% What is the total amount of the actual overhead costs for all five jobs? $38,000 O $13,000 $12,000 O $144,000 Understand how predetermined overhead may affect job cost. There are five ongoing jobs for your team. Given the uniqueness of these jobs, your team uses job costing when maintaining records. This visualization lists total materials to total costs percentage, total labor to total costs percentage, and predetermined overhead to total costs percentage. 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 program 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. Which job has the highest proportion of direct materials percentage to total costs? O J102 O J103 O J104 O J105 By hovering over the figure, what is the base when calculating the predetermined overhead rate and what is the rate? O Direct materials, 80% Direct labor, 80% O Direct labor, 60% O Direct materials, 60% What is the total amount of the actual overhead costs for all five jobs? $38,000 O $13,000 $12,000 O $144,000
