Purchase Solution

Cost allocation

Not what you're looking for?

Ask Custom Question

Please see the attached file.

The following table shows the cost allocation bases used to distribute various costs among the hospital's divisions.
Cost Pool Cost Allocation Annual Cost
Facilities:
Building depreciation Square feet of space $190,000
Equipment depreciation
Insurance
Utilities:
Electricity Cubic feet of space 24,000
Waste disposal
Water and sewer
Cable TV and phone
Heat
General administration:
Administrator Budgeted number of employees 220,000
Administrative staff
Office supplies
Community outreach:
Public education Budgeted dollars of patient billings 40,000
Scholl physical exams

Shown below are the amounts of each allocation base associated with each division.
Square feet Cubic feet Number of Patient
Employees Billings
General Medicine Division 15,000 135,000 30 2,000,000
Surgical Division 8,000 100,000 20 1,250,000
Medical Support Division 9,000 90,000 20 750,000
Administrative Division 8,000 75,000 30 0
TOTAL 40,000 400,000 100 4,000,000

Required:
1. Prepare a table that distributes each of the costs listed in the preceding table to the hospital's divisions.
2. Comment on the appropriateness of patient billings as the basis for distributing community outreach costs to the hospital's divisions. Can you suggest a better allocation base?
3. Is there any use in allocating utilities costs to the divisions? What purposes could such an allocation process serve?
4. 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 were $200,000, $25,000, $200,000, and $50,000 for facilities, utilities, general administration, and community outreach, respectively.

Attachments
Purchase this Solution

Solution Summary

Excel file contains calculations of cost allocated to each division.

Purchase this Solution


Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.