Loading...
HomeMy WebLinkAbout4.09 Financial Report March April 07of' 061 CITY CLERK File # ❑�®E-❑ o1 AGENDA STATEMENT CITY COUNCIL MEETING DATE: May 15, 2007 SUBJECT: Financial Reports for the Month of March And April 2007 Report Prepared by: Paul S. Rankin, Administrative Services Dir.evr , ATTACHMENTS: 1. Period Ending March 31, 2007 a) Year To Date (YTD) Revenues and Budget Comparison b) YTD Expenses and Budget Comparison c) March 31, 2007 Financial Statements 2. Period Ending April 30, 2007 a) Year To Date (YTD) Revenues and Budget Comparison b) YTD Expenses and Budget Comparison 11J/ c) April 30, 2007 Financial Statements RECOMMENDATION. Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the months of March 2007 and April 2007. Due to a staffing vacancy two months of reports have been combined in one Staff Report. 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. The analysis offered in this Agenda Report will also focus on the April data which is the most recent information available. Analysis of April 2007 Revenue and Expenditure Reports The April reports represent the reporting of revenues and expenditures for the first ten months of the Fiscal Year, through April 30, 2007. It should also be noted that there is not an even distribution of revenues and expenditures on a monthly basis. There is also a lag with the reporting of expenditures due to the significant amount of services provided to the City by independent contractors, including Police and Fire Services. General Fund Revenues Total General Fund Revenues collected through April are slightly more, based upon the percentage collected, to what occurred through the first quarter of the previous Fiscal Year. Through April 2007, the City had collected approximately 81% of the total budgeted General Fund Revenues, which was 1% more than the percentage collected in the same period of the prior Fiscal Year. This remains unchanged from the condition reported for the month of February. Although on a percentage basis the revenues are tracking according to the budget, there are deviations in terms of dollars collected in several categories. The following summarizes some of the more significant deviations from the prior year. ------------------------------------------- - - - - -- ---------------------------------------------------- - - - - -- C COPIES TO: Page 1 of 3 GAMonthly Financials\FY 06- 07 \Mar_Apri12007.doc ITEM NO. 4+ Summary of Significant General Fund Revenue Differences For Amounts Collected Julv - April 2007 vs July - April 2006 REVENUE YTD YTD DIFFERENCE April 2007 April 2006 2007 More / EXPLANATION Less Than 2006 Property Tax $15,877,669 $14,899,206 $ 978,463 Increases in assessed values as well as the elimination of ERAF III. There is also a timing difference in the City / County Property Tax sharing. As reported earlier in the mid -year report property tax revenue in 2006/07 is expected to exceed the budgeted amount. Sales Tax $11,396,854 $10,152,862 $1,243,992 The current amount reported is distorted due to a change in the final accrual methodology used at year end. Also, there is a difference in timing between the two years. In 2006 the City received its second in -lieu sales tax payment in June. In 2007 the payment was received in April and totaled $1.853 million. As previously reported total sales tax is expected to be below the budget due to general economic trends and delays in completion of new retail outlets. Real Property $389,353 $538,104 ($148,751) Fewer real estate transactions in the Transfer Tax current year. Transient $ 588,194 $ 525,214 $ 62,980 The 2006/07 budget is $42,611 Occupancy Tax lower than the final revenue achieved in 2005/06. Current trends are that there will be additional growth above what was achieved last year. Franchise Taxes $ 1,625,063 $1,369,062 $256,001 All categories of franchise taxes are above the level collected in accordance with the agreements in 2006. (Gas; Electric; Waste; Cable TV) Interest & Rentals $1,955,037 $1,566,318 $388,719 Reflects increase in interest rates and total funds invested. Intergovernmental $ 229,131 $872,731 ($643,600) In 2005 there was a one -time repayment by the State of funds borrowed in FY 2003/04. Other Revenues $ 871,945 $252,683 $619,262 Increase is largely reimbursements budgeted for underground project ands ill related response costs. Page 2 of 3 General Fund Expenditures Overall, through the month of April, expenditures in the General Fund totaled approximately $28.7 million and represented approximately 54% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $1,758,358 was related to Capital Improvement Projects and the remainder was related to Operating Costs reported in the General Fund. Capital Project expenditures typically do not follow an even distribution due to differences in project timing. In looking only at General Fund Operating Expenditures, the activity through April 2007 was lower than the amounts expended for the same period in the prior Fiscal Year. Through the end of April 2007, the City had expended 59% of the General Fund Operating Budget, which is 4% less than the percentage expended in the first ten months of the prior fiscal year. This difference is primarily attributable to lower costs incurred in Community Development which reflect a combination of Staff vacancies and a general slowdown in development activities resulting in lower expenditures. The 2006/07 Budget also included funding for major planning studies that have not incurred costs in the first ten months of the year. 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 3 of 3 City of Dublin 2006 -2007 YTD Revenues and Budget Comparison Total General Fund Revenues Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Revenues 60% 61% 62 % 1166% 74 °�3 % 63% 63% 40% ■ FY 2006/07 FY 2005/06 0% 30% 60% 90% 120% 150% 75% of Year Complete Date P,inted 5/412007 10 '59 AM % of Total for FY 2005/06 53% 66% 74% 63% 41% 77% 54% 75% 65% 63% 86% 61% 5 - i!5-o-7 `f. � ATTACHMENT 1(04 FY 2006/07 FY 2006/07 % of FY 2005106 Budget YTD Actual Budget YTD Actual Property Taxes 17,470,288 9,307,348 53% 8,882,802 Sales Taxes 15,283,000 9,543,875 62% 9,433,762 Real Property Transfer Tax 712,000 389,353 55% 514,066 Transient Occupancy Taxes 685,000 515,474 75% 459,735 Franchise Taxes 1,921,000 955,872 50% 733,922 Licenses and Permits 2,901,819 2,103,518 72% 2,405,806 Interest and Rentals 2,037,738 1,281,546 63% 848,564 Intergovernmental 1,530,976 199,064 13% 765,550 Charges for Services 6,740,407 5,825,982 86% 3,742,332 Fines and Forfeitures 143,560 90,253 63% 93,705 Other Revenues 1,983,070 788,334 40% 238,023 Total General Fund Revenues 51,408,858 31,000,619 60% 28,118,267 Date P,inted 5/412007 10 '59 AM % of Total for FY 2005/06 53% 66% 74% 63% 41% 77% 54% 75% 65% 63% 86% 61% 5 - i!5-o-7 `f. � ATTACHMENT 1(04 City of Dublin 2006 -2007 YTD Expenses and Budget Comparison For the Period Ending March 31, 2007 Total General Fund Exnenses General Government Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects PAM ■ FY 2006/07 FY 2005/06 0% 20% 40% 60% 80% 100% 120% 75% of Year Complete Total General Fund Expenses 52,729,586 General Fund Operating Expenses 45,431,418 D- PrinWd. 514QW7 10 '55 AM 2006/07 2006/07 FY 2005/06 Budget General Government 5,741,378 Police 12,175,438 Fire 9,294,483 Other Public Safety 463,056 Transportation 2,057,857 Health and Welfare 57,575 Culture and Community Services 7,037,361 Community Development 8,604,270 Capital Improvement Projects 7,298,168 Total General Fund Expenses 52,729,586 General Fund Operating Expenses 45,431,418 D- PrinWd. 514QW7 10 '55 AM 2006/07 % of FY 2005/06 % of Total for YTD Actual Budget YTD Actual FY 2005/06 3,731,728 65% 3,462,357 71% 5,699,871 47% 5,319,470 51% 4,549,428 49% 4,557,252 51% 132,992 29% 145,914 39% 1,235,077 60% 1,086,538 61% 18,500 32% 15,000 63% 4,186,462 59% 4,055,624 68% 5,421,215 63% 5,221,657 67% 1,658,846 23% 1,755,460 57% 26,634,119 51% 25,619,272 59% 24,975,273 55% 23,863,812 59% ATTACHMENT Q CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 2007 Prepared by The Finance Department May 4, 2007 3'b2,a ATTACHMENT = (a, CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2007 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUNDS FUNDS FUND ASSETS CASH (59,794,941) 4,459.892 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST 112,754,448 RECEIVABLES: TAXES ACCOUNTS 1,499,678 52,884 INTEREST 671,287 ASSESSMENTS DUE FROM OTHERS 1,901,086 INVENTORY AT COST PREPAID ITEMS 5,894 FIXED ASSETS LOANS RECEIVABLE AMOUNT TO BE PROVIDED TOTAL ASSETS 57,037,452 4,512,775 LIABILITIES /FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (766.182) DEPOSITS FOR AB1600 FEES (6,075) DEPOSITS OTHERS (519,568) PAYABLES: ACCOUNTS (363.268) INTEREST PAYROLL (4,277) DUE TO OTHERS (70,671) (7,488) DEFERRED REVENUE (140,415) DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (1,870,456) (7,488) FUND BALANCES (55,166,996) (4,505,287) TOTAL FUND E (55,166,996) (4,505,287) TOTAL LIABILITIES /EQUITY (57,037,452) (4,512,775) qv- ('0 TOTALS - -- MEMORANDUM ONLY-- - CURRENT PRIOR 502,954 43,808,116 112,062 (10,911,917) (8,378,478) 169,862 169,862 179,997 1,631.500 1,631,500 4,177,500 112,754,448 101,981,813 1,552,561 491.364 671.287 1,901,086 2,206,558 5,894 2,115 6,713,816 6,713,816 4.596,534 1,083,500 1,083,500 1,213,500 502,954 52,153,431 1.365.425 115,572,037 106,470,904 (20,000) (786,182) (623,765) (978.093) (984,168) (871,601) (519,568) (2,239,985) (18,549) (381.817) (570,501) (4,277) (617,405) (1,893,598) (1,971,756) (2,392,557) (2,363,862) (2,504,276) (127,768) (1.201,000) (1,201.000) (1,331,000) (5,274,101) (1,201,000) (8,353,045) (8,774,582) (502.954) (46,879.330) (164,425)(107,218,992) (88,791,355) (502,954) (46,879,330) (164,425)(107,218,992) (88,791,355) (502,954) (52,153,431) (1,365,425)(115,572,037) (97,565,937) 5� t2, (to CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Mar2007 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S. SERVICE FUND GROUP OF TERM DEBT --- MEMORANDUM - -- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 11,442,931 11,442,931 10,009.453 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 3,966 3,966 FIXED ASSETS 49.264,248 338,623,896 387,888,144 383.667.186 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 62,220,554 62,220,554 63,728,304 TOTAL ASSETS 60,711.146 338,623,896 62,220,554 461,555,596 457,404,944 LIABILITIES /FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (518,366) (62.220,554) (62,738,920)_(63,728,304) TOTAL LIABILITIES (518,366) (62.220.554) (62.738,920) (63,728,304) FUND BALANCES (60.192,780) (338.623,896) (398,816,676)(392,595,948) TOTAL FUND E (60,192,780) (338,623,896) (398,816,676)(392,595,948) TOTAL LIABILITIES /EQUITY (60,711,146) (338,623,896) (62,220,554) (461,555,596)(456,324,252) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 03/31/2007 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE * * * * ** *REVENUES * * * * * ** PROPERTY TAXES 17,470,288.00 9,307,347.81 8.162,940.19 246,713.83 16,775,905.94 198,887.67 8,882,801.58 7,893,104.36 SALES TAX 15,283,000.00 9,543,874.59 5.739,125.41 960.957.13 14,363,863.47 672,908.73 9,433.762.10 288,048.40 4,930.101.37 REAL PROPERTY TRANSFER TAX 712,000.00 389,353.26 322,646.74 429,560.48 690.404.35 324,483.04 514,065.77 105,077.44 176,338.58 HOTEL TRANSIENT OCCUPANCY TAX 685.000.00 515,473.50 169,526.50 623,049.58 727,611.60 377,215.28 459,734.75 245,834.30 267.876.85 FRANCHISE TAXES 1.921,000.00 955.871.69 965,128.31 1.526,107.93 1,789,355.75 1,113,809.89 733,922.21 412.298.04 1.055.433.54 LICENSES & PERMITS 2,901,819.00 2,103.518.47 798,300.53 709.411.15 3,142,223.22 458,750.95 2.405,806.31 250,660.20 736.416.91 FINES & FORFEITURES 143,560.00 90,253.03 53.306.97 353,414.23 149,467.45 307,867.52 93,704.57 45,546.71 55,762.88 USE /MONEY & PROP- INTEREST 1.864,164.00 1,195,675.32 668,488.68 2.244.10 1,447,812.35 2,221.40 793,434.55 22.70 654,377.80 USE /MONEY & PROP- RENTALS 173,574.00 85,870.53 87,703.47 10,230.71 123,154.10 6,212.76 55,129.41 4,017.95 68,024.69 INTERGOVERNMENTAL 1,530,976.00 199,063.73 1,331.912.27 4,861,689.14 1,020,574.22 3.462,357.24 765,550.38 1.399,331.90 255,023.84 CHARGES FOR SERVICES 6.740,407.00 5,825,982.15 914.424.85 5,774.668.80 3.742,331.98 2,032,336.82 OTHER SOURCES OF REVENUE 1.983,070.00 788.334.05 1,194,735.95 10,519,026.18 275,245.24 5,319,470.21 238,023.08 5.199.555.97 37,222.16 TOTAL REVENUE 51.408,858.00 31.000.618.13 20,408,239.87 79.558.58 46,280.286.49 44.451.43 28,118,266.69 35,107.15 18,162,019.80 * * ** ***EXPENDITURES * **** ** GENERAL GOVERNMENT ACTIVITIES CITY COUNCIL 362,356.00 247.248.56 115,107.44 246,713.83 198,887.67 47.826.16 CITY MANAGER 1,045.943.00 744,165.34 301,777.66 960.957.13 672,908.73 288,048.40 CENTRAL SERVICES 453.571.00 294,270.16 159,300.84 429,560.48 324,483.04 105,077.44 CITY ATTORNEY 750,395.00 481,279.64 269,115.36 623,049.58 377,215.28 245,834.30 ADMIN SERVICES 1.731,461.00 1,142,643.99 588.817.01 1.526,107.93 1,113,809.89 412.298.04 BUILDING MANAGEMENT 762.909.00 435,467.53 327,441.47 709.411.15 458,750.95 250,660.20 INSURANCE COST CENTER 534,659.00 355,029.91 179,629.09 353,414.23 307,867.52 45,546.71 ELECTIONS COST CENTER 21,815.00 25,554.79 (3,739.79) 2.244.10 2,221.40 22.70 NON- DEPARTMENTAL 78,269.00 6.067.62 72,201.38 10,230.71 6,212.76 4,017.95 ACTIVITY TOTAL 5,741,378.00 3,731,727.54 2,009,650.46 4,861,689.14 3.462,357.24 1.399,331.90 PUBLIC SAFETY POLICE 12,175,438.00 5.699,870.92 6,475,567.08 10,519,026.18 5,319,470.21 5.199.555.97 CROSSING GUARDS 88,511.00 49,522.63 38,988.37 79.558.58 44.451.43 35,107.15 ANIMAL CONTROL 255,100.00 42,739.22 212,360.78 225,853.07 53,428.29 172,424.78 TRAFFIC SIGNALS & STREET LIGHTIN 16.315.00 10,514.20 5.800.80 12,608.33 8.782.65 3,825.68 DISASTER PREPAREDNESS 103.130.00 30.215.59 72.914.41 59.513.44 39,251.77 20.261.67 FIRE SERVICES 9.294.483.00 4,549,428.21 4,745.054.79 8,896,548.07 4,557,251.50 4,339.296.57 ACTIVITY TOTAL 21.932,977.00 10.382,290.77 11,550.686.23 19,793.107.67 10,022,635.85 9.770,471.82 TRANSPORTATION PUBLIC WORKS 975.320.00 635.702.90 339,617.10 783,632.70 540.760.42 242,872.28 STREET MAINTENANCE 33,440.00 7,467.59 25,972.41 30,314.00 30.314.00 STREET SWEEPING 145,400.00 95,605.89 49,794,11 135,923.35 84,719.19 51.204.16 STREET TREE MAINTENANCE 103,529.00 33.020.19 70.508.81 119,576.15 33.218.36 86,357.79 STREET LANDSCAPING MAINTENAN 800.168.00 463,280.88 336,887.12 709,557.73 427,840.49 281,717.24 ACTIVITY TOTAL 2,057.857.00 1,235,077.45 822,779.55 1,779.003.93 1,086,538.46 692,465.47 HEALTH & WELFARE WASTE MANAGEMENT 29,075.00 29,075.00 8.829.31 8,829.31 CHILD CARE 18,500.00 18,500.00 15,000.00 15,000.00 SOCIAL SERVICES 10,000.00 10.000.00 HOUSING PROGRAMS THE CITY OF DUBLIN STATEMENT SHOWING --"rb -VIA REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 03/31/2007 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ACTIVITY TOTAL 57,575.00 18,500.00 39.075.00 23,829.31 15,000.00 8,829.31 CULTURE & LEISURE SERVICES LIBRARY SERVICES 832.317.00 417.822.75 414.494.25 618.993.45 459,877.71 159,115.74 CULTURAL ACTIVITIES 265,457.00 165.995.26 99.461.74 233.515.51 176,314.80 57,200.71 HERITAGE CENTER 192,777.00 131.024.16 61.752.84 158.806.33 105,736.04 53,070.29 DUBLIN CEMETERY 49,060.00 21.692.55 27,367.45 36,321.70 19,174.69 17,147.01 PARK MAINTENANCE 1.852.674.00 896.530.36 956.143.64 1,390,353.67 816,981.56 573.372.11 COMMUNITY TV 67.591.00 60,921.00 6,670.00 63,060.91 60.125.58 2.935.33 RECREATION ADMIN 740,553.00 492.245.08 248.307.92 686.496.76 483,546.00 202,950.76 PLAYGROUNDS 280,851.00 177.852.30 102.998.70 243.464.19 166,209.25 77,254.94 SHANNON CENTER 315.329.00 243,072.41 72,256.59 328,750.40 230,702.22 98,048.18 PRESCHOOL 121.504.00 71,767.03 49,736.97 108,039.36 76,549.53 31.489.83 TEENS PROGRAM 150.581.00 94,276.07 56.304.93 143.225.92 95,579.89 47,646.03. ADULT SPORTS 136.873.00 75,154.95 61,718.05 83,918.06 54.488.45 29,429.61 YOUTH SPORTS 170.700.00 137.516.13 33,183.87 142.237.92 115,538.44 26.699.48 COMMUNITY GYM 43.969.00 28.218.54 15.750.46 40.429.40 25.225.79 15,203.61 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 369.636.00 244,461.94 125.174.06 377,607.25 277,509.49 100.097.76 SENIOR CENTER 485.216.00 323.549.47 161.666.53 421,034.20 291.392.36 129,641.84 RECREATION INSTRUCTION 189,417.00 131.372.67 58.044.33 166,976.26 114,430.21 52.546.05 AQUATICS 446.642.00 256.851.65 189,790.35 411,688.61 275.006.25 136.682.36 PARKS /FACILITIES MANAGEMENT 326,214.00 216.138.16 110,075.84 293.642.66 211,235.43 82.407.23 ACTIVITY TOTAL 7,037.361.00 4,186.462.48 2.850.898.52 5.948.562.56 4.055.623.69 1.892.938.87 COMMUNITY DEVELOPMENT PLANNING 2.920,013.00 1,524,811.76 1,395.201.24 2.218,620.09 1,572,910.48 645,709.61 BUILDING SAFETY 3,205,667.00 2,001,215.54 1,204,451.46 2,908,309.60 1.872,342.58 1,035,967.02 ENGINEERING 2,215.848.00 1.695,493.84 520.354.16 2,380,371.77 1,536.409.67 843.962.10 ECONOMIC DEVELOPMENT 262,742.00 199,693.46 63,048.54 291,110.11 239.994.70 51,115.41 ACTIVITY TOTAL 8.604,270.00 5,421,214.60 3,183,055.40 7,798,411.57 5,221,657.43 2,576,754.14 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1,198,578.00 245,233.59 953,344.41 606,778.83 161,778.90 444,999.93 COMMUNITY IMPROVEMENTS 202,544.00 23.475.51 179,068.49 780,954.81 630,914.32 150,040.49 PARKS 4.835.076.00 1.121.793.37 3,713.282.63 1,037,007.51 723,534.44 313,473.07 STREET CONSTRC /IMPROVEMENTS 1,061.970.00 268.343.51 793,626.49 660.581.62 239.232.28 421.349.34 ACTIVITY TOTAL 7.298,168.00 1,658,845.98 5,639,322.02 3,085.322.77 1.755,459.94 1,329,862.83 TOTAL EXPENDITURES 52.729.586.00 26,634,118.82 26.095.467.18 43.289,926.95 25,619,272.61 17,670,654.34 EXCESS REVENUE (EXPENDITURES) (1,320,728.00) 4,366.499.31 (5.687.227.31) 2.990.359.54 2.498.994.08 491,365.46 TRANSFERS IN FROM OTHER FUNDS 39.525.20 (39.525.20) 15,188.59 15,188.59 TRANSFERS OUT FROM OTHER FUNDS (23.505.65) 23,505.65 (23.505.65) 23,505.65 REVENUES OVER(UNDER) EXPENDITURES (1,320,728.00) 4,382.518.86 (5,703.246.86) 3.005,548.13 2,475.488.43 530.059.70 * * * * * ** *REVENUES * * * * * * ** PROPERTY TAXES SALES TAX /OTHER TAXES FINES & FORFEITURES USES /MONEY & PROPERTY INTERGOVERNMENTAL FROM STATE INTERGOVERNMENTAL FROM COUNTY INTERGOVERNMENTAL FROM FEDERAL CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE * * * * ** *EXPENDITURES * * * * * ** PUBLIC SAFETY: THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 03/31/2007 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. t � r VARIANCE 119,960.00 61,237.46 58.722.54 115,763.98 59,287.64 56.476.34 426,421.00 228,243.34 198,177.66 443,195.51 237,180.35 206.015.16 177,000.00 133,706.85 43,293.15 190,869.24 119,491.84 71,377.40 120,002.00 130,233.83 (10,231.83) 108,314.70 68,613.05 39.701.65 1,084,313.00 910,862.87 173,450.13 1,094,513.46 764,122.45 330,391.01 370,913.00 171,013.60 199,899.40 355,919.00 155,280.00 200,639.00 482,198.00 19,494.85 462,703.15 122,330.00 51,833.41_ 70,496.59 1,462,058.00 735,276.64 726,78.1.36 1,315,435.57 675.,216.24 640,219.33 29,000.00 3.404.00 25,596.00 420,867.00 390,000.00 30,867.00 4,271,865.00 2,393,473.44 1,878,391.56 4,167,208.46 2.521,024.98 1.646.183.48 POLICE 103,710.00 100,370.70 3,339.30 105,670.43 105.389.23 281.20 TRAFFIC SIGNALS & STREET LTG 265,922.00 138,557.00 127,365.00 225,650.30 157.258.88 68.391.42 DISASTER PREPAREDNESS FIRE SERVICES 276,973.00 178,880.86 98,092.14 267,350.23 134,976.23 132,374.00 ACTIVITY TOTAL 646,605.00 417.808.56 228,796.44 598,670.96 397,624.34 201,046.62 TRANSPORTATION: STREET MAINTENANCE 379.294.00 131,441.39 247,852.61 335,939.86 177,937.24 158,002.62 STREET LANDSCAPE MAINTENANCE 5,822.00 13,198.43 (7,376.43) 4,823.96 4,823.96 ACTIVITY TOTAL 385,116.00 144.639.82 240,476.18 340,763.82 182,761.20 158,002.62 HEALTH & WELFARE: WASTE MANAGEMENT 1,575,838.00 751,732.52 824,105.48 1,822,693.60 1,126,548.14 696,145.46 SOCIAL SERVICES 61,804.00 33,072.50 28,731.50 60,427.00 36,956.81 23,470.19 HOUSING PROGRAMS ACTIVITY TOTAL 1,637,642.00 784,805.02 852.836.98 1,883,120.60 1,163,504,95 719.615.65 COMMUNITY DEVELOPMENT: ENGINEERING 6,000.00 2,981.36 3,018.64 6,000.00 6,000.00 ACTIVITY TOTAL 6,000.00 2.981.36 3,018.64 6,000.00 6,000.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS 17,581.00 17,581.00 39,556.00 29,791.00 9,765.00 PARKS 136,587.00 75,525.71 61,061.29 50,349.43 50,349.43 STREET CONSTRUCTION /IMPROVEMENT 1,204,569.00 47,069.36 1.157,499.64 1,257,617.38 535,398.52 722,218.86 ACTIVITY TOTAL 1,358,737.00 122,595.07 1.236,141.93 1,347,522.81 565,189.52 782,333.29 T 0 T A L EXPENDITURES 4,034,100.00 1,472,829.83 2,561,270.17 4,176,078.19 2,315,080.01 1,860.998.18 EXCESS REVENUE (EXPENDITURES) 237,765.00 920,643.61 (682,878.61) (8,869.73) 205.944.97 (214.814.70) TRANSFER IN FROM OTHER FUNDS (1.097.00) 1,097.00 TRANSFERS OUT TO OTHER FUNDS 1,097.00 (1,097.00) 21,788.59 6,600.00 15.188.59 REVENUES OVER (UNDER) EXPENDITURES 237,765.00 920,643.61 (682,878.61) (30,658.32) 199.344.97 (230,003.29) THE CITY OF DUBLIN STATEMENT SNOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 03/31/2007 SPECIAL ASSESSMENT FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE * *** * ** *REVENUES * * * * * * ** 319.000.00 210,688.79 108,311.21 SPECIAL BENEFITS ASSESSMENTS 737,494.00 364,945.60 372.548.40 645.230.59 326.006.80 319,223.79 USES /MONEY & PROP- INTEREST 17,137.00 14,815.26 2.321.74 17.139.71 10.053.42 7,086.29 OTHER SOURCES OF REVENUE 9,700.00 102.844.90 1.194.03 8,505.97 5,603.48 5,603.48 TOTAL REVENUE 764.331.00 380,954.89 383.376.11 667,973.78 341,663.70 326,310.08 * * * * ** *EXPENDITURES * * * * * ** PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 319.000.00 210,688.79 108,311.21 262.370.43 159.525.53 102.844.90 ACTIVITY TOTAL 319,000.00 210,688.79 108,311.21 262,370.43 159,525.53 102.844.90 TRANSPORTATION PUBLIC WORKS 2.470.00 1.511.59 958.41 2,095.50 1,574.78 520.72 STREET TREE MAINTENANCE 31.173.00 9,135.17 22,037.83 19,407.11 7,728.91 11,678.20 STREET LANDSCAPE MAINTENANCE 404,790.00 194,788.44 210,001.56 329,352.28 214,281.26 115.071.02 ACTIVITY TOTAL 438.433.00 205,435.20 232,997.80 350,854.89 223.584.95 127.269.94 COMMUNITY DEVELOPMENT ENGINEERING 13.100.00 358.50 12,741.50 11,357.60 11,357.60 ACTIVITY TOTAL 13.100.00 358.50 12,741.50 11,357.60 11,357.60 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 18,106.69 18.106.69 STREET CONSTRUCTION /IMPRVMNT 75,000.00 75,000.00 ACTIVITY TOTAL 93.106.69 18,106.69 75,000.00 T 0 T A L EXPENDITURES 770.533.00 416.482.49 354,050.51 717,689.61 412.574.77 305,114.84 EXCESS REVENUE (EXPENDITURES) (6,202.00) (35.527.60) 29,325.60 (49,715.83) (70,911.07) 21,195.24 REVENUES OVER (UNDER) EXPENDITURES (6,202.00) (35,527.60) 29,325.60 (49.715.83) (70,911.07) 21,195.24 * * * * * ** *REVENUE * * * * * * ** USES /MONEY & PROP- INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: * * * * ** *EXPENDITURES * * *** ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL CITY ATTORNEY ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS ACTIVITY TOTAL CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 03/31/2007 CAPITAL IMPROVEMENT' FUNDS CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR PRIOR Y.T.D. VARIANCE 1,444,942.00 1,404,702.35 40,239.65 1.286,165.31 747,975.84 538.189.47 21,267.707.00 7.132,469.08 14,135,237.92 17,143.271.43 10,737,470.24 6,405.801.19 22,712.649.00 8.537,171.43 14,175,477.57 18.429,436.74 11,485,446.08 6,943,990.66 39,525.20 (39,525.20) 52.250.00 55.530.01 (3,280.01) 52,250.00 95,055.21 (42,805.21) 75,050.34 75,050.34 56,509.63 33,516.47 22,993.16 131,559.97 33,516.47 98,043.50 864,070.00 232,588.59 631.481.41 327.654.70 200,323.37 127.331.33 864,070.00 232.588.59 631,481.41 327.654.70 200.323.37 127.331.33 ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 31,220.00 16,751.50 14,468.50 59,380.81 36,670.81 22,710.00 COMMUNITY IMPROVEMENTS PARKS 1.738.504.00 361,059.14 1,377,444.86 9,102.130.25 3,475,523.11 5,626,607.14 STREET CONSTRUCTION /IMPROVEMENT 32.653,594.00 3,264,158.53 29,389,435.47 5.109,251.49 1.361,562.32 3,747,689.17 ACTIVITY TOTAL 34,423,318.00 3,641.969.17 30,781,348.83 14,270,762.55 4,873,756.24 9.397,006.31 T 0 T A L EXPENDITURES 35,339,638.00 3,890.562.57 31,449,075.43 14,729,977.22 5,107,596.08 9,622,381.14 EXCESS REVENUE (EXPENDITURES) (12,626.989.00) 4,670,114.51 (17,297,103.51) 3,706,059.52 6.407,955.65 (2,701.896.13) TRANSFER IN FROM OTHER FUNDS 23,505.65 (23,505.65) 6,600.00 30,105.65 (23,505.65) TRANSFERS OUT TO OTHER FUNDS 39,525.20 (39,525.20) REVENUES OVER (UNDER) EXPENDITURES(12,626,989.00) 4;630,589.31 (17,257,578.31) 3,706,059.52 6,407,955.65 (2.701.896.13) < <� THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 03/31/2007 TRUST /AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ** * * * ** *REVENUES * * * * * * ** SPECIAL ASSESSMENTS 108.515.05 (108,515.05) 242.044.14 117,292.54 124.751.60 USES /MONEY & PROP- INTEREST 9,003.95 (9,003.95) 9,505.83 5.659.36 3.846.47 TOTAL REVENUE 117.519.00 (117,519.00) 251,549.97 122.951.90 128.598.07 * * * * ** *EXPENDITURES *** **** GENERAL GOVERNMENT ACTIVITIES NON- DEPARTMENTAL 230,503.00 228.121.25 2,381.75 231.731.25 229,862.50 1,868.75 ACTIVITY TOTAL 230,503.00 228,121.25 2,381.75 231,731.25 229,862.50 1.868.75 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 230,503.00 228.121.25 2,381.75 231.731.25 229,862.50 1.868.75 EXCESS REVENUE (EXPENDITURES) (230,503.00) (110.602.25) (119,900.75) 19.818.72 (106,910.60) 126,729.32 REVENUES OVER (UNDER) EXPENDITURES (230,503.00) (110,602.25) (119.900.75) 19,818.72 (106,910.60) 126,729.32 * * * * *** *REVENUES * * * * * * ** USES /MONEY & PROP- INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE * * * * ** *EXPENDITURES * **** ** GENERAL GOVERNMENT ACTIVITIES NON- DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS THE CITY OF DUBLIN STATEMENT SHOWING Ob 2(P REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 03/31/2007 INTERNAL SERVICE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE 407,294.00 309.892.82 97,401.18 267.035.82 172,855.73 94,180.09 1.784,731.00 1,309,449.25 475.281.75 1.790,982.80 1,338,844.57 452,138.23 19,800.00 10,046.58 9,753.42 939,048.36 31,510.00 907,538.36 2,211.825.00 1,629,388.65 582,436.35 2,997.066.98 1,543,210.30 1,453,856.68 2,043,020.00 456,861.82 1,586,158.18 2,908,427.37 2,043.020.00 456,861,82 1.586.158.18 2.908.427.37 447,429.54 2.460,997.83 447,429.54 2,460,997.83 15,089.26 (15.089.26) 15,089.26 (15,089.26) 2,043,020.00 456.861.82 1,586.158.18 2,908,427.37 462,518.80 2,445,908.57 168,805.00 1,172,526.83 (1,003,721.83) 88,639.61 1,080,691.50 (992.051.89) REVENUES OVER (UNDER) EXPENDITURES 168,805.00 1,172.526.83 (1,003,721.83) 88.639.61 1,080,691.50 (992,051.89) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 03/31/2007 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE * * ** ****REVENUES *** * * * ** USES /MONEY & PROP- INTEREST TOTAL REVENUE * * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 20.00 20.00 FINANCE ACTIVITY TOTAL 20.00 20.00 PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 20.00 20.00 EXCESS REVENUE (EXPENDITURES) (20.00) (20.00) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (20.00) (20.00) City of Dublin 2006 -2007 YTD Revenues and Budget Comparison Total General Fund Revenues Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Revenues 1% 44 197% 14 ■ FY 2006/07 FY 2005/06 0% 30% 60% 90% 120% 150% 83% of Year Complete % of Total for FY 2005/06 0 89% 71% 78% 72% 77% 78% 100% 86% 73% 77 % 92% 80% Date P-t.d. 5/420074 48 PM ATTACHMENT 01 FY 2006/07 FY 2006/07 % of FY 2005/06 Budget YTD Actual Budget YTD Actual Property Taxes 17,470,288 15,877,669 91% 14,899,206 Sales Taxes 15,283,000 11,396,854 75% 10,152,862 Real Property Transfer Tax 712,000 389,353 55 % 538,104 Transient Occupancy Taxes 685,000 588,194 86% 525,214 Franchise Taxes 1,921,000 1,625,063 85% 1,369,062 Licenses and Permits 2,901,819 2,175,147 75% 2,447,357 Interest and Rentals 2,037,738 1,955,037 96% 1,566,318 Intergovernmental 1,530,976 229,131 15% 872,731 Charges for Services 6,740,407 6,509,011 97% 4,213,298 Fines and Forfeitures 143,560 97,768 68% 114,417 Other Revenues 1,983,070 871,945 44% 252,683 Total General Fund Revenues 51,408,858 41,715,172 81% 36,951,252 % of Total for FY 2005/06 0 89% 71% 78% 72% 77% 78% 100% 86% 73% 77 % 92% 80% Date P-t.d. 5/420074 48 PM ATTACHMENT 01 City of Dublin 2006 -2007 YTD Expenses and Budget Comparison For the Period Ending April 30, 2007 Total General Fund V- - - - - -- General Government Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects 40% 60% 80% 83% of Year Complete �5z,z D- P,,.Wd5142W74r5 PM ATTACHMENT 2 CIO) 2006/07 2006/07 % of FY 2005/06 % of Total for Budget YTD Actual Budget YTD Actual FY 2005/06 General Government 5,741,378 4,184,989 73% 3,794,897 78% Police 12,175,438 5,787,210 48% 5,422,795 52% Fire 9,294,483 4,577,279 49% 4,609,821 52 % Other Public Safety 463,056 180,539 39% 159,913 42% Transportation 2,057,857 1,344,055 65% 1,200,891 68% Health and Welfare 57,575 20,421 35% 15,000 63% Culture and Community Services 7,037,361 4,783,811 68% 4,454,707 75% Community Development 8,604,270 6,015,599 70% 5,679,591 73% Capital Improvement Projects 7,298,168 1,758,358 24% 1,748,278 57% Total General Fund Expenses 52,729,586 28,652,261 549/. 27,085,893 63% General Fund Operating Expenses 45,431,418 26,893,903 59% 25,337,615 63% D- P,,.Wd5142W74r5 PM ATTACHMENT 2 CIO) CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF APRIL 2007 Prepared by The Finance Department May 4, 2007 ATTACHMENT X (P.) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Apr2007 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUNDS FUNDS FUND ASSETS CASH (61,233,298) 4.306,437 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST 122,824,719 RECEIVABLES: TAXES ACCOUNTS 1,499,678 52,884 INTEREST 671,287 ASSESSMENTS DUE FROM OTHERS 1,901,086 INVENTORY AT COST PREPAID ITEMS 9,910 FIXED ASSETS LOANS RECEIVABLE AMOUNT TO BE PROVIDED TOTAL ASSETS 65,673,381 4,359,321 LIABILITIES /FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (671,721) DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS (586,838) PAYABLES: ACCOUNTS (370,704) INTEREST PAYROLL (3.181) DUE TO OTHERS (36.483) (7,488) DEFERRED REVENUE (141,045) DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES (1,809,971) (7,488) FUND BALANCES (63:863,410) (4,351,833) TOTAL FUND E (63,863,410) (4,351,833) TOTAL LIABILITIES /EQUITY (65,673,381) (4,359,321) Rom TOTALS - -- MEMORANDUM ONLY-- - CURRENT PRIOR 657,480 43,299,993 178.007 (12,791,381) (7,303,548) 169.862 169,862 179,997 1,631,500 1.631,500 4,177,500 122,824.719 110,635,467 1,552,561 491,364 671.287 1,901,086 2,206,558 9,910 3,688 6,750,316 6,750,316 4,596,534 1,083,500 1.083,500 1,213,500 657,480 51,681,808 1,431:369 123,803,359 116,201,062 (20.000) (691,721) (379,895) (978,093) (978,093) (871,601) (586.838) (2,294,586) (18,549) (389,253) (571,260) (3,181) (606,334) (1,893,598) (1,937,568) (2,206.558) (2,363,862) (2,504,907) (127,768) (1,201,000) (1,201,000) (1,331,000) (5,274,101) (1,201,000) (8.292,561) (8,389,003) (657,480) (46,407,707) (230,369)(115,510,798) (88,791,355) (657,480) (46,407,707) (230,369)(115,510,798) (88,791,355) (657,480) (51,681,808) (1, 431 ,369)(123,803,359) (97,180,358) CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Apr2007 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A L S SERVICE FUND GROUP OF TERM DEBT --- MEMORANDUM - -- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 11,450,083 11.450,083 10,081,302 CASH WITH FISCAL AGENT - AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 3,966 3,966 FIXED ASSETS 49,264,248 338,623,896 387,888,144 383,667,186 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 62,216,048 62,216.048 63,728,304 TOTAL ASSETS 60.718,298 338.623,896 62,216,048 461,558,241 457,476,792 LIABILITIES /FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (518,366) (62,216.048) (62,734,414) (63,728,304) TOTAL LIABILITIES (518,366) (62,216,048) (62,734,414) (63,728,304) FUND BALANCES (60,1.99.932) (338,623,896) (398,823,827)(392,595,948) TOTAL FUND E (60,199,932) (338,623,896) (398.823,827)(392,595.948) TOTAL LIABILITIES /EQUITY (60,718,298) (338,623,896) (62,216,048) (461,558,241)(456,324,252) THE CITY OF DUBLIN STATEMENT SHOWING ` Db*2`9 REVENUES VERSUS EXPENDITURES t/ FOR THE PERIOD 07/01/2006 THROUGH 04/30/2007 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE * * * * ** *REVENUES * * * * * ** PROPERTY TAXES 17.470,288.00 15,877,668.60 99,295.02 1,592.619.40 246,713.83 16.775,905.94 14,899,205.55 1,876,700.39 SALES TAX 15183,000.00 11,396,854.13 3.886,145.87 14.363,863.47 10,152,862.10 4,211,001.37 REAL PROPERTY TRANSFER TAX 712,000.00 389.353.26 322,646.74 690,404.35 538,103.60 152,300.75 HOTEL TRANSIENT OCCUPANCY TAX 685,000.00 588,194.39 96,805.61 727,611.60 525,214.23 202,397.37 FRANCHISE TAXES 1,921,000.00 1,625,063.11 295,936.89 1,789,355.75 1,369,062.15 420.293.60 LICENSES & PERMITS 2,901,819.00 2,175,147.33 726,671.67 3,142,223.22 2,447,357.18 694.866.04 FINES & FORFEITURES 143,560.00 97,768.46 45,791.54 149,467.45 114,417.48 35,049.97 USE /MONEY & PROP- INTEREST 1,864,164.00 1,851.871.41 12.292.59 1,447,812.35 1,507,627.42 (59,815.07) USE /MONEY & PROP- RENTALS 173,574.00 103,165.41 70,408.59 123,154.10 58,690.35 64,463.75 INTERGOVERNMENTAL 1,530.976.00 229.131.24 1,301,844.76 1,020,574.22 872,730.86 147,843.36 CHARGES FOR SERVICES 6,740,407.00 6.509,010.77 231.396.23 5,774,668.80 4.213.298.44 1,561,370.36 OTHER SOURCES OF REVENUE 1,983,070.00 871,944.73 1,111,125.27 275.245.24 252,682.87 22,562.37 TOTAL REVENUE 51,408,858.00 41.715.172.84 9,693.685.16 46,280.286.49 36,951,252.23 9,329,034.26 * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES CITY COUNCIL 362,356.00 263,060.98 99,295.02 246,713.83 210,398.55 36,315.28 CITY MANAGER 1.045,943.00 831,567.80 214,375.20 960,957.13 744,491.64 216.465.49 CENTRAL SERVICES 453,571.00 319,038.67 134,532.33 429,560.48 350.552.67 79,007.81 CITY ATTORNEY 750,395.00 659,011.91 91,383.09 .623.049.58 425,807.30 197.242.28 ADMIN SERVICES 1,731,461.00 1,238,851.70 492.609.30 1,526,107.93 1,232,049.51 294,058.42 BUILDING MANAGEMENT 762,909.00 484,841.80 278,067.20 709,411.15 511,265.31 198..145.84 INSURANCE COST CENTER 534,659.00 356,150.41 178.508.59 353,414.23 311,460.61 41,953.62 ELECTIONS COST CENTER 21.815.00 25,554.79 (3,739.79) 2,244.10 2,221.40 22.70 NON- DEPARTMENTAL 78,269.00 6,910.77 71,358.23 10,230.71 6,650.38 3,580.33 ACTIVITY TOTAL 5,741,378.00 4,184,988.83 1,556,389.17 4,861,689.14 3,794,897.37 1,066,791.77 PUBLIC SAFETY POLICE 12,175,438.00 5,787,209.63 6,388,228.37 10,519,026.18 5.422,795.07 5,096,231.11 CROSSING GUARDS 88,511.00 58,591.38 29,919.62 79,558.58 53,035.06 26,523.52 ANIMAL CONTROL 255,100.00 74,570.22 180,529.78 225,853.07 53,428.29 172,424.78 TRAFFIC SIGNALS & STREET LIGHTIN 16,315.00 11,684.91 4,630.09 12,608.33 9.123.64 3,484.69 DISASTER PREPAREDNESS 103,130.00 35,692.44 67.437.56 59.513.44 44,326.09 15.187.35 FIRE SERVICES 9,294,483.00 4,577,278.65 4,717,204.35 8,896.548.07 4,609,821.14 4,286,726.93 ACTIVITY TOTAL 21,932.977.00 10.545,027.23 11,387,949.77 19,793.107.67 10,192.529.29 9,600,578.38 TRANSPORTATION PUBLIC WORKS 975,320.00 697,507.48 277.812.52 783,632.70 602,990.22 180,642.48 STREET MAINTENANCE 33.440.00 7,467.59 25.972.41 30,314.00 57.50 30,256.50 STREET SWEEPING 145,400.00 95.605.89 49,794.11 135,923.35 94,772.95 41,150.40 STREET TREE MAINTENANCE 103.529.00 35,617.29 67,911.71 119.576.15 38,654.22 80,921.93 STREET LANDSCAPING MAINTENAN 800.168.00 507,856.81 292,311.19 709.557.73 464,415.82 245.141.91 ACTIVITY TOTAL 2,057,857.00 1,344.055.06 713,801.94 1,779.003.93 1,200,890.71 578,113.22 HEALTH & WELFARE WASTE MANAGEMENT 29,075.00 1,921.25 27.153.75 8,829.31 8,829.31 CHILD CARE 18,500.00 18,500.00 15,000.00 15,000.00 SOCIAL SERVICES 10,000.00 10,000.00 HOUSING PROGRAMS THE CITY OF DUBLIN STATEMENT SHOWING Z 0 v ( REVENUES VERSUS EXPENDITURES Ob FOR THE PERIOD 07/01/2006 THROUGH 0413012007 GENERAL REVENUE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ACTIVITY TOTAL 57,575.00 20,421.25 37,153.75 23,829.31 15.000.00 8,829.31 CULTURE & LEISURE SERVICES LIBRARY SERVICES 832.317.00 592,227.36 240,089.64 618,993.45 466,821.28 152.172.17 CULTURAL ACTIVITIES 265.457.00 175,355.84 90,101.16 233,515.51 185,939.95 47,575.56 HERITAGE CENTER 192,777.00 143,571.87 49,205.13 158,806.33 117,100.81 41,705.52 DUBLIN CEMETERY 49,060.00 24,528.49 24,531.51 36,321.70 21.100.97 15,220.73 PARK MAINTENANCE 1,852,674.00 1,000.940.30 851,733.70 1,390.353.67 917,601.27 472,752.40 COMMUNITY TV 67,591.00 60.921.00 6.670.00 63,060.91 60.425.58 2.635.33 RECREATION ADMIN 740,553.00 557,476.43 183.076.57 686,496.76 538,141.01 148,355.75 PLAYGROUNDS 280,851.00 194.863.67 85,987.33 243,464.19 180.952.14 62,512.05 SHANNON CENTER 315.329.00 266,544.39 48,784.61 328,750.40 259,032.69 69,717.71 PRESCHOOL 121.504.00 79.462.12 42,041.88 108,039.36 85,618.85 22,420.51 TEENS PROGRAM 150,581.00 102,353.18 48,227.82 143,225.92 110.240.28 32.985.64 ADULT SPORTS 136,873.00 82,058.46 54.814.54 83.918.06 59,470.85 24.447.21 YOUTH SPORTS 170.700.00 143.774.35 26,925.65 142,237.92 121,184.24 21,053.68 COMMUNITY GYM 43.969.00 32.220.86 11348.14 40,429.40 30,738.25 9,691.15 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 369,636.00 297,940.37 71,695.63 377,607.25 337.227.43 40,379.82 SENIOR CENTER 485,216.00 361,367.20 123.848.80 421,034.20 319.098.74 101.935.46 RECREATION INSTRUCTION 189.417.00 140,544.36 48,872.64 166,976.26 125,069.36 41,906.90 AQUATICS 446,642.00 290.382.57 156,259.43 411,688.61 286,267.65 125.420.96 PARKS /FACILITIES MANAGEMENT 326.214.00 237,278.11 88.935.89 293.642.66 232,675.43 60.967.23 ACTIVITY TOTAL 7,037,361.00 4,783,810.93 2,253,550.07 5,948.562.56 4,454,706.78 1,493,855.78 COMMUNITY DEVELOPMENT PLANNING 2.920,013.00 1.704,038.60 1.215.974.40 2,218,620.09 1,748,953.93 469,666.16 BUILDING SAFETY 3.205,667.00 2.223,192.75 982,474.25 2,908.309.60 1.946,752.87 961.556.73 ENGINEERING 2.215,848.00 1.874,629.18 341,218.82 2.380.371.77 1,730.661.08 649,710.69 ECONOMIC DEVELOPMENT 262,742.00 213,738.51 49,003.49 291,110.11 253.222.70 37,887.41 ACTIVITY TOTAL 8.604,270.00 6,015.599.04 2,588,670.96 7,798,411.57 5,679.590.58 2,118.820.99 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1,198,578.00 262,607.23 935,970.77 606,778.83 204,266.80 402,512.03 COMMUNITY IMPROVEMENTS 202,544.00 25,920.93 176.623.07 780,954.81 631.706.57 149,248.24 PARKS 4,835,076.00 1,174,336.50 3,660.739.50 1.037,007.51 673.164.25 363.843.26 STREET CONSTRC /IMPROVEMENTS 1.061,970.00 295,492.84 766,477.16 660,581.62 239.140.82 421,440.80 ACTIVITY TOTAL 7.298,168.00 1,758,357.50 5,539,810.50 3,085,322.77 1,748,278.44 1.337,044.33 TOTAL EXPENDITURES 52,729.586.00 28,652,259.84 24,077,326.16 43;289,926.95 27,085.893.17 16.204,033.78 EXCESS REVENUE (EXPENDITURES) (1,320,728.00) 13,062,913.00 (14.383.641.00) 2.990.359.54 9,865.359.06 (6.874,999.52) TRANSFERS IN FROM OTHER FUNDS 39,525.20 (39,525.20) 15,188.59 15.188.59 TRANSFERS OUT FROM OTHER FUNDS (23,505.65) 23.505.65 (23,505.65) 23.505.65 REVENUES OVER(UNDER) EXPENDITURES (1.320.728.00) 13,078,932.55 (14,399,660.55) 3,005.548.13 9.841,853.41 (6,836,305.28) THE CITY OF DUBLIN .STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 04/30/2007 SPECIAL REVENUE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. * * * * * ** *REVENUES * * * * * * ** PROPERTY TAXES 119.960.00 97,674.60 3,289.30 22,285.40 105,670.43 115.763.98 105.396.95 108,002.42 SALES TAX /OTHER TAXES 426,421.00 TRAFFIC SIGNALS & STREET LTG 288,138.44 138,282.56 443,195.51 272,162.71 FINES & FORFEITURES 177,000.00 152,804.40 24,195.60 190,869.24 119,491.84 USES /MONEY & PROPERTY 120.002.00 148.639.50 (28,637.50) 108,314.70 FIRE SERVICES 68,613.05 INTERGOVERNMENTAL FROM STATE 1.084,313.00 978,582.48 105,730.52 1,094.513.46 811,130.11 INTERGOVERNMENTAL. FROM COUNTY 370,913.00 646,605.00 171,013.60 465,567.95 199.899.40 181,037.05 355,919.00 598.670.96 .193,390.00 INTERGOVERNMENTAL FROM FEDERAL 482,198.00 187,302.23 33,887.13 TRANSPORTATION: 448,310.87 122,330.00 72.482.23 CHARGES FOR SERVICES 1,462,058.00 1.172.140.43 289,917.57 1,315.435.57 379,294.00 1.253.048.16 OTHER SOURCES OF REVENUE 29,000.00 236,802.32 25.467.40 335,939.86 3.532.60 200,531.18 420,867.00 135,408.68 435,037.00 TOTAL REVENUE 4,271,865.00 3,068.347.98 1.203,517.02 4,167,208.46 3,333,357.52 * * * * ** *EXPENDITURES * * * * * ** PUBLIC SAFETY: VARIANCE 7,761.56 171,032.80 71,377.40 39.701.65 283.383.35 162,529.00 49,847.77 62.387.41 (14,170.00) 833,850.94 POLICE 103,710.00 100,420.70 3,289.30 105,670.43 105.396.95 273.48 TRAFFIC SIGNALS & STREET LTG 265,922.00 186,266.39 79,655.61 225,650.30 170,995.55 54,654.75 DISASTER PREPAREDNESS FIRE SERVICES 276,973.00 178,880.86 98,092.14 267,350.23 134,976.23 132,374.00 ACTIVITY TOTAL 646,605.00 465,567.95 181,037.05 598.670.96 411,368.73 187,302.23 TRANSPORTATION: STREET MAINTENANCE 379,294.00 142,491.68 236,802.32 335,939.86 200,531.18 135,408.68 STREET LANDSCAPE MAINTENANCE 5,822.00 13,198.43 (7,376.43) 4,823.96 4,823.96 ACTIVITY TOTAL 385,116.00 155,690.11 229,425.89 340,763.82 205,355.14 135,408.68 HEALTH & WELFARE: WASTE MANAGEMENT 1,575,838.00 1,481,632.91 94,205.09 1,822,693.60 1,133,282.97 689,410.63 SOCIAL SERVICES 61,804.00 39,343.68 22,460.32 60.427.00 37,745.25 22,681.75 HOUSING PROGRAMS ACTIVITY TOTAL 1,637,642.00 1,520,976.59 116,665.41 1,883,120.60 1,171,028.22 712,092.38 COMMUNITY DEVELOPMENT: ENGINEERING 6,000.00 6,000.00 6,000.00 6,000.00 ACTIVITY TOTAL 6,000.00 6,000.00 6.000.00 6,000.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS 17,581.00 17,581.00 39,556.00 29,791.00 9,765.00 PARKS 136,587.00 75,525.71 61,061.29 50,349.43 50.349.43 STREET CONSTRUCTION /IMPROVEMENT 1,204,569.00 77,398.56 1,127,170.44 1,257,617.38 547,435.59 710,181.79 ACTIVITY TOTAL 1,358,737.00 152,924.27 1,205,812.73 1,347,522.81 577,226.59 770,296.22 T 0 T A L EXPENDITURES 4,034,100.00 2,301,158.92 1,732,941.08 4,176,078.19 2,370,978.68 1,805.099.51 EXCESS REVENUE (EXPENDITURES) 237,765.00 767,189.06 (529,424.06) (8,869.73) 962,378.84 (971,248.57) TRANSFER IN FROM OTHER FUNDS (1,097.00) 1,097.00 TRANSFERS OUT TO OTHER FUNDS 1,097.00 (1,097.00) 21,788.59 6,600.00 15.188.59 REVENUES OVER (UNDER) EXPENDITURES 237,765.00 767,189.06 (529.424.06) (30,658.32) 955,778.84 (986,437.16) *** * ** *EXPENDITURES * * * * * ** PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG THE CITY OF DUBLIN STATEMENT SHOWING 57.438.24 262,370.43 2 2 l/•C� 182.689.78 REVENUES VERSUS EXPENDITURES ACTIVITY TOTAL 319,000.00 261,561.76 57,438.24 FOR THE PERIOD 182,589.78 79,780.65 TRANSPORTATION 07/01/2006 THROUGH 04/30/2007 SPECIAL ASSESSMENT PUBLIC WORKS FUNDS 1,597.54 872.46 CURRENT CURRENT 1,686.54 PRIOR 408.96 PRIOR STREET TREE MAINTENANCE 31.173.00 BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE * * * * * ** *REVENUES * * * * * * ** 6,313.83 STREET LANDSCAPE MAINTENANCE 404,790.00 211.946.49 192,843.51 SPECIAL BENEFITS ASSESSMENTS 737,494.00 583,715.23 153,778.77 645.230.59 101.846.25 580.129.33 ACTIVITY TOTAL 65,101.26 USES /MONEY & PROP- INTEREST 17,137.00 17.512.42 (375.42) 17,139.71 350,854.89 10,053.42 242.285.85 7,086.29 OTHER SOURCES OF REVENUE 9,700.00 3,219.91 6.480.09 5,603.48 5.603.48 TOTAL REVENUE 764,331.00 604.447.56 159.883.44 667,973.78 595,786.23 13,100.00 72,187.55 *** * ** *EXPENDITURES * * * * * ** PUBLIC SAFETY: TRAFFIC SIGNALS & STREET LIG 319,000.00 261.561.76 57.438.24 262,370.43 182.689.78 79,780.65 ACTIVITY TOTAL 319,000.00 261,561.76 57,438.24 262,370.43 182,589.78 79,780.65 TRANSPORTATION PUBLIC WORKS 2,470.00 1,597.54 872.46 2,095.50 1,686.54 408.96 STREET TREE MAINTENANCE 31.173.00 9,985.57 21,187.43 19,407.11 13,093.28 6,313.83 STREET LANDSCAPE MAINTENANCE 404,790.00 211.946.49 192,843.51 329,352.28 227.506.03 101.846.25 ACTIVITY TOTAL 438,433.00 223,529.60 214,903.40 350,854.89 242.285.85 108.569.04 COMMUNITY DEVELOPMENT ENGINEERING 13,100.00 358.50 12,741.50 11,357.60 11,357.60 ACTIVITY TOTAL 13,100.00 358.50 12,741.50 11,357.60 11,357.60 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 18,106.69 18.106.69 STREET CONSTRUCTION /IMPRVMNT 75,000.00 75,000.00 ACTIVITY TOTAL 93.106.69 18,106.69 75.000.00 T 0 T A L EXPENDITURES 770,533.00 485,449.86 285.083.14 717.689.61 454,339.92 263,349.69 EXCESS REVENUE (EXPENDITURES) (6.202.00) 118,997.70 (125.199.70) (49,715.83) 141,446.31 (191,162.14) REVENUES OVER (UNDER) EXPENDITURES (6,202.00) 118.997.70 (125,199.70) (49,715.83) 141.446.31 (191.162.14) * * * * * ** *REVENUE * * * * * * ** USES /MONEY & PROP- INTEREST OTHER SOURCES OF REVENUE TOTAL. REVENUE: * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL CITY ATTORNEY ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS ACTIVITY TOTAL CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 04/30/2007 CAPITAL IMPROVEMENT FUNDS CURRENT CURRENT PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR 23Ob 2ttp PRIOR Y.T.D. VARIANCE 1.444,942.00 1.588,698.60 (143,756.60) 1,286.165.31 787,428.16 498,737.15 21,267,707.00 6,725,488.45 14,542.218.55 17,143,271.43 12,627,146.66 4,516,124.77 22,712,649.00 8,314,187.05 14,398.461.95 18,429.436.74 13,414.574.82 5.014,861.92 39.525.20 (39.525.20) 52,250.00 57,794.59 (5,544.59) 52,250.00 97,319.79 (45,069.79) 75,050.34 75.050.34 56,509.63 39,140,47 17,369.16 131,559.97 39,140.47 92.419.50 864,070.00 254,993.14 609.076.86 327,654.70 218.563.41 109,091.29 864,070.00 254,993.14 609,076.86 327,654.70 218,563.41 109,091.29 ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 31,220.00 16,751.50 14.468.50 59.380.81 39.700.81 19.680.00 COMMUNITY IMPROVEMENTS PARKS 1.738,504.00 371,678.54 1.366,825.46 9.102,130.25 3.596,612.09 5,505,518.16 STREET CONSTRUCTION /IMPROVEMENT 32.653,594.00 3.477,508.45 29,176,085.55 5,109.251.49 1,450,875.84 3.658,375.65 ACTIVITY TOTAL 34,423,318.00 3.865.938.49 30,557,379.51 14,270,762.55 5,087,188.74 9.183.573.81 T 0 T A L EXPENDITURES 35.339,638.00 4,139,201.02 31,200,436.98 14,729,977.22 5,344,892.62 9,385,084.60 EXCESS REVENUE (EXPENDITURES) (12.626.989.00) 4,198,491.68 (16.825,480.68) 3.706.059.52 8,099.787.85 (4,393,728.33) TRANSFER IN FROM OTHER FUNDS 23,505.65 (23,505.65) 6,600.00 30,105.65 (23,505.65) TRANSFERS OUT TO OTHER FUNDS 39,525.20 (39,525.20) REVENUES OVER (UNDER) EXPENDITURES(12,626.989.00) 4,158,966.48 (16.785.955.48) 3.706,059.52 8.099,787.85 (4,393.728.33) THE CITY OF DUBLIN STATEMENT SHOWING [ Z� REVENUES VERSUS EXPENDITURES E FOR THE PERIOD 07/01/2006 THROUGH 04/30/2007 TRUST /AGENCY FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE * * * * * ** *REVENUES * * * * * * ** SPECIAL ASSESSMENTS 174.662.43 (174,662.43) 242,044.14 206,684.48 35,359.66 USES /MONEY & PROP- INTEREST 9,695.20 (9,695.20) 9,505.83 5,659.36 3.846.47 TOTAL REVENUE 184,357.63 (184,357.63) 251,549.97 212,343.84 39,206.13 * *** ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 230,503.00 229.015.00 1,488.00 231,731.25 230,506.25 1.225.00 ACTIVITY TOTAL 230,503.00 229,015.00 1,488.00 231,731.25 230,506.25 1,225.00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS T 0 T A L EXPENDITURES 230,503.00 229,015.00 1,488.00 231,731.25 230,506.25 1,225.00 EXCESS REVENUE (EXPENDITURES) (230.503.00) (44,657.37) (185,845.63) 19.818.72 (18.162.41) 37,981.13 REVENUES OVER (UNDER) EXPENDITURES (230,503.00) (44,657.37) (185.845.63) 19.818.72 (18,162.41) 37,981.13 * * * **** *REVENUES * * * * * * ** USES /MONEY & PROP- INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES NON- DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: FIRE ACTIVITY TOTAL TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES ✓ �i�[J' FOR THE PERIOD 07/01/2006 THROUGH 04/30/2007 INTERNAL SERVICE FUNDS CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE 407,294.00 358,963.83 48.330.17 267.035.82 172.855.73 94,180.09 1,784.731.00 1.309,449.25 475,281.75 1,790,982.80 1,491,131.14 299,851.66 19.800.00 10,046.58 9;753.42 939,048.36 31,510.00 907,538.36 2.211,825.00 1.678,459.66 533,365.34 2,997,066.98 1,695.496.87 1.301,570.11 2,043.020.00 498,780.91 1,544.239.09 2,908,427.37 2,043,020.00 498,780.91 1,544,239.09 2,908,427.37 512,908.28 2,395,519.09 512,908.28 2.395.519.09 30,048.81 (30,048.81) 30.048.81 (30.048.81) 2,043,020.00 498,780.91 1,544,239.09 2,908,427.37 542,957.09 2,365.470.28 168,805.00 1,179,678.75 (1,010,873.75) 88,639.61 1,152,539.78 (1.063,900.17) REVENUES OVER (UNDER) EXPENDITURES 168,805.00 1,179.678.75 (1.010,873.75) 88,639.61 1,152,539.78 (1,063,900.17) THE CITY OF DUBLIN STATEMENT SHOWING -j4 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 04/30/2007 ENTERPRISE FUND CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ** * * * ** *REVENUES * * * * * * ** USES /MONEY & PROP- INTEREST TOTAL REVENUE * * *- ** *EXPENDITURES * **** ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 20.00 20.00 FINANCE ACTIVITY TOTAL 20.00 20.00 PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES 20.00 20.00 EXCESS REVENUE (EXPENDITURES) (20.00) (20.00) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (20.00) (20.00)