MeCoMa: Smarter Healthcare Cost Management
Inspiration
Healthcare costs are rising year after year, yet patient outcomes don’t always improve. Hospitals face wasted resources, unnecessary procedures, long wait times, and frequent readmissions — all of which strain budgets and harm patients.
We were inspired to build a tool that helps leaders cut waste without cutting quality, turning scattered data into actionable insights.
What it does
MeCoMa (Medical Cost Management) is an AI-powered dashboard that unifies billing, outcomes, readmissions, provider performance, wait times, and patient satisfaction data into one centralized hub.
It allows:
- Users to identify high-cost, low-value procedures.
- Operations teams to spot inefficiencies like long patient wait times.
- Clinicians to track readmission risks and patient satisfaction.
- Executives to compare provider performance across specialties.
With AgentForce AI, leaders can also ask natural language questions — “Which procedures are the most wasteful?” — and instantly get results.
How we built it
We built MeCoMa using Salesforce and Tableau Next for data integration and interactive dashboards, with AgentForce AI for natural language queries.
Steps:
- Created semantic models with calculated fields such as:
$$ HighWaste = \begin{cases} 1 & \text{if Treatment\ Cost > 1000 \; \wedge \; Outcome < 70} \ 0 & \text{otherwise} \end{cases} $$
- Designed multi-page dashboards for financial, operational, clinical, and provider insights.
- Integrated AgentForce AI so leaders can query dashboards in plain English.
- Focused on professional UX design, ensuring the dashboards feel app-like and easy to navigate.
Challenges we ran into
- Combining multiple healthcare datasets into a single coherent model.
- Designing dashboards that balance depth with simplicity for non-technical users.
- Working within Tableau Next’s new interface, which lacks some classic features like size encoding on scatterplots.
- Building and polishing everything under tight hackathon time constraints.
Accomplishments that we're proud of
- Built a fully functional multi-dashboard prototype in under 15 hours.
- Added AI query support, showing how AgentForce can power natural language exploration.
- Balanced financial, clinical, and patient experience metrics in one tool.
- Created a design that feels both polished and ready to deploy.
What we learned
- How to leverage Tableau Next to build multi-page dashboards with an app-like flow.
- Techniques for combining financial, operational, and clinical data into one model.
- The importance of building for non-technical decision makers as the end users.
- How to simulate predictive modeling and demonstrate AI integration in a hackathon setting.
Result Analysis
Our prototype analysis demonstrated measurable impact:
- Financial Impact: High-cost, low-outcome procedures (e.g., CT scans, knee surgeries) account for nearly $18\%$ of spend. Optimizing them could save up to $15\%$ annually:
$$ \text{Savings} \approx 0.15 \times \$30M = \$4.5M $$
Operational Efficiency: MRI procedures averaged 65 minutes wait time vs. 9 minutes for blood tests. Streamlining resources could reduce wait times by $40\%$, saving about \$1.2M annually.
Clinical Outcomes: Heart surgery readmission rates are $22\%$, costing about \$8,000 per patient. Improving protocols could cut readmissions by $25\%$:
$$ \text{Savings} \approx 0.25 \times \$8,000 = \$2,000 \text{ per patient} $$
Provider Accountability: Outcome gaps of 15 points between top and bottom quartile providers. Closing this gap could improve outcomes by $12\%$, saving \$900K annually.
AI Efficiency: AgentForce reduces dependency on analysts, saving about 520 hours of manual analysis annually.
What's next for MeCoMa
- Add real-time hospital data feeds to move from prototype to live insights.
- Build predictive models for readmission risk, moving from descriptive to prescriptive analytics.
- Expand adoption to insurers and clinics beyond hospitals.
- Develop MeCoMa into a standalone web application that becomes the decision-making assistant for healthcare executives.
Built With
- salesforce
- supademo
- tableaunext
- workflows
Log in or sign up for Devpost to join the conversation.