Help please!

Required Information Applying Tableau Analytics 01-01 (Statlc) Cost Concepts [LO1-2, LO1-3, LO1-4, LO1-6] To complete this exerclse, 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 utllizing and learning the software. Once you are up and running with Tableau, watch the three "Gettg Started" Tableau videos. All of Tableau's short tralning 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 Inventorles. 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 Flle is "Cost Summary" It will default as a selection with no further Import steps needed Applying Tableau Analytics 01-01 (Static) Part 2 reate a stacked bar chart In Tableau that Includes two bars. The first bar will show the selling cost and the administratlve cost that ollectlvely comprise the total perlod costs. The second bar will show the direct materlals cost, the direct labor cost, and the hanufacturing overhead cost that collectlvely comprise the total product costs. - Click on the "New Worksheet" button at the bottom of your Workbook - Double-click on the newly created "Sheet 2" at the bottom and rename It "Manufacturing vs. Nonmanufacturing Costs." - On the lefthand side under "Dimensions" (sometimes labeled as Tables) click on "Product / Perlod" 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. This will create a vertical bar chart. - The calculation will default to Sum, which is what we want in this Instance. - To Improve vlewing, locate the "Standard" dropdown option In the menu bar at the top of the screen. Click on that dropdown and choose "Entlre Vlew." - To create a stacked bar chart, choose "Manufacturing / Nonmanufacturing" under "DImenslons" and drag It Into the "Color" Marks card ( - Label each cost category with Its respectlve amount by clicking on "Amount" under "Measures" and dragging and dropping It onto the "Label" Marks card. - If the labels appear horizontal, then proceed to the next step. If they do not appear horizontal, then click on the "Label" Marks card () and under "Label Appearance", click on the drop down for "Allgnment" and choose under direction. - If all labels do not appear, then click on the "Label" Marks card ((n)) and check the box at the bottom under options which states "Allow Labels to overlap other marks" - Your visualization should appear as follows: Required: 2a. For the company's administratlve costs: How are they classified? What is their total amount? 2b. For the company's direct labor cost: How is It classified? What is the total amount? 2c. For the company's direct materlals cost: How is It classified? What is the total amount? 2d. For the company's manufacturing overhead costs: How are they classified? What is the total amount? 2e. For the company's selling costs: How are they classified? What is the total amount