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...
-
A radioactive sample intended for irradiation of a hospital patient is prepared at a nearby laboratory. The sample has a half-life of 83.61 h. What should its initial activity be if its activity is...
-
Expand each of the following determinants across any row or down any column. (a) (b) (c) 212 023 164 002 726 443 2 213 103
-
This case is a continuation of the Burburr Resorts & Hotels Corporation serial case that began. The components of the Burburr serial case can be completed in any order. Burburr has several properties...
-
The following information was drawn from a countys general fund budgets and accounts for a particular year (in millions): For purposes of budgeting, the county recognizes encumbrances as the...
-
The video about sign language demonstrated: A . Most sign languages are very similar. B . All sign languages use the same gesture for the word "what". C . English - speaking countries use the same...
-
Consider the hypothetical eutectic phase diagram for metals A and B, which is similar to that for the lead-tin system, Figure 9.8. Assume that (1) and phases exist at the A and B extremities of the...
-
In February 2012, the Australian Accounting Standards Boards decided at its meeting to propose the withdrawal of AASB 1031 Materiality. There were several reasons for this proposal which includes:...
-
A key coordinative skill that experienced writers in Slattery's study developed was the ability to pre-stage their work environment for a productive session of work. What do you do before you write...
-
An independent distributor bought a new vending machine for \(\$ 2,000\). It had a probable scrap value of \(\$ 100\) at the end of its expected 10-year life. The value \(V\) at the end of \(n\)...
-
It is estimated that \(t\) years from now, the population of a certain suburban community will be \[P(t)=20-\frac{6}{t+1}\] thousand people. a. What will the population of the community be 9 years...
-
The velocity \(v\) (in feet per second) of the rock dropped into the well in the B.C. cartoon at the beginning of this section is also related to time \(t\) (in seconds) by the formula \[v=32 t\]...
-
Try creating a text cloud that captures the key threads of a chapter or an article that you are assigned to read for class. What kind of a visual picture emerges? What key terms seem to anchor the...
-
Match the root with its definition. gen/o necr/o xer/o 1. 2. 3. 4. 5. 6. 7. 8. 9. morph/o troph/o plas/o sten/o phag/o xen/o Translate the following roots. 10. Hydr/o 11. Orth/o 12. Necr/o 13. Myc/o...
-
When is the indirect pattern appropriate, and what are the benefits of using it?
-
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....
-
An investor is considering adding three new securities to her internationally focused, fixed-income portfolio. She considers the following non-callable securities: 1-year government bond 10-year...
-
An Australian investor currently holds an A$240 million equity portfolio. He is considering rebalancing the portfolio based on an assessment of the risk and return prospects facing the Australian...
-
An analyst is reviewing various asset alternatives and is presented with the following information relating to the broad equity market of Switzerland and various industries within the Swiss market...
Study smarter with the SolutionInn App