Live demos: no login required HIPAA-aligned · BAA on every account Austin, TX · Built for skilled nursing operators
(405) 383-5214

Weekly Census Forecasting With Ranges: A Step-by-Step Method

You do not need complex models to forecast census. A simple weekly method using pending admissions, discharges and trends gives administrators useful lead time.

3 min readBy CarePulse Analytics Team

Census drives nearly everything in a care community: revenue, staffing, supplies, dining and the daily feel of the building. Yet in many buildings, the forecast lives in the administrator's head, informed by experience and a few conversations. That works until a busy week arrives, or a cluster of discharges comes together.

A simple, repeatable weekly forecast does not require advanced statistics. It requires a consistent method and a willingness to compare what you expected with what happened.

The basic idea

At its simplest, a short-term census forecast looks like this:

Expected census = current census + expected admissions - expected discharges

The art is in estimating the last two terms. The following steps make it practical.

Step 1: List known admissions

Start with admissions that are scheduled or highly likely in the coming week. Your referral log or admission tracker is the source. Mark each as confirmed, likely or uncertain, and be conservative about the uncertain ones.

Step 2: List expected discharges

Include planned discharges, such as residents going home after rehabilitation, and any transfers you know about. Therapy and social services leaders can share their expected dates. Remember that planned dates sometimes move, so note the confidence level.

Step 3: Account for typical variation

Some changes are not predictable, such as hospital transfers or deaths. Rather than guessing each one, use your building's history to estimate a typical range. Look at the past several weeks and note how much census moved that you could not have predicted.

Step 4: Express it as a range

A single number suggests more certainty than exists. Use a range, such as a low, expected and high scenario, so planning accounts for uncertainty.

Step 5: Compare and learn

At the end of each week, compare the forecast with the actual census. Where did you miss? Were discharges earlier than expected? Did expected admissions fall through? Over time, you will learn where your estimates are weak and adjust.

Metrics that improve the forecast

Referral pipeline

Referrals in review, accepted but not yet admitted, and typical conversion rates from your own history.

Average length of stay by payer or service line

This helps anticipate the timing of discharges.

Day-of-week patterns

Many buildings see more admissions on certain days, and more discharges on others.

Seasonal patterns

Use your own history to note how census typically moves at different times of year.

Pending payer decisions

Authorization timelines can influence discharge timing.

Using the forecast

A forecast is only valuable if it informs decisions. Examples:

  • Staffing: adjust schedules ahead of a heavy admission day
  • Admissions: prioritize follow-up on referrals that would fill predicted gaps
  • Business office: anticipate revenue and A/R timing
  • Dietary and supplies: plan for changes in volume
  • MDS: prepare for admission-related assessments

Build a weekly rhythm

  1. Gather. Admissions, therapy, social services and nursing contribute their expected movements.
  2. Combine. Create the range forecast.
  3. Share. Distribute a one-page summary to department heads.
  4. Review. Next week, compare and adjust.

A fifteen-minute standing meeting, perhaps at the start of the week, can handle all four steps.

A hypothetical example

Imagine a hypothetical 90-bed building with several planned discharges at the end of the week and only a few confirmed admissions. The forecast shows a likely dip in census. The administrator asks admissions to prioritize pending referrals and asks the scheduler to consider adjusting staffing for the weekend. The forecast did not solve the dip, but gave the team time to respond.

Avoid these mistakes

  • Treating uncertain admissions as certain. Optimism can distort planning.
  • Ignoring the previous forecast. Reviewing misses is how the method improves.
  • Making it too complex. A method nobody maintains is worse than a simple one.
  • Keeping it private. Share it so every department can plan.

When to add sophistication

Once the simple method is working, you may add elements such as probability weights by referral source, or segment by payer. Keep each addition tied to a decision it would help you make.

Where CarePulse fits

CarePulse can combine referral, census and discharge data to support a weekly view of expected census, with history so you can see how past forecasts compared. If you would like to see how that might look with your data, a demo is a good place to start.