Required information

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 Tableaus 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:

Open the Tableau Desktop application.

On the lefthand side, under the Connect header and the To a file sub-header, click on Microsoft Excel.

Choose the Excel file and click Open.

Since the only worksheet in the Excel File is Cost Summary it will default as a selection with no further import steps needed

Create a pie chart in Tableau that shows the percentage of the companys total costs that are product costs and the percentage that are period costs:

Double click on Sheet 1 at the bottom of your workbook and rename it Product vs. Period Costs

On the lefthand side under Dimensions (sometimes labeled as Tables), click on Product / Period 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 () 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 period costs and the orange portion of the pie as product costs.

Your visualization should appear as follows:

Required: 1a. What percentage of the companys total costs are product costs? 1b. What percentage of the companys total costs are period costs? (For all requirements, round your answers to 2 decimal places.)

Production Summary	Machining Department	FIFO	Weighted-Average
Completed in Prior Month	Beginning WIP	210
Completed in Current Month	Beginning WIP	90	300
Completed in Current Month	Completed and Started	2500	2500
Completed in Current Month	Ending WIP	100	100
Incomplete at End of Current Month	Ending WIP	300	300