Contribution margin income statement for salem data services

Assignment Help Accounting Basics
Reference no: EM13849317

1. "Revenue hours" represent the key activity that drives costs at Salem Data Services. Which expenses in Exhibit 2 are variable with respect to revenue hours? Which expenses are fixed with respect to revenue hours?

2. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour.

3. Create a contribution margin income statement for Salem Data Services. Assume that intracompany usage is 205 hours. Assume commercial usage is at the March level.

4. Assuming the intracompany 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?

Since the intracompany demand is known to be 205 hours, the contribution from these sales is assured to cover a portion of the fixed costs. Thus, to determine the level of commercial revenue hours required to break even, the contribution from commercial sales only needs to cover the fixed costs remaining after subtracting the fixed costs already covered by the contribution from intracompany sales.

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

Increasing the price to commercial customers to $1,000 per hour would reduce demand by 30%.

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

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

6. Based on your analysis above, is Salem Data Services really a problem to Salem Telephone Company? What should Flores do about Salem Data Services?

Attachment:- Case2.pdf

Attachment:- case2excel.xlsx

Reference no: EM13849317

Questions Cloud

Objective of the firm in corporate finance : Discuss the four major conflicts that may occur with the objective of shareholder value maximization and what is corporate governance and what is its purpose?
Determine the income tax expense : From the income statement, determine the income tax expense for the most recent year. What are the current portion and the deferred portion of the expense? (See the "Taxes Based on Income" note in the Notes to Consolidated Financial Statements.)
What has been the effect of aggressive competitor pricing : Comment on the impact of the more highly aggressive pricing strategies used by competitors. What has been the effect of aggressive competitor pricing on your results (profitability, market share, cost to consumer, etc.)
Taxpayer rights and maximizing deductions : Discuss whether the IRS would be more effective in its collection efforts if it adopted a more customer service approach. Support your position.
Contribution margin income statement for salem data services : Create a contribution margin income statement for Salem Data Services. Assume that intracompany usage is 205 hours. Assume commercial usage is at the March level.
Impact of design of an accounting information system : Impact of Design of an Accounting Information System - Despite this fact, many of these firms rely on a single AIS. From the second e-Activity, for the business you researched, examine how its lines of business would affect the design of a new AIS.
Identify top characteristics to improving the profitability : Identify the top-three characteristics you would rely on the most for improving the profitability of the firm. Provide an example of how each characteristic would directly help the firm in terms of profitability.
Swot anaiysis for hewlett packard : The industry to be analyzed must correspond to one of the following industry categories but under no circumstances are you permitted to do this exercise on the industry of which the company in your group case is a part
Obtain a minimal state table for sequential network : Obtain a minimal state table for a clocked synchronous sequential network having a single input line, x, in which the symbols 0 and 1 are applied, and single output line z

Reviews

Write a Review

Accounting Basics Questions & Answers

  Bonnie and clyde are the only two shareholders in getaway

bonnie and clyde are the only two shareholders in getaway corporation. bonnie owns 60 shares with a basis of 6000 and

  What abc systems would be helpful to guide

Assuming that Seneca starts to supply new customers-large discounters and supermarkets outisde its local region-what ABC systems would be helpful to guide the profitability of the strategy and assist Seneca managers in making decisions?

  A company that manufactures ultrasonic wind sensors

a company that manufactures ultrasonic wind sensors invested 1.5 million 2 years ago to acquire part ownership in an

  Stock-based compensation package

As part of its stock-based compensation package, International Electronics granted 24 million stock appreciation rights (SARs) to top officers on January 1, 2006.

  Compute the equivalent units

Compute the equivalent units for May for the Cleaning Department, assuming that the company uses the weighted - average method of accounting for units.

  Double declining balance method of depreciation

Assume a 5 year useful life with a residual value of $50,000, how much depreciation expense should the company record on its books each year using the double declining balance method of depreciation?

  Calculating divisions return on investment

What method would be most appropriate for calculating the division's return on investment (ROI)? Why? Using this method, what is ROI for the current year?

  Financial atatements important to the financial planning

Why are pro-forma financial atatements important to the financial planning process?

  Warrants exceeds the average market price

In the diluted earnings per share computation, the treasury stock method is used for options and warrants to reflect assumed reacquisition of common stock at the average market price during the period. If the exercise price of the options or warra..

  What would make for a larger increase in the stock variance

the standard deviation of the market index portfolio is 20. stock a has a beta 1.5 and residual standard deviation of

  Couple elects gift splitting for the present year

Determination of Taxable Gifts. In the current year, David gives $180,000 of land to David, Jr. In the current year, David's wife gives $200,000 of land to George and $44,000 cash to David, Jr. Assume the couple elects gift splitting for the curre..

  What is the purpose of using regression analysis how may it

what is the purpose of using regression analysis? how may it be used to formulate strategies? provide examples

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd