These are practice questions based on questions on final exam. Please include worksheets, Excel spreadsheets, and explanations with your answers. Some questions contain more than one answer. Please provide all answers. This question has 2 requirements (attached).

3/23/2017 2. Assignment Print View Award: 6.25 points 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 $130,000 221,000 468,000 Division Liberal Arts Sciences Business Administration Budgeted Budgeted Enrollment Credit Hours 2,300 43,000 1,450 37,750 1,350 31,750 Planned Courses Requiring Computer Work 25 37 37 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) previous next References Worksheet Difficulty: 2 Medium Learning Objective: 1204 Use a cost allocation base to allocate costs. http://ezto.mheducation.com/hm.tpx?todo=c15SinglePrintView&singleQuestionNo=2.&postSubmissionView=13252705294043667&wid=13252705367548311&ro... 1/1 3/23/2017 2. Assignment Print View Award: 6.25 points 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 $130,000 221,000 468,000 Division Liberal Arts Sciences Business Administration Budgeted Budgeted Enrollment Credit Hours 2,300 43,000 1,450 37,750 1,350 31,750 Planned Courses Requiring Computer Work 25 37 37 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 Choose the better allocation base for distributing the cost to the following departments: Registrar Computer Services previous next References Worksheet Difficulty: 2 Medium Learning Objective: 1204 Use a cost allocation base to allocate costs. http://ezto.mheducation.com/hm.tpx?todo=c15SinglePrintView&singleQuestionNo=2.&postSubmissionView=13252705294043667&wid=13252705367548311&ro... 1/1