Loading...
HomeMy WebLinkAbout4.02 PrelimFinRpt 9-98 , r '. i! . . CITY CLERK File # DODD-DO AGENDA STATEMENT CITY COUNCIL MEETING DATE: (November 3,1998) SUBJECT: Preliminary Financial Report For the Month of September 1998 Report Prepared by: Paul S. Rankin, Assistant City Manager EXHIBITS A TT ACHED: Pro Forma Balance Sheet and Income Statements for the Period Ending September 30, 1998 qII.J Accept and file the reports. RECOMMENDATION: 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 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. Preliminarv Reportin{! of Information The auditors have completed the fmal phase of their field work necessary for the 1997/98 audit. The final audit results will impact the reported Fund Balance for each fund used by the City. 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 in individual funds. Staff has already made the fmal 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 significan~ when compared to all general fund revenues and expenses. Analysis ofPreliminarv September 1998 Revenue and Expenditure Report Given that this is only the third 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 September were collected at a rate which is slightly ahead of the first three months of the previous Fiscal Year. The City had collected through September 1998 approximately 18% of the total budgeted General Fund Revenues compared to approximately 15% in the prior Fiscal Year. Licenses and Permits are higher than in the same period in the prior year due to an increase in the number of building permits issued. Permits issued during July through September 1998 ------------------------------------------------------------------------------------------------------------- COPIES TO: 4~2 G:\MOl\'TIIFS\0998 Financial Reports.DOC ITEM NO. represented improvements valued at over $86 million. Charges for services are higher than in the same period of the prior year, primarily related to revenues received for planning and engineering services associated with increased development activity in Eastern Dublin. The "Other Revenue" category is lower than in the same period in the prior year, due to a decrease in tlA 1998 equity distribution payment received from ABAG PLAN. The insurance program has reduceWI' equity distributions in order to fund 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 September expenditures in the General Fund totaled $3,122,338 and represented approximately 14% of the total budgeted expenditures in the General Fund. Of this amount, a total of$143,151 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 September 1998 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of September 30, 1998, the City had expended 14% 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, which complicate comparisons between on~ year to the next. Two programs area have expenditures which ar. currently less than recorded in the previous year. In the General Government Program, the payment for the Civic Center Lease was slightly lower than in the same period in the prior year. Public Safety is the second program with expenditures below the percentage reported in the previous year. This is primarily due to a timing difference in payment of contract services. Community Development expenditures are higher than in the same period in the prior year due to timing differences in the payment for contract building services and higher development related contract. expenditures incurred in the planning and engineering divisions. Capital Improvement Projects are higher than in the same period in the prior year due to expenditures incurred in the current fiscal year for the second phase of the Dougherty Hills Park Slope Repair Capital 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. . City of Dublin 1998.99 YTD Revenues and Budget Comparison For the Period Ending September 30, 1998. Unaudited Total General Fund . Revenues Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits Interest and Rentals . Intergovernmental from State Charges for Sen'ices 9% J 8% g~J 17% 190 40% Exhibit 1 . FY 98/99 ::JFY 97/98 Other Revenues % 0% 30% 60% 90% 120% 150% 25% 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 429,275 9% 350,638 8% Sales Taxes 7,900,000 1,518,863 19% 1,440.243 18% Transient Occupancy Taxes 370,000 62,257 17% 59,354 19% Franchise Taxes 782,000 72,559 9% 62,306 8% Licenses and Permits 1,826,755 723,828 40% 310,895 22% Interest and Rentals 1,225,530 196,835 16% 231,525 15% Intergovernmental 1,258,420 312,593 25% 282,073 23% . Charges for Services 2,576,278 516,493 20% 275,518 11% Other Revenues 787,250 56,178 7% 142,074 26% Total General Fund Revenues 21,692,333 3,888,881 18% 3,154,626 15% 10/26/98 11 :15 g:\monthfslfscolor.xls Exhibit 2 City of Dublin 1998-99 YTD Expenses and Budget Comparison For the Period Ending September 30, 1998 - Unaudited Total General Fund Expenses 14% 16% Fire 19%] 21% 20% 24 0 General Government Civic Center Lease Police 2% 2% 33% . FY 98/99 =FY 97/98 230" Other Public Saff(jl'1o 3% Transportation 13% 15% 0% Health and Welfao'io Capital Improv. Projects 18% 19% Culture & Community Services Community Development 18% % 0% 30% 60% 25% of Year Complete 90% 120% FY 98/99 FY 98/99 % of FY 97/98 % of Total for Budget YTO Actual Budget YTO Actual FY 97/98 General Government 2,158,775 417,148 19% 373,178 21% Civic Center Lease 1,719,374 346,062 20% 361,627 24% Police 4,456,863 90,868 2% 78,165 2% Fire 4,210,354 988,824 23% 1,186,589 33% Other Public Safety 272,131 7,989 3% 229 0% Transportation 794,440 105,571 13% 95,399 15% Health and Welfare 18,160 0 0% 0 0% Culture and Community Services 2,510,206 442,033 18% 416,152 19% Community Development 3,240,627 580,692 18% 361,758 13% Capital Improvement Projects 2,782,188 143,151 5% 14,228 1% 16. Total General Fund Expenses 22,163,118 3,122,338 14% 2,887,325 General Fund Operating Expenses 19,380,930 2,979,187 15% 2,873,097 17% 10/26198 9:51 g:\monlhfsIty98\1scolor.xls ;. CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF SEPTEMBER 1998 . Prepared by The Finance Department October 8, 1998 . EXHIBIT 3 GL102 CITY OF DUBLI N PAGE j 10/08/98 BALANCE SHEET 9.27.02 FOR THE PERIOD 7/98 THROUGH 9/98 GENERAL SPECIAL SPECIAL CAP IT AL TRUST/ TOT A L ~ REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ..- MEMORANDUM ONLY FUNDS FUNDS FUNDS FUNDS FUND CURRENT JUNE 30, 1998 ASSETS CASH 11m305.41- 1774096.24 230948.00 9535652.03 24116.44 208492.70- 476868.48- CASH WITH FISCAL AGENT 144781.69 144781.69 138124.10 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 39438321.17 39438321.17 29135321.17 RECEIVABLES:TAXES ACCOUNTS (NET) 165501.58 139998.41 305499.99 212682.95 INTEREST 219840.71 219840.71 175681.50 ASSESSMENTS RENTS NOTES DUE FROM OTHERS 498403.10 103519.58 601922.68 385532.90 INVENTORY AT COST PREPAID ITEMS 7835.21 7835.21 5586.44 FIXED ASSETS AMOUNTS TO BE PROVIDED 1941500.00 1941500.00 2018500.00 TOT AL ASSETS 28556596.36 2017614.23 230948.00 9535652.03 2110398.13 42451208.75 31594560.58 LIAB, FNO BAL, RETND EARNINGS 4366.- DEPOSITS FOR PRIVATE OEVELPMNT 565554.04- 565554.04' DEPOSITS FOR AB1600 FEES 9601013.66- 9601013.66- 2596595.87- DEPOSITS OTHERS 684630.46- 3547.89- 248048.16- 936226.51- 787150.95- PAYABLES:ACCOUNTS 154257.76- 60811.30- 644.65- 215713.71' 395485.89- INTEREST PAYROLL 44684.21- 44684.21- 11201.76- DUE TO OTHERS 97916.46- 254417.55- 352334.01- 11101.33- OEBT INSTRUMENTS PAYABLE 2059000.00- 2059000.00- 2136000.00- TOTAL LIABILTIES 1547042.93- 318776.74- 9849706.47- 2059000.00- 13774526.14- 6374231.22- FUND BALANCES 27009553.43- 1698837.49- 230948.00' 314054.44 51398.13- 28676682.61- 25220329.36- TOTAL FUND EQUITY 27009553.43- 1698837.49- 230948.00- 314054.44 51398.13- 28676682.61- 25220329.36- TOTAL LIAB,FND BAL, RETD EARNS 28556596.36- 2017614.23- 230948.00- 9535652.03- 2110398.13- 42451208.75- 31594560.58- . GL1g2 10/08/98 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/98 THROUGH 9/98 . INTERNAL SERVICE FUNDS ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 596992.08 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 1645067.31 TOTAL ASSETS 2242059.39 . FND BAL, RETND EARNINGS ITS FOR PRIVATE DEVELPMNT DEPOS ITS OTHERS PAYABLES:ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCE CONTR I BUT! ONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 433932.34- 1808127.05- 2242059.39- 2242059.39- 20928566.85- 6380137.99- 16740304.73- TOTAL LIAB,FNO BAL, RETD EARNS . ENTERPRISE FUNDS FIXED ASSETS GENERAL LONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP 1718234.43 46896.00 19163436.42 6380137.99 20928566.85 6380137.99 14770000.00- 14770000.00- 1048676.85- 5109890.00- 6380137.99- 6158566.85- 6380137.99- 16740304.73 16740304.73 16740304.73- 16740304.73- PAGE 1 9.30.46 TOT A L S MEMORANDUM ONLY --- CURRENT JUNE 30, 1998 596992.08 1718234.43 46896.00 27188641.72 16740304.73 46291068.96 31510304.73- 31510304.73- 1482609.19- 6918017.05- 6380137.99- 14780764.23- 442223.23 1670377.98 46896.00 24032932.20 18410635.11 44603064.52 33945635.46- 33945635.46- 1091680.20- 5499059.69- 4066689.17- 46291068.96- 44603064.52- 10657429.06- GL104C THE CITY OF DUBLIN STATEMENT SHOWING ,PAGE , 10/08/98 REVENUES VERSUS EXPENDITURE 8.37.07 FOR THE PERIOD 7/98 THROUGH 9/98 GENERAL REVENUE FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1998 BUOGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* PROPERTY TAXES 4731100.00- 400899.47- 8.5 4330200.53- 4351858.66- 321462.53- 7.4 4030396.13- SALES TAX 7900000.00- 1518863.25- 19.2 6381136.75- 8025.447.79- 1440242.76- 17.9 6585205.03- REAL PROPERTY TRANSFERS 235000.00- 28375.65- 12.1 206624.35- 231331.24- 29174.54- 12.6 202156.70- TRANSIENT OCCUPANCY TAX 370000.00- 62257.12- 16.8 307742.88- 306318.00- 59354.00- 19.4 246964.00- FRANCHISE TAXES 782000.00- 72559.00- 9.3 709441.00- 759803.34- 62305.96- 8.2 697497.38- LICENSES & PERMITS 1826755.00- 723828.13- 39.6 1102926.87- 1398676.76- 310894.77- 22.2 1087781.99- FINES & FORFEITURES 45950.00- 10686.15- 23.3 35263.85- 40421.45- 11148.93- 27.6 29272.52- USES OF MONEY AND PROPERTY 1225530.00- 196835.33- 16.1 1028694.67- 1526496.29- 231525.32- 15.2 1294970.97- INTERGOVERNMENTAL FROM STATE 1258420.00- 312593.09- 24.8 945826.91- 1233812.25- 282073.44- 22.9 951738.81 - CHARGES FOR SERVICES 2576278.00- 516492.60- 20.0 2059785.40- 2483860.91- 275518.48- 11.1 2208342.43- OTHER SOURCES OF REVENUE 741300.00- 45491. 4 1 - 6.1 695808.59- 507052.04- 130924.67- 25.8 376127.37- TOTAL REVENUE 21692333.00- 3888881.20- 17.9 17803451.80- 20865078.73- 3154625.40- 15.1 17710453.33- *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: NON-OEPARTMENTAL 45000.00 .00 45000.00 487.55 187.40 38.4 300.15 CITY COUNCI L 1010 140373.00 37121.67 26.4 103251.33 120445.28 22435.59 18.6 98009.69 CITY MANAGER 1020 350365.00 79089.39 22.6 271275.61 316766.51 68885.51 21.7 247881.00 CITY ATTORNEY 1030 203340.00 25902.94 12.7 177437.06 220439.41 14102.57 6.4 206336.84 ADMIN SERVICES 1040 732965.00 .148729.29 20.3 584235.71 623479.37 135972.21 21.8 4875. BUILDING MANAGEMENT 1050 537270.00 46048.20 8.6 491221.80 315482.27 41963.42 13.3 2735 FACILITY RENTAL 1050-719 1719374.00 346063.49 20.1 1373310.51 1493347.61 361626.86 24.2 1131720.75 INSURANCE COST CENTER 1060 143047.00 80188.82 56.1 62858.18 163892.55 89631. 15 54.7 74261.40 ELECTIONS COST CENTER 1070 6415.00 66.02 1.0 6348.98 650.04 .00 650.04 ACTIVITY TOTAL 3878149.00 763209.82 19.7 3114939.18 3254990.59 734804.71 22.6 2520185.88 PUBLIC SAFETY: POll CE 2010 4456863.00 90867.82 2.0 4365995.18 4313328.45 78165.40 1.8 4235163.05 CROSSING GUARDS COST 2020 52887.00 .00 52887.00 48727.64 .00 48727.64 ANIMAL CONTROL 2030 180700.00 '.00 189700.00 191931.21 .00 191931.21 DISASTER PREAPREDNESS 2050 38544.00 7989.43 20.7 30554.57 22300.28 229.32 1.0 22070.96 FiRE SERVICES 2060 4210354.00 988824.30 23.5 3221529.70 3628257.63 1186589.14 32.7 2441668.49 ACTIVITY TOTAL 8939348.00 1087681.55 12.2 7851666.45 8204545.21 1264983.86 15.4 6939561.35 TRANSPORTATION: PUBLI C WORKS 3010 393130.00 83566.42 21.3 309563.58 355586.01 66472.70 18.7 289113.31 STREET MAINTENANCE 3020 141720.00 .00 141720.00 55741.35 2736. n 4.9 53004.63 STREET TREE MAINTENANCE 3040 44990.00 55n.80 12.4 39417.20 43164.47 2044.04 4.7 41120.43 STREET LANDSCAPE MAINT. 3050 214600.00 16431. 70 7.7 198168.30 196217.21 24145.61 12.3 172071.60 ACTIVITY TOTAL 794440.00 105570.92 13.3 688869.08 650709.04 95399.07 14.7 555309.97 HEALTH & 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 CULTURE & 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 9050.02 16.4 46221.98 53873.76 10973.71 20.4 42900.05 DUBLI N CEMETERY 8013 21624.00 111.68 .5 21512.32 36931.78 863.48 2.3 3606. GL 1.04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2 10/08/98 REVENUES VERSUS EXPENDITURE 8.37.07 FOR THE PERIOD 7198 THROUGH 9198 . GENERAL REVENUE FUND CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D PARK MAINTENANCE 8020 619429.00 49512.58 8.0 569916.42 551611.39 54146.33 9.8 497465.06 COMMUNITY CABLE TV 8030 61566.00 43056.20 69.9 18509.80 36347.00 24414.00 67.2 11933.00 RECREATION ADMIN. 8040 282179.00 59528.35 21.1 222650.65 247461.23 57672.50 23.3 189788.73 PLAYGROUNDS 8045 137665.00 40810.22 29.6 96854.78 119477 .39 36280.37 30.4 83197.02 SHANNON CENTER 8050 153998.00 28817.49 18.7 125180.51 145355.49 27385.52 18.8 117969.97 PRESCHOOL 8055 56878.00 12574.38 22.1 44303.62 52096.88 11564.76 22.2 40532.12 TEENS PROGRAM 8060 52028.00 6649.16 12.8 45378.84 34249.32 3541.10 10.3 30708.22 ADULT SPORTS 8065 73154.00 15071.92 20.6 58082.08 57312.65 15117.89 26.4 42194.76 YOUTH SPORTS 8066 85396.00 12268.36 14.4 73127.64 45215.51 11183.49 24.7 34032.02 SPECIAL EVENTS 8070 180672.00 9541.67 5.3 171130.33 98680.81 9396.75 9.5 89284.06 SENIOR CENTER 8080 124610.00 19360.91 15.5 105249.09 96151.47 21570.16 22.4 74581.31 RECREATION INSTRUCTION 8090 122588.00 36477.70 29.8 86110.30 136049.81 39574.95 29.1 96474.86 AQUA TI CS 8100 238900.00 79201.99 33.2 159698.01 231182.41 82467.30 35.7 148715.11 ACTIVITY TOTAL 2510206.00 442032.63 17.6 2068173.37 2168993.90 416152.31 19.2 1752841.59 COMMUNITY DEVELOPMENT: PLANNING 9010 922488.00 188689.87 20.5 733798.13 814255.37 150750.30 18.5 663505.07 BUILDING SAFETY 9020 880947.00 137675.27 15.6 743271.73 606011. 10 57374.45 9.5 548636.65 ENGINEERING 9030 1253161.00 203646.81 16.3 1049514.19 1186462.85 99863.41 8.4 1086599.44 ECONOMIC DEVELOPMENT 9040 184031.00 50679.74 27.5 133351.26 154403.41 53770.29 34.8 100633.12 ACTIVITY TOTAL 3240627.00 580691.69 17.9 2659935_31 2761132.73 361758_45 13.1 2399374.28 CAPITAL IMPROVEMENT PROJECTS: ~ERAL CIP PROJECTS 93NN 1269149.00 ; 18774.52 1.5 1250374.48 412250.17 7040.91 1.7 405209.26 MUNITY IMPROVEMENTS 94NN 72994.00 .00 72994.00 62322.25 3881. 89 6.2 58440.36 ARKS 95NN 1070945.00 123360.92 11.5 947584.08 146393.97 3175.27 2.2 143218.70 STREET CONSTRCIIMPROVMT 96NN 369100.00 1015.24 .3 368084.76 366233.78 129.28 366104.50 ACTIVITY TOTAL 2782188.00 143150.68 5.1 2639037.32 987200.17 14227.35 1.4 972972.82 TOT A L EXPENDITURES 22163118.00 3122337.29 14.1 19040780.71 18044610.70 2887325.75 16.0 15157284.95 EXCESS <REVENUE>EXPENDITURES 470785.00 766543.91- 162.8- 1237328.91 2820468.03- 267299.65- 9.5 2553168.38- TRANSFERS IN FROM OTHER FUNDS .DO .00 .00 24136.65- .00 24136.65- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 8384.92 .00 8384.92 EXCESS <REVENUE> EXPENDITURE 470785.00 766543.91- 162.8- 1237328.91 2836219.76- 267299.65- 9.4 2568920.11- . GL 1 04C THE CITY OF DUBLIN STATEMENT SH~ING of>AGE 1 10/08/98 REVENUES VERSUS EXPENDITURE 8.47.43 FOR THE PERIOD 7/98 THROUGH 9/98 SPECIAL REVENUE FUNDS . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-O ********REVENUES******* PROPERTY TAXES 76680.00- .00 76680.00- 74722.51- .00 74722.51- SALES TAX 175500.00- 43098.76- 24.6 132401.24- 166074.24- 24445.19- 14.7 141629.05- FINES & FORFEITURES 42400.00- 5930.73- 14.0 36469.27- 30595.76- 6562.42- 21.4 24033.34- USES OF MONEY AND PROPERTY 97330.00- .00 97330.00- 103983.22- .00 103983.22- INTERNGOVERNMENTAL FROM STATE 1486924.00- 205979.87- 13.9 1280944.13- 650748.42- 206277.33- 31.7 444471.09- INTERGOVERNMENTAL FROM COUNTY 145065.00- 28158.00- 19.4 116907.00 - 143024.00- 26511. 00- 18.5 116513.00- INTERGOVERNMENTAL FROM FEDERAL 108203.00- .00 108203.00- 136885.41- .00 136885.41- CHARGES FOR SERVICES 698080.00- .00 698080.00- 715254.01- .00 715254.01- OTHER SOURCES OF REVENUE 139810.00- 14241.00- 10.2 125569.00- 244641.83- .00 244641. 83- TOTAL REVENUE 2969992.00- 297408.36- 10.0 2672583.64- 2265929.40- 263795.94- 11.6 2002133.46- *******EXPENOITURES******* GENERAL GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT .00 .00 .00 175.00 .00 175.00 ACTIVITY TOTAL .00 .00 .00 175.00 .00 175 . 00 PUBLIC SAFETY: POll CE 77844.00 150.00 .2 77694.00 87354.31 471 . 05 .5 86883.26 TRAFFIC SIGNALS 104750.00 4008.32 3.8 100741. 68 80070.46 9152.86 11.4 70917.60 FIRE SERVICES 81745.00 975 . DO 1.2 80770.00 79808.20 2875.00 3.6 76. ACTIVITY TOTAL 264339.00 5133.32 1.9 259205.68 247232.97 12498.91 5.1 234 TRANSPORTATION: STREET MAINTENANCE 245020.00 7114.83 2.9 237905.17 249796.03 26470.28 10.6 223325.75 STREET SWEEPING 90070.00 6815.41 7.6 83254.59 78539.83 5870.76 7.5 72669.07 ACTIVITY TOTAL 335090.00 13930.24 4.2 321159.76 328335.86 32341.04 9.8 295994.82 HEALTH & WELFARE: WASTE MANAGEMENT 859499.00 2275.00 .3 857224.00 740895.48 1205.52 .2 739689.96 SENIOR SUPPORT CARE 7044.00 .00 7044.00 7044.00 .00 7044.00 ACTIVITY TOTAL 866543.00 2275.00 .3 864268.00 747939.48 1205.52 .2 746733.96 CULTURE & LEISURE SERVICES: PARK MAINTENANCE .00 .00 .00 3329.51 .00 3329.51 ACTIVITY TOTAL .00 .00 .00 3428.52 .00 3428.52 COMMUNITY DEVELOPMENT: ENGINEERING 38900.00 41.02 .1 38858.98 56396.92 3826.92 6.8 52570.00 ACTIVITY TOTAL 38900.00 41. 02 .1 38858.98 56396.92 3826.92 6.8 52570.00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 57611.00 167.50 .3 57443.50 233611.81 7103.29 3.0 226508.52 PARKS 185523.00 11788.14 6.4 173734.86 95432.22 29124.64 30.5 66307.58 STREET CONSTRUCTION/IMPROVMT 1068211.00 388394.67 36.4 679816.33 286937.98 4365.74 1.5 282572.24 ACTIVITY TOTAL 1311345.00 400350.31 30.5 910994.69 615982.01 40593.67 6.6 575388.34 TOT A L EXPENDITURES 2816217.00 421729.89 15.0 2394487. 11 1999490.76 90466.06 4.5 1909024.70 EXCESS <REVENUE~EXPENDITURE 153775.00- 124321.53 80.8- 278096.53- 266438.64- 173329.88- 65.1 93108.76- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 9468.29 .00 9468.29 EXCESS <REVENUE> EXPENDITURE 153775.00- 124321.53 80.8- 278096.53- 256970.35- 173329.88- 67.5 83640.47- . GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 10/cfB198 REVENUES VERSUS EXPENDITURE B.53.21 FOR THE PERIOD 719B THROUGH 9/98 . SPECIAL ASSESSMENT FUNDS PREVIOUS YEAR ENDING JUNE 30, 1998 CURRENT PERIOD BUOGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-O ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 254580.00- .00 254580.00- 276342.55- .00 276342.55- USES OF MONEY ANO PROPERTY 10300.00- .00 10300.00- 15890.80- .00 15890.80- OTHER SOURCES OF REVENUE 2000.00- .00 2000_00- 2026.04- .00 2026.04- TOTAL REVENUE 266880.00- .00 266880.00- 294259.39- .00 294259.39- *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRFC SIGSISTREET LIGHTING 130987.00 11462.74 8.8 119524.26 114852.44 7206.99 6.3 107645.45 ACTIVITY TOTAL 130987.00 11462.74 8.8 119524.26 114852.44 7206.99 6.3 107645.45 TRANSPORTATION: PUBLI C WORKS 4229.00 507.88 12.0 3721.12 3578.12 696.97 19.5 2881. 15 STREET TREE MAINTENANCE 9600.00 2304.91 24.0 7295.09 4084.90 164.40 4.0 3920.50 STREET LANDSCAPE MAINTENANCE 128ITO.00 15325.35 11.9 113444.65 103582.99 14991.15 14.5 88591.84 ACTIVITY TOTAL 142599.00 18138.14 12.7 124460.86 111246.01 15852.52 14.2 95393.49 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: tfilNEERING 3980.00 2957.04 74.3 1022.96 3465.00 3465.00 100.0 .00 ACTIVITY TOTAL 3980.00 2957.04 74.3 1022.96 3465.00 3465.00 100.0 .00 AL 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 2IT566.00 32557.92 11.7 245008.08 305617.35 26524.51 8.7 279092.84 EXCESS<REVENUE>EXPENDITURE 10686.00 32557.92 304.7 21871.92- 11357.96 26524.51 233.5 15166.55- EXCESS <REVENUE> EXPENDITURE 10686.00 32557.92 304.7 21871.92- 11357.96 26524.51 233.5 15166.55- . GL104C THE CITY OF DUBLIN STATEMENT SHO~ING "AGE 1 1 0/08/98 REVENUES VERSUS EXPENDITURE 9.10.24 FOR THE PERIOD 7/98 THROUGH 9/98 CAPITAL IMPROVEMENT FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* OTHER SOURCES OF REVENUE 10778637.00- .00 10778637.00- 599893.97- .00 599893.97- TOTAL REVENUE 10778637.00- .00 10778637.00- 599893.97- .00 599893.97- *******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 3080.00 21.2 11420.00 .00 .00 .00 ACTIVITY TOTAL 14500.00 3080.00 21.2 11420.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 8956.59 .9 965927.41 22818.06 2540.44 11. 1 20277.62 COMMUNITY IMPROVEMENTS 94024.00 .00 94024.00 12000.62 .00 12000.62 PARKS 2759725.00 3195.01 .1 2756529.99 86242.07 .00 862. STREET CONSTRUCTION/IMPROVMT 6922809.00 ' 35194.57 .5 6887614.43 419692.52 1740.00 .4 4179 ACTIVITY TOTAL 10751442.00 47346.17 .4 10704095.83 540753.27 4280.44 .8 5364 TOT A L EXPENDITURES 10782168.00 50571.31 .5 10731596.69 544001.85 4280.44 .8 539721.41 EXCESS<REVENUE>EXPENDITURE 3531.00 50571.31 1432.2 47040.31- 55892.12- 4280.44 7.7- 60172.56- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 14668.36 .00 14668.36 EXCESS <REVENUE> EXPENDITURE 3531. 00 50571.31 1432.2 47040.31- 41223.76- 4280.44 10.4- 45504.20- . GL 1 OrC THE CITY OF DUBLIN STATEMENT SHO~ING PAGE 1 10/08/98 REVENUES VERSUS EXPENDITURE 9.18.59 FOR THE PERIOD 7/98 THROUGH 9/98 . TRUST/AGENCY FUND 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 .00 .00 .00 234497.12- .00 234497.12- USES OF MONEY AND PROPERTY .00 1204.33- 1204.33 13568.83- 1737.04- 12.8 11831. 79- TOTAL REVENUE .00 1204.33- . 1204.33 248065.95- 1737.04- .7 246328.91- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL .00 157748.50 157748.50- 232903.25 156154.75 67.0 76748.50 ACTIVITY TOTAL .00 157748.50 157748.50- 232903.25 156154.75 67.0 76748.50 PUBLIC SAFETY: TRANSPORTATION: HEALTH & ~ELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOTAL EXPENDITURES .00 157748.50 157748.50- 232903.25 156154.75 67.0 76748.50 EXCESS(REVENUE)EXPENOITURE .00 156544.17 156544.17- 15162.70- 154417.71 1018.4- 169580.41- EXCESS (REVENUE) EXPENDITURE .00 156544.17 156544.17- 15162.70- 154417.71 1018.4- 169580.41- . . 0; GL 104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 10/08/98 REVENUES VERSUS EXPENDITURE 8.59.36 FOR THE PERIOD 7/98 THROUGH 9/98 . INTERNAL SERVICE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 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- 26970.45- .00 26970.45- CHARGES FOR SERVICES 737923.00- 66269.13- 9.0 671653.87- 241988.51- 61603.61- 25.5 180384.90- OTHER SOURCES OF REVENUE 30000.00- 895.06- 3.0 29104.94- 6782.95- .00 6782.95- TOTAL REVENUE 807527.00- 67164.19- 8.3 740362.81- 275741.91- 61603.61- 22.3 214138.30- *******EXPENOI TURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 728134. 00 40071.23 5.5 688062.77 234194.29 22757.07 9.7 211437.22 ACTIVITY TOTAL 728134.00 40071.23 5.5 688062.77 234194.29 22757.07 9.7 211437.22 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 728134.00 40071 .23 5.5 688062.77 234194.29 22757.07 9.7 211437.22 EXCESS<REVENUE>EXPENOITURE 79393.00- 27092.96- 34.1 52300.04- 41547.62- 38846.54- 93.5 2701.08- EXCESS <REVENUE> EXPENDITURE 79393.00- 27092.96- 34.1 52300.04- 41547.62- 38846.54- 93.5 270. . GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 10/08/98 REVENUES VERSUS EXPENDITURE 9.04.24 FOR THE PERIOD 7198 THROUGH 9/98 . ENTERPRISE FUNDS CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 30, 1998 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* USES OF MONEY AND PROPERTY 1827244.00- 397539.10- 21.8 1429704.90- 1590062.53- 361803.92- 22.8 1228258.61- TOTAL REVENUE 1827244.00- 397539.10. 21.8 1429704.90- 1590062.53- 361803.92- 22.8 1228258.61- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1719394.00 66374.48 3.9 1653019.52 1272423.93 69115.73 5.4 1203308.20 ADMIN SERVICES 3435.00 .00 3435.00 4415.00 1050.00 23.8 3365.00 ACTIVITY TOTAL 1722829.00 66374.48 3.9 1656454.52 1276838.93 70165.73 5.5 1206673.20 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 1722829.00 66374.48 3.9 1656454.52 1276838.93 70165.73 5.5 1206673.20 EXCESS<REVENUE>EXPENDITURES 104415.00- 331164.62- 317.2 226749.62 313223.60- 291638.19- 93.1 21585.41- TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 8384.92- .00 8384.92- EXCESS <REVENUE> EXPENDITURE 104415.00- 331164.62- 317.2 226749.62 321608.52- 291638.19- 90.7 29970.33- . .