Rooms × length-of-stay × turnover × no-show rate × overbook policy. The operational tool the board chair asks about and nobody has a clean answer for. Built for executive directors and house managers running hospital-adjacent family housing — Ronald McDonald House, hospital foundation lodging, pediatric oncology family residences. Compute realized occupancy, average waitlist days, families turned away, and the overbook strategy that gets one more family in the door.
Defaults are typical for a mid-size hospital-adjacent family house (~24 rooms, pediatric oncology + cardiology + transplant referral mix).
Length-of-stay distribution, no-show pattern, and the family mix. The single most important number in this whole tool is average LOS — it determines turnover frequency and therefore how many families you serve per year.
Different clinical referrals stay different lengths. Enter the % of families in each bucket and the average LOS for that bucket. They don't need to be precise — directionally accurate is enough.
When demand exceeds capacity (and it usually does), who gets the room? Every house has an implicit priority order — written down or not. Set the weights you actually use. The tool reports the implied turn-away pattern.
When a family is referred and a room isn't available, how many days do they typically wait? If you don't measure this — most houses don't — leave the default and the model will estimate from waitlist depth ÷ turnover rate.
If no-shows are 10% and you never overbook, 10% of your rooms sit empty when families are sleeping in their cars. Airlines figured this out decades ago. Houses are catching up. Conservative overbook is 4-8%; aggressive (and risky) is 12-15%.
The numbers — and what they say about where the next capacity dollar should go.
Per-family-night cost detail, capital-campaign sizing, hospital partner agreement modeling, in-kind-donation valuation for furnishings and food, volunteer-hour valuation, planned-giving program design for legacy donors. Built for the kind of nonprofit where the executive director, the house manager, and the development director all need to be looking at the same operating reality. Here, try these. They may help.
Educational and informational purposes only. This calculator and any output it produces are intended solely for general educational and decision-support purposes. They do not constitute investment, tax, legal, accounting, appraisal, lending, insurance, nonprofit-operations, or any other professional advice, and they do not create a fiduciary, attorney-client, accountant-client, or advisor-client relationship of any kind.
Estimates based on your inputs. All results are estimates derived from the data and assumptions you provide. Hospital partner agreements, eligibility frameworks, accounting standards (including FASB ASC 958 and IRS Form 990 reporting), regulations, family circumstances, and the specific facts of your house can materially change the answer. Industry occupancy benchmarks cited are approximate and drawn from publicly available family-housing-nonprofit reporting; your hospital catchment area, referral mix, and local lodging market will determine your actual right-sized targets. The Baratelli Institute, its affiliates, and any co-branding professional make no warranty of accuracy, completeness, currency, or fitness for any particular purpose, and disclaim all liability for decisions made in reliance on the output.
Consult your own qualified professionals. Before acting on anything calculated here, consult your own attorney, CPA, financial advisor, nonprofit-operations consultant, hospital-partner finance contact, or other qualified professional licensed in your jurisdiction who has reviewed your specific facts and applicable current law. The Baratelli Institute is a publisher of practitioner reference material. It is not a registered investment adviser, broker-dealer, law firm, accounting firm, appraisal firm, lender, or nonprofit-operations consultancy.
Co-branded versions: If a professional advisor's name and contact information appear on this tool, that advisor has elected to make the tool available to clients as a courtesy. Inclusion of an advisor's name does not constitute the advisor's endorsement of any specific result, nor does it transfer professional responsibility for the underlying methodology to that advisor. The disclaimer above applies regardless of co-branding.