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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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