Salem Telephone Essay Example
Salem Telephone Essay Example

Salem Telephone Essay Example

Available Only on StudyHippo
  • Pages: 2 (533 words)
  • Published: April 27, 2018
  • Type: Case Study
View Entire Sample
Text preview

Upon analyzing the first quarter reports of 2004, including the Summary of Computer Utilization and Summary Results of Operation, it is evident that further scrutiny should be placed on Salem Data Services' Data Services division, as they continue to operate at a loss. The analysis points out that key areas that require attention include the current utilization of computer usage hours, consistent negative results of operations, and determining whether some fixed costs can be converted to variable costs based on work levels. Of immediate concern is identifying fixed costs versus variable costs.

With variable costs amounting to $32,640, the company should closely inspect both variable and fixed costs of Salem Data Services. However, it is clear that the average variable costs for the first quarter are insufficient to offset the current fixed cost amounting to

...

$189,620. To address this issue, it is suggested that the company reviews the salaries for the Sales division and establishes a pay structure that is tied to revenue and sales. Moreover, sales promotion can also be tied to sales or revenue to convert these into variable costs.

Aside from the issue with variable and fixed costs, another major concern is the underutilization of computer hours available compared to those used. Currently averaging about 60% of utilization for available hours, the Commercial sales department requires more attention to drive commercial sales and maximize computer use.

There may be a need to reconsider commercial demand and adjust the sales promotion strategy to ensure that there is a sufficient market to serve. Salem Data Services has the potential to become a profitable subsidiary of Salem Telephone Company, but shutting down the division woul

View entire sample
Join StudyHippo to see entire essay

be premature. Instead, the organization should focus on increasing commercial sales and maximizing computer utilization by revisiting the promotion and sales strategy. Converting sales and promotions to variable costs could motivate staff to push for additional customers. The average utilization rate of computer hours is 60%, based on the Salem Data Services Summary of Computer Utilization. However, the Results of Operations show an average loss of $35,327, raising concerns about operations. Fixed costs are $189,620, and average variable costs are $32,640. The division's contribution margin is $154,292 or 82.5%. Further analysis reveals that corporate services make up almost 50% of the total variable cost per hour of $97.34.

An assessment should be made regarding the allocation of corporate costs. The current method involves allocating based on cost per square foot. Since variable costs are relatively low, there is some justification for continuing with this approach. However, converting additional costs to variable costs and re-evaluating the allocation method may lead to better outcomes. The following questions must be answered: 1) Which expenses listed in Exhibit 2 are variable concerning revenue hours? Which are fixed costs concerning revenue hours? 2) Calculate the cost per revenue hour for each cost that is variable with respect to revenue hours. 3) A contribution margin income statement for Salem Data Services must be created, assuming that Intracompany usage is 205 hours and Commercial usage is at the March level. 4) Determine how many commercial revenue hours of computer use would be necessary to break even each month if the intracompany demand for service will average 205 hours per month. 5) Estimate the impact on Income of each of Flores's proposed

options if...

Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New