Every year, the administration at ND University receives funding from the provincial government. This year, the government announced that due to budget cuts, it would be providing significantly less funding Although ND University has yet to hear what the actual amount of the cut will be, the administration has decided to be proactive and try to identify ways to be more efficient with its money Each year, each department is given an equal amount of money per student registered in the depart- ment. For example, the accounting department is given the same amount per student as the science department. In addition, the university gives an equal amount per student regardless of whether the student is a graduate student or an undergraduate student. As such, the university assumes that all students cost the same amount of money. During a recent town hall meeting to discuss the budget cuts, one faculty member brought up the idea that some departments run cash surpluses at the end of each year, because they do not spend all the money provided per student. This might be an indication that some departments have students who cost the university less than others. One way to determine the cost of a student is by using the activity-based costing (ABC) method. The president of the university, Mahmud Yazbek, has hired you, a young professional accountant, to help understand how activity-based costing may help to understand the cost of a student. President Yazbek has identified the major activities that the students engage in: lectures, labs, recruiting, administrative sup- port, student life support, and educational student support. In addition, he has identifed several overhead costs (Exhibit 1) and the percentage of time that each cost is spent on each activity. He has also provided you with a list of other information that he believes could act as cost drivers for each activity (Exhibit 2). Before President Yazbek rolls out this new method of costing, he would like to analyze whether the results wll be different from the existing method. The traditional method of allocating these costs has been to add up all of the costs and divide the amount by the total number of students attending the university to determine the cost per student. He has asked you, first, to determine an appropriate cost driver and, second, to determine the cost of an accounting student (graduate and undergraduate) versus the cost of a science student (gradu- ate and undergraduate). He would like you to prepare a report that includes your results and an analysis of your results. Required Prepare the report for President Yazbek.

Show transcribed data

Expert Answer

This solution was written by a subject matter expert. It's designed to help students like you learn core concepts.

Anonymous answered this149 answers

CATEGORY	TOTAL				ADMIN	STUDENT LIFE	EDUC STUDENT
		LECTURES	LABS	RECRUITING	SUPPORT	SUPPORT	SUPPORT
PROFESSOR'S SALARY	$ 21,851,700	65	15	5	0	5	10
TEACHING ASSISTANT SALARY	$ 3,015,000	5	60			10	25
INVIGILATORS SALARY	$ 753,750		10				90
LAB SUPERVISOR SALARY	$ 1,130,625		100
COUNSELLORS SALARY	$ 1,350,000			10	15	65	10
ADMISSION OFFICE SALARIES	$ 1,200,000			80	10	10
REGISTRAR'S OFFICE SALARIES	$ 480,000			25	70	5
LIBRARIAN'S SALARIES	$ 1,125,000	10	15	10	5	5	55
FOOD AND HOSPITALITY SALARIES	$ 10,500,000	5				95
JANITORIAL SALARIES	$ 15,750,000	10	10	10	5	65
CATEGORY	TOTAL				ADMIN	STUDENT LIFE	EDUC STUDENT
		LECTURES	LABS	RECRUITING	SUPPORT	SUPPORT	SUPPORT
PROFESSOR'S SALARY	$ 21,851,700	$ 14,203,605	$ 3,277,755	$ 1,092,585	$ -	$ 1,092,585	$ 2,185,170
TEACHING ASSISTANT SALARY	$ 3,015,000	$ 150,750	$ 1,809,000	$ -	$ -	$ 301,500	$ 753,750
INVIGILATORS SALARY	$ 753,750	$ -	$ 75,375	$ -	$ -	$ -	$ 678,375
LAB SUPERVISOR SALARY	$ 1,130,625	$ -	$ 1,130,625	$ -	$ -	$ -	$ -
COUNSELLORS SALARY	$ 1,350,000	$ -	$ -	$ 135,000	$ 202,500	$ 877,500	$ 135,000
ADMISSION OFFICE SALARIES	$ 1,200,000	$ -	$ -	$ 960,000	$ 120,000	$ 120,000	$ -
REGISTRAR'S OFFICE SALARIES	$ 480,000	$ -	$ -	$ 120,000	$ 336,000	$ 24,000	$ -
LIBRARIAN'S SALARIES	$ 1,125,000	$ 112,500	$ 168,750	$ 112,500	$ 56,250	$ 56,250	$ 618,750
FOOD AND HOSPITALITY SALARIES	$ 10,500,000	$ 525,000	$ -	$ -	$ -	$ 9,975,000	$ -
JANITORIAL SALARIES	$ 15,750,000	$ 1,575,000	$ 1,575,000	$ 1,575,000	$ 787,500	$ 10,237,500	$ -
TOTAL	$ 57,156,075	$ 16,566,855	$ 8,036,505	$ 3,995,085	$ 1,502,250	$ 22,684,335	$ 4,371,045
COST DRIVERS		LECTURE HOURS	LAB HOURS	NO. OF OFFER SENT TO POTENTIAL CUSTOMERS	NO. OF STUDENTS	NO. OF STUDENTS	NO. OF STUDENTS
COST ALLOCATION
	TOTAL	COST DRIVER FACTOR TOTAL	COST PER COST DRIVER FACTOR	ACCOUNTING (UNDER GRADUATE)	ACCOUNTING (GRADUATE)	SCIENCE (UNDER GRADUATE)	SCIENCE (GRADUATE)
LECTURE COST	$ 16,566,855	3,816,000	$ 4.34	$ 1,015,892.05	$ 50,013.15	$ 9,116,979.95	$ 250,065.74
LABS COST	$ 8,036,505	2,400,000	$ 3.35	$ 52,237.28	$ -	$ 4,018,252.50	$ 241,095.15
RECRUITMENT COST	$ 3,995,085	4,760	$ 839.30	$ 150,235.34	$ 15,107.46	$ 1,573,694.20	$ 53,715.43
OTHER SUPPORT COSTS	$ 28,557,630	14,645	$ 1,949.99	$ 1,267,494.67	$ 116,999.51	$ 9,749,959.03	$ 292,498.77
	$ 57,156,075