Question: John Doe opened a new Pizza Parlor. His fixed costs for Oven, counters etc is $5000. It costs Joe $8 to make a Medium Pizza.

John Doe opened a new Pizza Parlor. His fixed costs for Oven, counters etc is $5000. It costs Joe $8 to make a Medium Pizza. He is planning to sell it for $18 per Medium Pizza. Create a TABLE showing Total Cost and Total Revenue. Plot both on same chart a. What is the Break-even Quantity? (Show on Graph) b. How many pizzas should Joe sell to make $2000 Profit ? (Show on Graph) c. Due to competition, Joe is planning to drop the price to $15 per medium Pizza. What is the new Break-even? (Hint: Create a new revenue column and plot on same graph)

Use excel please and show work

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!

Please show the steps thank you. Required information Lab 1.1 Alternate: Assessing Profitability of a Mowing Business [The following information applies to the questions displayed below] Lab Insight:...

\f\f\f\f\f\f\f\f\f\fCOMPANY PROFILE Loblaw Companies Limited REFERENCE CODE: D8D0B7F3-D096-423F-845B-2EB571C6948C PUBLICATION DATE: 21 Jul 2015 www.marketline.com COPYRIGHT MARKETLINE. THIS CONTENT...

BUS312 Fall 2020 CASE 2 BAKERS DELIGHT INTRODUCTION Bart Johnson relaxed in his easy chair listening to the waves with his daughter Gina. He loved Jamaican beaches. He loved the smell of the salt and...

Papa John's International, Inc.: Its Strategy in the Pizza Restaurant Industry A. J. Strickland The University of Alabama Christopher Harrington, MBA 2013 The University of Alabama Joyce Meyer The...

How does Hydro One make money? 1. What are the objectives of Hydro One? (profit max, low prices, satisfy engineering constraints, markets, regulators etc?) 2. How does Hydro one make money? (Sources...

Cash Flows From Working It may surprise you that there are cash flows associated with holding a job. Using the examples provided in Chapter 6, construct a simple cash flow statement and payback...

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Question 1 (1 point) Which of the following statements describes Black Fly's process costing system? Question 1 options: Direct materials and direct labour are traced to each specific order. The...

Question : If you were asked to suggest an appropriate global strategy for B&Js at the end of the case, which 3-4 key factors could you identify in detail that would influence B&Js ideal global...

The rate of truck arrivals at a facility is 5 trucks per hour. The duty ratio for dispatching the trucks is 2 trucks per hour. The cost of operating the pier is $ 20 / hr and the cost of...

A newly discovered ionic compound has the formula NzT. The molecular weight of Nz is 43 g/mol and the molecular weight of Tis 76 g/mol. If a 688 ml sample of water contains 0.06 g of NzT, what is the...

A mortgage that is intended to enable older households to "liquify" the equity in their home is the Multiple Choice adjustable rate mortgage ( ARM ) . purchase - money mortgage ( PMM ) . reverse...

What is an example of constructive feedback? provide reference