Methodology · Workforce intelligence
By SeniorCRE, LLC · Updated October 12, 2026 · Educational methodology, not an operator result
A labor budget and a 13-week payroll forecast should share one model: census and care-level mix set required hours, the vacancy gap is priced as overtime and agency, and holiday differentials and employment-class loads are added to employee wages. Keeping components separate is what lets each variance be explained. The weekly reconciliation workflow lives on the senior housing payroll forecasting checklist.
| Component | Formula |
|---|---|
| Census | units × average occupancy |
| Required hours | census × days × Σ(care-level share × approved HPRD) |
| Vacancy gap | required hours × vacancy share |
| Overtime cost | gap × overtime share × base wage × overtime multiple |
| Agency cost | gap × (1 − overtime share) × agency bill rate |
| Holiday differential | census × HPRD × paid holidays × (1 − vacancy) × base wage × premium |
| Employment-class load | employee wages × Σ(class hours share × class load) |
Build the annual budget from the same components as the 13-week forecast above, so the two can be compared line by line. Required direct-care hours come from census and care-level mix; the vacancy gap is priced as overtime and agency; holiday differentials and employment-class cost loads are added last, to employee wages only.
Illustrative example — editable in the spreadsheet
Illustrative 2027 direct-care labor budget: $2,437,858 (67,277 required hours).
Illustrative only: one fictional 80-unit assisted-living community, direct-care labor only. Every input is an invented teaching assumption, not a benchmark, staffing requirement or SeniorCRE operator result.
| Component | 13-week budget slice | Rolling forecast | Variance |
|---|---|---|---|
| Straight-time wages | $432,076 | $406,375 | −$25,700 |
| Overtime wages | $33,815 | $45,204 | +$11,389 |
| Holiday differential | $4,748 | $4,466 | −$282 |
| Employment-class cost load | $113,894 | $110,363 | −$3,532 |
| Agency cost | $22,543 | $32,288 | +$9,745 |
| Total direct-care labor | $607,076 | $598,696 | −$8,380 |
Lower census lowers straight-time wages while a wider vacancy gap and a higher agency rate raise overtime and agency cost. A blended total would hide that the premium-labor lines moved the opposite way.
Start from census and care-level mix to calculate required direct-care hours, subtract filled-position coverage to find the vacancy gap, price that gap as overtime and agency, add holiday differentials, then apply employment-class cost loads to employee wages only. Keep each component separate so the annual budget can be compared with the rolling 13-week forecast component by component.
Run the same model for the next 91 days with budget inputs, then rerun it with current census, vacancy and rate readings. The difference by component is the bridge: it shows whether a variance comes from census, coverage or price rather than one blended total.