Question: Please show how to answer in Excel Problem 4: (10 points] A Pizza restaurant is considering a new oven in which to bake the firm's
Please show how to answer in Excel
Problem 4: (10 points] A Pizza restaurant 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 $20,000 and the variable costs are $2.00 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.25 per pizza. The pizzas sell for $14 each. A) What is the break-even point for each oven? [4 points) B) If the owner expects to sell 9.000 pizzas, which oven should she purchase and why? [2 points) C) At what volume should Janelle switch ovens? [2 points] D) If the owner expects to sell 15.000 pizzas, which oven should she purchase and why? [2 points)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
