finance management

profileshaaeh
su_mhc6305_w5_a4.xls
Home>Business & Finance homework help>finance management

Variance Analysis

Variance Analysis Case Study © 2007 South University
Venture Mental Health
Enter appropriate input values in cells colored red.
INPUT DATA:
Static Assumptions:
Expected Enrollment (Member-Months)
PC Commercial 0
PC Medicare 0
SH Commercial 0
SH Medicare 0
Total 0
Expected Premium Data (Per Member Per Month)
PC Commercial $0.00
PC Medicare 0.00
SH Commercial 0.00
SH Medicare 0.00
Expected Labor Data per Admission or Session
Inpatient Outpatient
# of Hours Hourly Rate # of Hours Hourly Rate
PC Comm 0 $0.00 0.00 $0.00
PC Medicare 0 0.00 0.00 0.00
SH Comm 0 0.00 0.00 0.00
SH Medicare 0 0.00 0.00 0.00
Expected Utilization and Total Labor Cost Data:
Inpatient Outpatient
Avg # Members Admission Cost per Total Referral Cost per Total Grand
Plan Type (in 000s) Rate Admission Costs Rate Session Costs Total
PC Comm 0.000 0.00 $0 $0 0.00 $0 $0 $0
PC Medicare 0.000 0.00 0 0 0.00 0 0 0
Total 0.000 $0 $0 $0
SH Comm 0.000 0.00 $0 $0 0.00 $0 $0 $0
SH Medicare 0.000 0.00 0 0 0.00 0 0 0
Total 0.000 0 0 0
Grand total 0.000 $0 $0 $0
Actual Results:
Actual Enrollment (Member-Months)
PC Commercial 0
PC Medicare 0
SH Commercial 0
SH Medicare 0
Total 0
Actual Premium Data (Per Member Per Month)
PC Commercial $0.00
PC Medicare 0.00
SH Commercial 0.00
SH Medicare 0.00
Actual Labor Data per Admission or Session
Inpatient Outpatient
# of Hours Hourly Rate # of Hours Hourly Rate
PC Comm 0 $0.00 0.00 $0.00
PC Medicare 0 0.00 0.00 0.00
SH Comm 0 0.00 0.00 0.00
SH Medicare 0 0.00 0.00 0.00
Actual Utilization and Total Labor Cost Data:
Inpatient Outpatient
Avg # Members Admission Cost per Total Referral Cost per Total Grand
Plan Type (in 000s) Rate Admission Costs Rate Session Costs Total
PC Comm 0.000 0.00 $0 $0 0.00 $0 $0 $0
PC Medicare 0.000 0.00 0 0 0.00 0 0 0
Total 0.000 $0 $0 $0
SH Comm 0.000 0.00 $0 $0 0.00 $0 $0 $0
SH Medicare 0.000 0.00 0 0 0.00 0 0 0
Total 0.000 $0 $0 $0
Grand total 0.000 $0 $0 $0
MODEL-GENERATED (OUTPUT) DATA:
BUDGET INPUTS:
Enrollment
Static Enrollment / Premium Actual
Member-Months:
PC Comm - - - -
PC Medicare - - - -
SH Comm - - - -
SH Medicare - - - -
Premiums:
PC Comm $0.00 $0.00 $0.00 $0.00
PC Medicare 0.00 0.00 0.00 0.00
SH Comm 0.00 0.00 0.00 0.00
SH Medicare 0.00 0.00 0.00 0.00
Revenues:
PC Comm $0 $0 $0 $0
PC Medicare 0 0 0 0
SH Comm 0 0 0 0
SH Medicare 0 0 0 0
Admit Rates:
PC Comm - 0 - 0 - 0 - 0
PC Medicare - 0 - 0 - 0 - 0
SH Comm - 0 - 0 - 0 - 0
SH Medicare - 0 - 0 - 0 - 0
Cost per Admission:
PC Comm $0 $0 $0 $0
PC Medicare 0 0 0 0
SH Comm 0 0 0 0
SH Medicare 0 0 0 0
Referral Rates:
PC Comm - 0 - 0 - 0 - 0
PC Medicare - 0 - 0 - 0 - 0
SH Comm - 0 - 0 - 0 - 0
SH Medicare - 0 - 0 - 0 - 0
Cost per Session:
PC Comm $0 $0 $0 $0
PC Medicare 0 0 0 0
SH Comm 0 0 0 0
SH Medicare 0 0 0 0
BUDGETS:
Enrollment
Static Enrollment / Utilization Actual
Total Revenues:
PC Commercial $ - $ - $ - $ -
PC Medicare - - - -
SH Commercial - - - -
SH Medicare - - - -
Aggregate $ - $ - $ - $ -
Total Costs (Staffing Costs):
PC Commercial Inpatient $ - $ - $ - $ -
PC Commercial Outpatient - - - -
Total $ - $ - $ - $ -
PC Medicare Inpatient $ - $ - $ - $ -
PC Medicare Outpatient - - - -
Total $ - $ - $ - $ -
SH Commercial Inpatient $ - $ - $ - $ -
SH Commercial Outpatient - - - -
Total $ - $ - $ - $ -
SH Medicare Inpatient $ - $ - $ - $ -
SH Medicare Outpatient - - - -
Total $ - $ - $ - $ -
Aggregate $ - $ - $ - $ -
Total Profits:
PC Commercial $ - $ - $ - $ -
PC Medicare - - - -
SH Commercial - - - -
SH Medicare - - - -
Aggregate $ - $ - $ - $ -
Margin 0.0% 0.0%
VARIANCE ANALYSIS:
Profit (Total) Variance: Check Figures = Revenue Variance + Cost Variance:
PC Commercial $ - 0% $ -
PC Medicare - 0% -
SH Commercial - 0% -
SH Medicare - 0% -
Aggregate $ - 0% $ -
Revenue Variance: Check Figures = Enrollment variance + Rate (PMPM) Variance:
PC Commercial $ - 0% $ -
PC Medicare - 0% -
SH Commercial - 0% -
SH Medicare - 0% -
Aggregate $ - 0% $ -
Enrollment Variance:
PC Commercial $ - 0%
PC Medicare - 0%
SH Commercial - 0%
SH Medicare - 0%
Aggregate $ - 0%
Rate (PMPM) Variance:
PC Commercial $ - 0%
PC Medicare - 0%
SH Commercial - 0%
SH Medicare - 0%
Aggregate $ - 0%
Cost Variance: Check Figures = Volume Variance + Management Variance:
PC Commercial $ - 0% $ -
PC Medicare - 0% $ -
SH Commercial - 0% $ -
SH Medicare - 0% $ -
Aggregate $ - 0% $ -
Volume Variance: Check Figures = Enrollment Variance + Utilization Variance:
PC Commercial $ - 0% $ -
PC Medicare - 0% -
SH Commercial - 0% -
SH Medicare - 0% -
Aggregate $ - 0% $ -
Enrollment Variance:
PC Commercial $ - 0%
PC Medicare - 0%
SH Commercial - 0%
SH Medicare - 0%
Aggregate $ - 0%
Utilization Variance:
PC Commercial $ - 0%
PC Medicare - 0%
SH Commercial - 0%
SH Medicare - 0%
Aggregate $ - 0%
Management Variance:
PC Commercial $ - 0%
PC Medicare - 0%
SH Commercial - 0%
SH Medicare - 0%
Aggregate $ - 0%
Staffing Variance: Check Figures:
PC Commercial Inpatient $ - 0% $ -
PC Commercial Outpatient - 0% -
Total $ - 0% $ -
PC Medicare Inpatient $ - 0% $ -
PC Medicare Outpatient - 0% -
Total $ - 0% $ -
SH Commercial Inpatient $ - 0% $ -
SH Commercial Outpatient - 0% -
Total $ - 0% $ -
SH Medicare Inpatient $ - 0% $ -
SH Medicare Outpatient - 0% -
Total $ - 0% $ -
Aggregate $ - 0% $ -
Rate Variance:
PC Commercial Inpatient $ -
PC Commercial Outpatient -
Total $ -
PC Medicare Inpatient $ -
PC Medicare Outpatient -
Total $ -
SH Commercial Inpatient $ -
SH Commercial Outpatient -
Total $ -
SH Medicare Inpatient $ -
SH Medicare Outpatient -
Total $ -
Aggregate $ -
Efficiency Variance:
PC Commercial Inpatient $ -
PC Commercial Outpatient -
Total $ -
PC Medicare Inpatient $ -
PC Medicare Outpatient -
Total $ -
SH Commercial Inpatient $ -
SH Commercial Outpatient -
Total $ -
SH Medicare Inpatient $ -
SH Medicare Outpatient -
Total $ -
Aggregate $ -