The URL can be used to link to this page

Home My WebLink About4.04 Quarterly Fin Reportor 19 82 /ii � 111 DATE: TO: FROM: STAFF REPORT CITY COUNCIL November 20, 2012 Honorable Mayor and City Councilmembers Joni Pattillo City Manager""' CITY CLERK File #320 -30 SUBJECT: Preliminary Quarterly Financial Report for the Period Ending September 30, 2012 (1st Quarter) Prepared by Paul S. Rankin, Administrative Services Director EXECUTIVE SUMMARY: The City Council will be presented with preliminary information related to the revenues and expenditures through the end of the first quarter of Fiscal Year ending June 30, 2013. The annual financial audit field work was completed on October 26, 2012. The auditors have not proposed any audit adjustments at the time the financial reports are prepared. However the beginning balances should be considered preliminary as any final audit adjusting entries will be recorded and included in the City's Comprehensive Annual Financial Report, to be presented in December. Based on the completion of the first quarter of the year, the report will include analysis of significant trends and variances between budgets and actual expenditures. FINANCIAL IMPACT: Detailed financial information can be found within the Staff Report and the Attachments. RECOMMENDATION: Staff recommends that the City Council receive the reports as authorized by Section 41004 of the California Government Code Submitted By Reviewed By Administrative Services Director Assistant City Manager DESCRIPTION: This item provides the report on the preliminary financial statements for the first quarter of Fiscal Year 2012 -2013 (which includes the months of July, August, and September 2012). Consistent Page 1 of 5 ITEM NO. 4.4 with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. 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 Budget 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 first quarter represents 25% 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 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 September 2012 represented 15% of the current budget. By comparison, revenue collected in the first three months of the previous Fiscal Year represented 11 % of its total General Fund revenue. It is typical for the first quarter revenue to be well below the percentage of the year completed. This is due to the fact that major general fund revenues such as property tax and sales tax are not evenly distributed on a monthly basis. 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 is helpful to identify items where a decrease or increase in year to date collections, may be consistent with the adopted Budget and Financial Plan. Page 2 of 5 Summary of Significant General Fund Revenue Differences For Amounts Collected July — September 2012 vs. July - September 2011 REVENUE YTD YTD DIFFERENCE September September FY 2012/13 EXPLANATION 2012 2011 More / (Less) FY 2011/12 Property $ 952,100 $ 903,781 $ 48,319 The majority of the taxes collected to date Tax represent the collection of unsecured property tax. Unsecured Tax is typically paid in a single installment due in September. The increase in Fiscal Year ANNUAL ACTUAL 2012 -2013 represents increased assessed BUDGET PRIOR YR DIFFERENCE valuation associated with the Unsecured $ 827,591 $23,073,950 $22,246,359 Tax Roll. Sales Tax/ $1,420,950 $1,808,413 ($ 387,463) The reported revenue as of September In -Lieu only includes advances based on State Sales Tax estimates. The reconciling payment for first quarter is not received until ANNUAL ACTUAL December. Staff monitors detailed sales BUDGET PRIOR YR DIFFERENCE tax data with the City's Consultant as it ($446,932) $14,550,000 $14,996,932 becomes available. License $ 1,343,401 $ 1,087,636 $ 255,765 The positive variance is related to the and increase in building permit activity. A total Permits of 446 residential units were issued in the first quarter of Fiscal Year 2012 -2013 compared to only 372 permits issued in the same period of the previous fiscal year — an increase of additional 74 permits or about 19 %. Staff will be monitoring ANNUAL ACTUAL development activity and will determine if a BUDGET PRIOR YR DIFFERENCE mid -year adjustment to the adopted ($2,067,946) $2,452,490 $4,520,436 budget is appropriate. Charge for $ 1,597,206 $ 1,300,771 $ 296,435 There are increases and decreases of the Services revenues in this category, and the increase in total revenues was due primarily related to development activities. As of September 2012, the City received an increase of approximately $78,000 in fire plan check /inspection fees and approximately $123,000 in planning and zoning fees compared to the same period ANNUAL ACTUAL of the prior year. The fees collected from BUDGET PRIOR YR DIFFERENCE Parks and Community Services ($1,123,530) $6,566,010 $7,689,540 contributed to the remaining increase. Page 3 of 5 REVENUE YTD September 2012 YTD September 2011 DIFFERENCE FY 2012/13 More / (Less) FY 2011/12 EXPLANATION Other $3,054,062 $ 543,089 $2,510,973 The revenues in this category are typically Revenue one -time or have irregular timing, such as contributions and reimbursements, therefore the revenues do not maintain a specific pattern. Pursuant to certain development agreements the City collected one -time community benefit payments in Fiscal Year 2012 -2013 that ANNUAL ACTUAL were not received in the same period of BUDGET PRIOR YR DIFFERENCE the prior year. ($5,416,160) $7,241,290 $1,825,130 General Fund Expenditures Overall, through the month of September 2012, expenditures in the General Fund totaled approximately $6.2 million and represented approximately 10% of the total budgeted expenditures in the General Fund (Attachment 2). Of this amount, a total of $139,551 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 September 2012, expenditures totaled 11 % of the Budgeted General Fund expenses, which was 1% higher than the percentage of total operating expenditures incurred in the previous year. The total amount of General Fund Operating expenditures for all Departments in the first three months of Fiscal Year 2012 -2013, were approximately $866,000 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 prior Fiscal Year. The largest variance occurred in Community Development (approximately $295,000) which reflects an increase in contract services related to development processing and reimbursable expenses, corresponding to the increases in the collection of development related fees. The Culture and Community Services also incurred an increase (approximately $205,000) related to staffing and contract costs. Increased community events during this period in the current fiscal year also contributed to the increase (such as the All America City Celebration and Splatter). There are also increases in Health and Welfare (approximately $159,000). This relates increased portions of staffing costs in environmental services and contract costs in social services budgeted in the General Fund. Police Services incurred an additional $120,000 of expenditures related to the conversion of police radios to digital units. The City has not received invoices for contract services for Police and Fire through September 2012, so those expenditures have not been recorded. All expenditures are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 of the California Government Code. Page 4 of 5 NOTICING REQUIREMENTS /PUBLIC OUTREACH: None. ATTACHMENTS: 1. General Fund Year to Date Revenues and Budget Comparisons. 2. General Fund Year to Date Expenditures and Budget Comparisons. 3. Comparison of Revenue versus Expenditures by Fund Type. 4. Fund Balances for the Period Ending September 30, 2012. Page 5 of 5 City of Dublin 2012 -2013 YTD Revenues and Budget Comparison For the Period Ending September 30, 2012 Total General Fund Revenues 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 0% 30% 60% 90% 120% 150% 25% of Year Complete FY 2012/13 FY 2012/13 % of FY 2011/12 % of Total for 42 YTD Actual Budget YTD Actual FY 2011/12 I""= Property Taxes 30% 952,100 4% 903,781 4% Sales Taxes 14,550,000 1,420,950 10% 1,808,413 ■ FY 2012/13 17 % 60,841 14% 84,523 �IIIIIIII FY 2011/12 Transient Occupancy Taxes 15% 181,754 21% 154,637 18% Franchise Taxes 0% 188,602 7% 197,817 7% Licenses and Permits 14% 1,343,401 55% 1,087,636 24% Fines & Penalties 11% 30,119 26% 25,008 20% Interest & Rentals 1,077,630 6% 14% 149,268 11% Intergovernmental 181,800 27,910 15% 0 0% Charges for Services 6,566,010 1,597,205 5% 1,300,771 17% Other Revenues 7,241,290 2 % 543,089 30% Total General Fund Revenues 7% 9,006,346 15% 6,254,943 11% 7% 21%o 18° 14% 19 °0 10% JJJJ2% 0% 30% 60% 90% 120% 150% 25% of Year Complete Date Printed 11/9/20129'. 48 AM ATTACHMENT 1 FY 2012/13 FY 2012/13 % of FY 2011/12 % of Total for Budget YTD Actual Budget YTD Actual FY 2011/12 Property Taxes 23,073,950 952,100 4% 903,781 4% Sales Taxes 14,550,000 1,420,950 10% 1,808,413 12% Real Property Transfer Tax 430,000 60,841 14% 84,523 19% Transient Occupancy Taxes 875,000 181,754 21% 154,637 18% Franchise Taxes 2,897,300 188,602 7% 197,817 7% Licenses and Permits 2,452,490 1,343,401 55% 1,087,636 24% Fines & Penalties 115,410 30,119 26% 25,008 20% Interest & Rentals 1,077,630 149,402 14% 149,268 11% Intergovernmental 181,800 27,910 15% 0 0% Charges for Services 6,566,010 1,597,205 24% 1,300,771 17% Other Revenues 7,241,290 3,054,062 42% 543,089 30% Total General Fund Revenues 59,460,880 9,006,346 15% 6,254,943 11% Date Printed 11/9/20129'. 48 AM ATTACHMENT 1 City of Dublin 2012 -2013 YTD Expenses and Budget Comparison For the Period Ending September 30, 2012 Total General Fund Expenses CIP Projects Community Development Culture & Community Services Health and Welfare Transportation Other Public Safety Fire Police General Government 10% 9% 8,278,567 Police 15,222,647 1% 10,868,810 Other Public Safety 623,410 �L2% 2,200,100 Health and Welfare 619,154 Culture and Community Services 22% Community Development 7,609,640 CIP Projects 19% 1,426,110 22% 456,738 21% 296,185 2% 100,992 19% 104,689 1 % 15,438 28% 17,289 4% 361,406 5% 343,110 18% 172,988 16% 13,952 5% 1,806,852 21% 8% 19% 1,676,008 2% 1,381,759 19% 139,551 4% 136,479 2% 6,189,918 1% 5,320,678 9% 6,050,367 1% 5,184,199 10% 3% 2% 8% 22% 0% 20% FY 2012/13 Budget General Government 8,278,567 Police 15,222,647 Fire 10,868,810 Other Public Safety 623,410 Transportation 2,200,100 Health and Welfare 619,154 Culture and Community Services 8,572,397 Community Development 7,609,640 CIP Projects 10,725,400 Total General Fund Expenses 64,720,125 General Fund Operating Expenses 53,994,725 ■ FY 2012/13 uuuu FY 2011/12 40% 60% 80% 100% 120% 25% of Year Complete FY 2012/13 % of FY 2011/12 % of Total for YTD Actual Budget YTD Actual FY 2011/12 1,459,945 18% 1,426,110 22% 456,738 3% 296,185 2% 100,992 1 % 104,689 1 % 15,438 2% 17,289 4% 361,406 16% 343,110 18% 172,988 28% 13,952 5% 1,806,852 21% 1,601,105 19% 1,676,008 22% 1,381,759 19% 139,551 1% 136,479 2% 6,189,918 10% 5,320,678 9% 6,050,367 11% 5,184,199 10% Date Printed 11/9/2012 9 .50 AM ATTACHMENT 2 CITY OF DUBLIN PROFORMA COMPARISON OF REVENUE VERSUS EXPENDITURES (By Fund Type) FISCAL YEAR 2012 -2013 FOR THE PERIOD ENDING SEPTEMBER 30, 2012 (Quarter 1) r LL(\1 LqM v I r IM-6Z APPEAR, - � Prepared by The Finance Department November 7, 2012 • General Fund - Comparison of Revenue & Expenditures 7/1/2012 — 9/30/2012 • Special Revenue Funds - Comparison Revenue & Expenditures 7/1/2012 — 9/30/2012 • Assessment District Funds - Comparison Revenue & Expenditures 7/1/2012 — 9/30/2012 • Agency Trust Funds - Comparison Revenue & Expenditures 7/1/2012 — 9/30/2012 • Internal Service Funds - Comparison Revenue & Expenditures 7/1/2012 — 9/30/2012 ATTACHMENT 3 Printed on: 11/09/2012 CITY OF DUBLIN Page 1 of 2 GENERALFUND COMPARISON OF REVENUES /VERSUS EXPENDITURES FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012 2013 2013 2013 2013 2012 2012 2012 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % REVENUES/SOURCE OF FUNDING*"*"**"* PROPERTY TAXES 23,073,950 952,100 22,121,850 4% 22,246,359 903,781 4% SALES TAX 14,550,000 1,420,950 13,129,050 10% 14,996,932 1,808,413 12% PROPERTY TRANSFER TAX 430,000 60,841 369,159 14% 441,575 84,523 19% HOTELTAX 875,000 181,754 693,246 21% 879,733 154,637 18% FRANCHISE TAXES - WASTE MGT 1,670,000 188,602 1,481,398 11% 1,683,239 197,817 12% FRANCHISE TAXES - UTILITIES 1,227,300 1,227,300 1,291,129 LICENSES & PERMITS 2,452,490 1,343,401 1,109,089 55% 4,520,436 1,087,636 24% FINES & PENALTIES 115,410 30,119 85,292 26% 126,387 25,008 20% INTEREST 553,690 988 552,702 0% 771,567 13,605 2% RENTALS & LEASES 523,940 148,414 375,526 28% 548,408 135,663 25% LOAN REPAYMENTS 16,603 (16,603) INTERGOVERNMENTAL - STATE 181,800 11,308 170,492 6% 196,629 CHARGES FOR SERVICES 6,566,010 1,597,206 4,968,804 24% 7,689,540 1,300,771 17% OTHER REVENUE 7,241,290 3,054,062 4,187,228 42% 1,825,130 543,090 30% SUB -TOTAL OPERATING REVENUES 59,460,880 9,006,346 50,454,534 15% 57,217,064 6,254,943 11% TRANSFERS IN 28,800 28,800 27,760 GRAND TOTAL REVENUE/SOURCES 59,489,680 9,006,346 50,483,334 15% 57,244,824 6,254,943 11% *"** - EXPENDITURES /TRANSFERS"**""**" GENERAL GOVERNMENT CITY COUNCIL 417,520 74,134 343,386 18% 349,649 69,584 20% CITY MANAGER /CITY CLERK 1,333,360 296,271 1,037,089 22% 1,277,736 300,891 24% ELECTIONS 46,120 881 45,239 2% 1,686 CENTRAL SERVICES /HUMAN RESOURCES 541,717 109,504 432,213 20% 515,500 108,757 21% INSURANCE 983,380 318,427 664,953 32% 594,999 253,555 43% CITY ATTORNEY 883,120 59,219 823,901 7% 716,959 130,195 18% ADMINISTRATIVE SERVICES 2,111,200 454,030 1,657,170 22% 1,948,071 417,529 21% BUILDING MANAGEMENT 868,660 142,906 725,754 16% 759,439 123,647 16% NON - DEPARTMENTAL 1,093,490 4,572 1,088,918 0% 291,153 21,951 8% GENERAL GOVERNMENT- SUBTOTAL 8,278,567 1,459,945 6,818,622 18% 6,455,192 1,426,110 22% PUBLIC SAFETY POLICE 15,222,647 456,738 14,765,909 3% 14,660,756 296,185 2% FIRE 10,868,810 100,992 10,767,818 1% 10,287,783 104,689 1% DISASTER PREPAREDNESS 113,810 13,644 100,166 12% 92,395 14,096 15% CROSSING GUARDS 111,890 2,876 109,014 3% 111,843 508 0% ANIMALCONTROL 365,340 (10,869) 376,209 (3 %) 223,353 TRAFFIC SIGNALS /STREET LIGHTING 32,370 9,788 22,582 30% 30,302 2,686 9% PUBLIC SAFETY- SUBTOTAL 26,714,867 573,168 26,141,699 2% 25,406,432 418,163 2% TRANSPORTATION PUBLIC WORKS ADMINISTRATION 932,980 185,754 747,226 20% 832,899 184,920 22% STREET MAI NTENANCE/SWEEPING 180,070 15,034 165,036 8% 140,454 15,137 11% STREET LANDSCAPE /TREE MAINTENANCE 1,087,050 160,617 926,433 15% 953,944 143,053 15% TRANSPORTATION- SUBTOTAL 2,200,100 361,406 1,838,694 16% 1,927,297 343,110 18% HEALTH & WELFARE WASTE MANAGEMENT 154,110 34,289 119,821 22% ENVIRONMENTAL SERVICES 225,490 56,223 169,267 25% 85,717 1,032 1% SOCIAL SERVICES 239,554 82,475 157,079 34% 221,791 12,871 6% HOUSING PROGRAMS 50 HEALTH & WELFARE- SUBTOTAL 619,154 172,988 446,166 28% 307,508 13,952 5% Printed on: 11/09/2012 CITY OF DUBLIN GENERALFUND COMPARISON OF REVENUES /VERSUS EXPENDITURES FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012 2013 2013 2013 2013 2012 BUDGET ACTUAL VARIANCE % BUD ACTUAL *"** - EXPENDITURES /TRANSFERS"**""**" CULTURE & LEISURE SERVICES COMMUNITY TV LIBRARY SERVICES PARK MAINTENANCE HERITAGE & CULTURALARTS RECREATION & COMMUNITY SERVICES PARKS /FACILITIES DEVELOPMENT CULTURE & LEISURE SERVICES - SUBTOTAL COMMUNITY DEVELOPMENT DEVELOPMENT SERVICES ENGINEERING ECONOMIC DEVELOPMENT COMMUNITY DEVELOPMENT - SUBTOTAL SUB -TOTAL OPERATIONG EXPENDITURES TRANSFERS OUT GRAND TOTAL EXPENDITURES REVENUES (SOURCE OF FUNDS) 0VERI(UNDER) EXPENDITURES Page 2 of 2 2012 2012 YTD % 87,150 36,138 51,012 41% 23,244 7,384 32% 564,730 28,746 535,984 5% 573,872 23,754 4% 2,488,630 441,546 2,047,084 18% 2,472,490 414,569 17% 987,110 232,088 755,022 24% 792,244 165,396 21% 4,082,700 986,247 3,096,453 24% 3,925,229 911,909 23% 362,077 82,088 279,989 23% 425,784 78,092 18% 8,572,397 1,806,852 6,765,545 21% 8,212,863 1,601,105 19% 4,673,040 985,314 3,687,726 21% 4,167,692 833,916 20% 2,146,580 536,554 1,610,026 25% 2,551,585 456,762 18% 790,020 154,141 635,880 20% 595,567 91,081 15% 7,609,640 1,676,009 5,933,631 22% 7,314,844 1,381,759 19% 53,994,725 6,050,367 47,944,358 11% 49,624,136 5,184,199 10% 10,725,400 139,551 10,585,849 1% 6,938,330 136,479 2% 64,720,125 6,189,918 58,530,207 10% 56,562,466 5,320,678 9% (5,230,445) 2,816,429 (8,046,874) (54%) 682,358 934,266 137% Printed on: 11/09/2012 CITY OF DUBLIN Page 1 of 1 SPECIAL REVENUE FUNDS COMPARISON OF REVENUES /VERSUS EXPENDITURES FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012 2013 2013 2013 2013 2012 2012 2012 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % REVENUES/SOURCE OF FUNDING*"*"**"* PROPERTY TAXES 152,400 152,400 152,486 SALES TAX 453,560 453,560 468,408 FINES & PENALTIES 141,870 14,930 126,940 11% 158,606 30,387 19% INTEREST 117,980 27,464 90,516 23% 108,538 2,636 2% LOAN REPAYMENTS 111,448 250 0% INTERGOVERNMENTAL - FEDERAL 1,914,660 1,914,660 1,002,227 INTERGOVERNMENTAL - STATE 1,858,950 269,829 1,589,121 15% 2,188,862 233,198 11% INTERGOVERNMENTAL - COUNTY 675,040 57,324 617,716 8% 606,145 26,301 4% CHARGES FOR SERVICES 2,661,250 25,650 2,635,600 1% 2,623,258 19,530 1% OTHER REVENUE 1,618,800 776,918 841,882 48% 1,036,964 20,457 2% SUB -TOTAL OPERATING REVENUES 9,594,510 9,906,993 4,566,123 96% 4,537,255 116,034 50% TRANSFERS IN 6,600 6,600 6,600 GRAND TOTAL REVENUE/SOURCES 2,789,998 9,906,993 4,564,223 96% 4,571,355 116,034 5% *"** - EXPENDITURES /TRANSFERS"**""**" GENERAL GOVERNMENT CITY ATTORNEY 53,780 502 53,278 1% 15,462 9,254 60% GENERAL GOVERNMENT- SUBTOTAL 31,048 386 31,604 9% 93,576 2,635 78% PUBLIC SAFETY POLICE 252,183 103,583 148,600 41% 154,109 9,547 6% FIRE 337,310 2,250 335,060 1% 321,670 643 0% TRAFFIC SIGNALS /STREET LIGHTING 369,986 24,491 345,495 7% 253,566 11,367 4% PUBLIC SAFETY- SUBTOTAL 232,502 918,161 462,937 95% 062,155 69,330 1% TRANSPORTATION PUBLIC WORKS ADMINISTRATION 15,410 1,460 13,950 9% 12,731 1,045 8% STREET MAI NTENANCE/SWEEPING 591,595 47,015 544,581 8% 428,709 45,818 11% TRANSPORTATION- SUBTOTAL 780,883 54,505 334,319 4% 559,558 57,471 99% HEALTH & WELFARE WASTE MANAGEMENT 2,557,310 23,135 2,534,175 1% 2,626,796 32,010 1% ENVIRONMENTAL SERVICES 206,490 2,069 204,421 1% 272,530 40,215 15% SOCIAL SERVICES 90,750 9,057 81,693 10% 77,577 5,763 7% HOUSING PROGRAMS 967,700 51,381 916,319 5% 1,138,054 522,317 46% HEALTH &WELFARE - SUBTOTAL 1,466,638 43,756 1,017,784 6% 5,995,230 788,183 93% CULTURE & LEISURE SERVICES COMMUNITY TV 47,130 17,669 29,461 37% 35,360 PARK MAINTENANCE 2,500 2,500 CULTURE & LEISURE SERVICES - SUBTOTAL 52,718 90,772 19,279 17% 13,178 COMMUNITY DEVELOPMENT ENGINEERING 174,800 6,410 168,391 4% 6,000 COMMUNITY DEVELOPMENT- SUBTOTAL 905,488 7,598 974,129 5% 7,888 SUB -TOTAL OPERATIONG EXPENDITURES 5,666,944 642,868 3,100,265 3% 3,156,371 700,204 910% TRANSFERS OUT 5,123,378 457,877 4,665,501 9% 2,260,949 162,557 7% GRAND TOTAL EXPENDITURES 98,028,166 057,420 98,851,563 0% 0,781,396 458,313 99% REVENUES (SOURCE OF FUNDS) 0VER /(UNDER) (9,942,696) 563,694 (9,795,518) (179/. ) 478,816 (380 ,000) (32° %) EXPENDITURES Printed on: 11/09/2012 CITY OF DUBLIN Page 1 of 1 ASSESSMENT DISTRICT FUNDS COMPARISON OF REVENUES /VERSUS EXPENDITURES FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012 2013 2013 2013 2013 2012 2012 2012 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % REVENUES/SOURCE OF FUNDING*"*"**"* PROPERTY TAXES 985,820 985,820 944,454 INTEREST 11,020 2,183 8,837 20% 10,048 216 2% OTHER REVENUE 2,500 2,500 2,924 SUB -TOTAL OPERATING REVENUES 999,340 2,183 997,157 0% 957,425 216 0% GRAND TOTAL REVENUE/SOURCES 999,340 2,183 997,157 0% 957,425 216 0% *"** - EXPENDITURES /TRANSFERS"**""**" PUBLIC SAFETY TRAFFIC SIGNALS /STREET LIGHTING 465,010 62,423 402,587 13% 418,092 25,513 6% PUBLIC SAFETY- SUBTOTAL 465,010 62,423 402,587 13% 418,092 25,513 6% TRANSPORTATION STREET LANDSCAPE /TREE MAINTENANCE 494,370 62,182 432,188 13% 399,336 67,884 17% TRANSPORTATION- SUBTOTAL 494,370 62,182 432,188 13% 399,336 67,884 17% COMMUNITY DEVELOPMENT ENGINEERING 32,390 32,390 40,722 2,605 6% COMMUNITY DEVELOPMENT- SUBTOTAL 32,390 32,390 40,722 2,605 6% SUB -TOTAL OPERATIONG EXPENDITURES 991,770 124,605 867,165 13% 858,151 96,002 11% TRANSFERS OUT 37,320 37,320 33,541 GRAND TOTAL EXPENDITURES 1,029,090 124,605 904,485 12% 891,693 96,002 11% REVENUES (SOURCE OF FUNDS) 0VER /(UNDER) (29,750) (122,422) 92,672 412% 65,732 (95,786) (14694 EXPENDITURES Printed on: 11/09/2012 CITY OF DUBLIN Page 1 of 1 INTERNAL SERVICE FUNDS COMPARISON OF REVENUES /VERSUS EXPENDITURES FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012 2013 2013 2013 2013 2012 2012 2012 BUDGET ACTUAL VARIANCE % BUD ACTUAL YTD % REVENUES/SOURCE OF FUNDING*"*"**"* INTEREST 106,090 35,950 70,140 34% 158,854 3,955 2% CHARGES FOR SERVICES 3,154,280 711,487 2,442,793 23% 2,785,435 678,846 24% OTHER REVENUE 380,200 117,075 263,125 31% 381,956 120,537 32% SUB -TOTAL OPERATING REVENUES 3,640,570 864,512 2,776,058 24% 3,326,245 803,338 240% GRAND TOTAL REVENUE/SOURCES 3,640,570 864,512 2,776,058 24% 3,326,245 803,338 24% *"** — EXPENDITURES /TRANSFERS"**""**" GENERAL GOVERNMENT NON - DEPARTMENTAL 5,585,170 638,603 4,946,567 11% 4,493,890 509,389 11% GENERAL GOVERNMENT- SUBTOTAL 5,585,170 638,603 4,946,567 11% 4,493,890 509,389 11% SUB -TOTAL OPERATIONG EXPENDITURES 5,585,170 638,603 4,946,567 11% 4,493,890 509,389 11% TRANSFERS OUT 894,597 894,597 143,111 GRAND TOTAL EXPENDITURES 6,479,767 638,603 5,841,164 10% 4,637,001 509,389 11% REVENUES (SOURCE OF FUNDS) 0VER /(UNDER) (2,839,197) 225,909 (3,065,106) (8%) (1,310,756) 293,950 (22V. EXPENDITURES Printed on: 11/09/2012 CITY OF DUBLIN AGENCY /TRUST FUNDS COMPARISON OF REVENUES /VERSUS EXPENDITURES FOR THE PERIOD 7/1/2012 THROUGH 9/30/2012 2013 2013 2013 2013 2012 BUDGET ACTUAL VARIANCE % BUD ACTUAL REVENUES/SOURCE OF FUNDING*"*"**"* PROPERTY TAXES INTEREST OTHER REVENUE SUB -TOTAL OPERATING REVENUES GRAND TOTAL REVENUE/SOURCES *"** - EXPENDITURES /TRANSFERS"**""**" GENERAL GOVERNMENT NON - DEPARTMENTAL GENERAL GOVERNMENT- SUBTOTAL COMMUNITY DEVELOPMENT ENGINEERING COMMUNITY DEVELOPMENT - SUBTOTAL SUB -TOTAL OPERATIONG EXPENDITURES GRAND TOTAL EXPENDITURES REVENUES (SOURCE OF FUNDS) 0VERI(UNDER) EXPENDITURES Page 1 of 1 2012 2012 YTD % 585,030 585,030 462,077 12,160 499,934 (487,774) 4,111% 5,607 (869,738) (15,512 %) 260,384 (260,384) 1,356,350 276,521 20% 597,190 760,319 (163,129) 127% 1,824,033 (593,217) (3394) 597,190 760,319 (163,129) 127% 1,824,033 (593,217) (3394) 9,550 311,418 (301,868) 3,261% 1,496,964 621,343 42% 9,550 311,418 (301,868) 3,261% 1,496,964 621,343 42% 66,500 66,500 66,500 66,500 76,050 311,418 (235,368) 409% 1,496,964 621,343 420% 76,050 311,418 (235,368) 409% 1,496,964 621,343 42% 521,140 448,901 72,239 86% 327,070 (1,214,560) (371V. CITY OF DUBLIN PRO FORMA MONTHLY FINANCIAL INFORMATION FOR THE PERIOD ENDING SEPTEMBER 30, 2012 (Quarter 1) Prepared by The Finance Department November 7, 2012 • SUMMARY — All Funds Revenue, Expenditures and Fund Balances 7/1/2012 — 9/30/2012 • DETAIL — By Individual Fund Revenue, Expenditures and Fund Balances 7/1/2012 — 9/30/2012 ATTACHMENT 4 City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2012 through September 30, 2012 SUMMARY BALANCE BUDGETED REVENUES TRANSFERS TOTAL FUNDS BUDGETED EXPENDITURES TRANSFERS ENDING FUNDS 07/01/2012 REVENUES 09/30/2012 09/30/2012 AVAILABLE EXPENDITURES 09/30/2012 09/30/2012 BALANCE GOVERNMENTAL FUNDS GENERAL General Funds 63,750,029 59,489,680 9,006,346 0 72,756,375 64,720,125 (6,050,367) (139,551) 66,566,457 Sub -Total GENERAL 63,750,029 59,489,680 9,006,346 0 72,756,375 64,720,125 (6,050,367) (139,551) 66,566,457 SPECIAL REVENUE Public Safety 491,305 607,810 33,621 0 524,927 751,833 (130,323) 0 394,603 Transportation 4,027,466 4,140,230 300,657 0 4,328,123 5,460,149 (50,824) (457,877) 3,819,423 Environmental 832,948 3,135,770 19,960 0 852,908 3,302,930 (29,264) 0 823,644 Parks 468 106,950 1 0 469 106,950 0 0 469 Maintenance Assessment Districts 922,009 999,340 2,183 0 924,192 1,029,090 (124,605) 0 799,588 Culture &Arts 376,348 239,400 846 0 377,194 49,630 (17,669) 0 359,525 Health & Welfare 5,226,153 1,370,950 817,030 0 6,043,182 1,118,830 (60,940) 0 5,982,242 Sub -Total SPECIAL REVENUE 11,876,697 10,600,450 1,174,298 0 13,050,995 11,819,412 (413,625) (457,877) 12,179,494 CAPITAL FUNDS Current Capital Projects 0 30,139,134 0 1,289,144 1,289,144 37,020,995 (1,289,144) 0 0 Impact Fees 25,015,923 5,231,690 4,510,480 0 29,526,403 6,484,170 0 (691,716) 28,834,687 Sub -Total CAPITAL FUNDS 25,015,923 35,370,824 4,510,480 1,289,144 30,815,547 43,505,165 (1,289,144) (691,716) 28,834,687 TOTAL GOVERNMENTAL FUNDS 100,642,648 105,460,954 14,691,125 1,289,144 116,622,917 120,044,702 (7,753,136) (1,289,144) 107,580,638 INTERNAL SERVICE FUNDS Internal Service Funds 12,283,548 3,640,570 864,512 0 13,148,060 6,479,767 (638,603) 0 12,509,457 Sub -Total INTERNAL SERVICE FUNDS 12,283,548 3,640,570 864,512 0 13,148,060 6,479,767 (638,603) 0 12,509,457 AGENCYFUNDS Trust Funds 8,548,754 0 758,171 0 9,306,924 0 (311,418) 0 8,995,507 Geologic Hazard Abatement 867,149 597,190 2,148 0 869,297 76,050 0 0 869,297 Sub -Total AGENCY FUNDS 9,415,903 597,190 760,319 0 10,176,222 76,050 (311,418) 0 9,864,804 Grand Total 122,342,100 109,698,714 16,315,955 1,289,144 139,947,199 126,600,519 (8,703,156) (1,289,144) 129,954,899 City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2012 through September 30, 2012 DETAILS BY FUND BALANCE BUDGETED REVENUES TRANSFERS TOTAL FUNDS BUDGETED EXPENDITURES TRANSFERS ENDING FUNDS 07/01/2012 REVENUES 09/30/2012 09/30/2012 AVAILABLE EXPENDITURES 09/30/2012 09/30/2012 BALANCE 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 2106 Traffic 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 2208 Congestion Management Agency 2210 Highway Safety Traffic Reduction Bond 2211 Federal Transportation (TIGER) 2212 ACTC -VEHICLE REGISTRATION FEE Sub -Total Environmental 2302 Measure D 2303 Garbage Service Fund 2304 Local Recycling Programs 2311 American Recovery & Reinvest. Act. - Env 2321 Storm Water Management 2322 Box Culvert 2323 Dublin / Dougherty 63,690,029 60,000 59,489,020 660 9,006,197 150 0 72,696,225 0 60,150 64,720,125 0 (6,050,367) 0 (139,551) 0 66,506,307 60,150 63,750,029 59,489,680 9,006,346 0 72,756,375 64,720,125 (6,050,367) (139,551) 66,566,457 109,171 215,149 0 37,630 108,700 16,710 3,945 1,070 35,010 100,000 141,870 1,110 326,550 2,200 303 543 3,321 15,031 120 14,302 0 0 0 0 0 0 0 0 109,475 215,692 3,321 52,661 108,820 31,013 3,945 44,830 20,720 100,000 142,240 104,533 337,310 2,200 (3,329) 0 0 (24,491) (100,254) (2,250) 0 0 0 0 0 0 0 0 106,146 215,692 3,321 28,171 8,566 28,763 3,945 491,305 607,810 33,621 0 524,927 751,833 (130,323) 0 394,603 1,746,775 1,279,880 270,306 0 2,017,081 1,287,561 (45,581) (19,844) 1,951,656 156,202 1,560,790 0 0 156,202 1,560,790 0 (306,720) (150,518) 843,848 342,030 2,051 0 845,899 790,436 0 (13,453) 832,446 367,965 461,650 421 0 368,386 844,112 (5,243) (51,802) 311,342 0 0 0 0 0 0 0 0 0 515,622 0 2,217 0 517,839 515,070 0 (24,715) 493,124 146,327 292,520 0 0 146,327 292,520 0 (41,344) 104,983 250,727 203,360 25,662 0 276,389 169,660 0 0 276,389 4,027,466 4,140,230 300,657 0 4,328,123 5,460,149 (50,824) (457,877) 3,819,423 36,184 150,850 0 0 36,184 188,690 (21,191) 0 14,993 48,046 2,475,650 117 0 48,164 2,493,860 (2,250) 0 45,914 180,933 19,060 18,487 0 199,420 87,130 (3,323) 0 196,097 13,506 0 0 0 13,506 0 0 0 13,506 25,127 483,250 50 0 25,177 443,250 0 0 25,177 353,098 5,050 875 0 353,973 80,000 0 0 353,973 98,785 1,100 244 0 99,029 5,000 0 0 99,029 City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2012 through September 30, 2012 DETAILS BY FUND FUNDS BALANCE 07/01/2012 BUDGETED REVENUES REVENUES 09/30/2012 TRANSFERS 09/30/2012 TOTAL FUNDS AVAILABLE BUDGETED EXPENDITURES EXPENDITURES 09/30/2012 TRANSFERS 09/30/2012 ENDING BALANCE GOVERNMENTAL FUNDS SPECIAL REVENUE Environmental 2324 Village Parkway 77,269 810 186 0 77,456 5,000 (2,500) 0 74,956 Sub -Total 832,948 3,135,770 19,960 0 852,908 3,302,930 (29,264) 0 823,644 Parks 2402 East Bay Regional Park District 468 106,950 1 0 469 106,950 0 0 469 Sub -Total 468 106,950 1 0 469 106,950 0 0 469 Maintenance Assessment Districts 2701 Street Light District 1983 -1 156,409 277,110 337 0 156,746 318,860 (38,954) 0 117,792 2702 Landscape District Stagecoach 1983 -2 32,938 79,900 67 0 33,004 77,350 (13,354) 0 19,651 2703 Landscape District Dougherty 1986-1 75,320 116,070 168 0 75,488 123,590 (13,937) 0 61,551 2704 Landscape District Santa Rita 1997 -1 243,903 305,700 608 0 244,511 313,850 (34,891) 0 209,620 2705 Street Light District East Dublin 1999 -1 413,440 220,560 1,003 0 414,443 195,440 (23,469) 0 390,974 Sub -Total 922,009 999,340 2,183 0 924,192 1,029,090 (124,605) 0 799,588 Culture &Arts 2801 Public Art Fund 272,941 102,700 676 0 273,617 2,500 0 0 273,617 2811 Cable TV Facilities 103,407 136,700 170 0 103,577 47,130 (17,669) 0 85,908 Sub -Total 376,348 239,400 846 0 377,194 49,630 (17,669) 0 359,525 Health & Welfare 2901 Affordable Housing Fund 5,155,894 1,306,860 815,438 0 5,971,332 1,057,480 (51,883) 0 5,919,449 2902 Noise Mitigation Fund 70,259 2,740 1,591 0 71,850 0 0 0 71,850 2903 Community Development Block Grant 0 61,350 0 0 0 61,350 (9,057) 0 (9,057) Sub -Total 5,226,153 1,370,950 817,030 0 6,043,182 1,118,830 (60,940) 0 5,982,242 CAPITAL FUNDS Current Capital Projects 3300 General Improvement CIP Projects 0 18,185,846 0 92,514 92,514 20,248,099 (92,514) 0 0 3400 Community Improvement CIP Projects 0 86,820 0 2,018 2,018 88,902 (2,018) 0 0 3500 Parks CIP Projects 0 3,869,630 0 534,208 534,208 4,363,114 (534,208) 0 0 3600 Streets CIP Projects 0 7,996,838 0 660,405 660,405 12,320,880 (660,405) 0 0 Sub -Total 0 30,139,134 0 1,289,144 1,289,144 37,020,995 (1,289,144) 0 0 City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2012 through September 30, 2012 DETAILS BY FUND FUNDS BALANCE 07/01/2012 BUDGETED REVENUES REVENUES 09/30/2012 TRANSFERS 09/30/2012 TOTAL FUNDS AVAILABLE BUDGETED EXPENDITURES EXPENDITURES 09/30/2012 TRANSFERS 09/30/2012 ENDING BALANCE GOVERNMENTAL FUNDS IMPACT FEES Public Facility 4100 Public Facility Fees 18,340,076 3,871,210 3,332,265 0 21,672,341 3,977,960 0 (534,208) 21,138,133 Sub -Total 18,340,076 3,871,210 3,332,265 0 21,672,341 3,977,960 0 (534,208) 21,138,133 Fire 4201 Fire Impact Fees (1,358,914) 55,330 23,863 0 (1,335,052) 0 0 0 (1,335,052) Sub -Total (1,358,914) 55,330 23,863 0 (1,335,052) 0 0 0 (1,335,052) Traffic 4301 EDTIF Category 1 1,384,387 328,290 230,356 0 1,614,743 785,370 0 (13,426) 1,601,317 4302 EDTIF Category 2 699,642 133,830 152,306 0 851,948 174,680 0 0 851,948 4303 EDTIF Category 3 1,536,465 16,720 3,807 0 1,540,272 0 0 0 1,540,272 4304 West Dublin TIF 628,002 164,730 57,395 0 685,398 5,270 0 0 685,398 4305 Dougherty Valley TIF 2,356,947 512,190 5,401 0 2,362,348 1,204,270 0 (4,937) 2,357,411 4306 TVTD 228,131 147,550 702,528 0 930,659 0 0 0 930,659 4308 BART Garage 0 1,840 242 0 242 0 0 0 242 4309 Mitigation Contributions 1,201,187 0 2,319 0 1,203,506 336,620 0 (139,145) 1,064,360 Sub -Total 8,034,761 1,305,150 1,154,353 0 9,189,114 2,506,210 0 (157,509) 9,031,606 INTERNAL SERVICE FUNDS 6101 Police Vehicles 754,076 167,550 40,869 0 794,945 404,370 0 0 794,945 6102 Fire Vehicles & Apparatus 2,107,762 176,930 44,283 0 2,152,046 329,270 0 0 2,152,046 6103 Non - Safety Vehicles 171,922 20,890 5,235 0 177,157 77,700 (50,768) 0 126,389 6201 Buildings 8,648,422 228,530 64,259 0 8,712,681 2,670,887 0 0 8,712,681 6301 Equipment 2,416,016 404,500 102,850 0 2,518,866 907,590 (134,517) 0 2,384,349 6401 Parks Replacement Fund 105,368 106,400 26,423 0 131,791 0 0 0 131,791 6501 Maintenance & Repairs 60,372 534,580 125,792 0 186,164 440,750 (85,546) 0 100,619 6901 Retiree Health 14,436 1,651,190 377,773 0 392,208 1,649,200 (367,772) 0 24,437 6951 PERS Side Fund Payoff (1,994,826) 350,000 77,028 0 (1,917,798) 0 0 0 (1,917,798) Sub -Total 12,283,548 3,640,570 864,512 0 13,148,060 6,479,767 (638,603) 0 12,509,457 AGENCYFUNDS Trust Funds 5101 Dublin Blvd Extension Trust/Agency 80,240 0 36 0 80,276 0 (189,053) 0 (108,777) AGENCYFUNDS Trust Funds 5171 CERBT (OPEB) Trust Fund 5198 ACAP Sub -Total Geologic Hazard Abatement 5301 Fallon Village GHAD 5302 Schaefer Ranch GHAD 5311 FALLON VILLAGE ANNEX /JORDAN RANCH 5321 FALLON CROSSING GHAD /N. TASSAJARA Sub -Total Grand Total City of Dublin All Funds - Revenue, Expenditures and Fund Balances July 01, 2012 through September 30, 2012 DETAILS BY FUND 8,370,747 0 97,767 0 8,548,754 0 757,728 0 9,128,475 0 (120,333) 0 9,008,142 407 0 98,174 0 (2,033) 0 96,141 758,171 0 9,306,924 0 (311,418) 0 8,995,507 336,164 260,970 833 0 336,997 7,050 0 0 336,997 530,985 327,870 1,315 0 532,301 66,500 0 0 532,301 0 3,360 0 0 0 0 0 0 0 0 4,990 0 0 0 2,500 0 0 0 867,149 597,190 2,148 0 869,297 76,050 0 0 869,297 122342,100 109,698,714 16,315,955 1,289,144 139,947,199 126.600.519 (8,703,156) (1,289,144) 129,954,899