Question

In: Accounting

Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of...

Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow:

Morrisey & Brown, Ltd.
Income Statements
For the Three Months Ended September 30
July August September
Sales in units 6,750 7,250 7,750
Sales $ 742,500 $ 797,500 $ 852,500
Cost of goods sold 445,500 478,500 511,500
Gross margin 297,000 319,000 341,000
Selling and administrative expenses:
Advertising expense 33,800 33,800 33,800
Shipping expense 69,500 73,700 77,900
Salaries and commissions 125,000 132,100 139,200
Insurance expense 9,900 9,900 9,900
Depreciation expense 22,100 22,100 22,100
Total selling and administrative expenses 260,300 271,600 282,900
Net operating income $ 36,700 $ 47,400 $ 58,100

Required: #3 only please

1. By analyzing the data from the company's income statements, classify each of its expenses (including cost of goods sold) as either variable, fixed, or mixed.

2. Using the high-low method, separate each mixed expense into variable and fixed elements. Express the variable and fixed portions of each mixed expense in the form Y = a + bX.

3. Redo the company’s income statement at the 7,750-unit level of activity using the contribution format.

Solutions

Expert Solution

1 Expenses Classification
Cost of goods sold Variable
Advertising expense Fixed
Shipping expense Mixed
Salaries and commissions Mixed
Insurance expense Fixed
Depreciation expense Fixed
2 Shipping expense Y = $12,800 + $8.40 per unit
Salaries and commissions Y = $29,150 + $14.20 per unit
Units Shipping Expense Salaries and Commissions
High level of activity               7,750 $77,900 $139,200
Low level of activity               6,750 $69,500 $125,000
Change               1,000 $8,400 $14,200
Variable-rate $8.40 $14.20
Fixed cost $12,800 $29,150
3
Sales          852,500
Variable expenses:
Cost of goods sold            511,500
Shipping expense             65,100
Salaries and commissions expense            110,050          686,650
Contribution margin          165,850
Fixed Expenses:
Advertising expense             33,800
Shipping expense             12,800
Salaries and commissions             29,150
Insurance expense               9,900
Depreciation expense             22,100          107,750
Net operating income            58,100

Related Solutions

Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 9,000 9,500 10,000 Sales $ 945,000 $ 997,500 $ 1,050,000 Cost of goods sold 567,000 598,500 630,000 Gross margin 378,000 399,000 420,000 Selling and...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 4,000 4,500 5,000 Sales $ 400,000 $ 450,000 $ 500,000 Cost of goods sold 240,000 270,000 300,000 Gross margin 160,000 180,000 200,000 Selling and...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 4,000 4,500 5,000 Sales $ 400,000 $ 450,000 $ 500,000 Cost of goods sold 240,000 270,000 300,000 Gross margin 160,000 180,000 200,000 Selling and...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 9,000 9,500 10,000 Sales $ 945,000 $ 997,500 $ 1,050,000 Cost of goods sold 567,000 598,500 630,000 Gross margin 378,000 399,000 420,000 Selling and...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 4,000 4,500 5,000 Sales $ 400,000 $ 450,000 $ 500,000 Cost of goods sold 240,000 270,000 300,000 Gross margin 160,000 180,000 200,000 Selling and...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 7,500 8,000 8,500 Sales $ 712,500 $ 760,000 $ 807,500 Cost of goods sold 427,500 456,000 484,500 Gross margin 285,000 304,000 323,000 Selling and...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of...
Morrisey & Brown, Ltd., of Sydney is a merchandising company that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: Morrisey & Brown, Ltd. Income Statements For the Three Months Ended September 30 July August September Sales in units 4,000 4,500 5,000 Sales $400,000 $450,000 $500,000 Cost of goods sold 240,000 270,000 300,000 Gross margin 160,000 180,000 200,000 Selling and administrative expenses: Advertising...
Morrisey & Brown, Ltd., of Sydney, Australia, is a merchandising firm that is the sole distributor...
Morrisey & Brown, Ltd., of Sydney, Australia, is a merchandising firm that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: MORRISEY & BROWN, LTD. Income Statements For the Four Quarters Ending December 31 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Sales in units 5,100 4,600 5,720 5,200 Sales revenue A$ 510,000 A$ 460,000 A$ 572,000 A$ 520,000 Less: Cost of goods...
Morrisey & Brown, Ltd., of Sydney, Australia, is a merchandising firm that is the sole distributor...
Morrisey & Brown, Ltd., of Sydney, Australia, is a merchandising firm that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: MORRISEY & BROWN, LTD. Income Statements For the Four Quarters Ending December 31 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Sales in units 5,700 5,200 6,440 5,800 Sales revenue A$ 570,000 A$ 520,000 A$ 644,000 A$ 580,000 Less: Cost of goods...
Morrisey & Brown, Ltd., of Sydney, Australia, is a merchandising firm that is the sole distributor...
Morrisey & Brown, Ltd., of Sydney, Australia, is a merchandising firm that is the sole distributor of a product that is increasing in popularity among Australian consumers. The company’s income statements for the three most recent months follow: MORRISEY & BROWN, LTD. Income Statements For the Four Quarters Ending December 31 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Sales in units 5,100 4,600 5,720 5,200 Sales revenue A$ 510,000 A$ 460,000 A$ 572,000 A$ 520,000 Less: Cost of goods...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT