Loading...
HomeMy WebLinkAbout4.07 FinancialRptSept2005 CITY CLERK File # D~~[QH9~ AGENDA STATEMENT CITY COUNCIL MEETING DATE: October 18,2005 SUBJECT: Financial Reports for the Month of September 2005 Report Prepared by: Carole A. Perry, Administrative Services Director and Fred W Marsh, Finance Manager ATTACHMENTS: 1. YTD Revenues and Budget Comparison 2. YTO Expenses and Budget Comparison 3. Financial Statements for September 2005 RECOMMENDATION:.l§ ~eceive 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 month of September 2005. Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion ofthe City's operations. Analvsis of September 2005 Rcvcnuc and Expcnditurc RCPorts The September reports represent the reporting of revenues and expenditures for the three months 0 r the Fiscal Year, through September 30, 2005. It should also be noted that there is not an even distribution of revenues and expenditures on a monthly basis. Thcrc is also a lag with the reporting of expenditures due to the significant amount of services provided to the City by independent contractors, including Policc and Fire Services. Given September is only the third month of the Fiscal Year, there is extremely limited data on which to base any major projections or identify significant trends. Also, in October 2005, thc auditors will start the t1nal phase of the fieldwork necessary for the Fiscal Year 2004-2005 audit. The final audit results will impact the reported Fund Balance presented in the attached monthly reports. General Fund Revenues Total General Fund Revenues collcctcd through Scptembcr arc less than what occurred in the third month of the previous Fiscal Year. Through September 2005, the City had collected approximately 14% of the total budgeted General Fund Revenues, which was 2% less than the percentage collcctcd in the prior Fiscal Year. A brief description is provided below to explain any material revenue variations. The first quarter Salcs Tax is lower, when compared to the same period in the prior year, as last year the State delayed implementation ofthe Y. percent reduction to sales tax (related to the 'Triple Flip") until the second quarter (Octobcr 2004). The City will receive reimbursements for these deductions from the State as part of thc property tax receipts to be received later in the Fiscal Year. Real Property Transfer Tax is higher than in the same period in the prior year due to timing differences in the receipt of these funds. Franchise Fees are lower than in the same period in the prior pcriod due to timing differences in the _~W~M______~____________N__~~~______________________________________________________________________________~ Document in FSCOLOR 09-Z005.XLS ITEM NO. Lt.1 COPIES TO: Page 1 of2 receipt of Garbage Franchise Fees. Interest and Rentals rcccived to date are lower than the prior year due to timing differcnccs in the rcceipt of interest earnings on the City's securities. Initia1ly a1l interest revenue is recorded in the General Fund and is then allocated quarterly to other funds on a pro rata basis. Intergovernmental revenue is higher than in the prior year duc to an early repayment by the State of the Vehicle License Fee (VLF) Loan from fiscal Year 2003-2004. At the time the Fiscal Year 2005-2006 City budget was approved, there was no indication that the VLF loan would be repaid ahead of schedule; therefore, no revenue was budgeted for this event. However, with the adoption of the State Budget, cities were advised that the VLF Gap Loan would be repaid early. Fines and Forfeitures are lower than in the same period of the prior year due to lower year to date rcceipts of court and parking fines. Other Revenues are lower than in the same period of the prior year due to a one time payment received in thc prior year for ongoing maintenance of storm drains and timing differences in thc receipt of reimbursements ITom the City of Pleasanton for the design of improvements to thc Fallon RoadJI-580 ITeeway interchange. General Fund Expenditures Overall, through the month of Sept em her, expenditures in the Gcncral Fund totaled about $4.9 million and represented approximatcly 10% of the total budgeted expenditures in the General Fund. Ofthis amount, a total of approximately $834,000 was related to Capital Improvement Projects and the remainder was related to Operating Costs reportcd 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 September 2005 was similar to the amounts expcnded for the same period in the prior Fiscal Year. Through the end of September 2005, the City had expended 10% of the General Fund Operating Budget, which was the same as the amount expended in the prior Fiscal Year. Health and Welfare expcnditures, as a percentage of budget, are higher than in the samc pcriod of the previous year due to expenditures budgeted in the previous year for consultant serviccs used in the negotiation of a new waste managenlent contract for the City. 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. Pagc 2 of2 City ofDuhUn 2005-2006 YTD Revenues and Budget ComparisOli For th~_.:E'e,~¡9d.J';!lßI.!UtSe,.ple,_...þ_.!t 30, 2005 140/0 : 16% 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 \ J!ti ~ I . FY 2005/06 . FY 2004/05 I I I 134% 4900 0% 30% 150% 60% 90% 120% 25% of Year Complete ..__n._ FY 2005/06 FY 2005t06 %ot FY 2004/05 % of Total for Budget YTD Actual Budget YTD Actual FY 2004t05 Property Taxes 15,716,461 716.900 5% 635,551 5% Sales Taxes 14.984.884 2,080,169 14% 2.369.238 16% Real Property Transfer Tax 745,600 136,416 18% 73,204 9% Transient Occupancy Taxes 680.S00 136,280 20% 133.801 20% Franchise Taxes 1.626,300 22,002 1% 126,257 8% Licenses and Permits 2,380,013 1.126.808 47% 1,569,734 45% Interest and Rentals 1.898.725 245,098 13% 410,697 24% Intergovernmental 498,650 669.739 134% 275,477 48% Charges for Services 5,256,561 1.072,4 78 20% 978,808 18% Fines and Forfeitures 132.200 24,651 19% 35.751 25% Other Revenues 1.596,243 194,917 12% 323,372 49% Total General Fund Revenues 45.516.137 6,425,458 14% 6,931,890 16% ~IY\ I.+'ì ID-I2.-DS'" Dal.Prki~: 0'4I2OOS11:3¡¡AM ATTACHMENT 1 ? 'lj"'J! City of Dublin 2005-2006 YTD Expenses and Budget Comparison For the Period Ending September 30, 2005 Total General Fnnd - I -----¡-. Expenses General Government Police Fire . FY 2005106 Other Public Safety . FY 2004/05 Transportation Health and Welfare 11 % Culture & Community Services Community Development Capital Improv. Projects 0% 20% 40% 60% 80% 100% 120% ..~ 25% of Year Complete 2005/06 2005106 %of FY 2004105 % of Total for Budget YTD Actual Budget YTD Actual FY 2004105 General Government 5,526,335 1,022,187 18% 976,019 21% Pollee 11,358.537 224,305 2% 236,876 2% Fire 8,890,188 92.066 1% 98,667 1% Other Public Safety 374,012 12,506 3% 15.592 4% Transportation 1,824,115 229,816 13% 211.942 13% Health and Welfare 15,000 17,000 113% 24,593 28% Culture and Community Services 6,348.938 1,066,412 17% 983,166 18% Community Development 8.433,682 1.407,853 17% 1,339.782 18% Capital Improvement Projects 4,567,765 834,475 18% 841.577 19% Total General Fund Expenses 47,338.572 4,906,620 10% 4.728,214 1t% General Fund Operating Expenses 42.770,807 4.072.145 10% 3,886,637 10% CIIIIIPrtn'*'fl:j~11:2IIAM ATTACHMENT 2 39j~ CITY OF DUBLIN'S PRO FORMA FINANCIAL 8T A TEMENTS FOR THE MONTH OF SEPTEMBER 2005 Prepared by The Finance Department October 4, 2005 ATTACHMENT 3 L.\ov\~ CITY OF DUBL! N BALANCE SHEET FOR THE PERIOD ENDING 30Sep2005 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ TOT A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ···MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUNDS FUND CURRENT PRIOR ASSETS CASH (52.700,885) 3.143,443 522.278 40,637,447 14.532 (8.383,185) (30.752,519) CASH WITH FISCAL AGENT 175.727 175.727 172,779 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 103.307.316 103.307,316 100.359.073 RECEIVABLES, TAXES ACCOUNTS 127.768 363,597 491.364 786 ,468 INTEREST 500.222 500.222 496.242 ASSESSMENTS DUE FROM OTHERS 2.141. 819 2.141. 819 1.829.213 INVENTORY AT COST PREPAID ITEMS 7.244 7.244 8.769 F I X ED ASSETS LOANS RECEIVABLE 4,500.000 4.500.000 AMOUNT TO BE PROVIDED 1.334.500 1.334.500 1.334.500 TOTAL ASSETS 53,383.484 3.507.040 522.278 45.137.447 1.524.759 104.075.008 74.234.524 LIABILITIES/FUND EOUITY DEPOSITS FOR PRIVATE DEVEL (1,033.670) (1.033.670) (972.824) DEPOSITS FOR AB1600 FEES (305.919) (480.933) (786,852) (117.086) DEPOSITS OTHERS (2,701.548) (2.701.548) (2.268.492) PAY ABLES: ACCOUNTS (331.602) (35.309) (7.303) (374,214) (281.254) INTEREST PAYROLL (618.331) (618,331) (548.096) DUE TO OTHERS (474.440) (2.141.819) (2.616.259) (33.842) DEfERRED REVENUE (127.768) (127.768) (127.768) DEBT INSTRUMENTS PAYABLE (1.452.000) (1.452,000) (1.452.000) TOTAL LIABILITIES (5.593.278) (35,309) (2.630.055) (1,452.000) (9.710,642) (5.801.362) FUND BALANCES (47.790.206) (3.471.730) (522.278) (42.507.392) (72.759) (94.364.366) (68,433.161) TOTAL FUND E (47.790.206) (3.471.730) (522,278) (42.507.392) (72.759) (94.364.366) (68,433.161) TOTAl. LIABILITIES/EOUITY (53.383,484) (3,507.040) (522,278) (45.137.447) (1.524.759)(104.075,008) (74.234,524) 5 ~\'3 CITY OF DUBlIN BALANCE SHEET FOR THE PERIOD ENDING 30Sep2005 INTERNAL SERVICE FUNDS ENTERPRISE FUND FIXED ASSETS GROUP OF ACCOUNTS GENERAL LONG TERM DEBT ACCOUNT GROUP TOT A L S ---MEMORANDl\'I... CURRENT PRIOR ASSETS CASH 9.159.293 9.159,293 8,067,376 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES, TAXES ACCOUNTS INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 46.511. 915 39.208.244 85,720,159 85.720.159 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 66.753.945 66,753,945 66.753.940 TOTAL ASSETS 55,671.208 39.208.244 66.753 . 945 161. 633.396 160.541.480 LIABILITIES/FUND EOUITY OEPOSITS FOR PRIVATE OEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAY ABLES , ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUNO 8ALANCES (55.671.208) TOTAL FUND E (55.671.208) (66.753.945) (66.753,945) (66,753.945) (66.753.945) (66.753.945) (66.753.945) (94.879,451) (93,787,535) (94,879,451) (93.787.535) (39.208,244) (39,208.244) TOTAL LIABILITIES/EOUITY (55.671.208) (39.208,244) (66.753.945) (161.633,396)(160,541,480) (e~I? THE CITY OF OU8LIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 09/30/2005 G ENE R AL REVENUE FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y,T,O, VARIANCE *******REVENUES******* PROPERTY TAXES '15.716,461.00 716,900.06 14,999.56094 13.905,268.16 635,550.84 13.269.717.32 SALES TAX 14.984,884.00 2.080,168.87 12,904.715,13 14.615.250.02 2.369.238.35 12.246.0II.67 REAL PROPERTY TRANSFER TAX 745,600.00 136,415.88 609.184,12 831.003.24 73,204.18 757.799,06 HOTEL TRANSIENT OCCUPANCY TAX 680,500.00 136,280.45 544.21955 663.631. 67 133.800.69 529.830.98 FRANCHISE TAXES 1.626,300.00 22,001. 91 1.604.298.09 I. 559 , 900 . 22 126,257.00 1.433.643.22 LICENSES & PERMIT5 2.3BO.013.00 1.126,807.72 1.253,205,28 3.520.140.84 1.569.734.15 I. 950 .406,69 FINES & FORFEITURES 132,200,00 24,651. 35 107.54865 143.316.33 35.750.64 107,565,69 USE/MONEY & PROP-INTEREST 1.757,524.00 232.731. 52 1,524.792 48 1.554.761.10 388.573.32 1.166.187.78 USE/MONEY & PROP-RENTALS 141. 201. 00 12,366.82 128,834,18 125.835.40 22.123.44 103.7II,96 INTERGOVERNMENTAL 498,650.00 669,739.10 (])I. 08910) 568.598.34 275.476,93 293 . 121. 41 CHARGES FOR SERVICES 5.256.561.00 1.072.478.10 4,184,082,90 5.568.306.94 978.808.06 4.589.498,88 OTHER SOURCES OF REVENUE 1.596,243,00 194,917.47 1. 401. 325 53 655.535.31 323.372.01 332.163,30 TOTAL REVENUE 45.516.137.00 6.425,459.25 39,090.677 .75 43.711.547.57 6.931.889.61 36.779.657.96 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES, CITY COUNCIL 300.704,00 44,425.76 256.278,24 224.070.48 45,569.65 178,500,83 CITY MANAGER 997.923,00 196,692.95 801. 230 05 919,976.69 197.869.15 722.107 54 CENTRAL SERVICES 538.55600 77.149.68 461.406,32 362,244.59 72.046.93 290.19766 CITY ATTORNEY 824,252,00 45,687.26 778.564 74 702.958.64 64,185.61 638.773,03 ADMIN SERVICES 1.642.60300 329.867.13 1,312,735,87 1.433,876.94 319.878.18 I. II3. 998.76 BUILDING MANAGEMENT 734,657,00 96,449.44 638.207,56 670.156.93 90.723.66 579,433,27 INSURANCE COST CENTER 397.03800 231,138.00 165.90000 314,526.18 185.695.00 128.831.18 ELECTIONS COST CENTER 2.89000 22.50 2,867,50 12,265.33 50.55 12.214,78 NON-DEPARTMENTAL 87,712,00 754.74 86.95726 68.155.13 68,155,13 ACTIVITY TOTAL 5.526.33500 1. 022,187.46 4,504.147,54 4,708,230.91 976.018.73 3.732.212.18 PUBLI C SAFETY POLICE II,358.537,00 224,304.97 11,134.232 03 9,837,B42.27 236.875.72 9.600,966.55 CROSSING GUARDS 72.28300 821.40 71.461. 60 71,407.04 876.16 70,530.88 ANIMAL CONTROL 208,898,00 208.89800 208.369.91 208,369.91 TRAFFIC 51GNALS & STREET LIG,ITlN 18.11000 1.553.82 16.556,18 8,587.87 1.260.03 7,327.84 DISASTER PREPAREDNESS 74.721. 00 10,130.99 64.590,01 68,023.15 13.455.66 54,567.49 FIRE SERVICES 8,890,188,00 92,065.93 8,798.122.07 8.204.421. 39 98,667,27 8,105,754.12 ACTIVITY TOTAL 20.622.737,00 328,877 .11 20,293.85989 18,398,651. 63 351.134.84 18.047.516.79 TRANSPORTATION PUBLIC WORKS 808,577,00 143,483.72 665.093,28 723,562.41 144,371,83 579,190.58 STREET MAINTENANCE 30,314,00 30.31400 15,908,28 15.908.28 STREET SWEEPING 150.67000 1l,318.01 139.351. 99 140.783,85 11.194.29 129.5B9.56 STREET TREE MAINTENANCE 99 .430 00 17 .366.63 82,063,37 99,195.45 2.817.09 96,378.36 STREET LANDSCAPING MAINTENAN 735.124,00 57,648.07 677.475,93 682,756.30 53.558,82 629,197.48 ACTIVITY TOTAL I.B24,llS,00 229,816.43 1.594.298,57 I. 662 , 206.29 211. 942,03 1. 450 . 264 . 26 HEALTH & WELFARE WASTE MANAGEMENT 2,000.00 (2.00000) 71,474.64 24.592,90 46.881.74 THE CITY OF DUBLIN STATEMENT SHOWING 715(;/3 REVENUES VERSUS EXPENDITURES FOR THE PERIOO 07/01/2005 THROUGH 09/30/2005 G ENE R A L REVENUE FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.LO. VARIANCE CHILD CARE 15.000.00 15.000,00 15,000.00 15,000.00 SOCIAL SERVICES HOUSING PROGRAMS 199.15 199.15 ACTIVITY TOTAL 15.000.00 17 ,000,00 (2.000,00) 86.673.79 24.592.90 62,080.89 CULTURE & LEISURE SERVICES LIBRARY SERVICES 615,611-00 12.755.99 602.B55, OJ 577,722.50 8.686.02 569 . 036.4B CULTURAL ACTIVITIES 204.701- 00 77 .157 .10 127,543,90 124,446.84 31. 265.00 93 .IBl. 84 HERITAGE CENTER 163,333.00 29,774,66 133,558,34 125,627.24 23.375.86 102,251.38 DUBLIN CEMETERY 49,958.00 2.680.08 47.277.92 40.518.28 7.993.63 32,524.65 PARK MAINTENANCE 1.704,065.00 115.886.03 1. 588, 178,97 1.450,064.58 140.427.35 1. 309 . 637 . 23 CCtlMUN ITY Tv 66,407.00 58,715,58 7.691.42 61.809.00 55,539.00 6,270.00 RECREATION ADMIN 704,134.00 139.496.67 564.637.33 608,760.76 134.881-76 473,879.00 PLAYGROUNDS 275.357.00 60,004,71 215.352,29 247,214.27 58.496.43 178,717.84 SHANNON CENTER 342,706.00 66.999.34 275.706.66 301. 087 .47 75.244.03 225 , 843 .44 PRESCHOOL 105.458.00 17.486.01 87,971,99 82,135.86 1S.168.28 66,967.58 TEENS PROGRAM 159,835.00 24,385.93 135.449.07 87,306.66 17 ,210.33 70,096.33 ADULT SPORTS 109,230.00 20.027-25 89.202.75 92,694.01 20.483.06 72,210.95 YOUTH SPORTS 153.617.00 34.264.42 119,352.58 118,533.39 19.881.53 98,651. 86 COMMUN!TV GYM 43,459.00 3.947.03 39.511.97 42,887 Æ 3,602.78 39,285.09 EMERALO GLEN ACTIVITY CENTER SPECIAL EVENTS 364.601. 00 110,635.33 253,965.67 331.898.19 90.345.34 241. 552.85 SEN lOR CENTER 365.728,00 74.079.76 291. 648.24 253,121. 20 48,IS8.90 204,932.30 RECREATION INSTRUCTION 183.023.00 32,117.55 150.905.45 175,147.95 39.545.90 135,502,05 AQUATICS 429,221. 00 121. 942.97 307.278.03 393,660.59 126.602.47 267,058.12 PARKS/FACILITIES MANAGEMENT 308.494.00 64.055.80 244,438.20 261. 928.57 56.228.24 205.700.33 ACTIVITY TOTAL 6.348.938.00 1.066,412.21 5,282,525.79 5.376,565.23 983.165.91 4,393,399,32 COMMUNITY DEVELOPMENT PLANNING 2.685.164.00 464.072.52 2,221. 091. 48 2.414,972.63 503.278.38 1.911,694.15 8UILDING SAFETY 3.213,885.00 451.162.96 2.762.722.04 2.399,434.25 357,306.99 2.032,127.26 ENGINEERING 2.194.005,00 403.127.45 1.790.877.55 2,304,691.55 354.166.98 1.950.524.57 ECONOMIC DEVELOPMENT 340.628 00 89,489.55 251.138.45 272,379.63 115.029.43 157,350.20 ACT! V ITY TOTAL 8.433,682,00 1- 407 . 852.48 7.025.829.52 7.391.477.96 1.339.7SU8 6.051,696.18 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1.319.558,00 33.163.49 1,286.394.51 638 , 027 .42 144,734.34 493,293.08 COMMUNITY IMPROVEMENTS 544,369,00 284.594.04 259.774.96 188,629.59 10.037.14 178.592.45 PARKS 1.518.597,00 384.734.71 1.133.862.29 2,630,020.78 556.694.38 2.073.326.40 STREET CONSTRC/IMPROVEMENTS 1.185.24100 131. 982 .75 1. 053 ,258.25 979,822.61 130.111.62 849,710.99 ACTIVITY TOTAL 4.567.76500 834,474.99 3,733.290.01 4.436,500.40 841.577 .48 3,594.922.92 TOTAL EXPENDITURES 47,338,572,00 4.906,620.68 42.431.951.32 42.060,306.21 4.728.213.67 37.332.092.54 EXCESS REVENUE (EXPENDITURES) (l . 822 .435 , 00) 1.518.838.57 (3.341.273.57) 1.651.24136 2.203.675.94 (552.434.58) TRANSFERS IN FROM OTHER FUNDS 21. 961.11 21. 961.11 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENOITURES (l . 822 .435 , 00) 1.518,838.57 (3,341.273.57) 1.673.202.47 2,203,675.94 (530,473.47) THE CITY OF DU8LIN STATEMENT SHOWING '8 0[) I 3 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 09/30/2005 5 P E C I A L REV E N U E FUNDS CURRENT CURRENT PR lOR PRIOR 8U[)3ET ACTUAL VARIANCE FISCAL YEAR Y.T.O, VARIANCE ********REVENUES******** PROPERTY TAXES 117,680,00 117.68000 112,532.03 112.532.03 SALES TAX/OTHER TAXES 360.500.00 2.424.11 358,075,89 364.477.71 364,477,71 FINES & FORFEITURES 156.000.00 11.525.30 144.474,70 149.341. 93 149,341.93 USES/MONEY & PROPERTY 99.757.00 99.757 00 102,932.29 102.932.29 INTERGOVERNMENTAL FROM STATE 1. 014.231. 00 247.088.24 767,142,76 2.354.339.65 200.447 56 2,153,892,09 INTERGOVERNMENTAL FROM COUNTY 340.440.00 340.440 00 332.344.00 332,344,00 INTERGOVERNMENTAL FROM FEDERAL 76,792.00 1.181. 95 75.610.05 56.796.80 1.653,92 55.142.88 CHARGES FOR SERVICES 1.350,461. 00 1.350.46100 1. 075,178,65 1075.178.65 OTHER SOURCES OF REVENUE 409,500.00 409,500,00 170.482.39 4.51835 165,964,04 TOTAL REVENUE 3.925,361.00 262,219.60 3.663.14140 4.718.425.45 206,619,s3 4.511.805.62 *******EXPENOITURES******* PU8L1 C SAFETY; POll CE 120,255.00 120.255.00 105.952.40 105,952.40 TRAFFIC SIGNALS & STREET LTG 234,700.00 61,697.82 173.002.18 173,175.14 12.65892 160.516.22 OISASTER PREPAREDNESS FIRE SERVICES 270.120.00 1. 875.00 268.245.00 25109121 2,256,18 248.835,03 ACTI V ITY TOTAL 625.075,00 63,572,82 561.502.18 530.218.75 14,915,10 515.30365 TRANSPORTATION; STREET MAINTENANCE 330.474,00 15,991. 99 314 .482.01 272.390.25 14,018,33 258.371,92 STREET SWEEPING ACTIVITY TOTAL 330.474,00 15,991. 99 314.482.01 272.390.25 14,018,33 258.37192 HEALTH & WELFARE: WASTE MANAGEMENT 1.874.906,00 23,034.00 1. 851. 872.00 1383.964.16 7,950,59 1.376.013.57 SOCIAL SERVICES 60.427,00 1979.94 58.447.06 44,927.00 44.927.00 HOUSING PROGRAMS ACTIVITY TOTAL 1935.333,00 25,013.94 1910.319.06 1428.891.16 7,950,69 1420,940.57 COMMUNITY DEVELOPMENT: ENGINEERING 6.00000 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 9,765,00 9.765.00 14,850.00 14,850.00 PARKS 31.310.00 31. 310.00 321.717.00 321.717 . 00 STREET CONSTRUCTION/IMPROVEMENT 1.654.170.00 307,992.87 1.346.177.13 148.044.06 54,419,87 93,624.19 ACTIVITY TOTAL 1695,245.00 307,992.87 1387.252.13 484.611.06 54,419,87 430.191.19 TOT A L EXPENDITURES 4,597,691.00 412.57162 4.185.119.38 2,722,11122 91.30389 2.630,807.33 EXCESS REVENUE (EXPENDITURES) (672.330.00) 050.352.02) (521. 977.98) 1996.314.23 115.315.94 1.880,998.29 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNOS 1. 331. 004.78 1.331.004.78 REVENUES OVER (UNDER) EXPENDITURES (672.330.00) (150.352,02) (521. 977.98) 665.309.45 115,315,94 549,993.51 q d6/~ THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 09/30/2005 S P E C I A LAS S E SSM E N T FUN 0 S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.O. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE 664.610.00 15,478.00 5.000.00 685,088,00 2.578.84 2,578,84 664.610,00 15.478.00 2,421.16 682.509.16 744,099,49 14.748.10 744,099,49 14,748.10 758,847.59 758,847,59 *******EXPENDITURES******* PUBLIC SAFETY; TRAFFIC SIGNALS & STREET LIG 278,600.00 31. 258.50 247.341.50 231. 533 . 62 30..778.70 200.754.92 ACTIVITY TOTAL 278,600,00 31. 258,50 247.341-50 231,533.62 30,778.70 200,754.92 TRANSPORTATION PUBLIC WORKS 2,415.00 340.99 2.074.01 1. 591. 29 296,56 1.294.73 STREET TREE MAINTENANCE 34,231. 00 1.419,91 32,811,09 18,466.76 1.642.55 16.824.21 STREET LANDSCAPE MAINTENANCE 356,039.00 26.996,31 329.04263 317.657.53 30, 111. 55 287,545.98 ACTIVITY TOTAL 392,685.00 28.757.27 363.927.73 337,715.58 32.050.66 305,664.92 COMMUNITY DEVELOPMENT ENGINEERING 13,100,00 8,482,60 4.61740 7.139.94 5,104,96 2.034.98 ACTIVITY TOTAL 13,100.00 8.482.60 4.617,40 7.139.94 5.104,96 2.034.98 CAPITAL IMPROVEMENT PROJECTS, COMMUNITY IMPROVEMENTS 32,920,00 32.920.00 STREET CONSTRUCTION/IMPRVMNT 75,000.00 75,000,00 ACTIVITY TOTAL 107,920,00 107.920.00 TOT A L EXPENDITURES 792,305.00 68,498,37 723.806.63 576.389.14 67.934,32 508,454,82 EXCESS REVENUE (EXPENDITURES) <107,217.00) (65.919.53) (41.297,47) 182.458,45 (61.934,32) 250.392.77 REVENUES OVER (UNDER) EXPENDITURES <107,211.00 ) (65.919,53) (41.297,47) 182.458 45 (67,934,32) 250.392,77 10/3/3 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 09/30/2005 CAP I TAL IMP R 0 V E MEN T FUN 0 S CURRENT BUDGET CURRENT ACTUAL VARIANCE PR lOR FISCAL YEAR PRIOR Y.T.O. VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 865.623.00 19.267.625.00 20.133,248.00 865,623.00 5,467,870.99 13,799,754.01 5,467,870.99 14.665.377.01 1.125,436.25 14.936.285.62 17.370.765.54 7.485.160.11 7,485,160.11 1.125.436.25 7.451.125.51 9,885.605.43 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES, CITY ATTORNEY 38,950.00 3.875.78 35.074.22 35.736.39 35.736.39 ACTlVITY TOTAL 38.950.00 3.875.78 35.074.22 35,736.39 35.736.39 PU8LI C SAFETY; TRANSPORT A TI ON : HEALTH & WELFARE; HOUSING PROGRAMS 899.170.00 55,163.97 844.006.03 219.221.20 31. 360.30 187,860.90 CULTURE & LEISURE SERVICES; RECREATION ADMINISTRATION ACTlVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACT! V ITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 67,700.00 67.700.00 624.943.39 139,564.57 485.378.82 COMMUNITY IMPROVEMENTS 251. 251. 50 251.251.50 PARKS 9.183.930.00 1.064.627.42 8,119,302.5S 6.285.687.19 103,698.71 6,181.988.48 STREET CONSTRUCTION/IMPROVEMENT 36.028,246.00 41.910.03 35.986.335.97 3.970,457.62 113.672.92 3.856.784.70 ACTIVITY TOTAL 45.279.876.00 1.106,537.45 44,173,338.55 11.132.339.70 356.936.20 10,775,403.50 TOT A L EXPENDITURES 46.217.996.00 1.165.577 . 20 45.052.418.80 11.387,297.29 388.296.50 10.999.000.79 EXCESS REVENUE (EXPENDITURES) (26.084.748.00) 4,302,293.79 (30,387.041.79) 4.674.424.58 7,096,863.61 (2,422.439.03) TRANSFER IN FROM OTHER FUNDS 0.309,043.67) 0.309.043.67) TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES(26.084,748.00) 4,302,293.79 (30.387.041.79) 5.983.468.25 7,096,863.61 (1.113.395.36) ¡Ivbl? THl CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 09/30/2005 T R U S T / AGE N C Y FUN D CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 228.280.46 228.280,46 USES/MONEY & PROP-INTEREST 5.612,63 5.61263 TOTAL REVENUE 233.893.09 233.893,09 *******EXPENOITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 231. 038,00 182,448.75 48.589.25 232.57I.18 178.745.43 53.825,75 ACTIVITY TOTAL 231,03800 182,448.75 48.589,25 232.571.18 178.745.43 53.82575 PU8LI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS lOT A L EXPENDITURES ?31. 038.00 182,448.75 48.589,25 232.571.18 178.74543 53.825.75 EXCESS REVENUE (EXPENDITURES) (231.038,00) (182,448.75) (48,58925) 1. 321. 91 (l78.745,43) 180,067,34 REVENUES OVER (UNDER) EXPENDITURES (231.038,00) (182,448.75) (48.589,25) 1.321. 91 (l78.745 ,43) 180,067.34 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 09/30/2005 Ia. tp; Fj I N T ERN A L S E R V ICE FUN 0 S CURRENT CURRENT PRIOR PR lOR BU[)3ET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 297.089.00 297.089.00 245.407.37 245.407.37 CHARGES FOR SERVICES 1.796,096.00 295.668.67 1. 500 .427 33 1. 642.441. 30 389.978.00 1. 252 .463.30 OTHER SOURCES OF REVENUE 23.400.00 14.525.00 8.875.00 14.606.96 14,606.96 TOT AI. REVENUE 2. 1I6, 585.00 310.193.67 1. 806.391. 33 1.902.455.63 389.97800 1.512.477 .63 *******EXPENOITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2.074.072.00 95. OSI. 58 1.978.990.42 1.130.744.57 539.724.13 591. 020.44 ACTIVITY TOTAL 2.074.072.00 95.081. 58 1. 978.990.42 1.130.744.57 539.724.13 591. 020.44 PUBLIC SAFETY: FIRE 65.561. 00 65.561.00 44.662.77 44.652.77 ACTIVITY TOTAL 65.561. 00 66.661.00 44.652.77 44.652.77 TRANSPORTATION: HEALTH & WELFARE; CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS; TOT A L EXPENDITURES 2.139.633.00 95.081. 58 2.044.551.42 1.175.397.34 539.724.13 635.673. 21 EXCESS REVENUE (EXPENDITURES) (23.048.00) 215.112.09 (238.160.09) 727.068.29 (149.746.13) 876,804.42 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES. (23.048.00) 215.112.09 (238.160.09) 727.058.29 (149.746.13) 876.804.42 ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACTIVITY TOTAL PUBLl C SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS; TOT A L EXPENDITURES EXCESS REVENUE (EXPENDITURES) TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES CURRENT BU[X;ET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2D05 THROUGH 09/30/2005 E N T E R P R I S E FUN D CURRENT ACTUAL PRIOR FISCAL YEAR VARIANCE PRIOR Y.T.O. /5 é0/3 VARIANCE