Question

In: Accounting

Company manufactures and sells a single product. The​ company's sales and expenses for last year​ follow:...

Company manufactures and sells a single product. The​ company's sales and expenses for last year​ follow:

LOADING...

​(Click the icon to view the​ information.)Read the requirements

LOADING...

.

Requirement 1. Fill in the missing numbers in the table. Use the following questions to help fill in the missing numbers in the​ table:

a. What is the total contribution​ margin?

The total contribution margin is

.

b. What is the total variable​ expense?

The total variable expense is

.

c. How many units were​ sold?

units were sold.

d. What is the​ per-unit variable​ expense?

The per-unit variable expense is

.

e. What is the​ per-unit contribution​ margin?

The per-unit contribution margin is

.

Now fill in the missing numbers in the table. ​(Enter the percentages as whole​ numbers, "XX")

Total

Per Unit

%

Sales. . . . . . . . . . . . . . . . . .

$115,000

$50

%

Variable expenses. . . . . . . .

%

Contribution margin. . . . . .

%

Fixed expenses. . . . . . . . . .

11,500

Operating income. . . . . . . .

$46,000

Requirement 2. Answer the following questions about breakeven​ analysis:

a. What is the breakeven point in​ units?

Begin by identifying the formula to compute the breakeven point in units.

(

+

) ÷

=

Breakeven sales in units

The breakeven point in units is

.

b. What is the breakeven point in sales​ dollars?

Begin by identifying the formula to compute the breakeven point in sales dollars.

(

+

) ÷

=

Breakeven sales in dollars

The breakeven point in sales dollars is

.

Requirement 3. Answer the following questions about target profit analysis and safety​ margin:

a. How many units must the company sell in order to earn a profit of

$58,000​?

The company must sell

units in order to earn a profit of $58,000.

b. What is the current margin of safety in​ units?

Begin by identifying the formula to compute the current margin of safety in units.

=

Margin of safety in units

The current margin of safety in units is

.

c. What is the margin of safety in sales​ dollars?

Begin by identifying the formula to compute the margin of safety in dollars.

=

Margin of safety in dollars

The margin of safety in dollars is

.

d. What is the margin of safety in​ percentage?

Begin by identifying the formula to compute the margin of safety in percentage.

Margin of safety as a

÷

=

percentage of budgeted sales

​(Round the percentage to the nearest tenth​ percent, X.X%.)

The margin of safety percentage is

%.

Sales. . . . . . . . . . . . . . . . . . .

$115,000

$50

?

Variable expenses. . . . . . .

?

?

?

Contribution margin. . . . . .

?

?

?

Fixed expenses. . . . . . . . . .

11,500

Operating income. . . . . . . .

$46,000

Solutions

Expert Solution

a.Total contribution Margin = Fixed expenses + Operating Income

= 11500+46,000

= $57,500

b.Total variable expense = Total Sales – Total contribution margin

= 115,000-57,500

= $57,500

c.Units sold = Total Sales/Selling price per unit

= 115,000/50

= 2,300 units

d. Per unit variable expense = 57,500/2,300

= $25 per unit

e. Per unit CM = 57,500/2,300

= $25 per unit

total

per unit

%

Sales

       115,000

50

100%

Variable expenses

57,500

25

50%

Contribution margin

57,500

25

50%

Fixed expenses

11,500

Operating income

46,000

a. Break even point in units = (Fixed expenses + operating income)/Contribution margin per unit

= (11500+0)/25

= 460 units

b. Sales dollars = (Fixed expenses + Operating Income)/Contribution Margin ratio

= (11,500+ 0)/50%

= $23,000

3.a. Units = (11500+58000)/25

= 2,780 units

b. Margin of safety = Budgeted sales in units – break even sales in units

= 2300 – 460

= 1,840 units

c. Sales dollars = Budgeted Sales dollars – breakeven sales in dollars

= 115,000 – 23000

= $92,000

% = Margin of safety in dollars/Budgeted sales in dollars

= 92000/115,000

= 80%


Related Solutions

Menlo Company distrubutes a single product. The company's sales and expenses for last month follow: Sales...
Menlo Company distrubutes a single product. The company's sales and expenses for last month follow: Sales $316, 000, per unit $20 Variable expenses 221,200 and 14 per unit Contribution margin 94,800 $6 Fixed expenses 74,400 Net operating income 20,400 1.what is the monthly break even point in unit sales and in dollar sales?2.Without resorting to computations, what id the total contribution margin at the break ever point? 3) How many units have to be sold each month to attain a...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow:    ...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow:     Total      Per Unit Sales   $   628,000      $   40      Variable expenses      439,600         28      Contribution margin      188,400      $   12      Fixed expenses      153,600               Net operating income   $   34,800               Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations,...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 302,000 $ 20 Variable expenses 211,400 14 Contribution margin 90,600 $ 6 Fixed expenses 77,400 Net operating income $ 13,200 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 620,000 $ 40 Variable expenses 434,000 28 Contribution margin 186,000 $ 12 Fixed expenses 148,800 Net operating income $ 37,200 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 612,000 $ 40 Variable expenses 428,400 28 Contribution margin 183,600 $ 12 Fixed expenses 147,600 Net operating income $ 36,000 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 624,000 $ 40 Variable expenses 436,800 28 Contribution margin 187,200 $ 12 Fixed expenses 154,800 Net operating income $ 32,400 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 306,000 $ 20 Variable expenses 214,200 14 Contribution margin 91,800 $ 6 Fixed expenses 76,200 Net operating income $ 15,600 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 608,000 $ 40 Variable expenses 425,600 28 Contribution margin 182,400 $ 12 Fixed expenses 151,200 Net operating income $ 31,200 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales. . . . . . . . . . . . . . . . . . . . . . . . $450,000 $30 Variable expenses . . . . . . . . . . . . . 180,000 12 Contribution margin . . . . . . . . . . . . 270,000 $18 Fixed expenses. ....
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total...
Menlo Company distributes a single product. The company’s sales and expenses for last month follow: Total Per Unit Sales $ 304,000 $ 20 Variable expenses 212,800 14 Contribution margin 91,200 $ 6 Fixed expenses 73,200 Net operating income $ 18,000 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT