REQUIREMENT: 1
Q | R | S | T | |
TARGETED SALES | 800,000 | 480,000 | 236,000 | 900,000 |
VARIABLE EXPENSES | 232,000 | 216,000 | 118,000 | 270,000 |
FIXED EXPENSES | 355,000 | 165,000 | 94,000 | 497,000 |
OPERATING INCOME(LOSS) | 213,000 | 99,000 | 24,000 | 133,000 |
UNIT SOLD | 88,750 | 110,000 | 12,500 | 18,000 |
CONTRIBUTION MARGIN PER UNIT | 6.40 | 2.40 | 9.44 | 35.00 |
CONTRIBUTION MARGIN RATIO | 0.71 | 0.55 | 0.50 | 0.70 |
Q
OPERATING INCOME= SALES-VARIABLE-FIXED EXPENSES
213,000 = 800,000-232,000-FIXED EXPNSES
FIXED EXPENSES= 800,000-232,000-213,000
=355,000
CONTRIBUTION= SALES - VARIABLE EXP
=800,000-232,000
=568,000
UNIT SOLD = CONTRIBUTION/CM PER UNIT
=568,000/6.40
=88,750 UNITS
CONTRIBUTION MARGIN RATIO= CONTRIBUTION/SALES
=568,000/800,000
= 0.71
R
CONTRIBUTION = SALES*CM RATIO
=480,000*0.55
=264,000
CONTRIBUTION =,SALES- VARIABLE EXP
264,000=480,000 - VARIABLE EXP
VARIABLE EXP= 216,000
CONTRIBUTION MARGIN PER UNIT= CONTRIBUTION /UNIT SOLD
=264,000/110,000
=2.4 PER UNIT
S:
CONTRIBUTION = UNIT SOLD* CONTRIBUTION MARGIN PER UNIT
9.44*12,500
=118,000
CONTRIBUTION= SALES- VARIABLE
118,000= 236,000-VARIABLE
VARIABLE EXP=118,000
CM RATIO = CONTRIBUTION/SALES
=118,000/236,000
=0.50
T.
CONTRIBUTION = UNITS SOLD*CM PER UNIT
=18,000*35
=630,000
CONTRIBUTION= SALES- VARIABLE EXPENSES
630,000 = SALES - 270,000
SALES= 900,000
CONTRIBUTION MARGIN RATIO= CONTRIBUTION/SALES
= 630,000/900,000
=0.70
REQUIREMENT 2:
BREAKEVEN POINT= FIXED COST/CM RATIO
Q =355,000/0.71
=500,000
R =165,000/0.55
=300,000
S =94,000/0.50
=188,000
T =497,000/0.70
=710,000
COMPANY S HAS LOWEST BREAK EVEN POINT BECAUSE IT HAS LOWEST FIXED COST IN ALL COMPANIES.
P7-61A (similar to) Question Help The budgets of four companies yield the following information: (Click the...
Please help me fill in all of the blanks with steps. Thank you! P7-61A (similar to) Data Table The budgets of four companies yield the following info EEB (Click the icon to view the budget information for the Requirements 1. Fill in the blanks for each company 2. Compute breakeven, in sales dollars, for each comp Company int? 216,000 270,000 153,000 93,000 Fixed expenses 216,000 350000 $154,000 $154,000 140,000 15,750 8.96 40.00 Operating income (loss) .. 131,500 12,500 Operating income...
The budgets of four companies yield the following information: E: (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? Requirement 1. Fill in the blanks for each company. (Round the contribution margin per unit and ratio calculations to two decimal pl 650,000 130,000...
The budgets of four companies yield the following information: BE(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 cause x i Data Table Requirement 1. Fill in the blanks for each company. (Round the contribution margin per unit and ratio calculations to two decimal places.) Company Q 720,000...
Data Table 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 T Company Q R S 625,000 $ 415,625 $ 190,000 125,000 160,000 90,000 130,000 $ $ 645,000 1. Target sales ............. $ Variable expenses Fixed expenses .......... Operating income (loss) $ Units...
11. 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? son Requirement 1. Fill in the blanks for each company (Round the contribution margin per unit and ratio calculations to two decimal places.) Q...
Include the contribution margin on your spreadsheeT VILLA1425 000000000000000 SONGS 01317300000OOOOOOOOOOOO 5 700301317300OOOOOOOOOOO0002305SOS P7-61A Find missing data in CVP relationships (Learning Objectives 1 & 2) The budgets of four companies yield the following information: Company R S Target sales $680,000 $445,000 $224.000 Variable expenses 170,000 270.000 Fixed expenses $159.000 $.93.000 Operating income (loss) $.150.000 $ $133.000 Units sold 106,800 12,500 18,000 Contribution margin per unit $ 6.25 $ 8.96 $ 35.00 Contribution margin ratio 0.60 Requirements 1. Fill in the...
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? 18,000 Target sales... 757,500 $ 480,000 $ 181,250 Variable expenses. 242.400 270.000 105,000 98,000 Foed expenses.... 175, 100 133,000 Operating income (loss) Units sold 110,000...
Please solve completely, thanks i Data Table 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? Requirement 1. Fill in the blanks for each company. (Round the contribution margin per unit and ratio calculations...
I need the answer to T collum 131730 252%58P700 P7-61A Find missing data in CVP relationships (Learning Objectives 1 & 2) The budgets of four companies yield the following information Company T Target sales $680,000 $445,000 $224,000 Variable expenses 170,000 270,000 Fixed expenses $159.000 $.93.000 www m Operating income (loss) $150.000 $133.000 18,000 106,800 12,500 Units sold $ 8.96 $6.25 $35.00 Contribution margin per unit 0,60 Contribution margin ratio wwwww Requirements 1. Fill in the blanks for each company 2....
P4-63A (similar to) Question Help The budgets of four companies yield the following information: E (Click the icon to view the budget information for the four companies.) Requirements 1. Fill in the blanks for each company. 2. Compute break-even, in sales dollars, for each company. Which company has the lowest break-even point in sales dollars? What causes the low break-even point? Tions to two decimal places.) Requirement Data Table Target sales. Variable expe Company Fixed expens Operating ind 720,000 $...