Principles of Accounting Volume 2
19th Edition
ISBN: 9781947172609
Author: OpenStax
Publisher: OpenStax College
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 9, Problem 8PA
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?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students 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.
Following 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…
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:…
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
Quick ratio and current ratio (Learning Objective 7) 1520 min. Consider the following data: COMPANY A B C D Cas...
Financial Accounting, Student Value Edition (5th Edition)
Determine the monthly payment for a 30-year real estate loan with an APR of 8.5% and an initial principal of $2...
Construction Accounting And Financial Management (4th Edition)
Quick ratio and current ratio (Learning Objective 7) 1520 min. Consider the following data COMPANY A B C D Cash...
Financial Accounting, Student Value Edition (4th Edition)
Prepare income statements (Learning Objective 5) Part One: In 2015, Patsy Jackson opened Patsys Posies, a small...
Managerial Accounting (5th Edition)
4. JC Manufacturing purchase d inventory for $ 5,300 and al so paid a $260 freight bill. JC Manufacturing retur...
Horngren's Financial & Managerial Accounting, The Financial Chapters (6th Edition)
(Learning Objective 5: Evaluate profitability) Virginia Company included the following items in its financial s...
Financial Accounting (12th Edition) (What's New in Accounting)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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?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 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
- With the information provided in the image: Prepare a multi-step income statement. Calculate the company's return on sales ratio.arrow_forwardPrepare 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.arrow_forwardUse 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_forward
- The 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_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_forwardSummary 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 $arrow_forward
- Requirements 1. Prepare the company's January, multistep income statement. Calculate income using the LIFO, average-cost, and FIFO methods. Label the bottom line "Operating income." Round the average cost per unit to three decimal places and all other figures to whole-dollar amounts. Show your computations. 2. Suppose you are the financial vice president of Ohio Instruments. Which inventory method will you use if your motive is to a. minimize income taxes? b. report the highest operating income? c. report operating income between the extremes of FIFO and LIFO? d. report inventory on the balance sheet at the most current cost? e. attain the best measure of net income for the income statemehi? State the reason for each of your answers. please answer all please answer all or skip do not waste question or time by giving incomplete or incorrect answer please provide answer with explanation computation formula please answer with steps thanksarrow_forwardYour Task… Using your assigned financial statements calculate the required ratios below Indicate if the change from year to year is favorable or unfavorable. All values should be accurate to at least two decimal places. The expectation is to submit a professional report free of grammar and spelling errors and easy to read. Think of this as a menu you would be handing to a customer. All calculations are to be represented. Analysis of Profitability Gross Profit Ratio Operating Profit Ratio Net Profit Ratio Sales to Total Assets Ratio Return on Total Assets Return on Equity Earnings Per Sharearrow_forwardFor 2014, Kasay Company initiated a sales promotion campaign that included the expenditure of an additional $30,000 for advertising. At the end of the year, Scott Brown, the president, is presented with the following condensed comparative income statement: Instructions1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to net sales for each of the years. Round to one decimal place.2. To the extent the data permit, comment on the significant relationships revealed by the vertical analysis prepared in(1).arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
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 Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License