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 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 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 rapidly evaluate pre-authorization requests by extracting clinical information from provider submissions, mapping findings against medical necessity standards, identifying documentation gaps, and generating clear authorization decisions with detailed rationale. This creates an audit trail that withstands peer review and appeals while supporting provider education through transparent decision logic.
by github
You can rapidly assess the healthcare economic implications of trade agreements by analyzing tariff classifications on pharmaceuticals and medical devices, evaluating intellectual property provisions affecting drug market entry, reviewing GATS commitments on healthcare service trade, and identifying competitive advantages or disadvantages across your portfolio countries. This skill helps you quantify market access gains and pricing pressures while flagging regulatory harmonization commitments that affect healthcare delivery.
by github
You can systematically decode state-specific grant requirements across Medicaid, workforce development, rural health, and behavioral health programs. The skill helps you identify compliance gaps in your current processes, build state-compliant budget narratives and work plans, and create audit-ready documentation frameworks tailored to your state's unique administrative standards and reporting frequencies.
by github
Conduct thorough retrospective audits of medical coding submissions with structured claim-level analysis, coder performance evaluation, and compliance risk stratification. You'll identify coding errors, quantify compliance violations, validate HCC accuracy, and generate audit documentation that satisfies CMS, OIG, and internal compliance requirements with supporting clinical justification and regulatory references.
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 systematize the entire primary source verification lifecycle—from initial data collection through final documentation—for healthcare providers. This skill manages verification requests across multiple credential categories (licenses, education, DEA, employment history), tracks source coordination timelines, resolves discrepancies between sources, and produces compliance-ready verification reports that satisfy Joint Commission, CMS, and plan network audits.
by github