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
Please show how to answer in Excel Problem 4: (10
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!