Problem 5A-7 Cost Behavior; High-Low Method; Contribution FormatIncome Statement [LO5-10]Morrisey & Brown, Ltd., of...Problem...

Free

50.1K

Verified Solution

Question

Accounting

Problem 5A-7 Cost Behavior; High-Low Method; Contribution FormatIncome Statement [LO5-10]

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

Morrisey & Brown, Ltd.
Income Statements
For the Three Months Ended September 30
JulyAugustSeptember
Sales in units8,5009,0009,500
Sales$850,000$900,000$950,000
Cost of goodssold510,000540,000570,000
Grossmargin340,000360,000380,000
Selling andadministrative expenses:
Advertisingexpense37,00037,00037,000
Shippingexpense110,000115,600121,200
Salaries andcommissions155,000162,800170,600
Insuranceexpense10,50010,50010,500
Depreciationexpense17,00017,00017,000
Total sellingand administrative expenses329,500342,900356,300
Net operatingincome$10,500$17,100$23,700

Required:

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

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

3. Redo the company’s income statement at the 9,500-unit levelof activity using the contribution format.

Answer & Explanation Solved by verified expert
4.2 Ratings (874 Votes)

1. Classification of   cost/ Expense
Cost Cost Behavior
Cost of Goods Sold Variable
Advertising Expense Fixed
Shipping Expense Mixed
Salaries and Commissions Mixed
Insurance Expense Fixed
Depreciation Expense Fixed
2. Seperation of Mixed Expense into Variable and Fixed Expense
Shipping Expense Salaries and Commission
High $1,21,200 $1,70,600
Low $1,10,000 $1,55,000
Difference in Cost $11,200 $15,600
Difference in Sales Volume 1,000 units 1,000 units
Variable Cost per Unit $11 $16
Fixed Cost per month $14,800 $22,400
(110000-(8500*$11.2) (155000-(8500*$15.6)
Morrissey and Brown Ltd.
Contribution Margin Income Statement
Activity Level : 9500 units
Sales Revenue $9,50,000
Less Variable Costs:
Cost of Goods Sold $5,70,000
Shipping Expense ( 9500 x $11.20) $1,06,400
Salaries and Commissions ( 9500 x $15.60) $1,48,200 $8,24,600
Contribution Margin $1,25,400
Less: Fixed Cost
Advertising $37,000
Insurance $10,500
Shipping $14,800
Salaries and Commissions $22,400
Depreciation $17,000
Total Fixed Costs $1,01,700
Net Operating Income $23,700

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

In: AccountingProblem 5A-7 Cost Behavior; High-Low Method; Contribution FormatIncome Statement [LO5-10]Morrisey & Brown, Ltd., of...Problem 5A-7 Cost Behavior; High-Low Method; Contribution FormatIncome Statement [LO5-10]Morrisey & Brown, Ltd., of Sydney is a merchandising companythat is the sole distributor of a product that is increasing inpopularity among Australian consumers. The company’s incomestatements for the three most recent months follow:Morrisey & Brown, Ltd.Income StatementsFor the Three Months Ended September 30JulyAugustSeptemberSales in units8,5009,0009,500Sales$850,000$900,000$950,000Cost of goodssold510,000540,000570,000Grossmargin340,000360,000380,000Selling andadministrative expenses:Advertisingexpense37,00037,00037,000Shippingexpense110,000115,600121,200Salaries andcommissions155,000162,800170,600Insuranceexpense10,50010,50010,500Depreciationexpense17,00017,00017,000Total sellingand administrative expenses329,500342,900356,300Net operatingincome$10,500$17,100$23,700Required:1. By analyzing the data from the company's income statements,classify each of its expenses (including cost of goods sold) aseither variable, fixed, or mixed.2. Using the high-low method, separate each mixed expense intovariable and fixed elements. Express the variable and fixedportions of each mixed expense in the form Y = a + bX.3. Redo the company’s income statement at the 9,500-unit levelof activity using the contribution format.

Other questions asked by students