The URL can be used to link to this page

Home My WebLink About4.02 FinancialRptJuly05 CITY CLERK File # Dr?ßllQ]-~ AGENDA STATEMENT CITY COUNCIL MEETING DATE: August 16,2005 SUBJECT: Financial Reports for the Month of July 2005 Report Prepared by: Carole A. Perry. Administrative Services Director and Fred w: Marsh, Finance Manager A TT ACHMENTS: I. YTD Revenues and Budget Comparison 2. YTD Expenses and Budget Comparison 3. Financial Statements for July 2005 RECOMMENDA TION: ~Receive the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report on the preliminary tlnaneial statements for the month of July 2005. Consistent with prior reports, the foclls will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Analvsis of Julv 2005 Revenue and EXDenditure ReDorts The July reports represent the reporting of revenues and expenditures for the one month of the Fiscal Year, through July 31, 2005. It should also be noted that there is not an cvcn distribution ofrevenues 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. In October 2005, the auditors will start the final 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. Given July is only the first month of the Fiscal Year, there is extremely limited data on which to base any major projections or identify signifícant 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 July are lower than what occurred in the first month of the previous Fiscal Year. Through July 2005, the City had collected approximately 4% of the total budgeted Gencral Fund Revenues, which was I % less than the percentage collected in the prior Fiscal Year. A brief description is provided below to explain any material revenue variations. ~______________________________________________W~_____-______________________________________________.~__~___ COPIES TO: Dotulnent In FSCOLOR 07a200S.XLS 10:0 ¿. ITEM NO. L\- .2, Licenses and Permits are lower than in the same period 0 [ the prior year due to a decrease in the valuation of building permits on new residential and commercial projects_ Interest and Rentals received to date are higher than the prior year due to an increase in the rate of rcturn on the City's investments. Initially all interest revenue is recorded in thc Gcncral Fund and is then allocated quarterly to other funds on a pro rata basis. Intergovernmental revenue is higher than in the prior year due to an carly 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 ahcad of schedule; therefore, no revenue was budgeted for this cvent. However, with the adoption of the State Budgct, cities were advised that the VLF Gap Loan would be repaid early. The City of Dublin received this paymcnt on July 27,2005 in an amount of$602,746.85. General Fund Expenditures Overall, through the month of July, expenditures in the Gcneral Fund totaled about $1.0 million and represented approximately 2% of thc total budgeted expenditures in the General Fund. Of this anlount, a total of approximately $17,000 was related to Capital Improvemcnt Projects and the remainder was related to Operating Costs reported in the General Fund. Capital Project expenditures typicaJJy do not follow an even distribution due to differences in project timing. In looking only at General Fund Operating Expcnditures, the activity through July 2005 was similar to the amounts expended for the same period in the prior Fiscal Year. Through the end of July 2005, the City had expended 2% of the General Fund Operating Budget, which was the same as the amount expended in the prior Fiscal Year. All cxpenditures are within the authorized budget. It is recommended that the City Council receive these reports as authorized by Section 41004 ofthe California Government Code. 2 iJþ 2-- n_.__.___.. /CJb '1r - ._u..._..._n..._"..". City of Dublin 2005-2006 YTD Revenues and Budget Comparison Total General Fund Revenues -1~:r the Period Endi)!g.J!!! ,,3J,2005,,,, '···--1 Property Taxes Sales Taxes Real Property Transfer Tax g~ Trauslent Occupancy Taxes g~ Franchise Taxes Licenses and Permits Interest and Reutals ! Intcrgovcrnmental from State Charges for Services Fines and Forfeitures Othcr Revenues 3% 2% 0% t% 0% 30% 60% I: :~~~~~;~~ 124% 90% 120% 150% -.-.....-.. 8% of Year Complete Property Taxes Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Fines and Forfeitures Other Revenues FY 2005/06 Budget Py 2005106 YTD Actual 15,716,461 14,984,884 745,600 680.500 1,626,300 2,380,013 1.898.725 498,650 5,256,561 132,200 1.591,243 o 746,500 o o o t60,452 97,521 618,465 215,117 4,484 3,449 1,845,988 Total General Fund Revenues 45,511,137 DaloPrlnlll':l: lIr.II2OO1:1~"~PM %of FY 2004/05 % of Total for Budget YTD Actual FY 2004/05 0% 0 0% 5% 923,400 7% 0% 0 0% 0% 0 0% 0% 62,986 4% 7% 590,802 17% 5% 2,743 0% 124% 180,150 32% 4% 199,747 4% 3% 3,296 2% 0% 3,775 1% 4% 1,966,899 5% "6- l/ø -0::;'"" "',2- ATTACHMENT 1 __._..___._n .~~~ City of Dublin 2005-2006 YTD Expenses and Budget Comparison For the Period Ending July 31, 2005 . . ...."......-.-.--.... Total General Fund 12% Expenses 2% General Government I!I! 8% 4% Pollee 0% 11% Fire 0% 0% Other pnbllc Safety 11% 1% Transportation 12% 2% Health and Welfare 0% 0% Cnlture & Community 14% Services 5% Community 13% Development 3% Capital Improv. i% Projeets 2% 0% 20% 40% . FY 2005106 . FY 2004105 --.-"... 60% 80% 100% t20% 8% or Year Complete 2005106 2005106 %of FY 2004105 % of Total for Budget YTD Açtual Budget YTD Actual FY 2004105 General Government 5,526,335 414,555 8% 206,648 4% Pollee 11,358.537 32.600 0% 74,459 t% Fire 8.890.188 8.614 0% 25.847 0% Other Public Safety 366.512 2,472 t% 3.830 1% Transportation 1.824.115 33,851 2% 40.411 2% Health and Welfare 15,000 0 0% 0 0% Culture snd Community Services 6,337,038 263.606 4% 267,008 5% Community Development 8.433,682 240.521 3% 237,830 3% Capital Improvement Projeçts 4,525.725 17.407 0% 75,564 2% Total General Fund Expenses 47.277.132 1,013,626 2% 931,597 2% General Fund Operating Expenses 42,751,407 996,219 2% 856.033 3% c..1I'rtn!tId:~4:'~~M ATTACHMENT 2 3\1~ CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JULY 2005 Prepared by The Finance Department August 3, 2005 ATTACHMENT 3 4~':; CITY OF DUBL! N BAI.ANCE SHEET FOR THE PERIOD ENDING 31Ju12DD5 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 (48.522.374) 5,237.751 623,836 34,817,378 196.689 (7.646.720) (26.706.774) CASH WITH FISCAL AGENT 175.049 175,049 172.779 AMOUNT HELD IN ESCROW INVESTMENTS AT COST 102.516.493 102.516.493 101. 946,341 RECE! VABLES, TAXES ACCOUNTS 127.76B 52.884 180.651 3.867.605 INTEREST (232,737) (232.737) 496.242 ASSESSMENTS DUE FROM OTHERS 1. 9B9. 267 1. 989.267 1. 989,267 INVENTORY AT COST PRE PAlO ITEMS 10.5BO 10,580 7,001 FIXED ASSETS 4.500,000 4.500.000 AMOUNT TO BE PROVIDED 1. 334.500 1. 334.500 1. 334,500 TOTAL ASSETS 56.888.997 5.290.635 623.836 39.317.37B 1. 706.238 102,827,083 83,106.961 LIABILITIES/FUND EQUITY OEPOSITS fOR PRIVATE DoVLL (970.255) (970.255) (705.064 ) OEPOSITS FOR ABI6DO FEES (213.799) (334.209) (548.008) (ll3, 621) DEPOSITS OTHERS (2.659.461) (2.659.461) (1.982.609) PAYABLES, ACCOUNTS (839,123) 004 .735) (40.814) (29.100) 0,013.772) 00,864.709) INTEREST PAYROLL (561.602) (561. 602) (594,923) OUE TO OTHERS (98.022) 060.054 ) 0.829.213) (2,087.289) (445.322) DEFERRED REVENUE (127.768) 027.768) (127.768) DEBT INSTRUMENTS PAYABLE 0,452.000) (1.452.000) 0.452.000) TOTAL LIA81LITIES (5,470.029) (264.789) (40,814) (2.192.522) 11.452.000) (9.420.153) 06.286.015) FUND BALANCES (50.418.968) (5.025.845) (583.022) (37.124.856) (254,238) (93.406,930) (66.820.946) TOTAL FUND E (50,418.968) (5,025,845) (5B3,022) (37.124.866) (254.238) (93.406.930) (66,820.946) TOTAL LIABILITIES/EQUITY (55.888.997) (5,290,635) (623,836) (39.317.378) (1.706.238)(102.827.083) (83.106.961) Ç-'bl~ CITY OF DUBLI N BALANCE SHEET FOR THE PERIOD ENDING 31Ju12005 INTERNAL ENTERPRISE F I X ED ASSETS GENERAL LONG TOT A L S SERVICE FUNO GROUP OF TERM DEBT ---MEHORANDUM--- FUNOS ACCOUNTS ACCOUNT GROUP CURRENT PRIDR ASSETS CASH 8.807.699 8,807,699 7,970,793 CASH WITH FISCAL AGENT AMOUNT HELD IN ESCROW INVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS 12.188 INTEREST ASSESSMENTS DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 46.511.915 39.208,244 85,720.159 85,720,159 AMOUNT TO BE PROVIDED 66.753.945 66,753.945 66.850.201 TOTAL ASSETS 55.319,614 39.208.244 66.753,945 161.281.802 160.553.341 LIABILITIES/FUND EOUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS 01.185) m.185) (35.556) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DE8T INSTRUMENTS PAYABLE (66,753,945) (66,753.945) (66,850,201) TOTAL LIABILITIES 01.185) (66,753.945) (66,765,130) (66,885.757) FUND BALANCES (55,308,429) (39.208.244) (94.516.673) (93.667.584) TOTAL FUND E (55.308.429) (39,208,244) (94,516,673) (93.667.584) TOTAL LIABILITIES/EQUITY (55.319.614) (39.208,244) (66,753.945) (161.281,802)(160.553.341) 6'tIQ ß THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 07/31/2005 G EN ERA L REV E N U E FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y. T.D VARIANCE *******REVENUES******* PROPERTY TAXES 16.716.46100 15,716.461. 00 13,647.977.32 13.647.977.32 SALES TAX 14.984.884.00 746,500.00 14,238.384.00 13.793.899.88 923,400.00 12,870,499.88 REAL PROPERTY TRANSFER TAX 745,600.00 746.600.00 831. 003.24 831. 003.24 HOTEL TRANSIENT OCCUPANCY TAX 680.60000 680,500.00 663.631.67 663.631. 67 FRANCHISE TAXES 1.626.300.00 1.626.300.00 1.669.900.22 62,986.00 1.496,914.22 LICENSES & PERMITS 2,380.013.00 160.462.03 2.219.660.97 3.516,090.84 590.801.62 2.926.289.22 FINES & FORFEITURES 132.200.00 4.483.62 127.716.38 142,091. 33 3.295.87 138.795.46 USE/MONEY & PROP-INTEREST 1. 757 .524 00 95,277.86 1.662.246.14 1.666.348.13 1. 556 ,348.13 USE/MONEY & PROP-RENTALS 141.201. 00 2.243.63 138.967.37 109.113.77 2.743.04 106.370.73 INTERGOVERNMENTAL 498.66000 618.464.85 (119.814.85) 568.598.34 180.150.37 388.447.97 CHARGES fOR SERVICES 5.266.561.00 215,116.78 5.041.444.22 5.557.301.48 199.746.75 5,357.554.73 OTHER SOURCES OF REVENUE 1. 591. 243.00 3.448.60 1. 587.794.50 639.822.66 3.774.84 636.047.82 TOTAL REVENUE 45.611.137.00 1. 845 . 987 . 27 43,665,149.73 42.585.778.88 1. 966.898.49 40,618,880.39 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES, CITY COUNC! L 280.704.00 19.826.73 260.878.27 229,930.71 7.506.30 222.425.41 CITY MANAGER 997.923.00 51.131. 60 946.791. 40 915.504.47 64.84447 850,660.00 CENTRAL SERVICES 538.556.00 16.732.46 621. 823.54 356.160.93 20.758.95 335.401. 98 CITY ATTORN EY 824.252.00 1. 433.40 822.818.60 743,616.65 2.06268 741.552.97 ADMIN SERVICES 1.642.603.00 93,067.98 1.549,535.02 1.432.162.79 99.137.74 1,333,025.05 BUIl.DING MANAGEMENT 734,657.00 1.226.99 733.431.01 632.266.26 12.339.16 619.927.10 INSURANCE COST CENTER 397.038.00 231.138 00 165,900.00 287.420.66 287.420.55 ELECTIONS COST CENTER 2,890.00 2.890.00 12.265.33 12.265.33 NON-DEPARTMENTAL 107.712.00 107,712.00 3.313.33 3.313.33 ACTIVITY TOTAL 5.626.335.00 414.555.16 5.111.779.84 4.612.640.02 206,648.30 4.405.991.72 PUBLI C SAFETY POLICE 11.358.637.00 32.60008 11.325,936.92 7.666.472.37 74.459.38 7,581,012.99 CROSSING GUARDS 72,283.00 72.283.00 71.407.04 71.407.04 ANIMAL CONTROL 208.898.00 208,898.00 163,639.91 163.639.91 TRAFFIC SIGNALS & STREET LIGHTIN 10.610.00 10,610.00 8.409.67 8,409.67 DISASTER PREPAREDNESS 74.721.00 2.472.37 72.248.63 58.023.15 3,830.33 54.192.82 FIRE SERVICES 8.890.188.00 8.61400 8.881.574.00 6.240.654.65 25.846.76 6.214.807.89 ACTIVITY TOTAL 20.615.237.00 43,686.45 20.571.550.65 14.197.606.79 104,136.47 14.093.47032 TRANSPORTATION PUBL! C WORKS 808.577.00 33.86052 774.726.48 716,434.56 40.410.62 676.023.94 STREET MAINTENANCE 30.314.00 30,314.00 14.397.66 14,397.56 STREET SWEEPING 150.670.00 150.670.00 140.783.85 140.78385 STREET TREE MAINTENANCE 99.430.00 99.430.00 99,195.45 99.195.45 STREET LANDSCAPING MAINTEN^N 735,124.00 735.124.00 662,617 .70 662.617 .70 ACTI V!TV TOTAL 1.824,115.00 33.86062 1.790.264.48 1.633,429.12 40.410.62 1.693.018.50 HEALTH & WELFARE WASTE MANAGEMENT 71.474.64 71.47464 CHILD CARE 15,000.00 15.000.00 15,000.00 15.00000 SOCIAL SERVICES HOUSING PROGRAMS 199.16 199.16 l11b ~ THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 07/31/2005 G ENE R A L REV E N U E FUN D CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ACTIYITY TOTAL 15.000.00 15.000.00 86.673.79 86.673 79 CULTURE & LEISURE SERVICES LIBRARY 5ERVICES 615.611.00 615.611.00 577,722.50 577 . 722 50 CULTURAL ACTIVITIES 204.701. 00 22.900.96 181. 800.04 11l, 978.73 6.909.85 105.068.88 HERITAGE CENTER 163.333.00 7.621.97 155,711.03 124.223.06 6.845.29 117.377.77 DUBLIN CEMETERY 49.958.00 49.958.00 40.518.28 40,51B.2B PARK MAINTENANCE 1.692.165.00 1.692.165.00 1.413,288.17 1.413.288.17 COMMUNITY TV 66.407.00 58.032.00 8,375.00 61. 809.00 54.649.00 7.160.00 RECREATION ADMIN 704,134.00 37.411.77 666.722.23 590.939.28 46.723.24 544.216.04 PLAYGROUNDS 275,357.00 18.493.25 256.863.75 246,009.35 23,630.64 222.378.71 SHANNON CENTER 342.706.00 16.319.75 326,386.25 350.110.47 18.862.79 331. 247 . 68 PRESCHOOL 105,458.00 3.931.05 101.526.95 81.122.44 4,513.06 76.609.38 TEENS PROGRAM 159.835.00 6.690.98 153,144.02 86.350.46 3.810.56 82.539.90 ADULT SPORTS 109.230.00 3,096.09 106.133.91 88.946.63 4.476.81 84,469.82 YOUTH SPORTS 153,617.00 5.000.62 148.616.38 118.368.22 3.861.68 114.506.54 COMMUNITY GYM 43.459.00 331.72 43,127.28 42.11l.63 1.417.60 40.694.03 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 364.601. 00 15.408.93 349.192.07 343,594.62 14.113.19 329 . 481. 43 SENIOR CENTER 365.728.00 11.052.79 354,675.21 248.617.13 12.431.45 236,185.68 RECREATION INSTRUCTION 183,023.00 5.071.53 177 .951.47 175.147.95 5,842.22 169.305.73 AOUATICS 429.22100 37.103.00 392,118.00 391. 621. 67 42.104.05 349.517.62 PARKS/FACILITIES MANAGEMENT 308,494.00 15.139.50 293.354.50 259.915.97 16,816.81 243.099.16 ACTIVITY TOTAL 6.337.038.00 263.605.91 6.073.432.09 5,352,395.56 267.008.24 5.085.387.32 COMMUNITY DEVELOPMENT PLANNING 2,685,164.00 72.983.08 2.612.180.92 2.410.787.49 94,761.17 2.316.026.32 BUILDING SAFETY 3.213.88500 40.652.80 3.173.232.20 2,337.580.32 45.009.62 2.292.570.70 ENGINEERING 2.194,005.00 82.742.99 2.11l.262.01 2.325.195.93 81. 228 . 39 2.243.967.54 ECONOMIC DEVELOPMENT 340.62800 44.141.79 296.486.21 271.728.77 16.830.43 254.898.34 ACTIVITY TOTAL 8.433.682 00 240.520.66 8,193,161.34 7.345.292.51 237.829.61 7.107,462.90 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1.319.55800 1.319,558.00 629.388.22 65.227.80 564.160.42 COMMUNITY IMPROVEMENTS 522,329.00 5,390.18 516.938.82 180.435.34 2.811.98 177.623.36 PARKS 1.498.597.00 11.278.66 1.487.318.34 2,576,829.99 61942 2.576.210.57 STREET CONSTRC/IMPROVEMENTS 1.185.24100 738'.63 1.184.502.37 989.245.41 6.90480 982.340.61 ACTIVITY TOTAL 4.525.72500 17 .407 .47 4,508,317.53 4.375.898.96 75.564.00 4,300.334.96 TOTAL EXPENDITURES 47,277,132.00 I. 013.626.17 46.263.505.83 37.603.936.75 931. 597 . 24 36.672.339.51 EXCESS REVENUE (EXPENOITURES) (1.765.99500) 832.361.10 (2.598.356.10) 4.981.842.13 1.035.30125 3.946.540.88 TRANSFERS IN FROM OTHER FUNDS 6.600.00 6.600.00 TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES (1.765.995.00) 832.361.10 (2.598.356.10) 4,988,442.13 1. 035.30125 3.953.140.88 '8ttb 13 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07101/2005 THROUGH 0'1/31/2005 S P E C I A L REV E N U E FUN D S CURRENT CURRENT PRIOR PRIOR BUrx;ET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE ********REVENUES******** PROPERTY TAXES II7.680.00 II7,680.00 1Il.532.51 II1.532.5I SALES TAX/OTHER TAXES 360.500.00 360.500.00 331. 217 . 92 331. 217 . 92 FINES & FORFEITURES 156.000.00 156,000.00 149.341.93 149.341.93 USES/MONEY & PROPERTY 99,757.00 99.757.00 49.303.08 49,303.08 INTERGOVERNMENTAL FROM STATE 1.014.231.00 1.014.231.00 2.037.231. 75 9,864.00 2,027,367.75 INTERGOVERNMENTAL FROM COUNTY 340.440.00 340.440.00 256.309.00 256,309.00 INTERGOVERNMENTAL FROM FEDERAL 76.792.00 76,792.00 43.231.25 43.231.25 CHARGES FOR SERVICES 1. 350 ,461. 00 t.350. 461. 00 1.064.250.12 1. 064.250 .12 OTHER SOURCES OF REVENUE 409.500.00 409.500.00 17.074.39 17.074.39 TOTAL REVENUE 3.925.361.00 3.925.361.00 4.059,491. 95 9.864.00 4.049.627.95 *******EXPENoITURES******* PU8LIC SAFETY: POLICE 120.255.00 120,255.00 105,952,40 105.95240 TRAFFIC SIGNALS & STREET LTG 234.700.00 234.700.00 169.744.34 2.083.33 167.661. 01 DISASTER PREPAREDNESS FIRE SERVICES 270.120.00 270.120.00 207.590.51 207.590.51 ACTIVITY TOTAL 625.075.00 625.075.00 483.287.25 2.083.33 481. 203.92 TRANSPORTATION: STREET MAINTENANCE 330,47400 330,474.00 272,390.25 272.390.25 STREET SWEEPING ACTIVITY TOTAL 330,474.00 330.474.00 272.390.25 272.390.25 HEALTH & WELFARE: WASTE MANAGEMENT 1.874.90600 4.332.35 1.870.573.65 753,072.56 505.55 752.567.01 SOCIAL SERVICES 60 ,427 00 60.427.00 40.332.98 40.332.98 HOUS I NG PROGRAMS ACTIVITY TOTAL 1. 935.333 00 4.332.35 1.931.000.65 793,405.54 505.55 792.899.99 COMMUNITY OEVELOPMENT, ENGINEERING 6.00000 6.000.00 6.000.00 6.000.00 ACTIVITY TOTAL 6.00000 6,000.00 6.000.00 6.000.00 CAP1TAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS COMMUNITY PROJECTS 9,765.00 9,765 00 14.850.00 14,850.00 PARKS 3t.310.00 3t.31000 321. 717.00 321.717.00 STREET CONSTRUCTION/IMPROVEMENT 1.654.170.00 4.306.23 1.649.86377 83.530.90 6,994.19 76.536.71 ACTlVlTY TOTAL 1. 695.245 00 4.306.23 1. 690.938.77 420.097.90 6.994.19 413.103.71 TOT ^ L EXPENOITURES 4,597,691.00 8.638.58 4.589.052.42 1.975.180.94 9,583.07 1.965,597.87 EXCESS REVENUE (EXPENDITURES) (672.33000) (8.638.58) (663.691.42) 2,084.311.01 280.93 2.084.030.08 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 6.600.00 6,600.00 REVENUES OVER (UNDER) EXPENOITURES (672.330.00) (8.638.58) (663.691.42) 2.077.711.01 280.93 2.077.430.08 '1JbI3 TilE CITY OF DUBLIN STATEMENT SHDWING REVENUES VERSUS EXPENDITURES FDR THE PERIOD 07/D1/2005 THRDUGH 07/31/2005 S P E C I A L ASS E SSM E N T FUN D S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL BENEFITS ASSESSMENTS 664.610.00 664.610.DD 741,372.52 741,372.52 USES/MDNEY & PROP-INTEREST 15.478 DD 15.478.00 7.19083 7,190.83 DTHER SOURCES OF REVENUE 5.00D.DD 5.000.0D TDTAL REVENUE 685.088.00 6B5.0BB.DD 748,563.35 74B,563.35 *******EXPENDITURES·**···· PUBLIC SAFETY; TRAFFIC SIGNALS & STREET LIG 278,600.00 278.600.DD 231, 711. 82 231. 711,82 ACTIVITY TOTAL 278.600.00 278,600.00 231.711.82 231, 711. 82 TRANSPORTATION PUBLIC WORKS 2.415.00 229.23 2,185.77 1.591.29 123.81 1,467.48 STREET TREE MAINTENANCE 34,231,00 34.231.00 18,466.76 18.466.76 STREET LANDSCAPE MAINTENANCE 356.039.00 356.039.00 312,141.30 312,141, 30 ACTIVITY TDTAL 392.685.00 229.23 392,455.77 332.199.35 123.81 332,075.54 COMMUNITY DEVELOPMENT ENGINEERING 13.100.00 13.100.00 7.139.94 7.139.94 ACTIVITY TOTAL 13.100.00 13.100.00 7.139.94 7,139.94 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 32.920.00 32.920.00 STREET CONSTRUCTIONIIMPRVMNT 75.000.00 75.000.00 ACTIVITY TOTAL 107.920.00 107,920.00 TOT A L EXPENDITURES 792,305.0D 229.23 792.075.77 571 ,051, 11 123.81 570.927.30 EXCESS REVENUE (EXPENDITURES) (107.217.0D) (229.23) (106,987.77) 177.512.24 (123.81) 177 ,636.05 REVENUES OVER (UNDER) EXPENDITURES (107.217.00) (229.23) (106.987.77) 177.512.24 (123.81 ) 177.636.05 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 07/31/2005 10 11b'3 CAP I TAL IMP R 0 V E MEN T FUN 0 S CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.O. VARIANCE ********REVENUE******** USES/MONEV & PROP-INTEREST 865.623.00 865.623.00 545.314.12 545.314.12 OTHER SOURCES OF REVENUE 19.267.62600 788.257.80 18.479,367.20 14.622.460.23 3.303.266.65 1l.319.193.58 TOTAL REVENUE: 20.133.248.00 788,257.BO 19.344.990.20 15.167.77435 3,303,266.65 1l,864,507.70 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 38.950.00 38,950.00 33,893.39 33.893.39 ACTIVITY TOTAL 38.950.00 38,950.00 33.89339 33,893.39 PUBLI C SAFETY: TRANSPDRTATION; HEALTH & WELFARE: HOUSING PROGRAMS 899.170.00 12.762.47 886,407.53 203.088.79 9.977.07 193, Ill. 72 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTIVITY TOTAL CAPITAl. IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 67.700.00 67.700.00 623.943.39 623,943.39 COMMUNI TV IMPROVEMENTS 251.251.50 251.251.50 PARKS 9,165.802.00 993.75 9.164.808.25 6.177,466.07 411. 07 6.177.05500 STREET CONSTRUCTION/IMPROVEMENT 36.028.246.00 7.802.16 36,020,443.84 3.741.604.68 12,533.04 3.729,071.64 ACTIVITY TOTAL 45,261.748.00 8.795.91 45.252.952.09 10.794,265.64 12.944.Il 10.781.321.53 TOT A L EXPENDITURES 46.199.B6B.OD 21.55B.38 46,178.309.62 1l.031.247.B2 22.921.18 11. 008.326.64 EXCESS REVENUE (EXPENDITURES) (26.066,620.00) 766.699.42 (26.833.319.42) 4.136.526.53 3.280.345.47 856. 181. 06 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES(26.066.520.0D) 766.699.42 (26,B33.319.42) 4.136.526.53 3,280,345.47 856 , 181. 06 /'l t1b 13 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/Z005 THROUGH 07/31/2005 T R U S T 1 AGE N C Y FUN D CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIDR Y.TD. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 228. 280 .46 ZZ8,Z80.46 USESIMONEY & PROP-INTEREST 3.49Z.75 3.492.75 TOTAL REVENUE Z31. 773.21 231.773Z1 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES; NON-DEPARTMENTAL 231. 038 00 231. 038.00 231. 421.18 176.590.25 54.830.93 ACT! V!TV TOTAL 231,038.00 231. 038 00 231. 421. 18 176.590.Z5 54.830.93 PUBLI C SAFETY; TRANSPORTATION: HEALTH & WELFARE; CULTURE & LEISURE SERVICES; COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 231,038.00 231. 038.00 231. 4Z1. IB 176,590.25 54.830.93 EXCESS REVENUE (EXPENDITURES) (231.03800) (231.03800) 352.03 (176.590.25) 176.942.28 REVENUES DVER (UNDER) EXPENDITURES (231. 038 00) (Z31.038.00) 35Z.03 (176.590.25) 176.94Z.Z8 l2eþl?i THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2005 THROUGH 07/31/2005 I N T ERN A L S E R V ICE FUN 0 S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP· INTEREST 297.0B9.00 297.089.00 115,973.87 115.973.87 CHARGES FOR SERVICES 1,796,096.00 1.796,096.00 1.624.22041 140.777 .51 1. 4B3 .442 . 90 OTHER SOURCE5 OF REVENUE 23.400.00 14.116.75 9.283.25 14.606.96 14.606.96 TOTAL REVENUE 2,116,585.00 14.11675 2.102.468.25 1,754.801.24 140.777 .51 1.614,023.73 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2.074,072.00 19.443.15 2.054.628.85 1.125,430.39 410.474.57 714.955.82 ACTI V ITY TOTAL 2.074.072.00 19.443.15 2,054,62B.85 1.125.430.39 410.474.57 714.955.82 PUBLI C SAFETY; fIRE 65.561. 00 65.561. 00 44,652.77 44,652.77 ACTIVITY TOTAL 65.561.00 65,561. 00 44.652.77 44.652.77 TRANSPORT A TI ON : HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS; TOT A L EXPENDITURES 2.139,633.00 19.443.15 2,120,189.85 1.170.083.16 410,474.57 759.608.59 EXCESS REVENUE (EXPENDITURES) (23.04BOO) (5,326.40) Cl7 . 721. 60) 584,71B.08 (269.697.06) 854.415.14 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES (23,048.00) (5.326.40) Cl7 . 721. 60) 584.718.08 (269.697.06) 854.415.14 ********REVENUES******** USESIMONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FINANCE ACTIVITY TOTAL PUBLI 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 BUDGET THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 0710112005 THROUGH 0713112005 E N T E R P R I S E FUN 0 CURRENT ACTUAL PRIOR FISCAL YEAR VARIANCE PRIOR Y.T.D. Iß 1'? VARIANCE