Preview

Salem Telephone Case Study

Satisfactory Essays
Open Document
Open Document
812 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
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 that intracompany work was billed at $400 per hour, and the commercial sales was billed $800 per hour.
The intracompany contribution margin = price - variable cost = $400 - $28.7 = $371.3/hr
The commercial contribution margin = $800 - $28.7= $771.3/hr
The intracompany usage is 205 hours, and the commercial usage in March is 138 hours.
So the sales revenue = $400 * 205 + $800 * 138 = $192,400
Variable costs = $28.7 * (205 + 138) = $9,844.1
The contribution margin = revenue - variable cost = $182,555.9
The fixed costs in March = total expenses - variable costs = $223,300 - 1,697 - 8,664 = $212,939
Net income ($30,383.1)

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

You May Also Find These Documents Helpful

  • Good Essays

    Ac505 Project B

    • 901 Words
    • 4 Pages

    The company would hire three new employees. These three individuals would be full-time employees working 2,000 hours per year and earning $12.00 per hour. They would also receive the same benefits as other production employees, 18% of wages, in addition to $2,500 of health benefits.…

    • 901 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Midterm Comm293

    • 5099 Words
    • 21 Pages

    No programmable calculators are permitted. Please show all calculations in an orderly and clear format for part marks. Time management is crucial. Be sure to attempt each question. No questions will be permitted during this examination. If you need to make an assumption, state it and continue. Read the questions carefully before making any assumptions. Question 1 (18 marks; suggested time 18 minutes) Revenue Recognition…

    • 5099 Words
    • 21 Pages
    Better Essays
  • Satisfactory Essays

    ¼ hours (20,000 x 60)/80,000 = 15 minutes 3. How many units were produced in the second quarter? 120,000 units Problem 7-54: Plantwide versus Departmental Rates, Product-Costing Accuracy: Activity-Based Costing, page 330-331 See Attached File…

    • 98 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    A) Commercial = $1,000/hr , 30% demand decrease Intracompany: 223 hrs * $400/hr = $89,200 Commercial: 97 hrs * $1,000/hr = $97,000 Total: 320 hrs $186,200 Variable Exp: 320 hrs * 28.7/hr = $9,184 Sales $186,200 Variable Expenses ($9,184) Contribution Margin $177,016 Fixed Expenses…

    • 454 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Indirect labor is a variable cost because it increases in total directly and proportionately with the change in the activity level.…

    • 492 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Salem

    • 923 Words
    • 4 Pages

    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? Total Revenues - Total Costs =…

    • 923 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    (TCO 1) Josie’s Grill budgeted the following costs for a month in which 1,600 steak dinners will be produced and sold: materials, $4,080; hourly labor (variable), $6,976; rent (fixed), $1,700; depreciation, $800; and other fixed costs, $600. Each steak dinner sells for $14.00 each. How much is the budgeted variable cost per unit?…

    • 1661 Words
    • 14 Pages
    Satisfactory Essays
  • Satisfactory Essays

    1,800 hours of market analysis time, was provided 280 designs relating to 10 products, and…

    • 389 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    We suppose the water usage, medical supplies, and purchased lab services as variable cost; employee’s salaries, benefits, and equipment depreciation as fixed cost. All revenue and costs will increase or decrease as straight-line…

    • 611 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Bus 630 Week 2 Assignment

    • 404 Words
    • 2 Pages

    The following worksheet contains cost and revenue data for Shop 48 and is typical of the company’s many outlets:…

    • 404 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    A) Explicit Costs = rent 25000 + business taxes 15 000 + products to sell 350 000 = $390 000…

    • 362 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    2. What Jonathan Edmunds meant was lost in the year event of $8,326 would contribute as amount invested to build the image of Auburn Circular Club.…

    • 650 Words
    • 3 Pages
    Powerful Essays