Salem Telephone Break-Even Analysis

Good Essays
Through our study of Salem Telephone Company (STC), we’re going to analyze whether or not Salem Data Services (SDS) will be a profitable business to keep. We will do so by utilizing break even analysis. Before we can find our solution, we should discuss Salem Data Services’ (SDS) accounting report step by step.
To begin, the various costs incurred to SDS should be grouped into either variable, or fixed. The only variable costs that have any relation to the total revenue hours listed from exhibit 2 are “power” and “Operations: hourly personnel.” Other expenses listed are fixed costs.
Now, we have our data to calculate unit variable cost per revenue hour. | January | February | March | Power | 1546 | 1485 | 1697 | Operations: hourly personnel | 7896 | 7584 | 8664 | Total Variable Cost | 9442 | 9069 | 10361 | Total Revenue Hours | 329 | 316 | 361 | Variable Costs per revenue hour | $ 28.70 | $ 28.70 | $ 28.70 |

The “contribution margin” income statement for SDS therefore is,

Break even analysis: Based on the assumptions above, the number of commercial revenue hours needed to break even is as follows:
(205 * 400 + x *800) -28.7 * (205+x) – 212939=0
82000 + 800x - 5884 - 28.7x - 212939=0
X = 212939 – 82000 + 5884 = 177.39 800-28.7

SDS needs to serve roughly 178 commercial hours to break even.

What if analysis: if commercial price is increased to $1000, the demand reduces
30%. The resulting effect on net income will be:
X = 138 * (1-0.3) = 97
(205 * 400 + 97 * 1000) – 28.7 – (205+97) – 212939 = ($42,606)

If commercial price is reduced to $600, the demand increases
30%. The resulting effect on net income will be:
X = 138 * (1+.03) = 180
(205 * 400 + 180 * 600) – 28.7 – (205+180) – 212939 = ($33,989)

Increased promotion would increase revenue hours by up to 30%
How much could be spent and still leave SDS with no reported losses each month?
X = 138 * (1+.03) = 180

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Salem Telephone

    • 498 Words
    • 2 Pages

    1. “Revenue hours” represent the key activity that drives costs at Salem Data Services. Which expenses in Exhibit 2 are variable with respect to revenue hours? Which expenses are fixed with respect to revenue hours? a. Variable Expenses – Wages for Hourly Personnel, Power b. Fixed Expenses – Wages for Salaried staff, Systems development and maintenance, Administration 2. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour.…

    • 498 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Salem Telephone

    • 903 Words
    • 4 Pages

    HBS case – Salem Telephone Company Opening In 2000 the Public Service Commission (PSC) was informed by the president of Salem Telephone Company (STC) that a profitable computer service subsidiary would reduce pressure for increases to telephone rates. With approval from the Public Service Commission, STC, a regulated public utility, established Salem Data Services (SDS) in 2001, an unregulated public utility to perform data processing for the telephone company and additionally to sell computer…

    • 903 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Salem Telephone

    • 704 Words
    • 3 Pages

    Salem Telephone Company 1. With respect to the revenue hours the expenses, power and operations: hourly personnel are the variable expenses. Rent, custodial services, Computer leases, Maintenance, Depreciation, Salaried staff, administration, sales, sales promotions, corporate services and systems development and maintenance expenses can be treated as fixed costs. 2. Costs per revenue hours for the Variable expenses power and operations hourly personnel are as follows Expenses | Jan…

    • 704 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Break even Analysis

    • 1590 Words
    • 7 Pages

    Break even analysis is an important part in production management and decision making. In this assignment, the key elements of the break-even analysis will be discussed. The key elements of break-even analysis are fixed cost, variable cost, total revenue, break-even point and margin of safety. Although break-even analysis is very useful, it has disadvantages. Break-even analysis is based on the production cost of the company which includes the fixed cost and variable cost. Then the total cost of…

    • 1590 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    Salem Telephone

    • 1067 Words
    • 3 Pages

    Salem Telephone Company – Salem Data Services Dear Mr. Flores, The objective of our engagement was to analyze Salem Data Services’ (SDS) operations to determine if this is a viable business with potential for growth and future profit or whether the business is likely to remain unprofitable and should be divested. A review of Salem Data Services’ utilization metrics for the first quarter of 2004 has helped us pinpoint the crux of SDS’s unprofitability over this three month span. Underutilization…

    • 1067 Words
    • 3 Pages
    Powerful Essays
  • Satisfactory Essays

    Salem Telephone

    • 490 Words
    • 2 Pages

    Salem Telephone Company ("STC") Question 1 Variable Costs Equipment costs: Power Wages and Salaries: Operations hourly personnel Fixed Costs Space costs: Rent, custodial services Equipment costs: Computer leases, maintenance, depreciation of computer equipment and office equipment / fixtures Wages and Salaries: Operations salaried staff, systems development and maintenance, administration, and sales Sales promotions Corporate services The group actively debated fixed…

    • 490 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Break Even Analysis

    • 3053 Words
    • 13 Pages

    is the Break even. The Break even point is the point at which revenue is exactly equal to costs. At this point, no profit is made and no losses are incurred. The break even point can be expressed in terms of unit sales or dollar sales. That is, the break even units indicate the level of sales that are required to cover costs. Sales above that number result in profit and sales below that number result in a loss. The break even sales indicate the dollars of gross sales required to break even. The determination…

    • 3053 Words
    • 13 Pages
    Powerful Essays
  • Satisfactory Essays

    Break Even Analysis

    • 520 Words
    • 2 Pages

    a) What is Break Even point? Break even point is the point at which income and expenses of are totally equal. So the business has not made any profit or any loss at this point. But when it comes to the total value of expenses is higher than total profit, the organization will suffer losses. Losses will result the opposite effect of profits. An organization that suffer losses may be forced to decrease their operational output. The reduction may consist of reducing their employees, shutting down their…

    • 520 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Break Even Analysis

    • 550 Words
    • 3 Pages

    Break Even Analysis A break even analysis is a method used widely by businesses to assist them with finance. The break even analysis shows a business when their amount of revenue is equal to their costs. This is known as the break-even point. Although the break even analysis shows many other things, this is the main thing companies look out for when composing a break even graph. The break even analysis is very important to businesses as it a way of measuring their success over a certain period of…

    • 550 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Break Even Analysis

    • 758 Words
    • 4 Pages

    Break Even Analysis University of Phoenix Accounting in Healthcare ACC561 November 26, 2010 Break Even Analysis Relevance of DRG Analysis as a Tool in Healthcare DRG analysis helps managers in health care determine levels of service at which to operate and to break even as well as avoid any loses. Using the DGR analysis, management will be able to determine the appropriate levels at which to operate making the most of any profits (Steven, & David, 2000). The management team of…

    • 758 Words
    • 4 Pages
    Good Essays