E$4-15($Algo$)$ Computing Activity Rates, Assigning Costs for a Service Industry $[$LO $4-3,4-4,4-5,4-7]$

The University of Dental Health $($UDH$)$ is a state$-$run university focusing on the education and training of dentists, dental assistants, dental hygienists, and other dental professionals. The university provides both traditional undergraduate courses to $13,300$ students and continuing professional education $($CPE$)$ courses to $5,700$ practicing professionals. UDH has just hired a new controller who wants to utilize ABC $.$ The controller has identified three key activities performed by the university and the cost of each of these activities:

UDH has three buildings with a total of $190,000$ square feet of classroom and facility space. Due to the large space requirements for labs and other training facilities, the undergraduate program utilizes $152,000$ square feet. Total cost, $$2,166,000$

UDH offers career placement services for undergraduate students, career counseling for active professionals taking CPE courses, and other student services to both groups. Total cost, $$608,000.$

UDH offers $1,300$ different instructional courses each year, $780$ of which are undergraduate courses. Total cost, $$3,510,000.$

Required:

Compute an activity rate for each of the three activities identified by the controller

Compute cost driver values and activity proportions for each group of students for each activity.

Determine the amount of costs assigned to each group of students and the cost per student to UDH to provide these three key activities.

Complete this question by entering your answers in the tabs below.

Required $1$

Required $2$

Required $3$

Determine the amount of costs assigned to each group of students and the cost per student to UDH to provide these three key activities.

Note: Do not round your activity rates or activity proportions.

$\backslash$table$[[$Activity$,$Activity Cost Driver,Cost,Undergraduate,CPE$],[$Facilities$,$Square Feet,$$2,166,000,,],[$Services$,$Number of Students,$$3r08,000,,],[$Instruction$,$Number of Courses,$$r3,510,000,,],[$Total Cost Assigned,,,,$],[$Number of Students,,,,$],[$Cost per Student,,,,$]]$

Screenshot $2024-07-23202114.$png

Required $1$

Required $2$

Required $3$

Determine the amount of costs assigned to each group of students and the cost per student to UDH to provide these three key activities

Note: Do not round your activity rates or activity proportions.

$\backslash$table$[[$Activity$,$Activity Cost Driver,Cost,Undergraduate,CPE$],[$Facilities$,$Square Feet,$$r2,166,000,,],[$Services$,$Number of Students,$$rr08,000,,],[$Instruction$,$Number of Courses,$$3,510,000,,],[$Total Cost Assigned,,,,$],[$Number of Students,,,,$],[$Cost per Student,,,,$]]$

Required $3$

Screenshot $2024-07-23202056.$png

Required $1$

Required $2$

Required $3$

Compute cost driver values and activity proportions for each group of students for each activity.

$\backslash$table$[[$Activity$,$Activity Cost Driver,,Cost,Undergraduate,$\backslash$table$[[$Activity$],[$Proportion$]],$CPE,$\backslash$table$[[$Activity$],[$Proportion$]],$Total,Total Proportion$],[$Facilities$,$Square Feet,$$,2,166,000,,,,,,],[$Services$,$Number of Students,$$,608,000,,,,,,],[|$ Instruction,Number of Courses,$$,3,510,000,,,,,,]]$

Required $1$

Required $3>$