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.
Required:
- 1. For each department, choose an allocation base and distribute the departmental costs to the college’s three divisions. Justify your choice of an allocation base.
- 2. Would you have preferred a different allocation base than those available using the data compiled by the comptroller? Why?
- 3. Build a spreadsheet: Construct an Excel spreadsheet to solve requirement (1) above. Show how the solution will change if the following information changes: the costs incurred by the departments were $120,000, $160,000, and $360,000, for Admissions, Registrar, and Computer Services, respectively.
1.
Choose an allocation base and distribute the departmental costs to the three divisions of the college for each department.
Explanation of Solution
Cost Allocation: The process of assigning the cost to the cost object is cost allocation. The cost allocation is done by the accountant to allocate the manufacturing overhead cost to different divisions.
Cost allocation base: An allocation base is the measure of activity, economic characteristic or physical characteristic that is related with responsibility centers.
Select an allocation base and distribute the departmental costs to the three divisions of the college for each department:
Division | ||||
Department and allocation base | Liberal arts | Sciences | Business administration | Total cost allocated |
Admissions (enrollment) | (1)$36,000 | (4)$$28,800 | (7)$$25,200 | $90,000 |
Registrar(credit hours) | (2)$56,250 | (5)$$52,500 | (8)$$41,250 | $150,000 |
Computer Services(courses requiringcomputer) | (3)$64,000 | (6)$$128,000 | (9)$$128,000 | $320,000 |
Table (1)
- The costs for admissions department are assigned on the basis of enrollment. If the numbers of students enrolled are more in a division then more admissions are there to process.
- The cost for registrar department is assigned on the basis of credit hours. Higher the number of credit hours, the more course registrations are there to process.
- The cost for computer science department is assigned on the basis of the number of courses requiring computer work. Higher the number of computer-intensive courses, higher will be the demands placed on the computer service department.
Working notes:
(1)Calculate the admissions department’s distribution of costs for Division Liberal arts:
(2)Calculate the registrar department’s distribution of costs for Division Liberal arts:
(3)Calculate the computer service department’s distribution of costs for Division Liberal arts:
(4)Calculate the admissions department’s distribution of costs for Division science:
(5)Calculate the registrar department’s distribution of costs for Division science:
(6)Calculate the computer service department’s distribution of costs for Division science:
(7)Calculate the admissions department’s distribution of costs for Division Business administration:
(8)Calculate the registrar department’s distribution of costs for Division Business administration:
(9)Calculate the computer service department’s distribution of costs for Division Business administration:
2.
State whether different allocation base can be preferred than those that are available using the data compiled by the computer.
Explanation of Solution
- The number of courses is possibly the most appropriate allocation base for the registrar’s costs. Costs in this department are determined by processing course registration and not driven by the credit hours. Four credit hours do not need any more registration effort than a three credit course.
- The requirement of estimated amount of computer time is possibly the most appropriate allocation base for the computer science department. Two different courses requiring computer work can place difference demands on the department of computer science.
3.
Prepare excel to show the change in the information.
Explanation of Solution
Prepare excel to show the change in the information:
Figure (1)
Working note:
Figure (2)
Want to see more full solutions like this?
Chapter 12 Solutions
MANAGERIAL ACCOUNTING-CONNECT ACCESS
- The Science Institute has three departments: Biology, Chemistry, and Physics. The institute's controller wants to estimate the cost of operating each department. He has identified several indirect costs that must be allocated to each department including $52,000 of indirect salaries, $9,000 of office supplies, and $41,000 of office rent. There are 500 students in the biology department, 200 in chemistry and 300 in physics. The director of the Institute wants to know how much of the indirect cost to allocate to each department. Based on this information the amount of the cost to be allocated is $102,000. the indirect cost is the "allocation base". the students are the "cost objects". All of the answers are correct.arrow_forwardTroglodyte University uses activity-based costing to assign indirect costs to academic departments, using three activities. The activity base, budgeted activity cost, and estimated activity-base usage for each activity are identified as follows: Activity Activity Base BudgetedActivity Cost Activity-BaseUsageFacilities Square feet $800,000 80,000 square feetInstruction Number of course sections 1,200,000 600 sectionsStudent services Number of students 290,000 2,500 studentsThe activity-base usage associated with the Archaeology and Geology departments is as follows:Department Facilities Instruction Student ServicesArchaeology 8,000 square feet 8 sections 150 studentsGeology 5,200 square feet 15 sections 200 studentsa. Determine the activity rate for each activity.Activity Activity RateFacilities $ per sq. ft.Instruction $ per sectionarrow_forwardTroglodyte University uses activity-based costing to assign indirect costs to academic departments, using three activities. The activity base, budgeted activity cost, and estimated activity-base usage for each activity are identified as follows: Activity Activity Base BudgetedActivity Cost Activity-BaseUsage Facilities Square feet $800,000 80,000 square feet Instruction Number of course sections 1,200,000 600 sections Student services Number of students 290,000 2,500 students The activity-base usage associated with the Archaeology and Geology departments is as follows: Department Facilities Instruction Student Services Archaeology 8,000 square feet 8 sections 150 students Geology 5,200 square feet 15 sections 200 students Determine the activity rate for each activity. Activity Activity Rate Facilities per sq. ft. Instruction per section Student services per…arrow_forward
- Troglodyte University uses activity-based costing to assign indirect costs to academic departments, using three activities. The activity base, budgeted activity cost, and estimated activity-base usage for each activity are identified as follows: Activity Activity Base BudgetedActivity Cost Activity-BaseUsage Facilities Square feet $800,000 80,000 square feet Instruction Number of course sections 1,200,000 600 sections Student services Number of students 290,000 2,500 students The activity-base usage associated with the Archaeology and Geology departments is as follows: Department Facilities Instruction Student Services Archaeology 8,000 square feet 8 sections 150 students Geology 5,200 square feet 15 sections 200 students a. Determine the activity rate for each activity. Activity Activity Rate Facilities $fill in the blank 1 per sq. ft. Instruction $fill in the blank 2 per section Student services $fill in the blank 3 per student b. Determine the…arrow_forwardMiracle Consulting Corporation has its headquarters in Chicago and operates from three branch offices in Portland, Dallas, and Miami. Two of the company's activity cost pools are General Service and Research Service. These costs are allocated to the three branch offices using an activity-based costing system. Information for next year follows: Activity Cost Pool Activity Measure Estimated Cost General service % of time devoted to branch $ 700,000 Research service Computer time $ 140,000 Estimated branch data for next year is as follows: % of time Computer time Portland 30 % 200,000 minutes Dallas 60 % 150,000 minutes Miami 10 % 50,000 minutes How much of the headquarters cost allocation should the Dallas office expect to receive next year? Multiple Choice $409,500. $472,500. $504,000. $280,000.arrow_forwardParker Company has two service departments, Cafeteria and Engineering, and two operating departments. The number of employees in each department is given below: Cafeteria 10 Engineering 40 Operating Department 1 500 Operating Department 2 200 The company uses the step method to allocate service department cost. Cafeteria is allocated first, and then Engineering. The costs of the Cafeteria are allocated to other departments on the basis of number of employees in the departments. If Cafeteria costs are budgeted at R69 375, the amount of cost allocated to Operating Department 2 would be closest to: A. R18 500 B. R18 750 C. R19 821 D. R46 875arrow_forward
- Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $55,660 2,200 Network center Number of devices monitored 668,100 10,200 Electronic mail Number of user accounts 57,500 5,750 Handheld technology support Number of handheld devices issued 153,600 9,600 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has 1,000 employees, of whom 50% are office employees.…arrow_forwardIdentify Activity Bases For a major university, select the activity base most appropriate for each cost listed below. An activity base may be used more than once or not used at all. Cost: Activity Base: 1. Financial aid office salaries 2. Office supplies 3. Instructor salaries 4. Housing personnel wages 5. Employee wages for maintaining student records 6. Admissions office salariesarrow_forwardThe director of public works needs to distribute the indirect cost allocation of $1.2 million to the three branches around the city. She will use the information from last year to determine the rates for this year. a. Determine this year’s indirect cost rates for each branch. b. Use the rates from last year and records for this year to distribute the allocation for this year. How much of the $1.2 million is actually distributed?arrow_forward
- Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $160,000 3,200 Network center Number of devices monitored 735,000 9,800 Electronic mail Number of user accounts 100,000 10,000 Handheld Technology support Number of handheld devices issued 124,600 8,900 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has 5,200 employees, of whom 25% are office…arrow_forwardMiddler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $82,350 2,700 Network center Number of devices monitored 631,125 9,350 Electronic mail Number of user accounts 63,500 6,350 Handheld technology support Number of handheld devices issued 140,800 8,800 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has 1,000 employees, of whom 30% are office employees.…arrow_forwardMiddler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $82,350 2,700 Network center Number of devices monitored 631,125 9,350 Electronic mail Number of user accounts 63,500 6,350 Handheld technology support Number of handheld devices issued 140,800 8,800 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has 1,000 employees, of whom 30% are office employees.…arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning