Maven Hospital Challenge

Hospital Overview and KPIs

• Total Cost Not Covered: $70.42M
• Average Cost per Visit: $3.64K
• Total Number of Patients: 974
• Patient Count by Month:
  • Peaks in February (3019 patients) and a general decline towards the end of the year
• Encounter Class Breakdown:
  • Ambulatory: 12.5K
  • Outpatient: 6.3K
  • Urgent Care: 3.7K
  • Emergency: 2.3K
  • Wellness: 1.9K
  • Inpatient: 1.1K
• Admissions and Claim Costs by Month and Year:
  • Highest claims in March 2012 ($774,524.96)
  • Total admissions: 27,891
  • Total claim cost: $101,514,375.52

Patient and Procedure Analysis

• Gender Distribution:
  • Male: 480 (49.2%)
  • Female: 494 (50.7%)
• Average Length of Stay: 0.30 days
• Count of City: 974
• Top Reasons for Encounters:
  • Acute bronchitis: 1732 encounters
  • Acute respiratory infections: 1240 encounters
  • Acute viral infections: 1167 encounters
  • Appendicitis: 552 encounters
• City Count by Gender and County:
  • Suffolk County: 331 (M), 313 (F)
  • Plymouth County: 27 (M), 22 (F)
  • Norfolk County: 65 (M), 90 (F)
  • Middlesex County: 71 (M), 54 (F)
  • Essex County: 1 (F)
• Monthly Average Length of Stay:
  • Peaks in March (0.73 days) and December (0.92 days)

Financial Analysis and Insights

• Total Claim Costs:
  • Total: $101.51M
  • Max Claim Costs per Year: $12.0M (2014)
  • Not Covered: $70.42M
• Encounter Class Breakdown (Pie Chart):
  • Ambulatory: 44.95%
  • Outpatient: 22.59%
  • Urgent Care: 8.33%
  • Emergency: 4.07%
  • Wellness: 3.67%
  • Inpatient: 1.91%
• Annual Claim Costs:
  • Highest in 2014 ($12.0M)
  • Steady decline after 2014
• Admissions and Claim Costs by Month and Year:
  • Total claims: $101,514,375.52
  • Total payer coverage: $31,097,506.99