Assigning Cost of Resources to Activities, Unbundling the General Ledger

Golding Bank provided the following data about its resources and activities for its checking account process:

Resources				Activities	Clerical Hours
Supervision		$74,000		Processing accounts		8,190
Phone and supplies		93,000		Issuing statements		4,620
Salaries		300,000		Processing transactions		6,090
Computer		23,000		Answering customer inquiries		2,100
Total		$490,000		Total		21,000

Computers are used only by the issuing (40 percent) and processing transaction (60 percent) activities.

Phone and supplies are 60 percent customer inquiries with the other 40 percent divided equally among the remaining activities, including supervising the checking operation.

The supervisor spends 100 percent of her time on supervision. In addition to the 21,000 clerical hours, there are 2,000 hours of supervision used (the hours used by the supervising clerks activity, which is not listed above).

Required:

Question Content Area

1. Prepare a work distribution matrix for the five primary activities. If an answer is zero, enter "0".

blank Golding Bank Percentage of Time on Each Activity

Activity	Supervisor	Clerks
Supervising clerks	fill in the blank d24d5903403ff8d_1%	fill in the blank d24d5903403ff8d_2%
Processing accounts	fill in the blank d24d5903403ff8d_3	fill in the blank d24d5903403ff8d_4
Issuing statements	fill in the blank d24d5903403ff8d_5	fill in the blank d24d5903403ff8d_6
Processing transactions	fill in the blank d24d5903403ff8d_7	fill in the blank d24d5903403ff8d_8
Answering customer inquiries	fill in the blank d24d5903403ff8d_9	fill in the blank d24d5903403ff8d_10

Feedback Area

Feedback

1. A work distribution matrix simply identifies the Amount of labor consumed by each activity. The supervising ratio is given. The remaining four ratios are calculated using the clerical hrs. total processing hours

Question Content Area

2. Calculate the cost of each activity. If required, round your answers to the nearest dollar.

Activity	Total
Supervising clerks	$fill in the blank 211f7efbb02b015_1
Processing accounts	$fill in the blank 211f7efbb02b015_2
Issuing statements	$fill in the blank 211f7efbb02b015_3
Processing transactions	$fill in the blank 211f7efbb02b015_4
Answering customer inquiries	$fill in the blank 211f7efbb02b015_5