Question: Help please USE EXCEL TO DO THE CALCULATIONS Based on the following information, Selling Price per Unit 90.00 Variable cost per unit 30.00 Fixed costs

Help please

USE EXCEL TO DO THE CALCULATIONS Based on the following information, Selling Price per Unit 90.00 Variable cost per unit 30.00 Fixed costs 240,000 A. Calculate the break-even in units B. Calculate the break-even in dollars C. How many units must the company sell to earn a profit of $30,000

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!

Based on the following information, Selling Price per Unit 150.00 Variable cost per unit 80.00 Fixed costs 280,000 A. Calculate the break-even in units 4,000.00 B. Calculate the break-even in dollars...

Based on the following information, Selling Price per Unit 150.00 Variable cost per unit 80.00 Fixed costs 280,000 A. Calculate the break-even in units B. Calculate the break-even in dollars C. How...

Question 3 (20%) Given the following information: Selling Price (per unit): $10,000 Contribution Margin (per unit): $3,000 Fixed Costs: $200,000 Required Each of these are separate situations: A....

Question 1 A company has the following financial information: year Labour (in hours) machine costs (in $) 2009 1,200 103,266 2010 1,225 110,216 2011 1,100 97,579 2012 1,050 94,581 2013 1,160 111,762...

Question 2 Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs: $200,000 Required - Cost-Volume-Profit (CVP) Each of these are separate...

Emeka Company has provided the following information: Sales price per unit $42 Variable cost per unit 16 Fixed costs per month $18,000 Calculate the contribution margin per unit. A.$58 B. $42 C. $16...

Peeler's Smoothie Company has provided the following information: Sales price per unit $6.50 Variable cost per unit $1.00 Fixed costs per month $3,000 Calculate the contribution margin ratio. (Round...

I need some quick help on this please I will rate! Many thanks and God bless!!! Emeka Company has provided the following information: Sales price per unit $56 Variable cost per unit 12 Fixed costs...

In a heat-driven refrigerator with ammonia as the working fluid, a turbine with inlet conditions of 2.0 MPa, 70C is used to drive a compressor with inlet saturated vapor at 20C. The exhausts, both at...

In the Excel file Call Center Data, how strongly is length of service correlated with starting age?

Your savings account is currently worth $ 1 , 2 0 0 . The account pays 4 . 5 percent interest compounded annually. Determine how much your account will be worth 6 years from now. How much will your...

is a declaration specifying the aims of agile approaches emphasizing a focus on individuals and interactions, working software, customer collaboration, and responding to change. The agile project...

1. Discuss the following statements: a) Predetermined is not the same thing as predictable. b) When we are aware of the consequences of our behaviour, we can change our behaviour. c) What we know is...

2. In this chapter, the reader should reflect on the following concepts:

1. To provide an understanding that a person in a communication situation conveys three things at the same time: their position, basic interests and values.