Salem Telephone Company Case Study
Essay by skbaril • February 4, 2012 • Case Study • 646 Words (3 Pages) • 2,623 Views
Salem Telephone Company Case Study
Group 9
1) The costs that vary as a result of revenue hours are power and hourly personnel costs. As additional revenue hours are realized, the cost to power the computers and to pay the personnel to assist commercial consumers will increase. Each additional revenue hour results in an increase in expenses.
Rent, custodial services, computer leases, maintenance, computer equipment, office equipment and fixtures, salaried staff, systems development and maintenance, administration and sales are all fixed. These expenses are not dependent on the number of revenue hours and are all fixed across the three months. The expenses will be incurred whether 0 or 200 revenue hours are realized.
Sales promotion and corporate services costs are variable, but they are not dependent on the number of revenue hours. Sales promotion expenses are independent of revenue hours. While the sales promotion expenses would reasonably be expected to rise as the expected revenue rises, there is no direct correlation to the revenue hours. The corporate services expense category is based on total wages and salaries, accounts receivable, and past-due accounts. The corporate services expense is variable only to the extent that hourly personnel make up the total corporate service expense balance. Because this value is not solely tied to revenue hours, corporate services must be treated as a fixed cost related to revenue hours.
2) The variable cost per revenue hour is $28.70.
Variable Costs January February March
Power $1,546 $1,485 $1,697
Hourly Personnel $7,896 $7,584 $8,664
Total Variable Costs $9,442 $9,069 $10,361
Hours 329 316 361
Variable Cost per Hour $28.70 $28.70 $28.70
3) The contribution margin per unit for Intracompany revenue hours is $371.30 ($400.00 - $28.70). The contribution margin per unit for Commercial hours is $771.30 ($800.00 - $28.70).
4) The commercial revenue hours needed to break even each month is 178 hours.
Revenue = Costs
(RI*QI + RC*QC) = (CM*(QI+QC) + CF)**
**Fixed costs assumed to include the March expense amount for sales promotion and corporate services expenses that have varied by month.
($400*205 + $800*QC) = ($28.70*(205+*QC) + $212,939)
QC*($800 - $28.70) = $212,939 + $5,883.50 - $82,000
QC= $136,823 / $771.30 = 178 Hours
...
...