House Operations Report

The House Operations report is a detailed set of statistics about the operations of the House over a period of time. It takes much of its data from the Room Occupants Detail screen and the Daily Occupancy tab of the Occupant Manager. For the numbers to be accurate, you must use the Daily Occupancy tab to mark the status of room occupants on a daily basis.

The report shows each month, each quarter, and year-to-date figures for 49 different parameters related to the activity in the House. These details are explained line by line below:

FAMILIES AND PEOPLE

 

1. Number of families

the number of different families who spent at least one night in the house during the period.

2. Number of adults

the number of different adults who stayed in the house. This includes guests and additional adults. This count is taken from the Occupant/patient grid at the bottom of the Daily Occupancy tab. Adults who are checked as "in room" are counted.

3. Number of children

the number of different children who stayed in the house. This includes patients and additional children. This count is taken from the Occupant/patient grid at the bottom of the Daily Occupancy tab. All patients are counted, along with additional children who are checked as "in room".

4. Number of outpatients only

the number of different children who were outpatients only during their stay. This count is taken from the Occupant/patient grid at the bottom of the Daily Occupancy tab. Patients who are checked as "in room" for their entire stay are counted.

5. Number of children who were both an outpatient and an inpatient at some time in their stay

the number of children who sometimes stayed in the House during their stay and sometimes were inpatients. This count is taken from the Occupant/patient grid at the bottom of the Daily Occupancy tab. Patients who are checked as "in room" for some of their stay and "inpatient" for some of their stay are counted.

6. Number of inpatients only

the number of different children who were inpatients only during their stay. This count is taken from the Occupant/patient grid at the bottom of the Daily Occupancy tab. Patients who are checked as "inpatient" for their entire stay are counted.

7. % families speak a language other than English at home

the number of families who speak a language other than English divided by the number of families in line 1. Whether a family speaks English at home is determined by the field you selected for this parameter on the report setup screen.

8. % families from

the number of families from each region divided by the number of families in line 1. The region is determined by the Region code on the Guest Stay screen. The 5 regions are selected on the report setup screen.

SERVICES - TOTALS

 

9. Number of room nights available

the number of rooms that are active (available) multiplied by the number of nights in the period. Rooms are defined on the Codes tab of Application Setup. A room is available unless the Active box on the Codes tab is unchecked (the room code is inactive.) Room codes can be marked as inactive for a specific date range.

10. Number of room nights used

the sum of the number of nights used by each available room during the period. A room is "used" if at least one person is marked as "in room" in the Occupant/patient grid at the bottom of the Daily Occupancy tab.

11. Number of stays

the total number of stays that had at least one night in the period. This count is taken from the Guest screen, Entry Detail tab, using the arrival and departure dates and the Stay Type of "Stay."

12. Number of stay entries

the number of stays with an arrival date in the period. This count is taken from the Guest screen, Entry Detail tab, using the arrival date and the Stay Type of "Stay."

13. Number of stay exits

the number of stays with a departure date in the period. This count is taken from the Guest screen, Entry Detail tab, using the departure date on the Billing tab and the Stay Type of "Stay."

14. Total number of adult guest entries

the number of adults who arrived during the period. This count is taken from the Daily Occupancy tab, using the check boxes in the Occupant/patient grid to determine when an adult guest has arrived.

15. Total number of child guest entries

the number of children who arrived during the period. This count is taken from the Daily Occupancy tab, using the check boxes in the Occupant/patient grid to determine when a child guest has arrived. This count includes patients who are "in room" and additional children.

16. Total number of outpatient entries

the number of outpatients who arrived during the period. This count is taken from the Daily Occupancy tab, using the check boxes in the Occupant/patient grid to determine whether a patient is an inpatient or is staying in the room (outpatient.)

17. Number of nights full

the number of nights during the period when every available room was occupied.

18. Number of nights less than 75% full

the number of nights during the period when less than 75% of the available rooms were occupied.

19. Number of stays for 5 diagnosis categories

the count of stays during the period for which a patient has one of the 5 diagnosis categories selected in the report setup screen. Note that if a stay includes more than one patient, and the patients have different diagnoses, the stay may be counted more than once.

SERVICES

 

20. Average rooms available

the number of rooms available each night averaged over the period.

21. Average booked rooms per night

the number of rooms occupied each night averaged over the period. Whether a room is occupied is determined from the Daily Occupancy tab.

22. Average people per night

the number of people occupying rooms averaged over the period. The count of people is taken from the Occupant/patient grid on the Daily Occupancy tab. Only people marked as "in room" for the night are counted.

 23. Average adults per night

the number of guests and additional adults occupying rooms averaged over the period. The count of adults is taken from the Occupant/patient grid on the Daily Occupancy tab. Only people marked as "in room" for the night are counted.

 24. Average children per night

the number of patients and additional children occupying rooms averaged over the period. The count is taken from the Occupant/patient grid on the Daily Occupancy tab. Only children and patients marked as "in room" for the night are counted.

25. Average outpatients per night

the number of patients occupying rooms averaged over the period. The count is taken from the Occupant/patient grid on the Daily Occupancy tab. Only patients marked as "in room" for the night are counted.

26. % of room nights subsidised - by source of income

the number of room nights paid for by third party payors divided by the total room nights for the period. The third party payor list is determined in the report setup screen. If a third party payor is selected on the Daily Occupancy tab, Paid By fields, that night is considered subsidised.

27. Room occupancy rate %

the number of room nights occupied divided by the number of available room nights during the period. A room is considered occupied if at least one person is marked as "in room" for that room and night on the Occupant/patient grid on the Daily Occupancy tab.

27b. Bed occupancy rate %

the number of beds occupied divided by the number of available beds during the period. The number of beds available is determined by the capacity of the room as set on the Codes tab of Application Setup. A bed is considered occupied for each person who is marked as "in room" for that room and night on the Occupant/patient grid on the Daily Occupancy tab.

28. % nights full

the number of nights that every available room is occupied divided by the number of nights in the period. A room is considered occupied if at least one person is marked as "in room" for that room and night on the Occupant/patient grid on the Daily Occupancy tab.

29. % nights 75% or less full

the number of nights that fewer than 75% of available rooms are occupied divided by the number of nights in the period. A room is considered occupied if at least one person is marked as "in room" for that room and night on the Occupant/patient grid on the Daily Occupancy tab.

30. Average length of stay Method 1

total room nights occupied divided by the total number of stays for the period. A stay is counted in the period if at least one night of the stay falls within the period.

31. Average length of stay Method 2

the average of the lengths of stay for all stays in the period. If the stay began before the start of the period, the length is calculated from the arrival date through the end of the period.

32. % room nights used by families staying

for each length of stay range, the number of nights used by families with that length of stay divided by the total room nights used during the period. A family's length of stay is calculated from their arrival date through the end of the period.

33. % patient nights for diagnosis

the number of room nights occupied by families with a patient with that diagnosis divided by the total number of room nights occupied during the period.

PROCESSES

 

34. Number of new families

the number of families whose first stay commenced during the period.

35. Families turned away

the number of families with an entry in the Guest Entry Detail tab with a Stay Type of "No Room" and an arrival date in the period.

VOLUNTEERS

 

36. Number of volunteers

the number of people with an entry in the Schedule tab of the Volunteer screen with a date in the period and actual hours worked. Note that this includes all volunteers unless you selected only certain project codes in the report setup screen. In that case, the hours worked must have a Project code from the list selected.

37. Volunteer hours worked

the number of hours worked by the volunteers in #36, above.

38. Volunteer hours per room night

the number of hours worked in #37 divided by the number of room nights in the period (#10).

FINANCIAL

 

39. Total room fees

the total charges for nights within the period. The total is based on charges created on the Billings tab of the Guest screen. If a charge covers a time range that overlaps the reporting period start or end dates, the total charge is prorated for the number of nights in the period. Charges are included whether they have been paid or not.

40. Room fees paid by families as a % of total

the charges paid by families divided by the total room fees in #39. A charge is considered paid by a family if the Paid By code is included in the Paid by Family list on the report setup screen.

41. Room fees paid by third parties as a % of total

the charges paid by a group of third party payors divided by total room fees in #39. The third party payor groups are defined by Paid By codes selected on the report setup screen.

DONORS

 

42. Number of donors

the number of households and organizations who made a gift during the period. If you selected only some Gift Fund codes on the report setup screen, then only donors to those funds are included.

43. Number of cash donations

the number of separate gifts made during the period. In-kind gifts as defined on the report setup screen are not included. If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

43b. Average value of donations - cash

the dollar amount of all cash donations made during the period divided by the number of donations (#43). If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

44. Number of on-line donations

the number of separate gifts made on-line during the period. Only on-line gifts as defined on the report setup screen are included. If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

44b. Average value of donations - on-line

the dollar amount of all donations made on-line during the period divided by the number of on-line donations (#44). If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

 45. Number of capital in-kind donations

the number of separate in-kind donations with a value over $500 made during the period. In-kind gifts are defined on the report setup screen. If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

 45b. Average value of donations - capital in-kind

the sum of all in-kind donations with a value over $500 made during the period divided by the number of capital in-kind donations (#45). If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

46. Number of other/regular in-kind donations

the number of separate in-kind donations with a value of $500 or less made during the period. In-kind gifts are defined on the report setup screen. If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

 46b. Average value of donations - other in-kind

the sum of all in-kind donations with a value of $500 or less made during the period divided by the number of other/regular  in-kind donations (#46). If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

47. Donations - total

the total amount of all donations received during the period. For in-kind donations, the value is counted. For other donations, the amount is counted. If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

48. Donations - cash as % total

the total amount of cash donations (not in-kind) divided by total donations (#47). If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.

49. Donations - in-kind as % total

the total value of in-kind donations divided by total donations (#47).  If you selected only some Gift Fund codes on the report setup screen, then only gifts to those funds are included.