Essay about Salem Telephone Company

Submitted By GoCeltics34
Words: 1035
Pages: 5
Open Document
ACCT500_ET - MANAGERIAL DECISION SUPPORT
Salem Telephone Company

In this case, the fixed expenses with respect to revenue hours are the following:
Custodial services
Rent
Computer leases
Maintenance
Depreciation of computer equipment, office equipment and fixtures
Operations salaried staff
Systems development and maintenance
Sales promotions
Corporate services
Sales
Sales Promotion
Administration
These are fixed costs because the cost driver revenue hours doesn’t impact them (for instance the rent price stay the same even if there is no sales). But for power expense it has an impact. It is a variable expense with respect to revenue hours as it depends how much the company use electricity and how many time the computers have worked. The hourly personnel salaries expense are also a variable expense with respect to revenue hours as it depends how many hours the staff has worked.
To calculate our cost revenue per hour with have first to calculate the cost per hour of each variable costs for each month:
For January, the power cost will be: $1,546 / 329 = $4.70 the hourly personnel cost will be: $7,896 / 329 = $24.00
For February, the power cost will be: $1,485 / 316 = $4.70 the hourly personnel cost will be: $7,584 / 316 = $24.00
For March, the power cost will be: $1,679 / 361 = $4.70 the hourly personnel cost will be: $8,664 / 361 = $24.00
By those results we can deduct that the cost per revenue hour of the variable costs is:
4.70 + 24 = $28.7 per hour
In the case we saw that intracompany work was billed at $400 per hour, and the commercial sales were billed at $800 per hour. Thanks to those number we are able to calculate our contribution margin and our commercial contribution margin:
Contribution margin: 400 - 28.7 = $371.3 per hour
Commercial contribution margin: 800 - 28.7 = $771.3 per hour
Those results permit us to create an income statement for Salem Data Services assuming that intracompany usage is 205 hours and that commercial usage is at the March level.
Income Statement of Salem Data Service for March 2004
Calculations
Intracompany
82,000
205*400
Commercial
110,400
138*800
Revenues
$192,400

Variable Cost
$9,844.1
1200*28.7
Contribution margin
$182,555.9
Revenues – Variable cost
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,236

Fixed Costs
$212,939

Net Loss
$30,383.1
Contribution margin – Fixed costs

Our net loss is $30,383.1 so let’s try to see the number of commercial sales we need at minimum in order to have no loss, knowing that the maximum number of hours for intracompany sales is already reached. Revenue = variable costs + fixed costs
205 * 400 + x * 800 = (205 +x)*28.7 + 212,939
X = 177.39
So our commercial revenue hours sold to break-even is $177.39
Knowing our break-even point is $177.39 and that we have a net loss several hypothesis will be test below in order to solve our problem:
I. By increasing the price to commercial customers to $1,000 per hour would reduce demand by 30%.
We have a commercial revenue hours of 138. If we apply a 30% decrease in demand, our new commercial revenue hours will be: 138 x 30% = 41.4
The difference between both would be 138 – 41.4 = 96.6 hours
Revenue

Calculation
Intracompany sales
$82,000
205*400
Commercial sales
$96,600
96.6*1000
Variable costs
$8,655.92
301.60*28.70
Contribution Margin
$169,944.08

Fixed Costs
$212,939

Net loss
$42,994.92

If we compare the loss of March with this loss, it will lead to an additional loss of:
42,994.92 – 23,700 = $12,611.92
II. By reducing the price to commercial customers to $600 per hour would increase demand by 30%.
We have a commercial revenue hours of 138. If we apply a 30% increase in demand, our new commercial revenue hours will be: 138 x 30% =
Show More

Related Documents: Essay about Salem Telephone Company

Essay about Salem Case Study

Case Summary Salem Telephone Company, a regulated utility, received permission from the state Public Service Commission to establish Salem Data Services. Salem Data Services would provide data processing services for the telephone company as well as outside companies. Unlike Salem Telephone, Salem Data Services would not be a regulated utility and would be considered a separate entity. While the intention would be that the profit from Salem Data would ease pressures to raise telephone prices, the…

Words 1023 - Pages 5

Salem Data Services Essay

Managerial Accounting for Decision Making 7310 Case #2 Salem Telephone Company Hubert Beauchemin, Lingzhou Bu, Haozhao Zhang With operations starting in 2001, Salem Data Services was seen as a window of opportunity for Salem Telephone Company. However, many problems have been encountered along the way. The most recent results have been so concerning that President Peter Flores has had to discuss solutions with Manager Cynthia Wu. The most pressing issue they must discuss are the unsustainable high fixed costs…

Words 1425 - Pages 6

Alexander Graham Bell And The Conquest Of Solitude Summary

foundation for many Bell articles. This author covers Bell’s life before, during, and after the telephone, this includes information focuses on the motive to build the telephone and it’s impact on society. Bruce explains that initially Bell didn’t intend on building the telephone, however once the telephone had “first spoken” Bell had only wanted to improve the invention. Continuing the creation of the telephone did not only positively impact Bell’s life but society as a whole to this day. Robert V. Bruce…

Words 979 - Pages 4

Essay on Salem Case Study

analysis of Salem Telephone Company and its subsidiary, Salem Data Services, we’ve encountered several factors that may be contributing to Salem Data Service’s consistent operating loses. The first issue is the remaining available hours to sell each month. This accounts for approximately 38% of the total hours available for revenue each month. The company is losing out on huge profits by not fully utilizing these hours. In March, the company had 223 hours available to sell. The company could have…

Words 332 - Pages 2

Salem telephone case Essay

Salem Telephone Company Jiaoyang Li 2014.09.28 Questions 1.Operations: hourly personnel and power are variable with respect to revenue hours. Space costs (Rent, Custodial services), Equipment costs (Computer leases, Maintenance, Depreciation), Operations for salaried staff, Systems development and maintenance, Administration, Sales, Sales promotion…

Words 992 - Pages 4

Bridgeton Paper

Superior Manufacturing Company 1. Based on the 2004 statement of profit and loss data (Exhibits 1 and 2), do you agree with Waters’ decision to keep product 103? 2. On January 1, 2006, should the company reduce the price of product 101? To what price? 3. What is Superior’s’s most profitable product? 4. What appears to have caused the return to profitable…

Words 1646 - Pages 7

Sales and Positive Customer Experience Essay

customers and ensured a consistently positive customer experience Quickly became a trusted assistant to the company president, executive staff and office manager and earned a reputation for maintaining a positive attitude and producing high-quality work Excel in listening to customer needs, articulating product benefits and creating solutions that provide value to the customer. Respond to telephone inquiries, providing quality service to customers and associates inquiring about the availability of products…

Words 1057 - Pages 5

Essay about Wireless Analytical Report

decreasing amount of annual income and the increasing need to budget costs in the United States and within our company. BACKGROUND Our business is looking to take advantage of a wireless service to offer to our employees. The purchase of five new lines will give our district managers the ability to always stay connected and relay important messages. To facilitate growth in the company it is imperative that we maintain a competitive edge and stay up to date in our technological tools. This study…

Words 2894 - Pages 12

Report on International Ethical Issues Essay

Report on International Ethical Issues February 20, 2010 TABLE OF CONTENTS 1). Executive Summary…………………………………………………………………3 1.1 Background and learning goals of the report …………………………………3 2). Introduction to Dell Inc………………………………………………………………4 2.1 Background of Dell Inc. ………………………………………………………4 2.2 International activities of Dell Inc. ……………………………………………5 3). International ethical issues facing Dell Inc. ………………………………………6 3.1 Employment Practices…………………………………………………………6…

Words 2740 - Pages 11

Essay about Review and Practice Exam Questions for

Review and Practice Exam Questions for Exam 1 Learning Objectives for Exam 1 Unit 1, Part 1: Population vs. sample Explain and give examples of individuals and variables. (Ch 1) Calculate a proportion. (Ch 3) Distinguish between a population and a sample. (Ch 1) Distinguish between a parameter and a statistic. Identify parameters and statistics in stories. (Ch 1) Explain the advantages and disadvantages of taking a census. (Ch 1) Describe the problems that can occur with sample statistics and explain…

Words 4697 - Pages 19