FREE NURSING CARE BUDGET MONITOR FOR THE PERIOD ENDING 30 SEPTEMBER 04 
1 April - 30 September 2004                  1                2                3                4                5               6               7               8               9 10 11               12 13
 Expenditure  Projected Projected Activity
 Qtr 1  July  Aug  Sept  Qtr 2  Total  Budget  Actual  Variance No Clients No Clients  Budgeted
 Apr - June  Sub-Total  To Date as at 30 June as at 30 Sept  No Clients Variance
 £  £  £  £  £  £  £  £  £
IWSSD Funded Island Clients
Q501 Elderly Frail - East Team        385,295       120,190       121,968       129,552       371,710     757,005  2,195,610  1,568,082     627,528 N/A 54 87.0 33.0
Q502 Elderly Frail - West Team        266,905        93,200       101,605        85,062       279,867     546,772  1,261,845  1,115,875     145,970 N/A 39 50.0 11.0
Q503 Elderly Frail - Hospital Team        186,796        60,636        63,254        35,507       159,397     346,193     126,185     600,974 -   474,789 N/A 18 5.0 -13.0
Q504 Elderly Frail - Sensory Impairment          32,811        16,404        14,021        14,509        44,934       77,745     151,420     160,991 -      9,571 N/A 6 6.0 0.0
Q505 Elderly Mentally Ill - East Team        106,761        40,416        38,719        40,117       119,252     226,013     454,264     499,527 -     45,263 N/A 18 18.0 0.0
Q506  Elderly Mentally Ill - West Team        144,019        60,554        49,796        49,475       159,825     303,844     555,212     635,874 -     80,662 N/A 23 22.0 -1.0
Q507 Elderly Mentally Ill - Hospital Team            4,581 -           187               -                 -   -           187        4,394       25,237        4,398       20,839 N/A 0 1.0 1.0
Q508 Elderly Mentally Ill - Sensory Impairment          14,430          5,553          5,033          4,871        15,457       29,887       50,474       59,261 -      8,787 N/A 2 2.0 0.0
Q509 Mental Health - East Team                 -                 -                 -                 -                 -               -         50,474             -         50,474 N/A 0 2.0 2.0
Q510 Mental Health - West Team            7,719          3,165          2,689          2,603          8,457       16,176       25,237       31,664 -      6,427 N/A 1 1.0 0.0
Q511 Physical Disability - Hospital Team                 -                 -               -         25,237             -         25,237 N/A 0 1.0 1.0
Q512 Physical Disability          28,042        11,094          9,553          9,245        29,892       57,934       75,711     114,250 -     38,539 N/A 4 3.0 -1.0
Q513 Physical Disability - Sensory Impairment                 -                 -               -         25,237             -         25,237 N/A 0 1.0 1.0
     1,177,359       411,025       406,638       370,941    1,188,604  2,365,963  5,022,143  4,790,896     231,247 0 165 199.0 34.0
IWSSD Funded Mainland Clients
Q551 Elderly Frail - East Team            7,389          3,390               -                 -            3,390       10,779       42,518       22,291       20,227 N/A 1 2.0 1.0
Q552 Elderly Frail - West Team            9,201          3,759          3,759          3,696        11,214       20,415       42,518       45,252 -      2,734 N/A 2 2.0 0.0
Q553 Elderly Frail - Hospital Team            2,812               -                 -                 -                 -          2,812             -          8,529 -      8,529 N/A 0 0.0 0.0
Q554 Elderly Frail - Sensory Impairment                 -                 -                 -                 -                 -               -               -             928 -         928 N/A 0 0.0 0.0
Q555 Elderly Mentally Ill - East Team          12,244          3,990          3,990          2,207        10,187       22,431             -         49,144 -     49,144 N/A 2 0.0 -2.0
Q556 Elderly Mentally Ill - West Team            3,364               -                 -                 -                 -          3,364             -          4,039 -      4,039 N/A 0 0.0 0.0
Q559 Mental Health - East Team                 -                 -                 -                 -                 -               -         21,259             -         21,259 N/A 0 1.0 1.0
Q560 Mental Health - West Team            5,396          1,837          1,838          1,779          5,454       10,850       21,259       22,287 -      1,028 N/A 1 1.0 0.0
Q562 Physical Disability                 -            1,876          1,160          7,786        10,822       10,822             -          2,552 -      2,552 N/A 0 0.0 0.0
         40,406        14,852        10,747        15,468        41,067       81,473     127,554     155,022 -     27,468 0 6 6.0 0.0
RNCC Island Placed Self Funders
Q570 RNCC Island Self Funders        112,652        45,573        52,809        31,489       129,871     242,523     352,287     506,311 -   154,024 N/A 102 89.0 -13.4
RNCC Island Self Funders Placed by Mainland Authorities
Q580 RNCC Self Funders (placed by Mainland Auth)            7,289          3,112          3,909          2,808          9,829       17,118       47,151       33,897       13,254 N/A 6 13.0 7.0
SUB-TOTAL      1,337,706       474,562       474,103       420,706    1,369,371  2,707,077  5,549,135  5,486,126       63,009 N/A 279 307.0 27.6
OTHER ITEMS
Q585 Continence Products                 -                 -                 -                 -                 -               -         80,000       87,843 -      7,843
Q590 Admin/Assessment                 -                 -                 -                 -                 -               -         41,200       41,200             -  
Q599 Unallocated/Contingency                 -                 -                 -                 -                 -               -         98,740             -         98,740
SUB-TOTAL                 -                 -                 -                 -                 -               -       219,940     129,043       90,897
                 
TOTAL      1,337,706       474,562       474,103       420,706    1,369,371  2,707,077  5,769,075  5,615,169     153,906
Notes:
The expenditure columns (1-6) show actual expenditure in this period, i.e. no accruals basis is used
Indicative share of the underspend based on the contributions to the pooled budget are as follows:
   Social Services @ 75.5%  £     116,199
   Primary Care Trust @ 24.5%   £      37,707
 £     153,906