b) Create a one-way data table of Sales Units vs. Net Income. Start sales units at 20,000 and end at 30,000, and increase in increments of 1,000. You may have to extend beyond 30,000 to get to break-even. If you need to, please extend 2 increments beyond the breakeven point. D E F H Assumptions Sales Units Unit Price COGS% 20000 50 0.5 Var. Cost%= Fixed Costa Interest Expense- Tax Rates 1 Typical Income Statment for Manufacturing Buisness 2 3 4 Revenue 1,000,000 .....(a) 5 COGS 500,000 (b) 6 Gross Profit 500,000 7 8 Vairable Cost 150,000 .....(c) 9 Fixed Cost 200,000 10 Operating Expenses 350,000 11 12 Net Operating income 150,000 13 14 Interest Expense 25,000 15 16 Earnings Before Taxes (EBT) 125,000 17 18 Taxes 42,500 .....(d) 19 20 Net Income 82,500 21 22 23 24 25 0.15 200000 25000 0.34 (EBT > 7 Step 3 0.23 (0