Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXHIBIT 7.1 Revenues Eagan Family Practice: Adult Medicine $12,000,000 Departmental Revenue Obstetrics 6,000,000 and Cost Projections Pediatrics 2,000,000 Total revenues $20,000,000 Direct Costs Patient Services

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
EXHIBIT 7.1 Revenues Eagan Family Practice: Adult Medicine $12,000,000 Departmental Revenue Obstetrics 6,000,000 and Cost Projections Pediatrics 2,000,000 Total revenues $20,000,000 Direct Costs Patient Services Adult Medicine $ 6,000,000 Obstetrics 3,600,000 Pediatrics 1,200,000 Subtotal $ 10,800,000 Support Administration $ 1,000,000 Facilities 4,400,000 Finance 1,800,000 Subtotal $ 7,200,000 Total expenses $18,000,000 Pretax profit $ 2,000,000EXHIBIT 7.2 Percentage of Services Provided by Eagan Family Practice: Services Provided to Administration Facilities Finance Allocation Percentages Administration 59% 5% Facilities 10% 5 Finance 10 10 Adult Medicine 35 55 50 Obstetrics 20 10 25 Pediatrics 25 20 15 Total 100% 100% 100% Percentage to support departments 20% 15% 10% Percentage to patient service departments 80% 85% 90% Notes: 1. The allocation percentages are based on a two-year analysis of the actual services provided by the support departments to other departments. 2. To use the percentages to perform an allocation, they may have to be adjusted to ensure that the entire amount of the cost pool is allocated. To illustrate, in the direct method, all of Administration's costs ($500,000) have to be allocated directly in a single allocation to the three patient service departments. If the raw percentages were used, only 35% + 20% + 25% = 80% of the cost pool would be allocated, so the allocation percentages have to be adjusted so that 80 percent represents the entire allocation (100 percent). Thus, instead of a 35 percent allocation to Adult Medicine, its adjusted allocation is 35%/80% = 43.75%. In a similar manner, the adjusted allocation to Obstetrics is 20%/80% = 25%, while the adjusted allocation to Pediatrics is 25%/80% = 31.25%. When done correctly, the adjusted percentages must sum to 100%: 43.75% + 25% + 31.25% = 100%.EXHIBIT 7.3 Sensitivity to Changes in Relative Overhead Costs: Eagan Family Practice: Sensitivity Analysis New Direct Expenses for Calculation 1 Values Administration $4,400,000 Facilities 1,000,000 Finance 1,800,000 Total overhead expenses $7,200,000 New Direct Expenses for Calculation 2 Administration $1,000,000 Facilities 1,800,000 Finance 4,400,000 Total overhead expenses $7,200,000 Sensitivity to Allocation Percentages: Percentage of Services Provided by Services Provided to Administration Facilities Finance Administration 25% 20% Facilities 30% 20 Finance 30 25 Adult Medicine 18 32 33 Obstetrics 10 6 17 Pediatrics 12 12 10 Total 100% 100% 100% Percentage to support departments 60% 50% 40% Percentage to patient service departments 40% 50% 609%Assume that Ashley plans to allocate support department costs to the patient services departments using the direct method. What is the total indirect cost allocation (from all three support departments combined) to the Adult Medicine department under this method

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting Volume 2

Authors: Thomas Beechy, Joan Conrod, Elizabeth Farrell, Ingrid McLeod-Dick

6th Edition

1259105482, 9780071338820

More Books

Students also viewed these Accounting questions

Question

What is the relevant price range for a product or service?

Answered: 1 week ago

Question

2. In what way can we say that method affects the result we get?

Answered: 1 week ago