Question

In: Accounting

Tru-Green Industries has two product lines of sprinklers that it manufactures: Oscillating and Rotary. The following...

Tru-Green Industries has two product lines of sprinklers that it manufactures: Oscillating and Rotary. The following is an income statement for each of the two product lines and for the total company for the year ended December 31, 2019:

Oscillating

Rotary

Total

Sales

$745,000

$695,000

$1,440,000

Cost of Goods Sold

(503,000)

(512,500)

(1,015,500)

Sales Commission

(47,000)

(44,000)

(91,000)

Contribution Margin

195,000

138,500

333,500

Advertising expense (specific to each individual segment)

(27,000)

(7,500)

(34,500)

General Fixed Operations Expense

(45,000)

(30,000)

(75,000)

Operating income

$123,000

$101,000

$224,000

Tru-Green Industries has a desired rate of return of 10%. Operating assets for each product line and the total operating assets for the company for 2019 are as follow:

Product Line

Operating Assets

Oscillating

$940,000

Rotary

$975,000

Total

$1,915,000

Required:

  1. What is the return on investment for each product line and for the entire company?

  2. What is the margin for each product line and for the company?

  3. Which product line is most profitable and why?

  4. What is the residual income of each product line and of the entire company?

Solutions

Expert Solution

Question 1:-

Return on investment for each product line is calculated using the following formula:-

(Operating Income/Average total assets) * 100

Oscillating = ($123,000/$940,000) * 100 = 13.09%

Rotary = ($101,000/$975,000) * 100 = 10.36%

Company = ($123,000 + $101,000/$940,000 + $975,000) = 11.70%

Question 2:-

Margin for the each product:-

(Operating Income/Sales) * 100

Oscillating = ($123,000/$745,000) * 100 = 16.51%

Rotary = ($101,000/$695,000) * 100 = 14.53%

Company = ($123,000 + $101,000/$745,000 + $695,000) = 15.56%

Question 3:-

The product line that is most profitable is Oscillating because it has a higher Margin in comparison to the Rotary. The Oscillating product line has a Margin of 16.51% in comparison to Rotary which has a margin of 14.53%

Question 4:-

Residual income = Operating Income - (Required Rate of return * Operating Assets)

Oscillating = $123,000 - (10% * $940,000) = $123,000 - $94,000 = $29,000

Rotary = $101,000 - (10% * $975,000) = $101,000 - $97,500 = $3,500

Company = $224,000 - (10% of $940,000 + $975,000) = $224,000 - (10% * $1,915,000) = $224,000 - $191,500 = $32,500


Related Solutions

  Green Lawn Industries has three product lines of sprinklers that it manufactures: Oscillating, Rotary, and Traveling....
  Green Lawn Industries has three product lines of sprinklers that it manufactures: Oscillating, Rotary, and Traveling. The following is an income statement for each of the three product lines for the year ended December 31, 2019: Oscillating Rotary Traveling Total Sales $375,000 $232,500 $300,000 $907,500 Cost of Goods Sold (123,000) (182,500) (127,500) (433,000) Sales Commission (33,000) (32,500) (30,000) (95,500) Contribution Margin 219,000 17,500 142,500 379,000 Advertising expense (specific to each individual segment) (27,000) (7,500) 0 (34,500) General Fixed Operations Expense...
Problem #2: Green Lawn Industries produces three types of lawn sprinklers: Oscillating, Rotary, and Traveling. Management...
Problem #2: Green Lawn Industries produces three types of lawn sprinklers: Oscillating, Rotary, and Traveling. Management is going through its annual planning and budgeting process and is anticipating producing 18,500 Oscillating units; 15,000 Rotary units, and 8,400 Traveling units for the upcoming year. Manufacturing costs for the upcoming fiscal year are budgeted to be as follows: Raw materials cost for Oscillating Sprinklers $ 137,320 Raw materials cost for Rotary Sprinklers $ 183,280 Raw materials cost for Traveling Sprinklers $ 157,280...
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury....
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $161,629 in overhead. The company has identified the following information about its overhead activity cost pools and the two product lines: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Basic Quantity/Amount Consumed by Luxury Materials handling Number of moves $ 4,134 13 moves 65 moves Quality control Number of inspections $ 30,295 200 inspections 100...
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury....
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $151,630 in overhead. The company has identified the following information about its overhead activity cost pools and the two product lines: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Basic Quantity/Amount Consumed by Luxury Materials handling Number of moves $ 4,000 10 moves 70 moves Quality control Number of inspections $ 26,730 220 inspections 110...
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury....
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $175,765 in overhead. The company has identified the following information about its overhead activity cost pools and the two product lines: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Basic Quantity/Amount Consumed by Luxury Materials handling Number of moves $ 4,240 15 moves 65 moves Quality control Number of inspections $ 33,725 180 inspections 175...
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury....
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $175,565 in overhead. The company has identified the following information about its overhead activity cost pools and the two product lines: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Basic Quantity/Amount Consumed by Luxury Materials handling Number of moves $3,640 25 moves 40 moves Quality control Number of inspections $37,525 220 inspections 175 inspections Machine...
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury....
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $141,783 in overhead. The company has identified the following information about its overhead activity cost pools and the two product lines: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Basic Quantity/Amount Consumed by Luxury Materials handling Number of moves $ 4,408 23 moves 53 moves Quality control Number of inspections $ 28,475 180 inspections 155...
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury....
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $181,011 in overhead. The company has identified the following information about its overhead activity cost pools and the two product lines: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Basic Quantity/Amount Consumed by Luxury Materials handling Number of moves $ 3,036 12 moves 54 moves Quality control Number of inspections $ 29,575 230 inspections 95...
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury....
Hazelnut Corp. manufactures lawn ornaments. It currently has two product lines, the basic and the luxury. Hazelnut has a total of $169,007 in overhead. The company has identified the following information about its overhead activity cost pools and the two product lines: Activity Cost Pools Cost Driver Cost Assigned to Pool Quantity/Amount Consumed by Basic Quantity/Amount Consumed by Luxury Materials handling Number of moves $ 4,032 25 moves 47 moves Quality control Number of inspections $ 33,375 200 inspections 175...
Comprehensive Insurance Company has two product lines: health insurance and auto insurance. The two product lines...
Comprehensive Insurance Company has two product lines: health insurance and auto insurance. The two product lines are served by three operating departments which are necessary for providing the two types of products: claims processing, administration, and sales. These three operating departments are supported by two departments: information technology and operations. The support provided by information technology and operations to the other departments is shown below. Support Departments Operating Departments Information Technology Operations Claims Processing Administration Sales Information technology — 20...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT