Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need requirements 9-11 please. show calculations Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Your
need requirements 9-11 please. show calculations
Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Your answers must be supported with calculations and formulas. No credit will be given for simply placing numbers in the answor blocks. Requirement 9 Use the contribution margin approach to compute the company's annual breakeven in units. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Breakeven in Units 460 Requirement 10 Use the contribution margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA cell(s) in your formula below. Format as a number. Always refor to the original data. Format the rabo as a percent, breakeven in dollars as accounting number format in whole dollars. \begin{tabular}{l|r|} \hline Contribution margin ratio & 36% \\ \hline Breakeven in Dollars & 2,353,361 \\ \hline \end{tabular} Requirement 11 Use the contribusion margin approach to compute the annual sales level (in units) required to eam a target operating income (proft) of $670,000. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Use the Excel ROUNDUP function to obtenin whole units to reach the target operating income. Target sales level (in units) Requirement 12 Step 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