Question

i Data Table Company Cloudy Windy Sunny S 1,300,000 Rainy $ (d) 693,000 S 0) Net Sales Revenue Variable Costs Fixed Costs Operating Income (Loss) 166,000 Units Sold Contribution Margin per Unit $ Contribution Margin Ratio (a) 144,000 346,500 374,400 (b) 203,000 270,000 $ (e) S (g) $87,200 130,000 12,000 4.00 S (f) S77.00 $ 18.00 70% 20% Print Done
Requirement 1. Fill in the blanks operating loss.) for each missing value. (Round the contribution margin per unit to the nearest cent. Use a minus sign or parentheses to enter an missing value. Sunny Rainy Cloudy Windy 693.00CAL $ 693,000 346,500 270,000 S 1,300,000 Net Sales Revenue Variable Costs Fixed Costs Operating Income (Loss) Units Sold Contribution Margin per Unit Contribution Margin Ratio 374,400 44,000 203,000 S 87.200 S 166,000 130,000 4.00 12,000 S77.00 S18.00 70% 20% nts 2. and 3. Which company has the lowest breakeven point in sales dollars? What causes the low hreakavan
he budgets of four companies yield the tollowing information: Click the icon to view the budget information for the four companies.) Read the requirements Requirements 2. and 3. Which company has the lowest breakeven point in sales dollars? What causes the low breakeven point? Begin by showing the formula and then entering the amounts to calculate the breakeven point in sales dollars for each company. (Complete all Round the breakeven point the required sales in dollars-up to the nearest whole dollar. For ex contribution margin.) answer boxes ample, $10 25 would be rounded to $11. Abbreviation used: CM + Required sales in dollars Sunny Rainy Cloudy Windy Which company has the lowest breakeven point in sales dollars? What causes the low breakeven point? )1 V has the lowest breakeven point, primarily due to Choose from any list or enter any number in the input fields and then continue to the next question
I have posted the data table which is the first picture
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Answer 1 Answer 2 & 3
Company (Fixed Cost / Contribution Margin ratio) = Required sales in dollars
Sunny Rainy Cloudy Windy Sunny $354,000.00 / 40.00% = $885,000.00
Net sales revenue $1,300,000.00 $480,000.00 $693,000.00 $468,000.00 Rainy $203,000.00 / 70.00% = $290,000.00
Variable costs $780,000.00 $144,000.00 $346,500.00 $374,400.00 Cloudy $270,000.00 / 50.00% = $540,000.00
Fixed costs $354,000.00 $203,000.00 $270,000.00 $6,400.00 Windy $6,400.00 / 20.00% = $32,000.00
Operating Income (loss) $166,000.00 $133,000.00 $76,500.00 $87,200.00
Units sold 130000 12000 4500 5200 Windy Company has the lowest breakeven point primarily due to lower Fixed cost.
Contribution Margin per unit $4.00 $28.00 $77.00 $18.00
Contribution Margin ratio 40.00% 70.00% 50.00% 20.00%
Answer a
Selling price per unit = $1300000/130000 units = $10
Variable cost per unit = Selling price per unit - Contribution margin per unit = $10-$4 = $6
Variable cost = 130000 units * $6 = $7,80,000
Answer b
Fixed costs = Contribution Margin - Operating Income
Contribution Margin = 130000 units * $4 = $520000
Fixed costs = $520000 - $166000 = $3,54,000
Answer c
Contribution Margin ratio = Contribution Margin / sales = $520000 / $1300000 = 40%
Answer d
Sales = Variable cost / (1 - Contribution Margin ratio) = $144000 / (1-70%) = $480000
Answer e
Operating Income = Sales - Variable cost - Fixed Cost = $480000 - $144000 - $203000 = $133000
Answer f
Contribution Margin per unit = [Sales * Contribution Margin ratio] / No.of units sold
Contribution Margin per unit = [$480000 * 70%]/12000 units = $28 per unit
Answer g
Operating Income = Sales - Variable cost - Fixed Cost = $693000 - $346500 - $270000 = $76,500
Answer h
No.of units sold = [Sales - Variable cost]/Contribution margin per unit = [$693000 - $346500]/$77 = 4500 units
Answer i
Contribution Margin ratio = [No.of units sold * Contribution Margin per unit]/Sales
Contribution Margin ratio = [4500 units * $77]/$693000 = 50%
Answer j
Net sales revenue = Variable cost / [1 - Contribution margin ratio]
Net sales revenue = $374400 / [1-20%] = $468000
Answer k
Fixed cost = Sales - Variable cost - Operating Income
Fixed cost = $468000 - $374400 - $87200 = $6400
Answer l
No.of units sold = [Sales - Variable cost]/Contribution margin per unit = [$468000 - $374400]/$18 = 5200 units
Add a comment
Know the answer?
Add Answer to:
I have posted the data table which is the first picture i Data Table Company Cloudy...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The budgets of four companies yield the following information: (Click the icon to view the budget...

    The budgets of four companies yield the following information: (Click the icon to view the budget information for the four companies.) Read the requirements. 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.) Sunny Rainy Cloudy Windy Net Sales Revenue $ 1,596,000 385,000 Variable Costs 58,000 231,000 165,750 Fixed Costs 208,000 236,000 Operating Income (Loss) 354,500 97,700 Units...

  • Please solve completely, thanks i Data Table The budgets of four companies yield the following information:...

    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...

  • Data Table The budgets of four companies yield the following information: (Click the icon to view...

    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...

  • The budgets of four companies yield the following information: (Click the icon to view the budget...

    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...

  • The budgets of four companies yield the following information: E: (Click the icon to view the...

    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: (Click the icon to view the budget...

    The budgets of four companies yield the following information: (Click the icon to view the budget information for the four companies.) Read the requirements. Requirement 1. Fill in the blanks for each missing value. (Round the contribution margin per unit to the nearest cent. Use a minu Down Right Up 1,625,000 $ Left $1,251,250 750,750 208.000 316.800 48,000 216,000 Net Sales Revenue Variable Costs Fixed Costs Operating Income (Loss) Units Sold Contribution Margin per Unit Contribution Margin Ratio $ 71,400...

  • I need the answer to T collum 131730 252%58P700 P7-61A Find missing data in CVP relationships...

    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....

  • 11. The budgets of four companies yield the following information: (Click the icon to view the...

    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...

  • Help please! This Question: 1 pt 3 of 3 (3 complete) The budgets of four companies...

    Help please! This Question: 1 pt 3 of 3 (3 complete) The budgets of four companies yield the following information: (Click the icon to view the budget information for the four companies.) Read the requirements 4.000 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 Down Left Right Net Sales Revenue $ 1,160,000 $ 584,000 Variable Costs...

  • P7-61A (similar to) Question Help The budgets of four companies yield the following information: (Click the...

    P7-61A (similar to) Question Help 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 to two...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT