Premium Essay

Salem Case Study

In: Business and Management

Submitted By ddana77
Words 613
Pages 3
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 ($1,240)
Computer leases ($95,000)
Maintenance ($5,400)
Depreciation:
Computer equipment ($25,500)
Office equipment and fixtures ($680) Wages and salaries
Operations: salaried staff ($21,600) Systems development and maintenance ($12,000)
Administration ($9,000)
Sales ($11,200)
Sales promotion ($8,083)
Corporate services ($15,236)

Variable cost in respect to revenue hours:
Power ($1,697)

Similar Documents

Premium Essay

Salem Case Study

...Case Study Analysis: Salem Telephone Company Contents Summary 2 Analysis 2 Questions 3 Recommendations 5 Works Cited 6 Summary In 2000, Peter Flores, president of Salem Telephone Company (STC) told the Public Service Commission that a profitable computer service subsidiary would reduce pressure for telephone rate increases. Once approval was received from Public Service Commission, STC, a regulated public utility, established Salem Data Services (SDS) in 2001, an unregulated wholly owned subsidiary, to perform data processing for the telephone company and, additionally, to sell computer services to other companies and organizations in its immediate metropolitan region. Following three years of operations, SDS has not been able to post profits and the president of STC is now faced with a challenge of whether the subsidiary SDS will be a profitable business venture. The president of STC, Peter Flores, is preparing to meet with Cynthia Wu, manager of SDS, to assess and determine the profitability of the subsidiary SDS. Our group’s tasks are to: ▪ analyze and review common cost behavior, distinguishing different types of costs (variable or fixed) as they pertain to business activities; ▪ construct a contribution margin income statement; ▪ review net income relative to reduction and commercial price increases; and ▪ formulate recommendations to the president of STC based on our financial analysis on whether or...

Words: 1092 - 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...

Words: 928 - Pages: 4

Premium Essay

Salem Telephone Case Study

...Salem Telephone Company Case Study 1. Variable Expenses with respect to revenue hours: Power expense, hourly personnel salaries expense. Fixed expenses with respect to revenue hours: Rent, custodial services, computer leases, maintenance, depreciation of computer equipment and office equipment and fixtures, operations salaried staff, systems development and maintenance, administration, and sales, sales promotions, corporate services. 2. Units: dollars per hour January February March Power expense 4.7 4.7 4.7 personnel salaries expense 24 24 24 Total Variable cost per revenue hour 28.7 28.7 28.7 3. 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/hr Commercial contribution margin: $800-$28.7=$771.3/hr Sales revenue $192,400 Variable cost $9844.1 Contribution margin $182,555.9 Fixed cost $212,939 Net loss ($30,383.1) 4. Revenue = Variable Costs + Fixed Costs 205(400) + X (800) =(X+205) (28.7) +212,939 X= 177.39 commercial hours sold to break-even 5. Original March: P= Net Income= ($23,700) For option 1: P=205(400)+1000(96.6)-301.6(28.7) -212,939= -42,994.92 For option 2: P=205(400) +600(179.4)-384.4(28.7) -212,939= -34,331.28 For option 3: P=205(400) +800(179.4)-384.4(28.7) -212,939 = 1548.72 In conclusion, for option1 and 2, both will decrease in net income. For option3, net income will increase to a benefit...

Words: 1246 - Pages: 5

Premium Essay

Salem Telephone Case Study

...Salem Telephone Company Case Study 1. Variable Expenses with respect to revenue hours: Power expense, hourly personnel salaries expense. Fixed expenses with respect to revenue hours: Rent, custodial services, computer leases, maintenance, depreciation of computer equipment and office equipment and fixtures, operations salaried staff, systems development and maintenance, administration, and sales, sales promotions, corporate services. 2. Units: dollars per hour January February March Power expense 4.7 4.7 4.7 personnel salaries expense 24 24 24 Total Variable cost per revenue hour 28.7 28.7 28.7 3. 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/hr Commercial contribution margin: $800-$28.7=$771.3/hr Sales revenue $192,400 Variable cost $9844.1 Contribution margin $182,555.9 Fixed cost $212,939 Net loss ($30,383.1) 4. Revenue = Variable Costs + Fixed Costs 205(400) + X (800) =(X+205) (28.7) +212,939 X= 177.39 commercial hours sold to break-even 5. Original March: P= Net Income= ($23,700) For option 1: P=205(400)+1000(96.6)-301.6(28.7) -212,939= -42,994.92 For option 2: P=205(400) +600(179.4)-384.4(28.7) -212,939= -34,331.28 For option 3: P=205(400) +800(179.4)-384.4(28.7) -212,939 = 1548.72 In conclusion, for option1 and 2, both will decrease in net income. For...

Words: 302 - Pages: 2

Premium Essay

Salem Telephone Company Case Study

...James Whittle Salem Telephone Company Case Study 9/29/2014 1.) The variable costs in Exhibit 2 are Power and Hourly Personnel Wages as the costs fluctuate from month to month and are driven by the revenue hours for the company. The fixed costs in Exhibit 2 are Rent, Custodial Services, Computer Equipment Leases, Computer Maintenance, Computer Depreciation, Office Equipment and Fixtures Depreciation, Salaried Staff Wages, Systems Development and Maintenance, Administrative Wages, Sales Wages, Sales Promotion, and Corporate Services. Rent, Custodial Services, Computer Equipment Leases, Computer Maintenance, Computer Depreciation, Office Equipment and Fixtures Depreciation, Salaried Staff Wages, Systems Development and Maintenance, Administrative Wages, and Sales Wages are all obviously fixed because the expenses do not vary monthly. However, Sales Promotion and Corporate Services expenses change monthly, but the change is not dependent on revenue hours. Therefore, they are fixed with respect to revenue hours. 2.) The calculations for variable costs with respect to revenue hours are as follows: | January | February | March | Total Power Expense | $1,546 | $1,485 | $1,697 | Total Revenue Hours | 329 | 316 | 361 | Total Variable Cost per Revenue Hour | $4.70 | $4.70 | $4.70 | | | | | | January | February | March | Total Hourly Personnel Wages Expense | $7,896 | $7,584 | $8,664 | Total Revenue Hours | 329 | 316 | 361 | Total Variable Cost per...

Words: 806 - Pages: 4

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

Free Essay

Fall of Ibm

...Title: The Fall of IBM Date: September 20, 2013 I. Executive Summary The purpose of this case study analysis is to analyze the situation of IBM in the 1990s, to come up with possible mutually exclusive alternatives for IBM’s management and ultimately, to recommend a possible strategy to regain back IBM’s throne in the industry. The problem of the case study is all about the survival of IBM in a much more competitive market ever encountered by the company. And also, overcoming new challenges brought about IBM’s new management and the dynamic technological environment. The methods of analysis used for this case study are the Porter’s Five Forces Model and the ANSOFF matrix analysis. Brief explanations were provided in each of the methods used for analysis. After analyzing the case study, the following three mutually exclusive alternative course of action were developed: 1. Decentralize Management; 2. Invest heavily on research and development and; 3. Partner with suppliers From the alternatives, I recommend that IBM should partner with its suppliers. Collaboration with suppliers will increase business flexibility and executive level business decision support. This will surely bring the most benefit for the company among the other alternatives course of action. The suppliers play a great role in the industry and having strong connections with them can help the company survive and even excel in the industry. Outline and Implementation: ...

Words: 1673 - Pages: 7

Free Essay

Role of Power

...contemporary organizational issue you find intriguing. Use one field site or example for the entire paper. Also, be explicit about the level issue. For example, if you are using the concept of personality then it is an individual level issue. A list of concepts and their related levels is provided in a separate document. Focus of paper-related requirements: Outline: Submit a formal outline for your paper, complete with references. The purpose of the outline is to help you organize your content, which also results in increased clarity, improved logic, and better structure of the paper. There may be adjustments from this document to your final paper, but at this stage the paper should not require major revisions. Final Paper: Use a case study format for the structure of your paper. Identify and analyze issues using course concepts, and propose recommendations for the organization you are focusing on. Use of course concepts 1. Use a minimum of 8 concepts for the paper. Include a list of the concepts you used at the beginning of the paper. 2. Briefly define each concept you use within the text (a paragraph or two). 3. For each concept, write a diagnosis at one level (e.g., the person level). For example, you might write “The employee misses work frequently due to stress from conflict with her supervisor.” Note, stress and conflict would require definitions.) 4. For each concept, write a solution or solutions. Identify the level(s) you addressed in Step 2...

Words: 594 - Pages: 3

Premium Essay

Ungs2050

...Calendar Overall for Case-Study Presentation & Mid-Term Exam – MGT 4760 (Strategic Management) Sem 1, 2012/2013 Sec 8 (M-W) No. | Week | Topics | Class Day | Date | Schedule | Details | | 1 | Chapter 1: The Nature of Strategic Management | 1- Mon 2- Wed | 10/912/9 | | | | 2 | Chapter 2: The Business Vision and Mission | 3- Mon 4- Wed | 17/919/9 | | | | 3 | Chapter 3: The External Assessment | 5- Mon 6- Wed | 24/926/9 | | | | 4 | Chapter 4: The Internal Assessment | 7- Mon 8- Wed | 1/103/10 | Quiz 1 (Chapter 1.2.3) | | | 5 | Chapter 4: The Internal Assessment | 9- Mon 10- Wed | 8/1010/10 | | | | 6 | Chapter 5: Strategies in Action | 11- Mon 12- Wed | 15/1017/10 | | | | | BREAK(22/10 – 28/10) | 13- Mon 14- Wed | 22/1024/10 | | | | 7 | Chapter 5: Strategies in Action | 15- Mon 16- Wed | 29/1031/10 | Case Presentation Session 1Case Presentation Session 2 | Group 1:L: Lia Hilaliah (Case Study 3)Group 2:L: Mas Syairah bte Mohamad (Case Study 5) | | 8 | Chapter 6: Strategy Analysis and Choice | 17- Mon 18- Wed | 5/117/11 | | (Mid-Term Exam 7/11 Wednesday)Seminar Room 1.1 | | 9 | Chapter 6: Strategy Analysis and Choice | 19- Mon 20- Wed | 12/1114/11 | Case Presentation Session 3Case Presentation Session 4 | Group 3:L: Mohamed Sheikh (Case Study 9) Group 4:L: Izzati Nor binti Salleh (Case Study 14) | | 10 | Chapter 7: Implementing Strategies: Management and Operations...

Words: 418 - Pages: 2

Premium Essay

Ob, Arctic Minings Consultants, Case Study

...ARCTIC MINING CONSULTANTS Case Synopsis Arctic Mining Consultants is a mining company that deals with mineral exploration. In this case study, the project given is staking 15 claims in Eagle Lake, Alaska. The project Manager was Tom Parker, who has a wide experience and specialized knowledge in all nontechnical aspects of mineral exploration. He is a geological field technician and field coordinator for Arctic Mining Consultants. He assigned his previous field assistants John Talbot, Greg Boyce and Brian Millar to help him complete the project. The job required them to stake at least 7 lengths each day in order to be completed on time. However, the whole team has became very tense and agitated, especially Tom Parker, as the deadline was just around the corner and there’s still many to be finished within the limited time. The problem became worse with the way Tom managed and treated his team. The only motivation to the team was the $300 bonuses promised by the company when the job is done on time, otherwise, they might wished to give up already. This happened because working as a field assistant and in long-working hours only giving them low wages, which is considered unreasonable compared to what they have to do. During the eight hard days, everything had actually proved the strengths and weaknesses of each of the team members, including Tom. Case analysis symptoms 1) What symptom(s) exist in this case to suggest that something has gone wrong? The symptom(s) to suggest...

Words: 2346 - Pages: 10

Premium Essay

Case Study Sample

...Running head: CASE STUDY XYZ Case Study XYZ: An Examination of Project Procurement Management Practices Group 12 John Doe Jane Smith Bobbie Sue University of Maryland University College Project Procurement Management, Semester XXXX, Section XXXX Professor Stephen R. Guth MMMM DD, YYYY [No Abstract or Introduction required for this assignment] The Inception Phase Rating Scale: 5—Excellent, 4—Very Good, 3—Good, 2—Poor, 1—Very Poor |Project Management Area |Inception Phase | |Scope Management | | |Time Management | | |Cost Management | | |Quality Management | | |Human Resource Management | | |Communication Management | | |Risk Management | | |Procurement Management | ...

Words: 804 - Pages: 4

Premium Essay

Organizations Conflicts

...policy. 2) Employee conditions: a. Lack of motivation  b. Compensate for low wages by over indulgence of free food allowance c. High turnover rate due to availability of high application rates. d. Employees are mostly college and high school students e. Lack of respect for managers. f. No incentive to increase motivation. In the case study Perfect Pizzeria, the area supervisor has many problems that need his attention. The largest appears to be the organization. In this case study I will assume that the area supervisor has the authority to affect change within his organization (i.e. he is the franchise owner). Being in an area with few job opportunities should give him the perfect opportunity to recruit bright, ambitious, and motivated people to staff his pizzerias. How can the area supervisor change his organization to achieve a more fluid corporate culture? I think this change can be achieved by human resource changes, structure changes, motivational changes, and reward for good performance as well as accountability for poor performance. Each one of these areas will require a change from the corporate level. For the sake of my case study I am going to assume that the area supervisor (franchise owner) can lobby to achieve this change within the organization. The first area to look...

Words: 445 - Pages: 2

Free Essay

Why Financial Intermediaries Exist

...letters in industry or for a class, knowing your purpose and audience will help determine what information to include. Generally, business letters follow a particular format, although your instructor or company may require you to use alternative formats. This guide provides writers with an introduction to writing business letters. Case Studies: This guide examines case studies, a form of qualitative descriptive research that is used to look at individuals, a small group of participants, or a group as a whole. Researchers collect data about participants using participant and direct observations, interviews, protocols, tests, examinations of records, and collections of writing samples. Starting with a definition of the case study, the guide moves to a brief history of this research method. Using several well documented case studies, the guide then looks at applications and methods including data collection and analysis. A discussion of ways to handle validity, reliability, and generalizability follows, with special attention to case studies as they are applied to composition studies. Finally, this guide examines the strengths and weaknesses of case studies. Desktop Publishing: Desktop publishing is the process of laying out and designing pages with your desktop computer. With software programs such as PageMaker and Quark Xpress, you can assemble anything from a one-page document to a...

Words: 795 - Pages: 4

Premium Essay

Brussels and Bradshaw

...Brussels and Bradshaw In response to the case study, Brussels and Bradshaw is a well-established financial institution that offers their clients competitive and innovative solutions for their community and work environments. The banking institution offers a summer internship to bright and driven individuals. The internship includes 14 weeks of very intense training and long hours. Interns are paid $20,000 for the contract. During the screening process, out of all the possible candidates Audrey Locke was selected. Audrey has some experience as an assistant, assurance analyst and financial planning analyst. Brussels and Bradshaw is operating in more than 25 countries globally; this case study takes place in Toronto. Many behavioral issues in the Brussels and Bradshaw institution are unprofessional and stressful. Job stress is defined as feeling one’s capabilities, resources, or needs that do not match the demands or requirements of the job (Hitt, Miller, & Colella, 2011 p. 249). Working 70 and 80 hours per week or possibly 120 hours will put a major burden on anyone, especially someone new to the working environment. Audrey is excited with her internship and very eager to learn. She is assigned a mentor and buddy by the business development manager, Kelly Richards. Kelly has 10 years of experience. Although associates consider her human resources, Kelly’s job is strictly administrative. Audrey is never introduced to her mentor and her buddy, Christine Page is very...

Words: 509 - Pages: 3

Premium Essay

Coach Purses

...Business case studies determine and define the primary issues that a company faces in the modern world market. A well designed business case study can provide a detailed contextual analysis of limited conditions and their horizontal relationships to other entities. In the case of Coach, they are an international clothing accessory company with a reputation of making pristinely handcrafted items with unique designs and a label that represents over seventy years of craftsmanship. In order to fully understand Coach’s business model, empirical data must be collected and analyzed to include the historical and current financial statistics, an in-depth analysis of the company overall, an analysis of the company’s business model, and finally current issues and future forecast that affect the longevity of the enterprise. By studying the history of Coach, both investors and those with an interest in the company can gain insight into key factors that motivate company decisions. Background/History The history of Coach starts in 1941 in a small family run leather workshop with six primary artisans in Manhattan that had skills passed down from generation to generation. It was not long until leather good become sought after for their high quality and workmanship. Through the guidance of the longtime and current CEO, Lew Frankfort, Coach expanded their business from just 6 million dollars 30 years ago to current sales exceeding 3.6 billion dollars. (Coach, 2012) From 1941 to present, the...

Words: 1026 - Pages: 5