Responsibility Accounting and Performance Evaluation Using Excel for key performance indicators (KPIs) The US Solar Company has data for the four divisions for the year, and wants the results for the three specified key performance indicators (KPIS). Division East North South West Net Sales 27,070,000.00 5,770,000.00 897,870.00 9,730,000.00 Variable Costs 15,441,300.00 3,162,600.00 410,016.60 4,616,300.00 Fixed Costs 10,294,200.00 2,108,400.00 273,344.40 2,944,200.00 Average Total Assets 12,270,250.00 4,230,000.00 1,251,290.00 13,620,000.00 Profit Margin Ratio Asset Turnover Ratio Return on Investment (ROI) Operating Income Average Total Assets 12,270,250.000 4,230,000.000 1,251,290.000 13,620,000.000 Net Sales 27,070,000.000 5,770,000.000 897,870.000 9,730,000.000 Profit Margin Ratio Asset Turnover Ratio Return on Investment (ROI)

Responsibility Accounting and Performance Evaluation Using Excel for key performance indicators (KPIs) The US Solar Company has data for the four divisions for the year, and wants the results for the three specified key performance indicators (KPIS). Division East North South West Net Sales 27,070,000.00 5,770,000.00 897,870.00 9,730,000.00 Variable Costs 15,441,300.00 3,162,600.00 410,016.60 4,616,300.00 Fixed Costs 10,294,200.00 2,108,400.00 273,344.40 2,944,200.00 Average Total Assets 12,270,250.00 4,230,000.00 1,251,290.00 13,620,000.00 Profit Margin Ratio Asset Turnover Ratio Return on Investment (ROI) Operating Income Average Total Assets 12,270,250.000 4,230,000.000 1,251,290.000 13,620,000.000 Net Sales 27,070,000.000 5,770,000.000 897,870.000 9,730,000.000 Profit Margin Ratio Asset Turnover Ratio Return on Investment (ROI)

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter14: Decentralized Operations

Section: Chapter Questions

Problem 14.5.2P

See similar textbooks

Similar questions

S Meiji Isetan Corporation of Japan has two regional divisions with headquarters in Osaka and Yokohama. Selected data on the two divisions follow Sales Net operating income Average operating assets Required 1 Required 2 Required: 1. For each division, compute the return on investment (ROI) in terms of margin and turnover. 2. Assume that the company evaluates performance using residual income and that the minimum required rate of return for any division is 17%. Compute the residual income for each division. 3. Is Yokohama's greater amount of residual income an indication that it is better managed? Osaka $ 9,900,000 $ 792,000 $ 2,475,000 Complete this question by entering your answers in the tabs below. ROI % Division Required 3 For each division, compute the return on investment (ROI) in terms of margin and turnover. Osaka Yokohama $ 29,000,000 $ 2,900,000 $ 14,500,000 Yokohama %
(Appendix 11A) Balanced Scorecard The following list gives a number of measures associated with the Balanced Scorecard: a. Number of new customers b. Percentage of customer complaints resolved with one contact c. Unit product cost d. Cost per distribution channel e. Suggestions per employee f. Warranty repair costs g. Consumer satisfaction (from surveys) h. Cycle time for solving a customer problem i. Strategic job coverage ratio j. On-time delivery percentage k. Percentage of revenues from new products Required: 1. Classify each performance measure as belonging to one of the following perspectives: financial, customer, internal business process, or learning and growth. 2. Suggest an additional measure for each of the four perspectives.
Quality Cost Report Loring Company had total sales of 2,400,000 for fiscal 20X1. The costs of quality-related activities are given below. Required: 1. Prepare a quality cost report, classifying costs by category and expressing each category as a percentage of sales. What message does the cost report provide? 2. Prepare a bar graph and pie chart that illustrate each categorys contribution to total quality costs. Comment on the significance of the distribution.
Cost of quality and value-added/non-value-added reports for a service company A. Using the information in Exercise 17, identify the cost of quality classification for each activity and whether the activity is value-added or non-value-added. B. Prepare a cost of quality report. Assume that sales are 3,000,000. (Round percentages to one decimal place.) C. Prepare a value-added/non-value-added analysis. D. Interpret the information in (B) and (C).
Contribution margin, break-even sales, cost-volume-profit chart, margin of safety, and operating leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows: It is expected that 12,000 units will be sold at a price of 240 a unit. Maximum sales within the relevant range are 18,000 units. Instructions 1. Prepare an estimated income statement for 20Y7. 2. What is the expected contribution margin ratio? 3. Determine the break-even sales in units and dollars. 4. Construct a cost-volume-profit chart indicating the break-even sales. 5. What is the expected margin of safety in dollars and as a percentage of sales? (Round to one decimal place.) 6. Determine the operating leverage.
Classify each of the following performance measures into the balanced scorecard perspective to which it relates: financial perspective, internal operations perspective, learning and growth perspective, or customer perspective. A. Employee satisfaction surveys B. Units of waste per production process, uniformity of products and inventory control C. Number of energy-efficient bulbs replaced D. Management training course certificates awarded E. Divisional profit F. Number of customer referrals
Contribution margin by segment The following information is for LaPlanche Industries Inc.: Determine the contribution margin for (A) Product YY and (B) West Region.
Communication The Norse Division of Gridiron Concepts Inc. experienced significant revenue and profit growth from 20Y4 to 20Y6 as shown in the following divisional income statements: There are no support department allocations, and the division operates as an investment center that must maintain a 15% return on invested assets. Determine the profit margin, investment turnover, and return on investment for the Norse Division for 20Y420Y6. Based on your computations, write a brief memo to the president of Gridiron Concepts Inc., Knute Holz, evaluating the divisions performance.
Quality Cost Report Whitley Company had total sales of 1,000,000 for the year ending 20X1. The costs of quality are given below. Required: 1. Prepare a quality cost report, classifying costs by category and expressing each category as a percentage of sales. What message does the cost report provide? 2. Prepare a bar graph and pie chart that illustrate each categorys contribution to total quality costs. Comment on the significance of the distribution.
Product costing and decision analysis for a service company Blue Star Airline provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month: Blue Star management wishes to assign these costs to individual flights in order to gauge the profitability of its service offerings. The following activity bases were identified with the budgeted costs: The size of the companys ground operation in each city is determined by the size of the workforce. The following monthly data are available from corporate records for each terminal operation: Three recent representative flights have been selected for the profitability study. Their characteristics are as follows: Instructions Determine the fuel, crew, and depreciation cost per mile flown. Determine the cost per arrival or departure by terminal city. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs.
Profit center responsibility reporting for a service company Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance, using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: The company operates three support departments: Shareholder Relations, Customer Support, and Legal. The Shareholder Relations Department conducts a variety of services for shareholders of the company. The Customer Support Department is the companys point of contact for new service, complaints, and requests for repair. The department believes that the number of customer contacts is a cost driver for this work. The Legal Department provides legal services for division management. The department believes that the number of hours billed is a cost driver for this work. The following additional information has been gathered: Instructions 1. Prepare quarterly income statements showing operating income for the three divisions. Use three column headings: East, West, and Central. 2. Identify the most successful division according to the profit margin. Round to the nearest whole percent. 3. Provide a recommendation to the CEO for a better method for evaluating the performance of the divisions. In your recommendation, identify the major weakness of the present method.
Investment Center Sales. Net income Average invested assets Profit margin Investment turnover Return on investment Profit Margin: Investment Center A B Investment Turnover: Investment Center A B Choose Numerator: Investment Center Use the information in the table above to compute each department's contribution to overhead (both in dollars and as a percent). (Round your final answers to 2 decimal places.) Return on investment: A B Choose Numerator: Choose Numerator: 1 A 1 $ $ 584,600 $1,580,000 ? 1 10% ? ?% B $12,200,000 $ $ 1 Choose Denominator: Choose Denominator: 1 Choose Denominator: ? ? ?% 1.3 13% = Profit Margin Profit margin 10.00 % % = Investment Turnover = Investment turnover 1.30 Return on investment = Return on investment % 13.00 %