The URL can be used to link to this page

Home My WebLink AboutItem 4.02 Qty Financial Report. G~~~ OF: Dp~~~ <:. ////~~ ~\ 19 _(~1~;:=7h `82 ' ~~ ,J ~~ ~ ~% ` ~~LI~'~OR~~ .;; STAFF REPORT C I T Y C L E R K DUBLIN CITY COUNCIL File # ^~~D^-~~ DATE: May 3, 2011 TO: Honorable Mayor and City Council Members ~ FROM: Joni Pattillo, City Manager SUBJECT: Quarterly Financial Report for the Period Ending March 31, 2011 (Third Quarter Fiscal Year 2010-2011) Prepared By: Vivian Gong, Finance Manager EXECUTIVE SUMMARY: The City Council will be presented with preliminary information related to the revenues and expenditures through the end of the third quarter of Fiscal Year 2010-2011. Based on the completion of nine months of activity the report will include analysis of significant trends and variances befinreen budgets and actual expenditures. FINANCIAL IMPACT: Detailed financial information can be found within the Staff Report and the Attachments. RECOMMENDATION: Receive the reports as authorized by Section 41004 of the California Government Code. ~ ~ ~"- Submitted By: Administrative Services Director DESCRIPTION: Reviewed Assistant City Manager This item provides the report on the preliminary financial statements for the third quarter which includes the months of July 2010 through March 2011. 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. , Page 1 of 6 ITEM NO. ~~ ~ Contents of Reports The Quarterly Report is broken into four components to provide a breakdown of information. The components are: • Attachment 1 General Fund Year To Date Revenues and Budget Comparisons (The report also includes a graphic comparison of actual revenue collected compared to the same period in the previous year. The report is broken down into Major Revenue Types.) • Attachment 2 General Fund Year To Date Expenditures and Budqet Comparisons (The report also includes a graphic comparison of actual expenditures compared to the same period in the previous year. The report is broken down into Major Program Types with segregated information for Police and Fire Services.) • Attachment 3 Comparison of Revenue Versus Expenditures - By Fund Type (The report provides budget to actual comparisons for the current Fiscal Year as well as information for the same period in the previous Fiscal Year. The information is arranged by Fund Type: General Fund; Special Revenue Fund; Assessment District Funds; Agency Trust Funds; and Internal Service Funds.) Attachment 4 Monthly Fund Balances (The report presented is as of the end of the quarter and it provides fund balance information as well as revenues and expenditures to date as required in Government Code Section 41004. The first page is a high level summary followed by additional detail for each fund.) The third quarter report represents completion of 75% of the Fiscal Year. It should 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 some expenditures due to the significant amount of services provided to the City by outside independent contractors, including Police and Fire Services. These services are billed to the City on a quarterly or bi-monthly basis and therefore, expenditures incurred during the reporting periods may be incomplete until the billing is received and recorded. General Fund Revenues As shown in Attachment 1, the total General Fund Revenues collected through March 2011 represented 68% of the current budget. Although the number does not track according to the percentage of year completion, it is consistent with the collection in the previous Fiscal Year in which the City collected 61 % of its total General Fund revenue. There were deviations in terms of dollars collected in several categories and the following Table summarizes some of the more significant deviations compared to the same reporting period in the prior year. In order to place the year to date trends in context this Table also includes: the Current Year Budget, Prior Fiscal Year Total and the Difference. This helps to provide conte~ct to the most recent trends. This will also help to identify items where a decrease in year to date collections may be consistent with the adopted Fiscal Year 2010/2011 Budget and Financial Plan. Page 2 of 6 Summary of Significant General Fund Revenue DifFerences For Amounts Collected July - March 2011 vs. July - March 2010 REVENUE YTD YTD DIFFERENCE March March FY 2010/11 EXPLANATION 2011 2010 More / (Less) FY 2009/10 Property $13,116,227 $13,292,589 ($176,362) Revenue collected thru March of prior year Taxes exceeded current collection by approximately 1%. The variance in this category was expected due to adjustments made by the County Assessor. The law requires the Assessor to adjust taxable values based on market conditions. The , City receives the first allocation for secured property tax in December. The second ANNUAL ACTUAL allocation for secured property tax is BUDGET PRIOR YR DIFFERENCE received in mid-April. $21,386,000 $22,141,004 ($755,004) Sales Tax/ $8,558,488 $7,689,076 $869,412 The 2010/2011 Budget anticipates an In-Lieu . increase of 2% (or $216,733) compared to Sales Tax prior year. Current data shows a positive variance as revenue collected through March 2011 exceeded prior year by 8% (or $869,412). There is a significant lag in sales tax data. The reported revenue as of March includes advances based on State ~ ANNUAL ACTUAL estimates and includes actual data for BUDGET PRlOR YR DIFFERENCE sales that occurred as of December 31, $12,400,000 $12,183,267 $216,733 2011. Transient $396,622 $339,424 $57,198 The increase in hotel occupancies is due Occupancy to the fact that additional rooms became Taxes available as local hotels completed their renovations. Also, with improved economic conditions the revenue has been increasing. Collection is tracking at 61 % of the current budget. Remittance for the~ ANNUAL ACTUAL month of March has not been received as BUDGET PRIOR YR DIFFERENCE of the date of this report. $650,000 $557,000 $93,000 Franchise $1,194,020 ~ $996,897 $197,123 The increase is associated with the Taxes amended franchise agreement for waste management services. There is a lag in . the collection of Franchise fees. The collections to date are consistent with the ANNUAL ACTUAL budget. BUDGET PRIOR YR DIFFERENCE $2,667,500 $2,271,574 $395,926 Page 3 of 6 REVENUE YTD YTD DIFFERENCE March March FY 2010/11 EXPLANATION 2011 2010 More / (Less) FY 2009/10 Licenses / $1,784,847 $1,677,175 $107,672 $94,854 or 6% of the positive variance in Permits this category is related to an increase in building permit activity. A total of 1029 building permits were issued during the ' period July 2010 through March 2091 as compared to a total of 965 permits issued in the same comparable period of the ANNUAL ACTUAL previous year (an increase of 7%). BUDGET PRIOR YR DIFFERENCE Planning permit revenue increased by $2,820,980 $2,260,365 $560,615 $16,721 compared to March 2010. Fines / $84,194 $115,159 ($30,965) Parking citation revenues decreased by Penalties approximately $26,000 as compared to collection in the prior year. ANNUAL ACTUAL BUDGET PRIOR YR DIFFERENCE $120,540 $144,593 ($24,053) Interest/ $1,006,101 $1,038,169 ($32,068) Interest income decreased by Rentals approximately $112,000 or 17% compared to prior year and corresponds to the declining rates earned on City investments. The decrease was offset by an increase of approximately $80,000 in facility rentals, in particular $55,394 was from Field and ANNUAL ACTUAL Court rentals. BUDGET PRIOR YR DIFFERENCE $1,322,534 $1,956,606 ($634,072) Inter- $283,489 $160,485 $123,004 The primary difference is related to a govern- $92,500 Federal reimbursement grant mental received in FY2010-2011 through the Metropolitan Transportation Commission for the Downtown Specific Plan project. ANNUAL ACTUAL The remaining increase is associated with BUDGET PRIOR YR DIFFERENCE on-going revenues collected from the State $504,860 $520,719 ($15,859) for the Motor Vehicle In-Lieu fees. Charge for $4,314,886 $3,897,550 $417,336 The variance in this category is comprised Services of both positive and negative deviations. The most significant increases were: 1) $237,990 Waste Management Admin Fees in accordance with the new agreement with AVI; 2) $439,106 Engineering Plan Check; and 3) $106,758 from Parks & Community ~ programs and services. The increases were artiall offset b decreases in: Page 4 of 6 REVENUE YTD YTD DIFFERENCE March March FY 2010/11 EXPLANATION . 2011 2010 More / (Less) FY 2009/10 1) Charges related to the Santa Rita Fire Services ($105,576) and 2) Development Zoning Fees ($130,632) In addition, due to a change in the accounting practice for those fees collected on behalf of other agencies (Zone 7, State Building surcharges, etc.) $185,065 was shown as current revenue ANNUAL' ACTUAL in March 2010 which was also a liability BUDGET PRIOR YR DIFFERENCE pending transmittal to third parties. $5,046,130 $5,327,968 ($281,838) Other $2,937,490 $856,356 $2,081,134 This category of revenue typically includes Revenue payments such as contributions, donations, or one-time reimbursements that may not occur consistently from year to year. In October 2010, the City received $2 million as a Community Benefit ANNUAL ACTUAL payment for the Jordan Ranch project. BUDGET PRIOR YR DIFFERENCE The City also received $166,667 from $2,889,200 $1,635,316 $1,253,884 KBH Investments, LLC from the Scarlett Court sales transaction. General Fund Expenditures Overall, through the month of March 2011, expenditures in the General ~und totaled approximately $28.7 million and represented approximately 56% of the total budgeted expenditures in the General Fund (Attachment 2). Of this amount, a total of $2,804,521 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. An examination of only the General Fund Operating Expenditures (Attachment 2) indicates that through March 2011, expenditures totaled 54°to of the Budgeted General Fund expenses, which was approximately 8% or $4.4 million higher than the amounts expended for the same period in the prior Fiscal Year. This variance reflects a combination of increases and decreases when compared to the prior Fiscal Year. Approximately $2.2 million of the deviation is primarily associated with a timing difference on the payment of, major contract services. As of March 2010, payments for the contract Police services were recorded for only finro months (July and August 2010). While as of March 2011, the payments reflect Police Services costs for the period July through October 2011 have been recorded. In the General Government expenditure category, the City Council authorized the contribution of $2 million to an Internal Services Fund established to set aside funds for future major building maintenance and replacement needs. All expenditures are within the authorized budget. Page 5 of 6 It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. NOTICING REQUIREMENTS/PUBLIC OUTREACH: None ~ ATTACHMENTS: Attachment 1- General Fund Year To Date Revenues and Budget Comparisons Attachment 2- General Fund Year To Date Expenditures and Budget Comparisons Attachment 3- Comparison of Revenue Versus Expenditures - By Fund Type Attachment 4- Monthly Fund Balances - For the Period Ending March 31, 2011 Page 6 of 6 ~ ,. , : .. FY 2010/11 FY 2010/11 % of FY 2009/10 Budget YTD Actual Budget YTD Actual Property Taxes 21,386,000 13,116,227 61°/a 13,292,589 Sales Taxes 12,400,000 8,558,488 69% 7,689,076 Real Property Transfer Tax 290,000 223,557 77% 228,791 Transient Occupancy Taxes 650,000 396,622 61 °/o 339,424 Franchise Taxes 2,667,500 1,194,020 45% 996,897 Licenses and Permits 2,820,980 1,784,847 63°/o 1,677,175 Fines 8~ Penalties 120,540 84,194 70% 115,159 Interest 8 Rentals 1,322,534 1,006,101 76% 1,038,169 Intergovernmental 504,860 283,489 56% 160,485 Charges for Services 5,046,130 4,314,886 86% 3,897,550 Other Revenues 2,889,200 2,937,490 102% 856,356 Total General Fund Revenues 50,097,744 33,899,921 68% 30,291,671 Data PrinteC: 4/792011 5:18 PM % of Total for FY 2009/10 60% 63% 61% 61% 44% 74% 80% 53% 31% 73% 52% 61% ~. a 5- 3- i i ATTACHMENT 1 City of Dublin 2010-2011 YTD Expenses and Budget Comparison For the Period Ending March 31, 2011 Total General Fund Expenses CIP Projects Community Development Culture & Community Services Health and Welfare Transportation Other Public Safety Fire Police General Government 89% 69% 69% ~~-t~~' ~ ~" ~~ 67% ^ FY 2010/11 % ~ FY 2009(10 46% ~ 3~% 21% 71 0% 20% 40% 60% 80% 100% 120% 75% of Year Complete FY 2010/11 FY 2010i11 % of FY 2009/10 Budget YTD Actual Budget YTD Actual General Government 8,474,280 6,057,142 71% 3,814,452 Police 12,859,260 4,622,988 36% 2,585,936 Fire 10,451,170 4,957,039 47% 5,148,124 Other Public Safety 1,144,275 419,914 37% 206,308 Transportation 1,896,610 1,223,455 65% 1,183,226 Health and Wetfare 276,630 114,224 41% 33,322 Culture and Community Services 7,640,409 4,764,705 62% ~1,873,179 Community Development 5,463,410 3,772,919 69% 3,625,257 CIP Projects 3,167,908 2,804,521 89% 2,369,702 Total General Fund Expenses 51,373,952 28,736,907 56% 23,839,506 General Fund Operating Expenses 48,206,044 25,932,386 54% 21,469,804 % of Total for 43% 21% 50% 40% 66% 46% 67% 69% 48% 46% ~„P„M~:a,~o„S,BPM ATTACHMENT 2 ~~ i5 CITY OF DUBLIN PRO FORMA COMPARISON OF REVENUE VERSUS EXPENDITURES (By Fund Type) FISCAL YEAR 2010-2011 FOR THE PERIOD ENDING MARCH 31, 2011 (Quarter 3) Q1 /~~~ 19 I ~ ~ -_ ~~ 11 Prepared by the Finance Department Presented To City Council May 3, 2011 • General Fund - Comparison of Revenue & Expenditures 7/1/2010 - 03/31/2011 • Special Revenue Funds - Comparison Revenue & Expenditures 7/1/2010 - 03/31/2011 • Assessment District Funds - Comparison Revenue & Expenditures 7/1/2010 - 03/31/2011 ~ Agency Trust Funds - Comparison Revenue & Expenditures 7/1/2010 - 03/31/2011 • Internal Service Funds - Comparison Revenue & Expenditures 7/1/2010 - 03/31/2011 ATTACHMENT 3 \IFOR-% Printed on: 04/19/2011 CITY OF DUBLIN '• . . ; t. ~.~ " , ` ~ ' GE NERAL FUND :,. . . V ~ COMPARISON OF REVENUES / VERSUS EXPENDITURES FOR THE PERIOD 7N/2010 THROU GH 3/31/2011 '- ' 2011 2011 2011 2011 2010 ~ 2010 2010 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % """"**"REVENUES/SOURCE OF FUNDING"***** *" PROFERTYTAXES 21,386,000 13,116,227 8,269,773 61 % 22,141,004 13,292,589 . $0 % SALES TAX . 12,400;000 8,558,488 3,841,512 69 % 12,183,267 7,689,076 63 % PROPERTY TRANSFER TAX 290,000 223,557 66,443 77 % 372,646 228,791 61 % HOTEL TAX 650,000 396,622 253,378 61 % 557,000 339,424 ~ 61 % FRANCHISE TAXES - WASTE MGT , 1,525,000 855,388 669,612 56 % 1,100,516 654,729 59 % FRANCHISE TAXES - UTILITIES 1,.142,500 338,632 803,868 30 % 1,171,058 342,168 29 % LICENSES & PERMITS 2,820,980 1,784,847 1,036,133 63 % - 2,260,365 1,677,175 74 % FINES 8~ PENALTIES 120,540 84,194 36,346 70 % 144,593 115,159 80 % INTEREST 867,610 - 670,014 197,596 77 % 1,576,962 781;790 50 % f2ENTALS 8~ LEASES 454,924 336,087 118,837 74 % 379,644 256,379 68 % INTERGOVERNMENTAL - FEDERAL 97,600 92,500 5,100 95 % 180,647 _ INTERGOVERNMENTAL - STATE . 407,260 190,989 216,271 47 % 340,072 160,485 47 % CHARGES FOR SERVICES 5,046,130 • 4,314,886 731,244 86 % 5,327,968 3,897,550 73 % OTHER REVENUE 2,889,200 2,937,490 (48,290) 102 % 1,635,316. 856,356 52 % SUB-TOTAL OPERATING REVENUES 50,097,744 33,899,921 16,197,823 68 % 49,371,056 30,291,670 61 %. ~ TRANSFERS IN 29,730 29,730 28,648 GRAND TOTAL REVENUE/SOURCES 50,127,474 33,899,921 16,227,553 68 % 49,399,705 30,291,670 61 % "*""*'*EXPEN DITURES/TRANSFERS""'**"** GENERAL GOVERNMENT • CITY COUNCIL 331,440 182,939 148,501 55 °/a 353,408 238,456 67 % CITY MANAGER/CITY CLERK . 1,136,650 822,948 313,702 72 % 1,098,683 813,863 74 °/a ELECTIONS 79,870 24,389 55,481 31 % 1,945 1,815 93 % CENTRAL SERVICES/HUMAN RESOURCES 439,380 293,157 146,223 67 % 398,475 296,849 74 % INSURANCE 940,780 470,496 470,284 50 % 788,886 345,982 44 % CITYATTORNEY 688,060 349,468 338,592 51 % 727,015 342,062 47 % ADMINISTRATIVE SERVICES 1;946,790 1,298,724 648,066 67 % 1,788,564 1,331,040 •' 74 % BUILDING MANAGEMENT 716,830 493,179 223,651 69 % 703,853 437,706 62 % NON-DEPARTMENTAL 2,194,480 2,121,842 72,638 97 % 3,011,461 6,678 0% GENERALGOVERNMENT-SUBTOTAL 8,474,280 6,057,142 2,417,138 71 % 8,872,290 ~ 3,814,452 43% PUBLIC SAFETY POLICE 12,859,260 4,622,988 8,236,272 36 % 12,281,022 2,585,936 21 % FIRE 10,451,170 4,957,039 5,494,131 47 % 10,203;635 5,148,124 50 % DISASTER PREPAREDNESS 416,535' 259,318 157,217 62 % 107,025 62,862 59 % CROSSING GUARDS 100,830' 63,012 37,818 62 % 100,659 57,472 57 % ANIMAL CONTROL 414,420 53,269 361,151 13 °/a 293,357 61,121 21 % TRAFFIC SIGNALS/STREET LIGHTING - 212,490 44,315~ 168,175 21 % 12,418 24,853 200 % PUBLIC SAFETY- SUBTOTAL 24,454,705 9,999,940 14,454,765 41 % 22,998,117 7,940,369 35 % ' TRANSPORTATION PUBLIC WORKS ADMINISTRATION 876,660 594,359 . 282,301 68 % 784,658 609,065 78 % STREET MAINTENANCE/SWEEPING .. 131,280 92,616 38,664 71 % 143,562 82,160 57 % STREET LANDSCAPE/TREE MAINTENANCE 888,670 536,480 352,190 60 % 862,864 492,001 57 % TRANSPORTATION- SUBTOTAL - 1,896,610 1,223,455 673,155 65 % 1,791,083 1,183,226 66 % HEALTH & WELFARE WASTE MANAGEMENT 3 (3) - ENVIRONMENTAL SERVICES 40,000 40,000 . 13,755 CHILD CARE 25,000 (25,000) - 18,500 9,632 52 % SOCIAL SERVICES 236,630 89,222 147,408 38 % 39,425 23,690 60 % HEALTH & WELFARE- SUBTOTAL 276,630 114,224 162,406 41 % 71,680 33,322 46 % Printed on: 04/19/2011 CITY OF DUBLIN ~~~~ GENERALFUND COMPARISON OF REVENUES / VERSUS EXPENDITURES FOR THE PERIOD 7/1/2010 THROUGH 3/31/2011 2011 2011 2011 2011 2010 2010 2010 BUDGET ACTUAL VARIANCE % BUD- ACTUAL YTD % ""'*"*"'EXPENDITURES/TRANSFERS*""*"*" CULTURE & LEISURE SERVICES COMMUNITY N 86,790 75,988 10,802 88 % ° 83,659 80,025 96 % LIBRARY SERVICES 522,940 275,616 247,324 53 % 815,019 432,659 53 % PARK MAINTENANCE 2,309,330 1,190,263 1,119,067 52 % 1,753,494 1,058,896 60 % HERITAGE 8~ CULTURAL ARTS 712,400 530,354 182,046 74 % 768,932 573,368 75 % RECREATION & COMMUNITY SERVICES 3,732,119 2,545,4&4 1,186,635 68 % 3,625,582 2,560,926 71 % PARKS/FACILITIES DEVELOPMENT ~ 276,830 147,001 129,829 53 °/a 220,144 167,305 76 % CULTURE & LEISURE SERVICES - SUBTOTAL 7,640,409 , 4,764,705 2,875,704 62 % 7,266,829 4,873,179 67 % COMMUNITY DEVELOPMENT ~ DEVELOPMENT SERVICES 3,587,570 . 2,380,567 1,207,003 66 % 3,578,842 2,398,997 67 % ENGINEERING 1,539,350 1,195,523 , 343,827 78 % 1,397,678 1,007,743 72 % ECONOMIC DEVELOPMENT 336,490 196,829 139,661 58 % 299,751 218,517 73 % COMMUNITYDEVELOPMENT-SUBTOTAL 5,463,410 3,772,919 1,690,491 69 % 5,276,271 3,625,257 69 % SUB-TOTAL OPERATIONG EXPENDITURES 48,206,044 25,932,386 22,273,658 54 % 46,276,269' 21,469,805 46 %' TRANSFERS OUT 3,167,908 2,804,521 363,387 89 %. 3,429,024 2,369,702 69 % GRAND TOTAL DCPENDITURES 51,373,952 28,736,907 22,637,045 56 % 49,705,294 23,839,507 48 % REVENUES(SOURCEOFFUNDS)OVER/(UNDER) (1,246,478) 5,163,014 (6,409,492) (414%) (305,589) 6,452,163 (2,111%) IXPENDITURES ~ ~ Printed on: 04/19/2011 CITY OF DUBLIN r~ IJ. SPECIAL REVENUE FUNDS «~ ~~D COMPARISON OF REVENUES / VERSUS EXPENDITURES FOR THE PERIOD 7/1/2010 THROUGH 3/31/2011 , 201] 2011 2011 2011 2010 2010 2010 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD - % '"""""'REVENUES/SOURCE OF FUNDING'*'"`*"*' PROPERTYTAXES 144,300 89,292 55,008 62 %. 145,206 88,020 61 % SALES TAX 422,920 224,355 198,565 53 % 398,611 205,755 52 % FINES & PENALTIES 170,000 114,735 55,265 67 % 168,187 109,798 65 % INTEREST 292,500 205,524 86,976 70 % 476,977 224,583 -47 % LOAN REPAYMENTS 371,000 466,112 (95,112) 126 °!0 861,769 812,773 94 °lo INTERGOVERNMENTAL - FEDERAL 1,244,683 50,430 1,194,253 4% 2,278,199 72,453 3% INTERGOVERNMENTAL-STATE 1,580,477 922,134 658,343 58 °/a 1,561,987 588,719 32 %. INTERGOVERNMENTAL-COUN7Y 1,213,735 915,472 298,263 75 % 1,564,180 1,006,829 64 % CHARGES FOR SERVICES 2,258,870 1,452,514 806,356 64 % 1,772,435. 1,122,858 63 % OTHER REVENUE 1,364,640 1,669,552 (304,912) 122 % 2,064,566 1,368,023 66 % SUB-TOTAL OPERATING REVENUES 9,063,125 6,110,120 2,953,005 67 % 11,592,116 5,599,810 48 % TRANSFERS IN 6,600 • 6,600 445,844 GRAND TOTAL REVENUE/SOURCES 9,069,725 6,110,120 2,959,605 67 % 12,037,959 5,599,810 47 % *'"""*'*EXPENDITURES/TRANSFERS""*""*' ~ GENERAL GOVERNMENT : CITYATTORNEY 57,430 19,846 37,5$4 35 % 85,455 61,045 71 % GENERAL GOVERNMENT - SUBTOTAL 57,430 19,846 37,58a 35 % 85,455 61,045 71 % PUBLIC SAFETY~ _ POLICE 128,880 72,599 56,281 56 % 160,299 86,794 54 % FIRE ' 318,860 164,347 154,513 52 % 380,012 199,256 52 % TRAFFIC SIGNALS/STREET LIGHTING 156;400 71,818 84,582 46 % 293,604 113,263 39 % PUBLIC SAFETY- SUBTOTAL 604,140 308,764 . 295,376 51 % 833,915 399,313 48 % TRANSPORTATION PUBLIC WORKS ADMINISTRATION ~ 15,571 7,409 8,162 48 % 8,770 1,570 ~. 18 % STREET MAINTENANCE/SWEEPING 531,205 246,872 284,333 46 % 310,127 112,381 36 % Others 3,861 TRANSPORTATION-SUBTOTAL 546,776 254,281 292,495 47% 322,758 113,950 35% HEALTH & WELFARE WASTE MANAGEMENT 2,429,930 1,248,350 1,181,580 51 % 1,847,767 935,920 51 °Jo ENVIRONMENTAL SERVICES 255,060 193,089 61,971 76 % 245,145 176,739 72 % SOCIAL SERVICES 104,240 81,268 22,972 78 % 55,435 44,394 80 % HOUSING PROGRAMS 13,248,270 7,541,667 5,706,603 57 % 1,432,282 1,021,054 71 % Others 22 (22) HEALTH & WELFARE - SUBTOTAL 16, 037, 500 9, 064, 396 6, 973,104 57 % 3, 580, 629 2,178,107 61 % CULTURE & LEISURE SERVICES PARK MAINTENANCE 6,220 6,220 1,964 975 50 % CULTURE & LEISURE SERVICES - SUBTOTAL 6,220 6,220 1,964 975 50 % COMMUNITY DEVELOPMENT ENGINEERING 6,000 2,965 3,035 49 % 6,000 6,000 100 % COMMUNITYDEVELOPMENT-SUBTOTAL 6,000 2,965 3,035 49 % 6,000 6,000 100 % SUB-TOTAL OPERATIONG EXPENDITURES 17,258,066 9,650,253 7,607,813 56 % 4,830,721 2,759,391 57 / TRANSFERS OUT 5,672,643 2,186,781 3,485,862 39 % 7,477,808 5,229,947 70 % GRAND TOTAL EXPENDITURES 22,930,709 11,837,034 11,093,675 52 % 12,308,529 7,989,338 65 % REVENUES (SOURCE OF FUNDS) OVER/(UNDER) (13,860,984) (5,726,913) (8,134,071J 41 % (270,570) (2,389,527) 883 % EXPENDITURES Printed on: 04/19/2011 CITY OF DUBLIN ~ I~ ~ ASSESSMENT DISTRICT FUNDS ~ ~ COMPARISON OF REVENUES / VERSUS EXPENDIT URES FOR THE PERIOD 7/1/ 2010 THROUGH 3/31/2011 2011 2011 2011 . 2011 2010 2010 2010 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % *'******REVENUES/SOURCE OF FUNDING'""***** ~ PROPERTY TAXES 886,810 534,562 352,248 60 % 868,349 525,227 60 % INTEREST 10,670 ' 8,560 2,110 80 % 17,973 8,568 48 % OTHER REVENUE 2,500 4,584 (2,084) 183 % 6,119 12 0% SUB-TOTAL OPERATING REVENUES 899,980 547,707 352,273 61 % 892,440 533,808 60 % GRAND TOTAL REVENUE/SOURCES 899,980 547,707 352,273 61 % 892,440 533,808 60 % *""""""EXPENDITURES/TRANSFERS'****'"* PUBLIC SAFETY - TRAFFIC SIGNALS/STREET LIGHTING 408,890 202,297 206,593 49 % 367,039 178,429 49 % PUBLIC SAFETY- SUBTOTAL 408,890 . 202,297 206,593 49 % 367,039 178,429 49 % TRANSPORTATION STREET LANDSCAPElrREE MAINTENANCE 468,740 258,036 210,704 55 % 376,187 227,924 61 % TRANSPORTATION-SUBTOTAL 468,740 258,036 210,704 55 % 376,187 227,924 61 % COMMUNITY DEVELOPMENT ENGINEERING 16,850 19,087 (2,237) 113 % 17,942 11,560 64 % COMMUN/TY DEVELOPMENT - SUBTOTAL 16,850 19,087 (2,237) 113 % 17,942 11,560 64 % SUB-TOTAL OPERATIONG EXPENDITURES 894,480 479,421 415,059 54 % 761,168 417,913 55 % TRANSFERS OUT 123,930 (377) 124,307 0% 10,773 GRAND TOTAL EXPENDITURES 1,018,410 479,044 539,366 47 % 771,941 417,913 54 % REVENUES (SOURCE OF FUNDS) OVER/(UNDER) (118,430) 68,663 (187,093) (58%) 120,499 115,895 96 % EXPENDITURES Printed on: 04/79/2011 CITY OF DUBLIN - ~ 1(,~j AGENCY/TRUST FUNDS ~ ~•~ COMPARISON OF REVENUES / VERSUS EXPENDITURES . , FOR THE PERIOD 7/1/2010 THROUGH 3/31/2011 2011 2011 2011 2011 2010 2010 2010 BUDGET ACTUAL VARIANCE• % BUD ACTUAL YTD % '***'***REVENUES/SOURCE OF FUNDING******** PROPERTY TAXES 551,285 336,222 215,063 61 % 363,193 219,807 61 % INTEREST . 2,683 1,099,468 (1,096,785) 40,979 % 758,153 1,012,365 ~' 134 % OTHER REVENUE 710,248 (710,248) 601,719 443,787 74 % SUB-TOTAL OPERATING REVENUES 553,968 2,145,938 (1,591,970J 387 % 1,723,064 1,675,959 97 % GRAND TOTAL REVENUE/SOURCES 553,968 2,145,938 '(1,591,970) 387 % 1,723,064 1,675,959 97 % *****"**EXPENDITURES/TRANSFERS**"""" GENERAL GOVERNMENT NON-DEPARTMENTAL 551,533 615,516 (63,983) 112 % 534,977 448,243 84 % GENERAL GOVERNMENT - SUBTOTAL 551,533 615,516 (63,983) 112 % 534,977 448,243 84 % SUB-TOTAL OPERATIONG EXPENDITURES 551,533 615,516 (63,983) 112 % 534,977 448,243 84 % GRAND TOTAL EXPENDITURES 551,533 615,516 (63,983) 112 % 534,977 448,243 84 % REVENUES (SOURCE OF FUNDS) OVER/(UNDER) 2,435 1,530,422 (1,527,987) 62,851 % 1,188,087 1,227,716 103 %. EXPENDITURES Printed on: 04/19/2011 CITY OF DUBLIN INTERNAL SERVICE FUNDS COMPARISON OF REVENUES / VERSUS EXPENDITURES FOR THE PERIOD 7l1/2010 THROUGH 3/31/2011 2011 2011 2011 2011 BUDGET ACTUAL VARIANCE % BUD ""***"'REVENUES/SOURCE OF FUNDING*"""'"* INTEREST CHARGES FOR SERVICES OTHER REVENUE ~ SUB-TOTAL OPERATING REVENUES TRANSFERS IN GRAND TOTAL REVENUE/SOURCES *'****** E X P E N D I T U R E S/T RA N S F E RS ******"' GENERAL GOVERNMENT NON-DEPARTMENTAL GENERAL GOVERNMENT - SUBTOTAL SUB-TOTAL OPERATIONG EXPENDITURES TRANSFERS OUT GRAND TOTAL EXPENDITURES REVENUES (SOURCE OF FUNDSJ OVER/(UNDER) EXPENDITURES ~~ ~~ 2010 2010 2010 ACTUAL YTD °/a 125,730 114,596 11,134 91 % 191,490 100,915 53 % 2,015,270 1,477,710 537,560 73 % 2,1-14,478 1,571,506 74 % 2,307,860 2,245,195 ~ 62,665 97 % 3,327,235 241,806 7% 4,448,860 3,837,501 611,359 86 % 5,633,203 1,914,228. 34 % 2,032,302 2,032,302 100 % 4,448,860 3,837,501 611,359 86 % 7,665,505 3,946,530 51 % 4,304,706 1,047,338 3,257,368 ' 24 °/a 3,891,331 892,677 23 % 4,304,706 1,047,338 3,257,368 24 % 3,891,331 892,677 23 % 4,304,706 1,047,338 3,257,368 24 % 3,891,331 892,677 23 % 134,856 114,832 20,024 85 % 2,032,303 2,032,303 100 % 4,439,562 1,162,170 3,277,392 26 % 5,923,634 2,924,980 49 % 9,298 2,675,331 (2,666,033) 28,773 % 1,741,871 1,021,550 59 % CITY OF DUBLIN PRO FORMA MONTHLY FINANCIAL INFORMATION FOR THE MONTH OF MARCH 2O11 ` .~ O~ DU~ ti~ ~f~ ~ ~ /// ~ ~11 . 19 ,,.,~ ~ ~~i- 8'Z ~ 1 ~- ~~~IFC~R~~~ Prepared by the Finance Department Presented To City Council May 3, 2011 ~ y y ~ x ~ z y ~ • SUMMARY - All Funds Revenue, Expenditures and Fund Balances 7/1 /2010 - 03/31 /2011 :• DETAIL - By Individual Fund Revenue, Expenditures and Fund Balances 7/1/2010 - 03/31/2011 ~ ` ~ c~ ATTACHMENT 4 ~ City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 201.0 through March 31, 201.1 SUMMARY BALANCE `~` xg~U~GET REVENUES ~ TRANSFERS TOTAL FUNDS ~,_ ~UbG~~~'~D EXPENDITURES TRANSFERS ENDING FUNDS 07/01/2010 ` REUE UES 03/31/2011 ' 03/31/2011 AVAILABLE .E Q~NDITUR 03/31/2011 03/31/2011 BALANCE ~ % ~~ ,~,~'.,a~« ~~ ~~ ~ ~:~a GOVERNMENTAL FUNDS GENERAL General Funds 59,496,258 Sub-Total GENERAL 59,496,258 ' SPECIAL REVENUE Public Safety 329,457 Transportation 2,859,720 Environmental 1,463,966 Parks p Maintenance Assessment Districts 803,704 Culture & Arts 375,002 Health & Welfare 12,900,338 Sub-Total SPECIAL REVENUE 18,732,187 CAPITAL FUNDS Current Capital Projects 9,314 Impact Fees 3,093,957 Sub-Total CAPITAL FUNDS 3,103,271 TOTAL GOVERNMENTAL FUND 81,331,716 INTERNAL SERVICE FUNDS Internal Service Funds 8,761,378 Sub-Total INTERNAL SERVICE FUNDS 8,761,378 AGENCYFUNDS ,Trust Funds 6,103,325 Geologic Hazard Abatement 154,255 Sub-Total AGENCY FUNDS 6,257,580 Grand Total 96,350,674 - ~'~ ~.` a .- aa f ~~ ,. x _ . , ~~s ~~ ~ :s ~ ~ :~~~~ a . ~ ~ ~~~~~~~; 33,899,921 0 93,396,178 ~5;'1,373,9 2 ~ ~ (25,932,386 ) (2,804,521) 64,659,272 33,899,921 0 93,396,178 ~,~ 6~1~378;962~ (25,932,386) (2,804,521) 64,659,272 r , ~ . 540,723 0 870,179 ~r ~~~~6~19 650 (~90,389) 0 579,790 1,125,747 0 3,985,467 ~~r ~3~5 7 D$~~ (273;822) (956,585) 2,755,060 1,550,624 0 3,014,590 `~ ~`~3a990,43~; (1,443,262) (369,121) 1,202,207 674,728 0 674,728 112$;~O6D ~ 0 (744,602) (69,873) 547,707 0 1,351,411 ~ 1,0~18~41p~ (479,421) 377 872,367 87,665 2 130 633 0 0 462,668 15 030 972 ~ ~~"22~~1~0~'` ~~ 1341 0360 0 (7 642 781) (116,473) 0 346,195 7 388 191 , , , , ~ ~ , , , , 6,657,827 0 25,390,014 ~2$,9~9~119~ . ` (10,129,674) (2,186,404) 13,073,937 ~ ~ ~, ~~,~~ ,,, ~~ ~ 0 6,963,608 6,972,922 sx ; ;~~ 16~~'~, ~30„ (6,974,011) 0 (1,089) 6,644,352 0 9,738,309 ~ ~ ~ ~; ~~ T?~~5~'~b7~ ~ (288,672) (1,857,852) 7,591,785 6,644,352 6,963,608 16,711,231 ,~~ 23;646,7$7 (T,262,683) (1,857,852) 7,590,696 , ~a z' ,~.~~-"?..' .m~ . 47,202,100 6,963,608 135,497,423 ~~` 98~968 858' ~ ' (43,324,743) (6,848,776) 85,323,904 ~ ~ ~, ,- ~~ ~~~ ~ y , r~ 3,837,501 0 12,598,879 ~~~ ~ r~ ~39 562: s~ ~.~~.~~~. ~ (1,047,338) (114,832) 11,436,709 3,837,501 0 12,598,879 ~'~;~,<~4;439~562` (1,047,338) (114,832) 11,436,709 1,953,035 0 8,056,360 192,903 0 347,158 2,145,938 0 8,403,518 53,185,539 6,963,608 156,499,821 (609,377) 0 7,446,983 . (6,139) 0 341,019 (615,516) 0 7,788,002 (44,987,597) (6,963,608) 104,548,616 ~ V ~ City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2010 through March 31, 2011 DETAILS BY FUND FUNDS BALANCE 07/01/2010 GOVERNMENTAL FUNDS GENERAL 1001 General Fund 1002 Cemetery Reserve Sub-Total SPECIAL REVENUE Public Safety ~ 2101 Special Criminal Activity Fund 2102 Vehicle Abatement 2103 SLES/COPS Fund - CA 2104 Local Law Enforcement Block Grant - Fed 2106 Tra~c Safety 2107 Federal Asset Seizure Fund 2109 EMS Special Revenue 2111 Enforcement Grants ~ Sub-Total _ Transportation 2201 State Gas Tax 2202 SAFETEA-LU 2204 ACTIA Sales Tax-Local Streets 2205 ACTIA Sales Tax-Bike & Ped 2209 TCRF(Traffic) Congestion Relie~ Sub-Total fnvironmental 2302 Measure D 2303 Garbage Service Fund 2304 Local Recycling Programs 2311 American Recovery & Relnvest. Act. - Env 2321 Storm Water Management 2322 Box Culvert 2323 Dublin / Dougherty 2324 Village Parkway REVENUES TRANSFERS TOTAL FUNDS 03/31/2011 03/31/2011 AVAILABLE EXPENDITURES TRANSFERS ENDING 03/31/2011 03/31/2011 BALANCE . 59,436 258 '~ S~tl 1~Z~6~,424- 33,899,271 0' 93,335,529 ~~'j~,~~3~982~ (25,932,386) (2,804,521) 64,598,622 60 000 y~~ 1 0'~0 649 0 ~ 60,649 x3 '~~ ~p". 0 0 60,649 ~... ~. .~~:~~~ ¢ a2~7,4Zq 33,899,921 0 93,396,178 ~ 59,496,258 ~~ S i ~~~1,3~7~3 5-~~ (25,932,386) . (2,804,521) 64,659,272 , ~ ~~~ ~~ ~ ~ ~~ ~~~ ~ ~ d ~ ~ . e e~ ~ ~, ~-~~i r ~ ~'~ "'~~ ~ , `~~ Y ~;~' , ~ ~ ~~~ _ . 82,053 ~~~ ~65,0 3,981 0 86,034 ~a Y~ ~~ > (1,313) 0 84,721 ~ ~r~~ ~ ~~~g ~. ~ ~ . 186,118 ` ~ 35,~90 29,556 0 215,675 ~` '~'9~,5$0; (387) 0 215,287 ~ 3 , - ~ ~__~ S ~a• ~ . . . 0 ~~~~ p;OQO 61,359 . 0 61,359' ~fr.~0.1Dp,00Q. (61,130) 0 229 8,630 ~ ~ ~ ~''''~~ `~: _ '~`~~`~ p. 84 0 8,714 ~~~ ;~3p (1,058) 0 7,657 ~ 38,799 ~, ~~ 7,p;~'~p ~ 115,587 0 154,386 ~~~ "15?r{~ p` (53,443) 0 100,943 4 504 "~ ~~`~"4Q; 135,698 0 140,202 ~, ~0~ 0 0 140,202 ~ 9 352 {m ^~ 3 6f7pp; 175,278 0 184,631 ~~ ~~„318~860 (164,347) . 0 20,284 ~'~ ~ ~ ,. 0 g~~~' . ,030~ 19,178 0 19,178 v~,a ~,,~M 4;454' (8,711) 0 10,467 ;.~ ~ ,~~, ~:~ . ~,~s~ . ~ 329,457 ~ Q~~~'r45,320 540,723. 0 870,179 ~~ "6'~9~85Q (290,389) 0 579,790 ~ €~~ ~ a, " .~,,~~. + ~sa ~~ ?~~t»~ , s~r~~~~~ ~ 1,25$ 331 ~~'~~~97~;'48 ~ 864,273 0 2,122,605 ~ 'l~,`234,68 ~ (266,413) (543,303) 1,312,889 0 ~~~ ~`~ ~7,g~p ~ 0 ~ 0 ~ 0 ~~6, ~59~ ~ 0 ~ (305,519) (305,519) 656,349 ~-~3,25'~53Q,; 192,677 0 849,026 t' ~~454 R¢0` 0. {51,550) 797,476 x r r~' 499 396 ~`~~~g18;4'1Q 64,145 0 563,540 ~,~~ _ 19~9 p~,07 (7,409) (56,213) 499,919 445 643 z~` `~a i~Q: 4,652 0 450,296 £~422 600 0 0 450,296 ~~~~, ~t~ ~,, ,~"~,~ ~.. 2,859 720 ~ ~'2;6$8,960 1,125,747 0 3,985,467 ~ ' ~~5~a7~,(}93 , (273,822) (956,585) 2,755,060 . '~ .e,~ .. '"~ > ~ ~ . A ~„~' .~~i" ~ _ ~ . - ua~vsr 251,800 ~ 42D~,240~ 76,745 0 328,544 ,~ ~28~,950 (164,310) 0 164,234 57,411 r ,~z~ ~ ~ ~'~~,~~ 2,213,39~t1~ 1,407,009 0 1,464,420 2, 37,040' (1,137,727) 0 326,693 440,994 ~~f~4;275:, 60,301 0 501,296 ~ ~ 195,215• (141,225) 0 360,070 0~~~~ ~~~,~; 1 f~~;700'~ 0 0 ~ 0 ~~ ~"" 186; OQ~ 0 (7,621) (7,621) ~ : ^~- 183 685 ~~`~196;510 832 0 184,517 ~~',~x 996;53!} 0 (361,500) (176,984) ~ ` ~ ~~~ ~ 343 882 ~ ° 5~860° . 3,722 0 347,604 ~ ~°~ 80,OQOy 0 0 347,604 ~ 106 034 `~ "~ ~ 0' 1,148 0 1 p7,1 g2 ~"~ ~~' ~ ~~° ~S;OOQ 0 0 107,182 80,160 '~A ~~ ~~; p 868 0 81,028 ~n~g ~'~'Q~ 0 0 81,028~ ~~: ~~`~ ~,~, ,~. ,. ~-.. : City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2010 through March 31, 2011 DETAILS BY FUND BALANCE -~BU~~~TEL~ REVENUES TRANSFERS TOTAL FUNDS : ~ TE EXPENDITURES TRANSFERS ENDING FUNDS ,.07/01/2010 ~~ aRE~I.~~S 03/31/2011 ' 03/31/2011 AVAILABLE X ~~e~~'~~~`C~I~~ 03/31/2011 03/31/2011 ' BALANCE ce~ ; P ~ ~`„ ,3,f;~,~. , d„~', ~. ' ~w R ~:~ :~ ~.'~. A. ~ ,s <,, a.z eea . GOVERNMENTAL FUNDS ~ ~~~ ~? `~ N ~~ ' ' `~ ~ ~~~~ ~ , , , ~ . . SPECIAL REVENUE °' M~, ~ ~~" ~ y ~~ °t 3~;~a~ ~a' ~s,`~a ~~` :~ Sub-Total 1,463 966 '~;~ 2g869 97t5' 1,550,624 0 3,014,590 ~ ~990~39 (1,443,262) (369,121) 1,202,207 ~ ~~ ~ i~~ ~,~1 ` Parks ~~ ~ ~ F,~ ~~r: 2402 East Bay Regional Park District 0 ~~~77'1 06~0, 674,728 0 674,728 . ~~~1,;~~26;b 0,' 0 (744,602) (69,873) ~,~_ .,~~~.. ~c~.~~i' Sub-Total 0 ,, ~~7~7'I;b~Q 674,728 0 674,728 ~~~,'~~~~6~~G0' 0 (744,602) (69,873) Maintenance Assessment Districts ~~,~~~ ~~~~^4 E~ ~~ ~. ;f9 ) - 2701 Street Light District 1983-1 151,673 :~~2 , 8~ 172,585 0 324,258 ~~~ ~29~,~ (148,127) 0 176,131 2702 Landscape District Stagecoach 1983-2 29,360 ~,~ ~ D~,2Z0 39,549 0 68,909 a~~~ 74,S7Q" (41,228) 0 27,680 a r a ~' 2703 Landscape District Dougherty 1986-1 ~ 85,711 ~" ~`~~a ~t~~~~3gp 56,969 0 142,680 •~ ~7Q~8~~U. (54,843) 0 87,837 2704 Landscape District Santa Rita 1997-1 191 985 ,~k~~266~7~40 162,348 0 354,332 30'1,780y (171,407) 0 182,925 2705 Street Light District East Dublin 1999-1 344 975 :~ 197~980 116,257 0 461,232 ;~~~;~s~4Q,61~Q~ (63,815) 377 397,794 ~~ ~_ .~~>,> ~. Sub-Total 803704 ~,~ ~ 899;~80~ 547,707 0. 1,351,411 ,~ ~~1~30~1~,~1d (479,421) 377 872,367 ~ , Culture & Arts ~ ~ ~ ~~ ~ h~ ~ ~ ~ 2801 PublicArt Fund ~ 375 002 ~«~~ ~~~~87`;`45~ 87,665 0 462,668 ~~; . 7 1~0 0 (116,473) 346,195 . ~.,.~^~~_~~~~ ,~ E, ~~ti~~r. , Sub-Total 375002 ~~ ~$7~,;450' 87,665 0 462,668 c 327,167v 0 (116,473) 346,195 Health 8 Welfare *r~~ ~ : ''~ ~ ~~ ~~ ~~- ' ~.a ~~ x° 2901 Affordable Housing Fund 12,838 676 K~ ~1~91:2y2a0 2,085,267 0 14,923,943 ~~ ~ 13~3e34~~9Q° (7,592,272) 0 7,331,671 2902 Noise Mitigation Fund 61,662 ~fi~~~ 1,SSb 4,490 0 66,152 ~~~ ' ~;C! 0 0 66,152 2903 Communit Develo ment Block Grant 0 93'170;~ 40,877 0 40,877 ~'~i ) Y P = „~~.__ ,:, ',~~ __,;. ~ ~6,07b, (50,509) 0 (9,632 Sub-Total 12,900 338 ~~,.~2;00~6;960.; 2,130,633 0 15,030,972 '~~°~~3~,410 ~60 (7,642,781) 0 7,388,191 CAPITALFUNDS s~~ ~ ~"~~ ~~~ Y~~' ~ ~ ~~~~`~ ~ ~~ ~ ~ Current Capital Projects ; ~~~ . ~ ~;~ ~~ , 3300 General Improvement CIP Projects 0 °' ~ 1 9U7~77$' 0 404,525 404,525 2 0`i~2~03~~ (404,525) 0 0 3400 Community Improvement CIP Projects 0 ~ ~~44~d9~7~ 0 141,260 141,260 ~~~ ~,d57;11Q` (141,260) 0 0 3500 Parks CIP Projects 0~~~=~~,3,Z22,802 0 3,387,844 3,387,844 ~;'~" 4~6~ 975: (3,387,844) . 0 0 3600 Streets CIP Projects 9,314 ~~ 10~ b2 6;822" 0 3,029,980 3,039,294 ~`z 9~;910,609; (3,040,382) 0 (1,089) ~ ~` " '~ ~ .~ ~~~~~ ~~~_~.< Sub-Total 9 314 ~~ 15,836,~899 0 6,963,608 6,972,922 ~~~ 16;5~'~;63U (6,974,011) 0 (1,089~ ~ ~ ~' z~~~~ ~ ~ . IMPACT FEES ~;~~~,~~. ~~°-~~ ~ ~x , r ~ ~ '~ ~ ' ~ ~~ ° x~~rre~ ~ s ;~~ .,. _.. . «... ~a'e~~ _,`~~' City of Dublin All Funds - Revenue, Expenditu~es and Fund Balances July 01, 2010 through March 31, 2011 DETAILS BY FUND BALANCE •~UpG~TEQ REVENUES ' TRANSFERS TOTAL FUNDS ~~`~ULIGE~EI~ EXPENDITURES TRANSFERS ENDING FUNDS 07/01/2010 ~~REVENU~ES 03/31/2011 03/31/2011 AVAILABLE E PENDITI! E~ 03/31/2011 03/31/2011 BALANCE ~ ~ ~ ,~~~{ ~. h _ ' . ~~~"`§ a ed~a ~ . ~~ ~' £~ "x'.:~~ ~{ ~ ~~ . . GOVERNMENTAL FUNDS IMPACT FEES Public Facility 4100 Public Facility Fees Sub-Totai Fire 4201 Fire Impact Fees Sub-Total Traffic 4301 EDTIF Category 1 4302 EDTIF Category 2 4303 EDTIF Category 3 4304 West Dublin TIF 4305 Dougherty Valley TIF 4306 MD 4307 Fallon Interchange Advances n 4309 Mitigation Contributions Sub-Total INTERNAL SERVICE FUNDS 6101 Police Vehicles 6102 Fire Vehicles 8 Apparatus 6103 Non-Safety Vehicles 6201 Buildings 6301 Equipment 6501 Maintenance & Repairs 6901 Retiree Health , . 6951 PERS Side Fund Payoff Sub-Total , AGENCYFUNDS TrustFunds 5101 Dublin Blvd Extension TrusUAgency (1,808,886) 4,260,531 4,260,531 67,262 67,262 0 (182,789) 2,717,699 0 (182,789) 2,717,699 0 0 (1,741,624) 0 0 (1,741,624) (280,000) 25,517 956,910 0 (27,382) 586,142 0 (751,067) 1,512,071 0 (251) 381,338 0 (5,240) 1,356,791 (8,672) , (498,933) 99,463 0 (9,720) 181,467 0 (407,986) 1,541,528 . (288,672) (1,675,063) 6,615,710 ~ #~~~~ 0 2,900,488 ~~ ~~~ 36~~966, ~ &.~;'n~~ ~'.l~ 3!°'. 0 2,900,488 , ~~~<»384;,968.; ~~ ~ ~ P; a ~~ ~ 0 (1,741,624) , ~~, `~ ~ ~ ~ ~Q 0 (1,741,624) } ~~ "~~0~ 575,982 ~~60d~04~0 635,412 0 1,211,393 349,944 a ~ = ,~29~2;300 263,580 0 613,524 2,240 685 r ~ ~ ~, ~ y27;30Q, 22,453 0 2,263,138 210606 y '33~7~510~ 170,983 0 381,589 539 565 ` z'~~8~7,690~ 822,467 0 1,362,032 227,048 232,6F10 380,021 0 607,069 189,222 ,~ `~'s~; ~~~Q'" ~;~ 1,965 0 191',187 ~ 1,929,834 ~~, 1 ~~ 26;820' _*~- ~~;~ ~. 19,680 0 1,949,514 6,262,885 ~~_'~~2;338,2~ff, 2,316,560 0 8,579,445 655129 ~~ `°~ 196;610 2,025 968 ~ ~ 190 OOQt ~ 141 838 .~~' ~~ ` ~,2~8~6~ 0 6,454,471 ~ '~ 2~ f 8;$70' <~~~~ 2,025,205 ~~~, 402,'I5,0° 89,986 ~~ 282 94Q~ 11,627 ~~:~ 3 8,7 ~640; ~ (2,642,846) ~'~ c305~040~ ~ *~~~' ~ 8,761,378 '~,,~~4!,4~48~$60~ 262, 328 164,431 0 819,560 ~~~~~'~ 404~ 3'~Q (68,879) ~ ~ 137,775 0 2,163,744 ~"~ ' 4b3~6~40 0 22,330 0 164,168 ~~ `~ ~27,57Q 0 2,158,846 0 8,613,317 ~~ 1;890,6~ x 0 291,611 0 2,316,816 ~ ~~'` ~707;42Q: (87,096) ~' ~~+~._, 198,366 0 288,352 ~ ~~"~386~140' (248,901) 642,462 0 654,088 ~ " 869,95Q~ (642,462) 221,679 0 (2,421,166) ~ ~~~` d 0 ~ ~ 3,837,501 0 12,598,879 ~ ~ ,:4,43,,9,562,~ ~ (1,047,338) 146,861 0 409,190 (227,827) 0 750,681 0 2,163,744 0 164,168 (82,856) 8,530,461 (31,976) 2,197,744 0 39,451 0 11,627 0 (2,421,166) (114,832) 11,436,709 -,~. ~ 0 1 S 1, 363~ ~ City of Dublin All Funds = Revenue, Expenditures and Fund Balances July 01, 2010 through March 31, 2011 DETAILS BY FUND BALANCE r~, BUIS~G~~'~D. REVENUES TRANSFERS TOTAL Fl1NDS ;; B`,Q E7~Q EXPENDITURES TRANSFERS ENDING FUNDS . 07/01/2010 ~' R~~/~NUEs 03/31/2011 03/31/2011 AVAILABLE E~H D~T'~RE~ 03/31/2011 ' 03/31/2011 BALANCE ~ ~ ' a~"` `~~ ~., ~~ ~~ ~ ~e ~~;c AGENCY FUNDS ~;3 ~~`~~~y; {YE, , HE ~ , ~~ „ ~ a, Trust Funds ' ~; ~ ' ~ r~ ~` ~ ~ ~ ~: 5171 CERBT (OPEB) Trust Fund 5,840 997 ~~ ,~~ ~ p 1,506,174 0 7,347,170 ~ ,~~$1 y4 0 (233,727) 0 7,113,444 5198 ACAP - ASSOCIATED COMMUNITY PcCTION PROGR 0~~;~ ~~ 0` 300,000 0 300,000 :~~ _~~~ ~4 Q (147,824) 0 152,176 s ~ _. . . ... ;, ~,N .~ ; ~~ ~ :~ ~.~ 3~ ~ , _ a~._, Sub-Total ~ 6,103 325 ; ~26D;198 1,953,035 0 8,056,360 ~, ~541,223; (609,377) 0 7,446,983 Geotogic Hazard Abatement ~ ~~ ~ ~ ~ ~`~ '~ ,~ ~ ~~~ ~ 5301 Fallon Village GHAD 43 222 ~ ' 93 pSU; ~ 78,010 0 121,232 ~~~~ ~~"`~'~ 5 (2,835) . 0 118,397 5302 Schaefer Ranch GHAD 111,033 ~~ A 2flD 72d~ 114,892 0 ~. 225,925 ~~ D$~; (3,304) 0 222,622 ~ X ~ ~~k~~ Sub-Total 154 255 >> ~,~ ~~93;'~i70" 192,903 _ 0 347,158 , ~~~10: (6,139) 0 341,019 ~_ ~ ~~~~: ~Q ~,. a~ ~ ~~.~ z.=~~ Grand Total 96,350,674 ~taq~8~~,'983;206 53,185,539 6,963,608 156,499,821 4~~7'~'13~96~J953,- (44,987,597) (6,963,608) 104,548,616 ~ ~~~ s ~ ~