The following table contains
financial information from 5 different companies:
|
|
Company
A |
Company
B |
Company
C |
Company
D |
Company
E |
|||||||||||
December 31, 2010
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
Assets
|
$
|
37,000
|
|
$
|
28,860
|
|
$
|
23,680
|
|
$
|
65,860
|
|
$
|
101,010
|
|
|
Liabilities
|
|
30,340
|
|
|
20,202
|
|
|
12,787
|
|
|
45,443
|
|
|
?
|
|
|
December 31, 2011
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Assets
|
|
40,000
|
|
|
28,800
|
|
|
?
|
|
|
72,800
|
|
|
110,400
|
|
|
Liabilities
|
|
?
|
|
|
19,584
|
|
|
13,132
|
|
|
34,944
|
|
|
87,216
|
|
|
During year 2011
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Stock
issuances
|
|
6,000
|
|
|
1,400
|
|
|
9,750
|
|
|
?
|
|
|
6,500
|
|
|
Net
income (loss)
|
|
8,840
|
|
|
?
|
|
|
1,100
|
|
|
10,439
|
|
|
7,482
|
|
|
Cash
dividends
|
|
3,500
|
|
|
2,000
|
|
|
5,875
|
|
|
0
|
|
|
11,000
|
|
|
Required:
|
||||||||||||||||
Answer the following questions
about Company A (Omit the "$" sign in
your response):
|
1a.
|
What is the amount of equity on
December 31, 2010?
|
Amount of equity
|
$
6,660
|
1b.
|
What is the amount of equity on
December 31, 2011?
|
Amount of equity
|
$
18,000
|
1c.
|
What is the amount of liabilities
on December 31, 2011?
|
Amount of
liabilities
|
$
22,000
|
Explanation:
Company A:
|
|
|
|
|
|
a.
|
Equity on December 31,
2010:
|
|
|
|
|
|
Assets
|
$
|
37,000
|
|
|
|
Liabilities
|
|
(30,340
|
)
|
|
|
|
|
|
|
|
|
Equity
|
$
|
6,660
|
|
|
|
|
|
|
|
|
b.
|
Equity on December 31, 2011:
|
|
|
|
|
|
Equity, December 31, 2010
|
$
|
6,660
|
|
|
|
Plus stock issuances
|
|
6,000
|
|
|
|
Plus net income
|
|
8,840
|
|
|
|
Less cash dividends
|
|
(3,500
|
)
|
|
|
|
|
|
|
|
|
Equity, December 31, 2011
|
$
|
18,000
|
|
|
|
|
|
|
|
|
c.
|
Amount of liabilities on
December 31, 2011:
|
|
|
|
|
|
Assets
|
$
|
40,000
|
|
|
|
Equity
|
|
(18,000
|
)
|
|
|
|
|
|
|
|
|
Liabilities
|
$
|
22,000
|
|
|
|
|
|
|
|
|
Answer the following questions
about Company B (Omit the "$" sign in
your response):
|
2a.
|
What is the amount of equity on
December 31, 2010?
|
Amount of equity
|
$
8,658
|
2b.
|
What is the amount of equity on
December 31, 2011?
|
Amount of equity
|
$
9,216
|
2c.
|
What is net income for year 2011?
|
Net income
|
$
1,158
|
Explanation
Explanation:
Company B:
a. and b.
a. and b.
|
12/31/2010
|
|
12/31/2011
|
|
||||
Equity:
|
|
|
|
|
||||
Assets
|
$
|
28,860
|
|
|
$
|
28,800
|
|
|
Liabilities
|
|
(20,202
|
)
|
|
|
(19,584
|
)
|
|
|
|
|
|
|
|
|
|
|
Equity
|
$
|
8,658
|
|
|
|
9,216
|
|
|
|
|
|
|
|
|
|
|
|
|
c.
|
|
|
|
|
Net income for 2011:
|
|
|
|
|
Equity,
December 31, 2010
|
$
|
8,658
|
|
|
Plus stock
issuances
|
|
1,400
|
|
|
Plus net
income
|
|
?
|
|
|
Less cash
dividends
|
|
(2,000
|
)
|
|
|
|
|
|
|
Equity,
December 31, 2011
|
$
|
9,216
|
|
|
|
|
|
|
|
|
Therefore, net income must have
been $ 1,158.
|
3.
|
Calculate the amount of assets for
Company C on December 31, 2011. (Omit the
"$" sign in your response)
|
Amount of Assets
|
$
29,000
|
Explanation:
Company C:
First, calculate the beginning
balance of equity:
|
|
Dec.
31, 2010
|
||||
Assets
|
|
$
|
23,680
|
|
|
Liabilities
|
|
|
(12,787
|
)
|
|
|
|
|
|
|
|
Equity
|
|
$
|
10,893
|
|
|
|
|
|
|
|
|
|
Next, find the ending balance of
equity as follows:
|
|
|
|
|
|
Equity, December 31,
2010
|
$
|
10,893
|
|
|
Plus stock issuances
|
|
9,750
|
|
|
Plus net income
|
|
1,100
|
|
|
Less cash dividends
|
|
(5,875
|
)
|
|
|
|
|
|
|
Equity, December 31,
2011
|
$
|
15,868
|
|
|
|
|
|
|
|
|
Finally, find the ending amount of
assets by adding the ending balance of equity to the ending balance of
liabilities:
|
|
Dec.
31, 2011
|
||||||
Liabilities
|
|
$
|
13,132
|
|
|
||
Equity
|
|
|
15,868
|
|
|
||
|
|
|
|
|
|
||
Assets
|
|
$
|
29,000
|
|
|
||
|
|
|
|
|
|
||
4.
|
Calculate the amount of stock
issuances for Company D during year 2011. (Omit
the "$" sign in your response):
|
||||||
Amount of stock issuances
|
$
|
Explanation:
Company D:
|
First, calculate the beginning and
ending owner’s equity balances:
|
|
12/31/2010
|
|
12/31/2011
|
|
||||
Assets
|
$
|
65,860
|
|
|
$
|
72,800
|
|
|
Liabilities
|
|
(45,443
|
)
|
|
|
(34,944
|
)
|
|
|
|
|
|
|
|
|
|
|
Equity
|
$
|
20,417
|
|
|
|
37,856
|
|
|
|
|
|
|
|
|
|
|
|
|
Then, find the amount of stock
issuances during 2011:
|
|
|
|
|
Equity, December 31,
2010
|
$
|
20,417
|
|
Plus stock issuances
|
|
?
|
|
Plus net income
|
|
10,439
|
|
Less cash dividends
|
|
0
|
|
|
|
|
|
Equity, December 31,
2011
|
$
|
37,856
|
|
|
|
|
|
|
Thus, stock issuances must have
been: $ 7,000
|
5.
|
Calculate the amount of
liabilities for Company E on December 31, 2010. (Omit
the "$" sign in your response):
|
Amount of Liabilities
|
$
|
Explanation:
Company E:
|
First, compute the balance of
equity as of December 31, 2011:
|
|
|
||||
Assets
|
|
$
|
110,400
|
|
|
Liabilities
|
|
|
(87,216
|
)
|
|
|
|
|
|
|
|
Equity
|
|
$
|
23,184
|
|
|
|
|
|
|
|
|
|
Next, find the beginning balance
of equity as follows:
|
|
|
|
|
|
Equity, December 31,
2010
|
$
|
?
|
|
|
Plus stock issuances
|
|
6,500
|
|
|
Plus net income
|
|
7,482
|
|
|
Less cash dividends
|
|
(11,000
|
)
|
|
|
|
|
|
|
Equity, December 31,
2011
|
$
|
23,184
|
|
|
|
|
|
|
|
|
Thus, the beginning balance of
equity was $20,202.
|
Finally, find the beginning amount
of liabilities by subtracting the beginning balance of equity from the
beginning balance of assets:
|
|
Dec.
31, 2010
|
||||
Assets
|
|
$
|
101,010
|
|
|
Equity
|
|
|
(20,202
|
)
|
|
|
|
|
|
|
|
Liabilities
|
|
$
|
80,808
|
|
|
|
|
|
|
|
|
|
Last month when Harrison Creations, Inc., sold 40,000 units, total sales were $300,000, total variable expenses were $240,000, and fixed expenses were $45,000.
ReplyDeleteRequired:
1. What is the company’s contribution margin (CM) ratio? (Omit the "%" sign in your response.)
Contribution margin ratio %
2. Estimate the change in the company’s net operating income if it were to increase its total sales by $1,500. (Omit the "$" sign in your response.)
Estimated change in net operating income $
Shirts Unlimited operates a chain of shirt stores that carry many styles of shirts that are all sold at the same price. To encourage sales personnel to be aggressive in their sales efforts, the company pays a substantial sales commission on each shirt sold. Sales personnel also receive a small basic salary.
ReplyDeleteThe following worksheet contains cost and revenue data for Store 36. These data are typical of the company's many outlets:
Per Shirt
Selling price $ 40.00
Variable expenses:
Invoice cost $ 18.00
Sales commission 7.00
Total variable expenses $ 25.00
Annual
Fixed expenses:
Rent $ 80,000
Advertising 150,000
Salaries 70,000
Total fixed expenses $ 300,000
The company has asked you, as a member of its planning group, to assist in some basic analysis of
its stores and company policies.
Required:
1.
Calculate the annual break-even point in dollar sales and in unit sales for Store 36. (Omit the "$" sign in your response.)
Break-even point in unit sales shirts
Break-even point in dollar sales $
3.
If 19,000 shirts are sold in a year, what would be Store 36's net operating income or loss? (Input the amount as a positive value. Omit the "$" sign in your response.)
$
4.
The company is considering paying the store manager of Store 36 an incentive commission of $3 per shirt (in addition to the salespersons' commissions). If this change is made, what will be the new break-even point in dollar sales and in unit sales? (Omit the "$" sign in your response.)
New break-even point in unit sales shirts
New break-even point in dollar sales $
5.
Refer to the original data. As an alternative to (4) above, the company is considering paying the store manager a $3 commission on each shirt sold in excess of the break-even point. If this change is made, what will be the store’s net operating income or loss if 23,500 shirts are sold in a year? (Input the amount as a positive value. Omit the "$" sign in your response.)
$
6.
Refer to the original data. The company is considering eliminating sales commissions entirely in its stores and increasing fixed salaries by $107,000 annually. If this change is made, what will be the new break-even point in dollar sales and in unit sales in Store 36? (Omit the "$" sign in your response.)
New break-even point in unit sales shirts
New break-even point in dollar sales $
Memofax, Inc., produces memory enhancement kits for fax machines. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below:
ReplyDeleteSales (13,500 units at $20 per unit) $ 270,000
Variable expenses 189,000
Contribution margin 81,000
Fixed expenses 90,000
Net operating loss $ (9,000)
Required:
1.
Compute the company's CM ratio and its break-even point in both units and dollars. (Omit the "%" and "$" signs in your response.)
CM ratio %
Break-even point in units
Break-even point in dollars $
2.
The sales manager feels that an $8,000 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result in a $70,000 increase in monthly sales. If the sales manager is right, what will the revised net operating income or loss? (Use the incremental approach in preparing your answer.) (Omit the "$" sign in your response.)
is $
3.
Refer to the original data. The president is convinced that a 10% reduction in the selling price, combined with an increase of $35,000 in the monthly advertising budget, will double unit sales. What will the new contribution format income statement look like if these changes are adopted? (Input all amounts as positive values. Omit the "$" sign in your response.)
Contribution Income Statement
$
$
4.
Refer to the original data. The company’s advertising agency thinks that a new package would help sales. The new package being proposed would increase packaging costs by $0.60 per unit. Assuming no other changes, how many units would have to be sold each month to earn a profit of $4,500? (Do not round intermediate calculations.)
Sales units
5.
Refer to the original data. By automating, the company could slash its variable expenses in half. However, fixed costs would increase by $118,000 per month.
a.
Compute the new CM ratio and the new break-even point in both units and dollars. (Do not round intermediate calculations. Omit the "%" and "$" signs in your response.)
CM ratio %
Break-even point in units
Break-even point in dollars $
b.
Assume that the company expects to sell 20,000 units next month. Prepare two contribution format income statements, one assuming that operations are not automated and one assuming that they are. (Omit the "$" and "%" signs in your response.)
Not Automated
Automated
Total Per Unit % Total Per Unit %
$ $ $ $
$ $
$ $