Preview

Salem Telephone Case

Satisfactory Essays
Open Document
Open Document
984 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Salem Telephone Case
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?

Variable: Wages of hourly personnel, Power

Fixed: Rent, custodial services, computer leases, maintenance, depreciation, salaried staff wages, administration, sales, systems development, sales promotion, corporate services

2.) For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour.
a. Wages of hourly personnel
Total wages of hourly personnel/total revenue hours = cost per revenue hour
i. January: 7896/329 = $24 per revenue hour ii. Februrary: 7584/316 = $24 per revenue hour iii. March: 8664/361 = $24 per revenue hour

b. Power
Cost of power/total revenue hours = cost per revenue hour
i. January: 1546/329 = $4.7 per revenue hour ii. February: 1485/316 = $4.7 per revenue hour iii. March: 1697/361 = $4.7 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.

Salem Data Services
Contribution Income Total Per Unit
Intracompany Sales (205) 82000 400
Commercial Sales (138) 110400 800
Variable Expenses (28.7 x 319.6) 9844
Contribution Margin 182556
Fixed Expenses 212939
Net Operating Income -30383

Intercompany Sales = 205 x 400 = 82000
Commercial Sales = 138 x 800 = 110400
Variable Expenses = 28.7 x 343 = 9844
Contribution Margin = 192400 – 9844 = 182556
New Operating Income = 182556 – 212939 = -$30383

4.) Assuming the intracompany demand for service will average 205 hours per month, what level of commerical revenue hours of computer use would be necessary to break even each month?
CM Ratio = Contribution Margin/Sales = 182556/192400 = .9488
Break even = Fixed Expenses/CM Ratio = 212939/.9488 = $224429.81

$224429.81 - $82000

You May Also Find These Documents Helpful

  • 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

    Paper cost ( 1,300 copies x .007) 9.10 Other supplies & electricity (1,300 copies x 0.004) 5.20 Total variable cost 14.30 2.) Calculate the total labor cost of these jobs Labor cost ( $ 8 x 4 hrs ) 32.00 3.) Suggest a way to assign labor and indirect costs to the cost of a copy made on that Sunday Direct Labor hours used because it is fixed and can be easily measured. 4.) Determine the full cost of one copy on the last Sunday in June, using the cost method in preceeding question. Paper cost 0.007 Other supplies & electricity Other supplies & electricity 0.004 0.004 Labor Cost (8/ hrx 4 hrs)/1300 copies 0.0246 Monthly operating cost (total cost (($5,000/30 days)/8hrs ) hourly rate ( 20.83/ hr x 4hrs )/1,300 copies 0.064 Total Full Cost per copy 0.0996 5. ) Determine the average annual full cost of one copy No. Of copies made / No. Of copies made 1,300 copies / 4hrs = 325 copies per hour Total no. Of copies made = total direct labor-hours x copies made per hour 7,280 hrs x 325 copies per hour = 2,366,000 copies Variable Cost ( 0.011 x 2,366,000 copies ) Labor cost (.0246 x 2,366,000 copies ) Other monthly cost total cost 5,000 x 12 months Total annual cost 26,026.00 58,203.60 144,000.00…

    • 657 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    1.) VARIABLE EXPENSES - Power - Operations (hourly personnel) FIXED EXPENSES - Rent - Custodial services - Computer leases - Maintenance - Depreciation - Operations (salaried staff) - Systems development and maintenance - Administration - Sales - Sales promotion - Corporate services 2.) VARIABLE EXPENSES: COST/HOUR JAN. FEB. MAR.…

    • 454 Words
    • 4 Pages
    Good Essays
  • Good Essays

    FIXED: rent, insurance, insurance VARIABLE: support staff (if paid hourly and hours per week vary), medical and office supplies.…

    • 391 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Salem

    • 923 Words
    • 4 Pages

    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? Variable expenses: Power Operations: hourly personnel Rent Custodial services Computer leases Maintenance Dep: Computer equipment Dep: Office equipment and fixtures Operations: salaried staff Systems development and maintenance Administration Sales Sales promotion Corporate services…

    • 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
  • Good Essays

    acc 422 final exams

    • 1656 Words
    • 7 Pages

    12) All of the following costs should be charged against revenue in the period in which costs are incurred…

    • 1656 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Foxy Original

    • 459 Words
    • 2 Pages

    6. Calculate the variable costs per order received at a trade show and the variable costs per order received through a sales rep?…

    • 459 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Based on Exhibit 2 the expenses incurred by Salem Data Services (SDS) fall into two categories- fixed expenses and variable expenses. The variable costs with respect to revenue hours are:…

    • 1271 Words
    • 7 Pages
    Good Essays
  • Better Essays

    Accounting is not always a black or white subject; there are many variables to consider when making a business decision. Looking past the numbers and being able to look at the larger picture will determine whether you will be an average manager or a great manager.…

    • 1199 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Soverign Lodge

    • 1618 Words
    • 7 Pages

    2. For each alternative from question 1, list the annual expenses that are incremental to that decision alternative but are not related to the room/days occupied, i.e. the incremental fixed costs for each alternative.…

    • 1618 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    (a) If Gina sells 20 shirts, what will her total revenue be? What will her total variable cost be?…

    • 702 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Eat2Eat

    • 320 Words
    • 4 Pages

    Eat2Eat.com Presented By – Suhail Menon Simran Jain Deepak Nadar Devaki Parikh Priyanka More (33) (74) (94) (102) (105) Case Overview • Eat2Eat.com was a online restaurant reservation service, covering doze ns of cities in the Asia-Pacific region. • The main activity of the Singapore Eat2EatPte Ltd, it was launched in 2 000, businessman and former Investment Banker with U.S.$1 million fro m his capital.…

    • 320 Words
    • 4 Pages
    Satisfactory Essays