Answer using Excel***

Janelle Heinke, the owner of Ha'Peppas!, is considering a new oven in which to bake the firm's signature dish, vegetarian pizza. Oven type A can handle 20 pizzas an hour. The fixed costs associated with oven A are $22,000 and the variable costs are $2.20 per pizza. Oven B is larger and can handle 40 pizzas an hour. The fixed costs associated with oven B are $30,000 and the variable costs are $1.45 per pizza. The pizzas sell for $15 each. 1. (5 points) What is the break-even point for each oven? 2. (5 points) If the owner expects to sell 2,000 pizzas, which oven should she purchase? 3. (5 points) At what volume should Janelle switch ovens? 4. 5 points bonus If you solve the question using Excel OM