Woods and Waters Financial and Managerial Analysis

Please see attached spreadsheet for data.

The Woods and Waters Company has two operating divisions, the Service Division and the Irrigation Division.
The company evaluates the performance of its divisions using the Return on Investment (RoI) measure. The following information pertains to the two divisions as of the end of the current year:

During the year, the Service Division repaired 8,000 units at an average service fee of $50.00 per unit. The Irrigation Division sold 250 units at an average price of $5,000. The company requires a minimum rate of return of 12%.

Compute the Return on Investment (ROI) measure for both divisions and the company as a whole. Based on ROI alone which division had the better performance? Round ROI measures to the nearest whole percent. Evaluate this company.

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/accounting/woods-and-waters-financial-and-managerial-analysis-7djf
Attachments

Solution Preview

... Round ROI measures to the nearest whole percent.

Evaluate this company.

Following are the steps to solve the above problem

A. Calculate the Operating Profits of both the division

Service Division Irrigation Division Total
Revenues 400000 1250000 1650000

Costs
Direct Material 40,000 400,000 440,000
Direct ...