Question

In: Accounting

Shown as follows are responsibility income statements for Butterfield, Inc., for the month of March. Investment...

Shown as follows are responsibility income statements for Butterfield, Inc., for the month of March.

Investment Centers
Butterfield, Inc Division 1 Division 2
Dollars % Dollars % Dollars %
Sales $ 470,000 100.00 % $ 290,000 100 % $ 180,000 100 %
Variable costs 228,000 48.51 174,000 60 54,000 30
Contribution margin $ 242,000 51.49 % $ 116,000 40 % $ 126,000 70 %
Fixed costs traceable to divisions 147,300 31.34 60,900 21 86,400 48
Division responsibility margin $ 94,700 20.15 % $ 55,100 19 % $ 39,600 22 %
Common fixed costs 50,000 10.64
Income from operations $ 44,700 9.51 %
Profit Centers
Division 1 Product A Product B
Dollars % Dollars % Dollars %
Sales $ 290,000 100 % $ 116,000 100.00 % $ 174,000 100.00 %
Variable costs 174,000 60 52,200 45.00 121,800 70.00
Contribution margin $ 116,000 40 % $ 63,800 55.00 % $ 52,200 30.00 %
Fixed costs traceable to products 40,600 14 12,180 10.50 28,420 16.33
Product responsibility margin $ 75,400 26 % $ 51,620 44.50 % $ 23,780 13.67 %
Common fixed costs 20,300 7
Responsibility margin for division $ 55,100 19 %

Required:

a. The company plans to initiate an advertising campaign for one of the two products in Division 1. The campaign would cost $3,000 per month and is expected to increase the sales of whichever product is advertised by $40,000 per month. Compute the expected increase in the responsibility margin of Division 1 assuming that (1) product A is advertised and (2) product B is advertised.

e. Prepare an income statement for Butterfield, Inc., by division, under the assumption that in April the monthly sales in Division 2 increase to $200,000.

Solutions

Expert Solution

Solution a:

Income Statement - Butterfield Inc. - Division 1 (Product A advertised)
Particulars Division 1 Product A Product B
Amount % Amount % Amount %
Sales $330,000.00 100.00% $156,000.00 100.00% $174,000.00 100.00%
Varaible Cost $192,000.00 58.18% $70,200.00 45.00% $121,800.00 70.00%
Contribution Margin $138,000.00 41.82% $85,800.00 55.00% $52,200.00 30.00%
Fixed costs tracable to products $43,600.00 13.21% $15,180.00 9.73% $28,420.00 16.33%
Product Responsibility Margin $94,400.00 28.61% $70,620.00 45.27% $23,780.00 13.67%
Common Fixed costs $20,300.00 6.15%
Responsibility margin for division $74,100.00 22.45%
Exisitng responsibility margin $55,100.00
Net Increase in responsibility margin $19,000.00
Income Statement - Butterfield Inc. - Division 1 (Product B advertised)
Particulars Division 1 Product A Product B
Amount % Amount % Amount %
Sales $330,000.00 100.00% $116,000.00 100.00% $214,000.00 100.00%
Varaible Cost $202,000.00 61.21% $52,200.00 45.00% $149,800.00 70.00%
Contribution Margin $128,000.00 38.79% $63,800.00 55.00% $64,200.00 30.00%
Fixed costs tracable to products $43,600.00 13.21% $12,180.00 10.50% $31,420.00 14.68%
Product Responsibility Margin $84,400.00 25.58% $51,620.00 44.50% $32,780.00 15.32%
Common Fixed costs $20,300.00 6.15%
Responsibility margin for division $64,100.00 19.42%
Exisitng responsibility margin $55,100.00
Net Increase in responsibility margin $9,000.00

Solution e:

Divisional Income Statement - Butterfield Inc. - April
Particulars Butterfield Inc. Division 1 Division 2
Amount % Amount % Amount %
Sales $490,000.00 100.00% $290,000.00 100.00% $200,000.00 100.00%
Varaible Cost $234,000.00 47.76% $174,000.00 60.00% $60,000.00 30.00%
Contribution Margin $256,000.00 52.24% $116,000.00 40.00% $140,000.00 70.00%
Fixed costs tracable to divisions $147,300.00 30.06% $60,900.00 21.00% $86,400.00 43.20%
Product Responsibility Margin $108,700.00 22.18% $55,100.00 19.00% $53,600.00 26.80%
Common Fixed costs $50,000.00 10.20%
Income from operations $58,700.00 11.98%

Related Solutions

Shown as follows is a segmented income statement for Drexel-Hall during the current month. Profit Centers...
Shown as follows is a segmented income statement for Drexel-Hall during the current month. Profit Centers Drexel-Hall Store 1 Store 2 Store 3 Dollars % Dollars % Dollars % Dollars % Sales $ 1,800,000 100 % $ 600,000 100 % $ 600,000 100 % $ 600,000 100 % Variable costs 1,080,000 60 372,000 62 378,000 63 330,000 55 Contribution margin $ 720,000 40 % $ 228,000 38 % $ 222,000 37 % $ 270,000 45 % Traceable fixed costs: controllable...
Shown as follows is a segmented income statement for Drexel-Hall during the current month. Profit Centers...
Shown as follows is a segmented income statement for Drexel-Hall during the current month. Profit Centers Drexel-Hall Store 1 Store 2 Store 3 Dollars % Dollars % Dollars % Dollars % Sales $ 1,800,000 100 % $ 600,000 100 % $ 600,000 100 % $ 600,000 100 % Variable costs 1,080,000 60 372,000 62 378,000 63 330,000 55 Contribution margin $ 720,000 40 % $ 228,000 38 % $ 222,000 37 % $ 270,000 45 % Traceable fixed costs: controllable...
The income statement for The TJX Companies, Inc., follows. THE TJX COMPANIES, INC. Consolidated Statements of...
The income statement for The TJX Companies, Inc., follows. THE TJX COMPANIES, INC. Consolidated Statements of Income Fiscal Year Ended ($ thousands) January 28, 2006 Net sales $16,057,935 Cost of sales, including buying and occupancy costs 12,295,016 Selling, general and administrative expenses 2,723,960 Provision (credit) for computer intrusion related costs - Interest expense (revenue), net 29,632 Income from continuing operations before provision for income taxes 1,009,327 Provision for income taxes 318,904 Income from continuing operations 690,423 Gain from discontinued operations,...
The most recent financial statements for Zoso, Inc., are shown here (assuming no income taxes):   Income...
The most recent financial statements for Zoso, Inc., are shown here (assuming no income taxes):   Income Statement Balance Sheet   Sales $4,200     Assets $15,300     Debt $11,000     Costs 3,390     Equity 4,300       Net income $810       Total $15,300       Total $15,300   Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year's sales are projected to be $5,976. Required: What is the external financing needed? (Do not round your intermediate calculations.)
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income...
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income Statement   Sales $5,683   Costs $4,258 Balance Sheet   Assets $16,387   Debt $8,882 Equity ? Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $7,885. What is the external financing needed?
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income...
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income Statement   Sales $7235   Costs $4280 Balance Sheet   Assets $16063   Debt $8972 Equity ? Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $7709. What is the external financing needed? (Negative amount should be indicated by a minus sign.) (Omit the "$" sign and commas in your response. Enter your answer...
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income...
The most recent financial statements for Dockett, Inc., are shown here (assuming no income taxes): Income Statement Sales $7468 Costs $4028 Balance Sheet Assets $17637 Debt $6122 Equity ? Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year’s sales are projected to be $8681. What is the external financing needed?
most recent financial statements for kerch inc are shown here. the Assuming no income taxes. income...
most recent financial statements for kerch inc are shown here. the Assuming no income taxes. income statement Balance Sheet sales $8,300 assets $23,200 Debt $9,00 costs 5,400 _______ Equity 14200 net 2810 Total $23,200 Total $23,20 income Assets and cost are proportional to sales. Debt and equity are not. No dividends are paid. Next year's sales are projected to be $9545 What is the external financing needed?
The most recent financial statements for Zoso, Inc., are shown here (assuming no income taxes):   Income...
The most recent financial statements for Zoso, Inc., are shown here (assuming no income taxes):   Income Statement Balance Sheet   Sales $4,500     Assets $15,300     Debt $10,400     Costs 3,440     Equity 4,900       Net income $1,060       Total $15,300       Total $15,300   Assets and costs are proportional to sales. Debt and equity are not. No dividends are paid. Next year's sales are projected to be $5,959. Required: What is the external financing needed? (Do not round your intermediate calculations.)
Return on investment​ (ROI) is often expressed as​ follows: Income / Investment = Income / Revenues...
Return on investment​ (ROI) is often expressed as​ follows: Income / Investment = Income / Revenues x Revenues / Investment 1. What advantages are there in the breakdown of the computation into two separate​ components? 2. Fill in the blanks for the following​ table: Companies in Same Industry A B C Revenues $1,600,000 $1,300,000 ? Income $96,000 $78,000 ? Investment $800,000 ? $2,600,000 Income as a percentage of revenues ? ? 1.5 % Investment turnover ? ? 2 ROI ?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT