You have been asked by management to explain the variances in costs under your inpatient capitated contract. The following data
is provided. Use the following data to calculate the variances.
Budget Actual
Inpatient Costs $12,568,500 $16,618,350
Members 42,000 42,000
Admission Rate 0.070 0.095
Case Mix Index 0.90 0.85
Cost per Case (CMI = 1.0) $4,750 $4,900
Problem 1: What dollar amount of the total variance is attributed to Enrollment Variance?
Problem 2: What dollar effect did the increased admission rate have on cost?
Problem 3: The intensity of care delivered dropped from a budgeted case mix of 0.90 to an actual case mix of 0.85. What dollar effect did this have on actual costs?
Problem 4: Costs per case increased to $4,900 from a budgeted value of $4,750. This increased actual total costs by what amount?
a) $400,000
b) $570,000
c) $970,000
d) $600,000
e) cannot calculate with given information
Budget Actual
Inpatient Costs $12,568,500 $16,618,350
Members 42,000 42,000
Admission Rate 0.070 0.095
Case Mix Index 0.90 0.85
Cost per Case (CMI = 1.0) $4,750 $4,900
Problem 1: What dollar amount of the total variance is attributed to Enrollment Variance?
Problem 2: What dollar effect did the increased admission rate have on cost?
Problem 3: The intensity of care delivered dropped from a budgeted case mix of 0.90 to an actual case mix of 0.85. What dollar effect did this have on actual costs?
Problem 4: Costs per case increased to $4,900 from a budgeted value of $4,750. This increased actual total costs by what amount?
a) $400,000
b) $570,000
c) $970,000
d) $600,000
e) cannot calculate with given information
1 answer:
You might be interested in
Answer:
The answer is C: 14300
Note: The actual answer is 14296, <em>and </em>the closest to that was option C.
Explanation:
Formula to calculate forecast using Exponential smoothing:
Where,
= New Forecast
= Previous period's forecast.
= Smoothing Constant
= Previous period's Actual Demand.
- Calculating the forecast for period 5:
Data:
Putting <em>values in the formula:</em>