Question

In: Accounting

Financial data for three different divisions of the same company, for last year, appear below: Division                         &

Financial data for three different divisions of the same company, for last year, appear below:

Division                                     A          %             B         %              C          % Company Total %

Sales                                  $3,200,000            $3,500,000           $5,000,000

Variable Costs                    1,450,000              1,750,000             2,750,000

Traceable Fixed Costs        1,250,000              1,350,000             1,450,000

Segment Margin

Common Fixed Costs:                                                                                              1,500,000

PART I: Complete the above table showing the Contribution Margin Ratio(CMR), and the segment margin for each of the segments. Determine the CMR for the company as a whole . If the company were to add a new division, what information from the above would you use to assist in the decision-making?

Division                                     A                            B                          C             Company Total

Average Operating Assets $4,000,000           $4,375,000         $4,000,000               

[AOA]                                                                                                               

Segment  Margin                                        

Turnover [T/O]

ROI

Minimum Required Rate of Return - MRROR  for the industry                                     

[MRROR] @ 8%

Residual Income [RI]

Required:    Complete the above comparison and answer the questions that follow

Here are the formulas for:

                 Margin - >  OI          Turnover - > Sales             ROI -> Margin x Turnover

                                    Sales                             AOA

RI -> OI – (MRROR x AOA)

  1. Compute each division’s turnover and ROI for the reporting period. Explain what is meant by “turnover”
  2. In the industry the average MRROR is 8%. Determine the residual income (RI) for each division. What is the sigfnificance of the MRROR? Why is RI a better measure of performance than ROI?
  3. If sales in the industry increased by 10%, without any increase in operating assets, which company would show the highest largest change in operating income? Why?
  4. If an expansion program that would require new investments of $1,000,000 in operating assets were undertaken, which division would you recommend in order to produce the highest return? Why?

Solutions

Expert Solution


Related Solutions

Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 346,000 $ 324,792 Accounts receivable 202,000 159,000 Inventory 298,000 299,000 Plant and equipment (net) 463,000 455,000 Investment in Cedar Company 318,000 293,000 Land (undeveloped) 237,000 237,000 Total assets $ 1,864,000 $ 1,767,792 Liabilities and owners' equity: Accounts payable $ 249,000 $ 228,000 Long-term debt 855,000 855,000 Owners' equity 760,000 684,792 Total liabilities and owners' equity $ 1,864,000...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 295,000 $ 336,524 Accounts receivable 178,000 180,000 Inventory 275,000 222,000 Plant and equipment (net) 480,000 441,000 Investment in Cedar Company 306,000 322,000 Land (undeveloped) 273,000 273,000 Total assets $ 1,807,000 $ 1,774,524 Liabilities and owners' equity: Accounts payable $ 224,000 $ 197,000 Long-term debt 824,000 824,000 Owners' equity 759,000 753,524 Total liabilities and owners' equity $ 1,807,000...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 260,000 $ 217,450 Accounts receivable 157,000 149,000 Inventory 288,000 284,000 Plant and equipment (net) 496,000 450,000 Investment in Cedar Company 233,000 347,000 Land (undeveloped) 335,000 335,000 Total assets $ 1,769,000 $ 1,782,450 Liabilities and owners' equity: Accounts payable $ 213,000 $ 171,000 Long-term debt 803,000 803,000 Owners' equity 753,000 808,450 Total liabilities and owners' equity $ 1,769,000...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position...
Financial data for Beaker Company for last year appear below: Beaker Company Statements of Financial Position Beginning Balance Ending Balance Assets: Cash $ 346,000 $ 324,792 Accounts receivable 202,000 159,000 Inventory 298,000 299,000 Plant and equipment (net) 463,000 455,000 Investment in Cedar Company 318,000 293,000 Land (undeveloped) 237,000 237,000 Total assets $ 1,864,000 $ 1,767,792 Liabilities and owners' equity: Accounts payable $ 249,000 $ 228,000 Long-term debt 855,000 855,000 Owners' equity 760,000 684,792 Total liabilities and owners' equity $ 1,864,000...
Financial data for Bingham Company for last year appear below: Bingham Company Balance Sheet For the...
Financial data for Bingham Company for last year appear below: Bingham Company Balance Sheet For the years ended Dec 31 2018 and 2019 ASSETS Dec 31, 2018 Dec 31, 2019 Cash 135,000 266,000 Accounts Receivable 225,000 475,000 Inventory 314,000 394,000 Plant+Equipment (net) 940,000 860,000 Investment in Carr Corp. 104,000 101,000 Land 198,000 65,000 Total Assets 1,916,000 2,161,000 LIABILITIES + EQUITY Accounts Payable 88,000 119,000 Long-Term Debt 585,000 665,000 Owner’s equity 1,243,000 1,377,000 Total Liabilities + Equity 1,916,000 2,161,000 Bingham Company...
Financial data for Bingham Company for last year appear below: Bingham Company Balance Sheet For the...
Financial data for Bingham Company for last year appear below: Bingham Company Balance Sheet For the years ended Dec 31 2018 and 2019 ASSETS Dec 31, 2018 Dec 31, 2019 Cash 135,000 266,000 Accounts Receivable 225,000 475,000 Inventory 314,000 394,000 Plant+Equipment (net) 940,000 860,000 Investment in Carr Corp. 104,000 101,000 Land 198,000 65,000 Total Assets 1,916,000 2,161,000 LIABILITIES + EQUITY Accounts Payable 88,000 119,000 Long-Term Debt 585,000 665,000 Owner’s equity 1,243,000 1,377,000 Total Liabilities + Equity 1,916,000 2,161,000 Bingham Company...
Condensed financial data of Oakley Company appear below.
Condensed financial data of Oakley Company appear below.     Additional information: 1. Equipment costing $97,000 was purchased for cash during the year. 2. Investments were sold at cost. 3. Equipment costing $47,000 was sold for $15,550, resulting in gain of $8,750. 4. A cash dividend of $83,400 was declared and paid during the year.   Instructions Prepare a worksheet for the statement of cash flows using the indirect method. Enter the reconciling items directly in the worksheet columns, using letters to...
Kilgors have three different divisions: Wine Division; Hotels Division; and Entertainment Division. Your role is to...
Kilgors have three different divisions: Wine Division; Hotels Division; and Entertainment Division. Your role is to prepare a balanced scorecard for the Wine Division to help managers evaluate performance.   1. Within the simulation, you selected the different BSC measures. On the table below, place a cross next to the measures you selected. Draw lines to demonstrate the cause and effect linkages between the measures that you have identified. [2 Marks] FINANCIAL CUSTOMER Return on investment Discounts and rebates as a...
When the Essex Company formed three divisions a year ago, the president told the division managers...
When the Essex Company formed three divisions a year ago, the president told the division managers an annual bonus would be given to the most profitable division. The bonus would be based on either the return on investment or residual income of the division. Investment is to be measured using gross book value or net book value. The following data are available: Division Book value Operating, Inc. A $500,000 $53,500 B $480,000 $52,000 C $300,000 $33,300             All the assets...
A multinational company has many divisions. Two of these divisions are Mic Division and Mandy Division....
A multinational company has many divisions. Two of these divisions are Mic Division and Mandy Division. The Mic Division produces a component that is used by the Mandy Division. The cost of manufacturing the component is as follows: Direct materials $10 Direct labour $6 Variable overhead $4 Fixed overhead $5* Total cost $25 *Based on a normal volume of 400,000 components Other costs incurred by the Mic Division are as follows: Fixed selling and administrative: $400,000 Variable selling: $1.50 per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT