← Care Systems IntelligenceWORKFORCE • FUNDING • RESIDENT PROGRAMS

LTC Optimization Framework Portal

A working analytical framework to help long-term care leaders review staffing, direct resources, and plan resident-program support.

DATA KEY: Sample data for three fictional facilities • January–September 2026 • Grant examples are fictional and unverified

Quick key · What you are looking at

LTC means long-term care. Choose a facility and reporting period below. The portal summarizes the selected records; the overtime slider explores an assumption.

Dashboard termPlain-language meaningHow to use it
Vacancy rateThe share of budgeted staff capacity that is unfilled.Review recruitment and staffing coverage needs.
Staff turnoverStaff departures during the selected period compared with average staff headcount.Review retention; compare periods of the same length.
Overtime (OT) shareThe share of regular and overtime employee hours worked as overtime.Review workload and scheduling pressure.
FTEFull-time equivalent: a way to express staff capacity in full-time roles.Compare filled capacity with the staffing budget.
Direct nursing HPRDDirect nursing hours per resident day.Review nursing coverage; this is not a compliance determination.
Program funding gapPlanned program costs that committed funding does not yet cover.Review funding priorities and unmet needs.
Program participationThe share of eligible residents participating each month, combined across selected months.Review engagement; this does not measure care outcomes.
Grant pipelineOpportunities being researched or prepared; potential amounts are not awarded funds.Organize funding work separately from available money.
Scenario amountA calculated illustration of an assumed overtime reduction.Explore a planning assumption; it is not achieved savings.

Sample data means generated records rather than actual facility records. Committed funding means an allocation included in the sample model. Optimization describes the portal’s decision-support purpose; this version does not automatically determine the best staffing or funding allocation.

Workforce pressure over time

Monthly vacancy rate = unfilled budgeted FTE ÷ budgeted FTE. No regulatory threshold is implied.

Operating cost review

Costs for the selected facilities and period. Program allocations are shown separately.

Facility performance comparison

All three facilities remain visible; only the reporting-period filter applies here. Period rates use summed numerators and denominators; staffing and occupied beds use monthly averages. Turnover is cumulative over the selected period, not annualized.
Sample facilityFilled / budgeted FTE*VacancyTurnoverOT shareDirect nursing HPRDProgram participationProgram funding gap

*Monthly average. HPRD = recorded direct nursing hours ÷ resident days; this demonstration is not a staffing compliance assessment. Participation is based on resident-month observations, not unique people across months.

Overtime planning scenario

Pending facility-data validation. Sample overtime levels are not an industry benchmark. The amount below is excluded from the default overview and printed evidence view.

Explore sample overtime assumptions

Illustrative gross overtime wage reduction. This assumes the same hourly wage and excludes replacement staffing, implementation cost, and care coverage effects.

Scenario amount • not achieved savings

Resident programs & funding allocation

Program budgets and committed funding are separate planning allocations. They are not added to operating revenue. Participation indicates engagement, not improved care quality or wellbeing.

Illustrative grant pipeline

Facility filter applies. Pipeline is an illustrative snapshot as of October 7, 2026; November dates below are future application deadlines and does not change with the operations period. Potential amounts are not awards or available cash.
Fictional opportunityPurposePotential amountStageIllustrative deadline
Definitions, limitations, and evidence use

Vacancy rate = Σ(BudgetedFTE − FilledFTE) / ΣBudgetedFTE. Period turnover = ΣSeparations / mean((HeadcountStart + HeadcountEnd)/2). Overtime share = ΣOvertimeHours / Σ(RegularHours + OvertimeHours); agency hours are excluded from that employee-hours denominator. Program participation = ΣProgramParticipants / ΣProgramEligibleResidents. Funding gap = Σmax(ProgramBudget − CommittedProgramFunding,0).

All records were generated deterministically with seed 42. There are no actual client records, confirmed grant opportunities, clinical outcomes, predictive models, causal findings, or deployed integrations in this version. Monthly snapshots simplify real staffing and finance systems. The dashboard supports descriptive review and a transparent scenario, rather than mathematical optimization.

Created with AI assistance on October 7, 2026 UTC (October 6 in Louisville). Calculation review, native Power BI implementation, and documentation of adaptations and testing remain part of the development process. Do not present this HTML dashboard as a native Power BI file or as a deployed facility system.

Framework Portal v1.2 • Current dataset: simulated • Built for operational review and planning • Companion package includes data, Power BI formulas, setup instructions, and validation records.