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

Premium Essay

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

Premium Essay

Salem

...tedious task and forced MOP to have 16 order entry operators on staff. In 1999, MOP introduced an electronic data interchange (EDI) system and implemented a new internet site in 2000. This allowed customer orders to arrive automatically so the clerks would not have to manually enter the data. With the EDI system, order entry operators only had to quickly verify the customer’s order for accuracy. This saves a tremendous amount of time, regardless of the order size. Next, there are two ways MOP shipped the product(s) to its customer, commercially or desktop delivery. For commercial shipments, MOP would use a third party freight forwarder and incur the applicable cost. This cost was incorporated in the mark up of the product. The cost of the carton shipped commercially did not vary much by weight or distance. For desktop deliveries, MOP would send one of their truck drivers to the customer. MOP added a 5% premium mark up for convenience. MOP had to hire 4 truck drivers and incur delivery truck expenses to provide this service, but avoided any commercial shipping charges. Desktop deliveries averaged three hours, but could take as little as 30 minutes or as long as eight hours. After understanding the key issues, Dunhill and Cunningham wanted to get a better understanding of the cost drivers associated with processing the product. Through interviews, sample data, and MOP’s income statement we identified several cost drivers affecting MOP’s profitability. First we......

Words: 1858 - Pages: 8

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. Alternatives Flores is contemplating asking Wu to estimate the effects on profit from increasing price to customers; not including Salem, reducing price, and increasing sales efforts. 1) Which expenses are variable and which are fixed with respect to revenue hours Fixed cost in respect to revenue hours: Rent ($8,000) Custodial services......

Words: 613 - Pages: 3

Premium Essay

Salem Telephone Data Corp

...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 Company from Salem Data Services warrants the need to re-evaluate Salem Data Services and continue......

Words: 2617 - Pages: 11

Premium Essay

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

Premium Essay

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

Premium Essay

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

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

Premium Essay

Salem Case

...1. “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. To find......

Words: 771 - Pages: 4

Premium Essay

Salem Witch

...Salem Revisited In 1692, the town of Salem Massachusetts turned on each other. They accused their own neighbors of witchcraft. Between June and September of 1692, nineteen people were unjustly executed by hanging, one crushed to death by stones, and many more incarcerated after trials had found them guilty of acts of sorcery. The trials have been researched and looked at many different ways for years. Scholars and students alike continue to be intrigued by the trials and continue to seek answers for how a small town could do this to itself. Every scholarly discipline contributes to what could be the possible answer from ergot poisoning to the psycho-social factor among Africans and American Indians. The road that leads to Salem comes from Europe where witch-hunts rose and fell. The reasons behind the trials themselves are complex. While economics, socioeconomic class issues, tainted food supply, property disputes, and congregational feuds are all listed as causes, the clergy and its congregation are what fueled the accusations and thereby deaths of many town citizens. Witchcraft and sorcery have long attracted the attention of historians and other scholars with the spotlight aimed at 14th-17th century Europe. During the 14th-17th centuries, thousands were executed but to try to be a number to it would be futile. There have been those who have been able to calculate those executed for witchcraft in small towns but the sheer number of countries a part of the craze makes it...

Words: 2452 - Pages: 10

Premium Essay

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

Premium Essay

Salem

...Salem Telephone Company | Accounting 5302 | | Summary: Salem Data Services is a subsidiary of Salem Telephone Company. In this report we analyze and discuss the impact of Salem Data Services on its parent company and determine the best course of action for Salem’s Management to undergo. Expenses: We analyzed the expenses of Salem Data Services to better understand their cost structure and determined their variable and fixed expenses. We used the fact that revenue hours are the cost driver for Salem Data Services to determine variable expenses. We concluded power and hourly staff expenses to be variable because the per revenue hour cost is constant as revenue hours vary. | Variable | Fixed |   | - Power- Operations: Hourly Personnel | - Space Costs Rent Custodial services | |   |   | | - Equipment Costs (less Power) Computer Leases Maintenance Depreciation Computer Equipment Office Equipment and fixtures |   |   | | - Operation: Salaried Staff | |   |   | | - Systems Development & Maintenance |   | | - Administration | |   |   | | - Sales | | |   |   | | - Sales Promotions | |   |   |   | - Corporate Services |   |   | We further analyzed variable expenses to determine their cost per revenue and its impact on the total variable cost and contribution margin. Power | January | February | March | Total | Cost/hour | Sales | $1546 | $1485 | $1697 |......

Words: 730 - Pages: 3

Premium Essay

Salem Data Servics

...1. Why did Salem Telephone Company form Salem Data Services? The company was formed to perform data processing for Salem Telephone Company and also sell these services to other customers, because Telephone service is a regulated utility the profits from unregulated data processing services could be used to off-set costs of providing telephone service at regulated prices. This logic was approved by the Public Service Commission as long as the two companies were separate. 2. How long does it take a start-up company to become profitable? The time period for a startup to become profitable is the same as the time it takes the company to develop sales/ revenue, which create enough total contribution margin to cover the fixed costs of the business 3. "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? Variable Expenses Power Operations: Hourly Personnel Fixed Expense Space Costs: Rent Custodial Services Equipment Costs Computer Leases Maintenance Depreciation Computer Equipment Office Equipment & Fixtures Wages & Salaries Operations: Salaried Staff Systems development and maintenance Administration Sales Sales Promotion Corporate Services 4. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour. Calculate the total......

Words: 609 - Pages: 3

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

Words: 1179 - Pages: 5