Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need requirements 12-15 please. show calculations i need requirements 12-15 please with calculations. this is all the information. Autosave Oof M Open recovered workbooks? Your

need requirements 12-15 please. show calculations
image text in transcribed
image text in transcribed
i need requirements 12-15 please with calculations. this is all the information.
image text in transcribed
image text in transcribed
image text in transcribed
Autosave Oof M 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 cell(s) in your formula below. Format as a number. Always tefer 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,361 \\ \hline \end{tabular} Requirement 11 Use the contribution margin approach to computh the annuat sales level (in units) required to eam a target operating income (pro5t) 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 obiain whole units to reach the target operasing income. Open tecovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 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 11begivenforsimplyplacingnum 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 Use the contribution margin raso approach to compute the breakeven point in sales dollars. Reference the DATA cell(s) in your formula below. Format as a number. Always refer to the original data. Format the rato 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 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 formula below. Format as a number. Aways tefer to the original data Use the Excel ROUNDUP function to obtain whole units to reach the target operating income. Target sales level (in units) 824 Requirement 12 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? 3) Comprehensive Project 1 Template v1 Requirement 11 Use the contribuson margin approach to compute the annual sales level (in units) required to eam a target operating income (profit) of $670,000. Reference the DATA cell(s) in your formula below. Format as a number. Aways refer to the original data. Use the Excel ROUNDUP function to obtain whole units to reach the target operating income. Home Insert Draw Page Layout Formulas Data Review view P. Tell me Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you loft off

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

Recommended Textbook for

More Books

Students also viewed these Accounting questions