Calculate the weighted-average contribution margin. Determine Sugar Donuts' monthly breakeven point in dozens of plain donuts and custard-filled donuts. Compute Sugar Donuts' margin of safety in dollars for August 2024. Compute the degree of operating leverage for Sugar Donuts. Estimate the new operating income if total sales increase by 30%. (Round the degree of operating leverage to four decimal places and the final answer to the nearest dollar Arume the col
Calculate the weighted-average contribution margin. Determine Sugar Donuts' monthly breakeven point in dozens of plain donuts and custard-filled donuts. Compute Sugar Donuts' margin of safety in dollars for August 2024. Compute the degree of operating leverage for Sugar Donuts. Estimate the new operating income if total sales increase by 30%. (Round the degree of operating leverage to four decimal places and the final answer to the nearest dollar Arume the col
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
Please respond to my question using an excel worksheet as I’m trying to learn how to use excel.
![Net Sales Revenue
Variable Costs:
Cost of Goods Sold
Selling Costs
Administrative Costs
Contribution Margin
Fixed Costs:
Selling Costs
Administrative Costs
Operating Income
SUGAR DONUTS
Contribution Margin Income Statement
Month Ended August 31, 2024
$32,100
17,400
6,750
24,750
8,250
$125,000
56,250
68,750
000
$ 35,750
Sugar Donuts sells three dozen plain donuts for every dozen custard-filled donut. A dozen plain donuts
sell for $4.00, with a total variable cost of $1.80 per dozen. A dozen custard-filled donuts sells for $8.00,
with a total variable cost of $3.60 per dozen.
Requirements:
*Create an excel sheet for each requirement in the project within one excel document.
OR
*Create a word document and label each section with the requirement number in the project.
1. Calculate the weighted-average contribution margin.
2. Determine Sugar Donuts' monthly breakeven point in dozens of plain donuts and custard-filled
donuts.
3. Compute Sugar Donuts' margin of safety in dollars for August 2024.
4. Compute the degree of operating leverage for Sugar Donuts. Estimate the new operating
income if total sales increase by 30%. (Round the degree of operating leverage to four decimal
places and the final answer to the nearest dollar. Assume the sales mix remains unchanged.)
5. Prove your answer to Requirement 4 by preparing a contribution margin income statement with
a 30% increase in total sales. (The sales mix remains unchanged.)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F342619bb-da07-4dfb-b71d-16abe5209672%2F58d5fa9c-2fe7-446f-a5d8-9d9c5197e288%2F3if1gc_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Net Sales Revenue
Variable Costs:
Cost of Goods Sold
Selling Costs
Administrative Costs
Contribution Margin
Fixed Costs:
Selling Costs
Administrative Costs
Operating Income
SUGAR DONUTS
Contribution Margin Income Statement
Month Ended August 31, 2024
$32,100
17,400
6,750
24,750
8,250
$125,000
56,250
68,750
000
$ 35,750
Sugar Donuts sells three dozen plain donuts for every dozen custard-filled donut. A dozen plain donuts
sell for $4.00, with a total variable cost of $1.80 per dozen. A dozen custard-filled donuts sells for $8.00,
with a total variable cost of $3.60 per dozen.
Requirements:
*Create an excel sheet for each requirement in the project within one excel document.
OR
*Create a word document and label each section with the requirement number in the project.
1. Calculate the weighted-average contribution margin.
2. Determine Sugar Donuts' monthly breakeven point in dozens of plain donuts and custard-filled
donuts.
3. Compute Sugar Donuts' margin of safety in dollars for August 2024.
4. Compute the degree of operating leverage for Sugar Donuts. Estimate the new operating
income if total sales increase by 30%. (Round the degree of operating leverage to four decimal
places and the final answer to the nearest dollar. Assume the sales mix remains unchanged.)
5. Prove your answer to Requirement 4 by preparing a contribution margin income statement with
a 30% increase in total sales. (The sales mix remains unchanged.)
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education