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]
3 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]3 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
Consumers today receive commercial messages from a broad range of sources.
NemiM [27]

Answer:

Letter A is correct. <u><em>Don't distinguish between message sources.</em></u>

Explanation:

Integrated marketing communication is a relevant tool whose primary objective is to ensure that there is compliance in corporate marketing communication across all media channels used by the organization, ie all communication of promotions and dissemination of company products and services is organized and consistent to create reliability and customer experience.

There are many benefits to ensuring that integrated marketing communication is well developed, some of which are brand awareness according to their individual exposed elements, cost savings and less waste with inconsistent messages, the consumer experience that assists continuous improvement. communication and focus on results, achieved most effectively when there is synchronization between internal and external communication in the company.

7 0
3 years ago
The deadweight loss associated with output less than the competitive level can be determined by A. subtracting the consumer surp
SSSSS [86.1K]

Answer:

C. subtracting the competitive level producer surplus from the producer surplus associated with less output

Explanation:

A deadweight loss refers to a cost to society created as a result of market inefficiency. Market inefficiency occurs when supply and demand are out of equilibrium. It is also known as excess burden.

Deadweight loss is also created due to taxes as they prevent people from purchasing things that they would otherwise as the final price of the product increases.

The deadweight loss associated with output less than the competitive level can be determined by subtracting the competitive level producer surplus from the producer surplus associated with less output

7 0
3 years ago
The CPI is 120 in year 1 and 150 in year 2. All inflation is anticipated. If Gringotts Bank charges an interest rate of 20.00 pe
liq [111]

Answer:

Gringotts Bank real interest rate = 20% - 25% = -5%

Explanation:

real interest rate = nominal interest rate - inflation rate

the inflation rate between year 1 and year 2 = [(CPI year 2 - CPI year 1) / CPI year 1] x 100 = [(150 - 120) / 120] x 100 = (30 / 120) x 100 = 0.25 x 100 = 25%

Gringotts Bank real interest rate = 20% - 25% = -5%

since the interest rate is negative, that means that Gringott Bank is actually losing money by lending it at 20% since the inflation rate is much higher.  

3 0
3 years ago
The Retained Earnings account has a credit balance of $40,000 before closing entries are made. Total revenues for the period are
iren2701 [21]

Answer:

A. Debit Income Summary $41,300; credit Expense accounts $41,300

Explanation:

At the end of the period, the revenue and expenses for the company are closed into the income summary account which in turn is closed into the retained earnings account.

For revenue, the entries are debit revenue and credit income summary with the revenue for the year. For expenses, credit expenses and debit income summary with the total expense for the year.

As such, given that Total revenues for the period are $58,200, total expenses are $41,300, and dividends are $10,200, the correct closing entry for the expense accounts is

Debit Income Summary $41,300

Credit Expense accounts $41,300

3 0
3 years ago
Using the following year-end information for WorkFit calculate the acid-test ratio:
ASHA 777 [7]

Answer:

0.97

Explanation:

The computation of the acid-test ratio is given below:

= Quick assets ÷ current liabilities

= (cash + short term investment + account receivable + supplies) ÷ (accounts payable + wages payable)

= ($58,110 + $14,000 + $58,000 + $5,600) ÷ ($108,000 + $31,900)

= $135,710 ÷ $139,900

= 0.97

7 0
3 years ago
Other questions:
  • How can being involved in extracurricular activities help you stand out on your college application?
    12·2 answers
  • A mid-sized firm plans to issue 10 million shares during an IPO. The underwriter plans to sell shares at $22.55; however, many i
    7·1 answer
  • Everyone likes to have lydia working on their committees because she seems to have the unique ability to consider a variety of o
    13·1 answer
  • Target Costing Oregon Equipment Company wants to develop a new log-splitting machine for rural homeowners. Market research has d
    9·1 answer
  • Note Payable (due Nov 1, 20X2) $ 2,000 Retained Earnings (Jan. 1, 20X1) $ 3,900 Revenues 55,600 Supplies 700 Supplies Expense 6,
    6·1 answer
  • g The budgeted production of​ Capricorn, Inc. is 15 comma 000 units per month. Each unit requires 30 minutes of direct labor to
    8·1 answer
  • To be in litigation is the same thing as to be in arbitration.
    13·1 answer
  • Why are craftsman likely to produce fewer goods than modern manufacturers produce?
    13·2 answers
  • The best way for a company to handle a boycott is to
    8·1 answer
  • The seeds of a financial crisis are often sown when an economy , an event known as?
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!