Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help and explain how to do the steps to get the answer :) 1. Using Goal Seek: a. Calculate the unit sales required to

please help and explain how to do the steps to get the answer :) image text in transcribed
image text in transcribed
image text in transcribed
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%. Please enter the answers for part 1 and 2 on Answers Tab A B c. D E. G. H Donaldson Company \begin{tabular}{|c|c|c|} \hline & Doto inputs: & \\ \hline & Unit sales & 40,000 \\ \hline & Selling price per unit & 1750 \\ \hline & Variable expense per unit & 7.50 \\ \hline & Iotal fixed expenses & $180,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|l|}{9} \\ \hline 10 & \multicolumn{5}{|c|}{ Contribution Format Income Statement } & \\ \hline 11 & & Total & Per Unit & \& & & \\ \hline 12 & Saies & $500,000 & 1250 & 100% & & \\ \hline 13 & Variable eapenses & 300,000 & 750 & 60% & & \\ \hline 14 & Contribution matgin & 200,000 & 500 & 40S & & \\ \hline 15 & Foned expenses & 180,000 & & & & \\ \hline 76 & Net operating income & $20,000 & & & & \\ \hline 17 & & & & & & \\ \hline 18 & Net profit margin percentage & 4.00% & & & & \\ \hline 19 & & & & & & \\ \hline 20 & CVP Graph Information & & & & & \\ \hline 21] & Selling price per unit & $1250 & & & & \\ \hline 22 & Variable expense per unit & 5750 & & & & \\ \hline 23 & Total fixed expenses & $180,000 & & & & \\ \hline 24 & & & & & & \\ \hline 25 & CVP Graph Toble & Units & Vorlable txpenses & Fixed Expenses & Total Expenses & Sales dollara \\ \hline 26 & & 4 & & & & \\ \hline 27 & & 5,000 & & & & \\ \hline 28 & & 10,000 & & & & \\ \hline 29 & & 15,000 & & & & \\ \hline 30 & & 20,000 & & & & \\ \hline 31 & & 25.000 & & & & \\ \hline 32 & & 30,000 & & & & \\ \hline 33 & & 35,000 & & & & \\ \hline 34 & & 40,000 & & & & \\ \hline 35 & & 45,000 & & & & \\ \hline 36 & * & 50.000 & & & & \\ \hline \end{tabular} \begin{tabular}{|l|lr|} \hline \multicolumn{3}{|c|}{ Margin of Safety } \\ \hline Actual sales (a) & 5 & 500,000 \\ \hline Break-even sales (b) & 5 & 450,000 \\ \hline Margin of safety in dollars (a) - (b) & 5 & 50,000 \\ \hline Margin of safety percentage & & 10,00% \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2 & GOA & AL SEEK ANSWERS & \\ \hline 3 & 1a. & Unit sales required to break even & units \\ \hline 4 & 1-b. & Unitsalesrequiredtoattainatargetprofitof$25,000 & units \\ \hline 5 & & Company's margin of safety (dollars) & \\ \hline 6 & 1-c. & Sellingpriceperunitrequiredtoattainnetoperatingincomeof$30,000 & \\ \hline 7 & 1-d. & Variableexpenseperunitrequiredtoattainnetoperatingincomeof$30,000 & \\ \hline 8 & 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}

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_2

Step: 3

blur-text-image_3

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

Auditing The Art and Science of Assurance Engagements

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Joanne C. Jones

13th Canadian edition

133405508, 978-0133405507

More Books

Students also viewed these Accounting questions