7InstructionsKey Code:[Key code here]89 Answers are entered in the cells with gray backgrounds.10 Cells with non-gray backgrounds are protected and cannot be edited.11 An asterisk (*) will appear to the right of an incorrect entry.121314 A.15Break-Even (in accounts)%3D1617181920212224million (rounded) accountsSupporting calculations:Revenue per account (in millions):Total revenue (in millions)Total accounts (in millions)Revenue per account (in millions)3031323334Variable cost per account (in millions):VariableFull AmountPercentage35Cost of revenue (in millions)36Selling, gen., admin. exp. (in millions)37Total variable costs38Divided by number of accountsVariable cost per account (in millions)3940Total fixed costs (in millions):4142FixedFull AmountPercentage43Cost of revenue (in millions)44Selling, gen., admin. exp. (in millions)45Depreciation46Total fixed costs (in millions)47484950 B.51Break-even (in $ revenue, in millions):52Total costs53Divided by number of accounts54Break-evenmillion55 Ch05 Excel AssignmentEX 05 -17 (14th ed)Break-even analysis for a service companyUse the provided Excel template to complete the following questionusing Excel formulas where appropriate...... ..Sprint Nextel is one of the largest digital wireless service providers in theUnited States. In a recent year, it had approximately 32.5 million directsubscribers (accounts) that generated revenue of $35,345 million. Costs andexpenses for the year were as follows (in millions):Cost of revenue$20,8419,765Selling, general, and administrativeexpensesDepreciation2,239Assume that 70% of the cost of revenue and 30% of the selling, general, andadministrative expenses are variable to the number of direct subscribers(асcounts).1. What is Sprint Nextel's break-even number of accounts, using the data andassumptions given? Round units (accounts) and per-account amounts to onedecimal place.2. How much revenue per account would be sufficient for Sprint Nextel to breakeven if the number of accounts remained constant?

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

Use the provided Excel template to complete the following question using Excel formulas where appropriate. 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 9,765 expenses 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). 1. What is Sprint Nextel's break-even number of accounts, using the data and assumptions given? Round units (accounts) and per-account amounts to one decimal place. 2. How much revenue per account would be sufficient for Sprint Nextel to break even if the number of accounts remained constant?

Use the provided Excel template to complete the following question using Excel formulas where appropriate. 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 9,765 expenses 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). 1. What is Sprint Nextel's break-even number of accounts, using the data and assumptions given? Round units (accounts) and per-account amounts to one decimal place. 2. How much revenue per account would be sufficient for Sprint Nextel to break even if the number of accounts remained constant?

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter6: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 16E: Break-even analysis for a service company3 Sprint Corporation (S) is one of the largest digital...

See similar textbooks

Similar questions

E22-11 UrLink Company is a newly formed company specializing in high-speed Internet Prepare and discuss a service for home and business. The owner, Lenny Kirkland, had divided the company Into two segments Home Internet Service and Business Internet Service. Each segment Is run by Its own supervisor, while basic selling and administrative services are shared by both segments. Lenny has asked you to help him create a performance reporting system that will allow him to measure cach segment's performance in terms of its profitability. To that end, the following information has been collected on the Home Internet Service segment for the first quarter of 2017, responsibility reporl. (L0 2, 3), P I 22 Budgetary Control and Responsibility Accounting Budget $25,000 Actual Service revenue Allocated portion of: Building depreciation Advertising Billing Property taxes Material and supplies Supervisory salaries Insurance $26,200 11,000 5,000 3,500 1,200 1,600 9,000 4,000 3,000 2,800 1,500 11,000…
Consider a telecommunication service provider. You have the following quarterly data: STATISTICS TYPICAL CONSUMER Number of referrals per period (n=n1+ n2) 5 of which, customers that joined due to the referral (n1) 3 of which, customers that would have joined anyway (n2) 2 Marketing cost per period (Mty) $30 Average gross margin (Aty) $78 Cost of referral (aty) $15 Acquisition cost savings (ACQ1ty and ACQ2ty) $10 Yearly discount rate (r) 15% Calculate CRV of a typical customer for one year (over 4 quarters).
E22-11 UrLink Company is a newly formed company specializing in high-speed Internet Prepare and discuss a service for home and business. The owner, Lenny Kirkland, had divided the company into responsibility report. two segments: Home Internet Service and Business Internet Service. Each segment is run by its own supervisor, while basic selling and administrative services are shared by both segments. Lenny has asked you to help him create a performance reporting system that will allow him to measure each segment's performance in terms of its profitability. To that end, the following information has been collected on the Home Internet Service segment for the first quarter of 2017. (LO 2, 3), AP 04 22 Budgetary Control and Responsibility Accounting Budget $25,000 Actual Service revenue Allocated portion of: Building depreciation Advertising Billing Property taxes Material and supplies Supervisory salaries Insurance Wages Gas and oil $26,200 11,000 5,000 3,500 1,200 1,600 9,000 4,000 3,000…
Using the Microsoft 10K for the Fiscal Year ended June 30, 2018 to answer questions: 1. Interpret the results of 2018 "above the line" compared to 2017 "above the line" and then 2017 "below the line" and 2017 "below the line". 2. What is the revenue and cost streams of MSFT using the 10K. How are the costs allocated between the product and service streams? 3. What are the revenue recognition policy of MSFT?4. What are some examples of the revenue recognition for each area as mentioned in the report?5. What is the EBIT and EBITDA for MSFT for 2018 and 2017? How did you calculate this? 6. Using the MSFT financial statements, what is the variance for the balances listed below). The answer must include: % change from 2017 to 2018$ change from 2017 to 2018please state whether it is a favorable or unfavorable variance from 2017 to 2018 Cost of services Selling, general, administration and other Gross Profit of services Gross Profit of products 7. In the financial statement, what is the…
account_circle Business AccountingQ&A Library. SureNa Division will use the Product81 to produce Product2ndSem and sell to large multinational companies. Furthermore, the SureNa Dvision is operating at 50% capacity. The following is the breakdown of costs of Product2ndSem: Purchased from outside supplier............................................... P22.50 Product81 from PasadoBa Division............................................. . SureNa Division will use the Product81 to produce Product2ndSem and sell to large multinational companies. Furthermore, the SureNa Dvision is operating at 50% capacity. The following is the breakdown of costs of Product2ndSem: Purchased from outside supplier............................................... P22.50 Product81 from PasadoBa Division............................................. close Get live help whenever you need from online tutors!Try bartleby tutor todayarrow_forward Question You are the manager of…
can u make like this in excel, and correct this two highlighted digit should have the same result COST AD (annual) F&F = 119,000 12760 M&E = 112,120 13390
ezto.mheducation.com/ext/map/index.html?_con%3Dcon&external_browser=D0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghm Assume the following (1) contribution margin = $150,0000 (2) net operating income $15,000, and (3) sales increase by 14%. Given these three assumptions, net operating income will increase by: Multiple Choice 15 1%. 14%. 116. 140%. < Prev 15 of 50 Next 2 Search for anything
e 1 of 16)- Google Chrome om/mod/quiz/attempt.php?attempt3D1893419&cmid%3891193 NG SYSTEM (ACADEMIC) erial Accounting - Spring21 %3 Time left 1:58:1 Company XYZ has three products A, B and C. The sales mix for products A, B and C are 7,5 and 4 units respectively. The contribution margin per unit for products A, B and C are $900, $600 and $400 respectively. Assuming that the fixed costs were $2,272,000. What is the breakeven point in units (in total)? (rounded to the nearest number) O a. None of the given answers O b. 1,641 O c. 6,745 O d. 3,335 O e. 800 The contribution margin ratio is 50%. If total fixed costs are $21.000, then what is the total cost ($) of producing and
Problem 11-19 (Algo) Comparison of Performance Using Return on Investment (ROI) [L011- Comparative data on three companies in the same service industry are given below. Required: 2. Fill in the missing information. (Round the "Turnover" and "ROI" answers to 2 decimal places.) Company A Sales $ 3,910,000 2$ 1,878,000 Net operating income $ 469,200 356,820 Average operating assets Margin $ 1,700,000 $ 2,660,000 4 % Turnover 1.50 Return on investment (ROI) 11.40 %
Chapter 12: Applying Excel: Exercise (Part 2 of 2) (Algo) 2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: Use Exhibit 128-1 and Exhibit 128-2. (Use appropriate factor(s) from the tables provided.) A B. Chapter 12: Applying Excel 2 Data 4 Example E Cost of equipment needed 430,000 45,000 35,000 20,000 6. Working capital needed Overhaul of equipment in four years 8. Salvage value of the equipment in five years $4 9. Annual revenues and costs: 435,000 10 Sales revenues 11 Cost of goods sold 245,000 Out-of-pocket operating costs %24 50,000 12 13 Discount rate 17 %
ageNOWv2 | Online teachin X + m/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress... If a business had sales of $3,894,000 and a margin of safety of 20%, the break-even point in sales dollars was Oa. $778,800 Ob. $3,115,200 Oc. $7,009,200 Od. $4,672,800
Kentfield Advisory Services (KAS) is a large management consulting firm organized into two groups: Governmental Services (GS) and Commercial Support (CS). Corporate information technology (IT) services support both groups. The cost of computer support is $47 million. The following information is given: Governmental Services Commercial Support Utilization Revenues ($000) $ 241,400 438,600 Required A Required: a. What is the cost charged to each group if the allocation is based on the utilization? b. What is the cost charged to each group if revenue is the allocation basis? c. Most of the business in Commercial Support is priced on a fixed fee basis, and most of the work in the Governmental Services Department is priced on a cost-plus fixed fee basis. Will the allocation base selected affect the amount of revenue? Complete this question by entering your answers in the tabs below. Required B Required C 43% Governmental services Commercial Support 57 What is the cost charged to each group…