70.2K

Verified Solution

Link Copied!

please help :)

1. Using Goal Seek: a. Calculate the unit sales required to break even. b. Calculate the unit sales required to attain a target profit of $25,000. What would be the company's margin of safety (in dollars) at this level of sales? c. Calculate the selling price per unit required to attain net operating income of $30,000. d. Calculate the variable expense per unit required to attain net operating income of $30,000. e. Calculate the unit sales required to attain a margin of safety of $75,000. 2. Using Solver: a. Calculate the unit sales required to attain a margin of safety percentage of 15%. b. Restore the original values in your Excel file. Calculate the unit sales required to attain a profit margin of 8%. c. Restore the original values in your Excel file. Calculate the selling price per unit required to attain a profit margin of 10%. d. Restore the original values in your Excel file. Calculate the variable expense per unit required to attain a profit margin of 6%. GOAL SEEK ANSWERS \begin{tabular}{|l|l|l|} \hline 1-a. & Unit sales required to break even & units \\ \hline 1-b. & Unitsalesrequiredtoattainatargetprofitof$25,000 & units \\ \hline Company's margin of safety (dollars) & Sellingpriceperunitrequiredtoattainnetoperatingincomeof$30,000 & Variableexpenseperunitrequiredtoattainnetoperatingincomeof$30,000 \\ \hline 1-e. & Unitsalesrequiredtoattainamarginofsafetyof$75,000 & units \\ \hline \end{tabular} SOLVER ANSWERS \begin{tabular}{|l|l|l|} \hline 2-a. & Unitsalesrequiredtoattainamarginofsafetypercentageof15% & units \\ \hline 2-b & Unitsalesrequiredtoattainaprofitmarginof8% & units \\ \hline 2-c & sellingpriceperunitrequiredtoattainaprofitmarginof10% & \\ \hline 2-d & Variableexpenseperunitrequiredtoattainaprofitmarginof6% & \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer