The URL can be used to link to this page

Home My WebLink AboutItem 4.04 Financial Report February 2006 CITY CLERK File # D~.[5][O AGENDA STATEMENT CITY COUNCIL MEETING DATE: April 4, 2006 SUBJECT Financial Reports for the Month of February 2006 Report Prepared by' Paul S. Rankin. Administrative Services Director and Fred Marsh, Finance Manager RECOMMENDATION ~ FINANCIAL STATEMENT I YTD Revenues and Budget Comparison 2. YTD Expenses and Budget Comparison 3 Financial Statements for February 2006 ~ve the reports. ATTACHMENTS See reports for detail of monthly financial activity DESCRIPTION This item provides the report on the preliminary financial statements for the month of February 2006. Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion ofthe City's operations. Analvsis of Februarv 2006 Revenue and Expenditure Reports The February reports represent the reporting of revenues and expenditures for eight months of the Fiscal Year, through February 28,2006. It should also be noted that there is not an even distribution of revenues and expenditures on a monthly basis. There is also a lag with the reporting of expenditures due to the significant amount of services provided to the City by independent contractors, including Police and Fire Services. General Fund Revenues Total General Fund Revenues collected through February are less than what occurred in the eighth month of the previous Fiscal Year Through February 2006, the City had collected approximately 57% of the total budgeted General Fund Revenues, which was I % less than the percentage collected in the prior Fiscal Year A brief description is provided below to explain any material revenue variations. Licenses and Permits, as a percent of the budget, are higher than in the prior year However, the actual revenue dollars are lower than in the same period of the prior year due to lower permits pulled for residential projects. This was accounted for with the original budget. Fiscal Year 2005-2006 revenue for Building Permits are expected to exceed the budget. Interest and Rentals received to date are higher than the prior year due to a higher than expected return on the City's investments and timing differences in the receipt of interest earnings on the City's securities. Initially all interest revenue is recorded in the General Fund and is then allocated quarterly to other funds on a pro rata basis. There are also required entries based on market value that are expected to reduce reported interest income. ------------------------------------------------------------------------------------------------------------- Document in FSCOLOR 02-2006.XLS ITEM NO. \1-. Lt COPIES TO: Page I of2 Intergovernmental revenue is higher than in the prior year due to an early repayment by the State of the Vehicle License Fee (VLF) Loan from Fiscal Year 2003-2004 At the time the Fiscal Year 2005-2006 City budget was approved, there was no indication that the VLF loan would be repaid ahead of schedule; therefore, no revenue was budgeted for this event. However, with the adoption of the State Budget, cities were advised that the VLF Gap Loan would be repaid early Charges for Services are higher than in the same period of the previous year due to additional zoning and subdivision fees received due to new development. Other Revenues are lower than in the same period of the prior year due to a one time payment received in the prior year for ongoing maintenance of storm drains and timing differences in the receipt of reimbursements from the City of Pleasanton for the design of improvements to the Fallon Road/I-580 freeway interchange. General Fund Expenditures Overall, through the month of February, expenditures in the General Fund totaled about $21.2 million and represented approximately 44% of the total budgeted expenditures in the General Fund. Ofthis amount, a total of approximately $1,576,000 was related to Capital Improvement Projects and the remainder was related to Operating Costs reported in the General Fund. Capital Project expenditures typically do not follow an even distribution due to differences in project timing. In looking only at General Fund Operating Expenditures, the activity through February 2006 was similar to the amounts expended for the same period in the prior Fiscal Year Through the end of February 2006, the City had expended 46% of the General Fund Operating Budget, which was 2% less than the amount expended in the prior Fiscal Year. Police is lower than in the same period of the prior year due to timing differences in the payment of contract police services. Fire is higher than in the same period of the prior year due to timing differences in the payment of contract fire services. Other Public Safety is higher than in the same period of the prior year due to timing differences in the payment of contract animal services. Community Development is lower than in the same period of the prior year due to temporary staffing vacancies in the planning division. Capital Improvement Projects are lower than in the same period of the prior year Several of the capital projects funded by the General Fund in Fiscal Year 2005-2006 will either not incur major expenditures until later in the Fiscal Year and/or will be carried over to Fiscal Year 2006-2007, including the CTV Studio Remodel, Building Permit System, Fire Station 16 Repairs, design for the reconstruction of the Shannon Center, and Utilities Undergrounding on Dougherty Road. All expenditures are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. Page 2 of2 {ofl~ City of Dublin 2005-2006 YTD Revenues and Budget Comparison .FQrJl1e.PerimLE!!Jli!!g.F~l>nlary.28.,...200.6......... 7% 8% Total General Fund Revenues Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Reveuues '. FY 2005/06! FY 2004/~ 69% 0% 90% 150% 120% 30% 60% 67% of Year Complete FY 2005/06 FY 2005/06 %of FY 2004/05 % of Total for Budget YTD Actual Budget YTD Actual FY 2004/05 Property Taxes 15,716,461 8,323,139 53% 7,515,739 53% Sales Taxes 14,984,884 8,599,990 57% 8,495,435 60% Real Property Transfer Tax 745,600 396,786 53% 430,143 52% Transient Occupancy Taxes 680,500 390,558 57% 371,936 56% Franchise Taxes 1,626,300 655,097 40% 622,048 40% Licenses and Permits 2,380,013 2,211,354 93% 2,818.959 80% Interest and Rentals 1,898,725 1,012,258 53% 791,567 46% Intergovernmental 498,650 759,222 152% 362,638 64% Charges for Services 5,256.561 3,279.764 62% 3,182,339 57% Fines and Forfeitures 132,200 81,827 62% 92,134 64% Other Revenues 1,815,830 353,447 19% 541,367 69% Total General Fund Revenues 45,735,724 26,063,442 57% 25,224,305 58% 'f.Lf 'tlo'l/Ob Dale Pr,nled. 3115120062.43 PM ATTACHMENT 1 20f 13 City of Dublin 2005-2006 YTn Expenses and Budget Comparison For the Period Ending February 28, 2006 Total General Fund Expenses General Government Police Other Puhlic Safety Transportation Health and Welfare Culture & Community Services I i i I L Commnnity Developmeut Capital Improv. Projects Fire 100% 100% r 45% 51% . FY 2005/06 III FY 2004/05 I ....51% 0% 100% 120% 20% 40% 60% 80% 67% of Year Complete 2005/06 2005/06 %of FY 2004/05 % of Total for Budget YTD Actual Budget YTD Actual FY 2004/05 General Government 5,532,335 3,101,283 56% 2,776,427 57% Police 11,360,037 2,732,112 24% 4,449,480 45% Fire 8,890,188 4,506,726 51% 2,333,461 28% Other Public Safety 383,869 129,661 34% 90,486 25% Transportation 1,824,115 954,608 52% 910,012 55% Health and Welfare 15,000 15,000 100% 78,676 100% Culture and Community Services 6,363,138 3,491,842 55% 3,152,091 59% Community Development 8,449,412 4,682,215 55% 4,454,091 60% Capital Improvement Projects 5,342,794 1,576,122 29% 2,381,905 51% Total General Fund Expenses 48,160,888 21,189,569 44% 20,626,629 49% General Fund Operating Expenses 42,818,094 19,613,447 46% 18,244,724 48% 0I1ol Printed. 31'5I2OO62.2:.lPM ATTACHMENT 2 30f /3 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF FEBRUARY 2006 Prepared by The Finance Department March 15, 2006 ATTACHMENT 3 4d /3 CITY OF DUBLI N BALANCE SHEET FOR THE PERIOD ENDING 28Feb2006 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM DNLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIDR ASSETS CASH (51 787 194) 3 233 424 573 684 37 695 44D 85 191 00 199,454) (29 004 071) CASH WITH FISCAL AGENT 179 460 179 460 172 779 AMOUNT HELO IN ESCROW 4 177 500 4 177 ,500 INVESTMENTS AT COST 105,447 689 105 447 689 103 466 248 RECEIVABLES TAXES ACCOUNTS 127 768 363 597 491 364 180 651 INTEREST ASSESSMENTS DUE FROM OTHERS 2,206 558 2.206 558 1. 829,213 INVENTORY AT COST PREPAID ITEMS 4 103 4 103 8,424 FIXED ASSETS LOANS RECEIVABLE 4.596 534 4 596 534 AMOUNT TO BE PROVIDEO 1. 213 500 1 213 500 1 334 500 TOTAL ASSETS 55 99B 924 3 597 021 573 684 46 469 474 1 478 152 108,117,255 77 987 743 LIABILITIES/FUND EOUITY DEPOSITS FOR PRIVATE DEVEL (747,953) (747,953) o 183,745) DEPOSITS FOR AB1600 FEES (832,185) (832,185) (387 954) DEPOSITS OTHERS (2,214 590) (2 214 590) (2 571 om PAYABLES ACCOUNTS (65B 063) (2 467) (660 529) (234 490) INTEREST PAYROLL (619 051) (619 051) (541 925) DUE TO OTHE RS (135,477) (5 270) (2 201.289) (2 342 035) (111 561) DEFERRED REVENUE (127 768) (127 768) 027 768) DEBT INSTRUMENTS PAYABLE o 331. 000) o 331 000) (1 452 000) TOTAL LIABILITIES (5 335,086) (5 270) (2 203 756) o 331 000) (8 875 111) (6,610 515) FUND BALANCES (50 663 838) (3,591 751) (573 6B4) (44,265,718) 047 152) (99,242 144) (71,377 ,228) TOTAL FUND E (50 663,838) (3 591 751) (573 6B4) (44 265 718) 047 152) (99,242,144) (71,377,228) TOTAL LIABILITIES/EQUITY (55 9g8 924) (3,597 021) (573,6B4) (46 469 474) (1 478 152)(IQB 117,255) (77 987 743) 5 ot- e) C lTY OF DUBLI N BALANCE SHEET FOR THE PERIOD ENDING 28Feb2006 INTERNAL ENTERPRI SE FIXED ASSETS GENERAL LONG TOT A L S SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PR lOR ASSETS CASH 9 825 600 9 825 600 8 537,297 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PRE PAlO ITEMS F I X ED ASSETS 50 002 851 333 664 335 383 667 186 85 720 159 LOANS RECEIVABLE AMOUNT TO BE PROVIOEO 63 728 304 63 728 304 66,753 945 TOTAL ASSETS 59 828,451 333 664 335 63 728 304 457,221.090 161. 011 400 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (63 728 304) (63 728 304) (66 753 945) TOTAL LIABILITIES (63 728 304) (63,72B,304) (66 753 945) FUND BALANCES (59 828 451) (333 664 335) (393,492,786) (94,257,455) TOTAL FUND E (59,828,451) (333 664 335) (393 492 786) (94,257,455) TOTAL LIABILITIES/EQUITY (59 828 451) (333 664 335) (63 728,304) (457 221 090)(161 011 400) 10 of 13 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 02/28/2006 G ENE R A L REVENUE FUN D CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y T D VARIANCE *******REVENUES******* PROPERTY TAXES 15 716,461 00 8323,13910 7,393,32190 14,054 547 16 7 515 739 07 6 538 808 09 SALES TAX 14 984 884 00 8 599 989 54 6 384 894 46 14 152,987 24 8 495 434 84 5 657 552 40 REAL PROPERTY TRANSFER TAX 745 600 00 396 786 14 348 813 86 831.003 24 430 142 83 400 860 41 HOTEL TRANSIENT OCCUPANCY TAX 680 500 00 390 557 75 289 942 25 663 631 67 371 936 15 291. 695 52 FRANCHISE TAXES 1 626 300 00 655 096 95 971.203 05 1 559,900 22 622 047 92 937 852 30 LICENSES & PERMITS 2 380 013 00 2,211 354.25 168 658 75 3,520 140 84 2,818 958 92 701.181 92 FINES & FORFEITURES 132,200 00 81 827 09 50.372 91 143 316 33 92 134.29 51.182 04 USE/MONEY & PROP~INTEREST 1 757 524 00 961 378 68 796 145 32 1 608,96640 729 364 34 879 602 06 USE/MONEY & PROP~RENTALS 141.201 00 50 879 61 90 321 39 125,835 40 62,202 68 63 632 72 INTERGOVERNMENTAL 498 650 00 759 222 04 (260.572 04) 568 598 34 362 638.37 205,959 97 CHARGES FOR SERVICES 5,256 561 00 3,279 763 93 1 976 797 07 5.548 124 34 3,182 339 05 2,365 .785 29 OTHER SOURCES OF REVENUE 1 815 830 00 353 447 14 1 462 382 86 783 873 45 541. 366 82 242 506 63 TOTAL REVENUE 45 735 724 00 26 063 442.22 19672,281 78 43 560 924 63 25,224 305 28 18,336,619 35 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES CITY COUNCIL 300 704 00 178 392 51 122 311 49 224 070 48 132,008 55 92 061 93 CITY MANAGER 997 923 00 599 719 69 398,203 31 919 976 69 585,554 83 334 421 86 CENTRAL SERVICES 538,556 00 292 424 94 246 131 06 362 244 59 230 060 38 132 184 21 CITY ATTORNEY 824,252.00 331 685 91 492,566 09 631 963 18 363 748 64 268,214 54 ADMIN SERVICES 1 648 603 00 990 905 97 657,697 03 1 433 876 94 876 927 89 556 949 05 8UILDING MANAGEMENT 734 657 00 405 713 15 328 943 85 668 646.21 369,560 56 299,085 65 INSURANCE COST CENTER 397 038.00 294 852.37 102,18563 508,448 41 205 547 98 302.900 43 ELECTIONS COST CENTER 2 890 00 2 112 00 778 00 12,265.33 12,265 33 NON-DEPARTMENTAL 87 712 00 5 476 69 82 235 31 68 155 13 753 06 67,402 07 ACT! V ITY TOTAL 5 532 335 00 3 101.283 23 2 431 051 77 4 829 646 96 2776427.22 2,053 219 74 PU8L1C SAFETY POll CE 11.360 037 00 2 732 112 22 8 627 924 78 9 837 842 27 4 449 479 70 5 388,362 57 CROSSING GUAROS 82,140 00 35,867 80 46 272 20 71 407 04 33 157 18 38,249 86 ANIMAL CONTROL 208 898 00 53 428 29 155 469 71 208,369 91 19 242 00 189 127 91 TRAFFIC SIGNALS & STREET LIGHTIN 18 110 00 8 083 48 10 026 52 8 587 87 4 130 29 4,457 58 DISASTER PREPAREDNESS 74 721 00 32.281 74 42 439.26 68 023 15 33 956 26 34 066 89 FIRE SERVICES 8,890 188 00 4 506 726 27 4,383 461 73 8 207 944 38 2 333 461 03 5.874 483 35 ACTI V!TY TOTAL 20 634 094 00 7 368 499 80 13,265 594.20 18 402,174 62 6 873 426 46 11 528 748 16 TRANSPORTATION PU8L1 C WORKS 808 577 00 476,384 36 332,192 64 723 562 41 445,202 72 278 359 69 STREET MAINTENANCE 30 314 00 30 314 00 15 908 28 24,867 89 (8 959 61) STREET SWEEPING 150 670 00 73,71356 76 956 44 140 783 85 58 723 13 82 060 72 STREET TREE MAINTENANCE 99 430 00 30 392 86 69 037 14 99 195 45 18,588 63 80 606 82 STREET LANDSCAPING MAINTENAN 735 124 00 374 116 83 361 037 17 682 756 30 362 629 74 320 126 56 ACTI V!TY TOTAL 1 824 115 00 954,607 61 869 507.39 1 662 206.29 910 012 11 752 194 18 HEALTH & WELFARE WASTE MANAGEMENT 71.474 64 63,499 22 7 975 42 CHILD CARE 15 000 00 15,000 00 15 000 00 15 000 00 SOCIAL SERVICES HOUSING PROGRAMS 176 89 (176 89) ? of 13 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 02/28/2006 GENERAL REV E N U E FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y T 0 VARIANCE ACT! V ITY TOTAL 15 000 00 15 ODD DO 86 474 64 78 676 11 7 798 53 CULTURE & LEISURE SERVICES LIBRARY SERVICES 617 771 00 322 373 81 295 397 19 577 734 07 285 321 61 292 412 46 CULTURAL ACTIVITIES 204 701 00 162 654 60 42 046 40 125 102 04 70 432 72 54,669 32 HERITAGE CENTER 163 333 00 95 437 16 67 895 B4 125 641 44 77 031 36 48 610 08 DUBLIN CEMETERY 49,95B 00 14,153 63 35,804 37 40 573 15 19 B7B.52 20 694 63 PARK MAINTENANCE I 712 065 00 BOO 788 71 911 276.29 I 450 064 58 774 011 34 676 053.24 COMMUNITY TV 66 407 00 60 125.58 6,281 42 61 809 00 57 349 00 4 460 00 RE CREATION ADM I N 708 174 00 423 130 68 285 043.32 608,760 76 377 603 40 231 157 36 PLAYGROUNDS 275 357 00 14B 425 71 126 931. 29 247 214.27 161 090 05 86 124.22 SHANNON CENTER 342 706 00 204 765 23 137 940 77 301 071 12 229,126 97 71 944 15 PRESCHOOL 105 458 00 67 000 13 38 457 87 82 639 86 53 081 75 29 558 11 TE E NS PROGRAM 159 835 00 85 026 77 74,808.23 87 306 66 53,053 50 34,253 16 ADULT SPORTS 109.230 00 49 120 29 60 109 71 92 694 01 57,272 44 35 421. 57 YOUTH SPORTS 153 617 00 95 984 82 57 632 18 118 533 39 70 143 80 48 389 59 COMMUN ITY GYM 43 459 00 22 339 96 21 119 04 42 887 87 24 522 92 18,364 95 EMERALO GLEN ACTIVITY CENTER SPECIAL EVENTS 364 601 00 231.219 05 133 381 95 331 898 19 186 172 48 145 725 71 SEN lOR CENTER 365 728 00 257 373 79 108 354.21 253 121 20 154 089 59 99 031 61 RECREATION INSTRUCTION 183 023 00 101 488 78 81 534.22 174 492 75 116 628 32 57 864 43 AOUATICS 429,221 00 231 327 73 197 893.27 393 660 59 217 987 67 175 672 92 PARKS/FACILITIES MANAGEMENT 308 494 00 119 105 95 189 3B8 05 261 928 57 167 294 03 94,634 54 ACTIVITY TOTAL 6 363 138 00 3 491 842.3B 2 871 295 62 5,377,13352 3,15209147 2,225,042.05 COMMUNITY DEVELOPMENT PLANNING 2 685 164 00 I 404,329 92 I 280 834 08 2 414 972 53 I. 549 883 13 B65 089 40 BUILDING SAFETY 3 214 615 00 I. 665,133 93 1 549 481 07 2,399,434 25 I 318 430 85 I 081 003 40 ENGINEERING 2 194 005 00 I 386 019 67 807 985 33 2.304 691 55 I 369,877 74 934 813.81 ECONOMIC DEVELOPMENT 355 628 00 226 731 56 128 896 44 272,379 63 215 899 23 56 480 40 ACT! V ITY TOTAL 8 449,412 00 4 682 215 08 3767,196 92 7 391 477 96 4 454 090 95 2 937 387 01 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS I 350 856 00 127 740 20 I 223 115 80 633 849 26 33B 170 49 295 678 77 COMMUNITY IMPROVEMENTS 874 999 00 630 138 13 244.860 87 403 110 09 24 145 68 378 964 41 PARKS I 628 920 00 657 720 40 971 199 60 2,630 020 7B I 741 181 72 888 839 06 STREET CONSTRC/IMPROVEMENTS I 488 019 00 160 523 32 I 327 495 68 980 260 11 278,407 23 701. 852.88 ACTI V ITY TOTAL 5,342 794 00 1.576 122 05 3 766 671 95 4 647 240.24 2 381 905 12 2 265 335 12 TOTAL EXPENDITURES 48 160 888 00 21 189 570 15 26 971 317 85 42 396 354.23 20,626,629 44 21 769 724 79 EXCESS REVENUE (EXPENDITURES) (2 425 164 DO) 4 873 872 07 (7,299 036 07) I 164 570 40 4 597 675 84 (3 433 105 44) TRANSFERS IN FROM OTHER FUNDS 475 053 00 475 053 00 27 230 91 27,230 91 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (] 950 III 00) 4,873 872 07 (6 823,983 07) I 191 801 31 4 597 675 84 (3 405 874 53) "ZoF13 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 02/28/2006 S P E C I A L REV E N U E FUN 0 S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y T 0 VARIANCE ********REVENUES******** PROPERTY TAXES 117 680 00 58,866 64 58 813.36 1I2 532 03 56 837 59 55.694 44 SALES TAX/OTHER TAXES 360 500 00 196 626 79 163 873.21 364 477 71 148 194 67 216.283 04 FINES & FORFEITURES 156 000 00 88,679 15 67 320 85 149 341 93 52 016 18 97,325 75 USES/MONEY & PROPERTY 99 757 00 46 829 50 52,927.50 102,932 29 30 778 45 72 153 84 INTERGOVERNMENTAL FROM STATE 1 014,231 00 643 833 30 370 397 70 2 354,339 65 1 737 230.52 617 109 13 INTERGOVERNMENTAL FROM COUNTY 340,440 00 79 255 00 261 185 00 332 344 00 72 652 00 259 692 00 INTERGOVERNMENTAL FROM FEDERAL 76 792 00 51. 833 41 24 958.59 56 796 80 20 560 80 36,236 00 CHARGES FOR SERVICES 1. 350,461 00 670 163 35 680 297 65 1 075 178 65 543 712.28 531 466 37 OTHER SOURCES OF REVENUE 409 500 00 390 000 00 19 500 00 170,482 39 5 347 65 165 134 74 TOTAL REVENUE 3 925 361 00 2,226,08714 1.699,273.86 4 718 425 45 2 667 330 14 2 051. 095 31 *******EXPENDITURES******* PUBLI C SAFETY POLICE 120,255 00 101 033 88 19,221 12 105 952.40 104 007 80 1 944 60 TRAFFIC SIGNALS & STREET LTG 234 700 00 143 577.25 91 122 75 173,175 14 88,555 48 84 619 66 DISASTER PREPAREDNESS FIRE SERVICES 270 120 00 134 976.23 135 143 77 251 091 21 28 391. 24 222,699 97 ACTIVITY TOTAL 625 075 00 379,587 36 245 487 64 530,21B 75 220 954 52 309 264.23 TRANSPORTATION STREET MAINTENANCE 330 474 00 133 099 62 197 374 38 272 390 25 98 917 14 173 473 1I STREET SWEEPING ACTI V!TV TOTAL 330 474 00 133 099 62 197 374 38 272,390 25 98 917 14 173 473 1I HEALTH & WELFARE WASTE MANAGEMENT 1 874,90600 1.128195.29 746 710 71 1 383 964 16 25 652 19 1. 358 31I 97 SOCIAL SERVICES 60 427 00 36 091. 23 24.335 77 44 927 00 30 681 97 14 245 03 HOUSING PROGRAMS ACTI V ITY TOTAL 1 935 333 00 1.164,286 52 771 046 48 1 428 891 16 56 334 16 1 372 557 00 COMMUNITY DEVELOPMENT ENGINEERING 6 000 00 6 000 00 6 000 00 6 000 00 ACTI V ITY TOTAL 6 000 00 6 000 00 6 000 00 6 000 00 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS COMMUNITY PROJECTS 39 556 00 29 791 00 9 765 00 14 850 00 14 850 00 PARKS 31 310 00 31 310 00 321 717 00 174 760 00 146 957 00 STREET CONSTRUCTION/IMPROVEMENT 1 670 803 00 525 449 32 1 145 353 68 149 554 78 73,071 25 76,483 53 ACTI V ITY TOTAL 1 741 669 00 555 240 32 1 186 428.68 486 121 78 247 831 25 238.290 53 TOT A L EXPENDITURES 4 644 1I5 00 2 243 037 78 2 401 077 22 2,723621 94 630 037 07 2 093 584 87 EXCESS REVENUE (EXPENDITURES) (718 754 00) (16 950 64) (701 803 36) 1 994 803 51 2,037 293 07 (42,489 56) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 88.737 00 6 600 00 82 137 00 1.336.274 58 1 336,274 58 REVENUES OVER (UNDER) EXPENDITURES (807,491 00) (23 550 64) (783 940 36) 658 528 93 2 037 293 07 (1 378 764 14) q 0(;3 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 02/28/2006 S P E C I A LAS S E SSM E N T FUN 0 S CURRENT BUDGET CURRENT ACTUAL VARIANCE PR lOR FISCAL YEAR PRIOR Y LO VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 664 610 00 324 983 90 339 626 10 744 099 49 438 340 98 305 758 51 USES/MONEY & PROP~INTEREST 15,478 00 6 615 42 8,862 58 14 748 10 3.767 17 10,980 93 OTHER SOURCES OF REVENUE 5 000 00 2 578 84 2 421 16 TOTAL REVENUE 685,DB8 DO 334 178 16 350 909 84 758.847 59 442,108 15 316 739 44 *******EXPENDITURES******* PUBLIC SAFETY TRAFFIC SIGNALS & STREET LIG 278 600 00 132 48B.84 146,111 16 231.533 62 120 357 08 III 176 54 ACTI V!TY TOTAL 278,600 00 132,48B 84 146 III 16 231 533 62 120 357 08 111.176 54 TRANSPORT A TI ON PUBLI C WORKS 2 415 00 I 241 94 1.173 06 1. 591 29 977 .81 613 48 STREET TREE MAINTENANCE 34,231 00 7 267 67 26 963 33 18 466 76 7,119 15 11.347 61 STREET LANDSCAPE MAINTENANCE 356 039 00 178 228 83 177 810 17 317 657 53 165 381 45 152 276 08 ACTI V!TY TOTAL 392,685 00 186 738 44 205 946 56 337 715 58 173 478 41 164 237 17 COMMUNITY DEVELOPMENT ENGINEERING 13 100 00 11 357 60 1. 742 40 7 139 94 6,669 94 470 00 ACTIVITY TOTAL 13,100 00 11 357 60 1 742 40 7 139 94 6 669 94 470 00 CAPITAL IMPROVEMENT PROJECTS COMMUNITY IMPROVEMENTS 32 920 00 18 106 69 14,813 31 STREET CONSTRUCTION/IMPRVMNT 75 000 00 75,000 00 ACTI V!TY TOTAL 107 920 00 18 106 69 89 813 31 TOT A L EXPENDITURES 792 305 00 348 691 57 443 613 43 576 389 14 300 505 43 275 883 71 EXCESS REVENUE (EXPENDITURES) 007 217 00) 04.51341) (92 703 59) 182 458 45 141 602 72 40.855 73 REVENUES OVER (UNDER) EXPENDITURES 007,217 00) 04 513 41) (92 703 59) 182 458 45 141 602 72 40 855 73 /Oof (3 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/D1/2D05 THROUGH 02/28/2006 CAP I TAL IMP R 0 V E MEN T FUN 0 S CURRENT 8UDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y T D VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 865 623 00 19 267 625 00 20,192 732 00 500 561 48 10 209 502 43 10 716 663 91 365 061 52 9 058 122 57 9 476 068 09 1.221 970.50 14,361 927 97 16 892 942 14 382,033 41 10,787,236.24 11 169.269 65 839 937 09 3,574 691 73 5 723 672 49 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES CITY ATTORNEY 38 950 00 26 645 49 12,304 51 35.736 39 2 164 00 33 572 39 ACT! V ITY TOTAL 38 950 00 26 645 49 12 304 51 35 736 39 2,164 00 33,572 39 PU8L! C SAFETY TRANS PORTA T! ON HEALTH & WELFARE HOUSING PROGRAMS 903,030 00 182,177 53 720 852 47 219 420 35 116 344 11 103 076 24 CULTURE & LEISURE SERVICES RECREATION ADMINISTRATION ACT! V ITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACT! V ITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 83 600 00 9 360 49 74.239 51 624,943.39 143 982 52 480 960 87 COMMUNITY IMPROVEMENTS 36 771 00 36,771 00 PARKS 11 322 835 00 3 453 763 91 7 869 071 09 6.285 687 19 307 667 43 5,978 019 76 STREET CONSTRUCTION/IMPROVEMENT 36 340,142 00 1.321 679.35 35 018,462 65 3 309 862 62 2 378 808 89 931 053 73 ACT! V ITY TOTAL 47 746 577 00 4,784 803 75 42 961 773 25 10,257 264.20 2 830 458 84 7 426 805 36 TOT A L EXPENOITURES 48 688 557 00 4,993,626 77 43 694,930 23 10,571 890 78 2 948 966 95 7 622 923 83 EXCESS REVENUE (EXPENDITURES) (28 555 309 00) 5 716 437 14 (34 271 746 14) 5,012 007 69 8 220.302 70 (3 208,295 0]) TRANSFER IN FROM OTHER FUNOS (59 484 00) (6 bOO 00) (52 884 00) (1 309 043 67) (1. 309 043 67) TRANSFERS OUT TO OTHER FUN OS 445,800 00 445 800 00 REVENUES OVER (UNDER) EXPENDITURES(28,941 625 00) 5 723 037 14 (34 664 662 14) 6,321 051 36 8 220 302 70 (1 899 251 341 Ilor/3 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 02/28/2006 T R U S T / AGE N C Y FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y T.D VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 117 292 54 (117 292 54) 228.280 46 116 965 04 111 315 42 USES/MONEY & PROP-INTEREST 4 513 53 (4 513 53) 5 612 63 386 19 5,226 44 TOTAL REVENUE 121 806 07 (121 806 07) 233 893 09 117 351.23 116 541 86 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 231 038 00 229 862.50 1 175.50 232,571 18 230 796 18 1 775 00 ACTIVITY TOTAL 231 038 00 229 862.50 1 175 50 232,571 18 230 796 18 1 775 00 PUBLI C SAFETY TRANSPORTATION HEALTH & WELFARE CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 231. 038 00 229 B62 50 1 175 50 232 571 18 230 796 18 1 775 00 EXCESS REVENUE (EXPENDITURES) (231 038 00) (108 056 43) 022 981 57) 1. 321 91 (113 444 95) 114 766 86 REVENUES OVER (UNDER; EXPENDITURES (231 038 00) (108,056 43) (122 981 57) 1 321 91 (113 444 95) 114 766 86 / 'J, of 13 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 02/28/2006 I N T ERN A L SERVICE FUN 0 S CURRENT CURRENT PR lOR PRIOR BUOGET ACTUAL VARIANCE F1SCAL YEAR Y T 0 VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 297 089 DO 113 324 31 183 764 69 245 407 37 79 081 16 166 326 21 CHARGES FOR SERVICES 1 796 096 DO 1 191 038 62 605,057 38 1 642 441.30 1 133 768 39 508 672 91 OTHER SOURCES OF REVENUE 23 400 DO 14 525 DO 8 875 DO 4,841 986 98 5,862.19 4 836 124 79 TOTAL REVENUE 2 116 585 DO 1.318 887 93 797 697 07 6 729 835 65 1.218 711 74 5 511 123 91 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2 092 680 00 406 960.53 1. 685 719 47 2 467 397 02 898 537 43 1.568,859 59 ACTIVITY TOTAL 2 092,680 00 406 960 53 1 685 719 47 2 467,397 02 898 537 43 1. 568 859 59 PUBLI C SAFETY FIRE 65 561 00 15 089.26 50 471 74 59 862 86 59 862 86 ACTI V!TY TOTAL 65 561 DO 15 089.26 50 471 74 59 862 86 59 862 86 TRANSPORTATION HEALTH & WELFARE CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 2 158 241 DO 422 049 79 1 736 191.21 2 527 259 88 898,537 43 1 628 722 45 EXCESS REVENUE (EXPENDITURES) (41 656 DO) 896 838 14 (938 494 14) 4 202,575 77 320 174 31 3 882 401 46 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (41 656 DO) 896 838 14 (938,494 14) 4 202,575 77 320 174 31 3 882 401 46 ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL FI NANCE ACT! V !TY TOTAL PUBLIC SAFETY HEALTH & WELFARE CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES CURRENT BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 02/2B/2006 E N T E R P R I S E FUN 0 CURRENT ACTUAL PRIOR FISCAL YEAR VARIANCE PRIOR Y T 0 13o~f3 VARIANCE