Question

Problem 2-71 (Algo) Cost Allocation and Regulated Prices (LO 2-3)

The City of Imperial Falls contracts with Evergreen Waste Collection to provide solid waste collection to households and businesses. Until recently, Evergreen had an exclusive franchise to provide this service in Imperial Falls, which meant that other waste collection firms could not operate legally in the city. The price per pound of waste collected was regulated at 20 percent above the average total cost of collection.

Cost data for the most recent year of operations for Evergreen are as follows.
  

Administrative cost	$	414,000
Operating costs—trucks		1,350,000
Other collection costs		334,000

Data on customers for the most recent year are as follows.

	Households	Businesses
Number of customers	13,400	5,800
Waste collected (tons)	5,400	14,800

The City Council of Imperial Falls is considering allowing other private waste haulers to collect waste from businesses, but not from households. Service to businesses from other waste collection firms would not be subject to price regulation. Based on information from neighboring cities, the price that other private waste collection firms will charge is estimated to be $0.04 per pound (= $80 per ton). (1 ton = 2,000 pounds)

  

Evergreen's CEO has approached the city council with a proposal to change the way costs are allocated to households and businesses, which will result in different rates for households and businesses. She proposes that administrative costs and truck operating costs be allocated based on the number of customers and the other collection costs be allocated based on pounds collected. The total costs allocated to households would then be divided by the estimated number of pounds collected from households to determine the cost of collection. The rate would then be 20 percent above the cost. The rate for businesses would be determined using the same calculation.

Required:

a. Based on cost data from the most recent year, what is the price per pound charged by Evergreen for waste collection under the current system (the same rate for both types of customers)?

b. Based on cost and waste data from the most recent year, what would be the price per pound charged to households and to businesses by Evergreen for waste collection if the CEO’s proposal were accepted?

	Households	Businesses
Allocated cost per customer	$92 correct	$92 answer correct
Total allocated cost	$	$
Average allocated cost per pound	$	$
Price	$	$

I am STUMPED. I cannot get the correct answer for total allocated cost, average allocated cost per pound or price. Help my accounting gods!

Answer 1

a.	Total cost:
				$
	Administrative cost			414,000
	Operating costs—trucks			1,350,000
	Other collection costs			334,000
	Total cost			2,098,000
				Households	Businesses	Total
	Waste collected (tons)			5400	14800
	Waste collected (pounds)			10800000	29600000	40400000
				(5400*2000)	(14800*2000)
	Cost per pound=Total cost/Total waste collected (pounds)=2098000/40400000=0.0519
	Price per pound:
				$
	Cost per pound			0.0519
	Add: Markup at 20%			0.0104
	Price per pound			0.0623
b.	Cost allocation:
				Households	Businesses	Total
	Administrative cost			288937.5	125062.5	414000
	(Based on number of customers)			414000*(13400/19200)	414000*(5800/19200)
	Operating costs—trucks			942187.5	407812.5	1350000
	(Based on number of customers)			1350000*(13400/19200)	1350000*(5800/19200)
	Other collection costs			89287.12871	244712.8713	334000
	(Based on pounds collected)			334000*(108/404)	334000*(296/404)
	Total allocated cost		a	1320412.129	777587.8713	2098000
	Number of customers		b	13400	5800
	Allocated cost per customer (a/b)			98.5382	134.0669
	Waste collected (pounds)           c			10800000	29600000
	Average allocated cost per pound (a/c)			0.1223	0.0263
	Add: Markup at 20%			0.0245	0.0053
	Price per pound			0.1467	0.0315