Copy and paste, or type, the following into cells A1:D5 of anExcel 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. Assumingthat demand is fixed at 1,050 units, what is the sell price perunit that results in break even?
Enter only the numerical solution. Do
