a)

b) c)

d)

EXHIBIT 7.1 Eagan Family Practice: Departmental Revenue and Cost Projections Revenues Adult Medicine Obstetrics Pediatrics Total revenues $12,000,000 6,000,000 2,000,000 $20,000,000 $ 6,000,000 3,600,000 1,200,000 $ 10,800,000 Direct Costs Patient Services Adult Medicine Obstetrics Pediatrics Subtotal Support Administration Facilities Finance Subtotal Total expenses $ 1,000,000 4,400,000 1,800,000 $ 7,200,000 $18,000,000 Pretax profit $ 2,000,000 Case 7: Eagan Family Practice 51 Percentage of Services Provided by Administration Facilities Finance EXHIBIT 7.2 Eagan Family Practice: Allocation Percentages Services Provided to 5% 5% Administration Facilities Finance 10% 5 10 10 Adult Medicine Obstetrics Pediatrics 35 20 55 10 50 25 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%. Assume that Ashley plans to allocate support department costs to the patient services departments using the direct method. Using the information provided in Exhibit 7.2, what percentage of the costs of the Finance department would be allocated to the Adult Medicine department using the direct method? Assume that Ashley plans to allocate support department costs to the patient services departments using the direct method. Using the information provided in Exhibits 7.1 and 7.2, what is the dollar amount of Finance cost that would be allocated to the Adult Medicine department using the direct method? Assume that Ashley plans to allocate support department costs to the patient services departments using the direct method. Using the information provided in Exhibits 7.1 and 7.2, what is the dollar amount of Finance cost that would be allocated to the Facilities department using the direct method? 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? EXHIBIT 7.1 Eagan Family Practice: Departmental Revenue and Cost Projections Revenues Adult Medicine Obstetrics Pediatrics Total revenues $12,000,000 6,000,000 2,000,000 $20,000,000 $ 6,000,000 3,600,000 1,200,000 $ 10,800,000 Direct Costs Patient Services Adult Medicine Obstetrics Pediatrics Subtotal Support Administration Facilities Finance Subtotal Total expenses $ 1,000,000 4,400,000 1,800,000 $ 7,200,000 $18,000,000 Pretax profit $ 2,000,000 Case 7: Eagan Family Practice 51 Percentage of Services Provided by Administration Facilities Finance EXHIBIT 7.2 Eagan Family Practice: Allocation Percentages Services Provided to 5% 5% Administration Facilities Finance 10% 5 10 10 Adult Medicine Obstetrics Pediatrics 35 20 55 10 50 25 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%. Assume that Ashley plans to allocate support department costs to the patient services departments using the direct method. Using the information provided in Exhibit 7.2, what percentage of the costs of the Finance department would be allocated to the Adult Medicine department using the direct method? Assume that Ashley plans to allocate support department costs to the patient services departments using the direct method. Using the information provided in Exhibits 7.1 and 7.2, what is the dollar amount of Finance cost that would be allocated to the Adult Medicine department using the direct method? Assume that Ashley plans to allocate support department costs to the patient services departments using the direct method. Using the information provided in Exhibits 7.1 and 7.2, what is the dollar amount of Finance cost that would be allocated to the Facilities department using the direct method? 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