Question

In: Accounting

Break-Even Analysis Rotelco is one of the largest digital wireless service providers in the United States....

Break-Even Analysis

Rotelco is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 100 direct subscribers (accounts) that generated revenue of $52,900. Costs and expenses for the year were as follows:

Cost of revenue $23,300
Selling, general, and administrative expenses 17,500
Depreciation 5,800

Assume that 60% of the cost of revenue and 25% of the selling, general, and administrative expenses are variable to the number of direct subscribers (accounts).

a. What is Rotelco's break-even number of accounts, using the data and assumptions above? Round to the nearest whole number.
_______ accounts

b. How much revenue per account would be sufficient for Rotelco to break even if the number of accounts remained constant? Round to the nearest dollar.
_______$ per account

I HAVE TRIED 64 AND 65 AS THE ANSWER TO THE FIRST PART OF THE QUESTION. I HAVE ALSO ASKED OTHER EXPERTS BUT NOTHING IS COMING UP RIGHT. PLEASE HELP

Solutions

Expert Solution

Answer a.

Variable Costs = 60% * Cost of Revenue + 25% * Selling, General and Administrative Expenses
Variable Costs = 60% * $23,300 + 25% * $17,500
Variable Costs = $18,355

Variable Costs per account = Variable Costs / Number of accounts
Variable Costs per account = $18,355 / 100
Variable Costs per account = $183.55

Service Revenue per account = Service Revenue / Number of accounts
Service Revenue per account = $52,900 / 100
Service Revenue per account = $529

Fixed Costs = 40% * Cost of Revenue + 75% * Selling, General and Administrative Expenses + Depreciation
Fixed Costs = 40% * $23,300 + 75% * $17,500 + $5,800
Fixed Costs = $28,245

Contribution Margin per account = Service Revenue per account - Variable Costs per account
Contribution Margin per account = $529.00 - $183.55
Contribution Margin per account = $345.45

Breakeven number of accounts = Fixed Costs / Contribution Margin per account
Breakeven number of accounts = $28,245 / $345.45
Breakeven number of accounts = 82

Answer b.

Breakeven number of accounts = 100
Fixed Costs = $28,245
Variable Costs per account = $183.55

Breakeven number of accounts = Fixed Costs / Contribution Margin per account
100 = $28,245 / Contribution Margin per account
Contribution Margin per account = $282.45

Contribution Margin per account = Service Revenue per account - Variable Costs per account
$282.45 = Service Revenue per account - $183.55
Service Revenue per account = $466.00


Related Solutions

Break-even analysis for a service company Rotelco is one of the largest digital wireless service providers...
Break-even analysis for a service company Rotelco is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 100 direct subscribers (accounts) that generated revenue of $36,300. Costs and expenses for the year were as follows: Cost of revenue $16,300 Selling, general, and administrative expenses 11,600 Depreciation 4,000 Assume that 60% of the cost of revenue and 30% of the selling, general, and administrative expenses are variable to the number of...
Rotelco is one of the largest digital wireless service providers in the United States. In a...
Rotelco is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 100 direct subscribers (accounts) that generated revenue of $28,400. Costs and expenses for the year were as follows: Cost of revenue $13,900 Selling, general, and administrative expenses 9,400 Depreciation 3,100 Assume that 75% of the cost of revenue and 20% of the selling, general, and administrative expenses are variable to the number of direct subscribers (accounts). a. What is...
Rotelco is one of the largest digital wireless service providers in the United States. In a...
Rotelco is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 100 million direct subscribers (accounts) that generated revenue of $31,100 million. Costs and expenses for the year were as follows: Cost of revenue $14,600 Selling, general, and administrative expenses 10,000 Depreciation 3,400 Assume that 70% of the cost of revenue and 30% of the selling, general, and administrative expenses are variable to the number of direct subscribers (accounts). a....
Rotelco is one of the largest digital wireless service providers in the United States. In a...
Rotelco is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 100 million direct subscribers (accounts) that generated revenue of $30,200 million. Costs and expenses for the year were as follows: Cost of revenue $14,500 Selling, general, and administrative expenses 8,800 Depreciation 3,300 Assume that 70% of the cost of revenue and 30% of the selling, general, and administrative expenses are variable to the number of direct subscribers (accounts). a....
Rotelco is one of the largest digital wireless service providers in the United States. In a...
Rotelco is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 100 million direct subscribers (accounts) that generated revenue of $54,300 million. Costs and expenses for the year were as follows: Cost of revenue $22,300 Selling, general, and administrative expenses 17,900 Depreciation 6,000 Assume that 70% of the cost of revenue and 30% of the selling, general, and administrative expenses are variable to the number of direct subscribers (accounts). a....
Sprint Nextel is one of the largest digital wireless service providers in the United States. In...
Sprint Nextel is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 32.5 million direct subscribers (accounts) that generated revenue of $35,345 million. Costs and expenses for the year were as follows (in millions): Cost of revenue $20,841 Selling, general, and administrative expenses 9,765 Depreciation 2,239 Assume that 70% of the cost of revenue and 30% of the selling, general, and administrative expenses are variable to the number of direct...
Break-even analysis for a service company Sprint Nextel is one of the largest digital wireless service...
Break-even analysis for a service company Sprint Nextel is one of the largest digital wireless service providers in the United States. In a recent year, it had approximately 32.5 million direct subscribers (accounts) that generated revenue of $35,345 million. Costs and expenses for the year were as follows (in millions): Cost of revenue $20,841 Selling, general, and administrative expenses 9,765 Depreciation 2,239 Assume that 70% of the cost of revenue and 30% of the selling, general, and administrative expenses are...
Explain break-even analysis, its purpose, and whether break-even analysis can be used in manufacturing and/or service...
Explain break-even analysis, its purpose, and whether break-even analysis can be used in manufacturing and/or service industry.
describe applications of break-even analysis in practice. provide limitations of break-even analysis.
describe applications of break-even analysis in practice. provide limitations of break-even analysis.
What is break-even? How is break-even calculated? How is a break-even analysis used? What are the...
What is break-even? How is break-even calculated? How is a break-even analysis used? What are the risks if break-even is not analyzed carefully?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT