Loading...
HomeMy WebLinkAboutItem 4.03 FinRpt Jan 1998 CITY CLERK File # DBJl3J0-~[Q] tt AGENDA STATEMENT CITY COUNCil MEETING DATE: (February 17,1998) SUBJECT: Financial Report For the Month of January 1998 ~ Report Prepared by: Paul S. Rankin, Assistant City Manager ExmBITS ATTACHED: 1. Chart - General Fund Revenues and Budget Comparison 2. Chart - General Fund Expenses and Budget Comparison 3. Balance Sheet and Income Statements for the Period Ending January 3D, 1998 RECOMMENDATION: (j# Accept and file the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. . DESCRIPTION: lbis item provides the report of the monthly [mancial statements for the month of January. The budget changes presented in the Mid Year Financial Report and approved at the City Council meeting on February 3, 1998, are included as part of this financial report. 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 January 1998 Revenue and E:x:penditure Report 1brough the first seven months of the fiscal year the revenue collections and expenses have been tracking similar to the previous fiscal year. Most of the significant deviations are due to timing differences between when events occurred in the two fiscal years. 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 January 1998 approximately 54% of the total budgeted General Fund Revenues, which is slightly higher than the 50% 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 annual sales tax is a result of the Christmas retail season, for which the City will not receive data until March of 1998. . -----------------~------------------------------------------------- COPIES TO: G;\M 01\'TIIFS\FY98\198AG.DOC ITEM NO. 4.7 Real Property Transfer Taxes have increased over the same period in the prior year due to an incr~ase 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. As of January the City had collected $106,589, which is approximately 54% of the Fiscal Year 1997/98 budget for this revenue category. In the prior fiscal year the total collected for the entire year was only $138,062. . 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. Typically building permit revenue does not follow an even distribution. Also, the expenditures associated with performing the inspections do not necessarily fall in the same fiscal year as the permit fee is paid. Interest and Rentals are higher than in the same period in the prior year due to a higher cash balance. The current report is somewhat skewed due to adjustments which will be made at the end of the fiscal year. Initially all interest revenue is recorded in the General Fund. At year end a portion of this revenue is allocated to other funds on a pro rata basis. Intergovernmental revenues are higher than in the same period in the prior year due to an increase in the amount of State Motor Vehicle in Lieu Fees collected to date. Charges for services are lower than in the same period in the prior year as the fees related to planning and engineering services for several projects in Eastern Dublin are expected to be collected later in the Fiscal 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 January expenditures in the General Fund totaled $8,499,938 and represented approximately 47% of the total budgeted expenditures in the General Fund. Of this amount, a total of $468,275 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 January 1997 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of January 30, 1998, the City had expended 47% of the General Fund Operating Budget, compared to 49.5% in the prior Fiscal Year. As previously noted there are some timing differences with payments for contract services, which complicate comparisons between one year to the next. The following analysis identifies the basis for significant deviations: Civic Center Lease expenditures to date are at approximately 93% of the budget compared to 100% in the same period of the prior Fiscal Year. lbis is due to the fact that the City is required to budget the gross debt service payment, even though part of the payment is offset by funds held by the Trustee. As of the January report the City has recorded the full amount of the debt service payment to be made by the General Fund, for Fiscal Year 1997/98. . -;c:- . . . . Other Public Safety expenditures are lower than the same period in the prior year primarily due to a temporary staff vacancy in the Disaster Preparedness Activity and timing differences in the payments for contract Animal Control Services. Due to a delay in billing by the County, the City has not recorded any Animal Control contract expense or Animal Shelter capital payments in Fiscal Year 1997/98. Culture and Community Services is higher than the same period in the prior year primarily due to timing differences in several activities. The Library contract service expense recorded in the current Fiscal Year represents two full payments, whereas in the prior year only one quarterly payment had been processed during the same period. In addition, the Park Maintenance activity included a similar timing difference related to water utility services. Community Development is lower than in the same period in the prior year, as the expenses related to contract Planning and Engineering services for several projects in Eastern Dublin are expected to be incurred later in the Fiscal Year. In addition there were staffmg vacancies for a portion of the 1997/98 Fiscal Year in both Activities. 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. -3- Exhibit 1 ~ 13 City of Dublin 1997-98 YTD Revenues and Budget Comparison For the Period Ending January 31,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 Services --- - ---~ -- .FY 97/98 . FY 96/97 72% Other Revenues 0% 30% 60% 90% 120% 150% 58% of Year Complete 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,482,700 2,380,469 53% 2,221,613 55% Sales Taxes 7,150,000 3,982,726 56% 3,594,379 51% Transient Occupancy Taxes 281,000 132,204 47% 128,069 48% Franchise Taxes 755,000 343,620 46% 314,231 43% Licenses and Permits 1,043,350 755,658 72% 455,245 42% Interest and Rentals 1,428,450 867,010 61% 646,715 47% . Intergovernmental 1,160,620 672,589 58% 607,420 53% Charges for Services 2,175,358 882,821 41% 665,516 48% Other Revenues 457,215 208,685 46% 127,829 47% Total General Fund Revenues 18,933,693 10,225,782 54% 8,761,017 50% 2/6/9B 9;55 g;\monthfs\fy9B\fscolor.xls City of Dublin 1997-98 YTD Expenses and Budget Comparison For tbe Period Ending January 31, 1998 - Unaudited Total General Fund Expenses -- - - - - 47% 50% General Government Civic Center Lease Police Fire Other Public Safety Transportation Health and Welfare Culture & Community Services Community Development Capital Improv. Projects 0% 30% 60% 50% of Year Complete 90% FY 97/98 Budget FY 97/98 YTD Actual General Government Civic Center Lease Police Fire Other Public Safety Transportation Health and Welfare Culture and Community Services Community Development Capital Improvement Projects 1,819,529 1,599,919 4.283,274 3,598,953 283,202 667,372 17,320 2.211,775 2,572,035 1,212,348 915,308 1,493,244 1,105,588 1,937,171 25,374 299,395 5,282 1,082,271 1,168,030 468,275 Total General Fund Expenses 18.265,727 8,499,938 General Fund Operating Expenses 17,053,379 8,031,663 216198 10:02 60% % of Budget 50% 93% 26% 54% 9% 45% 30% 49% 45% 39% 47% 47% FY 96/97 YTD Actual 893.167 1,496,712 960,419 1,610,816 56,118 295.166 6,634 876,174 940,728 624,701 7,760,635 7,135,934 .FY 97/98 . FY 96/97 % of Total for FY 96/97 g:\monthfs\fy98lfscolor .xis Exhibit 2 i /.: . 120% 53% 100% 25% 59% 32% 47% 43% 44% 51% 60%. 50% 50% Jet 13 . CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JANUARY 1998 . Prepared by The Finance Department February 4,1998 . '. EXHIBIT 3 . ltL102 2/04/98 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOO 7/97 THROOGH 1/98 . INTERNAL SERVICE FUND ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOONT 484565.23 INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOONTS TO BE PROVIDED 350034.76 TOTAL ASSETS 834599.99 ~FND BAL, RETND EARNIN~S TS FOR PRIVATE DEVELPMNT JE OSITS OTHERS ~AYABLES:ACCOUNTS INTEREST PAYROLL JUE TO OTHERS lEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES ~UND BALANCE ;ONTR I BUT IONS :NVESTMENTS IN FIXED ASSETS ~ETAINED EARNINGS TOTAL FUND EQUITY 445430.30- 389169.69- 834599.99- 834599.99- 21285388.79- 4066689.17- 18372224.42~ 'OTAL LIAB,FND BAL, RETD EARNS . ENTERPRISE FUNDS FIXED ASSETS GENERAL LONG GROOP OF TERM DEBT ACCOONTS ACCOONT GROUP 1066.56- 1623351.08 46896.00 19616208.27 21285388.79 15535000.00- 15535000.00- 640498.79- 5109890.00- 5750388.79- 4066689.17 4066689.17 4066689.17- 4066689.17- 18372224.42 18372224.42 18372224.42- 18372224.42- 5~/3 PAGE 1 19.22.48 TOT A L S --- MEMORANDUM ONLY --- CURRENT JUNE 3D, 1997 483498.67 1623351. 08 46896.00 24032932.20 18372224.42 44558902.37 33907224.42- 33907224.42- 1085929.09- 5499059.69- 4066689.17- 10651677.95- 300097.63 1733737.80 21045462.27 5327970.26 28407267.96 21592970.26- 21592970.26- 844131.12- 5459961.45- 510205.13- 44558902.37- 28407267.96- 6814297.70- b c6/S GL104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 2/04/98 REVENUES VERSUS EXPENDITURE 18.23.34 FOR THE PERIOD 7/97 THROUGH 1198 . GENERAL REVENUE FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* PROPERTY TAXES 4286000.00- 2273879.87- 53.1 2012120.13- 3920897.29- 2158152.60- 55.0 1762744.69- SALES TAX 7150000.00- 3982n5.64- 55.7 3167274.36- 7108598.19- 3594379.37- 50.6 3514218.82- REAL PROPERTY TRANSFERS 196700.00- 106589.34- 54.2 90110.66- 138062.47- 63459.81- 46.0 74602.66- TRANSIENT OCCUPANCY TAX 281000.00- 132204.00- 47.0 148796.00- 267007.09- 128068.72- 48.0 138938.37- FRANCHISE TAXES 755000.00- 343620.39- 45.5 411379.61- 723384.60- 314230.93- 43.4 409153.67- LICENSES & PERMITS 1043350.00- 755657.83- 72.4 287692.17- 1092182.95- 455244.93- 41.7 636938.02- FINES & FORFEITURES 33200.00- 19301. 74- 58.1 13898.26- 38492.21- 25247.79- 65.6 13244.42- USES OF MONEY AND PROPERTY 1428450.00- 867009.92- 60.7 561440.08- 1388948.66- 646715.14- 46.6 742233.52- INTERGOVERNMENTAL FROM STATE 1160620.00- 672589.05- 58.0 488030.95- 1151275.49- 607419.98- 52.8 543855.51- CHARGES FOR SERVICES 2175358.00- 882821.36- 40.6 1292536.64- 1386418.59- 665515.93- 48.0 720902.66- OTHER SOURCES OF REVENUE 424015.25- 189383.47- 44.7 234631.78- 223207.32- 102580.94- 46.0 120626.38. TOTAL REVENUE 18933693.25- 10225782.61- 54.0 8707910.64- 17438474.86- 8761016.14- 50.2 8677458.72. *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 9215.00 187.40 2.0 9027.60 27346.97 .00 27346.97 CITY CCUNCIL 1010 139834. DO 69414.39 49.6 70419.61 127472.84 80496.53 63.1 46976.31 CITY MANAGER 1020 334487.00 168545.51 50.4 165941.49 291093.65 159021.26 54.6 132072.39 CITY ATTORNEY 1030 234794.00 96495.37 41.1 138298.63 201718.85 91232.46 45.2 11)1 ADMIN SERVICES 1040 637675.00 326477.45 51.2 311197.55 569247.12 318757.66 56.0 250 BUILDING MANAGEMENT 1050 315955.00 152974.09 48.4 162980.91 331517.40 157619.68 47.5 1738 . FACI LITY RENTAL 1050-719 1599919.00 1493243.61 93.3 106675 .39 1496816.41 1496712.41 100.0 104.00 INSURANCE COST CENTER 1060 146803.00 100838.33 68.7 45964.67 122777.83 83260.24 67.8 39517.59 ELECTIONS COST CENTER 1070 766.00 375.91 49.1 390.09 20511.92 2778.38 13.5 1m3.54 ACTIVITY TOTAL 3419448.00 2408552.06 70.4 1010895.94 3188502.99 2389878.62 75.0 798624.37 PUBLI C SAFETY: POLI CE 2010 4283274.00 1105587.70 25.8 3177686.30 3794625.12 960418.78 25.3 2834206.34 CROSSING GUARDS COST 2020 49048.00 18583.34 37.9 30464.66 40926.26 16833.39 41.1 24092.87 ANIMAL CONTROL 2030 200124.00 .00 200124.00 110514.00 21918.00 19.8 88596.00 DISASTER PREAPREDNESS 2050 34030.00 6791.41 20.0 27238.59 25992.10 17366.56 66.8 8625.54 FIRE SERVICES 2060 3598953.00 1937170.74 53.8 1661782.26 2751796.45 1610815.63 58.5 1140980.82 ACTIVITY TOTAL 8165429.00 3068133.19 37.6 5097295.81 6723853.93 2627352.36 39.1 4096501.57 TRANSPORTATION: PUBLIC WORKS I 3010 366732.00 182430.86 49.7 184301.14 319005.00 171134.04 53.6 147870.96 STREET MAINTENANCE 3020 55770.00 2794.43 5.0 52975 .57 31593.44 28894.37 91.5 2699.07 STREET TREE MAINTENANCE 3040 47700.00 11260.11 23.6 36439.89 48375 .71 14120.70 29.2 34255.01 STREET LANDSCAPE MAINT. 3050 197170.00 102909.38 52.2 94260.62 230289.60 81016.90 35.2 149272.70 ACTIVITY TOTAL 667372.00 299394.78 44.9 367977.22 629263.75 295166.01 46.9 334097.74 HEALTH & ~ELFARE: ~ASTE MANAGEMENT 5020 5320.00 .00 5320.00 3595.87 633.50 17.6 2962.37 CHILD CARE 5030 12000.00 5282.06 44.0 6717.94 12000.00 6000.00 50.0 6000.00 ACTIVITY TOTAL 17320.00 5282.06 30.5 12037.94 15595.87 6633.50 42.5 8962.37 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 216994.00 108498.50 50.0 108495.50 205874. DO 51468.50 25.0 154405.50 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 12500.00 10000.00 80.0 2500.00 HERITAGE CENTER 8012 55930.00 28915.61 51.7 27014.39 54291.08 25714.26 47.4 28576.82 DUBLI N CEMETERY 8013 16690.00 7562.96 45.3 9127.04 15749.25 7361.71 46.7 838. . y ctf/3 GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/04/98 REVENUES VERSUS EXPENDITURE 18.47.49 FOR THE PERIOD 7197 THROUGH 1/98 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- 37965.32- 53.1 33534.68- .00 .00 .00 SALES TAX 159300.00- 93820.34- 58.9 65479.66- 152122.48- 86577.98- 56.9 65544.50- FINES & FORFEITURES 25000.00- 14891. 75- 59.6 10108.25- 22506.62- 12003.34- 53.3 10503.28- SPECIAL BENEFITS ASSESSMENTS .00 1262.81- 1262.81 .00 .00 .00 USES OF MONEY AND PROPERTY 78560.00- .00 78560.00- 98044.39- .00 98044.39- INTERNGOVERNMENTAL FROM STATE 740859.00- 370238.42- 50.0 370620.58- 611716.48- 368996.95 - 60.3 242719.53- INTERGOVERNMENTAL FROM COUNTY 141460.00- 54492.00- 38.5 86968.00- 143136.00- 55362.00- 38.7 8m4.00- INTERGOVERNMENTAL FROM FEDERAL 464889.00- 10736.26- 2.3 454152.74- 185082.30- .00 185082.30- CHARGES FOR 'SERVICES 739000.00- 352939.52- 47.8 386060.48- 788267.59- 397368.12- 50.4 390899.47- OTHER SOURCES OF REVENUE 218000.00~ .00 218000.00- 311205.00- 36549.00- 11.7 274656.00- TOTAL REVENUE 2638568.00- 936346.42~ 35.5 1702221.58- 2312080.86- 956857.39- 41.4 1355223.47- ~--EXPENDITURES-----" GENERAL GOVERNMENT ACTIVITIES; ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY; POll CE 93845.00 21594.27 23.0 72250.73 63146.44 757.74 1.2 62388.70 TRAFFIC SIGNALS 108150.00 33196.71 30.7 74953.29 78617.71 29580.90 37.6 49036.81 FIRE SERVICES 75960.00 37965.32 50.0 37994.68 .00 .00 .00 ACTIVITY TOTAL 2n955.00 92756.30 33.4 185198.70 141764.15 30338.64 21.4 111:. TRANSPORTATION; PUBLI C WORKS .00 .00 .00 172.47 .00 STREET MAINTENANCE 208910.00 52427.51 25.1 156482.49 213347.82 49724.45 23.3 163623.37 STREET SWEEPING 80600.00 31158.51 38.7 49441.49 67675.22 31799.54 47.0 35875.68 ACTIVITY TOTAL 289510.00 83586.02 28.9 205923.98 281195.51 81523.99 29.0 199671.52 HEALTH & WELFARE; WASTE MANAGEMENT 808166.00 367987.53 45.5 440178.47 718827.72 19782.25 2.8 699045.47 ACTIVITY TOTAL 808166.00 367987.53 45.5 440178.47 718827.72 19782.25 2.8 699045.47 CULTURE & LEISURE SERVICES; PARK MAINTENANCE .00 .00 .00 7154.10 .00 7154.10 ACTIVITY TOTAL .00 .00 .00 7191.46 .00 7191.46 COMMUNITY DEVELOPMENT; ENGINEERING 88120.00 11712.49 13.3 76407.51 88980.07 22561.47 25.4 66418.60 I ACTIVITY TOTAL 88120.00 11712.49 13.3 76407.51 88980.07 22561.47 25.4 66418.60 CAPITAL IMPROVEMENT PROJECTS; COMMUNITY IMPROVEMENTS 256283.00 102716.76 40.1 153566.24 140454.07 5124.98 3.6 135329.09 PARKS 219102.23 87404.08 39.9 131698.15 443937.09 23129.01 5.2 420808.08 STREET CONSTRUCTION/IMPROVMT 783610.00 33973.07 4.3 749636.93 353418.05 271225.59 76.7 82192.46 ACTIVITY TOTAL 1258995.23 224093.91 17.8 1034901.32 937809.21 299479.58 31.9 638329.63 TOT A L EXPENDITURES 2729791.23 783094.57 28.7 1946696.66 2175768.12 453685.93 20.9 1722082.19 EXCESS <REVENUE~EXPENDITURE 91223.23 153251.85- 168.0- 244475.08 136312.74- 503171.46~ 369. 1 366858.72 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 3395.00 .00 3395.00 EXCESS <REVENUE~ EXPENDITURE 91223.23 153251.85- 168.0- 244475.08 132917.74- 503171.46- 378.6 370253.72 . r ~ /:J . GL104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 2/04/98 REVENUES VERSUS EXPENDITURE 18.55.55 FOR THE PERIOD 7/97 THROUGH 1/98 . 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- 129820.85- 47.3 144586.15- 243986.94- 122270.01- 50.1 121716.93- 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- 129820.85- 44.8 159981.15- 262782.20- 123942.50- 47.2 138839.70- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLI C SAFETY: TRFC SIGS/STREET LIGHTING 121705.00 42988.66 35.3 78716.34 103293.98 30123.02 29.2 73170.96 ACTIVITY TOTAL 121705.00 42988.66 35.3 78716.34 103293.98 30123.02 29.2 73170.96 TRANSPORTATION: PUBLI C WORKS 1300.00 1123.11 132.5 423.11- 4247.66 1737.85 40.9 2509.81 STREET TREE MAINTENANCE 11410.00 1992.26 17.5 9417.74 5697.32 1121.48 19.7 4575.84 STREET LANDSCAPE MAINTENANCE 139420.00 66419.46 47.6 73000.54 138868.81 38081.28 27.4 100787.53 ACTIVITY TOTAL 152130.00 70134.83 46.1 81995.17 148813.79 40940.61 27.5 107873.18 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: 4111jr"'ITY 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 31815.00 7815.00 24.6 24000.00 16488.87 8067.92 48.9 8420.95 STREET CONSTRUCTION/IMPROVMT 47438.00 45000.00 94.9 2438.00 103000.00 103106.75 100.1 106.75- ACTIVITY TOTAL 79253.00 52815.00 66.6 26438.00 119488.87 111174.67 93.0 8314.20 TOT A L EXPENOITURES 35m8.0O 169403.49 47.4 188334.51 374782.60 185261.74 49.4 189520.86 EXCESS<REVENUE~EXPENDITURE 67936.00 39582.64 58.3 28353.36 112000.40 61319.24 54.7 50681.16 EXCESS <REVENUE> EXPENDITURE 67936.00 39582.64 58.3 28353.36 112000.40 61319.24 54.7 50681.16 . GL104c THE CITY OF DUBLIN STATEMENT SHOWING /0 rf" /S . PAGE 2/04/98 REVENUES VERSUS EXPENDITURE 19.11.5. FOR THE PERIOD 7/97 THRlXJGH 1/98 CAPITAL IMPROVEMENT FUND . CURRENT PERIOD PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T.D ........REVENUES....... OTHER SOURCES OF REVENUE 2889412.00. 51796.03- 1.8 2837615.97- 328497.84. 70429.55- 21.4 258068.29- TOTAL REVENUE 2889412.00. 51796.03- 1.8 2837615.97- 328497.84- 70429.55- 21.4 258068.29- .......EXPENDITURES....... GENERAL GOVERNHENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLI C SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: PLANNING 12850.00 .00 12850.00 .00 .00 .00 ACTIVITY TOTAL 12850.00 .00 12850.00 .00 .00 .00 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 100000.00 17421.55 17.4 82578.45 12823.75 5938.75 46.3 6885.00 COMMUNITY IHPROVEMENTS 42063.00 9640.00 22.9 32423.00 .00 .00 .00 PARKS 247410.00 18005.34 7.3 229404.66 .00 .00 .00 STREET CONSTRUCT I ON/I MPROVMT 2515167.00 60830.00 2.4 2454337_00 449732.20 251826.36 56.0 197905.84 ACTIVITY TOTAL 2904640.00 105896.89 3.6 2798743.11 462555.95 2Sn65.11 55.7 204. TOT A L EXPENDITURES 2917490.00 105896.89 3.6 2811593.11 462555.95 25n65.11 55.7 204 EXCESS<REVENUE>EXPENDITURE 28078.00 54100.86 192.7 26022.86- 134058.11 187335.56 139.7 532n.45- TRANSFERS OUT TO OTHER FUNDS .00 10785.46 10785.46- 1682.54 .00 1682.54 EXCESS <REVENUE> EXPENDITURE 28078.00 64886.32 231.1 36808.32- 135740.65 187335.56 138.0 51594.91- . Gl104C THE CITY OF DUBLIN STATEMENT SHOWING //~/J PAGE 1 2/04/98 REVENUES VERSUS EXPENDITURE 19.17 .06 FOR THE PERIOD 7/97 THROUGH 1/98 . TRUST/AGENCY FUND 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 .00 11n48.56- 117248.56 236036.28- 117654.79- 49.8 118381.49- USES OF MONEY AND PROPERTY .00 3479.31- 3479.31 11962.96- 2690.94- 22.5 92n.02- TOTAL REVENUE .00 120n7.87- 120n7.87 247999.24- 120345.73- 48.5 127653.51- *******EXPENDI TURES******* 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 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: 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)EXPENDI TURE .00 35426.88 35426.88- 15529.74- 32969.02 212.3- 48498.76- EXCESS (REVENUE) EXPENDITURE .00 35426.88 35426.88- 15529.74- 32969.02 212.3- 48498.76- . . I' I /) /;:3 I GL104C THE CITY OF DUBLIN STATEMENT SHOWING ""u PAGE. 1 2/04/98 REVENUES VERSUS EXPENDITURE 19.02.00 FOR THE PERIOD 7/97 THROUGH 1/98 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****.** USES OF MONEY AND PROPERTY 13750.00- .00 13750.00- 18137.65- .00 18137.65- CHARGES FOR SERVICES 243411.00- 141699.95- 58.2 101711.05- 211049.81- 119791.47- 56.8 91258.34- OTHER SOURCES OF REVENUE 500.00- 5o.oo~ 10.0 450.00- 21901.75- 1122.70- 5.1 20779.05- TOTAL REVENUE 257661.00- 141749.95- 55.0 115911.05- 251089.21- 120914.17- 48.2 130175.04~ *".***EXPENDITURES.*****. GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 266250.00 61611.41 23.1 204638.59 262014.45 94900.17 36.2 167114.28 ACTIVITY TOTAL 266250.00 61611.41 23.1 204638.59 262014.45 94900.17 36.2 167114.28 PUBLIC SAFETY: TRANSPORT A TI ON: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 266250.00 61611.41 23.1 204638.59 262014.45 94900.17 36.2 167114_28 EXCESS<REVENUE>EXPENDITURE 8589.00 80138.54- 933.0- 88727.54 10925.24 26014.00- 238. 1 - 36939.24 EXCESS <REVENUE> EXPENDITURE 8589.00 80138.54- 933.0- 88727.54 10925.24 26014.00- 238.1- 3693. . pL t04c . /J6'6/-2 1 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2/04/98 REVENUES VERSUS EXPENDITURE 19.06.49 FOR THE PERIOO 7/97 THROUGH 1/98 . 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- 1494471.40- 87.5 213792.60- 1592321.83- 1555895.19- 97.7 36426.64- TOTAL REVENUE 1708264.00- 1494471.40- 87.5 213792.60- 1592321.83- 1555895.19- 97.7 36426.64- *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1599939.00 1248826.32 78.1 351112.68 1314726.23 1231286.22 93.7 83440.01 ADMIN SERVICES 4260.00 1050.00 24.6 3210.00 4194.20 1000.00 23.8 I 3194.20 ACTIVITY TOTAL 1604199.00 1249876.32 77.9 354322.68 1318920.43 1232286.22 93.4 86634.21 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 1604199.00 1249876.32 77.9 354322.68 1318920.43 1232286.22 93.4 86634.21 EXCESS<REVENUE>EXPENDITURES 104065.00- 244595.08- 235.0 140530.08 273401.40- 323608.97- 118.4 50207.57 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 4211.16': .00 4211.16- EXCESS <REVENUE> EXPENDITURE 104065.00- 244595.08- 235.0 140530.08 277612.56- 323608.97- 116.6 45996.41 . .