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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!