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