In: Statistics and Probability
Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet:
Input data | |||
fixed cost | 16,000 | Units | 1,050 |
variable cost per unit | 4.75 | 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. Assuming that demand is fixed at 1,050 units, what is the sell price per unit that results in break even?
Enter only the numerical solution. Do
Thank you for providing the data in this format! Very considerate!
The answer is:
sell price per unit | 19.988 |
The data in excel(Actual)
The data in excel(Formulas)
Go to DATA - WHAT IF ANALYSIS - Goal Seek
The input for goal seek:
The output for goal seek:
Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!