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 Barksdale income Barksdale Expenses Account 2SOK 240,000 DO Wages Expense 70,000 300 Cost of Goods Sold 120.000 so Transportation-out 5.000 Income Tax Expense 10,000 Account Marketing Expense Valve 15.000 O 8.000 Net Sales Galon Sale of land Barksdale Expenses Wages Expense 70,000 Cost of Goods Sold 120,000 Transportation-out 5,000 Income Tax Expense 10,000 Account Interest Expense Value: 5,000 Common Size Metrics Company 06 Gross Margin 102 00 0 00 008 Return on Sales Percen 0.04 Company Barksdale Corporation Gross Margin Percentage Return on Sales Percentage: 0.09500 DO 000 Abbingtoning Barksdale Corporation Brooks Inc Lemmings te Stockton Co tableau Required: 1. Construct a mult step income statement using the data provided 2. If 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 or 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 incompleto 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? Reg1 Reg 2 Reg 3 Reg 4 Reqs Construct a multi-step income statement using the data provided. 240,000 (120,000) nce $ 120,000 Barksdale Corporation Income Statement Net Sales S Cost of Goods Sold (Gross Margin Less Operating Expenses Wages Expense $ Transportation out Marketing Expense Interest Expense Total Operating Expenses Operating Income Non operating Items Gain on Sale of Land S Income Tax Expense Total Non operating tems Income Before Income Taxes 70,000 5.000 15.000 5,000 $ 95.000 25,000 8,000 (10,000) $ (2.000) 23,000 net income Complete this question by entering your answers in the tabs below. Req1 Reg 2 Req3 Req4 Req5 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? Net income will increase by $300 ONet income will decrease by $300 Net income will increase by $500 Net income will decrease by $500 Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 Reg 4 Reg 5 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? Yes, income tax expense should be included No, income tax expense should not be included Reg 2 Req 4 > Complete this question by entering your answers in the tabs below. Req1 Reg 2 Reg 3 Reg 4 Reg 5 The gross margin percentage is incomplete for Barksdale Corporation in the provided Tableau Dashboard. What should the gross margin percentage be for Barksdale Corporation? O 50% 26% O7686 345% Complete this question by entering your answers in the tabs below. Reg 1 Req 2 Reg 3 Reg 4 Reqs Which company performed the best based on the return on sales ratio? Brooks Inc O Stockton Co Lemmings Inc None of these companies represent the top performer
