Loading...
HomeMy WebLinkAbout4.08 Financial Rpts 9/04 CITY CLERK File # D~[Q]~ AGENDA STATEMENT CITY COUNCIL MEETING DATE: October 19,2004 SUBJECT: Financial Reports for the Month of September 2004 Report Prepared by: Fred W Marsh, Finance Manager and Lisa Hisatomi, Administrative Analyst II ATTACHMENTS: l. 2. 3. YTD Revenues and Budget Comparison YTD Expenses and Budget Comparison Financial Statements for the Months of September 2004 RECOMMENDATION: ~ FINANCIAL STATEMENT: Receive the reports. See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary financial statements for the month of September 2004. The final audited results for Fiscal Year 2003-2004 are not yet available; therefore, this report is presented as "preliminary" at this time. Consistent with prior reports, the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion ofthe City's operations. Note that the City's revised budget has now accounted for all items affecting the City as part of the State's adopted budget for Fiscal Year 2004-2005. Agenda reports were previously presented to Council in September discussing the impacts of the passage of the State Budget for Fiscal Year 2004-2005 and Proposition IA which proposes establishing protections for revenues received by local governments. Analvsis of September 2004 Revenue and Expenditure Report In November 2004, the auditors will start the final phase of the fieldwork necessary for the Fiscal Year 2003-2004 audit. The final audit results will impact the reported Fund Balance presented in the attached monthly reports. 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. 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 September are comparable to what occurred in the third month of the previous Fiscal Year. Through September 2004, the City had collected approximately 17% ---------------------------------------------------------------------------~--------------------------------- COPIES TO: Document in FSCOLQR 09-2004.XLS l~ ITEM NO. ~ ~ of the total budgeted General Fund Revenues, which was 4% more than the percentage collected in the prior Fiscal Year. Real property transfer taxes are higher than in the same period of the prior year due to timing differences in the collection of these taxes. Licenses and Permits are higher than in the same period of the prior year due to an increase in the valuation of building permits on new residential and commercial projects. Interest and Rentals are higher than prior year timing differences in the receipt of interest payments and an increase in the rate of return on the City's investments. Initially all 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 same period of the prior year due to the suspension of Vehicle License Fee (VLF) backfill payments to the City for three months in the early part of Fiscal Year 2003-2004. Also, additional cuts to the VLF allocation, which were included as part of the adopted State Budget for Fiscal Year 2004-2005, have not yet been implemented. These cuts, when the budget reduction formulas are finalized by the Department of Motor Vehicles, will result in reduced VLF payments to the City for the remainder of the current Fiscal Year. Charges for Services are higher than in the same period of the previous year due to additional zoning and subdivision fees and plan check and inspection fees received due to new development. Fines and Forfeitures are higher than in the same period of the previous year due to timing differences in the collection of parking and court fines. Other revenues are higher than in the same period of the prior year due to developer reimbursements received for the costs of maintaining new storm drains and reimbursements received from the City of Pleasanton for the design of improvements to the Fallon Road Interchange. General Fund Expenditures Overall, through the month of September, expenditures in the General Fund totaled $4.6 million and represented approximately 10% of the total budgeted expenditures in the General Fund. Of this amount, a total of approximately $840,000 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 September 2004 was similar to the amounts expended for the same period in the prior Fiscal Year. Through the end of September 2004, the City had expended 10% of the General Fund Operating Budget, which was similar to the amount expended in the prior Fiscal Year. Health and Welfare expenditures are higher than in the same period of the prior year due to expenditures incurred to date on consultant services related to the solid waste request for proposal (RFP). Capital Improvement Project expenditures are higher than in the same period of the previous year due to expenditures incurred on the construction of the new senior center. As previously noted there are some timing differences with payment for contract services, which complicate comparisons from one year to the next. 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. ~~ ---.... ......-..--...-----.-....-.... .......-.....-..-------.---- \00 I~ City of Dublin 2004-2005 YTD Revenues and Budget Comparison JIºrJþ~:r~rlº(:LEmliÐg~~pt~Qlþ-~.L~,º,".2Qº4-,---,- _] 170 Total General Fund Revenues 13% I 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 0% 30% . FY 2004/05 . FY 2003/04 8% 61% 60% 90% 120% 150% 25% of Year Complete --------. FY 2004/05 FY 2004/05 DID of FY 2003/04 % of Total for Budget YTD Actual Budget YTD Actual FY 2003/04 Property Taxes 13,661,980 635,551 5% 633,580 5% Sales Taxes 13,613,216 2,369,238 17% 2,509,697 18% Real Property Transfer Tax 520,000 73,204 14% 36,245 6% Transient Occupancy Taxes 610,000 133,801 22% 125,227 19% Franchise Taxes 1,536,000 126,257 8% 118,670 8% Licenses and Permits 2,723,912 1,569,734 58% 869,458 28% Interest and Rentals 1,538,090 412,046 27% 95,663 15% Intergovernmental 449,100 275,477 61% 245,635 13% Charges for Services 5,117,168 970,157 19% 680,986 14% Fines and Forfeitures 112,900 34,446 31% 20,727 18% Other Revenues 1 ,437,280 323,372 22% 15,133 2% Total General Fund Revenues 41,319,646 6,923,283 17% 5,351,021 13% IC--l qo ...(;)'1 4·tS Date Printed: 1018J2004 12:41 PM ATTACHMENT 1 ~ ~ '2___________ City of Dublin 2004-2005 YTD Expenses and Budget Comparison For the Period EndiD Se t~~ber 30,~004 Fire . FY 2004/05 III FY 2003/04 Total General Fund Expenses General Government Police Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects 0% 20% 40% 60% 80% 25% of Year Complete 100% 120% ..---.-.--.-.---.."......-. ..-..--- "'.--.---.---.- 2004/05 2004/05 %of FY 2003/04 % of Total for Budget YTD Actual Budget YTD Actual FY 2003/04 General Government 4,964,972 947,484 19% 829,895 18% Police 9,882,259 226,124 2% 243,059 3% Fire 8,156,645 79,887 1% 90,298 1% other Public Safety 421,298 15,266 4% 11,856 3% Transportation 1,690,651 207,062 12% 222,564 15% Health and Welfare 78,125 24,593 31% 22,027 27% Culture and Community Services 5,863,186 961,843 16% 907,834 18% Community Development 7,807,374 1,317,482 17% 1,119,389 18% Capital Improvement Projects 5,814,403 841,187 14% 206,342 5% Total General Fund Expenses 44,678,913 4,620,928 10% 3,653,264 10% General Fund Operating Expenses 38,864,510 3,779,741 10% 3,446,922 10% Dale PrInted: 10I6l2OO4 12:45 PM ATTACHMENT 2 '3 "b \~ CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF SEPTEMBER 2004 Prepared by The Finance Department October 6, 2004 ATTACHMENT 3 t.f ~ ~ CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Sep2004 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 (49.789.958) 4.006.390 337.908 38.142.269 20.962 (7.282.428) (20.805.238) CASH WITH FISCAL AGENT 172.779 172.779 172.312 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 100.359.073 100.359.073 94.112.095 RECEIVABLES: TAXES ACCOUNTS 370.021 14.664 384.685 184.020 INTEREST 496.242 496.242 200.330 ASSESSMENTS DUE FROM OTHERS 308.720 308.720 308.720 INVENTORY AT COST PREPAID ITEMS II .499 II .499 9.913 FIXED ASSETS AMOUNT TO BE PROVIDED 1.447.500 1.447.500 1.447.500 TOTAL ASSETS 51. 755.598 4.021. 054 337.908 38.142.269 1. 641. 241 95.898.070 75.629.653 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (972.824) (972.824) (955.826) DEPOSITS FOR AB1600 FEES (81.736) (35.350) 017.086) (1.576.440) DEPOSITS OTHERS (2.268.492) (2.268.492) (996.979) PAYABLES: ACCOUNTS 552.106 (52.124) (271. 667) 228.314 (3.306.613) INTEREST PAYROLL (548.096) (548.096) (547.458) DUE TO OTHERS (33.842) (308.720) (342.562) (320.540) DEFERRED REVENUE 027.768) 027.768) (127.768) DEBT INSTRUMENTS PAYABLE 0.565.000) 0.565.000) o .565.000) TOTAL LIABILITIES (3.480.652) (360.845) (307.017) 0.565.000) (5.713.514) (9.396.624) FUND BALANCES (48.274.945) (3.660.210) (337.908) (37.835.252) (76.241) (90.184.556) (66.233.029) TOTAL FUND E (48.274,945) (3.660.210) (337.908) (37.835.252) (76.241) (90.184.556) (66.233.029) TOTAL LIABILITIES/EQUITY (51.755,598) (4.021. 054) (337.908) (38.142.269) (1.641.241) (95.898.070) (75.629.653) 56b1:; CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Sep2004 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOT A L S SERVICE FUND GROUP OF TERM DEBT ---MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT PRIOR ASSETS CASH 7.958.413 (20) 7.958.393 7.285.863 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 47.265.633 19.466.456 66.732.089 66.732.089 AMOUNT TO BE PROVIDED 68.580.288 68.580,288 68.752.907 TOTAL ASSETS 55.224.047 (20) 19.466,456 68.580,288 143.270.771 142.770.859 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAY ABLES: ACCOUNTS (17 .215) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (68.580,288) (68.580,288) (68.752.907) TOTAL LIABILITIES (68.580,288) (68.580,288) (68.770.122) FUND BALANCES (55,224.047) 20 (19.466.456) (74.690.483) (74.000,737) TOTAL FUND E (55,224.047) 20 (19 .466 .456 ) (74.690,483) (74.000.737) TOTAL LIABILITIES/EQUITY (55.224.047) 20 (19,466.456) (68.580.288) (143.270.771)(142.770,859) THE CITY OF DUBLIN STATEMENT SHOWING l.t' 6b '3- REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 09/30/2004 G ENE R A L REV E N U E FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 13,661. 980.00 635,550.84 13.026.429.16 12.085.708.32 633.580.48 11,452,127.84 SALES TAX 13.613.216.00 2,369.238.35 11.243,977.65 13.940,263.36 2,509,697.43 11,430.565.93 REAL PROPERTY TRANSFER TAX 520,000.00 73,204.18 446.795.82 571. 360.79 36,245.25 535.115.54 HOTEL TRANSIENT OCCUPANCY TAX 610,000.00 133,800.69 476.199.31 664.308.51 125.226.90 539.081. 61 FRANCHISE TAXES 1. 536.000. 00 126.257.00 1.409.743.00 1. 505.434.53 118.670.00 1. 386 .764.53 LICENSES & PERMITS 2.723.912.00 1. 569 .734 .15 1.154,177 .85 3.090.992.17 869.458.12 2.221.534.05 FINES & FORFEITURES 112.900.00 34 .445 . 64 78,454.36 117.369.48 20.727.37 96 . 642 .11 USE/MONEY & PROP-INTEREST 1. 369 .725.00 389.922.36 979.802.64 492.971.23 62.676.69 430,294.54 USE/MONEY & PROP-RENTALS 168.365.00 22.123.44 146.241. 56 130.741.40 32.986.58 97.754.82 INTERGOVERNMENTAL 449,100.00 275.476.93 173.623.07 1. 828. 992.93 245.634.71 1. 583 .358.22 CHARGES FOR SERVICES 5,117.168.00 970.156.85 4.147.011.15 4.801.136.74 680.985.64 4.120.151.10 OTHER SOURCES OF REVENUE 1.437.280.00 323.372.01 1.113.907 .99 845.368.13 15,132.90 830.235.23 TOTAL REVENUE 41. 319.646.00 6.923.282.44 34.396.363.56 40,074.647.59 5,351. 022.07 34.723.625.52 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 252.910.00 44.467.15 208.442.85 209.858.23 38.660.15 171.198.08 CITY MANAGER 928.273.00 192.859.34 735.413.66 817.034.42 174.756.31 642,278.11 CENTRAL SERVICES 350.911.00 70.194.05 280.716.95 341.914.49 61. 423.93 280.490.56 CITY ATTORNEY 689.493.00 63.677.28 625.815.72 698.116.15 38.282.94 659,833.21 ADMIN SERVICES 1.557.095.00 311.491. 92 1. 245.603.08 1. 244.537.07 275.905.18 968.631.89 BUILDING MANAGEMENT 641.134.00 79.049.08 562.084.92 757,522.96 105.550.90 651. 972.06 INSURANCE COST CENTER 358.986.00 185.695.00 173.291.00 420.061.97 135,291.17 284.770.80 ELECTIONS COST CENTER 15,670.00 50.55 15.619.45 2.541.41 24.70 2.516.71 NON-DEPARTMENTAL 170,500.00 170.500.00 125.656.16 125.656.16 ACTIVITY TOTAL 4.964.972.00 947.484.37 4.017.487.63 4.617.242.86 829.895.28 3.787.347.58 PUBLI C SAFETY POLI CE 9.882,259.00 226.124.40 9.656.134.60 8.570.781.93 243.059.28 8.327.722.65 CROSSING GUARDS 72.283.00 876.16 71.406.84 65.794.14 65.794.14 ANIMAL CONTROL 266.362.00 266.362.00 198.953.52 198.953.52 TRAFFIC SIGNALS & STREET LIGHTIN 17,240.00 1.260.03 15.979.97 6.543.33 188.36 6.354.97 DISASTER PREPAREDNESS 65.413.00 13.129.41 52.283.59 70.993.74 11,667.20 59.326.54 FIRE SERVICES 8.156.645.00 79.887.25 8,076.757.75 7 .440.483.12 90.298.38 7.350.184.74 ACTI V ITY TOTAL 18.460.202.00 321.277.25 18.138,924.75 16.353.549.78 345.213.22 16.008.336.56 TRANSPORTATION PUBLIC WORKS 738.575.00 139.491. 97 599.083.03 686,881.45 143.539.35 543.342.10 STREET MAINTENANCE 14.802.00 14.802.00 3.703.99 202.30 3.501.69 STREET SWEEPING 149.207.00 11 , 194 . 29 138.012.71 127,807.29 10.819.19 116.988.10 STREET TREE MAINTENANCE 97.352.00 2.817.09 94.534.91 117.583.47 23.885.87 93.697.60 STREET LANDSCAPING MAINTENAN 690.715.00 53.558.82 637.156.18 593.488.01 44.117.78 549.370.23 ACTI V ITY TOTAL 1. 690.651. 00 207,062.17 1.483.588.83 1. 529 .464.21 222.564.49 1. 306 . 899 . 72 HEALTH & WELFARE WASTE MANAGEMENT 63.125.00 24,592.90 38.532.10 46.419.04 2.000.00 44.419.04 CHILD CARE 15,000.00 15.000.00 18.500.00 18,500.00 SOCIAL SERVICES 1.000.00 1.000.00 HOUSING PROGRAMS 16.893.18 527.18 16.366.00 1'4,'3:- THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 09/30/2004 G ENE R A L REV E N U E FUN D CURRENT CURRENT PRIOR PRIOR BUOGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE ACTI V ITY TOTAL 78.125.00 24.592.90 53.532.10 82.812.22 22.027.18 60.785.04 CULTURE & LEISURE SERVICES LIBRARY SERVICES 582.730.00 8.686.02 574,043.98 522.604.10 10.643.16 511. 960.94 CULTURAL ACTIVITIES 159.718.00 30.663.00 129,055.00 110,249.30 53.052.50 57.196.80 HERITAGE CENTER 141. 355.00 22.403.14 118,951. 86 99,628.11 19.654.39 79.973.72 DUBLIN CEMETERY 53.602.00 7.993.63 45,608.37 53.533.84 2.271.16 51. 262.68 PARK MAINTENANCE 1. 532 . 409.00 140.427.35 1. 391. 981. 65 1.403.774.51 108.484.68 1.295.289.83 COMMUNITY TV 62,999.00 55.539.00 7.460.00 62.020.72 56.510.38 5,510.34 RECREATION ADMIN 638,564.00 130.034.28 508.529.72 518.312.54 114.816.64 403.495.90 PLAYGROUNDS 277,082.00 67.733.93 209.348.07 237.599.33 63.879.72 173,719.61 SHANNON CENTER 389.176.00 68.588.52 320.587.48 294.742.36 55.623.22 239.119.14 PRESCHOOL 90.699.00 14.659.95 76.039.05 77.388.27 13.745.20 63.643.07 TEENS PROGRAM 118.941.00 16.956.16 101. 984.84 86.212.99 18.686.47 67.526.52 ADULT SPORTS 110,559.00 20.279.73 90.279.27 101.640.17 24.245.60 77.394.57 YOUTH SPORTS 138.824.00 19.678.20 119.145.80 122.764.81 16.130.82 106.633.99 COMMUN ITY GYM 46.504.00 3.602.78 42.901. 22 37.309.40 2.772.91 34.536.49 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 339.220.00 89.709.92 249.510.08 348.052.22 83.602.36 264.449.86 SENIOR CENTER 297.455.00 45.123.96 252,331.04 223.784.61 45.825.07 177.959.54 RECREATION INSTRUCTION 195.220.00 39,037.57 156,182.43 185.369.65 48.404.18 136,965.47 AQUATICS 407.136.00 125.956.05 281,179.95 366.568.40 117.863.03 248.705.37 PARKS/FACILITIES MANAGEMENT 280.993.00 54.770.15 226,222.85 246.546.42 51. 622.54 194.923.88 ACTIVITY TOTAL 5.863.186.00 961. 843.34 4.901.342.66 5.098.101.75 907.834.03 4,190.267.72 COMMUNITY DEVELOPMENT PLANNING 2.731. 301. 00 493.136.14 2.238,164.86 2.271.403.13 392.639.42 1.878.763.71 BUILDING SAFETY 2.580.214.00 361.624.84 2.218.589.16 1.907,211.35 293.293.66 1.613.917.69 ENGINEERING 2.209.633.00 348,658.58 1.860.974.42 1.861.971.85 332.632.02 1. 529 , 339 . 83 ECONOMIC DEVELOPMENT 286.226.00 114.062.65 172.163.35 302.134.33 100.823.45 201. 310.88 ACTI V ITY TOTAL 7.807.374.00 1.317.482.21 6.489.891. 79 6.342.720.66 1. 119 . 388 . 55 5.223,332.11 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1. 020.815.00 144.734.34 876.080.66 924,023.70 19.142.19 904.881.51 COMMUNITY IMPROVEMENTS 799.839.00 9.874.57 789.964.43 718.087.36 26.278.48 691.808.88 PARKS 2.619.129.00 556.605.85 2.062.523.15 1. 829 .760 . 32 121. 603.71 1. 708.156.61 STREET CONSTRC/IMPROVEMENTS 1. 374.620.00 129.972 . 71 1.244.647.29 564.404.95 39.317.15 525,087.80 ACTIVITY TOTAL 5.814.403.00 841.187.47 4,973,215.53 4.036.276.33 206,341. 53 3.829.934.80 TOTAL EXPENDITURES 44.678.913.00 4.620.929.71 40,057.983.29 38.060.167.81 3,653.264.28 34.406.903.53 EXCESS REVENUE (EXPENDITURES) (3.359.267.00) 2.302.352.73 (5.661. 619.73) 2.014.479.78 1.697.757.79 316.721.99 TRANSFERS IN FROM OTHER FUNDS 21. 842 . 35 21. 842.35 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (3.359.267.00) 2.302.352.73 (5.661.619.73) 2.036.322.13 1. 697.757.79 338.564.34 THE CITY OF DUBLIN STATEMENT SHOWING tsø(,l.3 REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 09/30/2004 S P E C I A L REV E N U E FUN 0 S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 111.049.00 111.049.00 105.605.41 105.605.41 SALES TAX/OTHER TAXES 336.500.00 336.500.00 357.441. 52 357.441.52 FINES & FORFEITURES 164.000.00 164.000.00 154.784.03 12.272.78 142.511.25 USES/MONEY & PROPERTY 89.24B.00 89.248.00 29.822.10 14.494.78 15.327.32 INTERGOVERNMENTAL FROM STATE 1.188.010.00 200,447.56 987.562.44 2.420.722.35 200.634.69 2.220.087.66 INTERGOVERNMENTAL FROM COUNTY 306.890.00 306,890.00 269.149.00 269.149.00 INTERGOVERNMENTAL FROM FEDERAL 97.718.00 1.653.92 96.064.08 126.139.22 126.139.22 CHARGES FOR SERVICES 1. 056.723.00 1.056.723.00 988.833.16 988.833.16 OTHER SOURCES OF REVENUE 160.500.00 4.518.35 155.981.65 291.518.00 291.518.00 TOTAL REVENUE 3.510.638.00 206.619.83 3,304.018.17 4.744.014.79 227.402.25 4.516.612.54 *******EXPENDITURES******* PUBLIC SAFETY: POLI CE 121.560.00 121.560.00 161. 642.54 161. 642.54 TRAFFIC SIGNALS & STREET LTG 217.596.00 8.492.26 209.103.74 143,451.04 14.748.06 128.702.98 DISASTER PREPAREDNESS 8,179.22 2.175.00 6.004.22 FIRE SERVICES 287.626.00 2.256.18 285.369.82 211.138.48 1.250.00 209.888.48 ACTIVITY TOTAL 626.782.00 10.748.44 616.033.56 524,411.28 18.173.06 506.238.22 TRANSPORTATION: STREET MAINTENANCE 301. 750.00 14.018.33 287,731.67 216.334.44 14.677.72 201. 656.72 STREET SWEEPING ACTI V ITY TOTAL 301.750.00 14,018.33 287.731.67 216.334.44 14.677.72 201. 656.72 HEALTH & WELFARE: WASTE MANAGEMENT 1.346.244.00 7.782.84 1.338.461.16 1.248.019.76 1.250.00 1. 246 .769.76 SOCIAL SERVICES 44,927.00 44.927.00 44.935.00 44.935.00 HOUSING PROGRAMS ACTI V ITY TOTAL 1.391.171.00 7.782.84 1.383.388.16 1. 292.954.76 1.250.00 1. 291. 704.76 COMMUNITY DEVELOPMENT: ENGINEERING 6.000.00 6.000.00 6.000.00 6.000.00 ACTI V ITY TOTAL 6.000.00 6.000.00 6.000.00 6,000.00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS 44.928.00 44.928.00 63.670.75 63.670.75 PARKS 321. 717 . 00 321. 717.00 6.000.00 6.000.00 STREET CONSTRUCTION/IMPROVEMENT 667.210.00 54.303.86 612.906.14 1. 534 . 690 . 65 17.956.02 1. 516 .734.63 ACTI V ITY TOTAL 1. 033 . 855 . 00 54.303.86 979.551.14 1.604.361.40 17.956.02 1. 586 .405 . 38 TOT A L EXPENDITURES 3.359.558.00 86,853.47 3.272.704.53 3.644,061.88 52,056.80 3.592.005.08 EXCESS REVENUE (EXPENDITURES) 151.080.00 119,766.36 31. 313.64 1.099,952.91 175.345.45 924.607.46 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 21. 842 . 35 21. 842 . 35 REVENUES OVER (UNDER) EXPENDITURES 151.080.00 119.766.36 31. 313.64 1.078.110.56 175.345.45 902.765.11 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 09/30/2004 q~l~ S P E C I A L ASS E SSM E N T FUN 0 S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 639.589.00 639.589.00 593.202.41 593.202.41 USES/MONEY & PROP-INTEREST 12.909.00 12.909.00 4.093.98 1. 899 . 06 2.194.92 OTHER SOURCES OF REVENUE 5.000.00 5.000.00 144.29 144.29 TOTAL REVENUE 657.498.00 657.498.00 597.440.68 2.043.35 595.397.33 *******EX PEND I TURES******* PUBLI C SAFETY: TRAFFIC SIGNALS & STREET LIG 306.088.00 30.778.70 275.309.30 217.534.35 29.032.55 188.501.80 ACTI V ITY TOTAL 306.088.00 30.778.70 275.309.30 217.534.35 29.032.55 188.501.80 TRANSPORTATION PUBLIC WORKS 1.436.00 296.56 1.139.44 1.352.46 262.33 1. 090 . 13 STREET TREE MAINTENANCE 27.099.00 1.642.55 25 .456 . 45 26.752.22 97.08 26.655.14 STREET LANDSCAPE MAINTENANCE 344.474.00 30 . 111. 55 314.362.45 296.360.83 20.472.09 275.888.74 ACTIVITY TOTAL 373.009.00 32.050.66 340.958.34 324.465.51 20.831. 50 303.634.01 COMMUNITY DEVELOPMENT ENGINEERING 12.750.00 5.104.96 7.645.04 15.007.20 8.105.50 6.901.70 ACTI V ITY TOTAL 12.750.00 5.104.96 7.645.04 15.007.20 8.105.50 6.901.70 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS STREET CONSTRUCTION/IMPRVMNT 53.878.94 53.878.94 ACTI V ITY TOTAL 53.878.94 53.878.94 TOT A L EXPENDITURES 691.847.00 67.934.32 623.912.68 610.886.00 57.969.55 552.916.45 EXCESS REVENUE (EXPENDITURES) (34.349.00) (67.934.32) 33.585.32 (13.445.32) (55.926.20) 42.480.88 REVENUES OVER (UNDER) EXPENDITURES (34.349.00) (67.934.32) 33.585.32 (13.445.32) (55.926.20) 42,480.88 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENOITURES FOR THE PERIOO 07/01/2004 THROUGH 09/30/2004 IDøë,I3> CAP I TAL IMP R 0 V E MEN T FUN D S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST 810.154.00 810.154.00 330.842.99 159.451. 55 171.391.44 OTHER SOURCES OF REVENUE 18.631. 900.00 7.485.160.11 11.146.739.89 13.455.275.26 13.455.275.26 TOTAL REVENUE: 19.442.054.00 7.485.160.11 11.956.893.89 13.786.118.25 159.451.55 13.626.666.70 *******EX PEND I TURES******* GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 55.300.00 55.300.00 95.175.29 1.422.00 93.753.29 ACTIVITY TOTAL 55.300.00 55.300.00 95.175.29 1.422.00 93.753.29 PUBLI C SAFETY: TRANSPORT A TI ON : HEALTH & WELFARE: HOUSING PROGRAMS 809.412.00 30.233.30 779.178.70 2.252,493.88 81.190.16 2.171.303.72 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 5.000.00 139,564.57 (134.564.57) 1. 344.731. 36 464.517.81 880.213.55 COMMUNITY IMPROVEMENTS 36,771. 00 36.771. 00 PARKS 13.582.774.00 103.677.34 13.479.096.66 3.566.651.85 278.275.79 3.288.376.06 STREET CONSTRUCTION/IMPROVEMENT 18.694.364.00 112.778.46 18.581.585.54 6.499.154.56 342.221.94 6.156.932.62 ACTIVITY TOTAL 32.318.909.00 356.020.37 31.962.888.63 11.410.537.77 1.085.015.54 10.325.522.23 TOT A L EXPENDITURES 33.183.621. 00 386.253.67 32.797,367.33 13.758.206.94 1.167.627.70 12.590.579.24 EXCESS REVENUE (EXPENDITURES) (13.741. 567 . 00) 7.098.906.44 (20.840.473.44) 27.911.31 (1.008.176.15) 1. 036 . 087 . 46 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES(13.741.567.00) 7.098.906.44 (20.840.473.44) 27.911.31 (1.008,176.15) 1.036.087.46 1I~/~~' THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 09/30/2004 T R U S T / AGE N C Y FU N D CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 233.713.12 233.713.12 USES/MONEY & PROP-INTEREST 1.467.95 354.01 1.113.94 TOTAL REVENUE 235.181.07 354.01 234.827.06 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 228.196.00 178.745.43 49.450.57 229.893.50 173.508.25 56.385.25 ACTIVITY TOTAL 228.196.00 178.745.43 49.450.57 229.893.50 173.508.25 56.385.25 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 228.196.00 178.745.43 49.450.57 229.893.50 173.508.25 56.385.25 EXCESS REVENUE (EXPENDITURES) (228.196.00) 078.745.43) (49.450.57) 5.287.57 073.154.24) 178.441.81 REVENUES OVER (UNDER) EXPENDITURES (228.196.00) 078.745.43) (49.450.57) 5.287.57 073.154.24) 178.441.81 THE CITY OF DUBLIN STATEMENT SHOWING I2.Cb¡:; REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 09/30/2004 I N T ERN A L S E R V ICE FUN 0 S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 226,186.00 226.186.00 72.481. 36 33.799.29 38.682.07 CHARGES FOR SERVICES 1.733,474.00 281. 014.89 1. 452 .459 .11 1. 690.762.96 398.647.26 1. 292 .115.70 OTHER SOURCES OF REVENUE 21.122.00 21.122.00 18.206.68 18.206.68 TOTAL REVENUE 1,980,782.00 281. 014.89 1.699,767.11 1,781.451.00 432,446.55 1. 349.004.45 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2.309.746.00 539,724.13 1. 770.021. 87 504.332.93 160.871.92 343.461.01 ACTIVITY TOTAL 2.309,746.00 539.724.13 1. 770.021. 87 504,332.93 160,871.92 343,461.01 PUBLIC SAFETY: FIRE 66,010.00 66,010.00 57.068.73 57.068.73 ACTIVITY TOTAL 66,010.00 66,010.00 57.068.73 57.068.73 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 2.375.756.00 539,724.13 1. 836,031. 87 561.401.66 160.871. 92 400,529.74 EXCESS REVENUE (EXPENDITURES) (394.974.00) (258,709.24) (136,264.76) 1.220,049.34 271,574.63 948.474.71 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (394,974.00) (258,709.24) (136,264.76) 1. 220 , 049 . 34 271.574.63 948,474.71 ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACT! V !TY TOTAL PUBLIC 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 BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2004 THROUGH 09/30/2004 E N T E R P R I S E FUN D CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR 20.00 20.00 20.00 (20.00) (20.00) PRIOR Y.T.D. /3tt>1\3 VARIANCE 20.00 20.00 20.00 (20.00) (20.00)