Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10 points Save Answer Tommy Pizza: BEA: Tommy Pizza Restaurant specializes on its Mediterranean Style pizzas. The company wants to determine how many pizzas it

image text in transcribed
image text in transcribed
10 points Save Answer Tommy Pizza: BEA: Tommy Pizza Restaurant specializes on its Mediterranean Style pizzas. The company wants to determine how many pizzas it needs to sell per year to break even (.e. achieving a zero profit when total cost equals total revenue). The Excel spreadsheet named "Tommy_BEA" provides details of the unit price (Cell C3), unit cost (Cell C4), and fixed cost (Cell C6) of the production. Using the "Goal Seek" feature in Excel, find the demand that will enable the company to break even. Enter the break- even demand in the nearby box (enter numeric digit(s) with no decimal place; round your answer to the nearest integer as needed; do not use any comma, space or other unnecessary symbols). D E A B C 1 Tommy Pizza: Break Even Analysis 2. 3 $8.00 $5.50 4 5 6 5 Unit Price Unit Cost Demand Fixed Cost Variable Cost Revenue Profit $4,600.00 7 8 9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Connect For Computer Accounting With Quickbooks Online

Authors: Donna Kay

2nd Edition

1264152272, 9781264152278

More Books

Students also viewed these Accounting questions

Question

Explain how to control impulses.

Answered: 1 week ago

Question

Assess the requirements for strategic LMD

Answered: 1 week ago

Question

How can e-learning benefit organizations and individuals?

Answered: 1 week ago