ABC System For Baulkham Hills Shire Council Animal Shelter

Cost Allocation using a Costing System

The assignment must be completed as a group assignment for face to face students.Distance students have the option of doing it as a group or can also submit as an individual assignment, if you are unable to form a group online. Face to face students will be allocated into groups of 4-5 members by your respective Lecturer. Distance students can form groups themselves via the discussion forum on Moodle.Before starting this assessment please read information provided in the Plagiarism and Academic Misconduct tab on Moodle.

Students are to exhibit knowledge of the subject matter by demonstrating:
? Demonstrating accuracy in accounting calculations.
? Understanding and the ability to analyse and interpret the information from
the calculations undertaken.
? Breadth of quality of analyses and providing appropriate guidance to management decision making.
? Communication – use of appropriate grammar and the use of appropriate format.
? Correctly using the APA referencing system to cite academic sources in-text and in the reference list. Sufficient sources used – minimum of 4-6

Allocation of marks
Please refer to the marking rubric provided for this assessment task. Please ensure that you use the correct referencing style (APA style) as stated in the Unit Profile.Formatting You are required to consider the case study provided and write an executive report using Power Point. Your report should be set out in an appropriate format under
the following headings:
1. Executive summary – one page – an overview of the important issues and their background, and providing a summary of your findings.
2. Analysis – details of the analysis undertake and the results. All calculations should be shown. 

3. Findings – detail and justify your findings from the analysis. Take care to recognise and describe any limitations.
4. Action items/limitations – detail the limitations from the analysis. Identify potential areas for actions to be undertaken by the organisation.
5. The report must not exceed 8 Power Point Slides (excluding references andappendices, if any) using the Times New Roman Font, font sizes between 16-18

Submission requirements
You must submit your assignment in Power Point format electronically through the secure upload facility in the Moodle system. Please do not email your assignment to your lecturer or the Unit Coordinator. Please ensure all details are complete in the Cover sheet and ensure that it is the FIRST page of your assignment.These are the minimum requirements as outlined in the marking criteria available on the moodle site. However, students should note that satisfactorily meeting the minimum requirements will typically only result in the minimum pass grade being
awarded. Higher grades will be awarded for students that exceed these minimum requirements. See the marking criteria for further details.

Assignment questions
Baulkham Hills Shire Council owns and operates an animal shelter that performs three services: housing and finding homes for stray and unwanted animals, providing health care and nurturing services for the animals, and pet training services. One facility is dedicated to housing animals waiting to be adopted. A second facility houses veterinarian services. A third facility houses the director, his staff, and several dog trainers. This facility also has several large meeting rooms that are frequently used for classes given by the animal trainers. The trainers work with all of the animals to ensure that they are relatively easy to manage. They also provide dog obedience classes for adopting families. Estimated annual costs for the animal shelter and its services are as follows:

Director and staff salaries $60,000
Animal shelter employees’ salaries 100,000
Veterinarians and technicians 150,000
Animal trainers 40,000
Food and supplies 125,000
Building-related costs 200,000
On average, 75 animals per day are housed at the facility, or about 27375 (75 x 365)animal days in total. The number of animals housed during the year totalled 4500.In addition, the trainers offer about 125 classes during the year, i.e., about 30 weeks 

throughout the year. On average, 10 families attend each class. Last year the veterinarian clinic experienced 5000 animal visits.You have been newly appointed as one of the Director’s staff members and have been asked to set up an ABC system for the shelter so that the Director can better understand the cost for each of the shelter’s services. You gather the followinginformation:

Square footage for each facility:  Animal shelter 5000 square feet  Director and training 3000 square feet  Veterinarian clinic 2000 square feet Percentage of trainer time used in classes 50% Supplies used for veterinarian services $75,000

Cost Allocation using a Costing System

total indirect cost = 20000+60000+40000= $300000
Under the costing system, all indirect cost are allocated based on one cost attribute. In the given scenario it is square foot occupied by each division. Using this we have:
 - animal shelter: indirect cost per unit= 150000/5000=$30, direct cost per unit = 150000/5000 = $30.
 -veterinarian clinic: indirect cost per unit = 60000/2000= $30, direct cost per unit =225000/2000= $113
 -training: indirect cost per unit= 90000/3000.

we have then divided the total cost by the unit of each division:
 - animal shelter= 150000/4500= $67 per animal housed
 - clinic= 285000/5000= $57 per animal nursed
 - training= 9000/125= $720 per meeting

Activity Based Costing
Cost Pool Selection
We have been provided with data of Baulkham Hills Shire Council’s animal shelter. In order to identify the cost pools for the shelter, we have identified the characteristics which can help us identify the costs consumed separately for each of the divisions of the shelter-
 - Building related cost- these costs have been selected as a cost pool as the divisions individually take up floor space (Datar,2016).
 - Salaries- these costs have been selected as a cost pool as the services used for each division can be identified.
 - Food and supplies- the consumption of food and supplies can be identified according to the animals supported by each division (Datar,2016).
Hence these costs have been identified as separate cost pools.

Cost Driver Selection
The cost drivers of each cost pool is required to be identified based on the attribute that can easily be traced back to the division (Horngren, 2012).
 - Using are occupied for building related cost- since the use of building is based on area occupied, we have used the area occupied as a cost driver to allocate the building related expense.
 - Using the services provided by the employees in order to allocate salaries-the cost of services provided by the employees have been allocated based on functions, for example, salaries of the training staff will be allocated to the training centre.
 - Using the amount of other cost based on nature in order to allocate other costs- the costs incurred on food and supplies are allocated based on the nature of expense. For example, the food expenses are to be incurred for shelter and the supplies are to be used for veterinarian clinic.

Findings:
The following are to be considered for the above calculations:
 - Director and staff salaries have been totally charged to director and training division, as this facility houses the director, staff and other trainers
 - the animal shelter employees salaries have been totally charged to animal shelter division, as this facility uses the services provided by them
 - the salaries for veterinarians and the technicians have been totally charged to veterinarian clinic, as this facility uses the services provided by them
 - the 50% of the expenses have been charged to the director and training division and the reaming has been charged to animal shelters division, as the services of the technicians are used to train the sheltered animals.
 - $75000 of food and supplies has been charged to the clinic as mentioned, and the remaining expenses for food and supplies for $50000 has been charged to animal shelter, as the food expenses are to incurred on the animals housed
 - the building related cost have been charged based on area occupied by each division.
 In order to identify the cost per activity, we have allocated the costs of each division based on the activity(White, 2009):
 - Cost of animal shelter has been determined for each animal sheltered. The shelter housed 4500 animals for the year; cost of sheltering one animal for an entire year is $60.
 - Costs of the director and training division have been determined for each family attending a class. The division had offered about 125 meetings with 10 families attending each meeting; this means total 1250 families attended the meeting. Based on this data we have $112 for each family attending the classes.
 - Cost of the veterinarian clinic is based on the number of animal visits taking place. Cost incurred on each animal visit is $53 per visit for a year.

Limitations:
Though activity based costing provides better costing data, it has a few limitations:
 - collection of data required to execute activity based costing is very large, this requires too much manpower and resources
 - execution of activity based costing requires a trained professional, which makes it burdensome for the company
 - too much information may sometimes lead to confusion and wrong analysis
 - it becomes difficult to identify cost drivers for some activities, which make it difficult to allocate the costs 
Therefore, we see that there are some limitations of activity based costing which can sometimes harm the cost allocation process.

Conclusion

Therefore, the cost data collected will help the management understand the cost incurred on every activity taking place in each division. This will help them manage costs.
Using the results of the activity based costing, will help the management understand which of the divisions has been consuming more costs. Having an insight into the cost consumption of various functions, will help the management in better allocation of resources. The management can set budgets and appropriate resources, which will help in better functioning of the animal shelter.

References

Atkinson, A. A. (2012). Management accounting. Upper Saddle River, N.J.: Paerson.
Boyd, W. K. (2013). Cost Accounting For Dummies. Hoboken: Wiley.
Datar, S. (2015). Cost accounting. Boston: Pearson.
Datar, S. (2016). Horngren's Cost Accounting: A Managerial Emphasis. Hoboken:   Wiley.
Horngren, C. (2012). Cost accounting. Upper Saddle River, N.J.: Pearson/Prentice  Hall.
White, T. S. (2009). The 60 minute ABC book. Bedford: Consortium for Advanced   Manufacturing International.