Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
