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 | |||||||||||||
I have posted the data table which is the first picture i Data Table Company Cloudy...
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: (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 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 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 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 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 (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 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 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 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...