Principles of Accounting Volume 2
19th Edition
ISBN: 9781947172609
Author: OpenStax
Publisher: OpenStax College
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 9, Problem 8PB
The following revenue data were taken from the December 31, 2017, General Electric annual report
(10-K):
For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data.
How might a division sales manager use this data?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages.
Please see the attachment for details:
a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. Round to the nearest whole percentage.b. As far as the data permit, comment on significant relationships revealed by the comparisons.
Prepare a basic income statement forecast for the subsequent fiscal year, using a percentage of sales approach and using information included in the materials below to support assumptions that correspond for each revenue and expense. Each line item (e.g., marketing expenses) should have a note and an explanation on how it was calculated.
Summary operating data for Custom Wire & Tubing Company during the year ended April 30, 2018, are as follows: cost of goods sold, $510,700; administrative expenses, $63,600; interest expense, $38,000; rent revenue, $127,200; sales, $826,800; and selling expenses, $95,400.
Prepare a single-step income statement.
Custom Wire & Tubing Company
Income Statement
For the Year Ended April 30, 2018
Revenues:
$
Total revenues
$
Expenses:
$
Total expenses
$
Chapter 9 Solutions
Principles of Accounting Volume 2
Ch. 9 - Which of the following is nor a common goal of an...Ch. 9 - Which of the following does not describe a...Ch. 9 - In centralized organizations, primary decisions...Ch. 9 - A key advantage of a decentralized organization is...Ch. 9 - Strategic decisions occur ______. A. frequently...Ch. 9 - Segments are uniquely identifiable components of...Ch. 9 - Organizational charts _____. A. list the salaries...Ch. 9 - In a centralized organization, where are goals...Ch. 9 - Managers in decentralized organizations make...Ch. 9 - Which of the following is not a type of...
Ch. 9 - A system that establishes financial accountability...Ch. 9 - A responsibility center in which managers are held...Ch. 9 - A responsibility center structure that considers...Ch. 9 - An important goal of a responsibility accounting...Ch. 9 - Costs that a company or manager can influence are...Ch. 9 - An example of an uncontrollable cost would include...Ch. 9 - Internal costs that are charged to the segments of...Ch. 9 - A transfer pricing arrangement that uses the price...Ch. 9 - A transfer pricing structure that considers the...Ch. 9 - What is a management control system? What are its...Ch. 9 - Identify and describe the levels of management,...Ch. 9 - Discuss the difference between centralized and...Ch. 9 - Identity a company where you recently shopped....Ch. 9 - Discuss the difference between daily and strategic...Ch. 9 - Define segments and describe how identifying...Ch. 9 - Choose a company and describe how a specific...Ch. 9 - Choose a company and explain how a specific issue,...Ch. 9 - Assume you are the manager of a local Starbucks....Ch. 9 - Assume you are the manager of a local Starbucks....Ch. 9 - Lavell started out mowing lawns in the...Ch. 9 - Describe the concept of responsibility accounting.Ch. 9 - Describe the concept of a cost center and, using a...Ch. 9 - Describe the concept of a profit center and, using...Ch. 9 - Explain the benefits of a return on investment...Ch. 9 - Explain the benefits of a residual income...Ch. 9 - Discuss the concept of controllable and...Ch. 9 - Discuss the concept of transfer pricing.Ch. 9 - Discuss the advantages and disadvantages of a...Ch. 9 - Discuss the advantages and disadvantages of a...Ch. 9 - Discuss the advantages and disadvantages of a...Ch. 9 - Assume you have been hired by Hilton Hotels and...Ch. 9 - Consider the national nonprofit organization the...Ch. 9 - The following information is from Bluff Run Golf...Ch. 9 - The following information is from Daves Sporting...Ch. 9 - Assume you are the department B manager for...Ch. 9 - As manager of department B in MarIeys...Ch. 9 - Based on your research of the market in the...Ch. 9 - Using the information in the previous exercises...Ch. 9 - Assume you have been hired by Cabelas Sporting...Ch. 9 - Assume you are the regional manager for a hotel...Ch. 9 - The following information is from Dessert Dynasty....Ch. 9 - The following information is from Good Read Books....Ch. 9 - Assume you are the warehouse manager for Vinnies...Ch. 9 - As manager of the warehouse for Vinnies Vinyls,...Ch. 9 - Discuss how, as warehouse manager for Vinnies...Ch. 9 - Determine the operating income for Vinnies Vinyls...Ch. 9 - Use the following information to answer the...Ch. 9 - The income statement comparison for Forklift...Ch. 9 - Assume you are the leather department manager at...Ch. 9 - Financial information for BDS Enterprises for the...Ch. 9 - Using the information from BDS Enterprises,...Ch. 9 - Management of Great Springs Bottled Water Company...Ch. 9 - The following revenue data were taken from the...Ch. 9 - Use the following information to answer the...Ch. 9 - The income statement comparison for Rush Delivery...Ch. 9 - Assume you are the manager for the semi-trucks...Ch. 9 - Financial information for Lighthizer Trading...Ch. 9 - Using the information for Lighthizer Trading...Ch. 9 - Management of Green Peak Tea Company has asked...Ch. 9 - The following revenue data were taken from the...Ch. 9 - You have just been elected president of a...
Additional Business Textbook Solutions
Find more solutions based on key concepts
Horizontal analysis(Learning Objective 2)15-20 min. Below are net sales and net income data for a five-year per...
Financial Accounting, Student Value Edition (5th Edition)
Calculate profit margin on sales ratio. (LO 5). Suppose a firm had sales of $200,000 and net income of $7,000 f...
Financial Accounting
Surfing the Standards Case 2: Bonds with Detachable Warrants Companies sometimes issue bonds with detachable wa...
Intermediate Accounting
Use ABC to allocate manufacturing overhead (Learning Objective 2) Several years after reengineering its product...
Managerial Accounting (5th Edition)
Small Business Analysis Purpose: To help you understand the importance of cash flows in the operation of a smal...
Financial Accounting, Student Value Edition (4th Edition)
E4–16 Preparing the financial statements
The adjusted trial balance for Green Advertising Services is present...
Horngren's Accounting (12th Edition)
Knowledge Booster
Similar questions
- The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales, Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardFollowing are 2017 and 2018 revenue data for Honeywell International's four segments. Use these data to forecast its 2019 revenue. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Honeywell International Segment Sales and Business-Unit Sales by Segment $ millions 2018 2017 Aerospace sales Commercial aviation original equipment Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes Buildings Total Honeywell building technologies sales Performance materials and technologies sales UOP Russell LLP Process solutions Advanced materials Total performance materials and technologies sales $3,591 $2,475 5,373 5,861 5,423 4,053 2,622 3,906 $17,009 $16,295 $4,686 $4,482 5,370 6,053 $10,056 $10,535 $3,603 $2,753 4,981 5,553 3,606 2,791 $12,190 $11,097 Safety and productivity solutions sales Safety…arrow_forwardPerformance Aid, Inc. has two divisions: Test Preparation and Language Arts. Results (in millions) for the past three years are partially displayed here: Q.Use the DuPont method of profitability analysis to explain changes in the operating-income-to-totalassets ratios over the 2015–2017 period for each division and for Performance Aid as a whole. Comment on the results.arrow_forward
- Use the following selected data from Business Solutions's income statement for the three months ended March 31, 2022, and from its March 31, 2022, balance sheet to complete the requirements. Computer services revenue Net sales (of goods) Total sales and revenue Cost of goods sold Net income Quick assets Current assets Total assets Current liabilities Total liabilities Total equity Required: 1. Compute the gross margin ratio (both with and without services revenue) and net profit margin ratio. 2. Compute the current ratio and acid-test ratio. 3. Compute the debt ratio and equity ratio. 4. What percent of its assets are current? What percent are long term? Required 1 Required 2 Complete this question by entering your answers in the tabs below. $ 27,275 19,083 46,358 12,572 18,807 89,252 97,520 123,464 Gross margin ratio Net profit main ratio 885 885 122,579 Required 3 Required 4 Compute the gross margin ratio (both with and without services revenue) and net profit margin ratio. Note:…arrow_forwardHere is the operating data for Yalis Cleaning, Inc.: After analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenue as the base amount. Round percentages to two decimal places.arrow_forwardWith the information provided in the image: Prepare a multi-step income statement. Calculate the company's return on sales ratio.arrow_forward
- Use the following selected data from Business Solutions's income statement for the three months ended March 31, 2022, and from its March 31, 2022, balance sheet to complete the requirements. Computer services revenue Net sales (of goods) Total sales and revenue Cost of goods sold Net income Quick assets Current assets Total assets Current liabilities Total liabilities. Total equity Required 1 Required: 1. Compute the gross margin ratio (both with and without services revenue) and net profit margin ratio. 2. Compute the current ratio and acid-test ratio. 3. Compute the debt ratio and equity ratio. 4. What percent of its assets are current? What percent are long term? Required 2 Required 3 $ 27,912 19,428 47,340 13,820 Complete this question by entering your answers in the tabs below. 19,716 89,940 95,224 118,824 Gross margin ratio Net profit margin ratio 1,110 1,110 117,714 % % Compute the gross margin ratio (both with and without services revenue) and net profit margin ratio. Note:…arrow_forwardPlease see the picture below. I need help making a retained earnings statement, a balance statement, a comprehensive income statement and calculate the profit margin and the gross profit rate for the income statement I've included. Note that I have included the Income statement below. Note that I have included all the information that was made available to me. I need this asap. Big John's Merch Income statement For the month ending February 28, 2022 Sales - $50,000 Costs of goods sold- $12,500 Operating expenses Salaries- $2,500 Rent- $800 Advertising- $500 Depreciation- $300 Utilities- $75 Revenues and Expenses Internet revenues- $2,000 Internet expense- $150 Insurance expense- $400 Other revenues- $3,500arrow_forwardThe accounting information collected from the MCM company is detailed in the attached tables. Prepare the following:a-General Balance as of September 30, 2010b- Statement of the cost of goods sold for the month of September 2010c-Income statement for the month of September 2010d-Calculate the following financial ratios: Current ratio, acid test ratio, participation ratio, profit margin. Financial information was collected for the month of September 210 for the company MCM. Balance Bills to pay $35000 receivable accounts $29000 bonds payable $110000 buildings (net value) $605000 cash on hand $17000 dividends payable $8000 inventary $31000 terrain $450000 long-term mortgage payable $450000 retained earnings $154000 stock values $375000 transaction in september 2010 category Amount workforce $50000 bills insurance $20000 sales $62000 rent and maintenance $40000 salary $110000 others $62000 total $294000…arrow_forward
- A condensed income statement for Weber Associates and a partially completed vertical analysis follow. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). 2. Does Cost of Goods Sold, as a percentage of Net Revenues, represent better or worse performance in 2019 as compared to 2018? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete the vertical analysis by computing each missing line item as a percentage of net revenues. TIP: In the prior year, Cost of Goods Sold was 31 percent of Net Revenues, computed as ($1,397 ÷ $4,571). (Decreases should be indicated by a minus sign. Round your answers to the nearest whole percent.) Net Revenues Cost of Goods Sold Research and Development Expense Sales and Marketing Expense General and Administrative Expense Income from Operations Other…arrow_forwardUse the following information for Short Exercises S15-6 through S15-10. Accel’s Companies, a home improvement store chain, reported the following summarized figures: Requirements Compute the profit margin ratio for Accel’s Companies for 2018. Compute the rate of return on total assets for 2018.arrow_forwardThe following is select account information for August Sundries. Sales: $850,360; Sales Returns and Allowances: $148,550; COGS: $300,840; Operating Expenses: $45,770; Sales Discounts: $231,820. If August Sundries uses a multi-step income statement format, what is their gross margin?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning