# Salem Telephone Case

Satisfactory Essays
984 Words
Grammar
Plagiarism
Writing
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

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

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

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. Revenues Intracompany Commercial Total Revenues Less Variable Expenses Contribution Margin Fixed Expenses Rent…

• 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

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

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

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

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.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