Page Layout Formulas Data Revi N124 far D E B C Given Data Below Complete Columns E, F, G and H F G H . Also calculate Break Even Units for Columns B, E,F,G and H Base Decrease increase Increase increase 110% 110% 20% si 7 Sales Units 750,000 3 3 Sale Price S50 0 1 Revenue 537.500.000 12 13 Expenses 14 Salaries $2,500,000 Fixed 15 Salaries $11,250,000 Variable 16 Benefits $3,162,500 % of Salaries 7 Supplies S650,000 Fixed 18 Supplies $5,625,000 Variable 19 Other $150,000 Fixed 20 Other $1,875,000 Varable 21 Depreciation $7,500,000 See Note Below 22 Deprecition See Note Below 22 Interest $2,500,000 See Note Below 24 interest See Note Below 25 Total Expenses $35 212.500 26 27. Profit Before Taxe $2.287.500 20 29 Taxes 25% $571,875 30 31 Profit After Tax $1,715,625 32 33 34 Break Even Units 55 35 37 sa Depreciation for each 10% increase in sales units Depreciation increase by 5 39 No retirement of assets 40 41 Interest for each 15% increase in sales units an increase of $750,000 of interest expense, no retirement 42 43 44 15 45 47 18 49 0 1 Capital Budget Income Projection Ready