Tableau Dashboard Activity 4-1: Multi-Step Income Statements The following Tableau Dashboards show the total of all...
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
a) Given = {a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t), and P={b, d, f, j, m, o} Q = {a, j, k, r, s, t} R = {c, l, m, n, o, t} S = {c, e, f, k, n, p, q}. Determine the following (all...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A- Farah Corporation has provided the following production and total cost data for two levels of monthly production volume. The company produces a single product which it sells at $132.7 per unit...
-
Explain how Toyota could use standard costing for control. Focus on the cost of producing car doors to illustrate standard costing for control. (Car doors are produced by cutting sheet metal to a...
-
In a slap shot, a hockey player accelerates the puck from a velocity of 8.00 m/s to 40.0 m/s in the same direction. If this shot takes 3.33 x 10 -2 s, calculate the distance over which the puck...
-
Assume the same information in Exercise 18-61, except that there is a \(\$ 12,000\) beginning balance in the valuation allowance. Required a. Record the income tax journal entries on December 31,...
-
Balance sheets for Prego Company and Sprague Company as of December 31, 2010, follow: The fair values of Sprague Companys assets and liabilities are equal to their book values. Required: Prepare a...
-
One subunit of Contest Sports Manufacturing Company had the following financial results last month: (Click the icon to view the financial results.) Requirements 1. Complete the performance evaluation...
-
Sketch a set of equidistant 113 planes in a cubic unit cell.
-
S cos(2x) 1-1+2sin (2x) xp-
-
Could you please answer these questions step by step using a formula if necessary, if you are using a financial calculator please let me know the inputs and how did you use the calculator 12) Flo...
-
At a market price of $1.25, a Quantity demanded is exists. Quantity supplied is the price until it reaches equilibrium. Sellers will tend to Price per Apple y $2.00 $1.75 $1.50 $1.25 $1.00 $0.75...
-
DATABASE ALTERNATIVES a) In your own words, what do you understand by the term NOSQL databases [2 marks] b) Briefly explain the four (4) types of NOSQL databases [4 marks] 7 A BI
-
Cumulative Wealth f 0.8 0.6 0.4 0.2 0 Lorenz Curve: United States 2020 Personal Income y = 5.078x5 - 9.479x4 +6.151x - 1.058x + 0.308x 0.2 0.4 0.6 0.8 Cumulative Percentage of the Population United...
-
Provide the journal entry for the following. Prepare the entries (online exam in canvas may include questions about journal entries on these transactions) The following events took place at the...
-
State the points which should be borne in aWhat is the significance of substituting the words ' true and correct ' by the words ' true and fair' how does this change influence the scope of auditor's...
-
What are bounds and what do companies do with them?
-
Tom has a successful business with $100,000 of income in 2012. He purchases one new asset in 2012, a new machine which is 7-year MACRS property and costs $25,000. If you are Tom's tax advisor, how...
-
Jerry made the following contributions during 2012: His synagogue (by check).....................................................$680 The Democratic Party (by check)...
-
Greg died on July 1, 2012, and left Lea, his wife, a $50,000 life insurance policy which she elects to receive at $5,000 per year plus interest for 10 years. In the current year, Lea receives $6,200....
-
Claudia Vargas is contemplating the purchase of a machine that would be used in her business. The following estimates are available: Required: Determine the payback period for the machine purchase....
-
Cesar Nieto is contemplating the purchase of a machine that would be used in his business. The following estimates are available: Required: Determine the payback period for the machine purchase....
-
Veronica Torres is considering opening a ceramic studio. She has determined that it would require an investment of $14,000 to open the store. She believes that the cash inflows would grow each year...
Study smarter with the SolutionInn App