Miss Ellaneous Bakery is considering the addition of a new line of pies to its product offerings. It is expected that each pie will sell for $17 and the variable costs per pie will be $11. Total fixed operating costs are expected to be $25,000. Miss Ellaneous faces a marginal tax rate of 25%, will have interest expense associated with this line of $3,500, and expects to sell about 4,500 pies in the first year.

a. Create an income statement for the pie lines first year. Is the line expected to be profitable?

b. Calculate the operating break-even point in both units and dollars.

c. How many pies would Miss Ellaneous need to sell in order to achieve EBIT of $20,000?

d. Use the Goal Seek tool to determine the selling price per pie that would allow Miss Ellaneous to break even in terms of its net income.

e. Calculate the DOL, DFL, and DCL for the new pie line.