Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

PB 1.

LO 9.3Use the following information to answer the questions that follow.

Dessert Dynasty, Income Statement, Month December 31, 2018 for Store X, Store Y, and Store Z, respectively: Retail revenue, $17,976, $?, $37,380; Events revenue, $11,760, $4,620, $2,520; Total revenue, $29,736 $30,870 $39,900; Expenses: Ingredients, $3,528, $3,276, $?; Wages, $15,792, $18,438, $23,646; Baking supplies, $1,848, $2,352, $1,092; Fuel, $832, $1,302, $1,260; Utilities, $693, $756, $1,260; Total expenses, $22,693, $26,124, $33,222; Operating income, $?, $4,746, $6,678; Operating income %, $?, $?, $?.
  1. Calculate the operating income percentage for each of the stores. Comment on how your analysis has changed for each store.
  2. Perform a vertical analysis for each store. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information?
  3. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain.
PB 2.

LO 9.3Use Kellogg’s 2017 annual report to answer the following questions.

  1. Using the information for Kellogg, calculate the operating profit percentage for each of the divisions. Comment on how your analysis has changed compared to your analysis of the dollar amounts for each division.
  2. Using total assets as the investment, calculate the ROI for each division. In the total assets information you compile, you should ignore corporate and elimination entries amounts and you will also need to combine the U.S. divisions into a North American total. Comment on the results.
  3. Assume that Kellogg uses a cost of capital of 10%. Calculate the RI for each of the divisions (you will need to condense the U.S. divisions into a North American total). Comment on the results.
PB 3.

LO 9.3The income statement comparison for Rush Delivery Company shows the income statement for the current and prior year.

Rush Delivery Company, Income Statement Comparison for the current year and prior year, respectively (amounts in thousands): Sales, $15,000, $11,000; Cost of goods sold, $9,750, $7,480; Gross profit, $5,250, $3,520; Expenses: Wages, $3,900, $3,080; Utilities, $300, $250; Repairs, $75, $325; Selling, $225, $200; Total expenses, $4,500, $3,855; Operating income/(loss), $?, $?; Operating income/(loss) %, ?, ?; Total assets (investment base) $4,500, $1,500; Return on investment, $?, $?; Residual income (8% cost of capital) $?, $?.
  1. Determine the operating income (loss) (dollars) for each year.
  2. Determine the operating income (percentage) for each year.
  3. The company made a strategic decision to invest in additional assets in the current year. These amounts are provided. Using the total assets amounts as the investment base, calculate the ROI. Was the decision to invest additional assets in the company successful? Explain.
  4. Assuming an 8% cost of capital, calculate the RI for each year. Explain how this compares to your findings in part C.
PB 4.

LO 9.3Assume you are the manager for the semi-trucks division at the Speedy Delivery Company. The semi-truck division is a cost center and you are reviewing the driver overtime costs for the previous year, shown here:

Cost Center Data – Semi-truck Division. Driver overtime by month: January $150,000, February $172,500, March $103,500, April $104,535, May $106,626, June $95,963, July $91,165, August $82,048, September $69,741, October $87,177, November $135,124, December $243,222.
  1. Microsoft Excel or another spreadsheet application, create a line chart with markers showing the driver overtime expense. Describe your observations.
  2. Knowing that safety is important in your industry and weather plays a significant role in the safety of drivers, you decide to talk with the safety manager and obtained the following information:
Average snowfall (inches) by month: January 15, February 12, March 2, April 0, May 0, June 0, July 0, August 0, September 0, October 2, November 35, December 62. Non-company highway accidents by month: January 128, February 70, March 42, April 38, May 35, June 56, July 78, August 83, September 53, October 35, November 208, December 423.

Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the average snowfall and non-company highway accidents. Describe your observations and actions you might consider.

PB 5.

LO 9.4Financial information for Lighthizer Trading Company for the fiscal year-ended September 30, 20xx, was collected. As part of a management training session, you have been asked to prepare an income statement format that will be used to distribute to management. Subtotals and totals are included in the information, but you will need to calculate the values.

  1. In the correct format, prepare the income statement using this information:
  2. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $42,000 and 8% cost of capital.
  3. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.
Pretax income $?, Gross profit $?, Allocated costs (uncontrollable) $855, Labor expense $17,464, Sales $79,380, Research and development (uncontrollable) $132, Depreciation expense $7,140, Net income/(loss) $?, Cost of goods sold $50,009, Selling expense $525, Total expenses $?, Marketing costs (uncontrollable) $332, Administrative expense $290, Income tax expense (21% of pretax income) $?, Other expenses $134.
PB 6.

LO 9.4Using the information for Lighthizer Trading Company, prepare the income statement to include all costs, but separate out uncontrollable costs. Insert subtotals where appropriate (include one for operating income) before the uncontrollable costs. Income tax expense should be based on all expenses (that is, it will be the same amount as in the previous exercise). Calculate net income, profit margin, ROI, and RI excluding uncontrollable expenses. Prepare a short response to accompany the income statement that explains why uncontrollable costs are separated in the income statement.

PB 7.

LO 9.4Management of Green Peak Tea Company has asked you, the controller, to develop a transfer pricing system for the company. The Brewing Department of the company sells all of its product to the Bottling Department of the company. Thus the Brewing Department’s sales become the Bottling Department’s cost of goods sold. In order to determine an optimal transfer pricing system, management would like you to demonstrate what an income statement would look like under a cost, market, and negotiated transfer pricing structure. These various transfer prices are listed as follows. Prepare an income statement for each of the transfer prices by filling in the missing numbers in the provided income statement based on each transfer price (thus four different income statements) and calculate the operating income/loss percentage. Prepare a brief summary of the results.

Cost-basted $1.32, Market-based $1.15, Negotiated $1.24, Gallons transferred 89,000. Green Peak Tea Company, Income Statement, Month Ended November 31, 2018 for Brewing and Bottling, respectively: Sales, ?, $207,000; Cost of good sold, $61,090, $?; Gross profit, $?, $?; Fuel/utilities expense, $6,000, $5,400; Wages expense, $22,180, $41,400; Costs allocated form corporate, $39,938, $28,000; Total expenses, $68,118, $74,800; Operating income/(loss) $, $?, $?; Operating income/(loss) %, ?, ?.
PB 8.

LO 9.4The following revenue data were taken from the December 31, 2017, General Electric annual report (10-K):

Chart for 2017 Power, Renewable Energy, Oil & Gas, Aviation, Health-care, Transportation, and Lighting, respectively: Outside sales, $34,598, $10,211, $16,584, $26,790, $19,098, $4,168, $1,956; Intersegment sales, $1,392, $69, $646, $585, $18, $10, $31; Total sales, $35,990, $10,280, $17,230, $27,375, $19,116, $4,178, $1,987. Chart for 2016 Power, Renewable Energy, Oil & Gas, Aviation, Health-care, Transportation, and Lighting, respectively: Outside sales, $35,465, $9,022, $12,515, $25,530, $18,276, $4,713, $4,795; Intersegment sales, $1,330, $11, $383, $730, $15, $1, $28; Total sales, $36,795, $9,033, $12,898, $26,260, $18,291, $4,714, $4,823.

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?

Order a print copy

As an Amazon Associate we earn from qualifying purchases.

Citation/Attribution

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution-NonCommercial-ShareAlike License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at https://openstax.org/books/principles-managerial-accounting/pages/1-why-it-matters
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at https://openstax.org/books/principles-managerial-accounting/pages/1-why-it-matters
Citation information

© Dec 13, 2023 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.