stripe-projects
stripe projects
service-line-profitability
Analyze profitability by clinical service line using contribution margin analysis, cost allocation, and volume-revenue-expense decomposition. Use when evaluating service line financial performance, making investment or divestiture decisions, benchmarking against peers, or optimizing service mix.
Full skill instructions
This skill performs detailed financial analysis of clinical service lines — cardiology, orthopedics, oncology, women's health, behavioral health, primary care, etc. — using contribution margin methodology, full-cost allocation, and driver-based variance analysis. It produces actionable insights for service line investment, optimization, and strategic portfolio decisions.
| Input | Description | Format |
|---|---|---|
| Revenue data | Gross charges, contractual adjustments, net revenue by service line | Revenue ledger |
| Cost data | Direct costs (labor, supplies, drugs), indirect costs | Cost accounting |
| Volume data | Encounters, procedures, admissions, RVUs by service line | Volume stats |
| Payer mix | Revenue by payer (Commercial, Medicare, Medicaid, Self-pay) | Payer analysis |
| Cost allocation | Overhead allocation methodology and rates | Finance policy |
| Benchmarks | Peer margin data, national medians (MGMA, HFMA) | Reference data |
Establish clear service line definitions:
Build the service line income statement:
Gross Revenue (charges)
− Contractual Adjustments & Bad Debt
= Net Patient Revenue
+ Other Operating Revenue (grants, 340B, ancillary)
= Total Operating Revenue
− Direct Variable Costs
• Clinical labor (nurses, techs, therapists)
• Medical supplies and implants
• Pharmaceuticals
• Purchased services (contract labor, outsourced reads)
= Contribution Margin (CM)
− Direct Fixed Costs
• Physician compensation (if employed model)
• Equipment depreciation
• Dedicated facility costs
= Service Line Operating Margin
− Allocated Overhead
• Administration, IT, finance, HR, compliance
• Facility (shared space, utilities)
• Marketing, quality, training
= Fully Loaded Margin
Calculate CM ratio: Contribution Margin / Net Revenue × 100
Decompose margin changes into contributing factors:
Evaluate profitability by payer within each service line:
| Payer | Net Rev/Case | Cost/Case | Margin/Case | Margin % | Volume Share |
|---|---|---|---|---|---|
| Commercial | $18,500 | $14,200 | $4,300 | 23.2% | 35% |
| Medicare FFS | $12,800 | $14,200 | ($1,400) | −10.9% | 40% |
| Medicare Advantage | $13,500 | $14,200 | ($700) | −5.2% | 10% |
| Medicaid | $8,900 | $14,200 | ($5,300) | −59.6% | 12% |
| Self-Pay | $3,200 | $14,200 | ($11,000) | −343.8% | 3% |
Identify which payers are subsidizing others and the threshold commercial volume needed for overall profitability.
Compare service line metrics against external benchmarks:
Key benchmarking metrics: contribution margin per RVU/case/provider FTE, cost per RVU, revenue per adjusted discharge, and labor cost as percentage of net revenue.
Evaluate service line investment and optimization scenarios:
Synthesize analysis into portfolio strategy:
| Category | Criteria | Strategic Action |
|---|---|---|
| Stars | High margin, growing volume | Invest aggressively, protect market share |
| Cash cows | High margin, stable volume | Maintain, optimize efficiency |
| Turnarounds | Low margin, high strategic value | Targeted improvement plan with timeline |
| Divestiture candidates | Low margin, low strategic value | Evaluate exit or restructure |
| Growth bets | Negative margin, high market potential | Time-limited investment with milestones |
Consider non-financial strategic value: community need, network integrity, referral generation, academic mission, regulatory requirements.
Service Line Profitability Report:
├── Executive Summary (portfolio overview, top/bottom performers, key actions)
├── Service Line P&L Statements (contribution margin through fully loaded)
├── Margin Waterfall (volume, revenue, expense, mix variance decomposition)
├── Payer Mix Analysis (profitability by payer within each service line)
├── Benchmark Comparison (peer margins, cost per RVU, productivity)
├── Trend Analysis (3-5 year margin and volume trends)
├── Scenario Models (growth, cost reduction, payer mix sensitivity)
├── Strategic Portfolio Matrix (Stars, Cash Cows, Turnarounds, Divestiture)
├── Investment Recommendations (prioritized with expected ROI)
└── Methodology Notes (allocation methods, definitions, data sources)
| Service Line | National Median CM% | Top Quartile CM% |
|---|---|---|
| Cardiovascular | 35-45% | > 50% |
| Orthopedics | 40-50% | > 55% |
| Oncology | 25-35% | > 40% |
| Neurosciences | 30-40% | > 45% |
| Women's Health | 20-30% | > 35% |
| Primary Care | 5-15% | > 20% |
| Behavioral Health | 0-10% | > 15% |
| ED | 15-25% | > 30% |
Non-financial factors to weight alongside margin: community health need (CHNA priorities), downstream revenue generation (referral pathways), competitive positioning, academic/research mission alignment, regulatory requirements (emergency services, trauma designation), and workforce pipeline (teaching programs).
Example 1 — Hospital Service Line Review Analyze 12 service lines for a 350-bed community hospital. Identify cardiovascular (CM 48%) and orthopedics (CM 52%) as Stars. Flag behavioral health (CM −3%) and primary care (CM 6%) as margin-negative but strategically essential for referral generation. Model shows eliminating behavioral health would reduce cardiovascular volume by 8% through lost referral pathways, making the net system impact negative. Recommend operational turnaround plan for behavioral health rather than divestiture.
Example 2 — Ambulatory Service Line Expansion Evaluate adding a new ambulatory surgery center for orthopedic and GI procedures. Model: 3,200 projected cases in Year 1 at average CM of $2,800/case. Startup investment $4.5M. Projected break-even at 1,600 cases (Year 1). 5-year NPV: $8.2M. Payer mix sensitivity: profitable if commercial payer mix stays above 40%.
Service line profitability analysis primarily uses aggregate financial and operational data. When patient-level claims or encounter data is used for case-level costing, all processing must comply with HIPAA Privacy and Security Rules. Apply minimum necessary data access. Financial reports should not include patient identifiers. Cost-per-case analyses shared externally must be de-identified per 45 CFR §164.514. Reports shared with potential partners or investors require appropriate confidentiality agreements or Business Associate Agreements.
stripe projects
Harvest every `ponytail:` comment in the codebase into a debt ledger, so the deliberate shortcuts and deferrals ponytail leaves behind get tracked instead of rotting into "later means never". One-shot report, changes nothing.
okx dex market
okx agentic wallet
gmgn portfolio
okx dapp discovery
okx agent payments protocol
Stripe payment processing with checkout sessions, subscriptions, webhooks, and customer management.
Build comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups. Use this skill when creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-r...
Stock and cryptocurrency analysis with portfolio management and multi-dimensional scoring.
Real-time crypto derivatives positioning, whale tracking, liquidations, and institutional ETF flows across 37 specialized tools.
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.
Stay Ahead with Finalle.ai: The Ultimate Financial News and Tools Platform
AI-powered Pine Script code generator for TradingView
Research stocks at the speed of thought.
Empower your investment strategies with AI signals, option flow data, and advanced chart patterns.
Danelfin review covering its AI stock and ETF scores, rankings, portfolio tools, current pricing, strengths, risks, and alternatives for investors.
A software for comprehensive market sentiment analysis.
'Stock Correlations' App by Freshly.ai: Reveal Stock Patterns and Trends