Tableau Dashboard Activity 4-1: Multi-Step Income Statements The following Tableau Dashboards show the total of all income and expense transactions for Barksdale Corporation. Use the visualizations to answer the following questions Value 250K 200x 150K 100K SOK Barksdale Income 240,000 Net Sales Account 8,000 Gain on Sale of Land Barksdale Expenses Wages Expense 70,000 Transportation-out 5,000 Income Tax Expense 10,000 Cost of Goods Sold 120,000 Account Marketing Expense Value 15,000 Barksdale Expenses Wages Expense 70,000 Transportation-out 5,000 Income Tax Expense 10,000 Cost of Goods Sold 120,000 Account Interest Expense Value: 5,000 06 Gross Margin Percentage Return on Sales Percen 202 00 0.06 0.06 0.04 002 0.00 Abbington Inc. +ableau. Common Size Metrics Company Company Gross Margin Percentage Return on Sales Percentage: 0.09500 Barksdale Corporation Barksdale Corporation Brooks Inc Lemmings tric Stockton Co PH Required: 1. Construct a multi-step income statement using the data provided. 2. If a customer returned merchandise inventory with a sales price of $500 and cost to the company of $200, which of the following appropriately describes the impact that this transaction would have on the income statement? 3, the managers of Barksdale Corporation are interested in examining controllable operating expenses, should income tax expense be included in the same ple chart as the other expenses provided? 4. The gross margin percentage is incomplete for Barksdale Corporation in the provided Tableau Dashboard. What should the gross margin percentage be for Barksdale Corporation? 5. Which company performed the best based on the return on sales ratio? bok nt ences Req 1 Req 2 Net Sales Cost of Goods Sold. Req 3 Construct a multi-step income statement using the data provided. Gross Margin Less Operating Expenses Wages Expense Transportation out Marketing Expense Interest Expense Net Income Barksdale Corporation Income Statement Total Operating Expenses Operating Income Non-operating Items Gain on Sale of Land Income Tax Expense Total Non-operating items Income Before Income Taxes $ $ Req 4 S 240,000 (120,000) 70,000 5,000 15,000 5,000 8,000 (10,000) Req 5 S 120,000 S $ 95,000 25,000 (2.000) 23,000 Complete this question by entering your answers in the tabs below. Req 1 Req 5 If a customer returned merchandise inventory with a sales price of $500 and cost to the company of $200, which of the following appropriately describes the impact that this transaction would have on the income statement? Req 2 Net income will increase by $300 ONet income will decrease by $300 ONet income will increase by $500 ONet income will decrease by $500 Req 3 Req 4 < Req 1 Req 3 > Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 Yes, income tax expense should be included No, income tax expense should not be included If the managers of Barksdale Corporation are interested in examining controllable operating expenses, should income tax expense be included in the same pie chart as the other expenses provided? Req 5 < Req 2 Req 4 > Complete this question by entering your answers in the tabs below. Req 11 50% 25% Req 2 75% O45%- Req 3 Req 4 The gross margin percentage is incomplete for Barksdale Corporation in the provided Tableau Dashboard. What should the gross margin percentage be for Barksdale Corporation? Req 5 < Req 3 Req 5 > Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Which company performed the best based on the return on sales ratio? Brooks Inc. Stockton Co Lemmings Inc. None of these companies represent the top performer < Req 4 Req 4 Req S Reg 5