Hospital Bed Management & Patient Flow Optimizer
Analyze bed occupancy, forecast demand, and optimize patient flow logistics
What You Can Do
Analyze historical occupancy patterns to uncover unit-specific bottlenecks and discharge delays. Forecast bed demand based on admission trends and seasonal variation. Model capacity scenarios—such as staffing changes, new units, or bed reductions—to predict operational impact before implementation. Generate data-driven recommendations for discharge planning protocols, ICU-to-step-down transitions, and surge capacity strategies.
Features
identify peak demand periods, unit-level constraints, and recurring bottlenecks from historical data
predict bed needs 1-4 weeks ahead based on admission patterns, seasonality, and historical trends
simulate the impact of staffing changes, new beds, unit closures, or patient flow protocol shifts
pinpoint clinical, operational, and systemic factors extending patient stays
develop protocols to improve transitions and reduce bed hold times
forecast appropriate bed mix and staffing needs across acuity levels
assess facility readiness for emergency events and census spikes
generate unit-specific metrics (occupancy %, LOS, turnover rate, case-mix adjusted benchmarks)
Example Output
Example 1: Occupancy Pattern Analysis
Unit: Medical-Surgical (5 beds)
- Peak occupancy: 92% (Tue-Thu mornings)
- Avg discharge day: Friday (44% of discharges)
- Weekend census drop: 35% below weekday average
- Bottleneck: Monday morning admits backed up due to Friday discharge wave
Recommendation: Implement weekend discharge protocols and Monday-morning triage to smooth flow.
Example 2: Demand Forecast
ICU Bed Forecast (next 3 weeks):
- Week 1: 8.2 avg beds needed (current capacity: 8)
- Week 2: 9.1 avg beds needed — CAPACITY RISK
- Week 3: 7.8 avg beds needed
Action: Reserve 1 step-down bed for ICU overflow in Week 2; brief discharge planning team.
Example 3: Scenario Model
Scenario: Reduce beds from 40 to 35 (-5 beds)
Predicted impact:
- Occupancy rises from 78% to 91%
- Estimated 12% increase in average LOS (longer hold times)
- ED throughput reduced by ~8 admissions/week
- Staff overtime likely +15-20%
Conclusion: Not recommended without process improvements.
What's Included
- SKILL.md instruction file with workflow and prompt templates:
- Occupancy Data Template: Excel/CSV structure for unit-level bed data (date, unit, admits, discharges, census, LOS)
- Demand Forecasting Worksheet: historical data prep guide and interpretation checklist
- Scenario Modeling Framework: structured prompts for testing staffing, unit expansion, and surge scenarios
- KPI Dashboard Checklist: 12-15 key metrics to track with formulas and benchmarking guidance
- Discharge Planning Protocol Toolkit: templates for unit-level action plans based on bottleneck analysis
Who It's For
- Hospital administrators and operations directors planning bed allocation and patient flow
- Chief nursing officers optimizing unit staffing and discharge protocols
- Emergency department leaders managing admission backlogs and ED throughput
- Capacity planners forecasting bed needs and modeling expansion scenarios
- Quality and performance improvement teams reducing length of stay and improving throughput metrics
Best For
- Analyzing occupancy trends and identifying recurring operational bottlenecks
- Forecasting bed demand for the next 2-4 weeks based on admission patterns
- Modeling the impact of staffing, unit expansion, or bed reduction decisions before implementation
- Developing discharge planning protocols and process improvements
- Creating unit-specific KPI dashboards and performance benchmarks
You might also like
You can create health crisis communications that satisfy competing stakeholder interests—public health officials, political leadership, and foreign governments—without compromising either scientific integrity or diplomatic standing. This skill guides you through political risk analysis, stakeholder interest mapping, and language pre-testing to ensure your health messaging withstands scrutiny from both epidemiological and diplomatic angles.
by github
You can analyze denial data to identify patterns, prioritize which denials offer the highest recovery potential based on payer behavior and clinical evidence strength, and generate payer-specific appeal letters with medical necessity documentation. This approach recovers 30-40% of denied claims while revealing systemic billing issues that prevent future denials, dramatically improving your denial management ROI.
by github
You can process large volumes of patient feedback—surveys, reviews, complaints, and compliments—to identify recurring themes and emotional patterns that drive satisfaction. Claude reveals which service touchpoints matter most to your patient population, highlights systemic gaps, and generates prioritized improvement initiatives with clear implementation pathways. This transforms reactive complaint handling into proactive satisfaction architecture grounded in data.
by github
You can upload payer contracts and receive detailed analysis of reimbursement rates, payment terms, prior authorization requirements, and risk allocation clauses. The skill identifies rate adequacy gaps, flags hidden revenue leakage from bundling definitions and offset clauses, and surfaces negotiation leverage points based on industry benchmarks and your operational data. You'll generate evidence packages and rate scenario models to strengthen your position before contract renewal or amendment discussions.
by github
You can conduct comprehensive compliance audits of active grants by evaluating them against federal regulations (OMB 2 CFR 200), funder-specific terms, and institutional policies. Claude helps you identify specific compliance gaps, prioritize remediation actions, and create detailed remediation plans that protect institutional funding and reduce audit liability.
by github
You can systematically evaluate how political instability, leadership transitions, factional conflicts, and policy shifts affect your health security objectives and medical diplomacy initiatives. The skill identifies specific political vulnerabilities in healthcare infrastructure, pharmaceutical supply chains, aid acceptance, bilateral agreements, and cross-border health cooperation—enabling you to assess feasibility before committing resources and develop contingency protocols for high-risk environments.
by github
You can quickly process provider enrollment applications across multiple payer networks by identifying specific documentation gaps, verifying compliance with Medicare, state medical board, and DEA requirements, and generating compliant follow-up communications. This skill reduces enrollment cycle time and ensures applications are submission-ready on the first request, helping you manage high-volume credentialing workflows efficiently while maintaining audit-trail documentation.
by github
You can rapidly assess political risks that directly threaten healthcare operations abroad, including government stability, regulatory capture, sanctions impact, and how political transitions affect hospital partnerships. This skill integrates healthcare-specific political factors—pharmaceutical lobby influence, medical licensing corruption, and health system reform dynamics—into a structured risk assessment that informs strategic decisions on expanding, maintaining, or withdrawing from health programs.
by github