Loading...
HomeMy WebLinkAboutItem 4.05 Financial Report for January 2006 CITY CLERK File # D0~[~H9[Q AGENDA STATEMENT CITY COUNCIL MEETING DATE: March 21, 2006 SUBJECT Financial Reports for the Month of January 2006 Report Prepared by- Paul S. Rankin, Administrative Services Director and Fred Marsh, Finance Manager ATTACHMENTS 1 2. 3 YTD Revenues and Budget Comparison YTD Expenses and Budget Comparison Financial Statements for January 2006 RECOMMENDATION Receive the reports. FINANCIAL STATEMENT See reports for detail of montWy financial activity DESCRIPTION This item provides the report on the preliminary financial statements for the month of January 2006 Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Analvsis of January 2006 Revenue and Expenditure Reports The January reports represent the reporting ofrevenues and expenditures for seven months of the Fiscal Year, through January 31, 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 January are less than what occurred in the seventh month of the previous Fiscal Year. Through January 2006, the City had collected approximately 52% ofthe 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. Franchise Fees are lower than in the same period in the prior period due to timing differences in the receipt of these revenues, however they are expected to be higher by year end as stated in the mid year report. 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 ------------------------------------------------------------------------------------------------------------- COPIES TO: Page I of2 Document in FSCOLOR Ol-2006.XLS ITEM NO. 1f13 on a pro rata basis. There are also required entries based on market value that are expected to reduce reported interest income. 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 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/l-580 freeway interchange. General Fund Expenditures Overall, through the month of January, expenditures in the General Fund totaled about $17.2 million and represented approximately 36% of the total budgeted expenditures in the General Fund. Ofthis amount, a total of approximately $1,538,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 January 2006 was similar to the amounts expended for the same period in the prior Fiscal Year Through the end of January 2006, the City had expended 37% of the General Fund Operating Budget, which was I % less than the amount expended in the prior Fiscal Year. 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 ofthe 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 ofthe California Government Code. Page 2 of2 I or- 13 City of DUblin~~~;~:re:i~:~n~:~~:::a~~~~::;t~~:~a~iso~ 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 "~62% 51% 50~o ~% r8% Charges for Services Fines aud Forfeitures Other Revenues 0% 30% 60% 90% 58% of Year Complete FY 2005/06 FY 2005/06 %of Budget YTD Actual Budget Property Taxes 15,716,461 8,323,139 53% Sales Taxes 14,984,884 7,507,690 50% Real Property Transfer Tax 745,600 370,364 50% Transient Occupancy Taxes 680,500 321,107 47% Franchise Taxes 1,626,300 486,479 30% Licenses and Permits 2,380,013 2,094,006 88% Interest and Rentals 1,898.725 813,033 43% Intergovernmental 498,650 736,843 148% Charges for Services 5,256,561 2,842,097 54% Fines and Forfeitures 132,200 74,126 56% Other Revenues 1,815,830 346,552 19% Total General Fund Revenues 45,735,724 23,915,436 52% Dat..Printfld' 21211200610:21 AM . FY 2005/06 FY 2004/05 i ~48% I 120% I ~ 150% FY 2004/05 YTD Actual % of Total for FY 2004/05 7,515,739 7,472,535 430,143 338,188 552,660 2,622,380 652,103 350,121 2,758,434 83,157 469,059 23,244,519 53% 53% 52% 51% 35% 74% 38% 62% 50% 58% 60% 53% L.f '::; 3/';21107 ATTACHMENT 1 1- ! City of Dublin 2005-2006 YTD Expenses and Budget Comparison For the Period Ending January 31, 2006 Total General Fund Expenses General Governmeut Police Other Public Safety Transportation Health and Welfare Cultnre & Commnnity Services Fire 100% 100% 1- Community 47% i Development 52. Capital Improv. ~_ 0 Projects ~_~-+-- 49% L_ General Government Police Fire Other Public Safety Transportation Health and Welfare Culture and Community Services Community Development Capital Improvement Projects Total General Fund Expenses J 0% 20% 40% 60% 80% 100% 2005/06 Budget 5,532,335 11.360,037 8.890,188 383,869 1,824.115 15,000 6,363.138 8,449,412 5.342,794 48,160,888 General Fund Operating Expenses 42,818.094 OeIePli"led 3I3J2OO610.02/W -;z 0 {:. /5, I · FY 2005/06 III FY 2004/05 I 120% ATTACHMENT 2 30F 15 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JANUARY 2006 Prepared by The Finance Department February 21, 2006 ATTACHMENT 3 t.-{ 0 r 13- CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2006 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PR lOR ASSETS CASH (50 930 318) 3 270 172 618 210 37 733 813 131 555 (9 176 568) (28.512,455) CASH WITH FISCAL AGENT 178 395 178.395 172 779 AMOUNT HELD IN ESCROW 4.177 500 4 177 500 INVESTMENTS AT COST 106, B68 119 106 B68 119 105,74B 685 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 401 4 401 10 796 FIXED ASSETS LOANS RECEIVABLE 4 596.534 4.596 534 AMOUNT TO BE PROVIDED 1 213.500 1 213 500 1 334 500 TOTAL ASSETS 58.276 529 3 633 769 618 210 46 507 847 1 523 450 11 0 559 804 80 764 169 LIABILITIES/FUND EOUITY DEPOSITS FOR PRIVATE DEVEL 1847 279) (847.279) (1.227 70n DEPOSITS FOR ABI600 FEES 1763 358) (763 358) (370 998) DEPOSITS OTHERS (2 424 539) (2 424 539) (2 555 793) PAYABLES ACCOUNTS (708 524; (19 116) (1 556) 1729 196) (239 059) INTEREST PAYROLL 1617 909) (617 909) (541 604) DUE TO OTHERS (322 222) (5.270) (2,201 289) (2 528 780) DEFERRED REVENUE (127 768) 1127 768) 1127 768) DEBT INSTRUMENTS PAYABLE (1 331 000) II 331 000) (1 452 000) TOTAL LIABILITIES (5 811.599) (24 386) (2.202 845) (1 331 000) (9 369 B29) (6 514 928) FUND BALANCES (52 464 930) (3 609 383) (61B.210) (44.305 002) (192450)(101 IB9 975) (74.249 2401 TOTAL FUND E (52 464 930) (3 609 383) (618.210) (44.305 002) (192450)(101 189 975) (74.249 2401 TOTAL LIA8ILITIES/EOUITY (58 276.529) (3,633 769) (618,210) (46 507 B47) (1 523 450)(110.559 804) (80 764 169) 5 0 f /3 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Jan2DD6 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOTALS SERVICE FUND GROUP OF TERM DEBT ---MEMDRANDUMu FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 9 760 243 9 760.243 8 573 457 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 FIXED ASSETS 50 002 B51 333 664 335 3B3667,186 85 720 159 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 63 728 304 63 728 304 66 753 945 TOTAL ASSETS 59 763 094 333 664 335 63 728 304 457 155 733 161. 047 560 LIABILITIES/FUND EOUITY DEPOSITS FOR PRIVATE DEVEL OEPOSITS FOR ABI600 FEES DEPOS ITS 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 728.304) (66 753 945) FUND BALANCES (59 763 094) (333.664 335) (393 427 429) (94.293,6151 TOTAL FUND E (59 763 094) (333 664 335) (393 427 429) (94.293 615) TOTAL LIA8ILITIES/EQUITY (59 763.0941 (333 664,335) (63 728 304) (457 155 733)(161 047 560) THE CITY OF DUBLIN STATEMENT SHOWING ft, 6f 13 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 01/31/2006 G ENE R A L REV E N U E FUN D CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y T D VARIANCE *******REVENUES******* PROPERTY TAXES 15 716 461 00 8 323.139 10 7 393 321 90 14 054 547 16 7 515 739 07 6 538 808 09 SALES TAX 14 984 884 00 7 507 689 54 7.477 .194 46 14 152.987 24 7 472 534 84 6 680 452 40 REAL PRDPERTY TRANSFER TAX 745 600 00 370 364 14 375.235 86 831 003 24 430 142 83 400 860 41 HDTEL TRANSIENT OCCUPANCY TAX 680 500 00 321 107 42 359.392.58 663 631 67 338 188 07 325 443 60 FRANCH I SE TAX ES 1 626 300 00 486 479 01 1 139.820 99 1 559 900 22 552 659 92 1 007.240 30 LICENSES & PERMITS 2 380 013 00 2.094.005 67 286 007 33 3 520 140 84 2 622 379 82 897 761 02 FINES & FORFEITURES 132.200 00 74.126 27 58 073 73 143 316 33 83 157 08 60 159 25 USE/MONEY & PROP-INTEREST 1757.52400 769 598 16 987 925 84 1 608 966 40 591 939 43 1 017.02697 USE/MONEY & PROP-RENTALS 141.201 00 43 435 15 97 765 85 125.835 40 60 163 78 65 671 62 INTERGOVERNMENTAL 498 650 00 736.842 64 (238.192 64) 568 598 34 350 121.21 218 477 13 CHARGES FOR SERVICES 5 256.561 00 2 842 097 14 2 414 463 86 5 548 124 34 2 758.434 47 2 789 689 87 OTHER SOURCES OF REVENUE 1 815.830 00 346 552 06 1. 469.277 94 783 873 45 469 058 50 314 814 95 TOTAL REVENUE 45 735 724 00 23 915 436 30 21 820.287 70 43 560 924 63 23 244.519 02 20.316 405 61 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES CITY COUNCIL 300 704 00 152 146 50 148 557 50 224 070 48 120.211 15 103 859 33 CITY MANAGER 997 923 00 523 598 50 474 324 50 919 976 69 515 362 27 404 614 42 CENTRAL SERVICES 538.556 00 246 285.21 292.270 79 362.244 59 192 514 35 169 730 24 CITY ATTORNEY 824 252 00 272 948 14 551 303 86 631 963 18 298 848 14 333 115 04 AOMIN SERVICES 1 648 603 00 872 160.50 776 442.50 1 433 876 94 777 423 66 656 453 28 BUILDING MANAGEMENT 734 657 00 341 561 33 393 095 67 668 646 21 318 652.83 349.993 38 INSURANCE COST CENTER 397 038 00 271 678 12 125 359 88 508.448 41 204 480 66 303 967 75 ELECTIONS COST CENTER 2 890 00 2 112 00 778 00 12 265 33 3 479 13 8 786.20 NON-DEPARTMENTAL 87 712 00 4 650 66 83 061 34 68 155 13 505 50 67 649 63 ACTI V ITY TOTAL 5 532 335 00 2 687 140 96 2 845 194 04 4 829.646 96 2.431 477 69 2 398 169.27 PUBLIC SAFETY POll CE 11 360 037 00 2 573 665 64 8 786 371 36 9 837 842 27 2 176 519 28 7 661 322 99 CROSSING GUARDS 82 140 00 29 994 79 52 145 21 71 407 04 27.571 66 43 835 38 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 7 187 05 10 922 95 8.587 87 3 901 75 4.686 12 DISASTER PREPAREDNESS 74 721 00 28 410 18 46 310 82 68 023 15 30 770 04 37 253 11 FIRE SERVICES 8.890 188 00 2.401 479 24 6 488 708 76 8 207 944 38 2 293 937 32 5 914 007 06 ACTI V!TY TOTAL 20 634.094 00 5 094 165 19 15 539 928 81 18 402.174 62 4 551 942 05 13 850.232 57 TRANSPORTATION PUBL! C WORKS 808 577 00 415 000 86 393.576 14 723 562 41 391 999 54 331. 562 87 STREET MAINTENANCE 30.314 00 30 314 00 15 908 28 24 785 01 (8 876 73) STREET SWEEPING 150 670 00 59 735.52 90 934 48 140 783 85 45 877 64 94 906.21 STREET TREE MAINTENANCE 99 430 00 29 046 84 70 383 16 99.19545 16 389.20 82 806 25 STREET LANOSCAPING MAINTENAN 735.124 00 323 528 48 411 595.52 682.756.30 306.865 19 375 891 11 ACT! V ITY TOTAL 1 824 115 00 827 311 70 996 803 30 1 662 206 29 785 916 58 876 289 71 HEALTH & WELFARE WASTE MANAGEMENT 2 58 (2.58) 71 .474 64 63.387 46 8 087 18 CHILD CARE 15 000 00 15.000 00 15 000 00 15 000 00 SOCIAL SERVICES HOUSING PROGRAMS THE CITY OF DUBLIN STATEMENT SHOWING -; ot /3 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 01/31/2006 G ENE R A L REV E N U E FUN D CURRENT CURRENT PRIOR PR lOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y T D VARIANCE ACTI V JTY TOTAL 15 000 00 15 002 58 (2 58) 86 474 64 78 387 46 8 087 18 CULTURE & LEISURE SERVICES LIBRARY SERVICES 617 771 00 311 195 19 306 575 81 577 734 07 274 417 64 303 316 43 CULTURAL ACTIVITIES 204.701 00 142 664 13 62 036 87 125 102 04 61 159.30 63 942 74 HERITAGE CENTER 163,333 00 83 402 83 79 930 17 125 641 44 66 958.29 58 683 15 DUBLIN CEMETERY 49 95B 00 11.758 15 38.199 85 40 573 15 17.429 22 23 143 93 PARK MAl NTENANCE 1 712 065 00 650 637 85 1. 061. 427 15 1. 450 064 58 671.204 70 778 859 88 COMMUN JTY TV 66 407 00 59 545 58 6 861 42 61 809 00 57 349 00 4 460 00 RECREATION ADMIN 708 174 00 375 436 72 332 737 28 608.760 76 323 684 52 2B5 076 24 PLAYGROUNDS 275 357 00 132 635 72 142,721.28 247.21427 144 945 76 102.268 51 SHANNON CENTER 342 706 00 181. 263 24 161 442 76 301 071 12 200 900 88 100 170.24 PRESCHOOL 105 458 00 57 120 37 48 337 63 82 639 86 46 770 65 35.869.21 TEENS PROGRAM 159 835 00 70 397 57 89 437 43 B7 306 66 45 769 49 41 537 17 ADULT SPORTS 109 230 00 43 415 70 65 814 30 92 694 01 50 809.23 41. 884 78 YOUTH SPORTS 153 617 00 72 963.20 BO 653 80 118 533 39 55 640 09 62 893 30 COMMUNITY GYM 43 459 00 20 821 91 22 637 09 42 887 87 13 761 44 29 126 43 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 364 601 00 203 204 81 161.396 19 331 898 19 169 451 88 162 446 31 SEN lOR CENTER 365 728 00 222 803 78 142 924 22 253 121. 20 132 795 81 120 325 39 RECREATION INSTRUCTION 183 023 00 82 693 63 100 329 37 174 492 75 94 773 39 79 719 36 AOUA TI CS 429.221 00 208 309 69 220 911 31 393 660 59 203 831 02 189.829 57 PARKS/FACILITIES MANAGEMENT 308.494 00 165 596 17 142 897 83 261 92B 57 148.217 14 113 711 43 ACT! V ITY TOTAL 6 363 138 00 3 095 866 24 3.267 271 76 5.377 133 52 2.779,86945 2 597 264 07 COMMUNITY DEVELOPMENT PLANNING 2 685 164 OD 1 229 503 67 1 455 660 33 2 414 972 53 1 367 145 83 1 047 826 70 8UILDING SAFETY 3.214,615 00 1 367 397 16 1 847.217 84 2 399 434 25 1 117 892 06 1.281.542 19 ENGINEERING 2 194 005 00 1 172 626 45 1. 021 378 55 2,304 691 55 1.162,065 98 1 142 625 57 ECONOMIC DEVELOPMENT 355 628 00 213.861 74 141 766.26 272 379 63 203 894 85 68 484 78 ACTI V ITY TOTAL 8 449 412 00 3.983.389 02 4 466 022 98 7 391 477 96 3 850 99B 72 3 540 479.24 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1 350 856 00 120 910 34 1. 229 945 66 633 849.26 335 042 50 298 806 76 COMMUNITY IMPROVEMENTS 874 999 00 601 704 07 273 294 93 403 110 09 21 921 35 381 188 74 PARKS 1 628 920 00 656 404 00 972 516 00 2 630 020 78 1 668 129 57 961 891 21 STREET CONSTRC/IMPROVEMENTS 1 488 019 00 158 578.32 1 329 440 68 980 260 11 256 694 85 723 565 26 ACTI V JTY TOTAL 5 342 794 00 1.537,596 73 3 805 197 27 4 647 240.24 2.281 788 27 2 365 451 97 TOTAL EXPENDITURES 48 160 888 00 17.240 472 42 30 920.415 58 42 396 354.23 16 760.380 22 25 635 974 01 EXCESS REVENUE (EXPENDITURES) (2 425 164 DOl 6 674 963 88 (9 100 127 88) 1 164 570 4D 6 484 138.80 (5 319 568.40) TRANSFERS IN FROM OTHER FUNDS 475 053 00 475 D53 00 27 230 91 27.230 91 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNOER) EXPENDITURES (1 950 III 00) 6 674 963 88 (8 625.074 88) 1.191 801 31 6.484 138 80 (5.292,337 49) THE CITY OF DUBLIN STATEMENT SHOWING 'jotr3 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 01/31/2006 SPECIAL REVENUE 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 112 532 03 56 837 59 55 694 44 SALES TAX/OTHER TAXES 360.500 00 160 230 43 200 269 57 364 477 71 122 240 82 242 236 89 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 581 090 21 433,140 79 2.354 339 65 1 674 784.21 679 555 44 INTERGOVERNMENTAL FROM COUNTY 340 440 00 79.255 00 261 185 00 332.344 00 72 652 00 259 692 00 INTERGOVERNMENTAL FROM FEOERAL 76 792 00 37 404 53 39 387 47 56.796 80 2 790 99 54.005 81 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 4 518 35 165 964 04 TOTAL REVENUE 3 925 361 00 2 112 518 81 1 812 842 19 4 718 425 45 2 560 330 87 2 158 094 58 *******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 128 850.24 105 849 76 173 175 14 61 227 30 III 947 84 OISASTER PREPAREDNESS FIRE SERVICES 270 120 00 76 109 59 194 010 41 251 091 21 28 391. 24 222 699 97 ACT! V ITY TOTAL 625 075 00 305 993 71 319 081.29 530.218 75 193 626.34 336 592 41 TRANSPORT A T! ON STREET MAINTENANCE 330 474 00 114 817 68 215 656 32 272 390.25 78.615 99 193 774 26 STREET SWEEPING ACTI V!TY TOTAL 330 474 00 114 817 68 215 656 32 272 390.25 78 615 99 193 774.26 HEALTH & WELFARE WASTE MANAGEMENT 1 874 906 00 1 124 730 85 750 175 15 1. 383,964 16 22 624 50 1 361 339 66 SOCIAL SERVICES 60 427 00 15 442 41 44 984 59 44 927 00 20 819 30 24 107 70 HOUS I NG PROGRAMS ACTIVITY TOTAL 1 935 333 00 1.140 173 26 795 159 74 1.428.891 16 43 443 80 1 385 447 36 COMMUNITY DEVELOPMENT ENGINEERING 6 000 00 6 000 00 6.000 00 2 490 50 3.509 50 ACT! V!TY TOTAL 6 000 00 6 000 00 6 000 00 2 490 50 3 509 50 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 128 500 00 193.217 00 STREET CONSTRUCTION/IMPROVEMENT 1 670 803 00 521 662.17 1 149 140 83 149 554 78 72 900 46 76 654 32 ACTI V!TY TOTAL 1 741 669 00 551 453 17 1 190 215 83 486 121 78 201 400 46 284 721 32 TOT A L EXPENDITURES 4 644 115 00 2 118 437 82 2.525 677 18 2 723 621 94 519 577 09 2.204 044 85 EXCESS REVENUE (EXPENDITURES) (718 754 00) (5 919 01) (712 834 99) 1 994.803 51 2.040 753 78 (45 950.27) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 88.737 00 88 737 00 1 336.274 58 1 336 274 58 REVENUES OVER (UNDER) EXPENDITURES (807 491 DOl (5 919 01) (801 571 99) 658 528 93 2 040.753 78 (1 382 224 85) THE CITY OF DUBLIN STATEMENT SHOWING q of!3 REVENUES VERSUS EXPENDITURES FOR THE PERIOO 07/01/2005 THROUGH 01/31/2006 SPECIAL ASS E SSM E N T FUN 0 S CURRENT CURRENT PRIOR PR lOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y T 0 VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 664 610 00 324 983 90 339,626 10 744 099 49 438 340 9B 305 758 51 USES/MONEY & PROP-INTEREST 15 47B 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 08B 00 334 178 16 350 909 84 758 847 59 442 108 15 316 739 44 *******EXPENDITURES******* PUBL! C SAFETY TRAFFIC SIGNALS & STREET LIG 278,600 00 113 121 57 165 478 43 231 533 62 105 445 93 126 087 69 ACT! V ITY TOTAL 278 600 00 113 121 57 165,478 43 231 533 62 105 445 93 126 087 69 TRANSPORT A T! ON PUBL! C WORKS 2 415 00 962 54 1 452 46 1 591 29 959 99 631 30 STREET TREE MAINTENANCE 34 231 00 6 675 7B 27 555.22 18 466 76 5 226 41 13.240 35 STREET LANDSCAPE MAINTENANCE 356 039 00 153 942 16 202,C96.84 317 657 53 148 817 58 168 839 95 ACT! V!TY TOTAL 392 685 DO 161 580 48 231.104.52 337 715 58 155 003 98 182 7ll 60 COMMUNITY DEVELOPMENT ENGINEERING 13.10000 11 357 60 1 742 40 7 139 94 6 669 94 470 00 ACT! V!TY TOTAL 13,10000 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 ACT! V ITY TOTAL 107 920 00 18 106 69 89,813.31 TOT A L EXPENOITURES 792,305 00 304 166 34 488 138 66 576 389 14 267 119 85 309 269.29 EXCESS REVENUE (EXPENDITURES) (107,217 00) 30 011 82 (137 228 82) 182 458 45 174 988 30 7 470 15 REVENUES OVER (UNDER) EXPENDITURES (107,217 00) 30 011 82 (137 228 82) 182 458 45 174 988 3D 7 470 15 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOO 07/01/2005 THROUGH 01/31/2006 10 of 13 CAP I TAL IMP R 0 V E MEN T FUN D S CURRENT CURRENT PRIOR PRIOR BUIXiET ACTUAL VARIANCE FISCAL YEAR Y T D VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST 865 623 00 500.561 48 365 061 52 1.221 970 50 382 033 41 839 937 09 OTHER SOURCES OF REVENUE 19 267 625 00 9 083 026 75 10 184 598.25 14.361 927 97 9 972 193 69 4 389 734.28 TOTAL REVENUE 20 192 732 00 9.583.588.23 10 609 143 77 16 892.942 14 10 354 227 10 6.538 715 04 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES CITY ATTORNEY 38 950 00 23 106 79 15 843 21 35.736.39 504 00 35 232 39 ACTIVITY TOTAL 38 950 00 23.10679 15 843 21 35 736.39 504 00 35 232 39 PUBLI C SAFETY TRANSPORTATION HEALTH & WELFARE HOUSING PRIXiRAMS 903 030 00 158.77953 744.250 47 219 420 35 103.625 90 115 794 45 CULTURE & LEISURE SERVICES RECREATION ADMINISTRATION ACTI V!TY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTI V!TY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 83 600 00 83 600 00 624 943 39 143 614 57 481. 328 82 COMMUNITY IMPROVEMENTS 36 771 00 36 771 00 PARKS 11 322 835 00 3 374 843 07 7 947 991 93 6.285 687 19 300 087 79 5 985 599 40 STREET CONSTRUCTION/IMPROVEMENT 36 340 142 00 264 537 64 36 075 604 36 3.309 862 62 I 190 476 90 2 119 385 72 ACTI V ITY TOTAL 47 746 577 00 3 639 380 71 44 107 1% 29 10.257 264.20 1 634 179 26 8.623 084 94 TOT A L EXPENDITURES 48 688.557 00 3.821 267 03 44 867 289 97 10 571 890 78 1 738.309 16 8.833 581 62 EXCESS REVENUE (EXPENDITURES) (28 555 309 00) 5 762 321.20 (34 317 630 20) 5 012 007 69 8 615 917 94 (3 603 910 25) TRANSFER IN FROM OTHER FUNDS (59 484 00) (59 484 00) (] 309 043 67) (] 309 043 67) TRANSFERS OUT TO OTHER FUNOS 445 800 00 445.800 00 REVENUES OVER (UNDER) EXPENDITURES(28 941.625 00) 5 762 321.20 (34 703 946 20) 6 321 051 36 8.615 917 94 (2.294 866 58)