revenue variance

AutoSave Off 2 Week 4 SQT 3 (1) - Saved - O Search RENEE' RATLIFF RR File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 11 A A = General CIT ST TI TA 47 O W a Wrap Text - 3 Merge & Center 3 Paste BIU A y Insert Delete Format $ %, 820 y Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Data Analysis Analysis Clipboard Font Alignment Number Cells Editing 01 X fi D E F H 1 J K L M N 0 P Q R S T B 1 Week 4 - SQT 3 2 3 Static Budget Flexible Budget Actual Results 4 5 6 7 Assumptions: FFS visits Capitated visits Total 46,000 85,000 131,000 47,619 80,000 50,000 80,000 8 9 127,619 130,000 10 11 FFS rate 40 40 42 3 12 Capitated PMPM 3 3 13 14 Variable costs per visit Fixed costs 13.00 550,000 12.00 550,000 12.50 530,000 15 16 Variances Amount Percent 17 18 INCOME STATEMENT: 19 Revenues: 20 FFS 21 Capitated 22 Total Revenue Sheet1 2,050,000 1,840,000 255,000 2,095,000 # W + 100% Type here to search o j e B ? 12:01 AM 2/21/2021 AutoSave Off 2 Week 4 SQT 3 (1) - Saved - O Search RENEE' RATLIFF RR File Home Insert Page Layout Formulas Data Review View Help Share Comments X Calibri 11 A A = General CIT ST TI TA 47 O W a Wrap Text - 3 Merge & Center 3 Paste BIU A y Insert Delete Format $ %, 820 y Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Data Analysis Analysis Clipboard Font Alignment Number Cells Editing 01 X fi D E F H 1 J K L M N 0 P Q R S T B 1 Week 4 - SQT 3 2 3 Static Budget Flexible Budget Actual Results 4 5 6 7 Assumptions: FFS visits Capitated visits Total 46,000 85,000 131,000 47,619 80,000 50,000 80,000 8 9 127,619 130,000 10 11 FFS rate 40 40 42 3 12 Capitated PMPM 3 3 13 14 Variable costs per visit Fixed costs 13.00 550,000 12.00 550,000 12.50 530,000 15 16 Variances Amount Percent 17 18 INCOME STATEMENT: 19 Revenues: 20 FFS 21 Capitated 22 Total Revenue Sheet1 2,050,000 1,840,000 255,000 2,095,000 # W + 100% Type here to search o j e B ? 12:01 AM 2/21/2021 7:30 1