Loading...
HomeMy WebLinkAboutItem 4.08 PrelimFinRpt 10-97 (2) . . . CITY CLERK File # rTIll3l[Q]-3J[QJ AGENDA STATEMENT CITY COUNCIL MEETING DATE: (December 2,1997) SUBJECT: Preliminary Financial Report For the Month of October 1997 @lL'ReportPrepared by: Paul S. Rankin, Assistant City Manager EXIDBITS ATTACHED: 1. Chart - General Fund Revenues and Budget Comparison 2. Chart - General Fund Expenses and Budg~~ Comparison 3. Balance Sheet and Income Statements for the P~riod Ending October 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 monthly financial statements for the month of October. The previous monthly report for September was presented as "pro forma" since the final audited results of Fiscal Year 1996/97 were not 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. Analysis of October 1997 Revenue and Expenditure Report The October report represents the reporting of revenues and expenditures for the four months of the Fiscal Year. Major property tax revenues will not be received until December. In the expenditure category, the October report does not include expenses for the first quarter of contract Police Services, which will be paid in November. A more detailed analysis of General Fund Revenue and Expenditures is shown on the attached graphs and discussed below. General Fund Revenues The City had collected through October 1997 approximately 25% of the total budgeted General Fund Revenues, which is slightly higher than the 20% 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. However, it should be noted that a major portion of the sales tax is a result of the Christmas retail season, for which the City will not receive data until March of 1998. Real Property Transfer Taxes have increased over the same period in the prior year due to an increase in assessed value and sales activity primarily for residential units within the City. In addition, the initial sale of large parcels in Eastern Dublin results in an increased amount of Transfer Taxes. ------------------------c()pllfsl'():-------------------------------- 4.8 G:\M0l'\THFS\FY98\1097 AG.DOC ITEM NO. Transient Occupancy Taxes are higher than in the same period due to timing differences in the collection ' of these taxes. In the previous year the City received a late tax payment for the period covered by this report. 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. . Interest and Rentals are higher than in the same period in the prior year due to a higher cash balance. Initially all interest revenue is recorded in the General Fund and allocated to other funds on a pro rata basis at year end. 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 October expenditures in the General Fund totaled $3,586,613 and represented approximately 20% of the total budgeted expenditures in the General Fund. Of this amount, a total of $43,944 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. In looking at only General Fund Operating Expenditures, the activity through October 1997 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of October 30, 1997, the City had expended 21 % of the General Fund Operating Budget, the same percentage as in the. prior Fiscal Year. As previously noted there are some timing differences with payment for contract 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 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 timing differences in the payment of Library Services for the first quarter. 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 and Dougherty Hill Slope Repair 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. . Exhibit 2 . Total General Fund Revenues City of Dublin 1997-98 YTD Revenues and Budget Comparison For the Period Ending October 31, 1997- Unaudited ~% 20r . FY 97/98 III FY 96/97 Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits 49 0 Interest and Rentals . Intergovernmental from State Charges for Services 33% Other Revenues 0% 30% 60% 90% 120% 33% of Year Complete 150% FY 97/98 FY 97/98 % of FY 96/97 % of Total for Budget YTO Actual Budget YTO Actual FY 96/97 Property Taxes 4,407,700 413,418 9% 365,188 9% Sales Taxes 6,850,000 1,947,443 28% 1,734,373 24% Transient Occupancy Taxes 231,000 84,134 36% 14,020 5% Franchise Taxes 750,500 94,213 13% 85,975 12% Licenses and Permits 1,043,350 507,846 49% 327,358 30% Interest and Rentals 1,328,450 408,976 31% 242,437 17% . Intergovernmental 1,171,620 357,476 31% 354,028 31% Charges for Services 1,631,918 436,205 27% 353,784 26% Other Revenues 491,019 160,447 33% 84,352 31% Total General Fund Revenues 17,905,557 4,410,158 25% 3,561,515 20% 11/26/9710:42 g:\monthfs\fy9B\fs.xls Exhibit 2 City of Dublin 1997-98 YTD Expenses and Budget Comparison For the Period Ending October 31, 1997 - Unaudited Total General Fund Expenses General Government Civic Center Lease Police Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects - -- - ------ ---~--~ - - -- -- - ~ - - 20% 22% Fire " .FY 97/98 II FY 96/97 33% 33% 34% 0% 30% 60% 33% of Year Complete 90% 120% FY 97/98 FY 97/98 % of FY 96/97 % of Total for Budget YTO Actual Budget YTO Actual FY 96/97 General Government 1,783,878 520,174 29% 472,727 28% Civic Center Lease 1,599,919 361,627 23% 376,881 25% Police 4,282,674 133,666 3% 106,395 3% Fire 3,598,953 1,187,791 33% 921,418 33% Other Public Safety 276,880 5,454 2% 11,385 6% Transportation 667,372 148,268 22% 154,698 25% Health and Welfare 17,320 0 0% 0 0% Culture and Community Services 2,120,250 598,640 28% 473,134 24% Community Oevelopment 2,266,885 587,049 26% 479,150 26% Capital Improvement Projects 1,155,551 43,944 4% 352,509 34% . Total General Fund Expenses 17,769,682 3,586,613 20% 3,348,297 22% General Fund Operating Expenses 16,614,131 3,542,669 21% 2,995,788 21% 11/26/97 10:41 ll:\monlhfs\fy9B\fs.xls . CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF OCTOBER 1997 . Prepared by The Finance Department November 25, 1997 . EXHIBIT 3 GL102 CITY OF DUBLIN PAGE 1 "/25/97 BALANCE SHEET 12.59.38 FOR THE PERIOD 7197 THROOGH 10/97 GENERAL SPECIAL SPECIAL CAPITAL TRUSTI TOT A L ~ REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONLY-- FUNDS FUND S FUNDS FUNDS FUND CURRENT JUNE 30, 1997 ASSETS CASH 4330506.09- 1749910.42 231462.44 3080725.86 1 m7. 79 749330.42 163010.41- CASH YITH FISCAL AGENT 138124.10 138124.10 131518.06 UNAMORTIZED BOND DISCOONT INVESTMENTS AT COST 29085321.17 :.29085321.17 24935252.67 RECEIVABLES: TAXES ACCOONTS (NET) 179704.41 11412.56 191116.97 306200.31 INTEREST 175681.50 175681.50 29076.90 ASSESSMENTS RENTS NOTES DUE FROM OTHERS 371966.14 85226.76 457192.90 27563.44 INVENTORY AT COST PREPAID ITEMS 3284 . 69 3284.69 8422.66 FIXED ASSETS AMOONTS TO BE PROVIDED 2018500.00 2018500.00 2090500.00 TOTAL ASSETS 25485451.82 1846549.74 231462.44 3080725.86 2174361.89 32818551.75 27365523.63 LIAB, FND BAL, RETND EARNINGS 43634. DEPOSITS FOR PRIVATE DEVELPMNT 523066.59- 523066.59- DEPOSITS FOR AB1600 FEES 3134321.04- 3134321.04- 682995.22- DEPOSITS OTHERS 534671.14- 3547.89- 289271.92- 827490.95- 566526.40- PAYABLES:ACCOONTS 354225.80- 628.34- 628.35 354225.79- 525864.22- INTEREST PAYROLL 3901.69- 3901.69- 32895.52- DUE TO OTHERS 10245.80- 79259.00- 89504.80- 13002.00- DEBT INSTRUMENTS PAYABLE 2136000.00- 2136000.00 - 2208000.00- TOTAL LIABILTIES 1426111.02- 83435.23- 3422964.61- 2136000.00- 7068510.86- 4465625.13- FUND BALANCES 24059340.80- 1763114.51- 231462.44- 342238.75 38361.89- 25750040.89- 22899898.50- TOTAL FUND EQUITY 24059340.80- 1763114.51- 231462.44- 342238.75 38361.89- 25750040.89- 22899898.50- TOTAL LIAS,FND BAL, RETD EARNS 25485451.82- 1846549.74- 231462.44- 3080725.86- 2174361.89- 32818551.75- 27365523.63- . GL102 11/25197 crn OF DUBUH BALANCE SHEET FOR THE PERIOD 7197 THROUGH 10/97. . IHTERHAL SERVICE FUND ASSETS CASH CASH ~ITH FISCAL AGEHT UNAMORTIZED BOND DISCOUHT 448666.18 IHVESTMEHTS AT COST RECEIVABLES: TAXES ACCOUNTS (NET) INTEREST ASSESSMEHTS REHTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIDED 350034.76 TOTAL ASSETS .' FND BAL, RETND EARNINGS OSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:ACCOUNTS INTEREST PA YROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANC: CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS ~ETAINED EARNINGS TOTAL FUND EQUITY 798700.94 409531.25- 389169.69- 798700.94- 798700.94- 21332432.25- 4066689.17- 18372224.42- TOTAL LIAB,FND BAL, RETD EARNS . EHTERPRISE FUNDS 1050.00- 1670377.98 46896.00 19616208.27 21332432.25 15535000.35- 15535000.35- 687541.90- 5109890.00- 5797431.90- FIXED ASSETS GENERAL lONG GROUP OF TERM DEBT ACCOUHTS ACCOUNT GROUP 4066689.17 4066689.17 4066689. 17- 4066689.17- 18372224.42 18372224.42 18372224.42- 18372224.42- PAG: 1 13 . 04 . 03 TOT A l S MEMORANDUM ONLY --- CURRENT JUNE 30, 1997 447616.18 1670377.98 46896.00 24032932.20 18372224.42 44570046.78 33907224.77- 33907224.77- 1097073.15- 5499059.69- 4066689.17 - 10662822.01- 300450.79 1719345.08 21045462.27 5327970.26 28393228.40 21592970.26- 21592970.26- 830091.56- 5459961.45- 510205.13- 44570046.78- 28393228.40- 6800258.14- GL 1 ()4C THE CITY OF DUBLIN STATEMENT SHO~ING PAGE 1 11/25/97 REVENUES VERSUS EXPENDITURE 12.15.27 FOR THE PERIOO 7/97 THROUGH 10/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- 364111.95- 8.5 3921888.05- 3920897.29- 341481.25- 8.7 3579416.04- SALES TAX 6850000.00- 1947442.76- 28.4 4902557.24- 7108598.19- 1734372.58- 24.4 5374225.61- REAL PROPERTY TRANSFERS 121700.00- 49305.81- 40.5 72394.19- 138062.47- 23706.80- 17.2 114355.67- TRANSIENT OCCUPANCY TAX 231000.00- 84134.00- 36.4 146866.00- 267007.09- 14020.00- 5.3 252987.09- FRANCHISE TAXES 750500.00- 94212.63- 12.6 656287.37 - 723384.60- 85975.31- 11.9 637409.29- LICENSES & PERMITS 1043350.00- 507846.10- 48.7 535503.90- 1092182.95- 327357.61- 30.0 764825.34- FINES & FORFEITURES 33200.00- 15041.03- 45.3 18158.97- 38492.21- 9740.07- 25.3 28752.14- USES OF HONEY AND PROPERTY 1328450.00- 408975.92- 30.8 919474.08- 1388948.66- 242437.4o~ 17.5 1146511.26- INTERGOVERNMENTAL FROM STATE 1171620.00- 357475.66- 30.5 814144.34- 1151275.49- 354027.97- 30.8 797247.52- CHARGES FOR SERVICES 1631918.00- 436204.62- 26.7 1195713.38- 1386418.59- 353784.47- 25.5 1032634.12- OTHER SOURCES OF REVENUE 457819.25- 145406.83- 31.8 312412.42- 223207.32- 74611.81- 33.4 148595.51- TOTAL REVENUE 17905557.25- 4410157.31- 24.6 13495399.94- 17438474.86- 3561515.27- 20.4 13876959.59- *******EXPENDI TURES******* GENERAL ,GOVERNMENT ACTIVITIES: NON -DEPARTMENTAL 24064.00 187.40 .8 23876.60 27346.97 26.00- .1- 27372.97 CITY CooNCIL 1010 137334.00 37182.78 27.1 100151.22 127472.84 33327.26 26.1 94145.58 CITY MANAGER 1020 334487.00 93998.44 28.1 240488.56 291093.65 86711.53 29.8 204382. 12 CITY ATTORNEY 1030 186794.00 31074.79 16.6 155719.21 201718.85 39457.53 19.6 162261.32 ADMIN SERVICES 1040 637675.00 185184.15 29.0 452490.85 569247.12 164717.37 28.9 404_ BUILDING MANAGEMENT 1050 315955.00 72816.64 23.0 243138.36 331517.40 66906.97 20.2 264 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 99730.16 67.9 47072.84 122777.83 81136.45 66.1 41641.38 ELECTIONS COST CENTER 1070 766.00 .00 766.00 20511.92 496.30 2.4 20015.62 ACTIVITY TOTAL 3383797.00 881801.22 26.1 2501995.78 3188502.99 849607.96 26.6 2338895 . 03 PUBLl C SAFETY: POll CE 2010 4282674.00 133665.96 3.1 4149008.04 3794625 . 12 106395.14 2.8 3688229.98 CROSSING GUARDS COST 2020 42726.00 4504.71 10.5 38221.29 40926.26 2133.81 5.2 38792.45 ANIMAL CONTROL 2030 200124.00 .00 200124.00 110514.00 .00 110514.00 DISASTER PREAPREDNESS 2050 34030.00 949.27 2.8 33080.73 25992.10 9251.28 35.6 16740.82 FIRE SERVICES 2060 3598953.00 1187791.47 33.0 2411161.53 2751796.45 921417.86 33.5 1830378.59 ACTIVITY TOTAL 8158507.00 1326911.41 16.3 6831595.59 6723853.93 1039198.09 15.5 5684655.84 TRANSPORTATION: PUBLI C v.JRKS 3010 366732.00 99303.05 27.1 267428.95 319005.00 90031.62 28.2 228973.38 STREET MAINTENANCE 3020 55770.00 2736.72 4.9 53033.28 31593.44 28516.50 90.3 3076.94 STREET TREE MAINTENANCE 3040 47700.00 5844.97 12.3 41855.03 48375 .71 3467.53 7.2 44908.18 STREET LANDSCAPE MAINT. 3050 197'f70.00 40383.12 20.5 156786.88 230289.60 32681.86 14.2 197607.74 ACTIVITY TOTAL 667372.00 148267.86 22.2 519104.14 629263.75 154697.51 24.6 474566.24 HEALTH & ~LFARE: IJASTE 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 CULTURE & LEISURE SERVICES: Ll BRARY SERVI CES 8010 216994.00 54249.25 25.0 162744.75 205874.00 .00 205874.00 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 12500.00 10000.00 80.0 2500.00 HERIT AGE CENTER 80i2 55930.00 15125.29 27.0 40804 . 71 54291. 08 13492.55 24.9 40798.53 DUBLIN CEMETERY 8013 16690.00 1060.83 6.4 15629.17 15749.25 1415.61 9.0 143. GL 1 04C THE CITY OF DUBLIW STATEMEWT SH~ING PAGE 2 11/25/97 REVENUES VERSUS EXPENDITURE 12.15.27 FOR THE PERIOO 7197 THROUGH 10197 . GENERAL REVENUE FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCE/H VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D PARK MAHITENANCE 8020 589455.00 95783.06 16.2 493671.94 594119.19 87354.72 14.7 506764.47 COMMUNITY CABLE TV 8030 37051.00 25217.00 68.1 11834.00 34256.72 22561. 72 65.9 11695.00 RECREATION ADMIN. 8040 256353.00 74445.06 29.0 181907.94 234707.54 62924.64 26.8 171782.90 PLAYGROUNDS 8045 128003.00 45191.38 35.3 82811.62 108257.69 41469.19 38.3 66788.50 SHANNON CENTER 8050 148006.00 39726.34 26.8 108279.66 136660.43 37273.56 27.3 99386.87 PRESCHOOL 8055 54333.00 15847.43 29.2 38485.57 51629.57 15426.93 29.9 36202.64 TEENS PROGRAM 8060 35296.00 5647.60 16.0 29648.40 25445.93 7552.52 29.7 17893.41 ADULT SPORTS 8065 65350.00 19924.86 30.5 45425.14 61034.72 17532.21 28.7 43502.51 YOOTH SPORTS 8066 52406.00 13539.43 25.8 38866.57 39910.77 9764.87. . 24.5 30145.90 SPECIAL EVENTS 8070 42042.00 11624.18 27.6 30417.82 40133.97 10405.79 25.9 29728.18 SEN lOR CENTER 8080 104521.00 27961.77 26.8 76559.23 80392.97 23574.09 29.3 56818.88 RECREATION IIISTRUCTIOW 8090 88555.00 44212.92 49.9 44342.08 89684.89 24533.79 27.4 65151.10 AQUATICS 8100 219265.00 99083.79 45.2 120181.21 215910.85 87851.33 40.7 128059.52 ACTIVITY TOTAL 2120250.00 598640.19 28.2 1521609.81 2Do0559.57 473133.52 23.7 1527426.05 COMMUNITY DEVELOPMENT: PLAWNING 9010 744971 .00 206270.36 27.7 538700.64 659318.79 206462.12 31.3 452856.67 BUILDING SAFETY 9020 593826.00 148354.17 25.0 445471.83 386171.15 100021. 93 25.9 286149.22 ENGINEERING 9030 781875.00 171657.51 22.0 610217.49 684913.30 139887.40 20.4 545025.90 ECONOMIC DEVELOPMENT 9040 146213.00 60767.02 41.6 85445.98 108155.26 32778.55 30.3 75376.71 ACTIVITY TOTAL 2266885.00 587049.06 25.9 1679835.94 1838558.50 479150.00 26.1 1359408.50 CAPITAL IMPROVEMEWT PROJECTS: ~RAL CIP PROJECTS 93NN 584850.00 25681.28 4.4 559168.72 80137.74 3484.11 4.3 76653.63 UNITY IMPROVEMENTS 94NN 66000.00 4094.35 6.2 61905.65 51771.12 .00 51771.12 PARKS 95NII 192140.00 7415.09 3.9 184724.91 497423.22 165865.82 33.3 331557.40 STREET CDIISTRC/IMPROVMT 96NII 312561.00 6753.28 2.2 305807.72 403724.50 183159.07 45.4 220565.43 ACTIVITY TOTAL 1155551.00 43944.00 3.8 1111607.00 1033056.58 352509.00 34.1 680547.58 TOT A L EXPENDITURES 17769682.00 3586613.74 20.2 14183068.26 15429391.19 3348296.08 21.7 12081D95.11 EXCESS <REVENUE>EXPENDITURES 135875 .25- 823543.57- 606.1 687668.32 2009083.67- 213219.19- 10.6 1795864.48- TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 50n.54- .00 50n.54- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 4211.16 .00 4211.16 =XCESS <REVENU=> EXPENDITURE 135875 .25 - 823543.57- 606.1 687668.32 2009950.05- 213219.19- 10.6 1796730.86- . GL 1 04C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 11/25/97 REVENUES VERSUS EXPENDITURE 12.18.52 FOR THE PERIOD 7197 THROUGH 10197 SPECIAL REVENUE FUNDS . 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- 50558.35- 31.7 108741.65- 152122.48- 47332.58- 31.1 104789.90- FINES & FORFEITURES 25000.00- 8327.68- 33.3 16672.32- 22506.62- 5930.58- 26.4 16576.04- USES OF MONEY AND PROPERTY 78560.00- .00 78560.00- 98044.39- .00 98044.39- INTERNGOVERNMENTAL FROM STATE 740859.00- 249096.11- 33.6 491762.89- 611716.48- 239(l8.1.67- 39.2 372034.81- INTERGOVERNMENTAL FROM COUNTY 141460.00- 26511.00- 18.7 114949.00- 143136.00- 2m9.o0- 19.4 115397.00- INTERGOVERNMENTAL FROM FEDERAL 464889.00- 10537.89- 2.3 454351. 11- 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- 345031.03- 13.1 2293536.97- 2312080.86- 332077.83- 14.4 1980003.03- *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLl C SAFETY: POll CE 93845.00 20787.07 22.2 73057.93 63146.44 .00 63146.44 TRAFFIC SIGNALS 108150.00 14086.83 13.0 94063.17 78617.71 11630.21 14.8 66987.50 FIRE SERVICES 75960.00 2875.00 3.8 73085 . 00 .00 .00 .00 ACTIVITY TOTAL 277955.00 37748.90 13.6 240206.10 141764.15 11630.21 8.2 130:>> TRANSPORT A TI 011: PUBLl C WORKS .00 .00 .00 172.47 .00 STREET KAINTEIIAIICE 208910.00 34450.91 16.5 174459.09 213347.82 22906.23 10.7 190441.59 STREET S'oJEEPING 80600.00 18424.47 22.9 62175.53 67675.22 11961. 15 17.7 55714.07 ACTIVITY TOTAL 289510.00 52875.38 18.3 236634.62 281195.51 34867.38 12.4 246328. 13 HEALTH & 'oJELFARE: ~ASTE MANAGEMEIIT 808166.00 1205.52 .1 . 806960.48 718827.72 19782.25 2.8 699045.47 ACTIVITY TOTAL 808166.00 1205.52 .1 806960.48 718827.72 19782.25 2.8 699045.47 CULTURE & LEISURE SERVICES: PARI:: MAII/TEIIANCE .00 .00 .00 7154.10 .00 7154.10 ACTIVITY TOTAL .00 .00 .00 7191.46 .00 7191.46 COMMUIIITY DEVELOPMENT: ENGINEERING 88120.00 8320.87 9.4 79799.13 88980.07 12050.34 13.5 76929.73 ACTIVITY TOTAL 88120.00 8320.87 9.4 79799. 13 88980.07 12050.34 13.5 76929.73 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 250983.00 10494.23 4.2 240488.77 140454.07 .00 140454.07 PARKS 219102.23 30897.30 14.1 188204.93 443937.09 5360.24 1.2 438576.85 STREET COIISTRUCTION/IMPROVMT 766610.00 6562.99 .9 760047.01 353418.05 200261.55 56.7 153156.50 ACTIVITY TOTAL 1236695 .23 47954.52 3.9 1188740.71 937809.21 205621. 79 21.9 732187.42 TOT A L EXPEIIDITURES 2707491.23 148105.19 5.5 2559386.04 2175768.12 283951 .97 13.1 1891816.15 EXCESS <REVENUE>EXPEIIDITURE 68923.23 196925.84- 285.7- 265849.07 136312.74- 48125.86- 35.3 88186.88- TRAIISFERS OUT TO OTHER FUNDS .00 .00 .00 3395 . 00 .00 3395.00 EXCESS <REVENUE> EXPENDITURE 68923.23 196925.84- 285.7- 265849.07 132917.74- 48125.86- 36.2 84791.88- . GL104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 11/25/97 REVENUES VERSUS EXPENDITURE 12.23.41 FOR THE PERIOO 7197 THROUGH 10197 . SPECIAL ASSESSMENT FUNDS CURRENT PERlOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FI SCAl 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 PUBLl C SAFETY: TRFC SIGSISTREET lIGHTING 121705.00 16264.43 13.4 105440.57 103293.98 17051.76 16.5 86242.22 ACTIVITY TOTAL 121705.00 16264.43 13.4 105440.57 103293.98 17051.76 16.5 86242.22 TRANSPORTATION: PUBLI C I.'ORKS 1300.00 1005.34 77.3 294.66 4247.66 866.85 20.4 3380.81 STREET TREE MAINTENANCE 11410.00 561.57 4.9 10848.43 5697.32 923.77 16.2 4m.55 STREET LANDSCAPE MAINTENANCE 139420.00 22105.10 15.9 117314.90 138868.81 25262.54 18.2 1 13606.27 ACTIVITY TOTAL 152130.00 23672.01 15.6 128457.99 148813.79 27053.16 18.2 .121760.63 HEALTH & ~LFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: .GINEERING 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 7222.00 43.8 9266.87 STREET CONSTRUCTION/IMPROVMT 45000.00 .00 45000.00 103000.00 103106.75 100.1 106.75- ACTIVITY TOTAL 69000.00 .00 69000.00 119488.87 110328.75 92.3 9160.12 TOT A L EXPENDITURES 347485.00 43401.44 12.5 304083 . 56 374782.60 157457.11 42.0 217325.49 EXCESS<REVENUE>EXPENDITURE 57683.00 43401.44 75.2 14281.56 112000.40 155784.62 139.1 43784.22- EXCESS <REVENUE> EXPENDITURE 57683.00 43401.44 75.2 14281.56 112000.40 155784 .62 139.1 43784.22- . GL 1 O4C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 11/25/97 REVENUES VERSUS EXPENDITURE 12.45.56 FOR THE PERICO 7197 THROUGH 10/97 CAP IT AL IMPROVEMENT FUND . CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T~D ********REVENUES******* 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 PUBLI C SAFETY: TRANSPORT A TI ON: HEALTH & ~LFARE: CULTURE & LEISURE SERVICES: CCIoOOlN ITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 100000.00 9359.94 9.4 90640.06 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 28171.92 1.1 2486995.08 449732.20 178643.58 39.7 271088.62 ACTIVITY TOTAL 2873627.00 37531.86 1.3 2836095. 14 462555.95 178643.58 38.6 283912.37 TOT A L EXPENDITURES 2873627.00 37531. 86 1.3 2836095.14 462555.9S 178643.58 38.6 283ij EXCESS<REVENUE>EXPENDITURE 15785.00- 37531.86 237.8- 53316.86- 134058.11 108214.03 80.7 25 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 1682.54 .00 168 EXCESS <REVENUE> EXPENDITURE 15785.00- 37531.86 237.8- 53316.86- 135740.65 108214.03 79.7 27526.62 . GL 1 D4C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 1 1/25/97 REVENUES VERSUS EXPENDITURE 12.52.25 FOR THE . PERIO? 7/97 THROUGH 10/97 TRUST/AGENCY FUND CURRENT PERIO? PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS .00 .00 .00 236036.28- .00 236036.28- USES OF MONEY AND PROPERTY .00 1737.04- 1737.04 11962.96- 1600.84- 13.4 10362.12- TOTAL REVENUE .00 1737.04- 1737.04 247999.24- 1600.84- .6 246398.40- *******EXPENOITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 ACTIVITY TOTAL .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 PUBU C SAFETY: TRANSPORTATION: HEALTH & ~LFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOTAL EXPENDITURES .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 EXCESS(REVENUE)EXPENDITURE .00 154417.71 154417.71 - 15529.74- 151713.91 976.9- 167243.65- 4tSS (REVENUE) EXPENDITURE .00 154417.71 154417.71- 15529.74- 151713.91 976.9- 167243.65- . GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE" i 11/25/97 REVENUES VERSUS EXPENDITURE 12.31.51 FOR THE PERIOD 7/97 THROUGH 10/97 INTERNAL SERVI CE FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF HONEY AND PROPERTY 13750.00- .00 13750.00- 18137.65- .00 18137.65- CHARGES FOR SERVICES 243411. 00- 81514.34- 33.5 161896.66- 211049.81- 65315.01- 30.9 145734.80- OTHER SOURCES OF REVENUE 500.00- .00 500.00- 21901.75- 10n.70- 4.9 20829.05- TOTAL REVENUE 257661.00- 81514.34- 31.6 176146.66- 251089.21- 66387.71- 26.4 184701.50- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 266250.00 3n74.85 14.0 228975.15 262014.45 40037.51 15.3 221976.94 ACTIVITY TOTAL 266250.00 3n74.B5 14.0 228975.15 262014.45 40037.51 15.3 221976.94 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 266250.00 3n74.B5 14.0 228975. 15 262014.45 40037.51 15.3 221976.94 EXCESS<REVENUE~EXPENDITURE 8589.00 44239.49- 515.1- 52828.49 10925.24 26350.20- 241.2- 37275 . 44 EXCESS <REVENUE~ EXPENDITURE B589.00 44239.49- 515.1- 52828.49 10925.24 26350.20- 241.2- 37275 . 44 . . --- GL 1 04C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 11/25/97 REVENUES VERSUS EXPENDITURE 12.37.23 FOR THE PERIOO 7/97 THROUGH 10/97 . ENTERPRISE FUNDS CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY 1708264.00- 361803.92- 21.2 1346460.08- 1592321.83- 381843.09- 24.0 1210478.74- TOTAL REVENUE 1708264.00- 361803.92- 21.2 1346460.08- 1592321.83- 381843.09- 24.0 1210478.74- *******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 & YELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT 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- 309233.21- 113.1 35831.81 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 4211.16- .00 4211.16- ~ESS <REVENUE> EXPENDITURE 104065.00- 291638.19- 280.2 187573.19 277612.56- 309233.21- 111.4 31620.65 .