Question

In: Accounting

P7-66A CVP analysis at a multiproduct firm ( Learning objective 4 & 5) The contribution margin...

P7-66A CVP analysis at a multiproduct firm ( Learning objective 4 & 5)
The contribution margin income statement of Morgantown Coffe for October follows:

Morgan Coffee

Contribution Margin Income Statement

Month Ended October 31

Sales revenue
$      95,000
Less variable expense:
Cost of goods sold
$      33,500
Marketing expense
$      12,000
General administrative expense
$         2,000
$      47,500
Contribution margin
$      47,500
Less fixed expenses
Marketing expense
$      19,125
General administrative expense
$         3,375
$      22,500
Operating income
$      25,000
Morgantown Coffe sells three small coffees for every large coffee.
A small coffee sells for $2.00, with a variable expense of $1.00.
A large coffee sells for $4.00, with a variable expense of $2.00.
Requirements
1. Determine the coffee shop's monthly breakeven point in the numbers of small coffees amd large coffees.
Prove your answer by preparing a summary contribution margin income statement at the breakeven level of sales.
Show only two categories of expenses: Variable and fixed.
2. Compute the coffee shop's margin of safety in dollars.
3 Use the coffee shop's operating leverage factor (using the October contributionmargin income statement) to
determine its new operating income if sales volume increases 13%. Prove your results
using th contribution margin income statement format. Assume that sales mix remains unchanged.

Solutions

Expert Solution

Req 1:
Contribution margin per unit of Small coffee: $ 2.00 -1.00 = $ 1.00 per unit
Contrbution margin per unit of large coffee: $ 4.00 -2.00 =$2.00 per unit
Sales mix is 3:1 of Small and large coffee
Contribution margin of Sales mix: 3 units @1+ 1 unit @2$2 = $5 per sales mix.
Break even point in terms of sales mix: Fixed cost / Contribution margin per sales mix
(22500 /5 ) = 4500 sales mix
To be break even point, Number of units of Small coffee:4500*3 = 13500 units
Number of units of large units: 4500*1 = 4500 units
Req 2:
Contrbution= $ 47500
Sales: $ 95,000
CM ratio: Contribution/ Sales *100 = 47500 /95000 *100 = 50%
Net Income: $ 25000
Margin of safety in $= Net income/ CM ratio = $25000 /50% = $50,000
Req 3:
Degree of Opeerating leverage: Contribution/ Net income = 47500/25000 =1.9
Now, if sales revenue increase by 13%
Net income increase by 24.7% (i.e. 13%*1.9)
CONTRIBUTION MARGIN INCOME STATEMENT:
Sales revenue (95000+13%) 107350
Less: Variable ccost (47500+13%) 53675
Contribution margin   53675
Less: Fixed cost 22500
Net income    31175
Less: original income 25000
Increase in income 6175
% increase in income 24.70%

Related Solutions

Learning objective: This project is designed for you to compute contribution margin, and conduct breakeven and...
Learning objective: This project is designed for you to compute contribution margin, and conduct breakeven and what-if analyses by using Excel spreadsheets. Requirements: Please complete the calculations for the following problem in Excel spreadsheets. You can use Project 1 Format.xlsx to work on the project. A lot formulae are inserted in the comments of the spreadsheet file for your reference. Setting the formulae by referencing to the data in Excel spreadsheets is required. Problem set A computer store has sale...
In CVP analysis, gross margin is a less-useful concept than contribution margin." Do you agree? Explain....
In CVP analysis, gross margin is a less-useful concept than contribution margin." Do you agree? Explain. Q2: When might a company use budgeted costs rather than actual costs to compute direct-labor rates?
Problem 5-22 (Algo) CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5,...
Problem 5-22 (Algo) CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,100 units × $20 per unit) $ 262,000 Variable expenses 157,200 Contribution margin 104,800 Fixed expenses 116,800 Net operating loss $ (12,000 ) Required: 1....
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6]...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,500 units × $20 per unit) $ 270,000 Variable expenses 162,000 Contribution margin 108,000 Fixed expenses 120,000 Net operating loss $ (12,000 ) Required: 1. Compute...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6]...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,200 units × $20 per unit) $ 264,000 Variable expenses 158,400 Contribution margin 105,600 Fixed expenses 117,600 Net operating loss $ (12,000 ) Required: 1. Compute...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6]...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (12,700 units × $20 per unit) $ 254,000 Variable expenses 152,400 Contribution margin 101,600 Fixed expenses 113,600 Net operating loss $ (12,000 ) Required: 1. Compute...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6]...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (12,500 units × $30 per unit) $ 375,000 Variable expenses 225,000 Contribution margin 150,000 Fixed expenses 168,000 Net operating loss $ (18,000 ) Required: 1. Compute...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6]...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,300 units × $20 per unit) $ 266,000 Variable expenses 159,600 Contribution margin 106,400 Fixed expenses 118,400 Net operating loss $ (12,000 ) Required: 1. Compute...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6]...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,400 units × $20 per unit) $ 268,000 Variable expenses 160,800 Contribution margin 107,200 Fixed expenses 119,200 Net operating loss $ (12,000 ) Required: 1. Compute...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6]...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,400 units × $30 per unit) $ 402,000 Variable expenses 241,200 Contribution margin 160,800 Fixed expenses 178,800 Net operating loss $ (18,000 ) Required: 1. Compute...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT