Loading...
HomeMy WebLinkAboutItem 4.07 Financial Reports July & Aug CITY CLERK File # D~[3][2]-[5J[U] AGENDA STATEMENT CITY COUNCIL MEETING DATE: October 3,2006 SUBJECT: Financial Reports for the Months of July and August 2006 Report Prepared by: Paul S. Rankin, Administrative Services Director and Fred Marsh, Finance Manager ATTACHMENTS: 1. YTD Revenues and Budget Comparison 2. YTD Expenses and Budget Comparison 3. Financial Statements for July and August 2006 RECOMMENDA nON: 4Jf 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 July and August 2006. 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. Analysis of AU2ust 2006 Revenue and Expenditure Reports The August reports represent the reporting of revenues and expenditures for the first two months of the Fiscal Year, through August 31, 2006. 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. Given August is only the second month of the Fiscal Year, there is extremely limited data on which to base any major projections or identify significant trends. The Fund Balance adjustments as a result of transactions in the prior fiscal year have not been entered. The auditors have started the final phase of the fieldwork and any adjustments to Fund Balance will be incorporated in a future report after the audit is complete. Impact to City of Passa2e of State Bud2et for Fiscal Year 2006-2007 The State Budget passed in for Fiscal Year 2006-2007 has provisions which may have positive impacts on local government finances, that were not taken into consideration when the City 2006/07 Budget was prepared. · The State Budget provided funding to cities of Proposition 42 Transportation funds for Fiscal Year 2006-2007. The City has already received its allocation for the year totaling $264,310. The amount budgeted was $172,000. The State as part of their Budget remitted amounts owed for Fiscal Years 2003-2004 and 2004-2005. ------------------------------------------------------------------------------------------------------------- COPIES TO: Page 10f2 Document in FSCOLOR 08-2006 ITEM NO. if. 7 C/ . The State Budget included funds for the reimbursement to cities of amounts paid for jail booking fees. It is unknown at this time what amount, if any, will be received by the City for Fiscal Year 2006-2007. The State Controllers Office is reviewing the eligibility for all agencies which contract for Police Services. . Potential reimbursement to cities of amounts submitted for reimbursement for prior years for State Mandated costs. It is unknown at this time what amount, if any, will be received by the City for Fiscal Year 2006-2007. However, the fact that some funding was made available was an improvement over prior years. General Fund Revenues Total General Fund Revenues collected through August are similar, based upon the percentage collected, to what occurred in the second month of the previous Fiscal Year. Through August 2006, the City had collected approximately 8% of the total budgeted General Fund Revenues, similar to what was collected in the same period of the prior Fiscal Year. A brief description is provided below to explain any material revenue variations. Real Property Transfer Taxes are lower due to timing differences in the receipt of these revenues. The first payment was received in September and if it had been included would have resulted in a positive variance. Licenses and Permits are higher than in the prior year due to additional permits pulled for new residential projects. Intergovernmental revenue is lower than in the prior year, due to a one-time repayment by the State of the Vehicle License Fee (VLF) Loan from Fiscal Year 2003-2004 that occurred in the first two months of the previous year. General Fund Expenditures Overall, through the month of August, expenditures in the General Fund totaled approximately $2.6 million and represented approximately 5% ofthe total budgeted expenditures in the General Fund. Ofthis amount, a total of approximately $103,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 August 2006 was similar to the amounts expended for the same period in the prior Fiscal Year. Through the end of August 2006, the City had expended 6% of the General Fund Operating Budget, which was a similar percentage to the amount expended in the prior Fiscal Year. Capital Improvement Projects are lower than in the same period of the prior year due to amounts paid in the prior year for the Downtown Improvement Implementation and Senior Center projects. 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 2 of2 City of Dublin 2006-2007 YTD Revenues and Budget Comparison j.......... F........or..the..periOdEn.dingAUg~.......st31,2QO,6H , I ! I 8% i I i Total General Fund Revenues 'IWJl8% I I I /0 I cZLf I I I Property Taxes 0% 0% Sales Taxes Real Property Transfer Tax Transient Occupancy Taxes Franchise Taxes Licenses and Permits 37% Interest and Rentals Intergovernmental from State Charges for Services Fines and Forfeitures Other Revenues 0% 30% I_ FY... 2.00.6/071 FY 2005/06 ' 62% 60% 90% 150% 120% 17% of Year Complete FY 2006/07 FY 2006/07 %of FY 2005/06 % of Total for Budget YTD Actual Budget YTD Actual FY 2005/06 Property Taxes 17,470,288 0 0% 0 0% Sales Taxes 15,283,000 1,889,100 12% 1,741,900 12% Real Property Transfer Tax 712,000 0 0% 76,264 11% Transient Occupancy Taxes 685,000 72,093 11% 63,253 9% Franchise Taxes 1,921,000 66,773 3% 4,387 0% Licenses and Permits 2,901,819 1,059,465 37% 567,879 18% Interest and Rentals 2,037,738 196,348 10% 115,170 7% Intergovernmental 1,083,021 52,262 5% 628,012 62% Charges for Services 6,740,407 662,532 10% 606,979 11% Fines and Forfeitures 143,560 16,621 12% 15,862 11% Other Revenues 1,946,995 45,445 2% 4,914 2% Total General Fund Revenues 50,924,828 4,060,639 8% 3,824,620 8% ~,7 l OJ ~. ! Dale Printed' 9/15/2006 1233 PM ATTACHMENT 1 1--------------- Jo!}i City of Dublin 2006-2007 YTD Expenses and Budget Comparison For the Period Ending August 31,2006 Total General Fund ~5% Expenses f 7% General Government Police Fire 11% f1% Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects 0% 20% . FY 2006/07 FY 2005/06 63% I I i I I I -.. - --r--~----"----- m f. 40% 60% 80% 100% 120% 17% of Year Complete 2006/07 2006/07 %of FY 2005/06 % of Total for Budget YTD Actual Budget YTD Actual FY 2005/06 General Government 5,623,678 733,961 13% 694,962 14% Police 12,171,938 164,146 1% 154,446 1% Fire 9,253,613 60,870 1% 64,750 1% Other Public Safety 463,056 6,761 1% 7,409 2% Transportation 2,057,857 98,687 5% 87,877 5% Health and Welfare 46,500 18,500 40% 15,000 63% Culture and Community Services 6,969,511 647,169 9% 645,331 11% Community Development 8,604,270 805,744 9% 748,724 10% Capital Improvement Projects 5,380,062 102,519 2% 539,968 17% Total General Fund Expenses 50,570,485 2,638,357 5% 2,958,467 7% General Fund Operating Expenses 45,190,423 2,535,838 6% 2,418,499 6% Date Printed: 9/1512006 12:35 PM ATTACHMENT 2 l)t-f CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF AUGUST 2006 Prepared by The Finance Department September 15,2006 ATTACHMENT 3 Lf r ^,,' (}f ;f CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Aug2006 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 (51.619,677) 3,828.920 525.767 40.876.606 42.752 (6.345.632) (8.197,061) CASH WITH FISCAL AGENT 164.500 164.500 175.727 AMOUNT HELD IN ESCROW 1. 762 . 000 1. 762.000 661.000 INVESTMENTS AT COST 108.898.623 108.898,623 103.514.812 RECEIVABLES: TAXES ACCOUNTS 432.464 142.442 3,415 315,780 894,100 1. 608 , 520 INTEREST 671.287 671 ,287 500,222 ASSESSMENTS DUE FROM OTHERS 1. 886 , 536 1. 886 . 536 2.206.558 INVENTORY AT COST PREPAID ITEMS 2,802 2.802 3.085 FIXED ASSETS LOANS RECEIVABLE 4,731. 534 4,731. 534 4.596.534 AMOUNT TO BE PROVIDED 1. 083.500 1. 083.500 1. 213.500 TOTAL ASSETS 60.272,034 3.971.362 529,182 47.685,920 1. 290.752 113,749,250 106.282.899 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (780.374) (780.374) (1. 019.781) DEPOSITS FOR AB1600 FEES (887,998) (887.998) (502,117) DEPOSITS OTHERS (2.304,089) (2.304.089) (2.640.026) PAYABLES: ACCOUNTS (4.977.281) (85.997) (8.426) (86.767) (5.158.470) (4,639,260) INTEREST PAYROLL (62&,833) (626.833) (618.799) DUE TO OTHERS (570,156) 7.062 (1. 893.598) (2.456,692) (2.469.525) DEFERRED REVENUE (139,936 ) (139,936) (127,768) DEBT INSTRUMENTS PAYABLE (1,201. 000) (1. 201. 000) (1.331. 000) TOTAL LIABILITIES (10.286,666) (78.935) (8.426) (1.980,364) (1,201.000) (13,555.391) (13,348.277 ) FUND BALANCES (49.985,369) (3,892.427) (520.756) (45.705,555) (89,752)(100,193,859) (92.934.622) TOTAL FUND E (49.985,369) (3,892.427) (520.756) (45.705,555) (89,752)(100,193.859) (92.934.622) TOTAL LIABILITIES/EQUITY (60.272,034) (3.971.362) (529.182) (47.685,920) (1,290.752)(113,749.250)(106.282.899) /-:-. f i _' () f v,,. CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Aug2006 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 10,416,022 10,416.022 9,222.321 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 50,002.851 333.664.335 383.667,186 383.667.186 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 63.454.426 63.454.426 63.728.304 TOTAL ASSETS 60.418.873 333.664.335 63.454.426 457.537.633 456,617.811 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES: ACCOUNTS (43,613) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (63,454.426) (63.454,426) (63,728.304) TOTAL LIABILITIES (63.454.426) (63.454,426) (63,771.917) FUND BALANCES (60,418.873) (333,664.335) (394,083,207)(392,845.894) TOTAL FUND E (60.418.873) (333.664.335) (394,083,207)(392,845.894) TOTAL LIABILITIES/EQUITY (60,418,873) (333.664,335) (63,454,426) (457,537,633)(456,617.811) 00+ 1'1 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 08/31/2006 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 *******REVENUES******* PROPERTY TAXES 17.470.288.00 17.470,288.00 16.775,905.94 16,775.905,94 SALES TAX 15.283.000,00 1.889,100.00 13.393.900.00 14.122.360.86 1. 741. 900,00 12.380,460.86 REAL PROPERTY TRANSFER TAX 712.000.00 712.000.00 690,404.35 76.263,85 614.140,50 HOTEL TRANSIENT OCCUPANCY TAX 685.000.00 72.092.83 612.907.17 727,611.60 63,252.69 664,358.91 FRANCHISE TAXES 1.921.000.00 66.772.64 1.854,227.36 1.789.355.75 4,386.73 1. 784.969.02 LICENSES & PERMITS 2.901. 819.00 1. 059 ,464.81 1.842.354.19 3.142,223.22 567,878.70 2,574.344.52 FINES & FORFEITURES 143.560.00 16,621.17 126,938.83 149,467.45 15.862.44 133,605.01 USE/MONEY & PROP-INTEREST 1.864.164.00 187,108.24 1.677 .055. 76 1.447,812.35 106,170.38 1. 341. 641. 97 USE/MONEY & PROP-RENTALS 173.574.00 9,239.43 164,334.57 123,016.09 8,999.96 114.016.13 INTERGOVERNMENTAL 1. 083.021. 00 52,262.34 1. 030 . 758.66 1.020.574.22 628,011.54 392.562.68 CHARGES FOR SERVICES 6.740.407.00 662,531. 70 6.077,875.30 5.774.668.80 606,979.43 5.167.689.37 OTHER SOURCES OF REVENUE 1. 946.995.00 45.445.40 1. 901. 549.60 275,245.24 4.913.52 270.331. 72 TOTAL REVENUE 50,924.828.00 4,060,638.56 46,864.189.44 46,038.645.87 3,824,619.24 42.214,026.63 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 358,156.00 27.890.59 330.265,41 246,713.83 36,690.88 210,022.95 CITY MANAGER 1. 045 , 943 , 00 146.848.48 899.094.52 960.947.89 127,236.37 833,711. 52 CENTRAL SERVICES 453,571.00 50.062.93 403,508.07 429.556.52 49.965.73 379,590.79 CITY ATTORNEY 750,395.00 5.745.12 744.649.88 623.049.58 4,426.02 618,623.56 ADMIN SERVICES 1. 708,961. 00 226.862.21 1. 482 . 098 . 79 1. 544.209.40 214.771.97 1,329,437.43 BUILDING MANAGEMENT 762,909.00 31. 713.43 731.195,57 709.411.15 29.880.56 679,530.59 INSURANCE COST CENTER 443,659.00 244.161.00 199.498.00 349.473.23 231.138.00 118,335.23 ELECTIONS COST CENTER 21. 815.00 195.39 21. 619.61 2.244.10 2,244.10 NON-DEPARTMENTAL 78,269.00 481.49 77 ,787.51 10.230.71 852.62 9,378.09 ACTI V ITY TOTAL 5.623,678.00 733.960.64 4.889 , 717 . 36 4,875.836.41 694.962.15 4,180,874,26 PUBLIC SAFETY POLICE 12.171,938.00 164.145.53 12.007,792.47 10.519.026.18 154,446.30 10,364.579.88 CROSSING GUARDS 88,511.00 435.30 88.075.70 79.558.58 821.40 78.737.18 ANIMAL CONTROL 255, 100 . 00 255.100.00 225.853.07 225,853.07 TRAFFIC SIGNALS & STREET LIGHTIN 16,315.00 16,315.00 12.608.33 12,608.33 DISASTER PREPAREDNESS 103,130.00 6.325.24 96,804.76 59.513.44 6,587.34 52,926.10 FIRE SERVICES 9,253,613.00 60.870.38 9,192,742.62 8.850.271.63 64,750.19 8,785,521.44 ACTI V ITY TOTAL 21. 888.607.00 231.776.45 21,656,830.55 19,746,831. 23 226,605.23 19,520.226.00 TRANSPORTATION PUBLIC WORKS 975,320.00 97,818.97 877,501. 03 783,622.13 87,811.34 695,810.79 STREET MAINTENANCE 33.440.00 33.440.00 30,314.00 30.314.00 STREET SWEEPING 145,400.00 145,400.00 135,923.35 135.923.35 STREET TREE MAINTENANCE 103.529.00 103.529.00 119,576.15 119.576.15 STREET LANDSCAPING MAINTENAN 800,168.00 868.40 799.299.60 709,557.73 65.57 709.492.16 ACTI V ITY TOTAL 2.057,857.00 98,687.37 1. 959 .169.63 1,778,993.36 87.876.91 1. 691.116.45 HEALTH & WELFARE WASTE MANAGEMENT 18.000,00 18.000.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 ,I () . }vf THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 08/31/2006 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 ACTI V ITY TOTAL 46.500.00 18.500.00 28,000.00 23.829,31 15.000.00 8.829.31 CULTURE & LEISURE SERVICES LIBRARY SERVICES 830.642.00 4.176.24 826.465.76 618.993,45 5.475.66 613.517.79 CULTURAL ACTIVITIES 265.457.00 66.575.20 198.881.80 233.514,19 69.806.03 163.708.16 HERITAGE CENTER 180.402.00 21. 883.64 158.518.36 158.806.33 18.183.29 140.623.04 DUBLI N CEMETERY 49.060.00 49,060,00 36.321. 70 1. 000.00 35.321. 70 PARK MAINTENANCE 1.811.174.00 4.823.07 1.806.350.93 1. 390 .353.67 706.12 1.389.647.55 COMMUNITY TV 67.591. 00 59.681. 00 7.910.00 63.060.91 58.160.58 4.900.33 RECREATION ADMIN 740.553.00 104.308.79 636.244.21 686.487.52 102.294.70 584.192.82 PLAYGROUNDS 280.051.00 46.720.74 233.330.26 243.464.19 44.000.27 199.463.92 SHANNON CENTER 303.829.00 46.144.24 257.684.76 328.750.40 46.244.56 282.505.84 PRESCHOOL 121. 504.00 ll. 002.25 1l0. 501. 75 108.039.36 9,604.25 98.435.11 TEENS PROGRAM 150.581.00 18.642.57 131.938,43 143.225.92 15.718.49 127.507.43 ADULT SPORTS 136.873.00 12.126.17 124.746.83 83.918.06 14.560.45 69.357.61 YOUTH SPORTS 170.700.00 22.685.53 148.014.47 142.237.92 22.272.83 119. 965.09 COMMUNITY GYM 43.969.00 1. 321. 79 42.647.21 40.429.40 2.249.13 38.180.27 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 369,636.00 31. 310.57 338.325.43 377.607.25 44.576.54 333.030.71 SENIOR CENTER 485.216.00 51. 507.74 433.708.26 421. 034.20 34.522.31 386. 511. 89 RECREATION INSTRUCTION 189.417.00 22.707.66 166.709.34 166.976,26 27.383.56 139.592.70 AQUATICS 446.642.00 73,714.26 372,927.74 411. 688,61 84.061. 21 327.627.40 PARKS/FACILITIES MANAGEMENT 326,214.00 47.837,56 278,376.44 293.640.02 44,510.58 249,129.44 ACTI V ITY TOTAL 6.969. 511. 00 647.169.02 6.322,341. 98 5.948.549.36 645,330.56 5,303.218.80 COMMUNITY DEVELOPMENT PLANNING 2.920.013.00 233.948.49 2.686.064.51 2.220.229,85 258.407.23 1. 961. 822.62 BUILDING SAFETY 3.205.667.00 273.768.59 2.931. 898.41 2.908.292.43 210,943.47 2.697.348.96 ENGINEERING 2.215.848.00 217.940.47 1. 997 ,907.53 2.380.351.96 211.865.35 2,168.486.61 ECONOMIC DEVELOPMENT 262.742.00 80,086,45 182,655.55 291.108.79 67.508.27 223.600.52 ACTI V ITY TOTAL 8.604,270.00 805,744.00 7.798,526.00 7.799.983.03 748.724.32 7.051. 258.71 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1.181. 320.00 140,00 1.181,180.00 612.958.83 1.454.53 611. 504.30 COMMUNITY IMPROVEMENTS 261. 044.00 1. 244,67 259,799.33 780.954.81 279.568.34 501.386.47 PARKS 3.240.463.00 100.887.34 3.139.575.66 1. 037 . 007 .51 180.975.46 856.032.05 STREET CONSTRC/IMPROVEMENTS 697.235.00 247.04 696.987.96 660.581.62 77.970.00 582.611.62 ACTI V ITY TOTAL 5.380.062.00 102.519.05 5.277.542.95 3.091. 502.77 539.968.33 2.551.534.44 TOTAL EXPENDITURES 50,570.485.00 2.638.356.53 47,932.128.47 43.265.525.47 2.958.467.50 40.307.057.97 EXCESS REVENUE (EXPENDITURES) 354.343.00 1. 422 . 282 . 03 0.067.939.03 ) 2.773.120.40 866.151.74 1.906.968.66 TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES 354.343.00 1. 422 . 282 . 03 0.067,939.03) 2.773.120.40 866.151.74 1. 906.968.66 q c.{ 14 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 08/31/2006 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 119,960.00 119.960,00 115,763.98 115,763.98 SALES TAX/OTHER TAXES 426,421. 00 426,421. 00 443,195.51 443,195.51 FINES & FORFEITURES 177,000.00 18,295.13 158,704.87 190,869.24 11,525.30 179,343.94 USES/MONEY & PROPERTY 120,002.00 22,532,64 97.469.36 108,314.70 108,314.70 INTERGOVERNMENTAL FROM STATE 1.084,313.00 348,021. 03 736,291.97 1. 094,513.46 141. 841. 49 952,671.97 INTERGOVERNMENTAL FROM COUNTY 370,913,00 370,913.00 308,928.00 308,928.00 INTERGOVERNMENTAL FROM FEDERAL 482,198.00 482, 198.00 106,583.00 106,583.00 CHARGES FOR SERVICES 1. 462 , 058,00 1. 462 , 058 . 00 1.315,435.57 1,315,435.57 OTHER SOURCES OF REVENUE 29,000,00 29,000.00 420,867,00 420,867.00 TOTAL REVENUE 4,271,865.00 388,848.80 3,883,016.20 4,104,470.46 153,366.79 3,951.103.67 *******EXPENDITURES******* PUBLI C SAFETY: POLI CE 103,710.00 103,710.00 105,670.43 105,670.43 TRAFFIC SIGNALS & STREET LTG 265,922.00 11,559.58 254,362.42 225,650.30 46,904.33 178,745.97 DISASTER PREPAREDNESS FIRE SERVICES 276,973.00 276,973.00 267,350.23 267,350.23 ACTI V ITY TOTAL 646,605.00 11,559.58 635,045.42 598,670.96 46,904.33 551,766.63 TRANSPORTATION: STREET MAINTENANCE 379,294.00 10,020.90 369,273.10 335,939.86 335,939.86 STREET LANDSCAPE MAINTENANCE 5,822,00 5,822.00 4,823,96 4,823.96 ACTI V ITY TOTAL 385,116.00 10,020.90 375,095,10 340,763.82 340,763.82 HEALTH & WELFARE: WASTE MANAGEMENT 1. 570 , 978.00 4,952.54 1. 566 , 025 . 46 1. 822 , 693 . 60 12,787.92 1. 809 , 905 . 68 SOCIAL SERVICES 61. 804,00 61. 804.00 60,427.00 60,427.00 HOUSING PROGRAMS ACTI V ITY TOTAL 1. 632 , 782 . 00 4,952.54 1.627,829.46 1,883,120.60 12,787.92 1.870,332.68 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 17,581.00 17,581.00 39,556.00 39,556.00 PARKS 136,587.00 136,587.00 50,349,43 50,349.43 STREET CONSTRUCTION/IMPROVEMENT 1.149,439.00 6,983.33 1.142,455.67 1.257,617.38 7,376.89 1.250,240.49 ACTI V ITY TOTAL 1. 303,607,00 6,983.33 1.296,623.67 1.347,522.81 7,376.89 1.340,145,92 TOT A L EXPENDITURES 3,974,110.00 33,516.35 3,940,593.65 4,176,078.19 67,069.14 4,109,009.05 EXCESS REVENUE (EXPENDITURES) 297,755.00 355,332.45 (57,577 .45) (71,607.73) 86,297.65 057,905.38) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 6,600.00 6,600.00 REVENUES OVER (UNDER) EXPENDITURES 297,755.00 355,332.45 (57,577 .45) (78,207.73) 86,297.65 064,505.38) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 08/31/2006 lolJtf 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 737.494.00 737,494.00 645.230.59 645.230.59 USES/MONEY & PROP-INTEREST 17.137.00 1. 848,56 15.288.44 17.139.71 17.139,71 OTHER SOURCES OF REVENUE 9.700.00 9.700.00 5.603.48 2.578.84 3.024,64 TOTAL REVENUE 764.331. 00 1. 848.56 762.482.44 667,973.78 2.578.84 665.394,94 *******EXPENDITURES******* PUBLI C SAFETY: TRAFFIC SIGNALS & STREET LIG 319,000.00 19.109.39 299,890.61 262.370.43 15.588.26 246.782.17 ACTI V ITY TOTAL 319.000.00 19.109.39 299,890.61 262.370.43 15.588.26 246.782.17 TRANSPORTATION PUBLI C WORKS 2,470.00 85.96 2,384.04 2.095,50 229.23 1. 866 . 27 STREET TREE MAINTENANCE 31.173.00 31.173.00 19.407.11 461. 24 18,945.87 STREET LANDSCAPE MAINTENANCE 404.790.00 20.54 404,769.46 329.352.28 3.420.70 325,931.58 ACTI V ITY TOTAL 438,433.00 106.50 438,326.50 350.854.89 4.111.17 346.743.72 COMMUNITY DEVELOPMENT ENGINEERING 13.100.00 358.50 12,741.50 11.357.60 327.60 11,030.00 ACTI V ITY TOTAL 13.100.00 358.50 12,741.50 11.357.60 327.60 11.030.00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 18.106.69 18.106.69 STREET CONSTRUCTION/IMPRVMNT 75.000.00 75.000.00 ACTI V ITY TOTAL 93.106.69 93.106.69 TOT A L EXPENDITURES 770.533.00 19.574.39 750,958.61 717.689.61 20.027.03 697.662.58 EXCESS REVENUE (EXPENDITURES) (6.202.00) (17,725.83) 11,523.83 (49.715.83) (17 .448.19) (32.267.64) REVENUES OVER (UNDER) EXPENDITURES (6.202.00) (17,725.83) 11,523.83 (49.715.83) (17.448.19) (32.267.64) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 08/31/2006 CAP I TAL IMP R 0 V E MEN T FUN D S CURRENT BUDGET PRIOR FISCAL YEAR CURRENT ACTUAL VARIANCE ********REVENUE******** USES/MONEY & PROP-INTEREST OTHER SOURCES OF REVENUE TOTAL REVENUE: 1. 444.942.00 21. 267 . 707 . 00 22.712.649.00 129.299.06 1.315.642.94 1.286.165.31 5.463.701.11 15.804.005.89 17.384.910.43 5.593.000.17 17.119.648.83 18.677.675.74 10 Or ;q PRIOR Y.T.D. VARIANCE 1.286,165,31 3.779.734.53 13.605.175.90 3.779.734.53 14.897.941.21 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 52,250.00 52.250.00 56,509.63 56.509.63 ACTI V ITY TOTAL 52,250.00 52.250.00 56,509.63 56.509.63 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 804,070.00 23.658.40 780.411.60 327,654.70 34,541. 04 293,113.66 ACTI V ITY TOTAL 804,070.00 23.658.40 780.411.60 327.654.70 34.541. 04 293.113,66 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTI V ITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTI V ITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 12.710.00 12,710.00 59.380.81 59.380.81 COMMUNITY IMPROVEMENTS PARKS 1.319,439.00 305.255.00 1.014.184,00 9,103.686.17 333.051.56 8.770.634.61 STREET CONSTRUCTION/IMPROVEMENT 35.672,424.00 797.355.29 34.875.068.71 6,359.251.49 22.701. 97 6,336.549.52 ACTI V ITY TOTAL 37.004,573.00 1.102.610.29 35.901. 962.71 15.522.318.47 355.753.53 15.166,564.94 TOT A L EXPENDITURES 37.860.893.00 1,126,268.69 36.734,624.31 15.981.533,14 390.294.57 15,591,238.57 EXCESS REVENUE (EXPENDITURES) 05.148.244.00) 4,466,731.48 (19.614,975.48) 2.689.542.60 3.389.439.96 (699,897.36) TRANSFER IN FROM OTHER FUNDS (6.600.00) (6.600.00) TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES(15.148.244.00) 4,466,731.48 (19,614,975.48) 2.696.142.60 3.389,439.96 (693,297.36) Ii I J1t (J-t THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 08/31/2006 T R U S T / AGE N C Y FUN 0 CURRENT CURRENT PRIOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 242.044.14 242.044.14 USES/MONEY & PROP-INTEREST 1. 088 . 94 0.088.94 ) 9.505.83 9.505.83 TOTAL REVENUE 1. 088 . 94 0.088.94 ) 251. 549.97 251.549.97 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 230.503.00 186.363.75 44.139.25 231.731.25 181.173.75 50.557.50 ACTI V ITY TOTAL 230.503.00 186.363.75 44.139.25 231.731.25 181.173.75 50.557.50 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 230.503.00 186.363.75 44.139.25 231.731.25 181.173.75 50.557.50 EXCESS REVENUE (EXPENDITURES) (230.503.00) 085.274.81) (45.228.19) 19.818.72 081.173.75) 200.992.47 REVENUES OVER (UNDER) EXPENDITURES (230.503.00) 085.274.81) (45.228.19) 19.818.72 081.173.75) 200.992.47 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 08/31/2006 f:JCf:21 N T ERN A L S E R V ICE FUN D S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 407.294.00 34.524.75 372.769.25 267.035.82 267.035.82 CHARGES FOR SERVICES 1. 784.731. 00 187.305.12 1.597.425.88 1. 790 . 982 . 80 295.668.67 1.495.314.13 OTHER SOURCES OF REVENUE 19.800.00 19.800.00 37.948.00 14.116.75 23.831. 25 TOTAL REVENUE 2.211.825.00 221. 829.87 1. 989 . 995 .13 2.095.966.62 309.785.42 1. 786 .181. 20 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2.043.020.00 40.088.98 2.002.931. 02 744.178.13 59.839.23 684.338.90 ACTI V!TY TOTAL 2.043.020.00 40.088.98 2.002.931. 02 744.178.13 59.839.23 684.338.90 PUBLI C SAFETY: FIRE 46.269.84 46.269.84 ACTI V!TY TOTAL 46.269.84 46.269.84 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 2.043.020.00 40.088.98 2.002.931. 02 790.447.97 59.839.23 730.608.74 EXCESS REVENUE (EXPENDITURES) 168.805.00 181.740.89 (12.935.89 ) 1. 305 . 518 . 65 249.946.19 1. 055.572.46 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES 168.805.00 181.740.89 (12.935.89 ) 1.305.518.65 249.946.19 1. 055.572. 46 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 08/31/2006 E N T E R P R I S E FUN D CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR ********REVENUES******** USESIMONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 20.00 20.00 FINANCE ACTI V ITY TOTAL 20.00 20.00 PUBLIC SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT 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) PRIOR Y.T.D. /6 d J+ VARIANCE III /' I ~rot ;?L1 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JULY 2006 Prepared by The Finance Department September 15, 2006 /6' a/ ;It CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Ju12006 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 (50.377.651) 3.642.091 573.224 36.329.193 210.894 (9.622.249) (7 .966.685) CASH WITH FISCAL AGENT 181.893 181.893 175.727 AMOUNT HELD IN ESCROW 1. 762.000 1. 762.000 661. 000 INVESTMENTS AT COST 106.566.435 106.566.435 102.548.812 RECEIVABLES: TAXES ACCOUNTS 556.353 221. 546 3.415 315.780 1. 097 . 094 2.427.706 INTEREST 671. 287 671. 287 500.222 ASSESSMENTS DUE FROM OTHERS 1. 950.951 1. 950.951 2.206.558 INVENTORY AT COST PREPAID ITEMS 2.307 2.307 11.590 FIXED ASSETS LOANS RECEIVABLE 4.731. 534 4.731. 534 4.596.534 AMOUNT TO BE PROVIDED 1. 083 . 500 1. 083.500 1. 213.500 TOTAL ASSETS 59.369.681 3.863.637 576.639 43.138.507 1.476.287 108.424.751 106.374.965 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL (749.468) (749.468) (967.954) DEPOSITS FOR AB1600 FEES (659.837) (659.837) (351.164 ) DEPOSITS OTHERS (2.338.044) (2.338.044) (2.641. 384) PAYABLES: ACCOUNTS (5.895.318) (276.105) (37.482) (232.136) (6.441. 042) (7.800.261) INTEREST PAYROLL (628.158) (628.158) (617.611) DUE TO OTHERS (338.835) (57.353) ( 1. 893 . 598) (2.289.786) (2.304.581) DEFERRED REVENUE 033.125 ) 033.125 ) 027.768) DEBT INSTRUMENTS PAYABLE 0.201. 000) 0.201. 000) (1. 331. 000) TOTAL LIABILITIES 00.742.786) (333.458) (37.482) (2.125.734) 0.201. 000) 04.440.460) 06.141. 723) FUND BALANCES (48.626.895) (3.530.179) (539.157) (41.012.773) (275.287) (93.984.291) (90.233.242) TOTAL FUND E (48.626.895) (3.530.179) (539.157) (41.012.773) (275.287) (93.984.291) (90.233.242) TOTAL LIABILITIES/EQUITY (59.369.681) (3.863.637) (576.639) (43.138.507) (1.476.287)(108.424.751)(106.374.965) "b ;;;4 I [, CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 31Ju12006 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 10.320.920 10.320.920 9.127.410 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 50.002.851 333.664.335 383.667.186 383.667.186 LOANS RECEIVABLE AMOUNT TO BE PROVIDED 63.454.426 63.454.426 63.728.304 TOTAL ASSETS 60.323.772 333.664.335 63.454.426 457.442.532 456.522.901 LIABILITIES/FUND EQUITY DEPOSITS FOR PRIVATE DEVEL DEPOSITS FOR AB1600 FEES DEPOS ITS OTHERS PAYABLES: ACCOUNTS (27.473) (27.473) (56.861) INTEREST PAYROLL DUE TO OTHERS DEFERRED REVENUE DEBT INSTRUMENTS PAYABLE (63.454.426) (63.454.426) (63.728.304) TOTAL LIABILITIES (27.473) (63.454.426) (63.481.899) (63.785.165) FUND BALANCES (60.296.299) (333.664.335) (393.960.634)(392.737.735) TOTAL FUND E (60.296.299) (333.664.335) (393.960.634)(392.737.735) TOTAL LIABILITIES/EQUITY (60.323.772) (333.664.335) (63.454.426) (457.442.532)(456.522.901) /7ofl1 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 07/31/2006 G ENE R A L REV E N U E FUN D CURRENT CURRENT PR lOR PRIOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE *******REVENUES******* PROPERTY TAXES 17.470.288.00 17.470.288.00 16.775.905.94 16.775.905.94 SALES TAX 15.283.000.00 791. 400.00 14.491.600.00 14.122.360.86 746.500.00 13.375.860.86 REAL PROPERTY TRANSFER TAX 712.000.00 712.000.00 690.404.35 690.404.35 HOTEL TRANSIENT OCCUPANCY TAX 685.000.00 685.000.00 727.611.60 727.611.60 FRANCHISE TAXES 1. 921. 000.00 1.921.000.00 1.789.355.75 1.789.355.75 LICENSES & PERMITS 2.901.819.00 229.613.45 2.672.205.55 3.142.223.22 160.452.03 2.981. 771.19 FINES & FORFEITURES 143.560.00 5.164.66 138.395.34 149.467.45 4.483.62 144.983.83 USE/MONEY & PROP-INTEREST 1.864.164.00 70.796.86 1.793.367.14 1.447.812.35 105.144.52 1. 342 . 667.83 USE/MONEY & PROP-RENTALS 173.574.00 4.325.05 169.248.95 123.016.09 2.243.63 120.772.46 INTERGOVERNMENTAL 1. 083.021. 00 22.667.27 1.060.353.73 1.020.574.22 618.464.85 402.109.37 CHARGES FOR SERVICES 6.740.407.00 219.294.64 6.521.112.36 5.774.668.80 208.343.72 5.566.325.08 OTHER SOURCES OF REVENUE 1. 946.995.00 3.201.09 1.943.793.91 275.245.24 3.448.50 271.796.74 TOTAL REVENUE 50.924.828.00 1. 346 . 463.02 49.578.364.98 46.038.645.87 1. 849 . 080 . 87 44.189.565.00 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 358.156.00 17.131.11 341. 024.89 246.713.83 20.954.86 225.758.97 CITY MANAGER 1. 045.943.00 59.775.09 986.167.91 960.947.89 57.018.93 903.928.96 CENTRAL SERVICES 453.571. 00 18.611.93 434.959.07 429.556.52 19.274.94 410.281. 58 CITY ATTORNEY 750.395.00 2.872.56 747.522.44 623.049.58 2.020.57 621. 029.01 ADMIN SERVICES 1. 708.961. 00 114.550.68 1. 594 .410.32 1. 544 . 209 . 40 102.818.24 1. 441. 391.16 BUILDING MANAGEMENT 762.909.00 12.968.77 749.940.23 709.411.15 12.453.32 696.957.83 INSURANCE COST CENTER 443.659.00 244.161.00 199.498.00 349.473.23 231.138.00 118.335.23 ELECTIONS COST CENTER 21. 815.00 145.00 21. 670.00 2.244.10 2.244.10 NON-DEPARTMENTAL 78.269.00 78.269.00 10.230.71 401.97 9.828.74 ACTI V ITY TOTAL 5.623.678.00 470.216.14 5.153.461.86 4.875.836.41 446.080.83 4.429.755.58 PUBLIC SAFETY POLICE 12.171.938.00 44.848.24 12.127.089.76 10.519.026.18 71.881. 91 10.447.144.27 CROSSING GUARDS 88.511.00 88.511.00 79.558.58 79.558.58 ANIMAL CONTROL 255.100.00 255.100.00 225.853.07 225.853.07 TRAFFIC SIGNALS & STREET LIGHTIN 16.315.00 16.315.00 12.608.33 12.608.33 DISASTER PREPAREDNESS 103.130.00 2.456.06 100.673.94 59.513.44 3.025.79 56.487.65 FIRE SERVICES 9.253.613.00 28.551. 63 9.225.061.37 8.850.271. 63 29.524.78 8.820.746.85 ACTI V ITY TOTAL 21. 888.607.00 75.855.93 21. 812.751. 07 19.746.831.23 104.432.48 19.642.398.75 TRANSPORTATION PUBLI C WORKS 975.320.00 46.208.29 929.111. 71 783.622.13 39.786.14 743.835.99 STREET MAINTENANCE 33.440.00 33.440.00 30.314.00 30.314.00 STREET SWEEPING 145.400.00 145.400.00 135.923.35 135.923.35 STREET TREE MAINTENANCE 103.529.00 103.529.00 119.576.15 119.576.15 STREET LANDSCAPING MAINTENAN 800.168.00 800.168.00 709.557.73 709.557.73 ACTI V ITY TOTAL 2.057.857.00 46.208.29 2.011.648.71 1.778.993.36 39.786.14 1. 739 . 207.22 HEALTH & WELFARE WASTE MANAGEMENT 18.000.00 18.000.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 /1 or .lLi THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 07/31/2006 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 ACTI V ITY TOTAL 46.500.00 18,500,00 28.000,00 23.829.31 23,829.31 CULTURE & LEISURE SERVICES LIBRARY SERVICES 830.642.00 338.49 830.303,51 618.993.45 618.993,45 CULTURAL ACTIVITIES 265.457.00 30,974.55 234.482.45 233,514.19 23,590.38 209.923.81 HERITAGE CENTER 180.402.00 7,924.67 172 ,477 ,33 158.806.33 8,604.89 150,201. 44 DUBLI N CEMETERY 49.060.00 49.060.00 36,321. 70 36.321. 70 PARK MAINTENANCE 1.811.174.00 1.811.174.00 1. 390 .353.67 1. 390 . 353.67 COMMUN ITY TV 67.591. 00 59,466.00 8,125.00 63,060.91 58,032.00 5.028.91 RECREATION ADMIN 740.553.00 46,322.20 694,230.80 686.487.52 44.082.97 642.404.55 PLAYGROUNDS 280.051.00 17,479.90 262,571.10 243.464.19 19.080.42 224.383.77 SHANNON CENTER 303.829.00 15,256.15 288,572. 85 328,750.40 18.694.83 310.055.57 PRESCHOOL 121.504.00 4,803.95 116.700.05 108.039,36 4.518.22 103.521.14 TEENS PROGRAM 150.581. 00 8,450.57 142,130.43 143.225.92 7.278.15 135.947.77 ADULT SPORTS 136.873.00 4,560.88 132,312.12 83.918.06 3.330.92 80.587,14 YOUTH SPORTS 170.700.00 4,773.81 165,926.19 142.237.92 5.235.45 137.002.47 COMMUN ITY GYM 43.969.00 31.79 43.937.21 40.429.40 331.72 40.097.68 EMERALD GLEN ACTIVITY CENTER SPECIAL EVENTS 369,636.00 8,667.49 360,968.51 377.607.25 16.142.93 361. 464,32 SENIOR CENTER 485.216.00 18,793.72 466,422,28 421. 034.20 14.075.34 406.958.86 RECREATION INSTRUCTION 189,417,00 7.479.97 181,937,03 166.976,26 5.658,70 161.317.56 AQUATICS 446.642,00 31. 295.85 415,346.15 411. 688.61 37.660.83 374.027.78 PARKS/FACILITIES MANAGEMENT 326,214.00 17,316,53 308,897.47 293.640.02 16.811.91 276.828.11 ACTI V ITY TOTAL 6,969,511.00 283,936,52 6,685,574.48 5.948.549.36 283.129.66 5.665.419.70 COMMUNITY DEVELOPMENT PLANNING 2,920,013.00 94,962.00 2,825,051. 00 2.220.229,85 84.406.97 2.135.822,88 BUILDING SAFETY 3,205,667,00 52,891. 26 3,152,775.74 2.908.292.43 48.620.85 2.859.671.58 ENGINEERING 2,215,848.00 89,531. 72 2,126,316.28 2.380.351. 96 90,685.24 2.289.666.72 ECONOMIC DEVELOPMENT 262,742.00 54.213,98 208.528.02 291.108.79 45.140.88 245.967.91 ACTI V ITY TOTAL 8,604,270.00 291. 598,96 8,312,671.04 7.799.983.03 268.853.94 7 . 531. 129 . 09 CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 1,181,320.00 1.181. 320.00 612,958.83 612,958.83 COMMUNITY IMPROVEMENTS 261.044.00 975.29 260.068.71 780,954.81 5,881. 68 775,073.13 PARKS 3,240,463.00 95.116.03 3.145.346.97 1. 037,007.51 11,332.84 1.025,674.67 STREET CONSTRC/IMPROVEMENTS 697,235.00 247.04 696,987.96 660,581.62 802.74 659,778.88 ACTI V ITY TOTAL 5.380.062.00 96.338.36 5.283.723.64 3,091. 502 . 77 18,017.26 3,073,485.51 TOTAL EXPENDITURES 50.570.485.00 1. 282 . 654.20 49.287.830.80 43,265,525.47 1.160.300.31 42,105.225.16 EXCESS REVENUE (EXPENDITURES) 354.343.00 63.808.82 290.534.18 2,773.120.40 688.780.56 2,084,339.84 TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT FROM OTHER FUNDS REVENUES OVER(UNDER) EXPENDITURES 354.343.00 63.808.82 290.534.18 2.773,120.40 688,780.56 2,084,339,84 /.) l,."'l f Ii t) 'c /Lf ii' I 1'. THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 07/31/2006 S P E C I A L REV E N U E FUN D S CURRENT CURRENT PRIOR PR lOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** PROPERTY TAXES 119.960.00 119.960.00 115.763.98 115.763.98 SALES TAX/OTHER TAXES 426.421.00 426.421.00 443.195.51 443.195.51 FINES & FORFEITURES 177.000.00 177,000.00 190,869.24 190.869.24 USES/MONEY & PROPERTY 120,002.00 4,461.39 115,540.61 108.314.70 108,314.70 INTERGOVERNMENTAL FROM STATE 1.084,313.00 1.084,313.00 1.094.513.46 1. 094,513.46 INTERGOVERNMENTAL FROM COUNTY 370.913.00 370,913.00 308,928.00 308,928.00 INTERGOVERNMENTAL FROM FEDERAL 482,198.00 482,198.00 106,583.00 106,583.00 CHARGES FOR SERVICES 1. 462 . 058.00 1. 462 , 058 . 00 1.315,435.57 1. 315 .435.57 OTHER SOURCES OF REVENUE 29.000.00 29,000.00 420,867.00 420.867.00 TOTAL REVENUE 4.271.865.00 4,461.39 4.267.403.61 4.104,470.46 4.104.470.46 *******EXPENDI TURES******* PUBLl C SAFETY: POll CE 103.710.00 103.710.00 105,670.43 105.670.43 TRAFFIC SIGNALS & STREET LTG 265.922.00 5,271 .43 260.650.57 225,650.30 2,083.33 223.566.97 DISASTER PREPAREDNESS FIRE SERVICES 276.973.00 276.973.00 267.350.23 267,350.23 ACTI V ITY TOTAL 646.605.00 5.271.43 641. 333.57 598.670.96 2.083.33 596,587.63 TRANSPORTATION: STREET MAINTENANCE 379.294.00 379.294.00 335.939.86 335,939.86 STREET LANDSCAPE MAINTENANCE 5.822.00 5,822.00 4.823.96 4,823.96 ACTI V ITY TOTAL 385,116.00 385.116.00 340.763.82 340,763.82 HEALTH & WELFARE: WASTE MANAGEMENT 1. 570 , 978.00 1. 799.20 1. 569 . 178.80 1,822.693.60 4 , 526. 10 1.818,167.50 SOCIAL SERVICES 61. 804.00 61. 804.00 60.427.00 60,427.00 HOUSING PROGRAMS ACTI V ITY TOTAL 1. 632 .782 . 00 1. 799.20 1. 630 . 982 . 80 1.883.120.60 4.526.10 1.878,594.50 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 17.581.00 17.581.00 39.556.00 39,556.00 PARKS 136,587.00 136,587.00 50.349.43 50,349.43 STREET CONSTRUCTION/IMPROVEMENT 1.149.439.00 4,305.85 1.145,133.15 1.257.617.38 4,681. 72 1. 252 . 935 . 66 ACTI V ITY TOTAL 1,303,607.00 4,305.85 1. 299.301.15 1.347.522.81 4,681. 72 1. 342.841. 09 TOT A L EXPENDITURES 3,974,110.00 11,376.48 3,962,733.52 4.176,078.19 11. 291.15 4.164.787.04 EXCESS REVENUE (EXPENDITURES) 297.755.00 (6,915.09) 304.670.09 (71.607.73) (11,291.15) (60.316.58) TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS 6,600.00 6.600.00 REVENUES OVER (UNDER) EXPENDITURES 297.755.00 (6.915.09) 304.670.09 <78.207.73) (11.291.15) (66,916.58) /' ;]'1 (1' l~ THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 07/31/2006 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 737.494,00 737.494,00 645.230.59 645.230.59 USES/MONEY & PROP-INTEREST 17.137.00 703.91 16.433.09 17.139.71 17.139.71 OTHER SOURCES OF REVENUE 9.700.00 9.700.00 5.603.48 5.603.48 TOTAL REVENUE 764.331.00 703.91 763.627.09 667.973.78 667.973.78 *******EXPENDITURES******* PUBU C SAFETY: TRAFFIC SIGNALS & STREET LIG 319.000.00 319.000.00 262.370.43 262.370.43 ACTI V ITY TOTAL 319.000.00 319.000,00 262.370.43 262.370.43 TRANSPORTATION PUBU C WORKS 2.470.00 28.66 2.441. 34 2.095.50 229,23 1. 866 . 27 STREET TREE MAINTENANCE 31.173.00 31.173.00 19.407.11 19.407.11 STREET LANDSCAPE MAINTENANCE 404.790.00 404.790.00 329.352.28 329.352.28 ACTI V ITY TOTAL 438.433.00 28.66 438.404.34 350.854.89 229.23 350.625.66 COMMUNITY DEVELOPMENT ENGINEERING 13.100.00 13.100.00 11.357.60 11.357.60 ACTI V ITY TOTAL 13.100.00 13.100.00 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 ACTI V ITY TOTAL 93.106.69 93.106,69 TOT A L EXPENDITURES 770.533.00 28.66 770.504.34 717.689.61 229.23 717.460.38 EXCESS REVENUE (EXPENDITURES) (6.202.00) 675.25 (6.877.25) (49.715,83) (229.23) (49.486.60) REVENUES OVER (UNDER) EXPENDITURES (6.202.00) 675,25 (6.877.25) (49.715.83) (229.23) (49.486.60) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 07/31/2006 '" I '7U. / J (J-I f7\ I 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 1. 444 . 942 . 00 44.467.97 1.400.474.03 1.286.165.31 1.286.165.31 OTHER SOURCES OF REVENUE 21. 267.707.00 367.041. 00 20.900.666.00 17.384.910.43 788.257.80 16.596.652.63 TOTAL REVENUE: 22.712.649.00 411.508.97 22.301.140.03 18.677.675.74 788.257.80 17.889.417.94 *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: CITY ATTORNEY 52.250.00 52.250.00 56.509.63 56.509.63 ACTI V ITY TOTAL 52.250.00 52.250.00 56.509.63 56.509.63 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: HOUSING PROGRAMS 804.070.00 10.999.46 793.070.54 327.654.70 14.027.37 313.627.33 ACTI V ITY TOTAL 804.070.00 10.999.46 793.070.54 327.654.70 14.027.37 313.627.33 CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTI V ITY TOTAL COMMUNITY DEVELOPMENT PLANNING ACTI V ITY TOTAL CAPITAL IMPROVEMENT PROJECTS GENERAL CIP PROJECTS 12.710. aD 12.710.00 59.380.81 59.380.81 COMMUNITY IMPROVEMENTS PARKS 1.319.439.00 305.255.00 1.014.184.00 9.103.686.17 1. 079.23 9.102.606.94 STREET CONSTRUCTION/IMPROVEMENT 35.672 .424.00 321.305.54 35.351.118.46 6.359.251.49 8.524.14 6.350.727.35 ACTI V ITY TOTAL 37.004.573.00 626.560.54 36.378.012.46 15.522.318.47 9.603.37 15.512.715.10 TOT A L EXPENDITURES 37.860.893.00 637.560.00 37.223.333.00 15.981. 533 .14 23.630.74 15.957.902.40 EXCESS REVENUE (EXPENDITURES) 05.148.244.00) (226.051.03)(14.922.192.97) 2.689.542.60 764.627.06 1.924.915.54 TRANSFER IN FROM OTHER FUNDS (6.600.00) (6.600.00) TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES(15.148.244.00) (226.051.03)(14.922.192.97) 2.696 .142 . 60 764.627.06 1. 931. 515.54 ? -, ,. tiLt .' n.' I ,,/J' , THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 07/31/2006 T R U S T / AGE N C Y FUN D CURRENT CURRENT PRIOR PR lOR BUDGET ACTUAL VARIANCE FISCAL YEAR Y.T.D. VARIANCE ********REVENUES******** SPECIAL ASSESSMENTS 242.044.14 242.044.14 USES/MONEY & PROP-INTEREST 259.93 (259.93) 9.505.83 9.505.83 TOTAL REVENUE 259.93 (259.93) 251.549.97 251.549.97 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 230.503.00 230.503.00 231.731.25 231. 731. 25 ACTI V ITY TOTAL 230.503.00 230.503.00 231.731.25 231. 731. 25 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS TOT A L EXPENDITURES 230.503.00 230.503.00 231.731.25 231.731.25 EXCESS REVENUE (EXPENDITURES) (230.503.00) 259.93 (230.762.93) 19.818.72 19.818.72 REVENUES OVER (UNDER) EXPENDITURES (230.503.00) 259.93 (230.762.93) 19.818.72 19.818.72 .23 of .} + THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 07/31/2006 I N T ERN A L S E R V ICE FUN D S CURRENT BUDGET CURRENT ACTUAL VARIANCE PRIOR FISCAL YEAR PRIOR Y.T.D. VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST 407.294.00 12.613.42 394.680.58 267.035.82 267.035.82 CHARGES FOR SERVICES 1. 784.731. 00 64.204.22 1. 720 . 526.78 1. 790.982.80 147.113.68 1. 643.869. 12 OTHER SOURCES OF REVENUE 19.800.00 19.800.00 37.948.00 14.116.75 23.831. 25 TOTAL REVENUE 2.211.825.00 76.817.64 2.135.007.36 2.095.966.62 161.230.43 1.934.736.19 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL 2.043.020.00 17.650.34 2.025.369.66 744.178.13 19.443.15 724.734.98 ACTI V ITY TOTAL 2.043.020.00 17.650.34 2.025.369.66 744.178.13 19.443.15 724.734.98 PUBLIC SAFETY: FIRE 46.269.84 46.269.84 ACTI V ITY TOTAL 46.269.84 46.269.84 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 2.043.020.00 17.650.34 2.025.369.66 790.447.97 19.443.15 771. 004.82 EXCESS REVENUE (EXPENDITURES) 168.805.00 59.167.30 109.637.70 1. 305.518.65 141.787.28 1.163.731. 37 TRANSFER IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS REVENUES OVER (UNDER) EXPENDITURES 168.805.00 59.167.30 109.637.70 1.305.518.65 141. 787 .28 1.163.731. 37 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 07/01/2006 THROUGH 07/31/2006 E N T E R P R I S E FUN D CURRENT BUDGET CURRENT ACTUAL PRIOR FISCAL YEAR VARIANCE ********REVENUES******** USES/MONEY & PROP-INTEREST TOTAL REVENUE ********EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 20.00 20.00 FINANCE ACTI V ITY TOTAL 20.00 20.00 PUBLI C SAFETY: HEALTH & WELFARE: CULTURE & LEISURE SERVICES COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT 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) PRIOR Y.T.D. .'7J.l t '\ 'f veIO" " VARIANCE