salem telephone company case study pdf

• Harvard Business School →
• Faculty & Research →
• June 2004 (Revised November 2005)
• HBS Case Collection

Salem Telephone Company

• Format: Print

More from the Authors

• Faculty Research

Survey Masters LLC (A) and (B)

• June 2016 (Revised December 2016)

Survey Masters LLC (B)

• August 2012

Danshui Plant No. 2 (Brief Case)

• Survey Masters LLC (A) and (B)  By: William J. Bruns, Amit Eynan and Kip Krumwiede
• Survey Masters LLC (B)  By: William J. Bruns, Amit Eynan and Kip Krumwiede
• Danshui Plant No. 2 (Brief Case)  By: William J. Bruns, Julie H. Hertenstein and Kelvin Liu

The marketplace for case solutions.

Salem Telephone Co. – Case Solution

Salem Telephone Co., a computer subsidiary, has been losing profits. Its managers are tasked with determining if it is actually unprofitable. Likewise, they must look into price changes and other promotions which might help increase the profits.

​William J. Bruns Jr.; Julie H. Hertenstein Harvard Business Review ( 104086-PDF-ENG ) June 07, 2004

Case questions answered:

• Which expenses are variable and fixed with respect to revenue hours?
• Calculate the cost per hour for each variable expense.
• Prepare a contribution margin statement for Salem Data Services, assuming that intra-company usage is 205 hours. Assume commercial usage is at the march level.
• Assuming the inter-company demand for service will average 205 hours per month, what level of commercial revenue hours of computer use would be necessary to break even each month?
• Estimate the effect of income of each of the options Flores has suggested if Wu estimates as follows: Option 1: Increasing the price for commercial customers to $1000 per hour would reduce demand by 30%. Option 2: Reducing the price for commercial customers to $600 per hour would increase demand by 30%. Option 3: Increased promotion would increase revenue hours by up to 30%. Wu is unsure how much this promotion would take (How much could be spent and still leave Salem data services with no reported loss each month if commercial hours were increased by 30%).
• Based on your analysis above, is Salem Data Service really a problem for Salem Telephone Co.? What should Flores do about Salem Data Service?

Not the questions you were looking for? Submit your own questions & get answers .

Salem Telephone Co. Case Answers

Q.1: which expenses are variable and fixed with respect to revenue hours.

Variable expenses:

• Power Expense
• Operations: Hourly personnel

Fixed Expenses:

• Rent Expense
• Custodial service
• Computer leases
• Maintenance
• Depreciation: Computer equipment Office equipment
• Operations Salaried Staff
• System development and maintenance
• Administration
• Sales promotions
• Corporate services

Q.2: Calculate the cost per hour for each variable expense.

Q.3 Prepare a Contribution margin statement for Salem Data services, assuming that intracompany usage is 205 hours. Assume commercial usage is at the march level.

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/hour while Commercial contribution margin: $800-$28.7=$771.3/hour

Salem Data Service Contribution Margin statement For the month ended March 2004

Q.4 Assume the intercompany demand for service will average 205 hours per month. What level of commercial revenue hours of computer use would be necessary to break even each month?

Break-even point = Fixed costs/ CM per unit

Let’s suppose A is the commercial revenue hours to break even

Sales revenue per unit = $82,000/205= $400.00

Variable cost per unit = $9,844.10/343= $28.70

(205 x $400 + A x $800) – 28.70 x (205 + A) – 212,939 = 0

82,000 + 800A – 28.70A – 5883.50 – 212,939 = 0

-136,822.50 + 771.30A = 0

771.30 A = 136,882.50

Salem Data Services would need 177.39 commercial hours to break even each month.

Q.5 Estimate the effect of income of each of the options Flores has suggested if Wu estimates as follows:

Option 1: increasing the price for the commercial customer to $1000 per hour would reduce demand by 30%..

Original March data

P= Net Income= ($23,700)

For option 1:

Commercial revenue hours 138

A 30% decrease in demand would result in revenue hours of:

138*0.3= 41.4

138-41.4= 96.6 hours

Commercial revenue per hour cost increased to $1000/hour, and for intracompany, cost per hour would be the same as no assumption is given for intracompany.

205+96.6= 301.6 hours in total to calculate Variable cost.

Commercial revenue 96.6(1000) = $96,600

Intra-company revenue 205 (400) =$82,000

Less Variable cost 301.6 (28.7) = ($8655.92)

Less Fixed cost = ($212,939)

Net income= Revenue-Variable cost- fixed cost

Net income= ($42,994.2)

Option 2: Reducing the price for commercial customers to $600 per hour would increase demand by 30%.

With a 30% increase in demand would result in revenue hours of:

138+41.4= 179.4 hours

Commercial revenue per hour cost decreased to $600/hour, and for intracompany, cost per hour would be the same as no assumption is given for intracompany.

205+179.4= 384.4 hours in total to calculate Variable cost.

Commercial revenue 179.4(600) = $107640

Intracompany revenue 205 (400) =$82,000

Less Variable cost 384.4(28.7) = ($11032.82)

Net income= ($34331.28)

Option 3: Increased promotion would increase revenue hours by up to 30%. Wu is unsure how much this promotion would take (How much could be spent and still leave Salem data services with no reported loss each month if commercial hours were increased by 30%).

Assuming commercial per-hour costs are $800 because there is no price assumption, take the original per-hour cost. The intracompany cost per hour would be the same as no assumption is given for intracompany.

Commercial revenue 179.4(800) = $143,520

Net income= $1548.72

For options 1 and 2, the company would be in a loss, and for option 3, if the company is still spending $1548.72, there would be no loss to the company spending more than $1548.72, which will result in a loss. It could be spent on either sales promotion or corporate services costs.

Q.6: Based on your analysis above, is Salem Data service really a problem for Salem Telephone Co.? What should Flores do about Salem Data Service?

Based on my analysis above, I can say that Salem Telephone Co. should keep Salem’s data service. This is a new startup, so every new start-up business faces losses at the beginning because customers are less -aware of the product/service, and awareness takes time.

Slowly and gradually, its loss is decreasing. From Exhibit 2, we can see that from February to March, loss has decreased by almost $17000.

Salem data service has huge fixed costs, and profits are not in the beginning months. Salem Telephone should keep Salem data service. If not, then they could save fixed costs, but they have to pay/spend money for purchasing intracompany revenue hours.

If Salem data service is closed, then the situation would be like this:

Salem company would save the cost of ($86884), but he would purchase intracompany hours of $164,000.

Flores should continue to operate Salem Data Company. They should focus more on marketing strategies to make customers more aware of their service. Also, they should revise their cost strategies to decrease fixed expenses and increase profits.

They should apply the pricing strategy of option 2 in the 5th question to decrease per hour price, so this would increase demand by 30% or more percentage. As the price is reduced, automatically, it will increase sales and will take the company towards profits.

Another thing they can do is to prepare budgets where commercial revenue hours will be forecasted, and the decision could be made that makes the company profitable.

Did this solution help you?

Academia.edu no longer supports Internet Explorer.

To browse Academia.edu and the wider internet faster and more securely, please take a few seconds to  upgrade your browser .

Enter the email address you signed up with and we'll email you a reset link.

• We're Hiring!
• Help Center

Salem Telephone Company

Related Papers

Maximo Torero

CiteSeerX - Document Details (Isaac Councill, Lee Giles): Number.

Rohan Samarajiva

EXECUTIVE SUMMARY This report focuses on the seven regional holding companies (RHCs) created as a result of the breakup of the former Bell System. Relationships between the Bell Operating Companies (BOCs), the RHCs, and unregulated affiliates are examined in order to determine behaviors that should concern state regulators either because the behaviors directly increase costs to local ratepayers or because the behaviors lessen competition.

Historic Salem, Inc.

Isabella Connor

Built by Rufus B. Gifford, Master Builder. Built circa 1869.

Nicholas Economides

This chapter examines the current conditions in the US telecommunications sector (ie, October 2002). It examines the impact of technological and regulatory change on market structure and business strategy. Among others, it discusses the emergence and decline of the telecom bubble, the impact of digitization on pricing, and the emergence of Internet telephony.

Chi Lun Wong

SSRN Electronic Journal

Gregory Sidak

American Journal of Alzheimers Disease and Other Dementias

Darby Morhardt

Ojulari Abdulkabir

Loading Preview

Sorry, preview is currently unavailable. You can download the paper by clicking the button above.

RELATED PAPERS

Greg Jackson

Richard Gitlin

Dana Mackenzie

Speech Communication

rendy billi

Naohiko Kohtake

IS management handbook

Publisher ijmra.us UGC Approved

Transactions of the Newcomen Society

Jenny Wetton

Journal of the International Academy for Case Studies

Dr. LRK Krishnan

Telecommunications Policy

The International Food and Agribusiness Management Review

Erna van Duren

Richard Lau

Reza Samizadeh

Enterprise & Society

Paul Miranti

Government Publications Review

John S Richardson

Bibhuti Sunari

Mark Jamison

Business Economics

David Loomis

Asia Pacific Journal of Management and Education

Richard R. John

Jeffrey Keefe

Robert Camfield

Stéphane Vaucher

BRIJESH SATHIAN , Nishida Chandrasekharan

•   We're Hiring!
•   Help Center
• Find new research papers in:
• Health Sciences
• Earth Sciences
• Cognitive Science
• Mathematics
• Computer Science
• Academia ©2024

• Silver Bee Group
• [email protected]

• NEW SOLUTION
• Top Visitors
• Popular Topics
• Newest Members
• Newest Papers
• Top Donators

Salem Telephone

• University Login

Recent Topics

New entries.

• Quality Parts Company
• Lincoln Electric
• Vêtements Ltée
• Google Case Analysis

Most Recent Request

• oilwell cable comp
• research methods
• human resource sho
• toyota adopts a st

Ease your MBA workload and get more time for yourself

Download Salem Telephone Company Case Study

• Date: December 2019
• Size: 163.2KB
• Author: Tôn Thiện Đức

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA

This is a non-profit website to share the knowledge. To maintain this website, we need your help. A small donation will help us alot.

Copyright © 2024 IDOCPUB.

• Top Downloads

Salem Telephone Company Case Study

Short description, description.

Please fill this form, we will try to respond as soon as possible.

Please copy and paste this embed script to where you want to embed

We need your help!

Thank you for interesting in our services. We are a non-profit group that run this website to share documents. We need your help to maintenance this website.

To keep our site running, we need your help to cover our server cost (about $400/m), a small donation will help us a lot.

• Share on Facebook
• Share on Google+
• Share on LinkedIn

Please help us to share our service with your friends.

• Email: [email protected]

Salem Telephone Company Case Study

• Author / Uploaded
• Tôn Thiện Đức

Views 492 Downloads 28 File size 293KB

Report DMCA / Copyright

Recommend Stories

Resolucion Salem Telephone Company

Solución a preguntas; 1. Las «horas facturables» representan la actividad clave como factor de costes en Salem Data Serv

680 30 88KB Read more

Caso 04 Salem Telephone Company

Anexo 01 - Salem Data Services, Resumen - Utlizacion de los ordenadores, primer trimestre de 2004 Enero Número de dias l

568 28 193KB Read more

Prestige Telephone Company Case Study

Case Summary Prestige Data Services is a subsidiary of Prestige Telephone Company, designed to perform data processing f

347 31 388KB Read more

salem telephone

Hechos Arturo es un brillante ejecutivo que labora como Coordinador de Ventas. Candidato a ocupar la Gerencia de Ventas,

244 20 56KB Read more

1. "Revenue hours" represent the key activity that drives costs at Salem Data Services. Which expenses in Exhibit 2 are

1 0 93KB Read more

Case Study - Prestige Telephone Co.

Case Studies in Managerial Accounting (Prestige Telephone Company) Presented by: Group 1 Arroyo, Jimmy Casada, May Mand

420 24 397KB Read more

Case Study Company Case 6

Gsibat 1 Sarah Gsibat BUS 103 (Sec # 22) is ar stu ed d vi y re aC s o ou urc rs e eH w er as o. co m 12 October 2018

1 0 41KB Read more

Rendell Company Study Case

9,442 2,785 177KB Read more

Rockford Company Case Study

Rockford Company The Rockford Company founded in 1942, is in the business of laying wall-to-wall carpeting. The company

1 0 52KB Read more

Report "Salem Telephone Company Case Study"

• Silver Bee Group
• [email protected]

• NEW SOLUTION
• Top Visitors
• Popular Topics
• Newest Members
• Newest Papers
• Top Donators

Salem Telephone Company

• University Login

Recent Topics

New entries.

• Quality Parts Company
• Lincoln Electric
• Vêtements Ltée
• Google Case Analysis

Most Recent Request

• oilwell cable comp
• research methods
• human resource sho
• toyota adopts a st

Ease your MBA workload and get more time for yourself