1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
padilas [110]
4 years ago
15

Applying ExcelData Unit sales 10,000 unitsSelling price per unit $70 per unitVariable expenses per unit $42 per unitFixed expens

es $140,000Enter a formula into each of the questions below. If your formulas are correct, you should get the correct answers to the following questions. Show your work and formulas.(a) What is the break-even in dollar sales?Break-even in dollar _____(b) What is the margin of safety percentage?Margin of safety percentage _____(c) What is the degree of operating leverage? (Round your answer to 2 decimal places.)Degree of operating leverage _____3. Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in net operating income if unit sales increase by 20%Percentage increase in the operating income _____4. Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like thisData Unit sales 12,000 unitsSelling price per unit $70 per unitVarable expenses per unit $42 per unitFixed expenses $140,000(a) What is the net operating income? (Negative amount should be indicated by a minus sign.)Net operating income (loss) _____(b) By what percentage did the net operating income increase?Percentage increase in net operating income _____%
Business
1 answer:
katovenus [111]4 years ago
6 0

Answer:

Please see solution below

Explanation:

a. Break even in dollar sales

= [ Fixed cost / Contribution margin ] × Selling price per unit

Fixed cost = $140,000

Selling price per unit = $70

Variable expenses per unit = $42

BEP in dollars = [$140,000 / $70 - $42] × $70

= $350,000

b. Margin of safety percentage

= [ Current sales level - Break even point / Current sales level ] × 100

Current sales level = 10,000 units

Break even point = Fixed cost / Contribution margin

= $140,000 / $70 - $42

= 5,000 units

Margin of safety = [10,000 - 5,0000/10,000 ] × 100

= 50%

C. Degree of operating leverage.

= Contribution margin / Net operating income

Contribution margin = $70 - $42 = $28

Net operating income

Sales ($70 × 10,000)

$700,000

Less Variable cost ($42 × 10,000)

$420,000

Contribution margin

$280,000

Less Fixed cost

$140,000

Net operating income

$140,000

Degree of operating leverage = $280,000 / $140,000

= 20%

D. Percentage in net income

Sales ($70 × 12,000)

$840,000

Less variable cost

$420,000

Contribution margin

$420,000

Less fixed cost

$140,000

Net operating income

$280,000

Percentage change in net income

= [$140,000 / $280,000] × 100

= 50%

You might be interested in
A manager that looks at loans and deposits increases and decreases among other things to measure the bank's liquidity position i
Mademuasel [1]

Answer:

The answer is letter C

Explanation:

The sources and uses of funds approach.

6 0
4 years ago
Barney decides to quit his job as a corporate accountant (which pays $10,000 a month) and go into business for himself as a cert
stiv31 [10]

Answer:

$11,875; $1,575

Explanation:

Total cost of starting an own business is as follows:

= purchase office supplies + monthly electricity bill has increased

= $75 + $50

= $125 per month

Total revenue = $12,000 per month

Opportunity cost refers to the cost of forgone something in order to choose some other alternative.

Opportunity cost or Implicit costs:

= Earning from Job + Income from garage apartment

= $10,000 + $300

= $10,300

(a) Barney's average monthly accounting profits:

= Total revenue - Total cost

= $12,000 - $125

= $11,875

(b) Barney's average monthly economic profits:

= Accounting profits - Implicit cost or Opportunity cost

= $11,875 - $10,300

= $1,575

5 0
3 years ago
Other things the same, if the exchange rate changes from 20 pesos per dollar to 30 pesos per dollar, then the dollar Group of an
salantis [7]

Other things are the same, if the exchange rate changes from 20 pesos per dollar to 30 pesos per dollar, then the dollar (A) appreciates and buys more Mexican goods.

<h3>What is the exchange rate?</h3>
  • An exchange rate is a rate at which one currency is exchanged for another in finance.
  • Currencies are most typically national currencies, although they can also be sub-national, as in Hong Kong, or supra-national, as in the euro.
  • The value of one country's currency in respect to another currency is also referred to as the exchange rate.
  • Other things remain constant, if the exchange rate increases from 20 pesos to 30 pesos, the dollar appreciates and buys more Mexican items.

Therefore, other things are the same, if the exchange rate changes from 20 pesos per dollar to 30 pesos per dollar, then the dollar (A) appreciates and buys more Mexican goods.

Know more about exchange rates here:

brainly.com/question/2202418

#SPJ4

The correct question is given below:

Other things are the same, if the exchange rate changes from 20 pesos per dollar to 30 pesos per dollar, then the dollar ________.

The group of answer choices

(A) appreciates and buys more Mexican goods.

(B) appreciates and buys fewer Mexican goods.

(C) depreciates and buys more Mexican goods.

(D) depreciates and buys fewer Mexican goods.

7 0
2 years ago
Is this the Right answer?
Vinil7 [7]
You did answer correctly gg
8 0
3 years ago
Read 2 more answers
Robin Baker, a top manager at Westinghouse, has recently been put in charge of a new multi-million dollar project. She selects s
natulia [17]

Answer:

The answer is: A) Autocratic

Explanation:

Autocratic leadership style, also known as authoritarian leadership, is characterized by heavy control by the group's leader. The leader makes all the decisions and doesn't value the subordinates' contributions. Autocratic leaders make decisions based on their ideas and personal judgement, not the others'.

7 0
3 years ago
Other questions:
  • Dr. Leo is involved in an applied research study of customer satisfaction with a newly developed line of facial cosmetics and ot
    10·1 answer
  • Should Tangshan Mining company accept a new project if the​ company's maximum payback is 3.5 years and the​ project's initial af
    5·1 answer
  • When business analytics is used to understand past and current performance, it is called _____?
    7·1 answer
  • Both internal and external <br> help in the profitability and growth of an organization.
    5·2 answers
  • In liability based on negligence, _____. a contractual relationship is involved and it does matter whether or not the buyer deal
    13·1 answer
  • Completed Per Day
    15·1 answer
  • To compare themselves to peers, Bryan Air has a consultant to monitor customer service metrics such as customer satisfaction aga
    12·1 answer
  • The___ shows your company's equity.
    13·2 answers
  • Negative word-of-mouth communication is more likely to occur when consumers: Group of answer choices repeatedly purchase product
    11·1 answer
  • What type of listening would be used if Jim was trying to determine his employees' thoughts and opinions on new health-care cove
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!