Required information Applying Tableau Analytics 01-01 (Static) Cost Concepts [LO1-2, L01-3, LO1-4, LO1-6] To complete this exercise, you will need to download and install Tableau on your computer. Tableau provides free instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableau's short training videos can be found here. [The following information applies to the questions displayed below.] Karrion Company (KC) is a manufacturer that does not have any beginning or ending inventories. It had sales of $49 million during its first year of operations. You have been asked to help the company organize and visualize its costs from the prior year and to help prepare its traditional and contribution format income statements. Download the Excel file, which you will use to create the Tableau visualizations requested by the company. Upload the Excel file into Tableau by doing the following: 1. Open the Tableau Desktop application. 2. On the lefthand side, under the "Connect" header and the "To a file" sub-header, click on "Microsoft Excel." 3. Choose the Excel file and click "Open." 4. Since the only worksheet in the Excel File is "Cost Summary" it will default as a selection with no further import steps needed Applying Tableau Analytics 01-01 (Static) Part 3 Create a pie chart in Tableau that shows the percentage of the company's total costs that are fixed costs and the percentage that are rariable costs. - Click on the "New Worksheet" button at the bottom of your Workbook - Double-click on the newly created "Sheet 3 " at the bottom and rename it "Fixed vs. Variable Costs". - On the lefthand side under "Dimensions" (sometimes labeled as Tables), click on "Fixed / Variable" and drag it to the "Columns" area above the blank sheet. - Click on the "New Worksheet" button at the bottom of your Workbook. - Double-click on the newly created "Sheet 3 " at the bottom and rename it "Fixed vs. Variable Costs". - On the lefthand side under "Dimensions" (sometimes labeled as Tables), click on "Fixed / Variable" and drag it to the "Columns" area above the blank sheet. - On the lefthand side under "Measures", click on "Amount" and drag it to the "Rows" area. - The calculation will default to Sum; however, we want to modify this to show the percentage breakdown. To do this, click on the dropdown inside the green pill that currently says SUM(Amount) and select "Quick Table Calculation" then choose "Percent of Total" - This will create a vertical bar chart that we will change to a pie chart in the next step. - In the upper righthand corner of the screen, click on "Show Me," then select the "Pie Chart" option in the 2nd rows down in the far-right column - To improve viewing, locate the "Standard" dropdown option in the menu bar at the top of the screen. Click on that dropdown and choose "Entire View." - To insert numerical values in your pie chart, click the Text button (T ) in the menu bar at the top of the screen. - Notice that the color legend in the upper righthand corner of the screen defines the blue portion of the pie as fixed costs and the orange portion of the pie as variable costs. - Your visualization should appear as follows: Required: 3a. What percentage of the company's total costs are fixed costs? 3b. What percentage of the company's total costs are variable costs? (For all requirements, round your answers to 2 decimal places.)