LO 9.3Use the following information to answer the questions that follow.
- Calculate the operating income percentage for each of the courses. Comment on how your analysis has changed for each course.
- Perform a vertical analysis for each course. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information?
- Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain.
- Using the revenue and contribution profit information, calculate the contribution profit (loss) percentage for each of the divisions. Comment on how your analysis has changed compared to your analysis of the dollar amounts for each division.
- Since companies typically do not publicly provide more than macro levels of asset values, let’s assume the following level of assets (investment):
Calculate the return on investment (ROI) for each division. Comment on the results.
- Assume that Netflix uses a cost of capital of 7%. Calculate the residual income (RI) for each of the divisions. Comment on the results.
LO 9.3The income statement comparison for Forklift Material Handling shows the income statement for the current and prior year.
- Determine the operating income (loss) (dollars) for each year.
- Determine the operating income (percentage) for each year.
- 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 return on investment. Was the decision to invest additional assets in the company successful? Explain.
- Assuming an 8% cost of capital, calculate the residual income for each year. Explain how this compares to your findings in part C.
LO 9.3Assume you are the leather department manager at the Famous Football Factory. The leather department is a cost center and you are reviewing the scrap costs for the previous year, shown here:
- Using Microsoft Excel or another spreadsheet application, create a line chart with markers showing the leather scrap expense. Describe your observations.
- Knowing that leather is susceptible to indoor temperature, you decide to talk with the maintenance manager and obtain the following information:
Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the indoor temperature, spare parts inventory, and breakdowns. Describe your observations and actions you might consider.
LO 9.4Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an accounting intern, who has asked for your guidance on how to prepare an income statement format that will be distributed to management. Subtotals and totals are included in the information, but you will need to calculate the values.
- In the correct format, prepare the income statement using the following information:
- Calculate the profit margin, return on investment, and residual income. Assume an investment base of $100,000 and 6% cost of capital.
- Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.
LO 9.4Using the information from BDS Enterprises, 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 question 1). 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.
LO 9.4Management of Great Springs Bottled Water Company has asked you, the controller, to develop a transfer pricing system for the company. The Transportation Department of the company sells all of its product to the Bottling Department of the company. Thus the Transportation 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 three different income statements) and calculate the operating income/loss percentage. Prepare a brief summary of the results.
LO 9.4The 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?