CH 8 A B 4 Chelsea Clinic projected the following budget information for 2021: 5 6 Total FFS Visits Volume 80,000 visits 7 Payer Mix: 8 Blue Cross 55% 9 Highmark 45% 10 Reimbursement Rates: 11 Blue Cross $55 per visit 12 Highmark $60 per visit 13 Variable Costs 14 Resource Inputs: 15 Labor 0.8 hours per visit 16 Supplies 1.4 units per visit 17 Resource Input Prices: 18 Labor $25.00 per hour 19 Supplies $1.50 per unit 20 Fixed Costs $950,000 21 + 3 32 3.3 3.4 38 Function Library 42 X fx A B C D 9 Supplies $1.50 per unit 0 Fixed Costs $950,000 21 22 Using Exhibit 8.3 as a guide (excluding the capitated numbers since payers in this homeworle 23 problem are all FFS) construct Chelsea Clnic's operating budget for 2021, including projectic 24 volume, revenues, costs, and a P&L statement 25 26 27 1. Volume Assumptions 28 29 A. FFS 30 B. Capitated lives 31 Number of member-months 32 Expected utilization per member month 33 Number of visits 34 C. Total expected visits 85 36 Il Revenue File Home Insert Page Layout Formulas Data Review View Help fx Insert Function ? A AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference - Trig Functions Function Library Name Manage E42 fr B A 34 C. Total expected visits 35 36 II. Revenue 37 38 A. FFS 39 40 41 B. Capitated Lives 142 43 44 C. Total actual revenues 45 46 II. Cost 47 + for Insert Function ? A le AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library E42 B B + A 46 M. Cost 47 48 A. Variable Costs 49 Labor 50 Supplies 51 Total Variable Costs 52 Variable cost per visit 53 54 B. Fixed Cots: 55 Overhead, plant, equipment 56 C. Total actual costs 57 58 IV. P&L Statement Sa Revenues il ill INI 51 Normal No Spac. Heading Heading 2 Paragraph Styles FO IV. P&L Statement Revenues FFS Capitated Total Costs: Variable: FFS Capitated Total Contribution margin Fixed Costs Projected profit CH 8 A B 4 Chelsea Clinic projected the following budget information for 2021: 5 6 Total FFS Visits Volume 80,000 visits 7 Payer Mix: 8 Blue Cross 55% 9 Highmark 45% 10 Reimbursement Rates: 11 Blue Cross $55 per visit 12 Highmark $60 per visit 13 Variable Costs 14 Resource Inputs: 15 Labor 0.8 hours per visit 16 Supplies 1.4 units per visit 17 Resource Input Prices: 18 Labor $25.00 per hour 19 Supplies $1.50 per unit 20 Fixed Costs $950,000 21 + 3 32 3.3 3.4 38 Function Library 42 X fx A B C D 9 Supplies $1.50 per unit 0 Fixed Costs $950,000 21 22 Using Exhibit 8.3 as a guide (excluding the capitated numbers since payers in this homeworle 23 problem are all FFS) construct Chelsea Clnic's operating budget for 2021, including projectic 24 volume, revenues, costs, and a P&L statement 25 26 27 1. Volume Assumptions 28 29 A. FFS 30 B. Capitated lives 31 Number of member-months 32 Expected utilization per member month 33 Number of visits 34 C. Total expected visits 85 36 Il Revenue File Home Insert Page Layout Formulas Data Review View Help fx Insert Function ? A AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference - Trig Functions Function Library Name Manage E42 fr B A 34 C. Total expected visits 35 36 II. Revenue 37 38 A. FFS 39 40 41 B. Capitated Lives 142 43 44 C. Total actual revenues 45 46 II. Cost 47 + for Insert Function ? A le AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library E42 B B + A 46 M. Cost 47 48 A. Variable Costs 49 Labor 50 Supplies 51 Total Variable Costs 52 Variable cost per visit 53 54 B. Fixed Cots: 55 Overhead, plant, equipment 56 C. Total actual costs 57 58 IV. P&L Statement Sa Revenues il ill INI 51 Normal No Spac. Heading Heading 2 Paragraph Styles FO IV. P&L Statement Revenues FFS Capitated Total Costs: Variable: FFS Capitated Total Contribution margin Fixed Costs Projected profit
