the Vice President Of operations Divisional performance analysis and evaluation
ID: 2520298 • Letter: T
Question
the Vice President Of operations Divisional performance analysis and evaluation Obj. 4 PR 23-5B The vice president of operations of Free Ride Bike Company is evaluating the performance of two divisions organize as investment centers. Invested assets and conde sed income statement data for the past year for each division are as follows 2. Road Bike sion ROL 12.0% Road Bike DivisionMountain Bike Division $1,728,000 1,380,000 175,200 1,440,000 1,760,000 1,400,000 236,800 800,000 W EXCEL TEMPLATE Cost of goods sold Operating expenses Invested assets Instructions 1. Prepare condensed divisional income statements for the year ended December 31, 20v7, assuming that there were no service department charges. 2. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for each division. (Round percentages and the invest- 3. If management's minimum acceptable return on investment is 10%, determine the residual 4.Discuss the evaluation of the two divisions, using the performance measures de- ment turnover to one decimal place.) income for each division. termined in parts (1), (2), and (3).Explanation / Answer
Answer 1. FREE RIDE BIKE COMPANY Divisional Income Statement For the Year Ended Dec 31, 20Y7 Road Bike Division Mountain Bike Division Sale 1,728,000.00 1,760,000.00 Cost of Goods Sold 1,380,000.00 1,400,000.00 Gross Profit 348,000.00 360,000.00 Operating Expenses 175,200.00 236,800.00 Income From Operations 172,800.00 123,200.00 Answer 2. Profit Margin X Investment Turnover = ROI (Income From Operation / Sales) (Sales / Invested Assets) Road Bike Division 10.00% X 1.20 = 12.00% ($172,800 / $1,728,000) (1,728,000 / 1,440,000) Mountain Bike Division 7.00% X 2.20 = 15.40% (123,200 / 1,760,000) (1,760,000 / 800,000) Answer 3. Residual Income = Operating Income - (Operating Assets x Target Rate of Return) Road Bike Division Mountain Bike Division Operating Income 172,800.00 123,200.00 Required Rate of Return - Operating Assets X 10% 144,000.00 80,000.00 Residual Income 28,800.00 43,200.00 Answer 4. On the basis of Operating Income the Road Bike Division is the more profitable of the two division. On the basis of residual income & ROI the Mountain Bike Division is the more profitable of the two division.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.