Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet: Input data fixed cost 18,000 Units 1,000 variable cost per unit
Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet:
Input data | |||
fixed cost | 18,000 | Units | 1,000 |
variable cost per unit | 3.00 | revenue | =D2*B4 |
sell price per unit | 6.5 | expenses | =B2+(B3*D2) |
profit | =D3-D4 |
Use Excel's Goal Seek to answer the following question. With a demand of 1,000 units, what is the sell price per unit that results in break even?
Enter only the numerical solution. Do not include a $ sign.
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