Finance Group Project (Word)

docx

School

Humber College *

*We aren’t endorsed by this school

Course

4501

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

5

Uploaded by MajorCrownMongoose16

Report
EAGAN FAMILY PRACTICE is a medical practice with four locations in the Minneapolis/St. Paul area. The clinical staff consists of 20 physicians—all of whom practice in one or more areas of family medicine—and 46 advanced practice providers and nurses. Eagan is organized into three patient services departments: Adult Medicine, Obstetrics, and Pediatrics. Supporting these patient service departments are three support departments: Administration, Facilities, and Finance. Exhibit 7.1 shows Eagan's summary revenue and cost projections by the department for the coming year. As part of a much-needed overhaul of the cost allocation process, Eagan contracted with a major accounting firm to estimate the amount of services provided by the support departments to each other and to each patient service department. The intent of the study was to provide data that would help Eagan develop a better cost allocation system to replace the outdated, arbitrary system currently in use. The results of this study are shown in exhibit 7.2. Although expressed as percentages of the total dollar amount of support provided to other departments (instead of the more typical cost allocation rates), the data in exhibit 7.2 are based on an extensive study using sound managerial accounting techniques. Thus, both senior management and department heads at Eagan are comfortable with the resulting allocation
percentages. (Hint: To ensure that you apply the percentages properly in your analysis, pay attention to Note 2 at the bottom of exhibit 7.2.) The second step in the cost allocation process improvement initiative is to choose the allocation method. Four allocation methods are under consideration: direct, step-down, double apportionment, and reciprocal. Jerry Silverman, Eagan's chief financial officer, has asked Ashley Matson, the administrative resident at Eagan, to conduct a study and make a recommendation on the best allocation method. This task can be approached in several ways, but Ashley has decided to examine by doing. She plans to use the data in exhibits 7.1 and 7.2 to determine the overhead cost allocations under each allocation method. Afterward, she can compare and contrast the results.
Of course, the final decision cannot be made without considering the costs involved in implementing each allocation method. When Ashley asked Jerry about the costs inherent in each allocation method, Jerry said, “I don't know! Assume that the direct method is the least costly, the reciprocal method is the most costly, and the other two fall somewhere in between.” He also expects Ashley to make some judgments on the relative profitability of the patient services departments under the recommended allocation system. Ashley began her analysis by reviewing the allocation methods presented in her old healthcare finance textbook. She had no problem remembering basic cost allocation concepts, but she did hit two snags. The first problem was that the textbook did not describe the double apportionment method. However, after a little research, Ashley discovered that the double apportionment method is a slightly more complicated version of the step-down method. In the first apportionment, support provided by each service department to the other service departments as well as to the patient services departments is recognized. Because some costs remain in the support departments after the first apportionment, a second apportionment, which applies the step-down method, moves all remaining support department costs to the patient services departments. Thus, in the double apportionment method, service department support to all other service departments is recognized, whereas, in the pure step-down method, service department support is recognized only to “downstream” service departments. Here's how Ashley assumed that the double apportionment method would be applied to Eagan. (There are alternative ways in which this allocation method can be applied.) First, direct Administration costs would be allocated to the other five departments (two support and three patient services). Second, direct Facilities costs would be allocated to all other departments (including Administration and Finance). Third, direct Finance costs would be allocated to all other departments (including Administration and Facilities). After these three allocations are completed, the first apportionment is finished. Some costs remain in the support departments—the intra-support department allocations from the first apportionment—so a second apportionment is necessary. The second apportionment is conducted using the step-down method as it is normally applied, except that the application of the first apportionment means that the starting cost pool values are much lower. The second problem Ashley faced was that she did not know how to perform the reciprocal allocation. One method is to use simultaneous equations—but higher mathematics has never been Ashley's strong suit—and another method uses an iterative approach. Fortunately, Ashley had recently read an article in Accounting Monthly discussing an Excel model that uses the iterative approach to perform the reciprocal allocation. To help with the analysis, Ashley modified the magazine's model by using Eagan's numbers to calculate the allocation not only for the reciprocal method but also for the other three methods.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Put yourself in Ashley's shoes. Complete her assigned task and prepare a report to present to Eagan's executive committee. In addition, assess the sensitivity of the results to (1) the relative sizes of the direct costs at each support department and (2) the amount of support provided by the support departments to each other. Exhibit 7.3 contains the values that you may use in your sensitivity analysis.
Case Questions: 1. Briefly describe the differences in the four allocation methods discussed in the case. (Hint: Don’t discuss the mathematics of the schemes but rather how they differ conceptually.) Which of the four methods is conceptually best? 2. What are the allocations to each patient services department, and resulting profitability, under the four allocation methods using the base case cost amounts (exhibit 7.1) and allocation rates (Exhibit 7.2). 3. Consider the sensitivity of the results to changes in the values of the overhead cost pools. Repeat Question 2, but now use the overhead cost pool amounts from the first section of exhibit 7.3 along with the base case allocation percentages contained in exhibit 7.2. (Note that there are two different overhead cost pool amounts—Calculation 1 and Calculation 2.) 4. Consider the sensitivity of the results to changes in the allocation percentages. Repeat Question 2, but now use the percentages from exhibit 7.3 along with the base case overhead cost pool amounts given in exhibit 7.1. 5. What is your recommendation regarding the appropriate cost allocation method for the practice?