Calculate activity rates for each of the activity cost pools

Assignment Help Accounting Basics
Reference no: EM13970396

Kolbec Community College (KCC) has 4,000 full-time students and offers a variety of academic programs in three areas: professional studies, arts, and technology. The professional studies programs prepare students for administrative and clerical jobs in a variety of professional settings, including accounting, medicine, and law. The arts program's offerings are wide ranging and include graphic design, digital animation, culinary arts, cosmetology, and music arts. The technology programs are also varied, including information technology, medical laboratory technology, electrical engineering technology, pharmacy technology, and natural resources technology.

The chief financial officer of KCC, Lynn Jones, has consistently emphasized to other mem- bers of the senior management team the importance of understanding the costs of delivering the various academic programs. To that end, the costing system used at KCC tracks the direct costs of each program, which are shown below on an annual basis, along with the number of full-time students:

 

 

Item

ProfessionalStudies

 

Arts

 

Technology

 

Total

Full-time students. . . . . . . . . . . . . . . . . . . .

2,000

1,000

1,000

4,000

Professors' salaries . . . . . . . . . . . . . . . . .   .

$1,260,000

$ 650,000

$ 780,000

$2,690,000

Administrative salaries . . . . . . . . . . . . . . .

105,000

70,000

70,000

245,000

Supplies . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

40,000

150,000

50,000

240,000

Teaching support . . . . . . . . . . . . . . . . . . . .

160,000

100,000

80,000

340,000

Facilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

   275,000

   150,000

   175,000

   600,000

Total direct cost . . . . . . . . . . . . . . . . . .

$1,840,000

$1,120,000

$1,155,000

$ 4,115,000

It is very important to understand the overhead costs consumed by each academic program at KCC in determining the full cost of operating the programs. Central administration at KCC allocates financial resources to academic programs based on the estimated full cost per student of delivering the program. The overhead costs at KCC are significant, totalling over 60% of direct costs. Total annual overhead costs at KCC are as follows:

Activity

Administrative

Facilities

Office

Central administration . . . . . . . . . . . . . . . . . . . . . . . . .

20%

5%

15%

Information systems technology. . . . . . . . . . . . . . . .

20%

15%

15%

Student counselling services . . . . . . . . . . . . . . . . . .   .

5%

5%

10%

Human resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

10%

5%

10%

Library operations. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

20%

60%

30%

Registrar's office . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

 25%

 10%

 20%

Total . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .   .

100%

100%

100%

Traditionally, KCC has allocated overhead costs to academic programs on the basis of the number of full-time students in each program. This approach was deemed appropriate since Jones reasoned that increasing the number of students at KCC would result in higher overhead costs (e.g., more facilities would be needed, more indirect support costs would be incurred, etc.). However, Jones is beginning to question the accuracy of the traditional approach since it results in a similar full cost per student for the arts and technology programs, which she feels doesn't make sense. Based on her knowledge of the programs, Jones feels that the technology program is probably more expensive to deliver than the arts program, but this does not come through in the traditional costing approach.

Jones recently attended a seminar on management techniques being used by leading edu- cational institutions that, among other topics, covered the basics of the ABC approach. She likes the idea of being able to assign indirect costs to academic programs on the basis of how much of the support activity resources are consumed by each program. If Jones's instincts are correct in that some programs consume more resources of certain activities than others, this could have a significant impact on the overhead costs assigned to each under the ABC approach.

Upon returning to KCC, Jones decides to implement ABC. She, along with Assistant CFO James West, begins by identifying the key activities used to support the teaching programs. Rather than getting too detailed with respect to identifying activities in the initial implemen- tation, Jones decides to keep the process manageable and comes up with six key activities. Next, based on a series of interviews with various KCC employees who work in the departments covered by the identified activities, Jones and West estimate the percentage of the total admin- istrative, facility, and office expense resources consumed by each activity. Again, to keep the process efficient, Jones rounds all percentages to the nearest 5%, figuring that a "close enough" approach will suffice for this initial implementation and recognizing that the estimates are subjective to begin with. The results are shown below:

Working with key personnel from each of the six activities shown above, Jones and West then identify the activity measure and the quantity of that measure used for each teaching program. Fortunately, KCC implemented an enterprise resource planning system a few years ago, which is already tracking much of the information needed regarding the activity mea- sures and the specific quantities for each academic program:

Activity

Measure

Professional

Arts

Technology

Central administration . . . . . . . . . . . . . . .

Hours spent on program

6,000

7,000

7,000

Information systems technology. . . . . .

Processing hours

6,000

3,000

12,000

Student counselling services . . . . . . . . .

Number of students counselled

180

115

205

Human resources . . . . . . . . . . . . . . . . . . . .

Number of admin. staff and faculty members

 

21

 

15

 

14

Library operations . . . . . . . . . . . . . . . . . . .

Number of library circulations

6,000

3,000

3,000

Registrar's office . . . . . . . . . . . . . . . . . . . . .

Full-time students

2,000

1,000

1,000

Required:

1. Using the traditional approach to assigning overhead costs to academic programs:

a. Calculate the predetermined overhead rate.

b. Assign the overhead costs to each academic program using the predetermined rate.

c. Calculate the total cost per student (direct costs plus overhead) of operating each academic program.

2. Using ABC, complete the following requirements:

a. Using Exhibit 7-7 as a guide, complete the first-stage allocation of overhead costs to academic programs.

b. Using Exhibit 7-8 as a guide, calculate the activity rates for each of the activity cost pools.

c. Using the activity rates calculated in (b), complete the second-stage allocation of over- head to academic programs.

3. Based on the results of (2), calculate the total cost per student (direct costs plus overhead) of operating each academic program.

4. Draft a memo to Jones explaining the key reasons for differences in the total cost per student of operating each academic program that arise between the traditional costing approach and ABC.

Reference no: EM13970396

Questions Cloud

Conduct a research on one of the top fifteen health care : In a Microsoft Word document, create a 2- page report, on the basis of your research. Provide at least two resources or journal articles referring to the selected organization.
When a shift in long-run aggregate supply curve will change : When A shift in the long-run aggregate supply curve will change? The globalized AS/AD curve is the standard AS/AD model with an added.
How the factors you selected might impact decisions : Describe drug treatment options for patients diagnosed with the type of cancer you selected. Explain the short-term and long-term implications of these treatments.
Prepare a reconciliation of the train company''s bank account : Prepare journal entries to adjust the Train Company's books to reflect the correct bank balance on December 31, 2007.
Calculate activity rates for each of the activity cost pools : Draft a memo to Jones explaining the key reasons for differences in the total cost per student of operating each academic program that arise between the traditional costing approach and ABC.
Describe the short-run and long-run effects on real output : Describe the short-run and long-run effects on real output and the price level for each the following events. Assume the economy begins at short-run and long-run equilibrium. Justify your responses with reasoning.
Describe the qualitative design of the article : This is for qualitative design. The same assignment but on qualitative design. It is Mater's level post as well. One page with at least one reference. In APA format. Question and articles for review are attached.
What will happen to prices of goods and services produced : What will happen to the prices of goods and services produced with minimum wage labor? What is your conclusion? Is this proposal a good idea or not? Explain why.
Discuss capital rationing and soft rationing : Discuss capital rationing and soft rationing and what are some of the important points to remember while estimating the cash flows of a project?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Budgeting usually begins with the sales forecast since this

the following is a statement by a management consultantmany managers claim that budgets are impractical because

  Starfleet corporation has one temporary difference at the

starfleet corporation has one temporary difference at the end of 2012 that will reverse and cause taxable amounts of

  Calculate the ending balance of raw materials

Calculate the ending balance of Raw Materials and calculate the ending balance of Work in Process - Prepare brief job-order cost sheets for Jobs 58, 59, and 60.

  Distribution of the resources for the city

During the year, $ 500,000 was collected in sales taxes. Entries to record the collection and distribution of the resources for the city are recorded in which of the following funds?

  Calculate the interest earned on the savings account

A friend has $5,000 that has been saved from her part-time job. She will need her money, plus any interest earned on it, in six months and has asked for your help in deciding whether to put the money in a bank savings account at 4.5% interest or to l..

  Operating activities by the indirect method

Compute the amount of cash provided by or used for operating activities by the indirect method.

  Record the two events in general journal format

Moore Corporation repurchased 4,000 shares of its own stock for $30 per share. The stock has a par of $10 per share. A month later Moore resold 2,500 shares of the treasury stock for $35 per share.

  An outside supplier has offered to sell the company similar

a company makes wheels which it uses in the production of childrens wagons. the companys costs to produce 260000 wheels

  Tim is a single cash method taxpayer with one personal

tim is a single cash method taxpayer with one personal exemption. in april of this year tim paid 1020 with his state

  Important for clients of accounting firms

Why do you think it is important for clients of accounting firms to be ethical? How could a corporation integrate ethical behavior into its code of conduct and internal controls?

  Why are audit objectives important in planning and

why are audit objectives important in planning and performing an audit? explain the differences between transaction

  Process for evaluating the success of the new system

Propose a process for evaluating the success of the new system and a procedure for implementing software fixes and enhancements. Provide specific examples to support your response.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd