Free Essay

Salem Data

In: Business and Management

Submitted By ImGeneric
Words 407
Pages 2
Charles Steiner Salem Telephone Company Case Analysis

7 October 2015

1. Using exhibit two, the variable expenses with respect to revenue hours are power and hourly personnel salaries. The fixed expenses are: rent, custodial services, computer leases, maintenance, depreciation of equipment and fixtures, operations salaried staff, systems development/maintenance, administration, sales promotion and corporate services. 2. Power expense for January, February, and March are 4.7 dollars per hour. Personnel salaries expense for January, February, and March are 24 dollars per hour. Total variable cost per revenue hour for all three months is 28.7 dollars per hour. See appendix for calculations (number 2) 3. Salem Telephone Company Income Statement

For the period of March Sales Revenue

$192,400

Less Variable Cost

$9,844.1

Contribution Margin

$182,555.9

Less Fixed Cost

$212,939

Net Loss

($30,383.1)

See appendix for calculations (number 3) 4. With intercompany demand at 205 hours, Salem Data services will need to have at least 177.39 or 178 commercial revenue hours to break even.

See Appendix for calculations (number 4)

5. See appendix for calculations (number 5) Flores suggested three options to Salem Data to increase their bottom line. In option one Flores suggests increasing commercial hourly price to $1000. Factoring in the decrease in demand, the result is a net loss of $42,994.92. In option two, commercial hourly prices would be reduced to $600. Even with the increase in demand, the result is still a net loss of $34,331.28. In option three the resulting increase in demand yields a net income of $1,548.72. This means that the proposed promotion in order to increase demand cannot exceed $1,548.72 for it to be beneficial. These options show the difficulty in turning Salem Data profitable for Salem Telephone.

6. After analyzing Salem Data and various options achieve a net income, I have concluded that it would be best to close Salem Data. Salem telephone would then need to purchase 205 intercompany hours from another company, totaling to $164,000. This is $59,000 less than the roughly $223,000 a month it takes to operate and run Salem data. Salem Data has been operating at a net loss for the three listed months, and would need a lot of work to make profitable. I recommend Salem Telephone to drop Salem Data and purchase their 205 hours from a third party.

Appendix

Similar Documents

Premium Essay

Salem Data Servics

...Create a contribution margin income statement for Salem Data Services. Assume that intracompany usage is 205 hours. Assume commercial usage is at the March level. 6. Assuming the intracompany demand for service will average 205 hours per month, what...

Words: 609 - Pages: 3

Premium Essay

Salem Telephone Data Corp

...We have included data that will prove by increasing Commercial usage hours; the break-even point can be achieved. Overall, we do believe in the ability of Salem Data Services to become a profitable subsidiary of Salem Telephone Company. We do not believe it is necessary to shut down operations or sell Salem Data Services. The opportunity costs from Intra-Company sales and the expenses paid to Salem Telephone...

Words: 2617 - Pages: 11

Premium Essay

Salem Telephone Company Case Study

...Salem Data Services was established as computer data service firm. Flores initially believed that Salem Data Services would be profitable subsidiary for the parent company, Salem Telephone Company. Salem Data Services would perform data processing for Salem Telephone Company as well as sell computer services to other firms. Flores stood by the idea that the subsidiary would lower Salem Telephone Company’s need of increasing telephone rates. Salem Data Services struggled to become a profitable institution after two years of operation. In the recent year, Salem Telephone Company produced the lowest return on investment to shareholders in seven years. While Flores was prepared to re-consider the future of Salem Data Services, the manager Cynthia Wu urged Flores to give the subsidiary company more time, as she believe the firm would begin to show profit soon. This analysis will review the dilemma Peter Flores has faced and provide recommended course of action Flores should take in deciding what to do with Salem Data Services. Using account analysis, we showed that Salem Data Services carry an extremely high fix cost comparing to the variable cost. The fix cost is nearly 95% to the total cost per revenue hour. Variable cost is only accounted for a little over 5% of the total cost per revenue hour. As fix costs do not fluctuate according to revenue, income statement with high fix cost tends to skew the profit result of the company....

Words: 654 - Pages: 3

Premium Essay

Salem Telephone

...Salem Telephone Company – Case Study Summary In 2001 Salem Telephone established a subsidiary, Salem Data Services, for the purpose of performing data processing services for the telephone company and to meet this need for other companies. By 2003 Salem Data Service had finally overcome the problems experienced during startup and was running smoothly but their reporting had yet to show a profitable month. Peter Flores, president of Salem Telephone Company was discouraged by the presented results to date; however he was reluctant to suggest to Cynthia Wu, manager of Salem Data Services, that Salem Data be closed down or sold. He thought that the opportunity to have this subsidiary seemed too good to give up easily. Flores questioned whether the accounting reports truly painted a clear picture of the contribution that Salem Data Services was making to Salem Telephone. In other situations he had reviewed in the past, he felt that the procedure used in accounting for separate activities in the company tended to obscure the costs and benefits they provided. A review of the financial data shows Salem Data with an average monthly operating loss of almost approximately $35,000 in the first quarter. However, if Flores factors in the $82,000 savings Salem Telephone received in March as a result of the $400/hour discount on data services as well as the $8,000 Salem Telephone received in rent from Salem Data, the company still proves itself to be a valuable commodity....

Words: 1223 - Pages: 5

Premium Essay

Salem Telephone

...SUMMARY Salem Telephone Company operates as a regulated public utility. The state Public Service Commission (PSC) permitted Salem to establish a wholly owned subsidiary to provide computer services to other companies for a profit. The reason for the separate entities was so Salem Data Services could sell services unregulated and Salem Telephone could operate without raising rates. In 2000, the initial report to the PSC from the president of Salem Telephone was to convince them that the public entity, Salem Data Services, would become profitable and would end the need to raise telephone rates. By 2003, Salem Data had not turned a profit. Mr. Flores requested a meeting with the manager of Salem Data, Ms. Wu, so some type of action would be taken to “reduce the drain on Salem Telephone Company resources” (Bruns, Jr. & Hertenstein, 2005). The analysis that follows will show that Salem Data Services will not be a problem to Salem Telephone and eventually make a profit by spending more on promotional activities to increase commercial hours, and by moving fixed costs into variable costs. ANALYSIS Salem Data’s variable expenses with respect to revenue hours are power expense and hourly salary....

Words: 773 - Pages: 4

Premium Essay

Salem Telephone Company

...Salem Telephone Company SUMMARY: Peter Flores, President of Salem Telephone Company decided to create a subsidiary in the form of an unregulated data services company called Salem Data Services in 2000. Flores belief was that with the company unregulated it would become a profitable business and prevent the need, in the future, to increase phone rates due to increasing costs at Salem Telephone. Originally the company only provided intra-company services for Salem Telephone, however after management realized that there was a market in the metropolitan area for the computer time that was not used by Salem Telephone they decided to sell it to the commercial market. The only stipulation was that the Public Service Commission restricted the average monthly services charged provided by Salem Data Services to Salem Telephone not to exceed $82,000. DISCUSSION: The company had difficulties at the onset as expected such as finding fewer customers than originally expected. Although this problem was alleviated by 2003, the Salem Data Services remained unprofitable and continued to have a large amount of hours available to sell. As far as pricing, the intrapersonal hours were $400 dollars per hour while the commercial hours were priced at $800 per hour. In addition the Data Company had several costs but many at a discounted rate from what an independent company would pay due to its relationship with the Telephone Company....

Words: 1179 - Pages: 5

Premium Essay

Salem

...Contribution Margin Statement: Salem Data Services |...

Words: 730 - Pages: 3

Premium Essay

Salem Case Study

...Salem Telephone Company Case Study Salem Telephone Company Case Study Introduction Salem Data Service, SDS, is a vital asset to Salem Telephone Company. Even though there are losses occurring, SDS has begun to increase performance and losses have been decreasing over the last several months. Background Salem Telephone Company needed computer services to plan, control, and account for operations so it created Salem Data Service, SDC. Because Salem Telephone Company was a regulated utility, it needed to gain approval for this venture. This new subsidiary would be separate but wholly owned by Salem Telephone Company. Salem Data Service was allowed to compete with other computer service organizations, but it could not charge Salem Telephone Company more than $82,000. Both companies would pay each other for services rendered. Key Problems Revenue and cost data in the quarterly review revealed the lowest return on investment in seven years. Flores is reluctant to shut down or sell SDS, but feels that it is time to reassess SDS profitability. He has scheduled a meeting with Wu to discuss 3 possible scenarios....

Words: 613 - Pages: 3

Premium Essay

Salem Telephone Company Case Study

...With higher fixed cost, Salem Data Services has a higher leverage and is therefore riskier. 2. ($7,896 + $1,546) / 329 hours = $28.70 / hour. For every hour spent working, the company spends 28.70 dollars. 3. Intracompany Commercial Total Number of Hours (a): 205 138 343 Revenue (a x b): $82,000 $110,400 $192,400 Variable Costs (a x c): ($5,883.50) ($3,960.60) ($9,844.10) Contribution Margin: $76,116.50 $106,439.40 $182,555.90 Fixed Costs: ($212,939) Net Income: ($30,383.10) 4. Commercial fixed cost = total fixed cost – intracompany fixed cost CFX = $212,939 – (76,116.50) = $136,822.50 (SP/unit * # of units sold) = (VC/unit * # of units sold) + FC $800x = $28.70x + $136,822.50 $771.3x = $136,822.50 x= 177.39 hours 5....

Words: 430 - Pages: 2

Premium Essay

Precision

...Total revenue hours Hours available to sell The variable cost associated with Salem Data Services are: Item Equipment costs Power Wages and salaries January February March February March 22 20 23 528 480 552 5 40 568 4 32 512 4 32 584 206 123 329 239 181 135 316 196 223 138 361 223 Cost per revenue hour Item Power Operation s:hourly staff Total January $ February March 4.70...

Words: 1405 - Pages: 6

Premium Essay

Salem Case

...“Revenues hours” represent the key activity that drives cost 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? Variable: * Power * Operations: hourly personnel Fixed: * Rent * Custodial Services * Computer Leases * Maintenance * Depreciation: Computer Equipment * Depreciation: Office equipment and fixtures * Operations: salaried staff * Systems development and maintenance * Administration * Sales * Sales Promotion * Corporate Services 2. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour. | Jan | Feb | March | Power | $1,546 | $1,485 | $1,697 | Operations: hourly personnel | $7,896 | $7,584 | $8,664 | Total Variable Costs | $9,442 | $9,069 | $10,361 | Total Revenue Hours | 329 | 316 | 361 | Variable Costs per Revenue Hour | $28.70 | $28.70 | $28.70 | Power per revenue hour | $4.70 | $4.70 | $4.70 | Operation: hourly personnel per revenue hour | $24 | $24 | $24 | Variable Costs per Revenue Hour: (9442/329)= $28.7 Power per revenue hour: (1546/9442) x 28.7 = $4.7 Operation: hourly personnel per revenue hour: (7896/9442) x 28.7 = $24 3. Create a contribution margin income statement for Salem Data Services. Assume that intracompany usage is 205 hours. Assume commercial usage is at the March level....

Words: 771 - Pages: 4

Premium Essay

Salem Telephone Company Accounting Analysis

...I believe Flores should either close down or sell Salem Data Services, unless he believes its intangibles or potential deem it...

Words: 251 - Pages: 2

Premium Essay

Salem Telephone Co

...Salem Telephone Co Case Study #2 Overview: Salem Telephone Company (STC) is a telephone company who is regulated by the state Public Service Commission. The state Public Service Commission encouraged public utilities under its jurisdiction to seek new sources of revenue and profits. This would reduce the need for rate increase that higher costs would otherwise bring. The company formed an agreement with the state Public Service Commission to create a subsidiary. Thus Salem Data Services (SDS) was created to perform data processing for the telephone company and sell computer products and services to other companies and organizations. The separation between the companies is because STC was a regulated utility and SDS is an unregulated company. The only restriction the state Public Service Commission had was the average monthly charges for services provided by SDS to STC is not to exceed $82,000. This was the estimated cost of equivalent services used by STC in the year 2000. With retaining the separation between the two companies all accounts of SDS were separated from STC. Lastly, each company paid the other for services from the other. During April 2004 the president of STC, Peter Flores met with SDS’s manager Cynthia Wu to discuss the condition of the company. SDS currently has yet to have a profitable month, but Wu feels the company is progressing well and needed more time to show profits. This raised a concern for Flores....

Words: 1387 - Pages: 6

Premium Essay

Salem Telephone Case Solutions

...Salem Telephone Case 1) In my opinion the expenses that are variable with respect to revenue hours at Salem Data Services are Power, Hourly personnel, and Sales promotion. I believe these expenses are variable because they change with revenue. Corporate services is a mixed cost and there is not enough information to ascertain the portion that is variable....

Words: 1002 - Pages: 5

Premium Essay

Tqm Master Plann

...Team members: Gary Floss Tom Lynch Jim Naughton Joe Colletti Bob King Gene Miller Pamela Olivier Andre Shambarger Bob Allison Tom Flaherty Mark Finster Ken Karch Mark Shimelonis Control Data Eastman Kodak Expert Knowledge Systems GOAL/QPC GOAL/QPC Goodyear Tire and Rubber Intel Corporation McDonnell Douglas Procter & Gamble Rockwell International University of Wisconsin Weyerhaeuser Xerox Corporation Total Quality Management Master Plan: An Implementation Strategy Executive Summary Total Quality Management Master Plan: An Implementation Strategy What is TQM? Total Quality Management (TQM) is a structured system for meeting and exceeding customer needs...

Words: 10837 - Pages: 44