The Empire Hotel is a full-service hotel in a large city. Empire is organized into three departments that are treated as investment centers. Budget information for the coming year for these three departments is shown as follows. The managers of each of the departments are evaluated and bonuses are awarded each year based on ROI.
Empire Hotel | |||||||||||
Hotel Rooms | Restaurants | Health Spa | |||||||||
Average investment | $ | 8,247,000 | $ | 4,802,000 | $ | 848,000 | |||||
Sales revenue | $ | 10,000,000 | $ | 2,000,000 | $ | 600,000 | |||||
Operating expenses | 8,682,000 | 1,390,000 | 486,000 | ||||||||
Operating earnings | $ | 1,318,000 | $ |
610,000 |
$ | 114,000 | |||||
Required:
a. Compute the ROI for each department. Use the DuPont method to analyze the return on sales and capital turnover.
Assume the Health Spa is considering installing new exercise equipment. Upon investigating, the manager of the division finds that the equipment would cost $40,000 and that operating earnings would increase by $8,000 per year as a result of the new equipment.
b-1. What would be the ROI of investment in the new exercise equipment and Health Spa?
b-2. Would the manager of the Health Spa be motivated to undertake such an investment?
c-1. Compute the residual income for each department if the minimum required return for the Empire Hotel is 17 percent.
c-2. What would be the impact of the investment on the Health Spa's residual income?
Part a
Departments |
ROI |
Return on sales |
Capital turnover |
Hotel Rooms |
15.98% |
13.18% |
1.21 |
Restaurants |
12.70% |
30.50% |
0.42 |
Health Club |
13.44% |
19.00% |
0.71 |
Empire Hotel |
14.69% |
16.21% |
0.91 |
ROI = operating earnings / average investment
Hotel Rooms = 1318000/8247000 = 15.98%
Restaurants = 610000/4802000 = 12.70%
Health Club = 114000/848000 = 13.44%
Empire Hotel = 2042000/13897000 = 14.69%
Return on sales = operating earnings / sales revenue
Hotel Rooms = 1318000/10000000 = 13.18%
Restaurants = 610000/2000000 = 30.50%
Health Club = 114000/600000 = 19.00%
Empire Hotel = 2042000/13897000 = 16.21%
Capital turnover = sales revenue / average investment
Hotel Rooms = 10000000/8247000 = 1.21
Restaurants = 2000000/4802000 = 0.42
Health Club = 600000/848000 = 0.71
Empire Hotel = 2042000/13897000 = 0.91
Part b-1
ROI of investment in the new exercise equipment and Health Spa = (114000+8000)/(848000+40000) = 13.74%
Part b-2
Yes, the manager of the Health Spa would be motivated to undertake such an investment as there is increase in ROI
Part c-1
Departments |
Residual income |
Hotel Rooms |
-83990 |
Restaurants |
-206340 |
Health Club |
-30160 |
Residual income = operating earnings – return on investment
Hotel Rooms = 1318000-(8247000*0.17) = -83990
Restaurants = 610000-(4802000*0.17) = -206340
Health Club = 114000-(848000*0.17) = -30160
Part C-2
There will be positive impact of the investment on the Health Spa's residual income and the residual income would increase by $1200 (8000-(40000*17%))
The Empire Hotel is a full-service hotel in a large city. Empire is organized into three...
The Empire Hotel is a full-service hotel in a large city. Empire is organized into three departments that are treated as investment centers. Budget information for the coming year for these three departments is shown as follows. The managers of each of the departments are evaluated and bonuses are awarded each year based on ROI. Empire Hotel Hotel Rooms Restaurants Health Spa Average investment $ 8,231,000 $ 4,655,000 $ 1,021,000 Sales revenue $ 10,000,000 $ 2,000,000 $ 600,000 Operating expenses...
The Empire Hotel is a full-service hotel in a large city. Empire is organized into three departments that are treated as investment centers. Budget information for the coming year for these three departments is shown as follows. The managers of each of the departments are evaluated and bonuses are awarded each year based on ROI. Average investment Sales revenue Operating expenses Operating earnings Empire Hotel Hotel Rooms $ 7,915,000 $10,000,000 8,434,000 $ 1,566,000 Restaurants $5,291,000 $2,000,000 1,410,000 $ 590,000 Health...
The Empire Hotel is a full-service hotel in a large city. Empire is organized into three departments that are treated as investment centers. Budget information for the coming year for these three departments is shown as follows. The managers of each of the departments are evaluated and bonuses are awarded each year based on ROI. Average investment Sales revenue Operating expenses Operating earnings Empire Hotel Hotel Rooms $ 7,869,000 $ 10,000,000 8,779,000 $ 1,221,000 Restaurants $5,410,000 $2,000,000 1,046,000 $ 954,000...
Saxwell Corporation has many divisions and evaluates them using ROI. The corporation's expected ROI for each division is 14 percent or above. Earnings Investment base Division 1 $ 720,000 6,000,000 Division 2 $ 2,400,000 15,000,000 Assume that the manager of division 2 has the opportunity to purchase a new piece of equipment for $3,000,000 that would increase earnings by $300,000 per year. a. Show the impact of this purchase on division 2's ROI. b. Would the manager of division 2...
I hope this have the answers that you are requesting.
EXERCISE 1 Responsibility Report: Peak Outdoors produces and sells hiking gear. The production department reported the following information regarding its unique line of backpacks. Included are the static budget and actual results for the most recent year. Static Budget Actual Results Units Pruduced 24,000 units 27,000 units $144,000 $174,500 Direct Materials Direct Labor 216,000 236,250 Manufacturing OH- Variable 36,000 34,000 $396,000 $444,750 Total Variable Costs Manufacturing OH- Fixed 90,000 98,000...
Orange Corp. has two divisions: Fruit and Flower. The following information for the past year is available for each division Sales revenue Cost of goods sold and operating expenses Net operating income Average invested assets Fruit Division Flower Division $ 1.620,NNO $ 2,430,689 1.134.000 1.822.589 $ 486,000 $ 687,569 $ 4,050,000 $ 2,430,000 Orange has established a hurdle rate of 10 percent Required: 1-a. Compute each division's return on investment (ROI) and residual income for last year. 1-b. Determine which...
Exercise 10-8 Computing and Interpreting Return on Investment (RoI) [LO10-1] Selected operating data for two divisions of Outback Brewing, Ltd., of Australia are given below: Division New South Queensland $ 1,456,000 560,000 Wales $ 2,745,000 610,000 Sales Average operating assets Net operating income Property, plant, and equipment (net) $ 116,480 256,000 137,250 206,000 Required: 1. Compute the rate of return for each division using the return on investment (ROI) formula stated in terms of margin and turnover 2. Which divisional...
(Just need Req 2 for both questions)
Comparative data on three companies in the same service industry are given below: Required: 2. Fill in the missing information. (Round the "Margin" answers to 1 decimal place and "Turnover" answers to 2 decimal places.) Company В C $ $ Sales 600,000 500,000 84,000 70,000 Net operating income $ $ 300,000 1,000,000 Average operating assets 3.5% Margin % % Turnover 2.00 % 7 % Return on investment (ROI) % Exercise 10-12 Evaluating New...
Its all one question with multiple steps. Please help. No
handwriting please.
Responsibility Report: Peak Outdoors produces and sells hiking gear. The production department reported the following information regarding its unique line of backpacks. Included are the static budget and actual results for the most recent year Static Budget Actual Results Units Pruduced 24,000 units 27,000 units $144,000 $174,500 Direct Materials Direct Labor 216,000 236,250 Manufacturing OH- Variable 36,000 34,000 $396,000 $444,750 Total Variable Costs Manufacturing OH- Fixed 90,000 98,000...
Vernon Corporation operates three investment centers. The following financial statements apply to the investment center named Bowman Division: BOWMAN DIVISION Income Statement For the Year Ended December 31, 2018 Sales revenue $ 105,480 Cost of goods sold 59,475 Gross margin 46,005 Operating expenses Selling expenses (2,750 ) Depreciation expense (4,045 ) Operating income 39,210 Nonoperating item Loss of sale of land (3,800 ) Net income $ 35,410 BOWMAN DIVISION Balance Sheet As of December 31, 2018 Assets Cash $ 12,532...