Question

In: Accounting

The budgets of four companies yield the following​ information: The budgets of four companies yield the...

The budgets of four companies yield the following​ information:

The budgets of four companies yield the following​ information:

​(Click the icon to view the budget information for the four​ companies.)

Requirements

1.

Fill in the blanks for each company.

2.

Compute​ breakeven, in sales​ dollars, for each company. Which company has the lowest breakeven point in sales​ dollars? What causes the low breakeven​ point?

Company

Q

R

S

T

Target sales. . . . . . . . . . . . . . . .

$680,000

$331,250

$171,875

$

Variable expenses. . . . . . . . . .

170,000

270,000

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

156,000

88,000

Operating income (loss). . . . . .

$150,000

$

$

$133,000

Units sold. . . . . . . . . . . . . . . . .

125,000

11,000

18,000

Contribution margin per unit. .

$6.25

$

$10.00

$35.00

Contribution margin ratio. . . . .

0.80

Solutions

Expert Solution

1) Fixed Cost of Q = Contribution Margin - Operating Income

= 510,000 - 150,000

= $360,000

2) Unit sold of Q = Contribution Margin / Contribution Margin Per Unit

= 510,000/6.25

= 81,600 Units

3) Contribution margin ratio of Q = Contribution Margin/Total Sales = 510,000/680,000 = 0.75

4) Contribution Margin of R = Target Sales x Contribution Margin Ratio = 331,250 x 0.80 = $265,000

5) Variable Cost of R = Target Sales - Contribution Margin = 331,250 - 265,000 = $66,250

6) Operating Income of R = Contribution Margin - Fixed Cost = 265,000 - 156,000 = $109,000

7) Contribution Margin Per Unit of R = Contribution Margin / No. of Units sold = 265,000/125,000 = $2.12

8) Contribution Margin of S = Units sold x Contribution margin per unit = 11,000 x 10 = $110,000

9) Variable Cost of S = Target Sales - Contribution Margin = 171,875 - 110,000 = $61,875

10) Operating Income of S = Contribution Margin - Fixed Cost = 110,000 - 88,000 = $22,000

11) Contribution margin ratio of S = Contribution Margin/Total Sales = 110,000/171,875 = 0.64

12) Contribution Margin of T = Units sold x Contribution margin per unit = 18,000 x 35 = $630,000

13) Target Sales of T = Contribution Margin + Variable Expense = 630,000 + 270,000 = $900,000

14) Fixed Cost of T = Contribution Margin - Operating Income = 630,000 - 133,000 = $497,000

15) Contribution margin ratio of T = Contribution Margin/Total Sales = 630,000/900,000 = 0.70

Break Even in sales dollars = Fixed Cost/Contribution Margin Ratio

Based on attached working - Company S has the lowest Break even sales in dollars.

Reason for lowest breakeven of Company S is its lowest fixed cost among all companies


Related Solutions

​The budgets of four companies yield the following information:
The budgets of four companies yield the following information:CompanyQRSTTarget sales . . . . . . . . . . . . . . . .$680,000$445,000$224,000$Variable expenses . . . . . . . . . .170,000156,000Fixed expenses . . . . . . . . . . . . .159,00093,000Operating income (loss) . . . . . .$150,000$$$131,000Units sold . . . . . . . . . . . . . . . . .106,80012,50016,000Contribution margin per unit...
The budgets of four companies yield the following​ information: LOADING... ​(Click the icon to view the...
The budgets of four companies yield the following​ information: LOADING... ​(Click the icon to view the budget information for the four​ companies.)Read the requirements LOADING... . Requirement 1. Fill in the blanks for each missing value. ​(Round the contribution margin per unit to the nearest cent. Use a minus sign or parentheses to enter an operating​ loss.) Up Net Sales Revenue $992,000 Variable Costs Fixed Costs Operating Income (Loss) $42,500 Units Sold 155,000 Contribution Margin per Unit $3.20 Contribution Margin...
The budgets of three companies yield the following information. fill in the blanks for each missing...
The budgets of three companies yield the following information. fill in the blanks for each missing value. Carey Company: Net sales Revenue ________, Variable Costs 196,000, Fixed Costs 162,000, Operating Income (loss)__________, Units Sold 14,000, Contribution Margin per Unit__________, Contribution Margin Ratio 60%. Doren Company: Met Sales Revenue 950,000, Variable Costs 760,000, Fixed Costs 100,000, Operating Income(loss)__________, Units Sold_________, Contribution Margin per Unit $76.00, Contribution Margin Ratio____________. Everest Company: Net Sales Revenue___________, Variable Costs 186,300, Fixed Costs____________, Operating Income (loss)...
Financial information follows for four different companies:
  Financial information follows for four different companies:   Ace Consulting Inc. Brrrr Freezers Corp. Capital Consumer   Inc. Death Star Ltd. Sales Revenue $98,000 (c) $144,000 $120,000 Sales Returns and Allowances  (a) $  5,000 12,000 9,000 Net Sales Revenue 74,000  101,000 132,000    (g) Beginning Inventory 21,000 (d)  44,000  24,000 Purchases 63,000 105,000  (e) 90,000 Returns and Allowances 6,000 10,000  8,000   (h) Ending Inventory  (b) 48,000 30,000  28,000 Cost of Goods Sold 64,000 72,000 (f) 72,000 Gross Profit 10,000 29,000 18,000 (i)...
The following information is taken from the accounting records of four different companies. Provide the missing...
The following information is taken from the accounting records of four different companies. Provide the missing amounts. Assume there are no indirect materials used in the company’s finished product. Company 1 Company 2 Company 3 Company 4 Direct Materials Inventory, beginning $15,400 $ $6,000 $165,300 Purchases of direct materials 86,400 52,600 258,800 Total direct materials available for use 394,600 111,600 Direct Materials Inventory, ending 26,700 59,350 Direct materials used in production 90,800 Direct labor 212,700 25,500 299,100 Total manufacturing overhead...
The following information is taken from the accounting records of four different companies. Provide the missing...
The following information is taken from the accounting records of four different companies. Provide the missing amounts. Assume there are no indirect materials used in the company’s finished product. Company 1 Company 2 Company 3 Company 4 Direct Materials Inventory, beginning $15,900 $ $6,500 $166,000 Purchases of direct materials 86,400 52,600 258,900 Total direct materials available for use 394,900 112,000 Direct Materials Inventory, ending 26,200 59,750 Direct materials used in production 91,100 Direct labor 212,000 25,000 298,500 Total manufacturing overhead...
discuss the following four budgets in healthcare, and when would it be appropriate to use them?...
discuss the following four budgets in healthcare, and when would it be appropriate to use them? operating budget cash budget capital budget grant/contract budget
Briefly discuss four types of organizational budgets
Briefly discuss four types of organizational budgets
What information is necessary for the operating budgets?
What information is necessary for the operating budgets?
TO Industries prepares monthly cash budgets. The following budget information is available for April and May...
TO Industries prepares monthly cash budgets. The following budget information is available for April and May 2020: April May Sales $650,000 $700,000 Direct material purchases 220,000 240,000 Direct labor 175,000 180,000 Manufacturing overhead 120,000 130,000 Selling and administrative expenses 150,000 150,000 All sales are credit sales. The company expects to collect 65% from customers in the month of the sale and the remaining 35% in first month following the sale. The company purchases direct materials on account. The company pays...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT