Docstoc

week-ahead-template

Document Sample
week-ahead-template Powered By Docstoc
					             NEXT WEEK'S SCHEDULE ON FRIDAY
          DEMAND
                      MON       TUES       WED       THURS       FRI
Surgical Admissions
          ICU
          Telemetry
     Med/Surg Unit

Non-surgical Admissions
          ICU
          Telemetry
    Med/Surg Unit

Cardiac Procedure Admissions
          ICU
          Telemetry
     Med/Surg Unit

Predicted Admissions from the ED
          ICU
          Telemetry
     Med/Surg Unit

Predicted Direct Admits
          ICU
          Telemetry
     Med/Surg Unit

Average Midnight Census
          ICU                          0         0           0         0
          Telemetry                    0         0           0         0
     Med/Surg Unit                     0         0           0         0

TOTAL DEMAND
         Hospital           0          0         0           0         0
         ICU                0          0         0           0         0
         Telemetry          0          0         0           0         0
    Med/Surg Unit           0          0         0           0         0


          CAPACITY
Staffed Beds
          ICU
          Telemetry
     Med/Surg Unit
          TOTAL
            **PREDICTED OCCUPANCY RATES**

            MON        TUES       WED        THURS      FRI
Hospital     #DIV/0!    #DIV/0!    #DIV/0!    #DIV/0!    #DIV/0!
ICU          #DIV/0!    #DIV/0!    #DIV/0!    #DIV/0!    #DIV/0!
Telemetry    #DIV/0!    #DIV/0!    #DIV/0!    #DIV/0!    #DIV/0!
M/S Unit     #DIV/0!    #DIV/0!    #DIV/0!    #DIV/0!    #DIV/0!
1. Complete this worksheet on Friday for the next week.

2. Use next week's actual surgical, non-surgical, and cardiac procedure schedules to predict ICU,
Telemetry, and M/S unit admissions.

2. Use historical data on ED admissions and direct admits to predict admissions from the ED and
direct admissions.

3. Use the predicted Sunday midnight census for Monday. The prediction should be based on
historical data and the current situation on Friday. This is the only midnight census you need to
input. Factors are entered in the spreadsheet to predict the midnight census for Tuesday through
Friday. In the spreadsheed for ICU, Telemetry, and the M/S units, the midnight census for
Tuesday will be 5% higher than Monday and Wednesday will be 5% higher than Tuesday.
Thursday and Friday will be the same as Tuesday. If you need to change the factors for your
hospital, click on the appropriate cell and make the change in the formula at the top of the
spreadsheet.

4. Total Demand will be calculated automatically.

5. Under Capacity, enter your approximate staffed beds for the next week. This will most likely be
the same number for Monday through Friday.

6. The predicted daily occupancy rates for Monday through Friday will be shown on the Data
Summary worksheet. These occupancy rates do not include internal transfers or discharges. Use
these predictions to plan patient placement to better match capacity with demand.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:12/13/2011
language:
pages:3