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

Cost-support pool allocation

A temporary cost-support pool equals 50% of total positive hospital direct-cost overruns against budget. Allocate the pool proportionally to positive overruns only; hospitals at or below budget receive zero. Reconcile allocations to the pool and calculate each hospital remaining unfunded overrun.
Expected
Hospital actual, budget, positive overrun, allocation, unfunded overrun, reconciled total · Allocation waterfall
Tables
FactHospitalEncounters, FactBudgetMonthly, DimHospital · columns
  • FactHospitalEncounters
  • FactBudgetMonthly
  • DimHospital
  • HospitalID
  • DirectCostSAR
  • 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.