Question

In: Accounting

Muscle Bound Co. sells home exercise equipment. The company has two sales territories, Eastern and Western....

Muscle Bound Co. sells home exercise equipment. The company has two sales territories, Eastern and Western. Two products are sold in each territory: FasTrak (a Nordic ski simulator) and RowMaster (a stationary rowing machine).

  

During January, the following data are reported for the Eastern territory.

FasTrak RowMaster
Sales $ 600,000 $ 750,000
Contribution margin ratios 55 % 40 %
Traceable fixed costs $ 80,000 $ 150,000

Common fixed costs in the Eastern territory amounted to $120,000 during the month.

During January, the Western territory reported total sales of $600,000, variable costs of $270,000, and a responsibility margin of $200,000. Muscle Bound also incurred $180,000 of common fixed costs that were not traceable to either sales territory.


In addition to being profit centers, each territory is also evaluated as an investment center. Average assets utilized by the Eastern and Western territories amount to $14,000,000 and $12,000,000, respectively.

Required:

a. Prepare the January income statement for the Eastern territory by product line.

b. Prepare the January income statement for the company showing profits by sales territories. Conclude your statement with income from operations for the company and with responsibility margins for the two territories.

c. Compute the rate of return on average assets earned in each sales territory during the month of January.

e-1. The manager of the Eastern territory is authorized to spend an additional $50,000 per month to advertise one of the products. Based on past experience, the manager estimates that additional advertising will increase the sales of either product by $120,000?

e-2. On which product should the manager focus this advertising campaign?

Solutions

Expert Solution

SOLUTION:-

a

Muscle Bound Co.
Income Statement
Eastern Territory
For the month ended January 31
Fas Trak RowMaster Total
Sales Revenue $ 600,000 $ 750,000 $ 1,350,000
Less: Variable Costs 270,000 450,000 720,000
Contribution Margin $ 330,000 $ 300,000 630,000
Less: Traceable Fixed Costs 80,000 150,000 230,000
Product Margin $ 250,000 $ 150,000 $ 400,000
Common Fixed Costs 0 0 120,000
Net Operating Income $ 280,000

b.

Muscle Bound Co.
Income Statement
For the month ended January 31

Eastern

Territory

Western Territory Total
$ $ $
Sales Revenue 1,350,000 600,000 1,950,000
Less: Variable Costs 720,000 270,000 990,000
Contribution Margin 630,000 330,000 960,000
Less: Traceable Fixed Costs 230,000 130,000 360,000
Responsibility Margin 400,000 200,000 600,000
Common Fixed Costs 300,000
Income from Operations $ 300,000

c

Eastern Territory Western Territory
Income from Operations $ 280,000 $ 20,000
Average Assets 14,000,000 12,000,000
Rate of return on Average Assets 2 % 0.17%

e-1. Increase (decrease) in profit for FasTrak = $ 120,000 x 55% - $ 50,000 = $ 16,000.

increase (decrease) in profit for RowMaster = $ 120,000 x 40% - $ 50,000 = $ (2,000)

e-2. The manager should fous the advertising campaign on FasTrak.

THANK YOU, if any queries please leave your valuable comment comment box.....


Related Solutions

Muscle bound co. sells home exercise equipment. The company has two sales territories, Eastern and Western....
Muscle bound co. sells home exercise equipment. The company has two sales territories, Eastern and Western. Two products are sold in each territory: Fastrak (a Nordic ski stimulator) and Row Master (a stationary rowing machine). During January, the following data are reported for the eastern territory. FasTrak RowMaster Sales.............................................. $600,000 $750,000 Contribution margin ratios.......... 55% 40% Traceable fixed costs................. $80,000 $150,000 Common fixed costs in the Eastern Territory amounted to $120,000 during the month. During January, the Western Territory reported...
1. The Company has two territories--North and South. The territories have the following revenues and expenses:...
1. The Company has two territories--North and South. The territories have the following revenues and expenses: North                    South Sales                                                                          $ 500,000         $ 550,000 Variable costs                                                          200,000    275,000 Traceable fixed costs                                           150,000    180,000 Allocated common corporate costs           135,000        170,000   Net operating income (loss)                        $    15,000 $ (75,000 ) The management time is thinking about eliminating of the South Division due to its apparent unprofitability. If the South Division were to be eliminated, its traceable...
Hercules Exercise Equipment Co. purchased a computerizedmeasuring device two years ago for $56,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $56,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $23,800. A new piece of equipment will cost $146,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $70,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $70,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $30,800. A new piece of equipment will cost $160,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $78,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $78,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $34,800. A new piece of equipment will cost $230,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $78,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $78,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $34,800. A new piece of equipment will cost $230,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $86,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $86,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $38,800.      A new piece of equipment will cost $270,000. It also falls into the five-year category for MACRS depreciation.      Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $88,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $88,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $39,800. A new piece of equipment will cost $280,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $92,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $92,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $41,800. A new piece of equipment will cost $245,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. calculate your final answer using the formula and financial calculator methods. Year Cash...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $92,000. The equipment...
Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $92,000. The equipment falls into the five-year category for MACRS depreciation and can currently be sold for $41,800. A new piece of equipment will cost $300,000. It also falls into the five-year category for MACRS depreciation. Assume the new equipment would provide the following stream of added cost savings for the next six years. Use Table 12–12. Use Appendix B for an approximate answer but calculate your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT