Managerial Accounting: Creating Value in a Dynamic Business Environment
12th Edition
ISBN: 9781260417074
Author: HILTON, Ronald
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 12, Problem 31E
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Gipps Business College (GBC) has two degree programs, undergraduate (UG) and graduate (GRAD) and three service departments, information technology (IT), Event Planning (EP), and Career Services (CS). The CFO of GBC is conducting a profitability analysis of the two programs and wants to include the appropriate costs of the service departments in the costs of the two degree programs. As a part of the analysis, the CFO has collected the following usage patterns of the ser vice departments over the last two years.
Using Departments
Suppying Department
IT
EP
CS
UG
GRAD
IT
0
10%
20%
40%
30%
EP
0
0
25%
25%
50%
CS
0
0
0
60%
40%
Direct Costs
$ 70,000.00
$ 90,000.00
$ 100,000.00
To be determined
Required:-
a.) The CFO is unsure what the best way to allocate the cost is and has asked you for the allocations to the UG and GRAD programs using:
The direct method;
The step method starting with IT, followed by EP,…
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 $
118,000 Registrar 197,000 Computer Services 420, 000 Division Budgeted
Enrollment Budgeted Credit Hours Planned Courses Requiring Computer Work
Liberal Arts 1,100 31,000 12 Sciences 850 28,750 25 Business Administration
750 22,750 25 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:Recuired:
Dustroule the depurtmerital costs to the collegels three dwaish based on the
allocation bus ghen Chose the betier aliscation base for distr buting the cost to
the…
Burgess Business School has two degree programs, BBA and MBA. The school uses an ABC system to cost the three support services
it provides to students from both programs: Career Center, Events, and Library. Following are the costs of these three activities and the
cost drivers used in the system:
Activity
Cost
Activity
Career Center
Event planning and hosting.
Library
For the most recent year, data collected from the central IT systems indicate the following:
MBA
5,600
4,500
30,300
BBA
10,400
5,500
70,700
$ 448,000
440,000
606,000
Cost Driver
Interview-hours
Event attendance
Number of visits
Interview-hours
Event attendance
Library visits
Required:
a. Compute the cost-driver rates for the three activities at the school.
b. Suppose that in a future period, no students from the MBA program visited the Library. What amount of the Library cost would be
assigned to the MBA program?
Chapter 12 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
Ch. 12 - Why is goal congruence important to an...Ch. 12 - Define and give examples of the following terms:...Ch. 12 - Prob. 3RQCh. 12 - Explain the relationship between performance...Ch. 12 - Prob. 5RQCh. 12 - What is the key feature of activity-based...Ch. 12 - Prob. 7RQCh. 12 - Define and give examples of the following terms:...Ch. 12 - Give an example of a common resource in an...Ch. 12 - Explain how and why cost allocation might be used...
Ch. 12 - Define the term cost allocation base. What would...Ch. 12 - Referring to Exhibit 125, why are marketing costs...Ch. 12 - Prob. 13RQCh. 12 - Why do some managers and accountants choose not to...Ch. 12 - Why is it important in responsibility accounting...Ch. 12 - Prob. 16RQCh. 12 - Prob. 17RQCh. 12 - Prob. 18RQCh. 12 - Prob. 19RQCh. 12 - Prob. 21RQCh. 12 - Prob. 22RQCh. 12 - Prob. 23RQCh. 12 - Define the term manufacturing cycle efficiency.Ch. 12 - Prob. 25RQCh. 12 - What is meant by aggregate productivity, and what...Ch. 12 - For each of the following organizational subunits,...Ch. 12 - Prob. 28ECh. 12 - Prob. 29ECh. 12 - The following data pertain to the Waikiki Sands...Ch. 12 - Lackawanna Community College has three divisions:...Ch. 12 - Countywide Cable Services, Inc. is organized with...Ch. 12 - Prob. 36ECh. 12 - Prob. 37ECh. 12 - Prob. 38ECh. 12 - Prob. 39PCh. 12 - Prob. 40PCh. 12 - Prob. 41PCh. 12 - Rocky Mountain General Hospital serves three...Ch. 12 - Refer to the organization chart for Rocky Mountain...Ch. 12 - Prob. 44PCh. 12 - Buckeye Department Stores, Inc. operates a chain...Ch. 12 - Building Services, Co. (BSC) was started a number...Ch. 12 - Warriner Equipment Company, which is located in...Ch. 12 - Prob. 49PCh. 12 - MedTech, Inc. manufactures diagnostic testing...Ch. 12 - Prob. 51PCh. 12 - Cathys Classic Clothes is a retailer that sells to...Ch. 12 - Pacific Rim Industries is a diversified company...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- A company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950arrow_forwardPhoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departments administrative services (AS) and information systems (IS) and two operating departments-government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2020, Phoenix's cost records indicate the following: (Click the icon to view the cost records.) Read the requirements. Requirement 1a. Allocate the two support departments' costs to the two operating departments using the direct method. (Do not round intermediary calculations and round your final answers to the nearest whole dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances.) Operating Departments Support Departments AS GOVT CORP Direct Method Budgeted overhead costs before interdepartment cost allocations Allocation of AS costs Allocation of IS costs Total budgeted overhead of operating departments …………. IS Totalarrow_forwardDirect Method Seattle Western University has provided the following data to be used in its service department cost allocations: Required: Using the direct method, allocate the costs of the service departments to the two operating departments. Allocate the Administration cost on the basis of student credit-hours and the Facility Services cost on the basis of space occupied.arrow_forward
- Phoenix Partners provides management consulting services to government and corporate clients. Phoenix has two support departments administrative services (AS) and information systems (IS) and two operating departments-government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2020, Phoenix's cost records indicate the following: (Click the icon to view the cost records.) Read the requirements. Requirement 1c. Allocate the two support departments' costs to the two operating departments using the step-down method (Allocate IS first). (Do not round intermediary calculations and round your final answers to the nearest whole dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances.) Support Departments AS Operating Departments CORP Step-down Method IS GOVT Total Budgeted overhead costs 690,000 $2,100,000 $8,675,000 $12,490,000 $23,955,000 before interdepartment cost allocations Allocation of IS…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_forwardWhich of the following will give you the most accurate allocation between a cost's fixed component and variable component? a. Examination of a students’ registration forms for miscellaneous fees and tuition fees b. Use of the least squares method to allocate the cost of electricity c. Dividing the total cost on the water bill among the different departments based on direct labor hours d. Dividing the total cost of the postpaid plan using the high-low methodarrow_forward
- Comprehensive support department allocations (Need answers for parts C, D, and E please. Thank you!) Management at C. Pier Press has decided to allocate costs of the paper’s two support departments (administration and human resources) to the two revenue-generating departments (advertising and circulation). Administration costs are to be allocated on the basis of dollars of assets employed; human resources costs are to be allocated on the basis of number of employees. The following costs and allocation bases are available: Department Direct Costs Number of Employees Assets Employed Administration $390,750 5 $193,550 Human resources 246,350 4 145,850 Advertising 478,900 6 381,200 Circulation 676,300 13 935,150 Totals $1,792,300 28 $1,655,750 a. Using the direct method, allocate the support department costs to the revenue-generating departments.Note: Round percentages in your calculation to the nearest whole percent (for example, round 34.5% to 35%).Note:…arrow_forwardRoque Press has the service departments (administration and an and two operating departments (college texts and professional publications). Following are the direct costs and allocation bases for each of these areas: Department Administration Editorial College texts Professional publications Direct Costs P 450,000 350,000 2,250,000 950,000 a. P2,250,000 b. P2,702,566 c. P2,493,964 d. P2,458,602 ALLOCATION BASES Pesos of Assets Employed P 620,000 144,000 1,200,000 1,056,000 Number of Employees 10 8555 35 Company management has decided to allocate administration and editorial costs using the pesos of assets employed and number of employees, respectively. Using the reciprocal (algebraic) method: 29. What is the total operating cost after allocation of college textbooks?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-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_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 Determine the activity rate for each activity. Activity Activity Rate Facilities per sq. ft. Instruction per section Student services per…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: Budgeted Activity-Base Activity Activity Base Activity Cost Usage 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 per sq. ft. Instruction per section Student services per student b. Determine the total activity cost for the Archaeology Department. Total activity cost Nextarrow_forwardAtlanta Partners provides management consulting services to government and corporate clients. Atlanta has two support departments—administrative services (AS) and information systems (IS)—and two operating departments—government consulting (GOVT) and corporate consulting (CORP). For the first quarter of 2017, Atlanta's cost records indicate the following: Read the requirements2. Requirement 1a. Allocate the two support departments' costs to the two operating departments using the direct method. (Do not round intermediary calculations and round your final answers to the nearest whole dollar. Use parentheses or a minus sign when decreasing departments by allocating costs. Enter a "0" for any zero balances.) Support Departments Operating Departments Direct Method AS IS GOVT CORP Total Budgeted overhead costs before interdepartment cost allocations Allocation of AS costs…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
GE McKinsey Matrix for SBU Strategies; Author: Wolters World;https://www.youtube.com/watch?v=FffD1Ze76JQ;License: Standard Youtube License