Premium Essay

Salem Data Servics

In: Business and Management

Submitted By Hebron8653
Words 609
Pages 3
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 variable cost with respect to revenue hours.

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

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

Free Essay

Human Servics

...information by either doing surveys or by using information that you have gathered throughout you life span. Proper planning is done by following a step-by-step approach to building a reliable proposal. Planning also shows how the risks we take will assess the service delivery. Each step in the planning process will have its own component in the body of the proposal. Program evaluation is Program evaluation is the application of different social research designs in assessing the needs and results of programs. Evaluative research utilizes various research designs including exploratory, descriptive, and experimental designs (Yuen/Terao, 2003). The program evaluation provides both the formative and summative data that could be used to measure and assess the desirability and quality of the plan and its program (Yuen/Terao, 2003). With the evaluation it’s going to run parallel to the program planning. If the planning doesn’t work then how are we going to do an evaluation on it? The evaluation will coincide with the planning. It will also assess the needs of the program because it will show how the program is doing. What needs to be fixed or what can be changed to make things better. The political aspect in program planning can be tricky. Political economy is the interaction and dynamic between politics and economic interests (Yuen/Terao, 2003). I can foresee problems with funding because of political......

Words: 607 - 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

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

Free Essay

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

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

Esportes | 2x3 season x episode Future Man | [ACESSE COMANDOTORRENTS COM] Bohemian Rhapsody 2018 [HDCAM] [720p] [DUBLADO]