Question

In: Accounting

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 subscribers (accounts). In part (a) and (b), round all interim calculations and final answers to one decimal place. a. What is Sprint Nextel's break-even number of accounts, using the data and assumptions given? b. How much revenue per account would be sufficient for Sprint Nextel to break even if the number of accounts remained constant?

Solutions

Expert Solution

a)

Break-even number of accounts = Total Fixed Costs / (Revenue Per Account – Variable Cost per Account)

= $15,326.80 / (1,087.54 – 539.02)

= $15,326.80 / 548.52

= 27.94 million accounts or 27.9 million accounts

b)

Break-even (in $ revenue, in millions) = Total Costs / Divided by number of accounts

= $32,845 / 32.5

= $1,010.61

Variable Cost Percentage = Variable Cost per account / Revenue per account x 100

= 539.02 / 1087.54 x 100

= 49.56%

Supporting calculations:

Revenue Per Account (in millions):

Total Revenue (in million)

$35,345

Total accounts (in millions)

32.5

Revenue per account (in millions)

$1,087.54

Variable cost per account (in millions):

Cost of revenue (in millions) (20,841*70%)

$14,588.70

Selling, gen., admin. exp. (in millions) (9,765*30%)

$2,929.50

Total variable costs

$17,518.20

Divided by number of accounts

32.50

Variable cost per account (in millions)

$539.02

Total fixed costs (in millions):

Cost of revenue (in millions) (20,841*30%)

$6,252.30

Selling, gen., admin. exp. (in millions) (9,765*70%)

$6,835.50

Depreciation

$2,239.00

Total fixed costs (in millions)

$15,326.80

Note ---- I have considered two decimal places in intermediate calculation and rounded off final answer to 1 decimal place...In case any change, please modify the answer accordingly or advise me, i will the updated answer according to the decimal places..


Related Solutions

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....
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....
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...
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...
Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In...
Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet 30 minutes Supervisor salaries $117,000 per month Depreciation $29,000 per month Direct labor rate $15 per hour Prepare a flexible budget for 14,000, 18,000, and 21,000 filing cabinets for the month of March in the Assembly Department similar to Exhibit...
Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In...
Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it produces filing cabinets in two departments: Fabrication and Trim Assembly. Assume the following information for the Fabrication Department: Steel per filing cabinet 41 pounds Direct labor per filing cabinet 20 minutes Supervisor salaries $141,000 per month Depreciation $32,000 per month Direct labor rate $18 per hour Steel cost $1.52 per pound Prepare a flexible budget for 15,000, 19,000, and 23,000...
The ABC Company is one of the largest producers of power tools in the United States....
The ABC Company is one of the largest producers of power tools in the United States. The company is preparing to replace its current product line with the next generation of products: specifically, three exciting new power tools with the latest state-of-the-art features. Because of the limited amount of capital available, management needs to make some difficult choices about how much to invest in each of these products. Another concern is the effect of these decisions on the company’s ability...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT