The URL can be used to link to this page

Home My WebLink AboutItem 4.07 Qty Finance Report~~~~ O~' DU~~~G /// ~ 111 1`~~~~z ~ ~ ~~LIFOR~~~ / STAFF REPORT C I T Y C L E R K DUBLIN CITY COUNCIL File #^ 3~ 3^~-~5 ~ DATE: May 4, 2010 TO: Honorable Mayor and City Council Members FROM: Joni Pattillo, City Manager SUBJE • Quarterly Financial Report For The Period Ending March 31, 2010 (3~d Quarter) Prepared By: Vivian Gong, Finance Manager and Paul S. Rankin, Administrative Services Director EXECUTIVE SUMMARY: The City Council will be presented with information related to the revenue and expenditures through the end of the third quarter of fiscal year ending June 30, 2010. The report also includes fund balance information. Based on the completion of three quarters of the year 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. ~ ~C~~~ Submitted By: Administrative Services Director DESCRIPTION: Reviewed Assistant City Manager The focus of the financial analysis will be on the General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. The analysis offered in this Staff Report will also focus on the March 2010 data which is the most recent information available. In the coming months Staff will be assessing additional format changes to the Quarterly Reports in order to enhance the presentation of financial information. At this time the report format follows more closely with the "old" monthly report format. Page 1 of 5 ITEM NO. ~• Analvsis of March 2010 Revenue and Expenditure Reports The Third Quarter report (Attachments 1- 3) represents the reporting of revenues and expenditures for nine months of Fiscal Year 2009/2010 (July 1, 2009 through March 31, 2010). This represents the 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 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 basis and therefore, expenditures incurred during the first several months 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 2010 represented 67% 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 first nine months of the previous Fiscal Year in which the City collected 64% of its total General Fund revenue. Perhaps of greater significance is the fact that the first 9 months of the current year amounted to approximately $30.26 million compared to approximately $33.4 million in the previous year. In order to place the year to date trends in context, Table 1 below also includes: the Current Year Budget, Prior Fiscal Year Total and the Difference. This can be important given that in Fiscal Year 2009/10 not all revenue categories were expected to increase. Therefore a decrease in year to date collections may be consistent with the adopted Fiscal Year 2009/2010 Budget and Financial Plan. On April 6, 2010 the City Council also approved Mid-Year Budget Adjustments, which are not reflected in the third quarter report. As part of the analysis significant mid-year changes are discussed. Table 1: Summary of Significant General Fund Revenue Differences For Amounts Collected July - March 2010 vs. July - March 2009 REVENUE YTD March 2010 YTD March 2009 DIFFERENCE FY 09/10 More / (Less) FY 08/09 EXPLANATION Property $13,292,589 $13,732,059 $(439,470) Approximately 54% of the decrease (or Tax $237K) was from the collection of current year secured property tax. This reflects the adjustments to assessed values initiated by the Assessor to reflect market conditions. The remaining decrease occurred primarily in Supplemental Property Taxes, which reflects decreased sales prices as well as fewer property sales. In Fiscal Year 2009/10 these decreases were partially off set by the increases in collection of prior year taxes and penalties for late payment. This reflects some of the activity by banks to ANNUAL ACTUAL proceed with foreclosure and bring the BUDGET PRIOR YR DIFFERENCE accounts current. $21,467,750 $23,164,422 ($1,696,672) Page 2 of 5 REVENUE YTD YTD DIFFERENCE March March FY 09/10 EXPLANATION 2010 2009 More / (Less) FY 08/09 Sales Ta~c/ $7,734,301 $7,193,826 $540,475 A majority of the variance was due to a In-Lieu timing difference in the recording of the Sales Tax current year Sales Tax In-Lieu payment of $670,650 for the current period. Excluding that item, collection from Sales tax has decreased $130,175 compared to prior year. Although current information on October / November / December retail sales suggest an increase from the same quarter in 2009, the 2009 results reflected historically low sales. The overall budget ANNUAL ACTUAL for 2009/2010 is still projected to be less BUDGET PRIOR YR DIFFERENCE than the amount collected in the previous $10,652,100 $12,001,338 ($1,349,238) year. Transient $339,424 $397,593 ($58,169) The revenue in this category typically Occupancy follows the trend of the economy and has Taxes declined due to lower hotel occupancy rates. Collection is tracking at 59% of the current budget. A budget reduction of $91,000 was approved by the City Council on April 6, 2010, which reduces the budget ANNUAL ACTUAL to $484,000. Based on the reduced BUDGET PRIOR YR DIFFERENCE budget the amount collected through $575,000 $577,057 ($2,057) March is 70% of the Mid-Year adjusted bud et. License $1,704,089 $1,344,485 $359,604 Recent activity in residential Building and Permits has resulted in a positive variance. Permits This is a significant change from the data 'I available with the preparation of the Mid- ~ Year Budget Adjustment which decreased the budget by a net amount of $10,000. The increase in revenue collected through March of 2010 compared to the prior year occurred in three permit revenue types: $262,000 in Building Permits, $43,600 in Construction and $18,000 in Demolition Permits. Staff will be evaluating the longer term of some of these changes to determine if we can expect a decrease in anticipated permits in Fiscal Year 2010/2011. Permits obtained late in the fiscal year also have expenditure impacts in the subsequent year. The revenue is recognized in one year and expenses for ANNUAL ACTUAL building inspection services are incurred in BUDGET PRIOR YR DIFFERENCE a subsequent year. $1,649,160 $1,623,029 $26,131 Page 3 of 5 REVENUE YTD YTD DIFFERENCE March March FY 09/10 EXPLANATION 2010 2009 More / (Less) FY 08/09 Interest & $1,031,947 $1,683,952 ($652,005) The variance was due to the declining Rentals investment yield rates. Interest income decreased by $712,000 compared to prior year, which was partially offset by the increases in rental income (Mid-Year ANNUAL ACTUAL Budget Adjustment of +$30,000) from BUDGET PRIOR YR DIFFERENCE uses of City's facilities. $1,558,707 $2,547,705 ($988,998) Charge for $3,803,151 $4,723,017 ($919,866) The deviation in this revenue category Services can be identified by the primary decreases in development services (approximately $611,000 in Planning, Zoning and Subdivision Fees and $727,000 in ~, Engineering Plan Checking Fees). The charges for Parks and Community Services increased by approximately $242,000 and the collection for Zone 7 fee increased by $190,000 compared to prior year. The current Budget anticipated a decrease for this category. It is tracking at ANNUAL ACTUAL 81 % of the budget. BUDGET PRIOR YR DIFFERENCE $4,718,575 $6,124,947 ($1,406,372) Other $856,330 $2,817,138 ($1,960,808) This category of revenue includes Revenue payments such as contributions, donations, or reimbursement that typically do not follow a specific pattern. The deviation is primarily associated with one time revenue. In the previous Fiscal Year the City received a$1 million Community Benefit payment as provided for in the Wallis Ranch Development Agreement. Also in the prior year the City received $1.5 million from the City of Pleasanton for work related to the Fallon Interchange ANNUAL ACTUAL Capital project. Currently only $383,000 BUDGET PRIOR YR DIFFERENCE was received to date for work incurred on $761,981 $3,183,863 ($2,421,882) this project. The Mid-Year Adjustment decreased this budget by $72,960. General Fund Expenditures Overall, through the Fiscal Year 2009/2010 third quarter ending March 31, 2010, expenditures in the General Fund totaled approximately $23.9 million and represented approximately 46% of the total budgeted expenditures in the General Fund (Attachment 2). Of this amount, a total of $2,369,702 was related to Capital Improvement Projects and the remainder $21,488,012 was Page 4 of 5 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 Operatinq Expenditures (Attachment 2) indicates that through March 2010, expenditures totaled 47% of the Budgeted General Fund expenses. In the same period of the previous year the City expended 59% of the actual total General Fund Expenditures for the year. The primary variance is due to a timing difference of when the contract services bills are received and processed. In the prior year, the first and second quarter payments to Alameda County for Police services totaling $5.8 million were accounted for by the end of the third quarter. To date only payments of approximately $1.7 million for July and August 2009 services have been processed. The variance also reflects decreased expenditures in several divisions as planned for in the adopted budget. The most significant reduction resulted from less contract service costs in Community Development. All expenditures are within the authorized budget. Attachment 3 provides a comparison of Revenue and Expenditures by Major Fund Type (i.e. General Fund; Special Revenue Funds; Assessment District Funds; Agency & Trust Funds; and Internal Service Funds. The breakdowns in these reports provide additional detail in terms of specific department expenditures. Attachment 4 is the monthly report of Fund Balance, in the new format which was introduced at the April 20, 2010 City Council meeting with the January 2010 report. The report captures revenue, expenditures and fund balance in accordance with the reporting requirements of Section 41004 of the California Government Code. NOTICING REQUIREMENTS/PUBLIC OUTREACH: None ATTACHMENTS: 1. March 31, 2010 General Fund YTD (Year-To-Date) Revenues / Budget Comparison 2. March 31, 2010 General Fund YTD (Year-To-Date) Expenditures / Budget Comparison 3. Comparison of Revenues Versus Expenditures (By Fund Type) 4. Monthly Financial Information (Revenues / Transfers / Balances By Fund) Page 5 of 5 l n ~- ~~ City of Dublin 2009-2010 YTD Revenues and Budget Comparison For the Period Ending March 31, 2010 Total General Fund Other Revenues Charges for Services Intergovernmental from State Interest Fines and Forfeitures Licenses and Permits Franchise Taxes Transient Occupancy Taxes Real Property Transfer Tax Sales Taxes 11 % 1 8% 3 I ^ FY 2009/10 g j~° ~ ^ FY 2008/09 44% 0% 30% 60% 90% 120% 150% 75% of Year Complete FY 2009/10 Budget Property Taxes 21,467,750 Sales Taxes 10,652,100 Real Property Transfer Tax 282,000 Transient Occupancy Taxes 575,000 Franchise Taxes 2,215,000 Licenses and Permits 1,649,160 Fines 8 Penalties 140,000 Interest 8~ Rentals 1,558,707 Intergovernmental 1,152,200 Charges for Services 4,718,575 Other Revenues 761,981 Total General Fund Revenues 45,172,473 Date Pnnted: M152010 5:53 PM FY 2009/10 % of FY 2008/09 % of Total for YTD Actual Budget YTD Actual FY 2008/09 13,292,589 62% 13,732,059 59% 7,734,301 73% 7,193,826 60% 228,791 81% 197,261 78% 339,424 59% 397,593 69% 996,897 45% 997,413 46% 1,704,089 103% 1,344,485 83% 115,148 82% 105,060 73% 1,031,947 66% 1,683,952 66% 160,485 14% 184,486 44% 3,803,151 81% 4,723,017 77% 856,330 112% 2,817,138 88% 30,263,152 67°/a 33,376,290 64% ~-~-1 D '-~'•~ ATTACHMENT 1 ao~ i~ City of Dublin 2009-2010 YTD Expenses and Budget Comparison For the Period Ending March 31, 2010 46% Expenses 5 % CIP Projects 3 % o 39 /o 69% 71% 64% 62% 46° o 5 % 63% 63% 33 0 3 % Fire 50% 49% Police 9% 52° 65% 70% ^ FY 2009/10 ^ FY 2008/09 0% 20% 40% 60% 80% 100% 120% 75% of Year Complete FY 2009/10 FY 2009/10 % of FY 2008/09 % of Total for Budget YTD Actual Budget YTD Actual FY 2008/09 General Government 5,904,557 3,824,130 65% 4,149,883 70% Police 13,775,471 2,585,936 19% 6,685,556 52% Fire 10,366,197 5,148,124 50% 4,729,012 49% Other Public Safety 617,246 206,308 33% 200,439 37% Transportation 1,876,783 1,183,543 63% 1,450,639 63% Health and Welfare 84,180 38,322 46% 35,796 55% Culture and Community Services 7,641,634 4,870,718 64% 4,742,089 62% Community Development 5,292,765 3,630,931 69% 4,421,856 71% CIP Projects 6,756,267 2,369,702 35% 4,003,469 39% Total General Fund Expenses 52,315,100 23,857,714 46% 30,418,739 55% General Fund Operating Expenses 45,558,833 21,488,012 47% 26,415,270 59% Total General Fund Community Development Culture & Community Services Health and Welfare Other Public Safety General Government Transportation ~roP~~~,~,p,o,,~AM ATTACHMENT 2 3~F ~`~ CITY OF DUBLIN PRO FORMA COMPARISON OF REVENUES VERSUS EXPENDITURES (BY Fund Type) FISCAL YEAR 2009-2010 QUARTER 3 ENDING MARCH 31, 2010 f~~~ 19~ ~1 ~ v~~ ~ , , ' ,, ,i~~'~ ~~ C~G ,' ` ~ /l. . _.c ~_ Prepared by The Finance Department April 20, 2010 • General Fund - Comparison of Revenue & Expenditures 7/1/2009 - 03/31/2010 • Special Revenue Funds - Comparison Revenue & Expenditures 7/1/2009 - 03/31/2010 • Assessment District Funds - Comparison Revenue & Expenditures 7/1/2009 - 03/31/2010 • Agency Trust Funds - Comparison Revenue & Expenditures 7/1/2009 - 03/31/2010 • Internal Service Funds - Comparison Revenue & Expenditures 7/1/2009 - 03/31/2010 ATTACHMENT 3 Printed on: 04/22/2010 CITY OF DUBLIN Page 1 of 2 GENERALFUND COMPARISON OF REVENUES / VERSUS EXPENDITURES ~~~ ~~ FOR THE PERIOD 7/1/2009 THROUGH 3/31/2010 2010 2010 2010 2010 2009 2009 2009 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % ***"****REVENUES/SOURCE OF FUNDING"""*'"** PROPERTY TAXES 21,467,750 13,292,589 8,175,161 62 % 23,164,422 13,732,059 59 % SALES TAX 10,652,100 7,734,301 2,917,799 73 % 12,001,339 7,193,826 60 % PROPERTY TRANSFER TAX 282,000 228,791 53,209 81 % 254,022 197,261 78 % HOTEL TAX 575,000 339,424 235,576 59 % 577,057 397,593 69 % FRANCHISE TAXES - WASTE MGT 1,090,000 654,729 435,271 60 % 1,057,069 693,329 66 % FRANCHISE TAXES - UTILITIES 1,125,000 342,168 782,832 30 % 1,123,777 304,084 27 % LICENSES & PERMITS 1,649,160 1,704,089 (54,929) 103 % 1,623,029 1,344,485 83 % FINES & PENALTIES 140,000 115,148 24,852 82 % 143,219 105,060 73 % INTEREST 1,236,956 794,205 442,751 64 % 2,308,624 1,511,936 65 % RENTALS & LEASES 321,751 237,742 84,009 74 % 239,081 172,016 72 % INTERGOVERNMENTAL - FEDERAL 200,000 200,000 30,558 1,000 3% INTERGOVERNMENTAL - STATE 952,200 160,485 791,715 17 % 385,449 183,486 48 % CHARGES FOR SERVICES 4,718,575 3,803,151 915,424 81 % 6,128,969 4,723,017 77 % OTHER REVENUE 761,981 856,330 (94,349) 112 % 3,183,863 2,817,138 88 % SUB-TOTAL OPERAT/NG REVENUES 45,172,473 30,263,152 14,909,321 67 % 52,220,476 33,376,290 gq / TRANSFERS IN 19,632 GRAND TOTAL REVENUE/SOURCES 45,172,473 30,263,152 14,909,321 67 % 52,240,108 33,376,290 64 % """"'""'EXPENDITURES/TRANSFERS**"****' GENERAL GOVERNMENT CITY COUNCIL 400,143 238,456 161,687 60 % 236,760 192,877 81 % CITY MANAGER/CITY CLERK 1,118,464 813,863 304,601 73 % 1,153,279 833,547 72 % ELECTIONS 3,620 1,815 1,805 50 % 29,440 30,140 102 % CENTRAL SERVICES/HUMAN RESOURCES 455,645 296,849 158,796 65 % 507,657 379,611 75 % ~NSURANCE 586,427 345,982 240,445 59 % 555,949 359,563 65 % CITY ATTORNEY 556,567 342,062 214,505 61 % 932,239 625,278 67 % ADMINISTRATIVE SERVICES 1,904,702 1,331,223 573,479 70 % 1,763,596 1,229,382 70 % BUILDING MANAGEMENT 750,103 437,706 312,397 58 % 733,902 492,859 67 % NON-DEPARTMENTAL 128,886 16,097 112,789 12 % 11,074 6,625 60 % GENERALGOVERNMENT-SUBTOTAL 5,904,557 3,824,053 2,080,504 65 % 5,923,895 4,149,883 70 % PUBLIC SAFETY POLICE 13,775,471 2,585,936 11,189,535 19 °/a 12,754,923 6,685,556 52 % FIRE 10,366,197 5,148,124 5,218,073 50 % 9,631,598 4,729,012 49 % DISASTER PREPAREDNESS 126,389 62,862 63,527 50 % 106,066 70,374 66 % CROSSING GUARDS 100,830 57,472 43,358 57 % 94,070 51,834 55 % ANIMAL CONTROL 375,620 61,121 314,499 16 % 334,592 71,161 21 % TRAFFIC SIGNALS/STREET LIGHTING 14,407 24,853 (10,446) 173 % 12,739 7,070 56 % PUBLIC SAFETY- SUBTOTAL 24,758,914 7,940,369 16,818,545 32 % 22,933,987 11,615,008 51 % TRANSPORTATION PUBLIC WORKS ADMINISTRATION 906,820 609,065 297,755 67 % 1,102,500 767,217 70 % STREET MAINTENANCE/SWEEP~NG 145,347 82,160 63,187 57 % 188,552 106,846 57 % STREET LANDSCAPElTREE MAINTENANCE 824,616 492,318 332,298 60 % 1,022,297 576,575 56 % TRANSPORTATION-SUBTOTAL 1,876,783 1,183,543 693,240 63 % 2,313,349 1,450,639 63 % HEALTH 8 WELFARE WASTE MANAGEMENT 600 ENVIRONMENTAL SERVICES 26,255 26,255 CHILD CARE 18,500 9,632 8,868 52 % 18,500 9,945 54 % SOCIAL SERVICES 39,425 28,690 10,735 73 % 46,925 25,239 54 % HOUSING PROGRAMS 11 HEALTH 8 WELFARE- SUBTOTAL 84,180 38,322 45,858 46 % 65,425 35,796 55 % Printed on: 04/22/2010 CITY OF DUBLIN Page 2 of 2 GE NERALFUND COMPARISON OF REVENUES / VERSUS EXPENDITURES ~~ ~ +~' FOR THE PERIOD 7/1/2009 THROUGH 3/31/2010 2010 2010 2010 2010 2009 2009 2009 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % '*'*"""'*EXPEN D ITU RES/TRANS F ERS****"** CULTURE & LEISURE SERVICES COMMUNITYN 81,645 80,025 1,620 98 % 78,872 74,134 94 % LIBRARY SERVICES 820,311 432,659 387,652 53 % 873,318 429,552 49 % PARK MAINTENANCE 1,939,552 1,058,896 880,656 55 % 2,001,562 1,093,996 55 % HERITAGE & CULTURAL ARTS 846,002 573,199 272,803 68 °/a 962,182 691,335 72 % RECREATION & COMMUNITY SERVICES 3,698,899 2,558,634 1,140,265 69 % 3,439,364 2,273,963 66 % PARKS/FACILITIES DEVELOPMENT 255,225 167,305 87,920 66 % 256,909 179,108 70 % CULTURE 8 LE/SURE SERVICES - SUBTOTAL 7,641,634 4,870,718 2,770,916 64 % 7,612,207 4,742,089 62 % COMMUNITY DEVELOPMENT DEVELOPMENT SERVICES 3,616,067 2,399,229 1,216,838 66 % 4,057,413 2,883,219 71 % ENGINEERING 1,322,198 1,013,184 309,014 77 % 1,947,067 1,401,056 72 % ECONOMIC DEVELOPMENT 354,500 218,517 135,983 62 % 212,270 137,582 65 % COMMUNITYDEVELOPMENT-SUBTOTAL 5,292,765 3,630,931 1,661,834 69 % 6,216,749 4,421,856 71 % SUB-TOTAL OPERAT/ONG EXPENDITURES 45,558,833 21,487,935 24,070,898 47 % 45,065,612 26,415,270 59 % TRANSFERS OUT 2,369,702 (2,369,702) GRAND TOTAL EXPENDITURES 45,558,833 23,857,637 21,701,196 52 % 45,065,612 26,415,270 59 % REVENUES(SOURCEOFFUNDS)OVER/(UNDER) (386,360) 6,405,514 (6,791,874) (1,658%) 7,174,496 6,961,020 97% EXPENDITURES Printed on: 04/22/2010 CITY OF DUBLIN Page 1 of 1 SPECIAL REVENUE FUNDS re COMPA RISON OF REVENUES / VERSUS EXPENDITURES ~ ~ ~' `~ FOR THE PERIOD 7/ 1/2009 THROU GH 3/31/2010 2010 2010 2010 2010 2009 2009 2009 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD ~/, ""*"'•REVENUES/SOURCE OF FUNDING******** PROPERTY TAXES 138,150 87,980 50,170 64 % 141,880 85,387 60 °k~ SALES TAX 459,458 245,599 213,859 53 % 423,203 233,736 55 %~ FINES & PENALTIES 181,000 109,798 71,202 61 % 175,517 123,441 70 % INTEREST 317,547 224,583 92,964 71 % 643,083 448,759 70 % LOAN REPAYMENTS 813,023 (813,023) 750,000 750,000 100 °/a INTERGOVERNMENTAL-FEDERAL 2,923,815 72,453 2,851,362 2% 232,996 171,956 74 % INTERGOVERNMENTAL-STATE 1,473,087 586,914 886,173 40 % 1,346,963 716,408 53 % INTERGOVERNMENTAL - COUNTY 2,562,636 1,006,829 1,555,807 39 % 430,987 227,869 53 °/a CHARGES FOR SERVICES 1,728,625 1,122,858 605,767 65 % 1,643,211 1,041,683 63 % OTHER REVENUE 2,583,512 1,368,023 1,215,489 53 % 93,531 24,337 26 % SUB-TOTAL OPERATING REVENUES 12,367,830 5,638,060 6,729,770 46 % 5,881,371 3,823,576 65 % TRANSFERS IN 6,600 GRAND TOTAL REVENUE/SOURCES 12,367,830 5,638,060 6,729,770 46 % 5,887,971 3,823,576 65 % "**"`**"EXPENDITU RES/TRANSFERS****""* GENERAL GOVERNMENT CITYATTORNEY 51,250 61,045 (9,795) 119 % 59,139 41,605 70 % BUILDING MANAGEMENT 17,515 GENERAL GOVERNMENT - SUBTOTAL 51,250 61,045 (9,795) 119 % 76,654 41,605 54 % PUBLIC SAFETY POLICE 144,120 22,000 122,120 15 % 110,189 109,687 100 % FIRE 384,337 199,256 185,081 52 % 372,963 188,921 51 % TRAFFIC SIGNALS/STREET LIGHTING 339,454 116,161 223,293 34 % 255,909 112,352 44 % PUBLIC SAFETY- SUBTOTAL 867,911 337,416 530,495 39 % 739,061 410,960 56 % TRANSPORTATION PUBLIC WORKS ADMINISTRATION 13,568 1,570 11,998 12 % STREET MAINTENANCE/SWEEPING 389,055 112,381 276,674 29 % 347,011 189,971 55 % TRANSPORTATION-SUBTOTAL 402,623 113,950 288,673 28 % 347,011 189,971 55 % HEALTH 8~ WELFARE WASTE MANAGEMENT 1,855,966 936,120 919,846 50 % 1,763,500 844,346 48 % ENVIRONMENTAL SERVICES 275,700 176,539 99,161 64 % SOCIAL SERVICES 60,503 44,394 16,109 73 % 59,708 50,789 85 % HOUSING PROGRAMS 3,837,263 1,015,745 2,821,518 26 % 1,102,219 798,521 72 % HEALTH & WELFARE- SUBTOTAL 6,029,432 2,172,799 3,856,633 36 % 2,925,427 1,693,656 58 % CULTURE 8~ LEISURE SERVICES PARK MAINTENANCE 5,946 975 4,971 16 % 3,000 1,200 40 % HERITAGE & CULTURAL ARTS 5,000 2,500 50 % CULTURE 8 LEISURE SERVICES - SUBTOTAL 5,946 975 4,971 16 % 8,000 3,700 46 % COMMUNITY DEVELOPMENT ENGINEERING 6,000 6,000 100 % 6,000 6,000 100 % COMMUNITY DEVELOPMENT - SUBTOTAL 6,000 6,000 100 % 6,000 6,000 100 % SUB-TOTAL OPERATIONG EXPENDITURES 7,363,162 2,692,185 4,670,977 37 % 4,102,152 2,345,891 37 / TRANSFERS OUT 5,229,947 (5,229,947) 26,232 GRAND TOTAL EXPENDITURES 7,363,162 7,922,132 (558,970) 108 % 4,128,385 2,345,891 57 % REVENUES (SOURCE OF FUNDS) OVER/(UNDER) 5,004,668 (2,284,073) 7,288,741 (46%) 1,759,586 1,477,685 84 % EXPENDITURES Printed on: 04/22/2010 CITY OF DUBLIN Page 1 of 1 C ASSESSMENT DISTRICT FUNDS r ~ ~ ~ OMPARISON OF REVENUES / VERSUS EXPENDIT URES O FOR THE PERIOD 7/1 /2009 THROUGH 3/31/2010 2010 2010 2010 2010 2009 2009 2009 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % '*******REVENUES/SOURCE OF FUNDING****"'* PROPERTY TAXES 854,868 525,208 329,660 61 % 826,718 488,473 59 % INTEREST 11,232 8,568 2,664 76 % 24,081 14,711 61 % OTHER REVENUE 2,500 12 2,488 0% 10,959 5,012 46 % SUB-TOTAL OPERAT/NG REVENUES 868,600 533,788 334,812 61 % 861,758 508,196 5g / GRAND TOTAL REVENUE/SOURCES 868,600 533,788 334,812 61 % 861,758 508,196 59 % ***""""' EX P E N D I T U R E S/T RA N S F E RS"***"" PUBLIC SAFETY TRAFFIC SIGNALS/STREET LIGHTING 366,998 178,429 188,569 49 % 364,441 208,955 57 % PUBLIC SAFETY- SUBTOTAL 366,998 178,429 188,569 49 % 364,441 208,955 57 % TRANSPORTATION STREET LANDSCAPElTREE MAINTENANCE 437,213 227,607 209,606 52 % 404,374 210,240 52 % TRANSPORTATION-SUBTOTAL 437,213 227,607 209,606 52 % 404,374 210,240 52 % COMMUNITY DEVELOPMENT ENGINEERING 16,135 11,560 4,575 72 % 16,089 12,181 76 % COMMUNITYDEVELOPMENT-SUBTOTAL 16,135 11,560 4,575 72 % 16,089 12,181 76 % SUB-TOTAL OPERATIONG EXPENDITURES 820,346 417,596 402,750 51 % 784,904 431,376 55 % GRAND TOTAL EXPEND/TURES 820,346 417,596 402,750 51 % 784,904 431,376 55 % REVENUES(SOURCEOFFUNDS)OVER/(UNDER) 48,254 116,192 (67,938) 241% 76,854 76,819 100% EXPEND/TURES Printed on: 04/22/2010 CITY OF DUBLIN Page 1 of 1 AGENCY/TRUST FUNDS ~ ~ ~~ COMPARISON OF REVENUES / VERSUS EXPENDITURES O FOR T HE PERIOD 7!1/2009 THROUGH 3/31/2010 2010 2010 2010 2010 2009 2009 2009 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % """""*'REVENUES/SOURCE OF FUNDING""""""` PROPERTY TAXES 219,687 (219,687) 255,872 142,957 56 % INTEREST 825,647 (825,647) (1,277,086) (1,495,908) 117 % OTHER REVENUE 273,399 (273,399) 556,122 400,767 72 % SUB-TOTAL OPERATING REVENUES 1,318,733 (1,318,733) (465,093) (952,184) 205 % GRAND TOTAL REVENUE/SOURCES 1,318,733 (1,318,733J (465,093) (952,184) 205 % ********EXPE N DITU RES/TRANSFERS'"*"""*** GENERAL GOVERNMENT NON-DEPARTMENTAL 447,672 (447,672) 509,342 428,881 84 % GENERAL GOVERNMENT - SUBTOTAL 447,672 (447,672) 509,342 428,881 84 % SUB-TOTAL OPERATIONG EXPENDITURES 447,672 (447,672) 509,342 428,881 84 % GRAND TOTAL EXPENDITURES 447,672 (447,672) 509,342 428,881 84 % REVENUES (SOURCE OF FUNDS) OVER/(UNDER) 871,061 (871,061) (974,434) (1,381,066) 142 % EXPENDITURES Printed on: 04/22/2010 CITY OF DUBLIN INTERNAL SERVICE FUNDS COMPARISON OF REVENUES / VERSUS EXPENDI7 FOR THE PERIOD 7/1/2009 THROUGH 3/31/2010 2010 2010 2010 BUDGET ACTUAL VARIANCE Page 1 of 1 'URES a ~.~%°" ~ s„~~ 2010 2009 2009 2009 % BUD ACTUAL YTD % *****""*REVENUES/SOURCE OF FUNDING""`*""""* INTEREST 181,824 100,915 80,909 56 % 255,009 177,574 70 % CHARGES FOR SERVICES 1,777,031 1,308,575 468,456 74 % 1,955,258 1,452,688 74 % OTHER REVENUE 29,020 241,806 (212,786) 833 % 8,778,663 205,163 2% SUB-TOTAL OPERATING REVENUES 1,987,875 1,651,297 336,578 83 % 10,988,930 1,835,424 ~7 / TRANSFERS IN 2,032,302 (2,032,302) GRAND TOTAL REVENUE/SOURCES 1,987,875 3,683,599 (1,695,724) 185 % 10,988,930 1,835,424 17 % **'*""*EX P E N D I T U RESlTRAN S F E RS~"""~"** GENERAL GOVERNMENT NON-DEPARTMENTAL 3,453,610 887,124 2,566,486 26 % 3,491,356 1,574,340 45 % GENERAL GOVERNMENT-SUBTOTAL 3,453,610 887,124 2,566,486 26 % 3,491,356 1,574,340 45 % SUB-TOTAL OPERATIONG EXPENDITURES 3,453,610 887,124 2,566,486 26 % 3,491,356 1,574,340 45 % TRANSFERS OUT 2,032,303 (2,032,303) GRAND TOTAL EXPEND/TURES 3,453,610 2,919,427 534,183 85 % 3,491,356 1,574,340 45 % REVENUES(SOURCEOFFUNDS)OVER/(UNDER) (1,465,735) 764,171 (2,229,906) (52%) 7,497,575 261,084 3% EXPENDITURES ~~~~ ~~ CITY OF DUBLIN PRO FORMA MONTHLY FINANCIAL INFORMATION (Revenues / Transfers / Expenditures / Balances By Fund) FOR THE MONTH OF MARCH 2O10 (~~ 19 ~~ ~ v~f~ ~ , ' ,, ,,,,' ~ ~~f 8~ 1 ~ ~ r,. _ _.~ ~. Prepared by The Finance Department April 20, 2010 • SUMMARY - All Funds Revenue, Expenditures and Fund Balances 7/1 /2009 - 3/31 /2010 • DETAIL - By Individual Fund Revenue, Expenditures and Fund Balances 7/1 /2009 - 3/31 /2010 ATTACHMENT 4 City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2009 through March 31, 2010 DETAILS BY FUND BALANCE BUDGETED' REVENUES TRANSFERS TOTALFUNDS F3UDCETED EXPENDITURES TRANSFERS ENDING FUNDS 07/01/2009 ' REYENUES AVAILABLE EXPENDITURES BALANCE 03/31/2010 03/31/2010 03/31/2010 03/31/2010 GOVERNMENTALFUNDS GENERAL General Funds Sub-Total GENERAL SPECIAL REVENUE Public Safety Transportation Environmental Parks Maintenance Assessment Districts Culture & Arts Health & Welfare Sub-Total SPECIAL REVENUE CAPITAL FUNDS Current Capital Projects Impact Fees Sub-Total CAPITAL FUNDS TOTALGOVERNMENTALFUND INTERNAL SERVICE FUNDS Internal Service Funds Sub-Total INTERNAL SERVICE FUNDS AGENCYFUNDS Improvement District Geologic Hazard Abatement Sub-Total AGENCY FUNDS Grend Total 59,797,824 45~172r473 30,263,152 0 90,060,976 ' 45s~+;8~~3$ '' (21,488,012) (2,369,702) 66,203,261 59,797,824 ', 45,17?,473 30,263,152 0 90,060,976 ' 45,b~$,$33 (21,488,012) (2,369,702) 66,203,261 381,645 677,685 ' 283,158 0 664,803 $'l8;2S$ s (337,416) 0 327,387 3,618,508 ' 7,~32,103 ' 2,225,370 0 5,843,878 4#2,176 '' (115,011) (4,037,320) 1,691,547 861,077 ', 1,8$1,3$7 ' 1,232,075 0 2,093,151 ' 2,1d0,771 ; (1,117,598) 0 975,553 0 2,145,1'18 865,088 0 865,088 0` 0 (1,149,767) (284,679) 683,205 $68,6p9 ' 533,788 0 1,216,994 82D,348 (417,596) 0 799,398 375,779 6,782 ' 4,856 0 380,635 3,flOtl (975) (6,100) 373,560 12,962,043 5~4,$7~ i 1,027,513 0 13,989,557 ' 3,8~19,476' (1,121,184) (36,760) 12,831,613 18,882,258 ' 13,236,430 6,177,848 0 25,054,106 ' 8,'1$3,508' (3,109,781) (5,229,947) 16,714,378 0 ' 0 0 18,787,406 18,787,406 37,388,405 (18,768,239) 0 19,166 13,846,820 7,6$$,272 ' 3,633,834 0 17,480,654 4$,4~$ ` (588,689) (11,187,756) 5,704,210 13,846,820 T,6$5,272 3,633,834 18,787,406 36,268,060 ' 37,+~3~,$63: (19,356,928) (71,187,756) 5,723,376 92,526,902 ,66,094:'17~ ' 40,068,834 18,787,406 151,383,142 ' 91,17~,204 ' (43,954,722) (18,787,405) 88,641,015 4,536,416 , 1,887~875 ' 1,651,297 2,032,302 8,220,015 ' 3,453,610 ' (887,124) (2,032,303) 5,300,588 4,536,416 ,'1,987,875 ' 1,651,297 2,032,302 8,220,075 ' 3,453,510' (887,124) (2,032,303) 5,300,588 5,043,547 ' 0' 1,232,621 0 6,276,168 ' 0 (444,339) 0 5,831,829 25,946 '~ 86,113 0 112,059 ` 0' (3,333) 0 108,725 5,069,493 p', 1,318,733 0 6,388,227 ` 0: (447,672) 0 5,940,554 02,132,812 '6$,Q$2.050 ` 43,038,864 20,819,708 165,991,384 94,632,$14 ` (45 289 518) (20 819 708) 99 882 157 , , , , , , ~ O ~ -,~ City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2009 through March 31, 2010 DETAILS BY FUND BALANCE 'BUdGETELI REVENUES TRANSFERS TOTALFUNDS BULIGETED' EXPENDITURES TRANSFERS ENDING FUNDS 07/01/2009 ' REYENUES 03/31/2010 03/37/2010 AVAILABLE EXPENpIT11RES' 03/31/2010 03/31/2010 BALANCE GOVERNMENTAL FUNDS GENERAL 1001 General Fund 59,298,576 ' 45,'t61,412 ' 30,256,655 0 89,555,231 45,55$,833 ' (21,488,012) (2,369,702) 65,697,517 1002 Cemetery Reserve 60,000 1,365 ' 781 0 60,781 q' 0 0 60,781 1003 Box Culvert 335,728 7,412 4,369 0 340,097 0 0 0 340,097 1004 Storm Water Units 103,520 2,284 ' 1,347 0 104,867 tI ' 0 0 104,867 Sub-Total 59,797,824 ,45,17~,473' 30,263,152 0 90,060,976 ' 45,3~&$,833' (21,488,012) (2,369,702) 66,203,261 SPECIAL REVENUE Public Safety 2101 Special Criminal Activity Fund 39,775 ~'10 502 0 40,277 'S,25R ' (2,063) 0 38,214 2102 Vehicle Abatement 167,272 $2,7~1 ', 27,635 0 194,907 h,97& (1,046) 0 193,861 2103 SLES/COPS Fund - CA 0 100,QQ0 118 0 118 10Q,Od0 ' 0 0 118 2104 Local Law Enforcement Block Grant - Fed 0 36,89~v 37,012 0 37,012 3fi,895 ' (5,293) 0 31,719 2106 TrafficSafety 103,587 i81,4$5' 111,213 0 214,800 2$8,$Q2 s (116,161) 0 98,639 2107 Federal Asset Seizure Fund 0 :{# 4,462 0 4,462 Q 0 0 4,462 2109 EMS Special Revenue 71,012 , ~10,1,1d 88,618 0 159,630 384,337' (199,256) 0 (39,626) 2111 Enforcement Grants 0 '15,67Q ' 13,598 0 13,598 fl' (13,598) 0 0 Sub-Total 381,645 677,665 ' 283,158 0 664,803 ~18,269 (337,416) 0 327,387 Transportation 2201 State Gas Tax 1,917,667 ' 788,9&3 ' 605,831 0 2,523,499 438,608 (113,442) (638,413) 1,771,644 2202 SAFETEA-LU 0 ' 2,763,243 0 0 0 0' 0 (1,287,147) (1,287,147) 2204 ACTIA Sales Tax-Local Streets 849,068 2,741,2~1 1,544,022 0 2,393,090 Q' 0 (1,820,020) 573,070 2205 ACTIA Sales Tax-Bike & Ped 444,786 1~9,237 ! 70,220 0 515,006 13,56$ (1,570) (2,740) 510,697 2208 Congestion Management Agency 0 ' 166,QOa 0 0 0 p i 0 2 ( 89,000) (289,000) 2209 TCRF(Traffic) Congestion Relie~ 406,987 4S3,4p9 5,296 0 412,284 0 0 0 412,284 Sub-Total 3,618,508 7,032,~p3 2,225,370 0 5,843,878 452,178 ' (115,011) (4,037,320) 1,691,547 Environmental 2302 Measure D 283,926 ' 235,$37 121,338 0 405,264 28d,636 : (159,200) 0 246,064 2303 Garbage Service Fund 20,059 1,688,500 1,104,110 0 1,124,170 1,686,078 ` (858,614) 0 265,555 2304 Local Recyding Programs 557,091 12,07'1 ` 6,626 0 563,718 14~,058: (94,845) 0 468,872 2311 American Recovery & Relnvest. Act. - Env 0 ~,939 0 0 0 4,939 (4,939) 0 (4,939) S b T u - otal 861,077 J,941,347 1,232,075 0 2,093,151 2,14f1,711 (1,117,598) 0 975,553 Parks 2402 East Bay Regional Park District 0 , 2,145,118 865,088 0 865,088 Q 0 (1,149,767) (284,679) Sub-Total 0 2,'[d5,11$ 865,088 0 865,088 0 0 (1,149,767) ~(284,679) ~ -~- City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2009 through March 31, 2010 DETAILS BY FUND FUNDS BALANCE 07/01/2009 BUDG~TED ' REVENUES' REVENUES 03/31/2070 TRANSFERS 03/31/2010 TOTALFUNDS AVAILABLE 6UDGETED EXPENDI7URES EXPENDITURES 03/31/2010 TRANSFERS 03/31/2010 ENDING BALANCE GOVERNMENTALFUNDS SPECIAL REVENUE Maintenance Assessment Districts 2701 Street Light District 1983-1 152,021 267,512 ' 165,297 0 317,318 2'f4,816 ' (123,228) 0 194,089 2702 Landscape District Stagecoach 1983-2 26,321 68,879 ' 37,894 0 64,215 69,2$$ (43,372) 0 20,843 2703 Landscape District Dougherty 1986-1 79,546 1IIQ,992 ' 56,198 0 135,744 1d5,19~ ' (50,599) 0 85,145 2704 Landscape District Santa Rita 1997-1 160,287 2Si$,233 161,845 0 322,132 27Q,$+t~ ', (140,183) 0 181,949 2705 Street Light District East Dublin 1999-1 265,031 177,784 ' 112,555 0 377,585 iQp~1{t2 ' (60,214) 0 317,371 Sub-Total 683,205 868,6Q0 ' 533,788 0 1,216,994 $20,348 ' (417,596) 0 799,398 Culture & Arts 2801 Public Art Fund 375,779 6,7!$2 ' 4,856 0 380,635 3,OQ0 ' (975) (6,100) 373,560 Sub-Total 375,779 6,782' 4,856 0 380,635 3,000' (975) (6,100) 373,560 Health & Welfare 2901 Affordable Housing Fund 12,903,285 461,74T' 1,002,465 0 13,905,750 3,888,513 ' (1,076,790) 0 12,828,960 2902 Noise Mitigation Fund 58,762 Q' 1,784 0 60,546 0 0 0 60,546 2903 Community Development Block Grant (4) ~{Q~,Q&$ , 23,265 0 23,260 60,503 ' (44,394) (36,760) (57,894) Sub-Total 12,962,043 564,$1f> 1,027,513 0 13,989,557 3,9d9,076 ` (1,121,184) (36,760) 12,831,613 CAPITAL PROJECT FUNDS Current Capital Projects 3300 General Improvement CIP Projects 0 0' 0 582,130 582,130 2,$29,510 (581,953) 0 177 3400 Community Improvement CIP Projects 0 , p, 0 13,135 13,135 251,24'[ ' (13,092) 0 43 3500 Parks CIP Projects 0 Q 0 8,885,490 8,885,490 13,47$,855 ' (8,873,835) 0 11,655 3600 Streets CIP Projects 0 fl 0 9,306,651 9,306,651 ' 24,$2$,799 (9,299,359) 0 7,292 Sub-Total 0 0' 0 18,787,406 18,787,406 ', 37,38$.405 (18,768,239) 0 19,166 IMPACT FEES Public Facility 4100 Public Facility Fees 3,796,121 ! 6,'[76,518 2,012,644 0 5,808,765 0 0 (6,415,426) (606,662) Sub-Total 3,796,121 $,176,519 ' 2,012,644 0 5,808,765 0' 0 (6,415,426) (606,662) Fire 4201 Fire Impact Fees (1,841,336) 22T,546 56,712 0 (1,784,624) ~' 0 0 (1,784,624) Sub-Total (1,841,336) 227,546 56,712 0 (1,784,624) 0 0 0 (1,784,624) ~ . w ~ ~ City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2009 through March 31, 2010 DETAILS BY FUND FUNDS BALANCE 07/01/2009 BUQG~TED `REVENUES REVENUES 03/31/2010 TRANSFERS 03/31/2010 TOTALFUNDS AVAILABLE ' BU~GETED' EXPENDITIIRES' EXPENDITURES 03/31/2010 TRANSFERS 03/31/2010 ENDING BALANCE GOVERNMENTALFUNDS IMPACT FEES Traffic 4301 EDTIF Category 1 1,010,671 324,912 528,084 0 1,538,755 2,QSii (463,300) (211,175) 864,280 4302 EDTIFCategory2 2,848,140 1DO,Q76' 149,537 0 2,997,678 0' 0 (2,486,284) 511,393 4303 EDTIF Category 3 2,187,556 ! p' 28,467 0 2,216,023 0' 0 0 2,216,023 4304 West Dublin TIF 208,721 Q', 3,343 0 212,064 4' 0 (299) 211,765 4305 Dougherty Valley TIF 0 6$p,OQQ ' 534,879 0 534,879 0' 0 0 534,879 4306 MD 90,897 1T6r219 ' 267,451 0 358,348 q6~d0$ (22,116) 0 336,231 4307 Fallon Interchange Advances 3,531,085 ' a; 27,953 0 3,559,038 fl 0 (2,056,771) 1,502,268 4308 BART Garage 103,273 q' 0 0 103,273 4~ : (103,273) 0 0 4309 Mitigation Contributions 1,911,693 ' R' 24,764 0 1,936,458 Q' 0 (17,800) 1,918,657 Sub-Total 11,892,035 ` 7,281,20~ 1,564,479 0 13,456,514 48,438 (588,689) (4,772,329) 8,095,496 INTERNAL SERVICE FUNDS 6101 Police Vehicles 0 ~Zi-,25$ ' 193,104 546,628 739,732 $9$,g58 ' (126,660) 0 613,072 6102 Fire Vehicles & Apparatus 2,272,122 ' 223,$24 ! 157,468 0 2,429,590 f72,~$3 ' 0 (469,884) 1,959,706 6103 Non-Safety Vehicles 0 27,573 21,296 112,570 133,866 2T,57S 0 0 133,866 6201 Buildings 1,878,047 '[$8,4?8 ' 135,589 1,373,104 3,386,740 1,8$$,120 0 0 3,386,740 6301 Equipment 3,325,149 ' 4'E4,~8i~ I 264,658 0 3,589,807 562,914 ' (105,559) (1,562,419) 1,921,829 6501 Maintenance & Repairs (2,677) 376,663 ' 291,343 0 288,666 4tf3,46x (198,213) 0 90,454 6901 Retiree Health 9,270 536,851 457,694 0 466,964 ~! ' (456,692) 0 10,272 6951 PERS Side Fund Payoff (2,945,495) , Q, 130,144 0 (2,815,351) 4' 0 0 (2,815,351) Sub-Total 4,536,416 ''1,8$7,$7S' 1,651,297 2,032,302 8,220,015 3,453,610 (887,124) (2,032,303) 5,300,588 AGENCYFUNDS Improvement District 5101 Dublin Blvd Extension TrusUAgency 258,137 p 135,106 0 393,243 0' (227,180) 0 166,063 5171 CERBT (OPEB) Trust Fund 4,785,410 ' i1 1,097,515 0 5,882,925 p (217,159) 0 5,665,766 Sub-Total 5,043,547 p' 1,232,621 0 6,276,168 p (444,339) 0 5,831,829 Geologic Hazard Abatement 5301 Fallon Village GHAD 14,199 `0 ` 19,879 0 34,078 4 (1,667) 0 32 411 5302 Schaefer Ranch GHAD 11,748 Q' 66,233 0 77,981 D' (1,667) 0 , 76,314 Sub-Total 25,946 ',p 86,113 0 112,059 0 (3,333) 0 108,725 Grand Total 102,132,812 88,082,050 43,038,864 20 819 708 165 991 384 94,&32,$14 (45,289,518) (20,819,708) 99,882,157 ~ ^~,. ~ ~ ~0 ~~eycA