pre units are sold, the total varia produced Goal Seek D ? Set cell: To value:...

Transcribed Image Text:

pre units are sold, the total varia produced Goal Seek D ? Set cell: To value: By changing cell: unit per unit OK Cancel Chapter 7 O 1. 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 line's 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. ariable cost/unit sales Gool Seek=It's a great tool f you're not sure how to get here. e. Calculate the DOL, DFL, and DCL for the new pie line. pre units are sold, the total varia produced Goal Seek D ? Set cell: To value: By changing cell: unit per unit OK Cancel Chapter 7 O 1. 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 line's 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. ariable cost/unit sales Gool Seek=It's a great tool f you're not sure how to get here. e. Calculate the DOL, DFL, and DCL for the new pie line.