Skip to main content
DD-HLT-004 Hospital Network Performance and Capacity Planning Get the data →
DD-HLT-004-Q039 Hard Time series

Billed charges against budget

Reconcile billed charges against the monthly hospital-department budget. Report total actual, budget and variance, and build a variance bridge by hospital. Do not multiply monthly budget values by encounter counts.
Expected
Hospital totals: actual, budget, variance; overall reconciliation · Variance matrix
Tables
FactHospitalEncounters, FactBilling, FactBudgetMonthly, DimHospital +1 · columns
  • FactHospitalEncounters
  • FactBilling
  • FactBudgetMonthly
  • DimHospital
  • DimDate
  • EncounterID
  • BilledSAR
  • BudgetBilledSAR
  • BudgetDateKey
  • HospitalID
  • DepartmentID
  • AdmissionDateKey
  • YearMonth

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.

Create a free account Sign in