Salem Telephone Company Case Analysis

Topics: Variable cost, Costs, Revenue Pages: 8 (1271 words) Published: February 16, 2015

Peter Flores, president of Salem Telephone Company (STC) informed the Public Service Commission “that a profitable computer service Subsidiary would reduce pressure for the telephone rate increase.” And a result, Salem Data Services (SDS) was established. In 2003, SDS has “yet to experience a profitable month” and this induced the meeting between Peter Flores and Cynthia Wu, manager of SDS in April 2004. Flores and Wu held different views in regards to SDS; Flores felt SDS was draining STC resources and is questioning the ability of SDS to be a profitable business. Wu felt that SDS had the ability to show profits in the near future. To adequately prepare Flores, president of STC for his meeting with Wu, he assigns a task to a team of managerial accounting consultants to prepare a detailed analysis, which will aid in discussion with Wu. Action Plan

1. To conduct a cost analysis to determine the main cost activities for SDS; this will include fixed cost and variable cost. 2. To conduct a revenue analysis to determine cost per revenue. 3. To construct a detailed Contribution Margin Income Statement for SDS. 4. To present a Break-Even analysis

5. To use What-If analysis to show the impact of increasing and decreasing commercial prices and promotion. 6. To make specific recommendation based on quantitative data to Flores, president of STC whether or not SDS will produce a profit. Question 1

Based on Exhibit 2 the expenses incurred by Salem Data Services (SDS) fall into two categories- fixed expenses and variable expenses. The variable costs with respect to revenue hours are: Power
Operations: hourly personnel
Fixed costs with respect to revenue hours are:
Space costs:
Custodial Services
Equipment costs
Computer leases
Depreciation: Computer equipment and office equipment and fixtures. Wages and Salaries:
Operations: Salaried Staff
System development and maintenance
Sales promotion
Corporate services
Question 2
From Exhibit 2, one can see that the only variable expenses listed are Power, under Equipment Costs, and Hourly Personnel Wages, under Wages and Salaries. Using these figures and dividing them by total Revenue hours we get from Exhibit 1, we see that Variable cost per hour remained constant throughout the first quarter of 2004.

Power (Exhibit 2)
Total Revenue Hours (Exhibit 1)
Variable Cost Per Hour

Hourly Personnel Wages (Exhibit 2)
Total Revenue Hours (Exhibit 1)
Variable Cost Per Hour

Total Variable Cost

Question 3
Below is a Contribution Margin Income Statement for Salem Data Services; the format allows Flores to analysis the main feature, which is the contribution margin total. The significance of this number to Flores is shows how much money is available to pay fixed costs and ultimately provides a net income figure. Here, we see that SDS has a total contribution margin of 182,555.90 and a negative net income of $-30,383.10.


Intracompany Sales
Commercial Sales
Total Revenue
Variable Costs

Equipment Cost: Power
Wages and Salaries: Operations: Hourly Personnel
Total Variable Cost
Contribution Margin
Fixed Costs

Custodial Services
Computer Leases
Depreciation: Computer Equipment
Depreciation: Other Equipment and Fixtures
Operations: Salaried Staff
System Development and Maintenance
Sales Promotion
Corporate Service
Total Fixed Cost
Net Income

Question 4
Profit=SP (x) – VC (x) – TFC
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Salem Telephone Company Case Analysis
  • Salem Telephone Company Case Study Essay
  • Salem Telephone Company Case Study Essay
  • Salem Telephone Company Case Study Essay
  • Salem Telephone Company Essay
  • Salem Telephone Company Accounting Case Research Paper
  • Essay on Salem Telephone Case
  • Essay on Salem Telephone Company

Become a StudyMode Member

Sign Up - It's Free