Docstoc

piVot table

Document Sample
piVot table Powered By Docstoc
					                                                                         Data                               Cost Category
                                                                         Sum of Total Committed                                                                             Sum of YTD_Budget_2                                                                     Sum of AB_BUDGET_AMT2                                                               Total Sum of Total Committed     Total Sum of YTD_Budget_2      Total Sum of AB_BUDGET_AMT2
Service Summary                   Service                                Employee Related                   Income                        Other Expenditure                 Employee Related                Income                 Other Expenditure                Employee Related            Income                 Other Expenditure
                              0                                      0                                 -8                            0                                223                               0                     0                                 0                           0                     0                                 0                              215                              0                                  0
Community Development             Community Development                                           529,311                     -379,464                            747,444                         538,814              -537,460                           822,758                     926,970              -768,080                         1,378,220                          897,291                        824,112                          1,537,110
Corporate Team                    Boston Area Regeneration Company                                                                                                      0                                                                                       0                                                                              35,910                                0                              0                             35,910
                                  Centralised Purchases                                                                               0                            38,426                                                      0                           85,779                                                  0                          147,050                           38,426                         85,779                            147,050
                                  Corporate Management Board                                      452,595                             0                             8,618                         519,169                      0                            8,466                     893,770                -72,920                           14,020                          461,213                        527,635                            834,870
Environmental                     Bereavement                                                     103,343                      -456,402                           127,234                         105,942               -443,447                          150,099                     175,800               -780,260                          306,200                         -225,824                       -187,407                           -298,260
                                  Cleansing                                                       656,180                      -226,185                           417,108                         648,948               -240,354                          421,476                   1,086,240               -433,040                          694,460                          847,103                        830,070                          1,347,660
                                  Environmental                                                   264,179                       -51,067                            30,400                         271,019                -44,832                           19,396                     460,790                -47,890                           59,720                          243,513                        245,583                            472,620
                                  Fleet Management                                                 72,520                       -34,569                           360,709                          78,009                -35,350                          323,729                     128,780                -62,600                          557,820                          398,659                        366,388                            624,000
                                  Land Charges                                                     38,190                       -79,441                            11,458                          48,993                -70,000                           15,304                      83,580               -120,000                           26,450                          -29,793                         -5,703                             -9,970
                                  Licenses                                                         53,085                       -71,508                             1,772                          45,570                -84,298                            3,296                      77,970               -105,940                            5,650                          -16,651                        -35,432                            -22,320
                                  Parks & Grounds                                                 298,865                       -88,425                            42,646                         297,305                -99,674                           60,307                     463,350               -280,100                          100,480                          253,087                        257,938                            283,730
Financial Services                Accountancy                                                     492,487                       -58,091                           248,466                         547,914                -70,337                          255,766                     953,410               -483,720                          257,650                          682,862                        733,343                            727,340
                                  Revenues & Benefits                                             299,156                    -9,227,045                        11,293,493                         312,315             -9,125,527                       10,385,252                     528,740            -15,880,010                       15,195,860                        2,365,604                      1,572,040                           -155,410
                                  Internal Audit                                                                                      0                            21,518                                                      0                           37,059                                                  0                           63,530                           21,518                         37,059                             63,530
                                  Fraud                                                            49,142                                                           2,651                          52,233                                                   2,925                      92,150                                                   3,300                           51,794                         55,158                             95,450
Human & Corporate Resources       External Communications                                          74,356                          -400                            18,107                          75,073                      0                           21,679                     126,890                     0                            29,770                           92,063                         96,753                            156,660
                                  Human Resources                                                 135,291                        -5,649                            67,835                         169,401                -14,157                          105,236                     309,080               -19,020                           172,290                          197,477                        260,480                            462,350
                                  ICT                                                             155,395                       -13,146                           215,634                         173,239                -17,987                          240,068                     306,410              -111,600                           422,410                          357,884                        395,320                            617,220
                                  Performance & Improvement                                        80,349                             0                             1,253                          86,437                      0                            3,168                     151,470                     0                             5,430                           81,602                         89,604                            156,900
Legal & Democratic                Democratic                                                       68,222                       -15,975                           264,263                          88,555                 -1,225                          282,155                     152,780                -5,470                           457,210                          316,511                        369,485                            604,520
                                  Legal                                                           169,415                       -43,187                            19,013                         159,088                -26,783                           25,615                     237,700               -28,450                            35,340                          145,241                        157,919                            244,590
Non I&E                           Balance Sheet                                                                                                                 7,633,792                                                                              -3,525,439                                                                          -6,096,517                        7,633,792                     -3,525,439                         -6,096,517
                                  Capital                                                                                                                       2,227,573                                                                               3,519,919                                                                           6,034,147                        2,227,573                      3,519,919                          6,034,147
                                  Collection Fund                                                                                                             -14,215,170                                                                                       0                                                                                   0                      -14,215,170                              0                                  0
                                  BTAC                                                                 0                         -5,230                          -104,112                           2,853                 -2,975                           16,432                       4,890                -77,680                           76,470                         -109,342                         16,309                              3,680
                                  Revenue Summary                                                                            -4,120,293                           953,914                                                      0                                0                                                  0                                0                       -3,166,379                              0                                  0
Regeneration                      Building Control                                             137,330                         -139,493                             5,014                       143,583                 -158,538                           15,348                     258,350               -271,780                           26,260                            2,850                            393                             12,830
                                  Cultural                                                     592,769                         -404,889                           413,815                       573,278                 -469,777                          794,438                     960,320               -796,540                        1,146,850                          601,694                        897,939                          1,310,630
                                  Economic Regeneration                                        124,742                         -155,410                            56,855                       120,089                 -184,427                           52,573                     207,580               -327,420                           85,710                           26,187                        -11,764                            -34,130
                                  Housing                                                      277,723                         -147,172                            40,154                       273,867                 -127,709                           60,040                     483,140               -309,040                          106,570                          170,705                        206,197                            280,670
                                  Planning                                                     265,383                         -247,068                            25,668                       277,874                 -405,297                          128,397                     496,720               -558,460                          190,230                           43,983                            974                            128,490
                                  Property                                                      65,295                         -212,986                           243,871                        67,343                 -202,029                          310,696                     123,280               -299,420                          746,240                           96,180                        176,010                            570,100
                                  Parking                                                       27,913                         -684,013                           164,233                        30,209                 -741,396                          191,520                      51,520             -1,282,450                          270,450                         -491,867                       -519,668                           -960,480
Grand Total                                                                                  5,483,229                      -16,867,109                        11,383,880                     5,707,118              -13,103,580                       14,833,455                   9,741,680            -23,121,890                       22,555,180                                0                      7,436,993                          9,174,970
                                                                                                                                                                                                                                                                                    9,736,790
                         A                  B              C          D             E         F           G            H           I           J          K               L            M        N         O         P            Q          R                 T                 U          W
1 2007/08 Summary of Performance on the Income and Expenditure Account                                                                                                                                                                                                     APPENDIX 1
2
3 As at October 2007
4
5                                                     Employee Related Costs                            Other Expenditure                                     Income                                  NET POSITION
                                                                                                                                                                                                   Total Year
                                                   Year to Date                                     Year to Date                            Year to Date                                   Total     to Date                                             Original Full
                                         Committed Budget (inc     £                %     Committed Budget (inc     £       %     Committed Budget (inc                    £       %     Committed Budget (inc £ Overall % Overall       Forecast        Year Budget                      %
6                     £000's              to Date   Virements) Variance          Variance  to Date   Virements) Variance Variance to Date    Virements)                Variance Variance  to Date  Virements) Variance Variance          Outturn          (inc cfwds)       £ Variance Variance
7                Corporate Team
8    Corporate Management Board                 453            519         66           13%         9           8            (1)   (13%)             0           0              0                   462       527        65       12%             840               892              52      6%
9    Centralised Purchases                        0              0          0                      38          86            48      56%             0           0              0                    38        86        48       56%             124               141              17     12%
10   Boston Area Regeneration Company             0              0          0                       0           0              0                     0           0              0                     0         0         0                        36                36               0      0%
11   Total Corporate Team                       453            519         66           13%        47          94            47        50%           0           0              0                   500       613       113       18%           1,000             1,069              69      6%
12
13      Human and Corporate Resources
14 Performance & Improvement                     80             86          6            7%         1           3             2        67%            0           0              0                   81        89         8        9%             154               179             25       14%
15 Human Resources                              135            169         34           20%        68         105            37        35%          (6)        (14)            (8)      57%         197       260        63       24%             346               227          (119)     (53%)
16 ICT                                          155            173         18           10%       216         240            24        10%         (13)        (18)            (5)      28%         358       395        37        9%             607               682             75       11%
17 External Communications                       74             75          1            1%        18          22             4        18%            0           0              0                   92        97         5        5%             157               154            (3)      (2%)
18 Total Human & Corporate Resources            444            503         59           12%       303         370            67        18%         (19)        (32)           (13)      41%         728       841       113       13%           1,264             1,242           (22)      (2%)
19
20                  Regeneration
21 Planning                                    265            278           13         5%          26         128           102     80%         (247)        (405)        (158)          39%       44         1         (43)   (4300%)            179               180              1        0%
22 Building Control                            137            144            7         5%           5          15            10     67%         (139)        (159)         (20)          13%        3         0          (3)                        58                45          (13)     (29%)
23 Housing                                     278            274          (4)       (1%)          40          60            20     33%         (147)        (128)           19        (15%)      171       206           35      17%             281               335             54       16%
24 Economic Regeneration                       125            120          (5)       (4%)          57          53            (4)    (8%)        (155)        (184)         (29)          16%       27      (11)         (38)     345%             (34)              (27)             7     (26%)
25 Cultural                                    593            573         (20)       (3%)         414         794           380     48%         (405)        (470)         (65)          14%      602       897         295       33%           1,380             1,272          (108)      (8%)
26 Property                                     65             67            2         3%         244         311            67     22%         (213)        (202)           11         (5%)       96       176           80      45%             588               588            (0)      (0%)
27 Parking                                      28             30            2         7%         164         192            28     15%         (684)        (741)         (57)           8%    (492)     (519)         (27)       5%           (974)             (956)             18      (2%)
28 Total Regeneration                        1,491          1,486          (5)       (0%)         950       1,553           603     39%       (1,990)      (2,289)        (299)          13%      451       750         299       40%           1,477             1,437           (40)      (3%)
29
30              Legal & Democratic
31 Legal                                        169            159        (10)       (6%)          19          26             7        27%         (43)        (27)            16      (59%)        145       158        13        8%            245               197              (48)   (24%)
32 Democratic                                    68             89          21       24%          264         282            18         6%         (16)         (1)            15    (1500%)        316       370        54       15%            591               610                19      3%
33 Total Legal & Democratic                     237            248          11         4%         283         308            25         8%         (59)        (28)            31     (111%)        461       528        67       13%            835               807              (28)    (4%)
34
35            Community Development
36 Community Development                        529            539         10           2%        747         823            76        9%       (379)         (537)       (158)         29%         897       825       (72)      (9%)          1,561             1,534             (27)    (2%)
37 Total Community Development                  529            539         10           2%        747         823            76        9%       (379)         (537)       (158)         29%         897       825       (72)      (9%)          1,561             1,534             (27)    (2%)
38
39                  Environmental
40 Bereavement                                 103            106            3         3%         127         150            23      15%        (456)        (443)              13      (3%)    (226)     (187)           39     (21%)          (325)             (307)               18    (6%)
41 Cleansing                                   656            649          (7)       (1%)         417         421             4       1%        (226)        (240)            (14)        6%      847       830         (17)      (2%)          1,337             1,364               27      2%
42 Environmental                               264            271            7         3%          30          19          (11)    (58%)         (51)         (45)               6     (13%)      243       245            2        1%            450               457                7      2%
43 Fleet Management                             73             78            5         6%         361         324          (37)    (11%)         (35)         (35)               0        0%      399       367         (32)      (9%)            624               612             (12)    (2%)
44 Land Charges                                 38             49          11         22%          11          15             4      27%         (79)         (70)               9     (13%)      (30)       (6)          24    (400%)            (10)              (10)             (0)      0%
45 Licenses                                     53             46          (7)      (15%)           2           3             1      33%         (72)         (84)            (12)       14%      (17)      (35)        (18)       51%            (22)              (26)             (4)    14%
46 Parks & Grounds                             299            297          (2)       (1%)          43          60            17      28%         (88)        (100)            (12)       12%      254       257            3        1%            264               320               56    18%
47 Total Environmental                       1,486          1,496          10          1%         991         992             1       0%      (1,007)      (1,017)            (10)        1%    1,470     1,471            1        0%          2,316             2,410               94      4%
48
49              Financial Services
50 Accountancy                                  492            548         56           10%      248          256          8          3%         (58)         (70)            (12)      17%       682       734        52           7%            726               775              49      6%
51 Internal Audit                                 0              0          0                     22           37         15        41%             0            0               0                 22        37        15          41%             52                64              12     19%
52 Revenues & Benefits                          299            312         13           4%    11,293       10,385      (908)        (9%)      (9,227)      (9,126)            101       (1%)    2,365     1,571     (794)        (51%)          (155)             (164)              (9)     5%
53 Fraud                                         49             52          3           6%         3            3          0          0%            0            0               0                 52        55         3           5%             95               101                6     5%
54 Total Financial Services                     840            912         72           8%    11,566       10,681      (885)        (8%)      (9,285)      (9,196)              89      (1%)    3,121     2,397     (724)        (30%)            718               776              58      7%
55
56 TOTAL SERVICES                            5,480          5,703         223           4%    14,887       14,821          (66)     (0%)     (12,739)     (13,099)        (360)            3%   7,628     7,425     (203)         (3%)          9,172             9,275             103        1%
57
     Forecast Outturn against Original
58 Budget (inc cfwds)                        9,581          9,712         131           1%    22,481       22,548            67        0%    (22,890)     (22,985)            (95)         0%                                                   9,172             9,275             103        1%



                                                                                                                                                                                                                                                                         4/14/2010
SUMMARY OF VARIANCES NOT YET VIRED IN TO SYSTEM 13.11.07

Sum of + (saving)/ - (overspend)
Service                            Service Summary                 Total
Accountancy                        Financial Services                 10
ALL AREAS                          (blank)                          131
Building Control                   Regeneration                      -45
Community Development              Community Development             -24
Cultural                           Regeneration                      -69
Democratic                         Legal & Democratic                 14
Planning                           Regeneration                      -51
Property                           Regeneration                      -18
Internal Audit                     Financial Services                 12
General Fund Balance               (blank)                            88
                                   General Fund Balance               13
Parking                            Regeneration                       14
Bereavement                        Environmental                      27
Cleansing                          Environmental                      11
Environmental                      Environmental                      23
Performance & Improvement          Human and Corporate Resources       3
Parks & Grounds                    Environmental                      20
ICT                                Human and Corporate Resources      10
Human Resources                    Human and Corporate Resources      12
Centralised Purchases              Corporate Team                     23
Grand Total                                                         204

virements done:
add procurement                                                      -9    70009962
add vmp savings taken                                               -28    70009963
add si reserve                                                       -5    70009959
total as per forecast sheet                                         162




                                                                                 4/14/2010
Sum of + (saving)/ - (overspend)
E/I/S                            Total
E                                   67
I                                  -95
O                                 101
S                                 131
Grand Total                       204




                                         188c3272-b898-4e7e-9901-401faf6e6f14.xls
Variances Reported to end of October 2007

Cost Centre                                                     Service
                                            + (saving)/ - (overspend)                    Service Summary         Comment                   E/I/S
Leisure Complex Income                                        6 Cultural                 Regeneration            Previously Reported       I
Elections income 2005/06                                    15 Democratic                Legal & Democratic      Previously Reported       I
Insurance Renewal contract                                   -5 Accountancy              Financial Services      Previously Reported       E
PIP cancellation                                             -2 Cultural                 Regeneration            Previously Reported       E
Concessionary Fares                                        -50 Community Development Community Development Previously Reported             E
Vacancy Management                                        190 ALL AREAS                                          Previously Reported       S
Investment Income                                           32 Accountancy               Financial Services      Previously Reported       I
Parking Income                                             -68 Property                  Regeneration            Previously Reported       I
Guildhall delayed opening                                  -48 Cultural                  Regeneration            Previously Reported       E
PRSA                                                       -44 Cultural                  Regeneration            Previously Reported       E
Planning Income                                            -86 Planning                  Regeneration            Previously Reported       I
Building Control Income                                    -50 Building Control          Regeneration            Previously Reported       I
Internal Audit                                              12 Internal Audit            Financial Services      Part A - Action Plan P6   E
Drainage Board Precepts                                     10 General Fund Balance      General Fund Balance    Part A - Action Plan P6   O
Creations - gym equipment lease                             13 Cultural                  Regeneration            Part A - Action Plan P6   E
Member Allowances                                             6 Democratic               Legal & Democratic      Part A - Action Plan P6   E
Business Rates                                              14 Parking                   Regeneration            Part A - Action Plan P6   E
Core Grants                                                   7 Community Development Community Development Part A - Action Plan P6        E
Parish cemeteries                                             5 Bereavement              Environmental           Part A - Action Plan P6   E
Operations - sweeper                                        11 Cleansing                 Environmental           Part A - Action Plan P6   E
Smoke free legislation                                      17 Environmental             Environmental           Part A - Action Plan P6   E
Tourism development                                           6 Cultural                 Regeneration            Part A - Action Plan P6   E
Professional subs                                                                                                Part A
                                                              3 Performance & ImprovementHuman and Corporate Resources - Action Plan P6    E
Tree safety inspections                                     10 Parks & Grounds           Environmental           Part B - Action Plan P6   E
R&M                                                         50 Property                  Regeneration            Part B - Action Plan P6   E
Personal Grants                                               1 Community Development Community Development Part B - Action Plan P6        E
Safeguard children grant                                      2 Community Development Community Development Part B - Action Plan P6        E
Memorial inspections                                        12 Bereavement               Environmental           Part B - Action Plan P6   E
Flare training                                                1 Environmental            Environmental           Part B - Action Plan P6   E
Building control                                              5 Building Control         Regeneration            Part B - Action Plan P6   E
Capital financing                                           88 General Fund Balance                              Part C - Action Plan P6   O
PRSA Income - to Finance                                    (2) Accountancy              Financial Services      Period 7 monitoring       I
Development Control                                         (4) Planning                 Regeneration            Period 7 monitoring       E
Grounds Maintenance                                        10 Parks & Grounds            Environmental           Period 7 monitoring       I
Fixed Penalty Fines                                          2 Environmental             Environmental           Period 7 monitoring       I
CCTV Income                                                11 Community Development Community Development Period 7 monitoring              I
Customer Services                                            5 Community Development Community Development Period 7 monitoring             E
Development Control                                          4 Planning                  Regeneration            Period 7 monitoring       E
Bereavement services                                       10 Bereavement                Environmental           Period 7 monitoring       E
LGA Conference                                              (2) Democratic               Legal & Democratic      Period 7 monitoring       E
Shared services contribution                                (5) Democratic               Legal & Democratic      Period 7 monitoring       E
TIC relocation                                            (65) ALL AREAS                                         Period 7 monitoring       S
Disposal of cemetery lodges                                  3 General Fund Balance      General Fund Balance    Period 7 monitoring       O
Internal Communications                                    10 ICT                                                Period
                                                                                         Human and Corporate Resources 7 monitoring        E
LA21                                                         3 Environmental             Environmental           Period 7 monitoring       E
Central Training and Conferences                           12 Human Resources                                    Period
                                                                                         Human and Corporate Resources 7 monitoring        E
Centralised purchasing underspends                         23 Centralised Purchases      Corporate Team          Period 7 monitoring       E
Procurement Savings                                       (14) Accountancy               Financial Services      Period 7 monitoring       E
Community Safety Review                                   (41) ALL AREAS                                         Period 7 monitoring       S
Establishment Savings                                      27 ALL AREAS                                          Period 7 monitoring       S
Je provision                                               20 ALL AREAS                                          Period 7 monitoring       S
Procurement Shared Services Contribution                    (1) Accountancy              Financial Services      Period 7 monitoring       E
Planning delivery Grant                                    35 Planning                   Regeneration            Period 7 monitoring       I
TOTAL ADJUSTMENT TO BASE BUDGET                           204


                                                                                                188c3272-b898-4e7e-9901-401faf6e6f14.xls

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:39
posted:4/14/2010
language:English
pages:5