To complete this exercise, you will need to download and install Tableau on your computer.

• Borne Company manufactures two models of industrial componentsa Basic model (20,000 units) and an Advanced Model (5,000 units). The company considers all of its manufacturing overhead costs ($1,618,900) to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all of it manufacturing overhead to four cost poolsAssemble and Pack (allocated based on direct labor-hours), Machining (allocated based on machine-hours), Order Processing (allocated based on the number of orders processed), and Setups (allocated based on setup hours). An ABC implementation team has completed the activity-based cost allocations and is seeking your help in creating some Tableau visualizations that contrast these cost allocations with the companys plantwide approach.

Required:

1a. For the Assemble and Pack activity:

What percentage of the cost is allocated to the Basic Model?

What percentage of the cost is allocated to the Advanced Model?

1b. For the Machining activity:

What percent of the cost is allocated to the Basic Model?

What percent of the cost is allocated to the Advanced Model?

1c. For the Order Processing activity:

What percent of the cost is allocated to the Basic Model?

What percent of the cost is allocated to the Advanced Model?

1d. For the Setups activity:

What percent of the cost is allocated to the Basic Model?

What percent of the cost is allocated to the Advanced Model?

Note: For all requirements, round your answers to 2 decimal places.

1e. Which of the following statements is true?

Note: You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.

\begin{tabular}{|l|l|l|} \hline 1-a. Percentage of cost for Basic model & & % \\ \hline 1-a. Percentage of cost for Advanced model & & % \\ \hline 1-b. Percentage of cost for Basic model & & % \\ \hline 1-b. Percentage of cost for Advanced model & % \\ \hline 1-c. Percentage of cost for Basic model & % \\ \hline 1-c. Percentage of cost for Advanced model & % \\ \hline 1-d. Percentage of cost for Basic model & % \\ \hline 1-d. Percentage of cost for Advanced model & % \\ \hline \end{tabular} The ABC system shows that the Advanced model consumes a higher percentage of the unit-level activity costs-Order Processing and Setups-than the Basic model. The ABC system shows that the Advanced model consumes a higher percentage of the batch-level activity costs-Order Processing and Setups-than the Basic model. The ABC system shows that the Advanced model consumes a lower percentage of the batch-level activity costs-Order Processing and Setups-than the Basic model. The ABC system shows that the Advanced model consumes a lower percentage of the unit-level activity costs-Order Processing and Setups-than the Basic model. \begin{tabular}{|l|l|l|} \hline 1-a. Percentage of cost for Basic model & & % \\ \hline 1-a. Percentage of cost for Advanced model & & % \\ \hline 1-b. Percentage of cost for Basic model & & % \\ \hline 1-b. Percentage of cost for Advanced model & % \\ \hline 1-c. Percentage of cost for Basic model & % \\ \hline 1-c. Percentage of cost for Advanced model & % \\ \hline 1-d. Percentage of cost for Basic model & % \\ \hline 1-d. Percentage of cost for Advanced model & % \\ \hline \end{tabular} The ABC system shows that the Advanced model consumes a higher percentage of the unit-level activity costs-Order Processing and Setups-than the Basic model. The ABC system shows that the Advanced model consumes a higher percentage of the batch-level activity costs-Order Processing and Setups-than the Basic model. The ABC system shows that the Advanced model consumes a lower percentage of the batch-level activity costs-Order Processing and Setups-than the Basic model. The ABC system shows that the Advanced model consumes a lower percentage of the unit-level activity costs-Order Processing and Setups-than the Basic model