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% | ||||
ekkarill92 answered 1 year agoRelated 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
Latest Questions
- answer the following using C# Design and program a Visual Studio Console project in C# that...
- Write a program that acts as a basic calculator Assume the starting result is 0 Ask...
- Explain the following business terms: Explain what attestation means in business. Explain what assurance means in...
- Write a program to carry out the stated task: When one of the buttons is pressed,...
- The current asset section of the Excalibur Tire Company’s balance sheet consists of cash, marketable securities,...
- Write a program that uses a two-dimensional array to store the highest and lowest temperatures for...
- Question 1. What aspects of Michelangelo’s David (1501-1504) are characteristic of Italian Renaissance art? Question 2....
ADVERTISEMENT