calculate the total break even point using goal seek

1 3 A B 1 Meyerson's Bakery 2 Projected Income Statement for Pie Line 3 For the Year Ended December 31, 2017 4 2017* 5 Sales 6 Less: Variable Costs 7 Less: Fixed Costs 20,000 8 Earnings Before Interest and Taxes 9 Less: Interest Expense 3,000 10 Earnings Before Taxes 11 Taxes 12 Net Income 13 14 Less: Preferred Dividends 100 15 Net Income Available to Common 16 Common Shares Outstanding 1,000 17 Earnings per Share 18 19 Assumptions 20 Price per pie $ 20.00 21 Unit Sales 3,000 22 Target EBIT 23 Variable Costs as a Percent of Sales 60% 24 Projected Sales Growth 10% 25 Tax Rate 35% 10 11 12 13 3. Calculate total break-even point on "Total BE" tab, using Goal Seek