The URL can be used to link to this page

Home My WebLink About4.02 PrelimFinRpt 9-97CITY CLERK File # 0531[01-a[d 0 AGENDA STATEMENT CITY COUNCIL MEETING DATE: (November 4, 1997) SUBJECT: Preliminary Financial Report For the Month of September 1997 (Report Prepared by: Paul S. Rankin, Assistant City Manager EXHIBITS ATTACHED: Pro Forma Balance Sheet and Income Statements for the Period Ending September 30, 1997 RECOMMENDATION: I VV 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 September. 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. Preiiminary RenortinLy of Information The auditors recently 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. Analysis of Preliminary September 1997 Revenue and Expenditure Report The September report represents the reporting of revenues and expenditures for the first quarter of the Fiscal Year. The significance of first quarter expenditure results must be viewed with the understanding of the amount of services the City receives from contract service providers. This contract arrangement often creates a lag between when the City receives the services and when the expenditure is recorded. In addition, 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. ---------------------------------------------------------------- COPIES TO: G:\M0NrHFS\FY98 \0997AG.D0C ITEM NO. 4*2 General Fund Revenues Total General Fund Revenues collected through September are comparable to what occurred in the ihird month of the previous Fiscal Year. The City had collected through September 1997 approximately .18% of the total budgeted General Fund Revenues, slightly higher -than the 15% of Revenues collected during 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 autos. Real Property Transfer Taxes have increased over the same period in the prior year due to 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 collection of these taxes. The City is now collecting these taxes on a monthly basis instead of quarterly. Licenses and Permits are higher than in the same period in the prior year, due to the issuance of several building permits and building plan check fees for several projects in the Eastern Dublin. The "Other Revenues" category is 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 Expenditures Overall, through the month of September expenditures in the General Fund totaled $2,867,112 and represented approximately 16% of the total budgeted expenditures in the General Fund. Of this amount, a total of $14,216 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 from year to year. 0 In looking at only General Fund Operating Expenditures, the activity through September 1997 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of September 30, 1997, the City had expended 17% of the General Fund Operating Budget compared to 16% 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. 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 slightly higher than the same period in the prior year due to higher payments for contract recreation instructors resulting from a large increase in enrollment for acting recreation classes, and for annual cable services for Channel 30. 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. • _9_ • • i City of Dublin 1997 -98 YTD Revenues and Budget Comparison For the Period Ending September 30, 1997- Unaudited Total General Fund 180 Revenues 15% 1 FY 96197 8% Budget YTD Actual Budget YTD Actual Property Taxes 8% Property Taxes 4,407,700 350,638 8% Sales Taxes l21 Yo 6,850,000 1,440,243 21% ■ FY 97/98 18% Transient Occupancy Taxes 231,000 59,354 26% 0 ® FY 96/97 Transient 750,500 6% 8% 57,040 8% Licenses and Permits 1,043,350 Occupancy Taxes 0% 211,987 19% Interest and Rentals 1,328,450 231,525 17% 8% 7% Intergovernmental 1,171,620 282,073 24% Franchise Taxes 8% Charges for Services 1,631,918 275,562 17% 251,140 Licenses and Other Revenues 30% 142,074 29% 74,899 28% Total General Fund Revenues Permits 19 0 2,536,085 15% 10/27/97 15:57 Interest and Rentals 17 ° . 7% g:vnonthfsVy98Vs.x1s Intergovernmental 21% from State 23% 0 Charges for Services 18° 29% Other Revenues 28% I 30% 60% 90% 120% 150% 0% 25% of Year Complete FY 97198 FY 97198 % of FY 96197 % of Total for Budget YTD Actual Budget YTD Actual FY 96/97 Property Taxes 4,407,700 350,638 8% 320,615 8% Sales Taxes 6,850,000 1,440,243 21% 1,262,273 18% Transient Occupancy Taxes 231,000 59,354 26% 0 0% Franchise Taxes 750,500 63,306 8% 57,040 8% Licenses and Permits 1,043,350 310,895 30% 211,987 19% Interest and Rentals 1,328,450 231,525 17% 92,061 7% Intergovernmental 1,171,620 282,073 24% 266,070 23% Charges for Services 1,631,918 275,562 17% 251,140 18% Other Revenues 488,719 142,074 29% 74,899 28% Total General Fund Revenues 17,903,257 3,155,670 18% 2,536,085 15% 10/27/97 15:57 g:vnonthfsVy98Vs.x1s FY 97198 FY 97/98 % of FY 96/97 % of Total for Budget YTD Actual Budget YTD Actual FY 96/97 General Government 1,783,878 371,801 21% 348,971 Civic Center Lease 1,599,919 361,627 23% 376,881 Police 4,282,674 62,742 1% 65,743 Fire : 3,598,953 1,186,589 33% 691,884 Other Public Safety 276,880 151 0% 7,135 Transportation 667,372 94,799 14% 108,210 Health and Welfare 17,320 0 0% 0 Culture and Community Services 2,119,950 415,640 20% 359,231 Community Development 2,266,885 359,547 16% 299,178 Capital Improvement Projects 1,155,551 14,216 1% 222,627 Total General Fund Expenses 17,769,382 2,867,112 16% 2,479,860 General Fund Operating Expenses 16,613,831 2,852,896 17% 2,257,233 10127/97 16:18 21% 25% 2% 25% 4% 17% 0% 18% 16% 22% 16%10 16% gAmonthfsW981f As 3 • • CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF SEPTEMBER 1997 Prepared by The Finance Department October 24, 1997 •♦i11"Mm y GL102 10/24/97 ASSETS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/97 THROUGH 9/97 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY FUNDS FUNDS FUNDS FUNDS FUND CASH 5037349.09- 1738465.24 248339.37 2576252.11 17737.79 CASH WITH FISCAL AGENT 138124.10 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 29135321.17 RECEIVABLES:TAXES ACCOUNTS (NET) 179704.41. 32978.54 INTEREST 175681.50 ASSESSMENTS RENTS NOTES DUE FROM OTHERS 371966.14 92825.76 INVENTORY AT COST PREPAID ITEMS 5586.44 FIXED ASSETS AMOUNTS TO BE PROVIDED 2018500.00 TOTAL ASSETS 24830910.57 1864269.54 248339.37 2576252.11 2174361.89 LIAR, FND SAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 436695.42 - DEPOSITS FOR A31600 FEES 2596595.87 - DEPOSITS OTHERS 494331.14- 3547.89- 289271.92 - "AYABLES:A000UNTS 354225.80- 41888.44- 628.35 INTEREST PAYROLL 11201.76 - )UE TO OTHERS 11101.33- 79259.00 - )EST INSTRUMENTS PAYABLE 2136000.00 - TOTAL LIABILTIES 1307555.45- 124695.33- 2885239.44- 2136000.00 - =UND BALANCES 23523355.12- 1739574.21- 248339.37- 308987.33 38361.89 - TOTAL FUND EQUITY 23523355.12- 1739574.21- 248339.37- 308987.33 38361.89 - OTAL LIAB,FND SAL, RETD EARNS 24830910.57- 1864269.54- 248339.37- 2576252.11- 2174361.89- PACE 1 I 11.40.50 T O T A L S� - -- MEMORANDUM ONLY -- CURRENT JUNE 30, 1997 456554.58- 488831.62 138124.10 130995.55 29135321.17 23678006.89 212682.95 331718.78 175681.50 47163.90 464791.90 27563.44 5586.44 5718.37 2018500.00 2090500.00 31694133.48 26800498.55 436695.42- 239899 2596595.87- 525081.38- 787150.95- 537126.40- 395485.89- 526515.60- 11201.76- 37475.46- 90360.33- 310.00- 2136000.00- 2208000.00- 6453490.22- 4074408.68- 25240643.26- 22726089.87- 25240643.26- 22726089.87- 31694133.48- 26800498.55- 01 1 GL 102 10/24/97 0 ASSETS :ASH ;ASH WITH FISCAL AGENT JNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 2ECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES )UE FROM OTHERS INVENTORY AT COST 'REPAID ITEMS =IXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS IXB, FND SAL, RETND EARNINGS )EPOSITS FOR PRIVATE DEVELPMNT )EPOSITS OTHERS 'AYABLES:A000UNTS INTEREST PAYROLL )UE TO OTHERS EST INSTRUMENTS PAYABLE TOTAL LIABILITIES -UND BALANCE :ONTRIBUTIONS NVESTMENTS IN FIXED ASSETS ETAINED EARNINGS TOTAL FUND EQUITY OTAL LIAB,FND SAL, RETD EARNS • CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/97 THROUGH 9/97 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUNDS GROUP OF TERM DEBT FUND ACCOUNTS ACCOUNT GROUP 422288.78 1050.00- 1670377.98 46896.00 548797.76 19616208.27 545355.56 5640810.06 971086.54 21332432.25 545355.56 5640810.06 15535000.35 - 15535000.35- 581916.85- 687541.90- 389169.69- 5109890.00- 971086.54- 5797431.90- 971086.54- 21332432.25- 5640810.06 - 5640810.06- 545355.56 - 545355.56- 545355.56- 5640810.06- PAGE 1 11.41.16 T. 0 T A L S - -- MEMORANDUM ONLY --- CURRENT JUNE 30, 1997 421238.78 304484.02 1670377.98 1719334.71 46896.00 20710361.59 21045462.27 5640810.06 5327970.26 28489684.41 28397251.26 21175810.41- 21592970.26- 21175810.41- 21592970.26- 1269458.75- 834114.42- 5499059.69- 5459961.45- 545355.56- 510205.13- 7313874.00- 6804281.00- 28489684.41- 28397251.26- Co GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 10/24197 REVENUES VERSUS EXPENDITURE 10.07.24 FOR THE - PERIOD 7/97 THROUGH 9/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 * * * * * ** *REVENUES * * * * * ** PROPERTY TAXES 4286000.00- 321462.53- 7.5 3964537.47- 3920897.29- 300973.70- 7.7 3619923.59 - SALES TAX 6850000.00- 1440242.76- 21.0 5409757.24- 7108598.19- 1262272.58- 17.8 5846325.6' REAL PROPERTY TRANSFERS 121700.00- 29174.54- 24.0 92525.46- 138062.47- 19641.17- 14.2 118421.3:`; TRANSIENT OCCUPANCY TAX 231000.00- 59354.00- 25.7 171646.00- 267007.09- .00 267007.09- FRANCHISE TAXES 750500.00- 62305.96- 8.3 688194.04- 723384.60- 57040.12- 7.9 666344.45 - LICENSES & PERMITS 1043350.00- 310894.77- 29.8 732455.23- ''1092182.95- 211987.18- 19.4 880195.77 - FINES & FORFEITURES 33200.00- 11148.93- .33.6 22051.07- 38492.21 - 7579.46- 19.7 30912.75 - USES OF MONEY AND PROPERTY 1328450.00- 231525.32- 17.4 1096924.68- 1388948.66- 92060.54- 6.6 1296888.12 - INTERGOVERNMENTAL FROM STATE 1171620.00- 282073.44- 24.1 889546.56- 1151275.49- 266069.67- 23.1 885205.82 - CHARGES FOR SERVICES 1631918.00- 275562.48- 16.9 1356355.52- 1386418.59- 251139.75- 18.1 1135278.84 - OTHER SOURCES OF REVENUE 457519.25- 130924.67- 28.6 326594.58- 223207.32- 67320.05- 30.2 155887.27 - TOTAL REVENUE 17905257.25- 3154669.40- 17.6 14750587.85- 17438474.86- 2536084.22- 14.5 14902390.64- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON- DEPARTMENTAL 24064.00 187.40 .8 23876.60 27346.97 26.00- .1- 27372.97 CITY COUNCIL 1010 137334.00 22435.59 16.3 114898.41 127472.84 27499.00 21.6 99973.84 CITY MANAGER 1020 334487.00 68288.26 20.4 266198.74 291093.65 66144.15 22.7 224949.50 CITY ATTORNEY 1030 186794.00 14102.57 7.5 172691.43 201718.85 16582.38 8.2 185136.47 ADMIN SERVICES 1040 637675.00 135192.37 21.2 502482.63 569247.12 120602.90 21.2 44864 BUILDING MANAGEMENT 1050 315955.00 41963.42 13.3 273991.58 331517.40 37462.90 11.3 294054 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 89631.15 61.1 57171.85 122777.83 80632.48 65.7 42145.35 ELECTIONS COST CENTER 1070 766.00 .00 766.00 20511.92 74.12 .4 20437.80 ACTIVITY TOTAL 3383797.DO 733427.62 21.7 2650369.38 3188502.99 725852.48 22.8 2462650.51 PUBLIC SAFETY: POLICE 2010 4282674.00 62741.87 1.5 4219932.13 3794625.12 65743.49 1.7 3728881.63 CROSSING GUARDS COST 2020 42726.00 .00 42726.00 40926.26 .00 40926.26 ANIMAL CONTROL 2030 200124.00 .00 200124.00 110514.00 .00 110514.00 DISASTER PREAPREDNESS 2050 34030.00 150.65 .4 33879.35 25992.10 7134.89 27.5 18857.21 FIRE SERVICES 2060 3598953.00 1186589.14 33.0 2412363.86 2751796.45 691884.02 25.1 2059912.43 ACTIVITY TOTAL 8158507.00 1249481.66 15.3 6909025.34 6723853.93 764762.40 11.4 5959091.53 TRANSPORTATION: PUBLIC WORKS 3010 366732.00 65872.95 18.0 300859.05 319005.00 64714.83 20.3 254290.17 STREET MAINTENANCE 3020 55770.00 2736.72 4.9 53033.28 31593.44 20927.29 66.2 10666.15 STREET TREE MAINTENANCE 3040 47700.00 2044.04 4.3 45655.96 48375.71 1492.22 3.1 46883.49 STREET LANDSCAPE MAINT. 3050 197170.00 24145.61 12.2 173024.39 230289.60 21075.21 9.2 209214.39 ACTIVITY TOTAL 667372.00 94799.32 14.2 572572.68 629263.75 108209.55 17.2 521054.20 iEALTH & 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 2500.00 HERITAGE CENTER 8012 55930.00 10973.71 19.6 44956.29 54291.08 8124.89 15.0 46166.19 DUBLIN CEMETERY 8013 16690.00 863.48 5.2 15826.52 15749.25 956.91 6.1 14792 10 GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2 10/24/97 REVENUES VERSUS EXPENDITURE 10.07.24 FOR THE PERIOD 7/97 THROUGH 9/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 54146.33 9.2 535308.67 594119.19 46021.49 7.7 548097.70 COMMUNITY CABLE TV 8030 37051.00 24414.00 65.9 12637.00 34256.72 22211.72 64.8 12045.00 RECREATION ADMIN. 8040 256353.00 57106.67 22.3 199246.33 234707.54 48513.64 20.7 186193.90 PLAYGROUNDS 8045 128003.00 36280.37 28.3 91722.63 108257.69 34362.03 31.7 73895.66 SHANNON CENTER 8050 148006.00 26853.33 18.1 121152.67 136660.43 23580.79 17.3 113079.64 PRESCHOOL 8055 54333.00 11564.76 21.3 42768.24 51629.57 11272.90 21.8 40356.67 TEENS PROGRAM 8060. 35296.00 3541.10 10.0 31754.90 25445.93 4966.26 19.5 20479.67 ADULT SPORTS 8065 65350.00 15219.89 23.3 50130.11 61034.72 14423.75 23.6 46610.97 YOUTH SPORTS 8066 52406.00 11183.49 21.3 41222.51 39910.77 7632.58 19.1 32278.19 SPECIAL EVENTS 8070 42042.00 9396.75 22.4 32645.25 40133.97 9072.84 22.6 31061.13 SENIOR CENTER 8080 104221.00 21518.99 20.6 82702.01 80392.97 17435.22 21.7 62957.75 RECREATION INSTRUCTION 8D90 88555.00 39574.95 44.7 48980.05 89684.89 20525.93 22.9 69158.96 AQUATICS 8100 219265.00 83002.46 37.9 136262.54 215910.85 80130.37 37.1 135780.48 ACTIVITY TOTAL 2119950.00 415640.28 19.6 1704309.72 2000559.57 359231.32 18.0 1641328.25 COMMUNITY DEVELOPMENT: PLANNING 9010 744971.00 149727.80 20.1 595243.20 659318.79 153053.98 23.2 506264.81 BUILDING SAFETY 9020 593826.00 57217.03 9.6 536608.97 386171.15 47705.08 12.4 338466.07 ENGINEERING 9030 781875.00 98939.96 12.7 682935.04 684913.30 72438.62 10.6 612474.68 ECONOMIC DEVELOPMENT 9040 146213.00 53662.21 36.7 92550.79 108155.26 25980.08 24.0 82175.18 ACTIVITY TOTAL 2266885.00 359547.00 15.9 1907338.00 1838558.50 299177.76 16.3 1539380.74 IMPROVEMENT PROJECTS: ONAL ERAL CIP PROJECTS 93NN 584850.00 7D40.91 1.2 577809.09 80137.74 1605.45 2.0 78532.29 COMMUNITY IMPROVEMENTS 94NN 66000.00 3870.17 5.9 62129.83 51771.12 17126.77 33.1 34644.35 PARKS 95NN 192140.00 3175.27 1.7 188964.73 497423.22 33078.52 6.6 464344.70 STREET CONSTRC /IMPROVMT 96NN 312561.00 129.28 312431.72 403724.50 170815.94 42.3 232908.56 ACTIVITY TOTAL 1155551.00 14215.63 1.2 1141335.37 1033056.58 222626.68 21.6 810429.90 T 0 T A L EXPENDITURES 17769382.00 2867111.51 16.1 14902270.49 15429391.19 2479860.19 16.1 12949531.00 EXCESS <REVENUc> EXPENDITURES 135875.25- 287557.89- 211.6 151682.64 2009083.67- 56224.03- 2.8 1952859.64 - TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 5077.54- .00 5077.54 - TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 4211.16 .00 4211.16 EXCESS < REVENUE> EXPENDITURE 135875.25- 287557.89- 211.6 151682.64 2009950.05- 56224.03- 2.8 1953726.02- • • GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 10/24/97 REVENUES VERSUS EXPENDITURE 10.18.38 FOR THE PERIOD 7/97 THROUGH 9/97 REVENUE FUNDS SPECIAL CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T -D * * * * * ** *REVENUES * * * * * ** PROPERTY TAXES 71500.00- .00 71500.00- .00 .00 .00 SALES TAX 159300.00- 24445.19- 15.3 134854.81- 152122.48- 22462.91- 14.8 129659.57 - FINES & FORFEITURES 25000.00- 6562.42- 26.2 18437.58- 22506.62- 3879.99- 17.2 18626.63 - USES OF MONEY AND PROPERTY 78560.00- .00 78560.00- 98044.39- .00 98D44.39- INTERNGOVERNMENTAL FROM STATE 740859.00- 206277.33- 27.8 534581.67- 611716.48 - 88655.79- 14.5 523060.69 - INTERGOVERNMENTAL FROM COUNTY 141460.00- 26511.00- 18.7 114949.00- 143136.00- 27739.00- 19.4 115397.00 - INTERGOVERNMENTAL FROM FEDERAL 464889.00- .00 464889.00- 185082.30- .00 185082.30 - CHARGES FOR SERVICES 739000.00- .00 739000.00- 788267.59- .00 788267.59 - OTHER SOURCES OF REVENUE 218000.00- .00 218000.00- 311205.00- 11394.00- 3.7 299811.00 - TOTAL REVENUE 2638568.00- 263795.94- 10.0 2374772.06- 2312080.86- 154131.69- 6.7 2157949.17- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .DO .00 .00 PUBLIC SAFETY: POLICE 93845.00 471.05 .5 93373.95 63146.44 .00 63146.44 TRAFFIC SIGNALS 108150.00 9152.86 8.5 98997.14 78617.71 6501.30 8.3 72116.41 FIRE SERVICES 75960.00 2875.00 3.8 73085.00 .00 .00 .00 ACTIVITY TOTAL 277955.00 12498.91 4.5 265456.09 141764.15 6501.30 4.6 135262 TRANSPORTATION: PUBLIC WORKS .00 .00 .00 172.47 .00 172. STREET MAINTENANCE 208910.00 26470.28 12.7 182439.72 213347.82 5445.09 2.6 207902.73 STREET SWEEPING 80600.00 5870.76 7.3 74729.24 67675.22 6173.47 9.1 61501.75 ACTIVITY TOTAL 289510.00 32341.04 11.2 257168.96 281195.51 11618.56 4.1 269576.95 EALTH & WELFARE: WASTE MANAGEMENT 808166.00 1205.52 .1 806960.48 718827.72 19771.09 2.8 699056.63 ACTIVITY TOTAL 808166.00 1205.52 .1 806960.48 718827.72 19771.09 2.8 699056.63 :ULTURE &.LEISURE SERVICES: PARK MAINTENANCE .00 .00 .00 7154.10 .00 7154.10 ACTIVITY TOTAL .00 .00 .00 7191.46 .00 7191.46 ;DMMUNITY DEVELOPMENT: ENGINEERING 88120.00 3771.26 4.3 84348.74 88980.07 8590.26 9.7 80389.81 ACTIVITY TOTAL 88120.00 3771.26 4.3 84348.74 88980.07 8590.26 9.7 80389.81 -APITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 250983.00 7103.29 2.8 243879.71 140454.07 .00 140454.07 PARKS 219102.23 29124.64 13.3 189977.59 443937.09 .00 443937.09 STREET CONSTRUCTION /IMPROVMT 766610.00 4365.74 .6 762244.26 353418.05 190714.54 54.0 162703.51 ACTIVITY TOTAL 1236695.23 40593.67 3.3 1196101.56 937809.21 190714.54 20.3 747094.67 0 T A L EXPENDITURES 2707491.23 90410.40 3.3 2617080.83 2175768.12 237195.75 10.9 1938572.37 :XCESS <REVENUE >EXPENDITURE 68923.23 173385.54- 251.6- 242308.77 136312.74- 83064.06 60.9- 219376.80 - 'RANSFERS OUT TO OTHER FUNDS .00 .00 .00 3395.00 .00 3395.00 :XCESS < REVENUE> EXPENDITURE 68923.23 173385.54- 251.6- 242308.77 132917.74- 83064.06 62.5- 215981.80- • 9' GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 10/24/97 REVENUES VERSUS EXPENDITURE 10.28.21 FOR THE ' PERIOD 7/97 THROUGH 9/97 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T-D * * * * * ** *REVENUES * * * * * ** SPECIAL BENEFITS ASSESSMENTS 274407.00- .00 274407.00- 243986.94= .00 243986,94 - USES OF MONEY AND PROPERTY 13395.00- .00 13395.00- 18795.26- 1672.49- 8.9 17122.77 - OTHER SOURCES OF REVENUE 2000.00- .00 2000.00- .00 .00 .00 TOTAL REVENUE 289802.00- .00 289802.00- 262782.20- 1672.49- .6 261109.71- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRFC SIGS /STREET LIGHTING 121705.00 T206.99 5.9 114498.01 103293.98 11480.79 11.1 91813.19 ACTIVITY TOTAL 121705.00 7206.99 5.9 114498.01 103293.98 11480.79 11.1 91813.19 TRANSPORTATION: PUBLIC WORKS 1300.00 696.97 53.6 603.03 4247.66 695.56 16.4 3552.10 STREET TREE MAINTENANCE 11410.00 164.40 1.4 11245.60 5697.32 64.98 1.1 5632.34 STREET LANDSCAPE MAINTENANCE 139420.00 14991.15 10.8 124428.85 138868.81 18243.71 13.1 120625.10 ACTIVITY TOTAL 152130.00 15852.52 10.4 136277.48 148813.79 19004.25 12.8 129809.54 HEALTH & WELFARE: C URE C URE & LEISURE SERVICES: ITY DEVELOPMENT: 4650.00 3465.00 74,5 1185.00 3185.96 3023.44 94.9 162.52 ACTIVITY TOTAL 4650.00 3465.00 74,5 1185.00 3185.96 3023.44 94.9 162.52 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 24000.00 .00 24000.00 16488.87 .00 16488.87 STREET CONSTRUCTION /IMPROVMT 45000.00 .00 45000.00 103000.00 103048.50 100.0 48.50 - ACTIVITY TOTAL 69000.00 .00 69000.00 119488.87 103048.50 86.2 16440.37 T 0 T A L EXPENDITURES 347485.00 26524.51 7.6 320960.49 374782.60 136556.98 - 36.4 238225.62 =XCESS<REVENUE> EXPENDITURE 57683.00 26524.51 46.0 31158.49 112000.40 134884.49 120.4 22884.09 - EXCESS < REVENUE> EXPENDITURE 57683.00 26524,51 46.0 31158.49 112000.40 134884.49 120.4 22884.09- /o GL104C 10/24/97 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 REVENUES VERSUS EXPENDITURE 10.48.41 FOR THE ' PERIOD 7/97 THROUGH 9/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 * * * * * * * *REVENU- S * * * * * ** OTHER SOURCES OF REVENUE 2889412.00- .00 2889412.00- 328497.84- 70429.55- 21.4 258068.29 - TOTAL REVENUE 2889412.00- .00 2889412.00- 328497.84- 70429.55- 21.4 258068.29- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 100000.00 2540.44 2.5 97459.56 12823.75 .00 12823.75 COMMUNITY IMPROVEMENTS 19000.00 .00 19000.00 .00 .00 .00 PARKS 239460.00 .00 239460.00 .00 .00 .00 STREET CONSTRUCTION /IMPROVMT 2515167.00 1740.00 .1 2513427.00 449732.20 84644.75 18.8 365087.45 ACTIVITY TOTAL 2873627.00 4280.44 .1 2869346.56 462555.95 84644.75 18.3 377911.20 T 0 T A L EXPENDITURES 2873627.00 4280.44 .1 2869346.56 462555.95 84644.75 18.3 37791 EXCESS <REVENUE >EXPENDITURE 15785.00- 4280.44 27.1- 20065.44- 134058.11 14215.20 10.6 119 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 1682.54 .00 168 . EXCESS < REVENUE> EXPENDITURE 15785.00- 4280.44 27.1- 20065.44- 135740.65 14215.20 10.5 121525.45 Il GL104C 10/24/97 0 * * * * * ** *REVENUES * * * * * ** SPECIAL BENEFITS ASSESSMENTS USES OF MONEY AND PROPERTY TOTAL REVENUE I * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES NON- DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOTAL EXPENDITURES EXCESS(REVENUE)EXPENDITURE 0 S (REVENUE) EXPENDITURE • THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/97 THROUGH 9/97 TRUST /AGENCY FUND PAGE 1 11.06.22 .00 CURRENT PERIOD 156154.75- 232469.50 PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE .00 154417.71 154417.71- FISCAL YR Y-T -D 980.3- 167766.16- .00 .00 .00 236036.28- .00 236036.28- .00 1737.04- 1737.04 11962.96- 1078.33- 9.0 10884.63- .00 1737.04- 1737.04 247999.24- 1078.33- .4 246920.91- .00 156154.75 156154.75- 232469.50 153314.75 . 66.0 79154.75 .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 .00 154417.71 154417.71- 15529.74- 152236.42 980.3- 167766.16- .00 154417.71 154417.71- 15529.74- 152236.42 980.3- 167766.16- 1�2 266250.00 ACTIVITY TOTAL 266250.00 'UBLIC SAFETY: 28.8 -RANSPORTATION: 17862.09- GL104C THE CITY OF DUBLIN STATEMENT SHOWING :OMMUNITY DEVELOPMENT: 157454.33- APITAL IMPROVEMENT PROJECTS: PAGE 1 10/24/97 266250.00 REVENUES VERSUS EXPENDITURE 8589 -00 157454 10.33.46 FOR THE ' PERIOD 7197 THROUGH 9/97 INTERNAL SERVICE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D• " * * * ** *REVENUES * * * * * ** )SES OF MONEY AND PROPERTY 13750.00- .00 13750.00- 18137.65- .00 18137.65 - .HARGES FOR SERVICES 243411.00- 40619.16- 16.7 202791.84- 211049.81- 47508.47- 22.5 163541.34 - )THER SOURCES OF REVENUE 500.00- .00 500.00- 21901.75- 1072.70- 4.9 20829.05 - TOTAL REVENUE 257661.00- 40619.16- 15.8 217041.84- 251089.21- 48581.17- 19.3 202508.04- `* * ** *EXPENDITURES * * * * * ** 3ENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 266250.00 ACTIVITY TOTAL 266250.00 'UBLIC SAFETY: 28.8 -RANSPORTATION: 17862.09- ZALTH & WELFARE: 26451.09 :ULTURE LEISURE SERVICES: 30383.43- :OMMUNITY DEVELOPMENT: 157454.33- APITAL IMPROVEMENT PROJECTS: 208.0- " 0 T A L EXPENDITURES 266250.00 :XCESS <REVENUE>EXPENDITURE 8589 -00 XCESS < REVENUE> EXPENDITURE 8589.00 22757.07 8.5 243492.93 63251.45 18197.74 28.8 45053.71 22757.07 8.5 243492.93 63251.45 18197.74 28.8 45053.71 22757.07 8.5 243492.93 63251.45 18197.74 28.8 45053.71 17862.09- 208.0- 26451.09 187837.76- 30383.43- 16.2 157454.33- 17862.09- 208.0- 26451.09 187837.76- 30383.43- 16.2 157454 • GL104C 10/24/97 is * * * * * ** *REVENUES * * * * * ** USES OF MONEY AND PROPERTY TOTAL REVENUE THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE ' PERIOD 7/97 THROUGH 9/97 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE PAGE 1 10.39.06 PREVIOUS YEAR ENDING JUNE 30, 1997 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y -T -D 1708264.00- 361803.92- 21.2 1346460.08- 1592321.83- 381832.72- 24.0 1210489.11- 1708264.00- 361803.92- 21.2 1346460.08- 1592321.83- 381832.72- 24.0 1210489.11- * * * * ** *EXPENDITURES * * * * * ** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1599939.00 69115.73 4.3 1530823.27 1314726.23 71609.88 5.4 1243116.35 ADMIN SERVICES 4260.00 1050.00 24.6 3210.00 4194.20 1000.00 23.8 3194.20 ACTIVITY TOTAL 1604199.00 70165.73 4.4 1534033.27 1318920.43 72609.88 5.5 1246310.55 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1604199.00 70165.73 4.4 1534033.27 1318920.43 72609.88 5.5 1246310.55 EXCESS <REVENUE>EXPENDITURES 104065.00- 291638.19- 280.2 187573.19 273401.40- 309222.84- 113.1 35821.44 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 4211.16- .00 4211.16 - I&S < REVENUE> EXPENDITURE 104065.00- 291638.19- 280.2 187573.19 277612.56- 309222.84- 111.4 31610.28