The URL can be used to link to this page

Home My WebLink About4.06 PrelimFinRpt 7-98 ~ CITY CLERK File # D[3][3]~-[5]raJ . AGENDA STATEMENT CITY COUNCIL MEETING DATE: (September 1,1998) SUBJECT: Preliminary Financial Report For the Month of July 1998 Report Prepared by: Paul S. Rankin, Assistant City Manager EXHIBITS ATTACHED: Pro Forma Balance Sheet and Income Statements for the Period Ending July 31, 1998 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 July. The reason that the report is presented as "preliminary" is that the final audited results of Fiscal Year 1997/98 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 Reporting of Information The auditors will start this month the final phase of their field work necessary for the 1997/98 audit. The fmal audit results will impact the reported Fund Balance presented in the attached monthly reports. For example, any General Fund Revenues which exceeded the 1997/98 expenditures have not been carried forward to the 1998/99 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 anticipates the final entries will occur by the October report, including the fmal year end accrual entry for Sales Tax. In addition, there are some expense accruals which have not been posted to Fiscal Year 1997/98 and thus will affect comparisons of the percentage incurred in the first month. The scope of the changes is not significant when compared to all general fund spending. Analysis of Preliminary .July 1998 Revenue and Expenditure Report Given that this is only the first month of the 1998/99 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 July are comparable to what occurred in the first month of the previous Fiscal Year. The City had collected through July 1998 approximately 6% of the total budgeted General Fund Revenues compared to approximately 4% in the prior Fiscal Year. Licenses and Permits are higher than in the same period in the prior year due to the issuance of building permits during ------------------------------------------------------------------- COPIES TO: G:\MONTHFS\0797 AG.DOC ITEM NO. 4.6 July 1998, representing improvements valued at over $55 million. Intere;t and Rentals are higher than in the same period in the prior year due to timing differences and a higher cash balance. Initially all interest · revenue is recorded in the General fund and allocated to other fimds on a pro rata basis at year end. . Intergovernmental Revenue is higher than in the same period in the prior year due to timing differences in . the collection of State Motor Vehicle In Lieu Fees for the month of July. The "Other Revenue" category is lower than in the same period in the prior year, due to a decrease in the 1998 equity distribution payment received from ABAG PLAN. The insurance program has reduced equity distributions in order to fimd higher coverage limits. In Fiscal Year 1998-99 the City will have liability coverage of $7 million per occurrence, which is an increase from a $5 million limit. 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 July expenditures in the General Fund totaled $1,098,872 and represented approximately 5% of the total budgeted expenditures in the General Fund. Of this amount, a total of $72,482 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 July 1998 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of July 31, 1998, the City had expended 5% of the General Fund Operating Budget compared to 7% in the prior Fiscal Year. As previously noted there are some timing differences with payment for contract services and insurance premiums, which complicate comparisons between one year to the next. 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. . -;1.- . . Exhibit 1 City of Dublin 1998-99 YTD Revenues and Budget Comparison For the Period Ending July 31,1998 - Unaudited I I Total General Fund Revenues Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals Intergovernmental from State Charges for Services 0% 0% 7% 6% . FY 98/99 .FY 97/98 0% 0% 0% 0% Other Revenues 0% 30% 60% 83 90% 120% 150% 8% of Year Complete FY 98/99 FY 98/99 %of FY 97/98 % of Total for Budget YTD Actual Budget YTD Actual FY 97/98 Property Taxes 4.966,100 0 0% 0 0% Sales Taxes 7,900,000 550,400 7% 479,700 6% Transient Occupancy Taxes 370,000 0 0% 0 0% Franchise Taxes 782,000 0 0% 0 0% Licenses and Permits 1,826.755 469,475 26% 37,604 3% Interest and Rentals 1.225,530 114,699 9% 6,950 0% Intergovernmental 1,258,420 103.204 8% 0 0% . Charges for Services 2,576,278 91,635 4% 83.574 3% Other Revenues 787,050 46.636 6% 114,772 21% Total General Fund Revenues 21,692,133 1,376,049 6% 722,600 4% 8/25/98 11 :25 g:\monthfs\fscolor.xls I~ ,S Exhibit 2 City of Dublin 1998-99 YTn Expenses and Budget Comparison For the Period Ending July 31, 1998 - Unaudited Fire . Total General Fund Expenses General Government Civic Center Lease Police . FY 98/99 DFY 97/98 Other Public Safety Transportation Health and Welfare Culture & Community Services . Community Development Capital Improv. Projects 0% 30% 60% 8% or Year Complete 90% 120% FY 98/99 FY 98/99 % of FY 97/98 % of Total for Budget YTD Actual Budget YTD Actual FY 97/98 General Government 2,158,775 91,821 4% 146,237 8% Civic Center Lease 1,719,374 346,062 20% 361,627 24% Police 4,456,863 14,621 0% 23,392 1% Fire 4,210,354 316,509 8% 296,150 8% Other Public Safety 272,131 2,735 1% 62 0% Transportation 794,440 23,491 3% 12,786 2% Health and Welfare 18,160 0 0% 0 0% Culture and Community Services 2,510,006 126,230 5% 82,841 4% Community Development 3,240,627 104,921 3% 74,847 3% Capital Improvement Projects 2,748,052 72,482 3% 131 0% 6%. Total General Fund Expenses 22,128,782 1,098,872 5% 998,073 General Fund Operating Expenses 19,380,730 1,026,390 5% 997,942 7% 8125198 1 1:25 g:lmonlhfs\fy98\fscalor .xls ;< ~ /:3 . CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JULY 1998 . Prepared by The Finance Department August 19, 1998 . EXHIBIT 3 at 1:3 GL'C2 CITY OF DUBLIN PA-GE 1 8/18/98 BALANCE SHEET 14.09.29 FOR THE PERIOD 7/98 THROUGH 7/98 GENERAL SPECIAL SPECIAL CAP IT AL TRUSTI TOT A L S. REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONLY --- FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1998 ASSETS CASH 11104901.79- 1690523.58 279254.03 8629754.83 176507.79 328861.56- 60449.64- CASH WITH FISCAL AGENT 143428.79 143428..79 136947. 13 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 39875470.64 39875470.64 27685321.17 RECEIVABLES:TAXES 44073.96 ACCOUNTS (NET) 136596.42 136596.42 780179.32 INTEREST 63467.97- 63467.97- 175681.50 ASSESSMENTS 8663.63 RENTS NOTES DUE FROM OTHERS 244198.74 94397.33 338596.07 385532.90 INVENTORY AT COST PREPAID ITEMS 6405.26 6405.26 5121. 13 FIXED ASSETS AMOUNTS TO BE PROVIDED 2018500.00 2018500.00 2018500.00 TOTAL ASSETS 29094301.30 1784920.91 279254.03 8629754.83 2338436.58 42126667.65 31179571.10 LIAB, FND BAL, RETND EARNINGS 425504. DEPOSITS FOR PRIVATE DEVELPMNT 544329.91- 544329.91- DEPOSITS FOR AB1600 FEES 9169332.18- 9169332.18- 1978934.23- DEPOSITS OTHERS 725928.46- 3547.89- 248261.35- 977737.70- 772343.70- PAYABLES:ACCOUNTS 1500540.50- 130130.09- 30611.65- 4384.07- 1665666.31- 1169008.28- INTEREST PAYROLL 43743.89- 43743.89- 1171.82- DUE TO OTHERS 176143.04- 176143.04- DEBT INSTRUMENTS PAYABLE 2136000.00- 2136000.00- 2136000.00- TOTAL LIABILTIES 2990685.80- 133677.98- 30611.65- 9421977.60- 2136000.0p- 14712953.03- 6482962.22- FUND BALANCES 26103615.50- 1651242.93- 248642.38- 792222.77 202436.58- 27413714.62- 24696608.88- TOTAL FUND EQUITY 26103615.50- 1651242.93- 248642.38- 792222.77 202436.58- 27413714.62- 24696608.88- TOTAL LIAB,FND BAL, RETD EARNS 29094301.30- 1784920.91- 279254.03- 8629754.83- 2338436.58- 42126667.65- 31179571.10- . i( c5 jg GL1C2 8/i 8/98 CITY OF DUBL! N BALANCE SHEET FOR THE PERIOD 7/98 THROUGH 7/98 . INTERNAL SERVICE FUND ASSETS CASH CASH UITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 534533.10 INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEIo!S FIXED ASSETS AMOUNTS TO BE PROVIDED 350034.76 TOTAL ASSETS 884567.86 .FND BAL, RETND EARNINGS TS FOR PRIVATE DEVELPMNT DE SITS OTHERS PAYABLES:ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCE CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUYD EQUITY 248.35- 248.35- 495,49.52- 389169.69- 884319.51- 884567.86- 21332386.41- 4066689.17- 16239618.82- TOTAL LIAB,FND BAl, RETD EARNS . ENTERPRISE FUNDS 8384.92- 1677667.06 46896.00 19616208.27 21332356.41 15535000.00- 15535000.00- 657496.41- 5109890.00- 5797386.41- FIXED ASSETS GENERAL lONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP 4066689.17 4066689.17 4066689.17- 4066689.17- 16239615.82 16239618.52 16239618.82- 16239618.82- PAGE 1 14.32.37 TOT A l S MEMORANDUM ONLY --. CURRENT JUNE 30, 1998 526148.18 1677667.06 46896.00 24032932.20 16239618.52 42523262.26 248.35- 31774618.82- 31774867.17- 1182646.23- 5499059.69- 4066689.17- 10748395.09- 1.20521.77 1670200.92 46896.00 24032932.20 183n224.42 44543075.31 33907224.77- 3390n24.77- 1070101.68- 5499059.69- 4066689.17- 42523262.26- 44543075_31- 10635850.54- 5" c5 IS GL10"C THE CITY OF ~UBLIN STATEMENT SHO~ING PAGE 1 8/15/95 REVENUES VERSUS EXPENDITURE 10.26.02 FOR THE PERIOD 7198 THROUGH 7/98 GENERAL REVENUE FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FI SCAL YR Y-T-D ********REVENUES******* PROPERTY TAXES 4731100.00- .00 4731100.00- 4269117.76- .00 4269117.76- SALES TAX 7900000.00- 550400.00- 7.0 7349600.00- 7540287.89- 479700.00- 6.4 7060587.89- REAL PROPERTY TRANSFERS 235000.00- .00 235000.00- 231331.24- . .00 231331.24 - TRANSIENT OCCUPANCY TAX 370000.00- .00 370000.00- 306318.00- .00 306318.00- FRANCHISE TAXES 782000.00- .00 782000.00- 726399.34- .00 726399.34- LICENSES & PERMITS 1826755.00- 469475.16- 25.7 1357279.84- 1400476.76- 37603.52- 2.7 1362873.24- FINES & FORFEITURES 45950.00- 3631.27- 7.9 42318.73- 40421.45- 4621.88- 11.4 35799.57- USES OF MONEY AND PROPERTY 1225530.00- 114698.92- 9.4 1110831. 08- 1622893.23- 6950.35- .4 1615942.88- INTERGOVERNMENTAL FROM STATE 1258420.00- 103203.57- 8.2 1155216.43- 1233812.25- .00 1233812.25- CHARGES FOR SERVICES 2576278.00- 91635.34- 3.6 2484642.66- 2440792.34- 83573.71 - 3.4 2357218.63- OTHER SOURCES OF REVENUE 741100.00- 43005.40- 5.8 698094.60- 503749.71- 110150.67- 21.9 393599.04- TOTAL REVENUE 21692133.00- 1376049.66- 6.3 20316083.34- 20315599.97- 722600.13- 3.6 19592999.84- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 45000.00 .00 45000.00 187.40 .00 187.40 CITY COUNCIL 1010 140373.00 11062.40 7.9 129310.60 120295.28 9452.48 7.9 110842.80 cITY MANAGER 1020 350365.00 27495.07 7.8 322869.93 316711.51 15530.52 4.9 301180.99 CITY A HORNEY 1030 203340.00 .00 203340.00 245266.02 .00 245266.. ADMIN SERVICES 1040 732965.00 50521.47 6.9 682443.53 622877.71 30369.49 4.9 592508. BUILDING MANAGEMENT 1050 537270.00 2741. 85 .5 534528.15 309338.75 2032.52 .7 307306. FACILITY RENTAL 1050-719 1719374.00 346062.24 20.1 1373311.76 1493347.61 361626.86 24.2 1131720.75 INSURANCE COST CENTER 1060 143047.00 .00 143047.00 139035.94 88852.38 63.9 50183.56 ELECTIONS COST CENTER 1070 6415.00 .00 6415.00 650.04 .00 650.04 ACTIVITY TOTAL 3878149.00 437883.03 11.3 3440265.97 3247710.26, 507864.25 15.6 2739846.01 PUBLIC SAFETY: POLI CE 2010 4456863.00 14620.87 .3 4442242.13 4334724.44 23392.10 .5 4311332.34 CROSSING GUARDS COST 2020 52887.00 .00 52887.00 48727.64 .00 48727.64 ANIMAL CONTROL 2030 180700.00 .00 180700.00 164759.33 .00 164759.33 DISASTER PREAPREDNESS 2050 38544.00 2735.48 7.1 35808.52 21913.28 62.43 .3 21850.85 FIRE SERVICES 2060 4210354.00 316508.97 7.5 3893845.03 3623552.15 296149.85 8.2 3327402.30 ACTIVITY TOTAL 8939348.00 333865.32 3.7 8605482.68 8193676.84 319604.38 3.9 7874072.46 TRANSPORTATION: PUBLI C WORKS 3010 393130.00 23491.19 6.0 369638.81 350104.71 12785.56 3.7 337319.15 STREET MAINTENANCE 3020 141720.00 .00 141720.00 2930.97 .00 2930.97 STREET TREE MAINTENANCE 3040 44990.00 .00 44990.00 29608.89 .00 29608.89 STREET LANOSCAPE MAINT. 3050 214600.00 .00 214600.00 184782.06 .00 184782.06 ACTIVITY TOTAL 794440.00 23491.19 3.0 770948.81 567426.63 12785.56 2.3 554641.07 iEALTH & WELFARE: WASTE MANAGEMENT 5020 6160.00 .00 6160.00 5039.06 .00 5039.06 CHILD CARE 5030 12000.00 .00 12000.00 12000.00 .00 12000.00 ACTIVITY TOTAL 18160.00 .00 18160.00 17039.06 .00 17039.06 :ULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 224247.00 .00 224247.00 216997.00 .00 216997.00 CULTURAL ACTIVITIES 8011 20000.00 20000.00 100.0 .00 10000.00 10000.00 100.0 .00 HERITAGE CENTER 8012 55272.00 2913.94 5.3 52358.06 53602.64 1710.14 3.2 51892.50 DUBLI N CEMETERY 8013 21624.00 .00 21624.00 17118.16 .00 17118. . t, ~ /:2 GL104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 2 8/18/98 REVENUES VERSUS EXPENDITURE 10.26.02 FOR THE PERIOO 7/98 THROUGH 7/98 . GENERAL REVENUE FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D PAR( MAINTENANCE 8020 619429.00 .00 619429.00 503590.27 .00 503590.27 COMMUNITY CABLE TV 8030 61566.00 .00 61566.00 36347.00 .00 36347.00 RECREATION ADMIN. 8040 282179.00 20666.75 7.3 261512.25 247356.29 13419.71 5.4 233936.58 PLAYGROUNDS 8045 137665.00 18105.88. 13.2 119559.12 '119438.04 8705.55 7.3 110732.49 SHANNON CENTER 8050 153998.00 5820.18 3.8 148177.82 145327.99 4471. 14 3.1 140856.85 PRESCHOOL 8055 56878.00 4283.57 7.5 52594.43 52066.88 2707.19 5.2 49359.69 TEENS PROGRAM 8060 52028.00 2103.91 4.0 49924.09 34249.32 736.40 2.2 33512.92 ADULT SPORTS 8065 73154.00 4328.28 5.9 68825.n 57312.65 2404.46 4.2 54908.19 YOUTH SPORTS 8066 85396.00 3168.73 3.7 82227.27 45185.51 3313.71 7.3 41871.80 SPECIAL EVENTS 8070 1806n.00 3464.76 1.9 1m07.24 98680.81 1795.77 1.8 96885.04 SENIOR CENTER 8080 124410.00 6007.08 4.8 118402.92 95665.11 3323.13 3.5 92341.98 RECREATION INSTRUCTION 8090 122588.00 6264.60 5.1 116323.40 136019.81 14518.02 10.7 121501.79 ACUA TI CS 8100 238900.00 29102.61 12.2 209797.39 230969. 18 15735.67 6.8 215233.51 ACTIVITY TOTAL 2510006.00 126230.29 5.0 2383775 . 71 2099926.66 82840.89 3.9 2017085.77 COMMUNITY DEVELOPMENT: PLANNING 9010 922488.00 50981.65 5.5 871506.35 809442.29 31223.90 3.9 778218.39 BUILDING SAFETY 9020 880947.00 10825.19 1.2 870121.81 606011.10 6504.28 1.1 599506.82 ENGINEERING 9030 1253161.00 34981.64 2.8 1218179.36 1170106.18 32322.22 2.8 1137783.96 ECONOMIC DEVELOPMENT 9040 184031.00 8132.08 4.4 175898.92 154373.41 4796.22 3.1 149577.19 ACTIVITY TOTAL 3240627.00 104920.56 3.2 3135706.44 2739932.98 74846.62 2.7 2665086.36 CAPITAL IMPROVEMENT PROJECTS: 4llllRAL CIP PROJECTS 93NN 1269149.00 .00 1269149.00 405868.92 .00 405868.92 UNITY IMPROVEMENTS 94NN n994.00 2445.60 3.4 70548.40 62175.25 .00 62175.25 PAR(S 95NN 1051309.00 69662.50 6.6 9S1646.50 146246.97 131.20 .1 146115.77 STREET CONSTRC/IMPROVMT 96NN 354600.00 374.20 .1 354225.80 436201.38 .00 436201.38 ACTIVITY TOTAL 2748052.00 n482.30 2.6 2675569.70 1050492.52 13 1 .20 1050361.32 TOT A L EXPENDITURES 22128782.00 10988n.69 5.0 21029909.31 17916204.95 9980n.90 5.6 16918132.05 EXCESS <REVENUE>EXPENDITURES 436649.00 277176.97- 63.5- 713825.97 2399395.02- 2754n.77 11.5- 2674867.79- TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 20253.75- .00 20253.75- EXCESS <REVENUE> EXPENDITURE 436649.00 277176.97- 63.5- 713825 .97 2419648.77- 2754n.77 11.4- 2695121.54. . ? if' ;3 GL104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 8/21/98 REVENUES VERSUS EXPENDITURE 14.42.C" FOR THE PERIOD 7198 THROUGH 7198 SPECIAL REVENUE FUNDS . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* PROPERTY TAXES 76680.00- .00 76680.00- 74130.51- .00 74130.51- SALES TAX 175500.00- 11661.96- 6.6 163838.04- 166074.24- 10476.56- 6.3 155597.68- FINES & FORFEITURES 42400.00- .00 "42400.00 - 30595.76- .00 30595.76- uses OF MONEY AND PROPERTY 97330.00- .00 97330.00- 3490.57- .00 3490.57- INTERNGOVERNMENTAL FROM STATE 1486924.00- 49958.77- 3.4 1436965.23- 573353.27- 1344.71 - .2 572008.56. INTERGOVERNMENTAL FROM COUNTY 145065.00- .00 145065.00- 143024.00- .00 143024.00- INTERGOVERNMENTAL FROM FEDERAL 108203.00- .00 108203.00- 24081.55- .00 24081.55- CHARGES FOR SERVICES 698080.00- .00 698080.00- 707626.59- .00 707626.59. OTHER SOURCES OF REVENUE 139810.00- 4391.00- 3.1 135419.00- 244641.83- .00 244641.83- TOTAL REVENUE 2969992.00- 66011. 73- 2.2 2903980.27- 1967018.32- 11821.27- .6 1955197.05- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON.DEPARTMENTAL .00 17.52- 17.52 .00 .00 .00 BUILDING MANAGEMENT .00 .00 .00 175.00 .00 175.00 ACTIVITY TOTAL .00 17.52- 17.52 175 . 00 .00 175 . 00 PUBLI C SAFETY: POll CE 77844. 00 .00 77844.00 63218.34 .00 63218.34 TRAFFIC SIGNALS 104750.00 6239.35 6.0 98510.65 80070.46 .00 8007. FIRE SERVIces 81745.00 .00 81745.00 79216.20 .00 7921 ACTIVITY TOTAL 264339.00 6239.35 2.4 258099.65 222505.00 .00 222505. TRANSPORTATION: STREET MAINTENANCE 245020.00 .00 245020.00 233522.14 .00 233522.14 STREET SWEEPING 90070.00 .00 90070.00 78539.83 .00 78539.83 ACTIVITY TOTAL 335090.00 .00 335090.00 312061.97 .00 312061.97 HEALTH & WELFARE: ~ASTE MANAGEMENT 859499.00 800.00 .1 858699.00 740418.98 15.00 740403.98 SENIOR SUPPORT CARE 7044.00 .00 7044.00 7044.00 .00 7044.00 ACTIVITY TOTAL 866543.00 800,00 .1 865743.00 747462.98 15.00 747447.98 CULTURE & LEISURE SERVICES: PARK MAINTENANCE .00 .00 .00 4431. 90 .00 4431. 90 ACTIVITY TOTAL .00 .00 .00 4530.91 .00 4530.91 COMMUNITY DEVELOPMENT: ENGINEERING 38900.00 .00 38900.00 56396.92 606.30 1.1 55790.62 ACTIVITY TOTAL 38900.00 .00 38900.00 56396.92 606.30 1.1 55790.62 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 57611.00 .00 57611.00 233611.81 1147.10 .5 232464.71 PARI::S 185523.00 1153.94 .6 184369.06 95432.22 1549.60 1.6 93882.62 STREET CONSTRUCTION/IMPROVMT 1068211.00 405.29 1067805.71 257749.63 .00 257749.63 ACTIVITY TOTAL 1311345.00 1559.23 .1 1309785.77 586793.66 2696.70 .5 584096.96 TOT A L EXPENDITURES 2816217.00 8563.54 .3 2807653.46 1929926.44 3318.00 .2 1926608.44 EXCESS <REVENUE>EXPENDITURE 153775.00- 57430.67- 37.3 96344.33- 37091.88- 8503.27- 22.9 28588.61- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 9468.29 .00 9468.29 EXCESS <REVENUE> EXPENDITURE 153775.00- 57430.67- 37.3 96344.33- 27623.59- 8503.27- 30.8 19120.32- . ?uf /S GL 1 04C. THE CITY OF DUBLIN STATEMENT SHOJING PAGE 1 8118/98 REVENUES VERSUS EXPENDITURE 1 1. 46. 1 0 FOR THE PERIOD 7/98 THROUGH 7198 . SPECIAL ASSESSMENT FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 254580.00- .00 254580.00- 274105.82- .00 274105.82- USES OF MONEY AND PROPERTY 10300.00- .00 10300.00- 1112.47- .00 1112.47- OTHER SOURCES OF REVENUE 2000.00- .00 2000.00- 2026.04- .00 2026.04- TOTAL REVENUE 266880.00- .00 266880.00- 277244.33- .00 277244.33- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRFC SIGSISTREET LIGHTING 130987.00 5594.13 4.3 125392.87 114835.16 1000.00 .9 113835.16 ACTIVITY TOTAL 130987.00 5594.13 4.3 125392.87 114835.16 1000.00 .9 113835. 16 TRAt/SPORT A TI ON: PUBLI C WORKS 4229.00 220.26 5.2 4008.74 3578.12 154.18 4.3 3423.94 STREET TREE MAINTENANCE 9600.00 .00 9600.00 3719.00 .00 3719.00 STREET LANDSCAPE MAINTENANCE 128770.00 .00 128770.00 96000.26 .00 96000.26 ACTIVITY TOTAL 142599.00 220.26 .2 142378.74 103297.38 154.18 .1 103143.20 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: .EERING 3980.00 .00 3980.00 3465.00 750.00 21.6 2715.00 ACTIVITY TOTAL 3980.00 .00 3980.00 3465.00 750.00 21.6 2715.00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS .00 .00 .00 27115.00 .00 27115.00 STREET CONSTRUCTION/IMPROVMT .00 .00 .00 48938.90 .00 48938.90 ACTIVITY TOTAL .00 .00 .00 76053.90 .00 76053.90 TOT A L EXPENDITURES 277566.00 5814.39 2.1 271751.61 297651.44 1904.18 .6 295747.26 EXCESS<REVENUE~EXPENDITURE 10686.00 5814.39 54.4 4871.61 20407.11 1904.18 9.3 18502.93 EXCESS <REVENUE~ EXPENDITURE 10686.00 5814.39 54.4 4871.61 20407.11 1904.18 9.3 18502.93 . c; ;( I~ GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PkGE , 8/18/98 REVENUES VERSUS EXPENDITURE 13.44.39 FOR THE PERIOD 7/98 THROUGH 7198 CAP IT AL IMPROVEMENT FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY .00 .00 .00 6431.68- .00 6431.68- OTHER SOURCES OF REVENUE 10778637.00- .00 10778637.00- 51796.03- .00 51796.03- TOTAL REVENUE 1Q778637.00- .00 10778637.00- 58227.71- .00 58227.71- *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLI C SAFETY: TRANSPORTATION: HEALTH & ~ELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 14500.00 .00 14500.00 .00 .00 .00 ACTIVITY TOTAL 14500.00 .00 14500.00 .00 .00 .00 COMMUNITY DEVELOPMENT: PLANNING 16226.00 145.14 .9 16080.86 3248.58 .00 3248.58 ACTIVITY TOTAL 16226.00 145.14 .9 16080.86 3248.58 .00 3248.58 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 974884.00 .00 974884.00 22818.06 .00 22818.06 COMMUNITY IMPROVEMENTS 94024.00 .00 94024.00 12000.62 .00 1200~ PARKS 2742n5.0o .00 2742725.00 86242.07 .00 8624 STREET CONSTRUCTION/IMPROVMT 6922809.00 .00 6922809.00 410503.66 .00 410503. ACTIVITY TOTAL 10734442.00 .00 10734442.00 531564.41 .00 531564.41 TOT A L EXPENDITURES 10765168.00 145. 14 10765022.86 534812.99 .00 534812.99 EXCESS<REVENUE>EXPENDITURE 13469.00- 145.14 1. 1- 13614.14- 476585.28 .00 476585.28 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 10785.46 .00 10785.46 EXCESS <REVENUE> EXPENDITURE 13469.00- 145.14 1.1- 13614.14- 487370.74 .00 487370.74 . /6 ~ /.3 GL104; THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 8/i 8/98 REVENUES VERSUS EXPENDITURE 14.03.27 FOR THE PERIOD 7/98 THROUGH 7/98 . TRUST/AGENCY FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, '998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS .00 .00 .00 234497.'2- .00 234497.12- USES OF MONEY AND PROPERTY .00 .00 .00 8063.11~ 560.07- 6.9 7503.04- TOTAL REVENUE .00 .00 .00 242560.23- 560.07~ .2 242000. , 6- **.****EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL .00 .00 .00 232903.25 .00 232903.25 ACTIVITY TOTAL .00 .00 .00 232903.25 .00 232903.25 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMP~OVEMENT PROJECTS: TOTAL EXPENDITURES .00 .00 .00 232903.25 .00 232903.25 EXCESS(REVENUE)EXPENDITURE .00 .00 .00 9656.98- 560.07- 5.B 9096.9'- EXCESS (REVENUE) EXPENDITURE .00 .00 .00 9656.98- 560.07- 5.8 9096.91- . . /1 if /9 GL104C THE CITY OF DUBLIN STATEMENT SHO~ING PA-CE 1 8/18/98 REVENUES VERSUS EXPENDITURE 13.10.14 FOR THE PERIOD 7198 THROUGH 7198 INTERNAL SERVICE FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY 39604.00- .00 39604.00- .00 .00 .00 CHARGES FOR SERVICES 737923.00- .00 737923.00- 241988.51- 24905.08- 10.3 217083.43- OTHER SOURCES OF REVENUE 30000.00-. 895.06- 3.0 29104.94- 6782.95. .00 6782.95- TOTAL REVENUE 807527.00. 895.06- .1 806631.94- 248771.46- 24905.08- 10.0 223866.38- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 728134.00 8356.85 1.1 719777.15 110169.11 8510.00 7.7 101659.11 ACTIVITY TOTAL 728134.00 8356.85 1.1 719777.15 110169.11 8510.00 7.7 101659.11 PUBLI C SAFETY: POll CE .00 .00 .00 1282.50 .00 1282.50 ACTIVITY TOTAL .00 .00 .00 1282.50 .00 1282.50 TRANSPORTATION: HEALTH & YELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 728134.00 8356.85 1.1 719777.15 111451.61 8510.00 7.6 102941.61 EXCESS<REVENUE>EXPENDITURE 79393.00- 7461. 79 9.4- 86854.79- 137319.85- 16395.08- 11.9 120924. EXCESS <REVENUE> EXPENDITURE 79393.00- 7461. 79 9.4- 86854.79- 137319.85. 16395.08- 11.9 120924. . I), z1' / 'J; GL104C ' THE CITY OF DUBLIN STATEMENT SHOWING PAGE , 8n 8/98 REVENUES VERSUS EXPENDITURE 13.25.53 FOR THE PERIOO 7/98 THROUGH 7/98 . ENTERPRISE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, '998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY '827244.00- 346062.24- '8.9 '48"8'.76~ '600972.02- 36'626.86- 22.6 1239345. '6- TOTAL REVENUE '827244.00- 346062.24- '8.9 ":'81 '81.76- 1600972.02- 361626.86- 22.6 '239345. , 6- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1719414.00 66374.48 3.9 '653039_52 1584652.08 69115.73 4.4 '5'5536.35 ADMIN SERVICES 6870.00 .00 6870.00 4415.00 .00 4415.00 ACTIVITY TOTAL 1726284.00 66374.48 3.8 '659909.52 1589067.08 69115.73 4.3 1519951.35 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 1726284 . 00 66374.48 3.8 1659909.52 '589067.08 69115.73 4.3 1519951.35 EXCESS<REVENUE>EXPENDITURES '00960.00- 279687.76- 277.0 178727.76 11904.94- 292511. 13- 2457.1 280606.19 EXCESS <REVENUE> EXPENDITURE 100960.00- 279687.76- 277.0 178727.76 11904.94- 29251'.13- 2457.1 280606.19 . . J?; cf ;:3