Salem Telephone Company

512 Words3 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? The expenses that are variable with respect to revenue hours are: • Power • Operations of Hourly Personnel 2. For each expense that is variable with respect to revenue hours, calculate the cost per revenue hour. Expense January February March Power: Cost 1,546 1,485 1,697 Total Revenue Hours 329 316 361 Cost per Revenue Hour $4.70 $4.70 $4.70 Hourly Personnel: Cost 7,896 7,584 8,664 Total Revenue Hours 329 316 361 Cost per Revenue Hour $24.00 $24.00 $24.00 Total Cost per Revenue Hours = $4.70 + $24.00 = $28.70 3. Create a contribution margin income statement for Salem Data Services. Assume that intracompany usage is 205 hours. Assume commercial use is at the March level. Also assume that the Sales Promotion and Corporate Services expenses will be at the same levels as in March. Salem Data Services Contribution Margin Income Statement For the Quarter Ended March 31, 2004 Revenues Intracompany $ 82,000 Commercial 110,400 Total Revenues: $ 192,400 Less: Variable Expenses Power (at $4.70) $ 1,612 Operations: Hourly Personnel (at $24.00) 8,232 Total Variable Expenses: $ 9,844 Contribution Margin $ 182,556 Less: Fixed Expenses Rent $ 8,000 Custodial Services 1,240 Computer Leases 95,000 Maintenance 5,400 Depreciation 26,180 Operations: Salaried Staff 21,600 Systems Development & Maintenance 12,000 Administration 9,000 Sales 11,200 Sales Promotion 8,083 Corporate Services 15,236 Total Fixed Costs: $ 212,939 Net Income $ (30,383) 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

More about Salem Telephone Company

Open Document