Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need requirements 15-17 please. show calculations Autosave Oof A Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you

need requirements 15-17 please. show calculations
image text in transcribed
image text in transcribed
image text in transcribed
Autosave Oof A 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 answer 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 Requirement 10 Use the contribusion margin ratio approach to compute the breakeven point in sales dollars. Reference the DATA coll(s) in your formula below. Format as a number. Always refer to the original data. Format the ratio as a percent, breakeven in dollars as accounting number format in whole dollars. \begin{tabular}{|l|r|} \hline Contrbution margin ratio & 36% \\ \hline Breakeven in Dollars & 2.353,3.61 \\ \hline \end{tabular} Requirement 11 Use the contribution margin approach to compute the annual sales level (in units) required to eam a target operating income (prost) of $670,000 Reference the DATA cell(s) in your tormula below. Format as a number. Always refer to the original data. Use the Excel RoUNDUP function to oblain whole units to reach the target operating income. Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Requirement 15 Use the contribution margin approach to compute the change in net operating income if the sales increase by 6% and advertising spending is increased by $6,000. Renterence the DATA celli(s) in your formuta below. Format as a number. Aways refer to the original data. Use the Excel ROUNDUP hunction to obtain whole units or dollars New Operatng income change in Operating income is increasing adversing spending a good idea? Requirement 16 Use the contribution margin appronch to calculate margin of safety in dolians, as a percent and in units. Reference the DATA cell(0) in your fomula below. Format as a number. Aways refer to the eriginal data Use the Excel ROUNDUP function to obtain whole units or dollars Requirement 17 Use the contribusion margin approach to calculase operasing leverage. What is the eatmated percent increase in net incorne if sales Incieast 15\%? What is the New Ooeratina hcome? Reference the DATA celi(s) in your forrivia below. Format as a namber. Aways feter to the original data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Paid cash for supplies, $ 5 0 0

Answered: 1 week ago

Question

Explain the pages in white the expert taxes

Answered: 1 week ago