Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HW+3 Regan Byr n Home IA: abcWrap TextGeneral Fill Calibri (Body) Clear BIU 11 Merge O and cost data remain the same. Complete the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
HW+3 Regan Byr n Home IA: abcWrap TextGeneral Fill Calibri (Body) Clear BIU 11 Merge " O and cost data remain the same. Complete the table below and determine the PMPM rate the hespital have to charge to retain the Avg Rew per TOTAL 4e What overall net income would be produced if the admission rate of the capitated group were reduced by 10%7 Ag Rev per Admission Revenue by Payer Admssio ti Varable Contribution Costs Meen 9 Medicare TOTAL 2NET INCOME 3.1 3.23.3 Select destination and press ENTER or choose Paste Normal View 12 Excel File Edit View Insert Format Tools Data window HW+3 Regan Byrum.xlsx Tables Charts SmartArt Formulas DataReview abc - Wrap Text Currency D27 CHAPTER 7 SERVIC Monework 33, Chapter AND PRICINS MacBook Pro Help HW+ 3 Regan Byrun Excel File Edit View Insert Format Tools Data Window e 0 0 Charts SmartArt FormulasData abe Wrap Text Currency Fill Calibri (Body)1 AA Clear BIU Merge v D27 CHAPTER 7: SERVICE LINE COSTING AND PRICING 2 Homework 3.3, Chapter 7 4 Valley Forge has the following three payor groups hug Revenue per variable Cost per 5 Payer 5,000 9,000 5,000 7,000 $3,000 ,500 1,000 The hospitals fixed costs are $40,000,000 12 ,500 17.500.000 8 TOTAL 20 NET INCOME 195000004 25 26 b. Now, assume thart haif of the 100,000 covered lives in the commercial payer group wil be moved to a capitated plan All utiation and cout data remain the same. Complete the table below and determine the PMpM rate the hospital have to charge to retain the same Net Income calculated in part a 29 Aug Rev per 3.3 MacBook Pro 90% A Home Layout Tables Charts ill SmartArtFormulas Data Review ont Wrap Text Curr Clear, B. 1 | U D27 28 29 b. Now, assume that halt of the 100,000 covered lives in the commercial payer group will be moved to a capitated plan. All utization 31 same Net Income calculated In part a. and cost data remain the same. Complete the table below and determine the PMPM rate the hospltal have to charge to retain the 32 VC per Td Variable Contribution Avg Rew per Admission Revenue Margin 35 Commercial Capitated 36 PennCare 37 Medicare 38 TOTAL 39 40 PMPM rate 41 43 45 46 48 49 50 53 What overall net income would be produced if the admission rate of the capitated group were AdmissionRevenue by Faver Admssion reduced by 10%? 54 56 Comm 57 Comm Capitated 59 Medicare 60 TOTAL 61 62 NET INCOME 63 oma 13 MacBoo HW+3 Regan Byr n Home IA: abcWrap TextGeneral Fill Calibri (Body) Clear BIU 11 Merge " O and cost data remain the same. Complete the table below and determine the PMPM rate the hespital have to charge to retain the Avg Rew per TOTAL 4e What overall net income would be produced if the admission rate of the capitated group were reduced by 10%7 Ag Rev per Admission Revenue by Payer Admssio ti Varable Contribution Costs Meen 9 Medicare TOTAL 2NET INCOME 3.1 3.23.3 Select destination and press ENTER or choose Paste Normal View 12 Excel File Edit View Insert Format Tools Data window HW+3 Regan Byrum.xlsx Tables Charts SmartArt Formulas DataReview abc - Wrap Text Currency D27 CHAPTER 7 SERVIC Monework 33, Chapter AND PRICINS MacBook Pro Help HW+ 3 Regan Byrun Excel File Edit View Insert Format Tools Data Window e 0 0 Charts SmartArt FormulasData abe Wrap Text Currency Fill Calibri (Body)1 AA Clear BIU Merge v D27 CHAPTER 7: SERVICE LINE COSTING AND PRICING 2 Homework 3.3, Chapter 7 4 Valley Forge has the following three payor groups hug Revenue per variable Cost per 5 Payer 5,000 9,000 5,000 7,000 $3,000 ,500 1,000 The hospitals fixed costs are $40,000,000 12 ,500 17.500.000 8 TOTAL 20 NET INCOME 195000004 25 26 b. Now, assume thart haif of the 100,000 covered lives in the commercial payer group wil be moved to a capitated plan All utiation and cout data remain the same. Complete the table below and determine the PMpM rate the hospital have to charge to retain the same Net Income calculated in part a 29 Aug Rev per 3.3 MacBook Pro 90% A Home Layout Tables Charts ill SmartArtFormulas Data Review ont Wrap Text Curr Clear, B. 1 | U D27 28 29 b. Now, assume that halt of the 100,000 covered lives in the commercial payer group will be moved to a capitated plan. All utization 31 same Net Income calculated In part a. and cost data remain the same. Complete the table below and determine the PMPM rate the hospltal have to charge to retain the 32 VC per Td Variable Contribution Avg Rew per Admission Revenue Margin 35 Commercial Capitated 36 PennCare 37 Medicare 38 TOTAL 39 40 PMPM rate 41 43 45 46 48 49 50 53 What overall net income would be produced if the admission rate of the capitated group were AdmissionRevenue by Faver Admssion reduced by 10%? 54 56 Comm 57 Comm Capitated 59 Medicare 60 TOTAL 61 62 NET INCOME 63 oma 13 MacBoo

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

The ASQ Certified Food Safety And Quality Auditor

Authors: Steven Wilson

4th Edition

1951058186, 978-1951058180

More Books

Students also viewed these Accounting questions