Exercise 12-31 Cost Allocation in a College (LO 12-4)

Lackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended.

PLEASE SEE the attached pdf for the entire. ALSO, please note that the answers I put into the table for cost allocation are wrong. Kindly show your work.

Exercise 12-31 Cost Allocation in a College (LO 12-4) Lackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended. Department Annual Cost Admissions $ 131,000 Registrar 223,000 Computer Services 472,000 Planned Courses Budgeted Budgeted Requiring Division EnrollmentCredit Hours Computer Work Liberal Arts 2,400 44,050 26 Sciences 1,500 38,500 38 Business Administration 1,400 32,500 38 Required: 1. Distribute the departmental costs to the college's three divisions based on the allocation base given. 2. Choose the better allocation base for distributing the cost to the following departments