Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please complete the table for requirement 3. All additional details provided. The contribution margin income statement of Awesome Coffee for February follows: K (Click the
Please complete the table for requirement 3. All additional details provided.
The contribution margin income statement of Awesome Coffee for February follows: K (Click the icon to view the contribution margin income statement.) Awesome Coffee sells three small coffees for every large coffee. A small coffee sells for $3.00, with a variable expense of $1.50. A large coffee sells for $5.00, with a variable expense of $2.50. Requirements 1. Determine Awesome Coffee's monthly break-even point in numbers of small coffees and large coffees. Prove your answer by preparing a summary contribution margin income statement at the break-even level of sales. Show only two categories of expenses: variable and fixed. 2. Compute Awesome Coffee's margin of safety in dollars. 3. Use Awesome Coffee's operating leverage factor to determine its new operating income if sales volume increases 15%. Prove your results using the contribution margin income statement format. Assume the sales mix remains unchanged.Data table -X lar Awesome Coffee par Contribution Margin Income Statement For the Month Ended February 29 bur Sales revenue $ 88,000 Variable expenses: Cost of goods sold $ 30,000 Marketing expense 8,000 General and administrative expense 2,000 40,000 15% Contribution margin 48,000 Fixed expenses: Marketing expense 34,650 General and administrative expense 7,350 42,000 $ 6,000 Operating income sure toRequirement 1. Determine Awesome Coffee's monthly break-even point in numbers of small coffees and large coffees. Begin by identifying the formula to compute the total break-even point in units. Fixed expenses + Operating income ) / Weighed-avg. CM per unit = Break-even sales in units Now calculate the weighted-average contribution margin per unit. (Round the weighted-average contribution margin per unit to the nearest cent.) Small Large Total Sales price per unit EA 3.00 $ 5.00 Less: Variable expense per unit (1.50) (2.50) Contribution margin per unit $ 1.50 $ 2.50 Sales mix in units 3 4 $ 4.50 $ 2.50 $ 7.00 Contribution margin $ 1.75 Weighted-average contribution margin per unit The break-even point is 18,000 small cups and 6,000 large cups of coffee.Prepare a summary contribution margin income statement to prove your answer above. (For amounts with a zero balance, make sure to enter "0" in the appropriate cell.) Small Large Total Sales revenue $ 54,000 $ 30,000 $ 84,000 Less: Variable expenses (27,000) (15,000) (42,000) Contribution margin $ 27,000 $ 15,000 42,000 Less: Fixed expenses (42,000) Operating income $ 0 Requirement 2. Compute Awesome Coffee's margin of safety in dollars. Identify the formula to compute the margin of safety in dollars. Sales Break-even sales in dollars = Margin of safety in dollars The margin of safety in dollars is $ 4000. . . Requirement 3. Use Awesome Coffee's operating leverage factor to determine its new operating income if sales volume increases 15%. Prove your results using the contribution margin income statement format. Assume the sales mix remains unchanged. Identify the formula to compute the operating leverage factor. Contribution margin Operating income = Operating leverage factor Awesome Coffee's operating leverage factor is 8 . (Round your answer to two decimal places.) If Awesome Coffee can increase sales revenue by 15%, keeping the sales mix the same, operating income will be $ 13200 . Prepare a summary contribution margin income statement to prove your answer above. (For amounts with a zero balance, make sure to enter "0" in the appropriate cell.) Awesome Coffee Effect on Operating Income of 15% Increase in Sales Volume Current level Percent increase Dollar increase Sales revenue 15% Less: Variable expenses 15% Contribution margin Change in fixed expenses Operating income before sales increase Operating income after sales increaseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started