Question: 1.) Set up the following cell entries in Excel: Variable cost/unit $1.5 Fixed cost $90 Selling price/unit $3 Number of units 60 Assuming that the

1.) Set up the following cell entries in Excel:

Variable cost/unit

$1.5

Fixed cost

$90

Selling price/unit

Number of units

Assuming that the number of units to be sold is fixed and is 60. Current selling price is $3 and subject to change.

Using Goal Seek, what should the selling price per unit be in order to realize a breakeven amount of $200?Please explain how to get this with every step

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 Accounting Questions!

S&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments...

Set up the following cell entries in Excel: Variable cost/unit $1.5 Fixed Cost $90 Selling price/unit $3 Breakeven (units) Breakeven in dollars ($) Using Goal Seek, what should the selling price per...

instructions and 3 excel sheets are attached Wine Depot Ch 07-07 Present Value Analysis Annuity payment required: Future need: Term (in years): Interest rate: Investment value in future: Current...

Can someone help me with these problems? File Home Insert Draw Page Layout Formulas Data Review View Developer Help Power Pivot Share X Arial 12 AI ab General $ %) Conditional Formatting Format as...

I understand most of this project but I am having a difficult time with Projected Income Statement at the end of this project. I am in hope that someone could help me out. Thank you! I understand...

Managerial Accounting Can anyone Help me with these, and include the calculations in order for me not to hardcode the numbers because I need to use the excel formulas . Thank you Project #2 Sales...

On the data sheet of the attached document, I cannot figure out how to determine "Projected Sales Price/Unit." How do I do this? Thank you. Project #2 - Budgeting Learning Objectives: 1) Provide a...

Project #2 - Budgeting Learning Objectives: 1) Provide a comprehensive budgeting experience. 2) Exhibit the use of Excel in creating a master budget. Learning Outcomes: 1) Understanding of the...

On the data sheet of the attached document, I cannot figure out how to determine "Projected Sales Price/Unit." How do I do this? Thank you. Project #2 - Budgeting Learning Objectives: 1) Provide a...

Hi. I need Chapter 11 part 1-4 Let me know. Thanks! (it wont letme add more than $8, but I will give $12+ tip) Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK...

I can't do this project. Is there any way I can get the answers to it with your help Project #2 - Budgeting Learning Objectives: 1) Provide a comprehensive budgeting experience. 2) Exhibit the use of...

Weather forecasters know they are making future predictions based only on past and present observations. What if a colleague told you that an investment in that new startup was a sure thing?

Which cost is greater: replacement cost or actual cash value? Why?

For the ODE given below, state the order of the equation and whether or not it is linear. x 7 d 2 ydx 2 8 y + 7 x = 0 Order: linear nonlinear If linear, is it homogeneous? homogeneous non -...

After you use a text editor to write a program, will it be in main memory or auxiliary memory?

The following information is available for the preparation of the government-wide financial statements for the City of Northern Pines for the year ended June 30, 2020: From the previous information,...

A random variable Z is defined as Z = X + Y where X and Y are Gaussian with the following statistics: 1. E[X] = 2, E[Y] = -3 2. X = 2, Y = 3, 3. XY = 0.5

Heat treating is often used to carbonize metal parts, such as gears. The thickness of the carbonized layer is a critical output variable from this process, and it is usually measured by performing a...

In a microwave oven, electrons describe circular motion in a magnetic field within a special tube called a magnetron; the electrons motion results in the production of microwaves. (a) If the...

Let Q be the optimal order quantity, and Q is an order quantity that differs from Q by Q units. A value of Q=Q+Q would result in a higher average annual cost than a value of Q=QQ True False

8. Give an example of how the scarcity principle can be used to influence others.

2. A Soviet invasion of Poland would lead to the severing of diplomatic relations between the United States and the Soviet Union.

1. Diplomatic relations between the United States and the Soviet Union would be severed in 1993 than that