Question
Open the Excel file and go to the Template tab . 1. Using Goal Seek: a. Calculate the unit sales required to break even. b.
Open the Excel file and go to the Template tab.
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 companys 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
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