Using the goal seek tool determine the selling price per yogurt that would allow Frankie's frozen yogurt to break even in terms of net income?
| Frankie's Frozen Yogurt's |
| Projected Income Statement for Greek Yogurt Line |
|
|
| Sales |
$20,400 |
| Variable Costs |
3,400 |
| Fixed Costs |
15,000 |
| Earnings Before Interest and Taxes |
2,000 |
| Interest Expense |
2,000 |
| Earnings Before Taxes |
- |
| Taxes |
- |
| Net Income |
- |
|
|
| Additional Data |
|
| Estimated Pie Sales in Units |
3,400 |
| Price per Pie |
$6 |
| Variable Cost per Pie |
$1 |
| Tax Rate |
35% |
|
|
| Operating Break-even Points |
|
| Units |
3,000.00 |
| Dollars |
$ 18,000.00 |
|
|
| Target Level of EBIT |
$20,000 |
| Unit Sales Needed to Reach Target EBIT |
7,000 |
What the actual formula is without using goal seek.