Question

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 Admissions Registrar Computer Services Annual Cost $125, eee 211,800 448,000 Planned Courses Requiring Computer Work Division Liberal Arts Sciences Business Administration Budgeted Enrollment 1,809 1,200 1. 100 Budgeted Credit Hours 38,800 34,800 28, eee 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: Complete this question by entering your answers in the tabs below. Required 1 Required 2 Distribute the departmental costs to the college's three divisions based on the allocation base given. (Do not round intermediate calculations. Round your final answers to the nearest whole dollar.) Division Department and Allocation Base Liberal Arts Sciences Business Administration Total Cost Allocated Admissions (enrollment) Registrar (credit hours) Computer Services (courses requiring computer) Required 1 Required 2 >

Answer 1

Calibri - V11 VAA = ab Wrap Text General - 6. 0 BIU - H- A- 00 Merge & Center - 9' . % 0 Conditional Format as Formatting Table Styles Cell Styles -ard Font Alignment Number A B C D Division partment Allocation Base Ratio Liberal Art Sciences Business Administration Total Cost Allocation mission Enrollment 18:12:11 $54,878 $36,585 $33,537 $1,25,000 gistrar Credit Hours 38:34:28 $80,180 $71,740 $59,080 $2,11,000 mputer Science Course Requiring Computer 20:33:32 | $1,05,412 $1,73,929 $1,68,659 $4,48,000