Skip to main content
DD-HLT-004 Hospital Network Performance and Capacity Planning Get the data →
DD-HLT-004-Q058 Very Hard

Contribution gap and cost-reduction target

Management wants actual contribution to match budget contribution using direct-cost savings alone, holding billed charges fixed. Reconcile the contribution gap and calculate the required uniform cost-reduction percentage. Assess whether the target is feasible when reductions are capped at 10%.
Expected
Actual/budget contribution, gap, required percentage, capped-savings feasibility · Scenario waterfall
Tables
FactHospitalEncounters, FactBilling, FactBudgetMonthly · columns
  • FactHospitalEncounters
  • FactBilling
  • FactBudgetMonthly
  • EncounterID
  • BilledSAR
  • DirectCostSAR
  • BudgetBilledSAR
  • BudgetDirectCostSAR
  • BudgetDateKey

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.