Question: Copy and paste, or type, the following into cells A 1 :D 5 of an Excel spreadsheet: table [ [ Input data,,, ] ,

Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet:
\table[[Input data,,,],[fixed cost,25,000,Units,1,950],[variable cost per unit,4.80,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,950 units, what is the sell price per unit that results in break even?
Enter only the numerical solution. Do not include a $ sign.
Your Answer:
Answer
 Copy and paste, or type, the following into cells A1:D5 of

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 General Management Questions!