The URL can be used to link to this page

Home My WebLink About4.09 PrelimFinRpt 8-97CITY CLERK File # 0 3I E- 5 0 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (October 7. 1997) SUBJECT: Preliminary Financial Report For the Month of August 1997 OpReport Prepared by: Paul S. Rankin, Assistant City Manager EXHIBITS ATTACHED: Pro Forma Balance Sheet and Income Statements for r the Period Ending August 31, 1997 RECOMMENDATION:) `� Accept and file the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the preliminary financial statements for the month of August. The reason that the report is presented as "preliminary" is that the final audited results of Fiscal Year 1996/97 are not yet available. 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. Preliminary ReRorting of Information • The auditors have just completed the final phase of their field work necessary for the 1996/97 audit. The final audit results will impact the reported Fund Balance presented in the attached monthly reports. For example, any General Fund Revenues which exceeded the 1996/97 expenditures have not been carried forward to the 1997/98 Fund Balance. The computer program used by the City requires that all posting entries to the prior year be complete, prior to posting the change in fund balance. Staff has already made the final year end accrual for sales tax, and anticipates that the final entries will occur by the October report. The scope of the changes is not significant when compared to all general fund revenues and expenses. Anal sis of Preliminary Auggst 1997 Revenue and EIc enditure ReR0rt Given that this is only the second month of the 1997/98 Fiscal Year, there is extremely limited data on which to base any major projections or identify significant trends. For example the receipt of revenues does not typically follow an even distribution throughout the Fiscal Year. Major amounts of Property Taxes and Sales Taxes are not received until later in the Fiscal Year. There is also a lag with the reporting of expenditures due to the significant amount of services provided to the City by independent contractors. General Fund Revenues Total General Fund Revenues collected through August are comparable to what occurred in the second month of the previous Fiscal Year. The City had collected through August 1997 approximately 10% of the total budgeted General Fund Revenues, similar to the same period in the prior Fiscal Year. Sales Tax is higher than in the same period in the previous year as the State has increased the amount of the monthly sales tax advances to the City as a result of the increased sales activity within the City, primarily related to COPIES TO: G AM0NTHFSTV981089'7AG.DBC ITEM NO. 4,9 autos. Real Property Transfer Taxes have increased over the same period in the prior year due io an increase in assessed value and sales activity for residential units within the City. Transient Occupancy Taxes are higher than in the same period due to timing differences in the collectio of these taxes. Licenses and Permits are lower than in the same period in the prior year due to 3D issuance of several building permits for the California Highlands project in the first two months of the previous year. Other revenues are higher than in the same period in the prior year due to an increase in the equity distribution payment received from ABAG PLAN, the City's liability insurance coverage provider, and an increase in parking citations issued over the same period in the prior year. Based upon the limited information available there were not any areas with significant deviations from the current budget projections. General Fund EXUnditures Overall, through the month of August expenditures in the General Fund totaled $1,817,665 and represented approximately 10% of the total budgeted expenditures in the General Fund. Of this amount, a total of $7,792 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 at only General Fund Operating Expenditures, the activity through August 1997 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of August 31, 1997, the City had expended 10% of the General Fund Operating Budget compared to 9% in the prior Fiscal Year. As previously noted there are some timing differences with payment for contract services, including the payment for fire services, which complicate comparisons between one year to the next. 0 Transportation is down from the same period in the prior year due to timing differences in the completion of the City's street overlay project. Culture and Community Services is higher than the same period in the prior year due to timing differences in the payment for contract recreation instructors and for annual cable services for Channel 30. Community Development is higher than the same period in the prior year due to the payment for annual membership in the Tri Valley Convention and Visitors Bureau. Capital Improvement Projects are down from the same period in the prior year due to expenditures incurred in the prior year on the Dublin Blvd Widening project. All expenditures to date are within the authorized budget. It is recommended that the City Council receive and file these reports as authorized by Section 41004 of the California Government Code. I� 12 — 0 City of Dublin 1997 -98 YTD Revenues and Budget Comparison For the Period Ending August 31, 1997- Unaudited Total General Fund 10% Revenues 10% Property Taxes 0% -T 0% Interest and Rentals 1,2% Intergovernmental 17°/ from State 15% 2% Charges for Services 27% Other Revenues 0% 30% 60% 90% 120% 16% of Year Complete 150% ■ FY 97/98 p FY 96/97 16 % Sales Taxes 15% Transient 12% Occupancy Taxes 5% YTD Actual 4% Franchise Taxes 4% Licenses and Permits 0 % Interest and Rentals 1,2% Intergovernmental 17°/ from State 15% 2% Charges for Services 27% Other Revenues 0% 30% 60% 90% 120% 16% of Year Complete 150% ■ FY 97/98 p FY 96/97 FY 97/98 FY 97198 % of FY 96/97 % of Total for Budget YTD Actual Budget YTD Actual FY 96/97 Property Taxes 4,407,700 12,736 0% 10,300 0% Sales Taxes 6,850,000 1,119,300 16% 1,064,200 15% Transient Occupancy Taxes 231,000 28,317 12% 14,028 5% Franchise Taxes 750,500 31,178 4% 28,278 4% Licenses and Permits 1,043,350 97,359 9% 155,012 14% Interest and Rentals 1,328,450 36,929 3% 49,360 4% Intergovernmental 1,171,620 198,843 17% 176,918 15% Charges for Services 1,631,918 188,550 12% 162,441 12% Other Revenues 488,719 133,539 27% 70,122 26% Total General Fund Revenues 17,903,257 1,846,751 10% 1,730,659 10% 9/NW 16:52 g:lmonthfsVy98Vs.x1s City of Dublin 1997 -98 YTD Expenses and Budget Comparison For the Period Ending August 31, 1997 - Unaudited Total General Fund 10% Expenses 099% General Government 14% 14% Civic Center Lease 23 Police r 1% Fire � 16% Other Public Safety 0 "/9 9 /o 3% Transportation 6%° Health and Welfare 10% Culture & Community 13% Services IWO% Community Development 11% 10% Capital Improv. Projects 1% ° 14 /° 0% 30% 60% 16% of Year Complete FY 97/98 FY 97/98 YTD Actual Budget General Government 1,808,378 Civic Center Lease 1,599,919 Police 4,280,674 Fire 3,598,953 Other Public Safety 276,880 Transportation 667,372 Health and Welfare 17,320 Culture and Community Services 2,119,950 Community Development 2,266,885 Capital Improvement Projects 1,131,051 Total General Fund Expenses 17,767,382 General Fund Operating Expenses 16,636,331 9129/97 78:54 a 60% 16% of Year Complete FY 97/98 % of YTD Actual Budget 258,064 14% 361,627 23% 44,196 1% 593,000 16% 151 0% 39,428 6% 0 0% 274,820 13% 238,587 11% 7,792 1% 1,817,665 10% 1,809,873 11% 90% FY 96/97 YTD Actual ■ FY 97/98 ■ FY 96/97 1.20% % of Total for FY 96/97 232,336 14% 376,881 25% 34,540 1 % 229,534 8% 4,512 3% 58,183 9% 0 0% 198,518 10% 177,310 10% 144,908 . 140% 1,456,722 9% 1,311,814 9% gAm°nthWy9ti sAs • C.l • 911 CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS at THE MONTH OF AUGUST 1997 Prepared by The Finance Department September 29, 1997 EXHI BIT X GL102 CITY OF DUBLIN PAGE 1 9/25/97 BALANCE SHEET 16.04.14 FOR THE PERIOD 7/97 THROUGH 8/97 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L So REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY - -- MEMORANDUM ONLY - -- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1997 ASSETS CASH 4428367.22- 1760978.45 287964.41 2181102.11 17737.79 180584.46- 246090.15 CASH WITH FISCAL AGENT 137532.72 137532.72 130456.16 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 27935321.17 27935321.17 23378006.89 RECEIVABLES:TAXES 44073.96 44073.96 ACCOUNTS (NET) 717869.23 32978.54 750847.77 825664.31 INTEREST 175681.50 175681.50 68550.96 ASSESSMENTS 7466.54 1197.09 8663.63 RENTS NOTES DUE FROM OTHERS 371966.14 92825.76 464791.90 27563.44 INVENTORY AT COST PREPAID ITEMS 3398.11 3398.11 5890.69 FIXED ASSETS AMOUNTS TO BE PROVIDED 2018500.00 2018500.00 2090500.00 TOTAL ASSETS 24819942.89 1894249.29 289161.50 2181102.11 2173770.51 31358226.30 26772722 .IAB, FND SAL, RETND EARNINGS )EPOSITS FOR PRIVATE DEVELPMNT 457008.30- 457008.30- 158905.62 - )EPOSITS FOR AB1600 FEES 2197777.95- 2197777.95- 210233.11 - ]EPOSITS OTHERS 493911.89- 3547.89- 289271.92- 786731.70- 610301.72 - 'AYABLES:A000UNTS 513693.21- 187377.10- 21857.39- 3039.57- 725967.27- 611252.44 - INTEREST PAYROLL 8679.94- 8679.94- 36138.55 - lUE TO OTHERS 81766.56- 79259.00- 161025.56- 465.00 - )EST INSTRUMENTS PAYABLE 2136000.00- 2136000.00- 2208000.00 - TOTAL LIASILTIES 1555059.90- 270183.99- 21857.39- 2490089.44- 2136000.00- 6473190.72- 3835296.44 - 'UND BALANCES 23264882.99- 1624065.30- 267304.11- 308987.33 37770.51- 24885035.58- 22937426.16 - TOTAL FUND EQUITY 23264882.99- 1624065.30- 267304.11- 308987.33 37770.51- 24885035.58- 22937426.16 - OTAL LIAB,FND SAL, RETD EARNS 24819942.89- 1894249.29- 289161.50- 2181102.11- 2173770.51- 31358226.30- 26772722.60- . y GL102 9/25/97 0 ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS FND SAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS -lAYABLES:A000UNTS INTEREST PAYROLL )UE TO OTHERS )EST INSTRUMENTS PAYABLE TOTAL LIABILITIES =UND BALANCE - ONTRIBUTIONS ' NVESTMENTS IN FIXED ASSETS :STAINED EARNINGS TOTAL FUND EQUITY 'OTAL LIAB,FND SAL, RETD EARNS � 0 5 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/97 THROUGH 8/97 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUNDS GROUP OF TERM DEBT FUND ACCOUNTS ACCOUNT GROUP PAGE 1 I 16.07 19 T O T A L S - -- MEMORANDUM ONLY --- CURRENT JUNE 30, 1997 429047.77 1050.00- 427997.77 1670377.98 1670377.98 46896.00 46896.00 548797.76 19616208.27 545355.56 5640810.06 977845.53 21332432.25 545355.56 5640810.06 15535000.35 - 15535000.35- 588675.84- 687541.90- 389169.69- 5109890.00- 293473.71 I 1719329.47 20710361.59 21045462.27 5640810.06 5327970.26 28496443.40 28386235.71 5640810.06 -` 21175810.41- 21592970.26- 5640810.06- 21175810.41- 21592970.26- 1276217.74- 823098.87- 5499059.69- 5459961.45- 545355.56- 545355.56- 510205.13- 977845.53- 5797431.90- 545355.56- 7320632.99- 6793265.45- 977845.53- 21332432.25- 545355.56- 5640810.06- 28496443.40- 28386235.71- GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 9/25/97 REVENUES VERSUS EXPENDITURE 15.03.13 FOR THE PERIOD 7/97 THROUGH 8/97 0 GENERAL REVENUE FUND - CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D ** * *"* *REVENUES * * * * * ** PROPERTY TAXES 4286000.00- .00 4286000.00- 3920897.29- .00 3920897.29 - SALES TAX 6850000.00- 1119300.00- 16.3 5730700.00- 7108598.19- 1064200.00- 15.0 6D44398.19- REAL PROPERTY TRANSFERS 121700.00- 12735.85- 10.5 108964.15- 138062.47- 10299.89- 7.5 127762.58 - TRANSIENT OCCUPANCY TAX 231000.00- 28317.00- 12.3 202683.00- 267007.09- 14028.00- 5.3 252979.09 - FRANCHISE TAXES 750500.00- 31177.69- 4.2 719322.31- 723384.60- 28277.59- 3.9 695107.01 - LICENSES & PERMITS 1043350.00- 97359.46- 9.3 945990.54- 1092182.95- 155011.98- 14.2 937170.97 - FINES & FORFEITURES 33200.00- 8168.88- 24.6 25031.12- 38492.21- 4728.35- 12.3 33763.86 - USES OF MONEY AND PROPERTY 1328450.00- 36928.95- 2.8 1291521.05- 1388948.66- 49359.96- 3.6 1339588.70 - INTERGOVERNMENTAL FROM STATE 1171620.00- 198842.84- 17.0 972777.16- 1151275.49- 176917.83- 15.4 974357.66 - CHARGES FOR SERVICES 1631918.00- 188550.09- 11.6 1443367.91- 1386418.59- 162440 -92- 11.7 1223977.67 - OTHER SOURCES OF REVENUE 455519.25- 125370.11- 27.5 330149.14- 223207.32- 65394.52- 29.3 157812.80 - TOTAL REVENUE 17903257.25- 1846750.87- 10.3 16056506.38- 17438474.86- 1730659.04- 9.9 15707815.82- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 48564.00 187.40 .4 48376.60 27346.97 26.00- .1- 27372.97 CITY COUNCIL 1010 137334.00 16997.21 12.4 120336.79 127472.84 15590.07 12.2 111882.77 CITY MANAGER 1020 334487.00 46889.04 14.0 287597.96 291093.65 45689.85 15.7 24540 CITY ATTORNEY 1030 186794.00 982.08 .5 185811.92 201718.85 487.60 .2 20123 ADMIN SERVICES 1040 637675.00 92421.28 14.5 545253.72 569247.12 76763.70 13.5 492483.42 BUILDING MANAGEMENT 1050 315955.00 11392.18 3.6 304562.82 331517.40 13332.91 4.0 318184.49 FACILITY RENTAL 1050 -719 1599919.00 361626.86 22.6 1238292.14 1496816.41 376880.55 25.2 1119935.86 INSURANCE COST CENTER 1060 146803.00 89195.25 60.8 57607.75 122777.83 80458.12 65.5 42319.71 ELECTIONS COST CENTER 1070 766.00 .00 766.00 20511.92 40.64 .2 20471.28 ACTIVITY TOTAL 3408297.00 619691.30 18.2 2788605.70 3188502.99 609217.44 19.1 2579285.55 'USL1C SAFETY: POLICE 2010 4280674.00 44196.30 1.0 4236477.70 3794625.12 34540.20 .9 3760084.92 CROSSING GUARDS COST 2020 42726.00 .00 42726.00 40926.26 .00 40926.26 ANIMAL CONTROL 2030 200124.00 .DO 200124.00 110514.00 .DO 110514.00 DISASTER PREAPREDNESS 2050 34030.00 150.65 .4 33879.35 25992.10 4512.05 17.4 21480.05 FIRE SERVICES 2060 3598953.00 593000.45 16.5 3005952.55 2751796.45 229533.84 8.3 2522262.61 ACTIVITY TOTAL 8156507.00 637347.40 7.8 7519159.60 6723853.93 268586.09 4.0 6455267.84 RANSPORTATION: PUBLIC FORKS 3010 366732.00 38695.22 10.6 328036.78 319005.00 37212.66 11.7 281792.34 STREET MAINTENANCE 3020 55770.00 600.00 1.1 55170.00 31593.44 20823.23 65.9 10770.21 STREET TREE MAINTENANCE 3040 47700.00 .00 47700.00 48375.71 .00 48375.71 STREET LANDSCAPE MAINT. 3050 197170.00 132.88 .1 197037.12 230289.60 147.38 .1 230142.22 ACTIVITY TOTAL 667372.00 39428.10 5.9 627943.90 629263.75 58183.27 9.2 571080.48 EALTH & WELFARE: WASTE MANAGEMENT 5020 5320.00 .00 5320.00 3595.87 .00 3595.87 CHILD CARE 5030 12000.00 .00 12000.00 12000.00 .00 12000.00 ACTIVITY TOTAL 17320.00 .00 17320.00 15595.87 .00 15595.87 ULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 216994.00 .00 216994.00 205874.00 .00 205874.00 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 12500.00 10000.00 80.0 25D0 HERITAGE CENTER 8012 55930.00 5924.27 10.6 50005.73 54291.08 2864.81 5.3 5142 DUBLIN CEMETERY 8013 16690.00 .00 16690.00 15749.25 750.00 4.8 14999. (O GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2 9/25/97 REVENUES VERSUS EXPENDITURE 15.03.13 FOR THE isPERIOD 7/97 THROUGH 8/97 GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D PARK MAINTENANCE 8020 589455.00 1207.04 .2 588247.96 594119.19 572.03 .1 $93547.16 COMMUNITY CABLE TV 8030 37051.00 23611.00 63.7 13440.00 34256.72 200.00 .6 34056.72 RECREATION ADMIN. 8040 256353.00 38454.45 15.0 217898.55 234707.54 31612.53 13.5 203095.01 PLAYGROUNDS 8045 128003.00 26974.41 21.1 101028.59 108257.69 26628.56 24.6 81629.13 SHANNON CENTER 8050 148006.00 16308.07 11.0 131697.93 136660.43 15880.18 11.6 120780.25 PRESCHOOL 8055 54333.00 7745.13 14.3 46587.87 51629.57 7296.18 14.1 44333.39 TEENS PROGRAM 8060 35296.00 2193.42 6.2 33102.58 25445.93• 2801.48 11.0 22644.45 ADULT SPORTS 8065 65350.00 11848.96 18.1 53501.04 61034.72 8408.80 13.8 52625.92 YOUTH SPORTS 8066 52406.00 9564.08 18.2 42841.92 39910.77 6475.20 16.2 33435.57 SPECIAL EVENTS 8070 42042.00 7097.60 16.9 34944.40 40133.97 7394.51 18.4 32739.46 SENIOR CENTER 8080 104221.00 14616.91 14.0 89604.09 80392.97 11172.31 13.9 69220.66 RECREATION INSTRUCTION 8090 88555.00 34395.43 38.8 54159.57 89684.89 8391.04 9.4 81293.85 AQUATICS 8100 219265.00 64879.04 29.6 154385.96 215910.85 58070.86 26.9 157839.99 ACTIVITY TOTAL 2119950.00 274819.81 13.0 1845130.19 2000559.57 198518.49 9.9 1802041.08 IMMUNITY DEVELOPMENT: 9010 744971.00 100011.58 13.4 644959.42 659318.79 92989.17 14.1 566329.62 PLANNING BUILDING SAFETY 9020 593826.00 18313.25 3.1 575512.75 386171.15 18459.68 4.8 367712.07 ENGINEERING 9030 781875.00 73517.07 9.4 708357.93 684913.30 46919.89 6.9 637993.41 ECONOMIC DEVELOPMENT 9040 146213.00 46745.32 32.0 99467.68 108155.26 18941.46 17.5 89213.80 ACTIVITY TOTAL 2266885.00 238587.22 10.5 2028297.78 1838558.50 177309.60 9.6 1661248.90 OL IMPROVEMMENT PROJECTS: GENERAL CIP PROJECTS 93NN 560350.00 6735.5D 1.2 553614.50 80137.74 448.82 .6 79688.92 COMMUNITY IMPROVEMENTS 94NN 66000.00 .00 66000.OD 51771.12 .00 1.0 51771.12 492536.46 PARKS 95NN 192140.00 1043.81 .5 191096.19 497423.22 4886.76 STREET CONSTRC /IMPRDVMT 96NN 312561.00 11.97 312549.03 403724.50 139572.00 34.6 264152.50 ACTIVITY TOTAL 1131051.00 7791.28 .7 1123259.72 1033056.58 144907.58 14.0 888149.00 0 T A L EXPEENDITURES 17767382.00 1817665.11 10.2 15949716.89 15429391.19 1456722.47 9.4 13972668.72 XCESS [REVENUE>EXPENDITURES 135875.25- 29085.76- 21.4 106789.49- 2OD9083.67- 273936.57- 13.6 1735147.10 - RANSFERS IN FROM OTHER FUNDS .00 .DD .00 5077.54- .00 5077.54 - 4211.16 RANSFERS OUT TO OTHER FUNDS .DO .00 .00 4211.16 .00 XCESS [REVENUES EXPENDITURE 135875.25- 29085.76- 21.4 106789.49- 2009950.05- 273936.57- 13.6 1736013.48 - GL104C THE CITY OF DUBLIN STATEMENT SHOWING 9/25/97 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/97 THROUGH 8/97 SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE *" * * ** *REVENUES * ****** PROPERTY TAXES 71500.00- .DO 71500-00 - SALES TAX 159300.00- 24445.19- 15.3 134854.81 - FINES & FORFEITURES 25000.00- 1424.01- 5.7 23575.99 - USES OF MONEY AND PROPERTY 78560.00- .00 78560.00 - INTERNGOVERNMENTAL FROM STATE 740859.00- 54283.17- 7.3 686575.83 - INTERGOVERNMENTAL FROM COUNTY 141460.00- .DO 141460.00 - INTERGOVERNMENTAL FROM FEDERAL 464889.00- .00 464889.00 - CHARGES FOR SERVICES 739000.00- .00 739000.00 - OTHER SOURCES OF REVENUE 218000.00- ,00 218000.00 - TOTAL REVENUE 2638568.00- 80152.37- 3,0 2558415.63- *"" "EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .OD .00 .DO PUBLIC SAFETY: POLICE 93845.00 406.09 .4 93438.91 TRAFFIC SIGNALS 108150.00 2058.36 1.9 106091.64 FIRE SERVICES 75960 -00 .00 75960,00 ACTIVITY TOTAL 277955.00 2464.45 .9 275490.55 TRANSPORTATION: PUBLIC WORKS .00 .00 .00 STREET MAINTENANCE 208910.00 .DO 208910.00 STREET SWEEPING 80600.00 5870.76 7.3 74729.24 ACTIVITY TOTAL 289510.00 5870.76 2.0 283639.24 4EALTH & WELFARE: WASTE MANAGEMENT 808166.00 33.27 808132.73 ACTIVITY TOTAL 808166.00 33.27 808132.73 ,ULTURE & LEISURE SERVICES: PARK MAINTENANCE .00 .00 .00 ACTIVITY TOTAL .DO .00 .00 :OMMUNITY DEVELOPMENT: ENGINEERING 88120,00 1565.01 1.8 86554.99 ACTIVITY TOTAL 88120.00 1565.01 1.8 86554.99 :APITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 241447.00 4178.01 1.7 237268 -99 PARKS 191902.00 3959.51 2.1 187942.49 STREET CONSTRUCTION /IMPROVMT 766610,00 4204.73 .5 762405.27 ACTIVITY TOTAL 1199959.00 12342.25 1.0 1187616.75 0 T A L EXPENDITURES 2670755.00 22275.74 .8 2648479.26 XCESS [REVENUE>EXPENDITURE 32187.00 57876.63- 179.8- 90063.63 RANSFERS OUT TO OTHER FUNDS -DO .00 .00 XCESS [ REVENUE> EXPENDITURE 32187.00 57876,63- 179.8- 90063.63 RA PAGE 1 I 15.15.01 9 PREVIOUS YEAR ENDING JUNE 30, 1997 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D .00 152122.48 - 22506.62- 98044.39- 611716.48- 143136.00- 185082.30- 788267.59- 311205.00- 2312080.86- .00 63146.44 78617.71 .00 141764.15 172.47 213347.82 67675,22 281195.51 718827.72 718827.72 7154.1D 7191.46 88980.07 88980.07 140454.07 443937,09 353418.05 937809.21 2175768.12 136312.74- 3395.00 132917.74- .00 22462.91 - 2105.03- .00 88655.79 - 27739.00- .DO .00 11394.00 - 152356.73- .00 14.8 129659.57- 9.4 20401.59 - 98044.39- 14.5 523060.69- 19.4 115397.00 - 185082.30- 788267.59- 3.7 299811.00- 6.6 2159724.13- .00 .00 .00 1703.08 .00 1703.08 .00 .00 .00 .00 18786.48 18786.48 .00 ,00 3715.59 3715.59 .00 .DO 188005.51 188005.51 212210.66 59853.93 .00 63146.44 2.2 76914.63 .00 1.2 14006 172. 213347.82 67675.22 281195.51 2.6 700041.24 2.6 700041.24 7154.10 7191.46 4.2 85264.48 4.2 85264.48 140454.07 443937.09 53.2 165412.54 20.0 749803.70 9.8 1963557.46 43.9- 196166.67- 3395.00 59853.93 45.0- 192771.67- • � 40 ril THE CITY OF DUBLIN STATEMENT SHOWING PAGE PAGE I 4004C D4C 1 8 9/75/97 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/47 THROUGH $/97 CAPITAL IMPROVEMENT FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D * ** * ** *REVENUES * * ** - -* 2889412.00- 328497.84- .OD 328497.84 - ,THER SOURCES OF REVENUE 2$89412.00- .00 2889412.00- 328497.84- ,00 328497.84 - TOTAL REVENUE 2889412 -00- .00 * **** *EXPENDITURES * * * * * ** ENERAL GOVERNMENT ACTIVITIES: .00 .00 ACTIVITY TOTAL .00 .00 .00 .00 USLIC SAFETY: RANSPORTATION: EALTH & WELFARE: JLTURE & LEISURE SERVICES: IMMUNITY DEVELOPMENT: 4PITAL IMPROVEMENT PROJECTS: 2540.44 2.5 97459.56 12$23.75 12$23.75 GENERAL CIP PROJECTS 100000.00 19000.00 ^00 .00 .DO COMMUNITY IMPROVEMENTS 19000.00 .00 239460.00 .00 ^00 ,00 PARKS 239460.00 2515167.00 .00 1740.00 .1 2513427 -00 449732.20 39407.08 8.8 410325.12 STREET CONSTRUCTION /IMPROVMT 2869346.56 462555.95 39407.08 8.5 423148.87 ACTIVITY TOTAL 2873627.00 4260.44 .1 IDA 2873627.00 4280.44 .1 2869346.56 462555.95 39407.08 8.5 423148 ^87 L EXPENDITURES 15785.00- 4280.44 27.1- 20065.44- 134058.11 39407.08 29.4 94651.03 ;CESS[REVENUE�EXPENDITURE 1682.54 .00 1662.54 2ANSFERS OUT TO OTHER FUNDS .00 DO .00 ;LESS [REVENUES EXPENDITURE 1578 5.00- 4280.44 27.1- 20065.44- 135740.65 39407.08 29.0 96333.57 � 40 ril GL104C 9/25/97 **** * ** *REVENUES * * * * * ** SPECIAL BENEFITS ASSESSMENTS JSES OF MONEY AND PROPERTY TOTAL REVENUE -******EXPENDITURES******* 3ENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL 'UBLIC SAFETY: "RANSPORTATION: :EALTH & WELFARE: :ULTURE & LEISURE SERVICES: OMMUNITY DEVELOPMENT: APITAL IMPROVEMENT PROJECTS: OTAL EXPENDITURES _XCESS(REVENUE)EXPENDITURE XCESS (REVENUE) EXPENDITURE THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 REVENUES VERSUS EXPENDITURE 16.00.10 FOR THE PERIOD 7/97 THROUGH 8/97 TRUST /AGENCY FUND CURRENT PERIOD_ PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE .00 .00 .00 1145.66- .00 1145.66- .00 156154.75 .00 156154.75 .00 156154.75 .00 155009.09 .00 155009.09 FISCAL YR Y -T-D .00 236036.28- .00 236036.28- 1145.66 11962.96- 538.94- 4.5 11424.02- 1145.66 247999.24- 538.94- .2 247460.30- 156154.75- 232469.50 153314.75 66.0 79154.75 156154.75 - 232469.50 153314.75 66.0 79154.75 156154.75- 232469.50 153314.75 66.0 79154.75 155009.09- 15529.74- 152775.81 983.8- 168305.55- 155009.09- 15529.74- 152775.81 983.8- 168305.55 - GL104C 9/25/97 9 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/97 THRDUGH 8/97 INTERNAL SERVICE FUND PAGE 1 15.29.08 • CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D * * * *"* *REVENUES * * * * * ** 13750.D0- 1$137.65- .DO 1$137.65 - USES OF MONEY AND PROPERTY 13750.00- 243411.00- .00 40619.16- 16.7 202791.84- 211049.81- 30062.96- 14.2 180986.85 - CHARGES FOR SERVICES 500.00- 21901.75- 1072.70- 4.9 20829.05 - OTHER SOURCES OF REVENUE 500.00- .00 40619.16- 15.8 217041.84- 251089.21- 31135.66- 12.4 219953.55- TOTAL REVENUE 257661.00- * *** ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: 266250.00 15998.08 6.0 250251.92 63251.45 11762.54 18.6 51488.91 NON- DEPARTMENTAL 266250.00 15998.08 6.0 250251.92 63251.45 11762.54 18.6 51488.91 ACTIVITY TOTAL PUBLIC SAFETY. TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: 266250.DD 15998.08 6.0 250251.92 63251.45 11762.54 18.6 51488.91 T p T A L EXPENDITURES 8589.00 24621.08- 286.7- 33210.0$ 187837.76- 19373.12- 10.3 168464.64 - EXCESS[REVENUE>EXPENDITURE 0 S [ REVENUE> EXPENDITURE 8589.00 24621.08- 286.7- 33210.08 187837.76- 19373.12- 10.3 168464.64- • GL104C THE CITY OF DUBLIN STATEMENT SHOWING 9/25/97 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/97 THROUGH 8/97 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE PAGE 1 I 15.40.37 0 PREVIOUS TEAR ENDING JUNE 30, 1997 ACTUAL ACTUAL PERCENT - VARIANCE FISCAL YR Y -T -D •** * * ** *REVENUES * * * * * ** JSES OF MONEY AND PROPERTY 1708264.00- 361803.92- 21.2 1346460.08- 1592321.83- 381827.48- 24.0 1210494.35 - TOTAL REVENUE 1708264.00- 361803.92- 21.2 1346460.08- 1592321.83- 381827.48- 24.0 1210494.35- * * * ** *EXPENDITURES * * * * * ** 3ENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 1599939.00 ADMIN SERVICES 4260.00 ACTIVITY TOTAL 1604199.00 ,UBLIC SAFETY: 'RANSPORTATION: EALTH $ WELFARE: ULTURE & LEISURE SERVICES: OMMUNITY DEVELOPMENT: APITAL IMPROVEMENT PROJECTS: 69115.73 4.3 1530873.27 1314726.23' 71609.88 5.4 1243116.35 1050.00 24.6 3210.00 4194.20 1000.00 23.8 3194.20 70165.73 4.4 1534033.27 1318920.43 72609.88 5.5 1246310.55 0 T A L EXPENDITURES 1604199.00 70165.73 4.4 1534033.27 1318920.43 72609.88 5.5 1246310.55 I XCESSIREVENUE>EXPENDITURES 104065.00- 291638.19- 280.2 187573.19 273401.40- 309217.60- 113.1 35816.20 RANSFERS IN FROM OTHER FUNDS .00 .00 .00 4211.16- .00 4211.16- XCESS [ REVENUE> EXPENDITURE 104065.00- 291638.19- 280.2 187573.19 277612.56- 309217.60- 111.4 31605.04 101 pl,