Salem Telephone Data Corp

In: Business and Management

Submitted By kjt1994
Words 2617
Pages 11
Table of Content

Executive Summary 1
Background 2
Analysis 3
Recommendations 4
Appendix A- Summary of Computer Utilization 5
Appendix B- Summary Results of Operations, First Quarter 2004 6
Appendix C- Variable and Fixed Cost in respect to revenue hours 7
Appendix D- Breakdown of Variable Cost per Hour Usage 8
Appendix E- Contribution Margin Income Statement, March 2004 9
Appendix F- Contribution Margin Ratios 11
Appendix G- Break-even Analysis 12
Appendix H- “What if” Analysis 13 Executive Summary

Since 2001, Salem Data Services has been operating at a net loss. After review the reports from first quarter 2004, it has become apparent that action will be necessary. Through our examination of the first quarter 2004 reports, we have concluded three key areas to focus on. These include utilization of computer usage hours, how the results of the operations have been unprofitable, and how sales promotions are not tied to current levels of work. Our analysis begins with careful inspection of the variable and fixed costs of Salem Data Services. It is clear the variable costs equaling $32,640, do not contribute enough to covering the total fixed costs of $189,620. The other focus of the analysis lies in the re-evaluating the usage hours available for Commercial Sales. Currently the level of Commercial Sales is under utilized. Available hours need to be maximized to eliminate the current loss and begin to show growth and profit. 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…...

Similar Documents

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. If Salem......

Words: 1223 - Pages: 5

Salem Telephone Case Study

...800 | $53,800 | 53,800 | TOTAL FC | $189,620 | $189,620 | $189,620 | 2) Cost per Revenue Hour for Variable Expenses: Revenue Hours> | January329 | February316 | March361 | Power | $1546 | $1485 | $1697 | Cost/Revenue Hr. | $4.70/hr. | $4.70/hr. | $4.70/hr. | Hourly Personnel | $7896 | $7584 | $8664 | Cost/Revenue Hr. | $24/hr. | $24/hr. | $24/hr. | Corporate Services | $15,424 | $15,359 | $15,236 | Cost/Revenue Hr. | $46.88 | $48.60 | $42.20 | Sales Promotions | $7,909 | $7,039 | $8,083 | Cost/Revenue Hr. | $24.04/hr. | $22.28/hr. | $22.39/hr. | 3) Contribution margin income statement for Salem Data Services Assumption: Intra company usage=205 hours; Commercial usage for March=138 hours Revenue Hours Intra company: 205 Commercial: 138 Total Revenue Hours: 343 Salem Data Services Income Statement | | Revenues | | Intra company sales | $82,000 | Commercial Sales | 110,400 | TOTAL REVENUE | $192,400 | | | LESS Variable Expenses | | Power | $1612.10 | Hourly Personnel | 8,232 | Corporate Services | 14,474.60 | Sales Promotions | 7,679.77 | TOTAL VARIABLE COSTS | $31,998.47 | CONTRIBUTION MARGIN | $160,401.53 | | | LESS FIXED EXPENSES | | Space costs | | Rent | $8,000 | Custodial services | 1,240 | Equipment costs | | Computer leases | 95,000 | ......

Words: 928 - Pages: 4

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. The fixed expenses with respect to revenue include, Space costs, Equipment costs, depreciation expense, Salaried staff, system development and maintenance, administration and sales. 2) Salem Data Services First Quarter 2004 Summary of Computer Utilization | |January |February |March |Total Qtr | |Number of Weekdays (M-F) |22 |20 |23 |65 | |X 24 hours per day |528 |480 |552 |1560 | |Number of Saturdays |5 |4 |4 |13 | |X 8 hours per day |40 |32 |32 |104 | |Total hours available for revenue |568 |512 ...

Words: 1002 - Pages: 5

Salem Telephone Company

...Through our study of Salem Telephone Company (STC), we’re going to answer that if Salem Data Services (SDS) is really a profitable business to keep by using break-even point analysis. Before we come out the final solution, let’s discuss SDS’ accounting report step by step. First, we have to divide the various costs incurred in SDS into two types: variable costs and fixed costs. From Exhibit 2 we can see that only “Power” and “Operations: hourly personnel” are variable costs that have relation to the total revenue hours. Other expenses listed in Exhibit 2 are all fixed costs (Q1). Besides, we can calculate the unit variable costs per revenue hour as follows (Q2): January February 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 Furthermore, by distinguish the variable costs and fixed costs, we can construct the contribution margin income statement for SDS at March level, assuming 205 hours for intracompany usage (Q3): Revenues Intracompany 82,000 Commercial 110,400 Total Revenues 192,400 Variable expenses (power + hourly personnel) 9,844 Contribution margin 182,556 Fixed expenses Rent 8,000 Custodial services 1,240 Computer leases 95,000 Maintenance 5,400 Depreciation 26,180 Salaried staff 21,600 System development 12,000 Administration 9,000 Sales 11,200 Sales promotion 8,083 Corporate services 15...

Words: 753 - Pages: 4

Salem Telephone Case Study

...Salem telephone case 1. ”Revenue hours” represent the key activity that drives costs at Salem Data Service . Which expenses in Exhibit 2 are variable with respect to revenue hours? Which expenses are fixed with respect to revenue hours? A : Variable costs : The power, hourly personal. Fixed costs : The rent, custodial service, computer leases, maintenance, computer equipment, office equipment and fixtures, salaried staff, system development and maintenance, administration, sales promotion, Corporate service. 2. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour. A : | |January |February |March | |Total revenue hours |329 |316 |361 | |Power |1546 |1485 |1697 | |Hourly personal |7896 |7584 |8664 | |Variable cost per revenue hour |28.699 |28.699 |28.700 | 3. Create a contribution margin income statement for Salem Data Service. Assume that intracompany usage is 205 hours. Assume commercial usage at the March level. A : From the text, we know...

Words: 995 - Pages: 4

Salem Telephone

...Managerial Accounting Case Study 1: Salem Telephone Company 96122050 96122051 96122052 96122073 96122085 96122088 96122092 Group 1 Through our study of Salem Telephone Company (STC), we’re going to answer that if Salem Data Services (SDS) is really a profitable business to keep by using break-even point analysis. Before we come out the final solution, let’s discuss SDS’ accounting report step by step. First, we have to divide the various costs incurred in SDS into two types: variable costs and fixed costs. From Exhibit 2 we can see that only “Power” and “Operations: hourly personnel” are variable costs that have relation to the total revenue hours. Other expenses listed in Exhibit 2 are all fixed costs (Q1). Besides, we can calculate the unit variable costs per revenue hour as follows (Q2): January 1,546 7,896 9,442 329 28.70 February 1,485 7,584 9,069 316 28.70 March 1,697 8,664 10,361 361 28.70 Power Operations: hourly personnel Total variable costs Total revenue hours Variable costs per revenue hour Furthermore, by distinguish the variable costs and fixed costs, we can construct the contribution margin income statement for SDS at March level, assuming 205 hours for intracompany usage (Q3): Revenues Intracompany 82,000 Commercial 110,400 Total Revenues 192,400 Variable expenses (power + hourly personnel) 9,844 Contribution margin 182,556 Fixed expenses Rent 8,000 Custodial services 1,240 Computer leases 95,000 Maintenance 5,400 Depreciation 26,180 Salaried......

Words: 778 - Pages: 4

Salem Telephone

...Salem Telephone Company Managerial Accounting Case Study 1: Salem Telephone Company 96122050 96122051 96122052 96122073 96122085 96122088 96122092 Group 1 Through our study of Salem Telephone Company (STC), we’re going to answer that if Salem Data Services (SDS) is really a profitable business to keep by using break-even point analysis. Before we come out the final solution, let’s discuss SDS’ accounting report step by step. First, we have to divide the various costs incurred in SDS into two types: variable costs and fixed costs. From Exhibit 2 we can see that only “Power” and “Operations: hourly personnel” are variable costs that have relation to the total revenue hours. Other expenses listed in Exhibit 2 are all fixed costs (Q1). Besides, we can calculate the unit variable costs per revenue hour as follows (Q2): January 1,546 7,896 9,442 329 28.70 February 1,485 7,584 9,069 316 28.70 March 1,697 8,664 10,361 361 28.70 Power Operations: hourly personnel Total variable costs Total revenue hours Variable costs per revenue hour Furthermore, by distinguish the variable costs and fixed costs, we can construct the contribution margin income statement for SDS at March level, assuming 205 hours for intracompany usage (Q3): Revenues Intracompany 82,000 Commercial 110,400 Total Revenues 192,400 Variable expenses (power + hourly personnel) 9,844 Contribution margin 182,556 Fixed expenses Rent 8,000 Custodial services 1,240 Computer leases 95,000 Maintenance 5,400......

Words: 340 - Pages: 2

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. Their fixed expenses for revenue hours are rent, custodial services, computer leases, maintenance, depreciations of computer and office equipment and fixture, operations salaried staff, system development and maintenance, administration, sales, sales promotion and...

Words: 773 - Pages: 4

Salem Telephone Company

...Salem Telephone Company • • • • C.V. Hareesh Naidu V.Venkata Surya Teja B. Asheesh Kumar M. Rohit Kumar 186 168 032 Salem Telephone Company • Subsidiary : Salem Data Services • Data processing service provider for the telephone company. • Sell computer services to other companies. • Initially started to reduce telephone rate hikes. • Currently running in losses • Mr. Flores wished to have a wholly owned entity rather than a public utility company. • Average monthly charge for services by the subsidiary to parent should be less than $82,000 Problems • • • • Delayed equipment deliveries. Higher salary expectation by the personnel. Hard to find customers than expected. Lowest return on investment in 7 years. Fixed and Variable Costs of Salem Data Services Fixed Costs: o Rent o Custodial services o Computer leases o Maintenance o Computer equipment and fixtures o Salaried staff o Systems development and maintenance o Administration o Sales o Sales promotion o Corporate services Variable Costs: o Power o Hourly personnel • Power: Costs($) Cost per revenue hour for each variable expense January 1546 329 4.7 February 1485 316 4.7 March 1697 361 4.7 Total revenue hours Cost per revenue hour($ per hour) • Hourly Personnel: January Costs($) Total revenue hours Cost per revenue hour($ per hour) 7,896 329 24 February 7,584 316 24 March 8,664 361 24 Contribution margin intra company Usage(hours) Selling price per hour($) total sales......

Words: 453 - Pages: 2

Salem Telephone Company

...Salem Telephone Company • • • • C.V. Hareesh Naidu V.Venkata Surya Teja B. Asheesh Kumar M. Rohit Kumar 186 168 032 Salem Telephone Company • Subsidiary : Salem Data Services • Data processing service provider for the telephone company. • Sell computer services to other companies. • Initially started to reduce telephone rate hikes. • Currently running in losses • Mr. Flores wished to have a wholly owned entity rather than a public utility company. • Average monthly charge for services by the subsidiary to parent should be less than $82,000 Problems • • • • Delayed equipment deliveries. Higher salary expectation by the personnel. Hard to find customers than expected. Lowest return on investment in 7 years. Fixed and Variable Costs of Salem Data Services Fixed Costs: o Rent o Custodial services o Computer leases o Maintenance o Computer equipment and fixtures o Salaried staff o Systems development and maintenance o Administration o Sales o Sales promotion o Corporate services Variable Costs: o Power o Hourly personnel • Power: Costs($) Cost per revenue hour for each variable expense January 1546 329 4.7 February 1485 316 4.7 March 1697 361 4.7 Total revenue hours Cost per revenue hour($ per hour) • Hourly Personnel: January Costs($) Total revenue hours Cost per revenue hour($ per hour) 7,896 329 24 February 7,584 316 24 March 8,664 361 24 Contribution margin intra company Usage(hours) Selling price per hour($) total sales......

Words: 453 - Pages: 2

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. Also, in 2003 STC’s income was at an......

Words: 1387 - Pages: 6

Salem Telephone Company

...Case Study #1. Salem Telephone Company 1. Variable expenses: Power (the more hours sold, the more energy consumed) The hourly personnel (operations) works only when the computers are in operation Fixed expenses: The rent has to be paid despite any level of production ($8,000 monthly) The custodial services depend on Salem Telephone's estimated space, they are independent from the revenue of the Company The computer leases were acquired to run the business (before it was actually started up) The maintenance is necessary even when you do not produce/sell anything The deprecation depends on the number of years not on the number of hours sold Operations: salaried stuff consists of the six people necessary to run the center (the number of people remains the same) Systems development and maintenance the system needs to be developed and maintained constantly to keep the work in process Administration: the salaries are paid on a fixed regular basis Sales promotion: there is a certain amount of money that has been allocated on advertising Corporate services are independent from revenue (are obtained when needed) Sales (should equal an estimated amount) 2 2. January 1,576 7.896 329 4.7 March 4,485 7,584 316 4.7 February 1,697 8,664 361 4.7 24 24 24 28.7 Power Hourly personnel Total Rev. hours VC/Revenue hour (Power) VC/ Revenue hour (personnel) Total Variable Cost/ hour 28.7 28.7 Variable cost per revenue......

Words: 901 - Pages: 4

Salem Data

...   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 ......

Words: 407 - Pages: 2

Salem Telephone Case Study

...Salem Telephone Company Case Study 1. Variable Expenses with respect to revenue hours: Power expense, hourly personnel salaries expense. Fixed expenses with respect to revenue hours: Rent, custodial services, computer leases, maintenance, depreciation of computer equipment and office equipment and fixtures, operations salaried staff, systems development and maintenance, administration, and sales, sales promotions, corporate services. 2. Units: dollars per hour January February March Power expense 4.7 4.7 4.7 personnel salaries expense 24 24 24 Total Variable cost per revenue hour 28.7 28.7 28.7 3. Income statement for Salem Data Services From the article, I know that intracompany work was billed at $400 per hour, and commercial sales were billed at $800 per hour. So, intracompany contribution margin: $400-$28.7= $371.3/hr Commercial contribution margin: $800-$28.7=$771.3/hr Sales revenue $192,400 Variable cost $9844.1 Contribution margin $182,555.9 Fixed cost $212,939 Net loss ($30,383.1) 4. Revenue = Variable Costs + Fixed Costs 205(400) + X (800) =(X+205) (28.7) +212,939 X= 177.39 commercial hours sold to break-even 5. Original March: P= Net Income= ($23,700) For option 1: P=205(400)+1000(96.6)-301.6(28.7) -212,939= -42,994.92 For option 2: P=205(400) +600(179.4)-384.4(28.7) -212,939= -34,331.28 For option 3: P=205(400) +800(179.4)-384.4(28.7) -212,939 = 1548.72 In conclusion, for option1 and 2, both will decrease in net income. For option3, net income will increase to a......

Words: 1246 - Pages: 5

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. In fact the Data Company had no expenses with...

Words: 1179 - Pages: 5