Please use this link (http lmscontent embanet com OU MHA HLTH6210 Documents Week3 A3 3 WestsideData xls) to access the spreadsheet The question is asking to fill in the blanks for Part 1, 2, and 3 The answers for Part 1 and 2 will be used to complete Part 3 Parts 1 3 Parts 1 3 of this assignment will be completed within the Westside Group Practice Cost Allocation Methods spreadsheet Click the link below to download the spreadsheet Westside Group Spreadsheet ( http lmscontent embanet com OU MHA HLTH6210 Documents Week3 A3 3 WestsideData xls ) This spreadsheet includes 3 sections Input Data, Allocations, and Final Output Data Portions of the Allocation Section (Part I and Part 2 on the spreadsheet) and the Final Output Section (Part 3 on the spreadsheet) must be completed Some of these have already been completed for you as a guide Complete all open cells in the Allocations (Parts 1 and 2) and Final Output Data (Part 3) These parts are shaded on the spreadsheet for easier identification Note that you do not need to complete any portion of the Double Apportionment or Reciprocal Schedules, these results are presented for your review 50 PART 1 51 DIRECT METHOD 52 53 Administration allocation$ 437,500 54 Facilities allocation 55 Finance allocation 56 Total 57 58 PART2 59 STEP DOWN METHODFor x, no amount should be entered Patient Service PediatricsTotal $ 1,000,000 4,400,000 300 0001800 000 Adult Medicine Obstetrics 517,647 Patient Service Administration FacilitiesFinance Adult Medicine ObstetricsPediatrics x $ 100,000 $100,000 350,000 61 Administration allocation 62 Facilities allocation 63 Finance allocation 64 Total $800,000 4,026,316 395 614 2,373684 473,684 473,684 $ 7200,000 50 PART 1 51 DIRECT METHOD 52 53 Administration allocation$ 437,500 54 Facilities allocation 55 Finance allocation 56 Total 57 58 PART2 59 STEP DOWN METHODFor x, no amount should be entered Patient Service PediatricsTotal $ 1,000,000 4,400,000 300 0001800 000 Adult Medicine Obstetrics 517,647 Patient Service Administration FacilitiesFinance Adult Medicine ObstetricsPediatrics x $ 100,000 $100,000 350,000 61 Administration allocation 62 Facilities allocation 63 Finance allocation 64 Total $800,000 4,026,316 395 614 2,373684 473,684 473,684 $ 7200,000

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 06, 2024

Please use this link (http://lmscontent.embanet.com/OU/MHA/HLTH6210/Documents/Week3/A3.3_WestsideData.xls) to access the spreadsheet. The question is asking to fill in the blanks for Part 1, 2, and 3. The

Please use this link (http://lmscontent.embanet.com/OU/MHA/HLTH6210/Documents/Week3/A3.3_WestsideData.xls) to access the spreadsheet. The question is asking to fill in the blanks for Part 1, 2, and 3. The answers for Part 1 and 2 will be used to complete Part 3.

Parts 1 - 3

Parts 1 3 of this assignment will be completed within the Westside Group Practice Cost Allocation Methods spreadsheet.

Click the link below to download the spreadsheet:

Westside Group Spreadsheet ( http://lmscontent.embanet.com/OU/MHA/HLTH6210/Documents/Week3/A3.3_WestsideData.xls )

This spreadsheet includes 3 sections: Input Data, Allocations, and Final Output Data. Portions of the Allocation Section (Part I and Part 2 on the spreadsheet) and the Final Output Section (Part 3 on the spreadsheet) must be completed. Some of these have already been completed for you as a guide. Complete all open cells in the Allocations (Parts 1 and 2) and Final Output Data (Part 3). These parts are shaded on the spreadsheet for easier identification. Note that you do not need to complete any portion of the Double Apportionment or Reciprocal Schedules, these results are presented for your review.

image text in transcribed

50 PART 1 51 DIRECT METHOD: 52 53 Administration allocation$ 437,500 54 Facilities allocation 55 Finance allocation 56 Total 57 58 PART2 59 STEP-DOWN METHODFor x, no amount should be entered Patient Service PediatricsTotal $ 1,000,000 4,400,000 300 0001800 000 Adult Medicine Obstetrics 517,647 Patient Service Administration FacilitiesFinance Adult Medicine ObstetricsPediatrics x $ 100,000 $100,000 350,000 61 Administration allocation 62 Facilities allocation 63 Finance allocation 64 Total $800,000 4,026,316 395.614 2,373684 473,684 473,684 $ 7200,000 50 PART 1 51 DIRECT METHOD: 52 53 Administration allocation$ 437,500 54 Facilities allocation 55 Finance allocation 56 Total 57 58 PART2 59 STEP-DOWN METHODFor x, no amount should be entered Patient Service PediatricsTotal $ 1,000,000 4,400,000 300 0001800 000 Adult Medicine Obstetrics 517,647 Patient Service Administration FacilitiesFinance Adult Medicine ObstetricsPediatrics x $ 100,000 $100,000 350,000 61 Administration allocation 62 Facilities allocation 63 Finance allocation 64 Total $800,000 4,026,316 395.614 2,373684 473,684 473,684 $ 7200,000