Home Insert Draw Page Layout Formulas Data>> Tell me G A % > Conditional Formatting Format as Table 2 Cell Styles Clipboard Font Alignment Number Calis Editing 310 fx B C D BKEAN-EVEN POINT AND SELLING PRICE 3 Specialty Steel, Inc. will manufacture and sell 400,000 units next year. Fixed costs will total $350,000, and variable costs will be 70 percent of sales. 1. The firm wants to achieve a level of earnings before interest and taxes of $250,000. What selling price per unit is necessary to achieve this result? 4 b. Set up a pro forma income statement to verify your solution to part (a). Complete the steps below sing cell references to givent data or previous calculations. In some cases, a simple cell reference is all you need. To copypaste a formula across a row or doww a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used the directions will specify the use of that function. Do not ope in merical data into a cell or function, Instead, make a reference to the cell in which the data is found. Make your computations only In the blue cells highlighted below. In all cases, unless otherwise directed, we the earliest appearance 5 of the data in your formulas, sually the Glen Data section 6. DATA 12 Total units 400,000 8 Fixed costs $350,000 9 Variable costs 70% 10 2. The firm wants to achieve a level of earnings before perest and taxes of $250,000. What selling 11 price per unit is necessary to achieve this result? 12 13 EBIT S250.000 14 Total sales 15 Average selling price 10 17 b. Set up a pro forma income statement to verify your solution to part() 20 Tourable costs 21 even before fed cos 27 Totalfixed cost 18