FREE NURSING CARE BUDGET MONITOR FOR THE PERIOD ENDING 31 DECEMBER 03 
1 April - 31 December 2003                  1                2                3                4                5               6               7               8               9 10               11 12
 Expenditure  Projected Projected Activity
 Qtr 1  Qtr 2  Oct  Nov  Dec  Total  Budget  Actual  Variance No Clients  Budgeted
 Apr - June  July - Sept as at 31 Dec  No Clients Variance
 £  £  £  £  £  £  £  £  £
Preserved Rights
Q501 Elderly Frail - East Team          39,497        30,161          8,983          8,694          8,984       96,319     158,970     149,330        9,640 5 6 1
Q502 Elderly Frail - West Team          33,120        33,482          7,353          8,735          5,750       88,440     132,475     108,311       24,164 3 5 2
Q505 Elderly Mentally Ill - East Team          13,247        13,393          4,514          4,367          4,513       40,034       26,495       53,534 -     27,039 1 1 0
Q506  Elderly Mentally Ill - West Team            6,033               -                 -                 -                 -          6,033       26,495        6,032       20,463 0 1 1
Q509 Mental Health - East Team                 -                 -                 -                 -                 -               -         26,495             -         26,495 0 1 1
         91,897        77,036        20,850        21,796        19,247     230,826     370,930     317,207       53,723 9 14 5
IWSSD Funded Island Clients
Q501 Elderly Frail - East Team        385,545       377,039       119,092       124,639       130,748  1,137,063  2,066,613  1,466,580     600,033 55 78 23
Q502 Elderly Frail - West Team        227,988       230,756        80,755        71,964        79,088     690,551  1,139,287     951,717     187,570 38 43 5
Q503 Elderly Frail - Hospital Team          61,579       108,426        39,974        28,243        36,268     274,490     132,475     435,449 -   302,974 20 5 -15
Q504 Elderly Frail - Sensory Impairment          23,650        35,322        11,424        11,699        11,426       93,521     158,970     124,980       33,990 5 6 1
Q505 Elderly Mentally Ill - East Team          90,084        57,849        24,164        24,398        20,339     216,834     423,921     354,854       69,067 14 16 2
Q506  Elderly Mentally Ill - West Team        122,886       135,807        44,971        40,713        44,261     388,638     529,901     526,139        3,762 20 20 0
Q507 Elderly Mentally Ill - Hospital Team                 -                 -                 -            3,980          2,328        6,308       26,495       13,141       13,354 1 1 0
Q508 Elderly Mentally Ill - Sensory Impairment          14,042        22,593          4,784          4,629          4,783       50,831       52,990       64,874 -     11,884 2 2 0
Q509 Mental Health - East Team                 -                 -                 -                 -               -         26,495             -         26,495 0 1 1
Q510 Mental Health - West Team          16,153        16,682          2,526          2,446          2,527       40,334       26,495       47,834 -     21,339 1 1 0
Q511 Physical Disability - Hospital Team                 -                 -                 -                 -               -         26,495             -         26,495 0 1 1
Q512 Physical Disability          19,871        30,208          9,026          8,735          9,026       76,866       79,485     103,362 -     23,877 4 3 -1
Q513 Physical Disability - Sensory Impairment                 -                 -                 -                 -                 -               -         26,495             -         26,495 0 1 1
       961,798    1,014,682       336,716       321,446       340,794  2,975,436  4,716,117  4,088,930     627,187 160             178 18
IWSSD Funded Mainland Clients
Q551 Elderly Frail - East Team            3,083        13,518          1,660               -                 -         18,261       44,150       28,400       15,750 1 2 1
Q552 Elderly Frail - West Team            7,024          7,520          1,884               -                 -         16,428       44,150       25,596       18,554 1 2 1
Q553 Elderly Frail - Hospital Team                 -            9,282          4,457          2,730          2,821       19,290             -         27,832 -     27,832 1               -   -1
Q555 Elderly Mentally Ill - East Team            1,719        11,963          5,997          1,640          3,854       25,173             -         36,997 -     36,997 2 0 -2
Q556 Elderly Mentally Ill - West Team            5,502          5,388          1,993          1,929          1,472       16,284             -         23,530 -     23,530 1 0 -1
Q559 Mental Health - East Team                 -                 -                 -                 -               -         22,075             -         22,075 0 1 1
Q560 Mental Health - West Team            5,396          5,455          1,837          1,779          1,838       16,305       22,075       21,700           375 1 1 0
Q562 Physical Disability                 -               576               -            3,911               -          4,487             -               -               -   0 0 0
         22,724        53,702        17,828        11,989          9,985     116,228     132,450     164,055 -     31,605 7 6 -1
RNCC Island Placed Self Funders
Q570 RNCC Island Self Funders          96,230        99,402        30,080        37,166        37,203     300,081     378,300     400,108 -     21,808 100 89 -11
 
RNCC Island Self Funders Placed by Mainland Authorities
Q580 RNCC Self Funders (placed by Mainland Auth)          13,085        10,883          3,439          3,795          3,246       34,448       50,700       45,931        4,769 8 13 5
SUB-TOTAL      1,185,734    1,255,705       408,913       396,192       410,475  3,657,019  5,648,497  5,016,231     632,266 284             300 16
OTHER ITEMS
Q585 Continence Products                 -                 -                 -                 -                 -               -         76,360       82,000 -      5,640
Q590 Admin/Assessment                 -            9,637               -                 -                 -          9,637             -         40,000 -     40,000
SUB-TOTAL                 -            9,637               -                 -                 -          9,637       76,360     122,000 -     45,640
                 
TOTAL      1,185,734    1,265,342       408,913       396,192       410,475  3,666,656  5,724,857  5,138,231     586,626
Notes:
The expendiutre columns (1-5) 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 @ 76.3%  £     447,596
   Primary Care Trust @ 23.7%   £     139,030
 £     586,626