Question

Allocation Direct Method

10 Revenues: 12 13 Adult Medicine 14 Obstetrics 15 Pediatrics 16 Total revenues $ 12,000,000 6,000,000 2,000,000 $ 20,000,000

32 Allocation Matrix 33 34 Services Percentage of Services Provided by 35 Provided to Administration Facilities Finance 36 37

44 45 H 1 46 47 48 ALLOCATION CALCULATIONS 49 50 PART 1 51 DIRECT METHOD: Patient Service 52 Adult Medicine Obstetrics Pediat

Part 1 use provided info to complete table using direct method.
part 2 use provided data to complete table using step-down method.

8 INPUT DATA KEY OUTPUT 10 Revenues 11 Profit and Loss Statements 12 PART 3 (INSERT INFORMATON FROM INPUT DATA AND PARTS 1 AN

null

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer with working is given below

PART 1 DIRECT METHOD Administration allocation Facilities Allocation Finance Allocation Total Adult Patient Obstetrics Pediat

DIRECT METHOD Administration allocation Facilities Allocation Finance Allocation Adult Patient Obstetrics Pediatrics Medicines Services Total $437,500 $250,000 $312,500 $1,000,000 $2,847,059 $517,647 $1,035,294 $4,400,000 $1,000,000 $500,000 $300,000 $1,800,000 $4,284,559 $1,267,647 $1,647,794 $7,200,000 STEP-DOWN METHOD Administration Facilities Finance Adult Medicines Obstetrics Pediatrics Total Cost -$1,000,000 Administration allocation Facilities Allocation Finance Allocation $100,000 -$4,500,000 $100,000 $473,684 -$2,373,684 $350,000 $200,000 $250,000 $800,000 $2,605,263 $473,684 $947,368 $4,026,316 $1,318,713 $659,357 $395,614 $2,373,684 $4,273,977 $1,333,041 $1,592,982 $7,200,000 PROFIT AND LOSS STATEMENTS DIRECT METHOD Aggregate Revenues Direct Costs Indirect Costs Total Costs Pre-tax profit Adult Obstetrics Pediatrics Medicines $12,000,000 $6,000,000 $2,000,000 $6,000,000 $3,600,000 $1,200,000 $4,284,559 $1,267,647 $1,647,794 $10,284,559 $4,867,647 $2,847,794 $1,715,441 $1,132,353 $847,794 $20,000,000 $10,800,000 $7,200,000 $18,000,000 $2,000,000 STEP-DOWN METHOD Revenues Direct Costs Indirect Costs Total Costs Pre-tax profit Adult Obstetrics Pediatrics Medicines $12,000,000 $6,000,000 $2,000,000 $6,000,000 $3,600,000 $1,200,000 $4,273,977 $1,333,041 $1,592,982 $10,273,977 $4,933,041 $2,792,982| $1,726,023 $1,066,959 $792,982 Aggregate $20,000,000 $10,800,000 $7,200,000 $18,000,000 $2,000,000

Add a comment
Know the answer?
Add Answer to:
Allocation Direct Method Part 1 use provided info to complete table using direct method. part 2...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 8 INPUT DATA 10 Revenues 11 12 13 Adult Medicine 14 Obstetrics 15 Pediatrics Total revenues...

    8 INPUT DATA 10 Revenues 11 12 13 Adult Medicine 14 Obstetrics 15 Pediatrics Total revenues $ 12.000.000 6,000,000 2.000 ODO $ 20,000,000 18 Direct Costs 20 Patient Series Departments 21 Adult Medicine 22 Obstetrics 3.600.000 23 Pediatrics 1.200.000 24 Subtotal $ 10.800.000 25 Support Departe 26 Administration 1 000 000 27 Facilities 4.400000 28 Finance 180dddd 29 Subtotal MS71200.000 30 Total costs $ 18.000.000 Ready Allocation Matrix Services 5 Provided to Percentage of Services Provided by Administration Facilities Finance...

  • I need assistance answering these questions. PART 3 (INSERT INFORMATON FROM INPUT DATA AND PARTS 1...

    I need assistance answering these questions. PART 3 (INSERT INFORMATON FROM INPUT DATA AND PARTS 1 AND 2) 1.200.000 Direct costs Indirect costs Direct Costs Pro-tax prate 200 Step Down Method Patient Services Departments A Medicine Ostetrics Pediatrics Su Indirect costs olol H oH Faces REVIEW PURPOSES ONLY Pediatrical Indirect costs 236.593.567 1.340 338.257 1823.07.17 Pre-tax pro REVIEW PURPOSES ONLY Ostetrics Indirect costs 15940205 63289785918 Pre-tax pro ALLOCATION CALCULATIONS PART 1 Adult Medicine Obstetica Pediatrics Administration allocation Facilities allocation Finance...

  • Tacoma Hospital has three support departments and four patient services departments. The direct costs to each...

    Tacoma Hospital has three support departments and four patient services departments. The direct costs to each of the support departments are as follows: Tacoma Hospital has three support departments and four patient services departments. The direct costs to each of the support departments are as follows: Direct Costs Cost Driver General Administration $2,000,000 Salary Dollars Facilities $5,000,000 Housekeeping Labor Hours Financial Services $3,000,000 Patient Services Revenue Total $10,000,000 The patient services revenue, salary dollars, and housekeeping labor hours for each...

  • Il Musli duon.) is the better cost driver for the costs of a hospital's financial department:...

    Il Musli duon.) is the better cost driver for the costs of a hospital's financial department: patient services department revenues or number 6.8 Which is the bette services department: patient servi of bills generated? Explain your rationale. atient services re as follows The following data pertain to problemus 6.3 through 6.6: St. Benedict's Hospital has three support departments and four patien departments. The direct costs to each of the support departments are as General Administration $2,000,000 Facilities 5,000,000 Financial Services...

  • Tacoma Hospital has three support departments and four patient services departments. The direct costs to each...

    Tacoma Hospital has three support departments and four patient services departments. The direct costs to each of the support departments are as follows: Direct Costs Cost Driver General Administration $2,000,000 Patient Services Revenue Facilities $5,000,000 Space (square feet) Financial Services $3,000,000 Patient Services Revenue Total $10,000,000 The patient services revenue and space utilization (square feet) for each department are as follows: Patient Services Revenue Space (square feet) Routine Care $30,000,000 400,000 Intensive Care $4,000,000 40,000 Diagnostic Services $6,000,000 60,000 Other...

  • 6.3 its and four patient services partments are as follows: The following data pertain to problems 6.3 trong 6....

    6.3 its and four patient services partments are as follows: The following data pertain to problems 6.3 trong 6.6: St. Benedict's Hospital has three support departments and four departments. The direct costs to cach of the support departmen General Administration Facilities Financial Services 3,000,000 Selected data for the three support and four patient services departm shown below: $2,000,000 5,000,000 departments are Housekeeping Labor Hours Salary Dollars 2,000 $1,500,000 Patient Space Services (square Department Revenue feet) Support: a General 10,000 Administration...

  • 6.7 a & b only please write out so I can follow. No pictures. New problem....

    6.7 a & b only please write out so I can follow. No pictures. New problem. The following data pertain to problems 6.7 and 6.8: St. Luke's Hospital has three support departments and four patient services Selected data for the three support and four patient services departments a Healthcare $4,000,000 5,000,000 4,000,000 follows: departments. The direct costs to each of the support departments are as General Administration Maintenance Employee Benefits are shown below: Patient Services Revenue Space (square feet) Number...

  • E F G H Use the following information to allocate costs using the direct, step, and...

    E F G H Use the following information to allocate costs using the direct, step, and reciprocal methods: Not-A-Mega Bank has three service departments (Administration, Communications, and Facilities) and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows: Direct costs..... Employee hours Number of employees Square footage occupied... Administration Communications Facilities Deposits Loans $160,000 $240,000 $203,200 $6,730,000 $4,850,000 15,500...

  • 11. Using the Step-Down Method for this problem. Accounting - Billing has a total cost pool...

    11. Using the Step-Down Method for this problem. Accounting - Billing has a total cost pool of $2,112,600. The cost driver has been determined to number of procedures. What would the allocation rate be for Accounting/Billings? (Hint: round to the third decimal place) Choice A: $11.31 per procedure Choice B: $1.565 per procedure Choice C: $3.32 per procedure Choice D: $8.00 per procedure #12. Using the Step-Down Method for this problem. Now that you have calculated the new allocation rate...

  • Use the following information to answer questions 1-3. The housekeeping services department of Ruger Clinic, a...

    Use the following information to answer questions 1-3. The housekeeping services department of Ruger Clinic, a multispecialty practice in Toledo, Ohio, had $100,000 in direct costs during 2015. These costs must be allocated to Ruger’s three revenue-producing patient services departments using the direct method. Two cost drivers are under consideration: patient services revenue and hours of housekeeping services used. The patient services departments generated $5 million in total revenues during 2015, and to support these clinical activities, they used 5,000...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT