The URL can be used to link to this page

Home My WebLink About4.03 PrelimFinRpt 6-97 .. CITY CLERK File # nl3J[3l[(iJ-~lQ] . AGENDA STATEMENT CITY COUNCIL MEETING DATE: (September 16,1997) SUBJECT: Preliminary Financial Report For the Month of July 1997 rrJv Report Prepared by: Paul S. Rankin, Assistant City Manager EXHIBITS ATTACHED: Pro Forma Balance Sheet and Income Statements for the Period Ending July 31, 1997 RECOMMENDATION: l!v"ry{ccept and file 1he reports. . FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the preHminary financial statements for the month of July. The reason that the report is presented as "preHminary" is that the final audited results of Fiscal Year 1996/97 are not yet available. Consistent with prior reports the focus will be on General Fund Revenues and Expenditures, which represent the most significant portion of the City's operations. Preliminarv ReDortin2 of Information . The auditors have just begun the :final phase of their field work necessary for the 1996/97 audit. The:final audit results will impact the reported Fund Balance presented in the attached monthly reports. For example, any General Fund Revenues which exceeded the 1996/97 expenditures have not been carried forward to the 1997/98 Fund Balance. The computer program used by the City requires that all posting entries to the prior year be complete, prior to posting the change in fund balance. Staff anticipates the :final entries will occur by the October report, including the :final year end accrual entry for Sales Tax. In addition, there are some expense accruals which have not been posted to Fiscal Year 1996/97 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. Analvsis ofPreliminarv Julv 1997 Revenue and Expenditure ReDort Given that this is only the first month of the 1997/98 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 1997 approximately 4% of the total budgeted General Fund Revenues compared to approximately 5% in the prior Fiscal Year. Licenses and Permits are lower than in the same period in the prior year due to the issuance of several building permits ------------------------------------------------------------------- COPIES TO: G:\MONTHFS\F'\'98'10797 AG.DOC ITEM NO. 4., for the California Highlands project in the previous year. Other revenues are higher than in the same period in the prior year due to an increase in the equity distribution payment received from ABAG. Although this report does not typically focus on Special Revenue Funds, the impact of State Budget deliberations is worth noting. In Fiscal Year 1996/97 the City collected approximately $69,740 in Special . Revenues in the month of July. In the cunent Fiscal Year the City received less than $12,000 in the first month. lIDs was due to the fact that the State is not authorized do distribute certain revenues if a State Budget has not been adopted. With action by the Legislature in August the remittance of these fimds has now begun. 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,003,450 and represented approximately 6% of the total budgeted expenditures in the General Fund. Of this amount, a total of $131 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 1997 was comparable to the amounts expended for the same period in the prior Fiscal Year. As of July 31, 1997, the City had expended 6% of the General Fund Operating Budget compared to 5% 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. 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 1997-98 YTD Revenues and Budget Comparison For the Period Endin July 31, 1997- Unaudited Total General Fund 4% . Revenues 5% Property Taxes 0010 0% Sales Taxes 7% 7% Transient 0% Occupancy Taxes 0% .FY 97/98 I Franchise Taxes 0% . FY 96/97 0% I Licenses and Permits 4% I 12% I I Interest and Rentals 0% 1% . Intergovernmental from State Other Revenues % Charges for Services 0% 30% 60% 90% 8% of Year Complete 120% 150% FY 97/98 FY 97/98 %of FY96197 % of Total for Budget YTD Actual Budget YTD Actual FY 96/97 Property Taxes 4,407,700 0 0% 0 0% Sales Taxes .6,850,000 479,700 7% 456,100 7% Transient Occupancy Taxes 231,000 0 0% 0 0% Franchise Taxes 750,500 0 0% 0 0% Ucenses and Pennits 1,043,350 37,604 4% 127,800 12% Interest and Rentals 1,328,450 6,616 0% 9,915 1% Intergovernmental 1,171,620 0 0% 85,616 7% Charges for Services 1,631,918 83,488 5% 56,135 4% . Other Revenues 487,500 114,773 24% 54,808 20% Total General Fund Revenues 17,902,038 722,180 4% 790,374 5% 8l29I97 18:26 g:ImOI'lIhfs'lfy98\ts.xls I City of Dublin 1997-98 YTD Expenses and Budget Comparison For the Period Ending July 31, 1997 - Unaudited Police ~ I I Total General Fund Expenses General Government Civic Center Lease Fire Other Public Safety 0% 1% .FY 97/98 . FY 96/97 Transportation . 4% 3% Health and Welfare Culture & Community Services Community Development 3% 3% Capital Improv. Projects 0% 0% ,. 0% 30% 60% 8% of Year Complete 90% 120% FY 97198 FY 97198 %of FY 96197 % of Total for Budget YTD Actual Budget YTD Actual FY 96197 General Government 1,808,378 152,5n 8% 133,642 8% Civic Center Lease 1,599,919 361,627 23% 376,881 25% Police 4,280,674 23,392 1% 12,471 0% Fire 3,598,953 296,150 8% 0 0% Other Public Safety 276,880 62 0% 1,595 1% Transportation 667,372 12,786 2% 13,139 2% Health and Welfare 17,320 0 0% 0 0% Culture and Community Services 2,119,950 82,009 4% 64,070 3% Community Development 2,266,885 74,847 3% 59,910 3% Capital Improvement Projects 1.131,051 131 0% 1,857 0% 4%. Total General Fund Expenses 17,767,382 1.003,581 6% 663.564 General Fund Operating Expenses 16,636.331 1,003,450 6% 661,707 5% 8I29If17 16;31 g:\monthfslfyllBlfula ^ . . . .'. . ... CITY OF DUBLIN'S PRO FORMA FINANCIAL STATEMENTS FOR THE MONTH OF JULY 1997 Prepared by The Finance Department August 28, 1997 j EXHIBIT 1 GL1 02 0/28/97 ASSETS CASH CASH WITH FISCAL AGENT UHAMORTI ZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIOED TOTAl ASSETS LIAS, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVElPMNT JEPOSITS FOR AB1600 FEES JEPDSITS OTHERS :>AYABLES:ActOUNTS INTEREST PAYROLL )UE TO DTIERS )EBT INSTRUMENTS PAYABLE TOTAl lIABIlTIES =UND BALANCES TOTAl FUND EQUITY GENERAL REVENUE FUNDS CITY OF DUBLUI BALANCE SHEET FOR THE PERIOD 7/97 THROUGH 7/97 SPECIAL REVENUE FUNDS 4029599.52- 1m735.46 27680177.42 345585.07 356.98 20093.41- 6376.05 23982802.59 472499.88- 470503.89- 408405. 75~ 1171.82- 1352581.34- 22630221.25- 22630221.25- 21596.01 1795331.47 313475.4B- 313475 .48- 1481855.99- 1481855.99- .OTAL LIAS, FHD BAL, RETll EARNS 23982802.59- 1795331.47- 'I SPECIAL ASSESSMENT FUNDS 339148.94 339148.94 46744_96- 46744.96~ 292403_98~ 292403.98- CAPITAL IMPROVEMENT FUNDS 1685333.95 98536.69 1783870.64 2204708.65- 98536.69- 9424_07- 2312669.41- 528798.77 528798.77 TRUST I AGENCY FUND 173892.54 135920.94 2090500.00 2400313.48 2208000.00- 2208000.00- 192313.48- 192313.4S- 339148.94- 1783870.64- 2400313.48- PAGE 1 14.08.06 . TOTALS MEMORANDUM ONLY --- CURRENT JUNE 3D, 1997 57488.63- 135920.94 27680177.42 444121.76 356.98 1502.60 6376.05 2090500.00 30301467.12 472499.88- 2204708.65- 569040.58- 778050.26- 1171.82- 2208000.00- 6233471.19- 24067995.93- 24067995.93- 67216.84- 129917.22 24268006.89 74334.65 832225 . 03 107209.14 30957.72 406140.56 4332.75 2090500.00 27876407. 178055.84- 210m.11- 556209_72- 1623084:'25~- 5957.33 477.50- 2208000.00- 4770103.09- 23106304.03- 23106304.03- 30301467.12- 27876407.12- . G~1(j2 8/28/97 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7197 THROUGH . INTERNAL SERVI CE FUND ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 420930.01 INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS CNET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOONTS TO BE PROVIDED 4511B7.86 TOTAL ASSETS .FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL lIABILITIES FUND BALAN::E CONTRIBUTIONS INVESTMENTS IN fIXED ASSETS RETAINED EARNINGS TOTAL fUND EQUITY 672117.87 522046.42. 350071.45- 872117.87. EtlTERPRISE fUNDS 4211.16. 1682518.55 1%16208.27 2i294515.66 15919421.35- 15919421.35. 265204.31- 5109890.00- 872117.87- 21294515.66- 5375094.31- TOTAL LIAB,FND BAl, RElll EARNS . ~ 7197 FIXED ASSETS GENERAL lONG GROUP OF TERM DEBT ACCOUNTS ACCOUNT GROUP 510205.13 510205.13 510205.13- 510205.13- 5327970.26 5327970.26 5327970.26- 5327970.26- 510205.13- 5327970.26- PAGE 1 11.00.36 TOT A L S MEMORANDUM ONLY --- CURRENT JUNE 3D, 1997 416718.85 1682518.55 20577601.26 5327970.26 28004808.92 21247391.61. 21247391.61- 787250.73- 5459961.45- 510205.13- 6757417.31- 280308.09 1719013.14 21045462.27 5327970.26 28372753.76 588.78- 21592970.26' 21593559.04- 809028.14- 5459961.45- 510205.13- 28004808.92- 28372753.76- 6779194.72- GL104C THE CITY OF DUBLIH STATEMEHT SH~IHG PAGE " 6/28/97 REVENUES VERSUS EXPEHDITURE 9.02.1' FOR THE PERIOO 7/97 THROUGH 7/97 . GENERAL REVENUE FUND CURREHT PERIOO PREVIOUS YEAR ENDIHG JUHE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ...."'.REVENUES******* PROPERTY TAXES 4286000.00- .00 4286000.00- 3876823.33- .00 3876823.33- SALES TAX 6850000.00- 479700.00- 7.0 6370300.00- 6570433.37- 456100.00- 6.9 6114333.37. REAL PROPERTY TRANSFERS 121700.00- .00 121700.00- 114533.84' .00 114533.s.; . TRANSIENT OCCUPANCY TAX 231000.00- .00 231000.00- 237681.09' .00 237681.09- FRANCH I SE TAXES 750500.00- .00 750500.00- 723384.60. .00 723384.60. LICENSES & PERMITS 1043350.00. 37603.52- 3.6 1005746.48- 1092182.95- 127799.99- 11.7 964382.96- FINES & FORFEITURES 33200.00. 4621.88- 13.9 28578.12' 38492.21- 2753.56- 7.2 35738.65. USES OF MONEY AND PROPERTY 1328450.00' 6616.42- .5 1321833.58' 1374024.07- 9914.65- .7 1364109.42' INTERGOVERNMENTAL FROM STATE 1171620.00- .00 1171620.00- 1151275 .49- 85615.60' 7.4 1065659.89. INTERGOVERNMENTAL FROM FEDERAL .00 .00 .00 974.00- .00 974.00. CHARGES FOR SERVICES 1631918.00- 83487.71 - 5.1 1548430.29- 1339422.90. 56135.04- 4.2 1283287.86' OTHER SOORCES OF REVENUE 454300.00- 110150.67- 24.2 344149.33- 232207.32- 52054.68- 22.4 180152.64. TOTAL REVENUE 17902038.00- 722180.20- 4.0 17179857.80- 16751435.17- 790373.52- 4.7 15961061.65. .......EXPENDITURE~~.-~-.. GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 48564.00 .00 48564.00 27346.97 .00 27346.97 CITY CWNCn 1010 137334.00 9452.48 6.9 127881.52 12747.2.84 8327.90 6.5 119144. CITY KANAGER 1020 334487.00 18380.52 5.5 316106.48 288443.65 15302.64 5.3 273141 CITY ATIORNEY 1030 186794.00 .00 186794.00 201718.85 .00 201718. ADMIN SERVICES 1040 637675 . 00 33859.29 5.3 603815.71 565808.19 27119.70 4.8 538688.49 BUILDING MANAGEMENT 1050 315955.00 2032.52 .6 313922.48 329127.11 2680.14 .8 326446.97 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 88852.38 60.5 57950.62 118766.13 80212.09 67.5 38554;04 - ELECTIONS COST CENTER 1070 766.00 .00 766_00 20511.92 .00 20511.92 ACTIVITY TOTAL 3408297.00 514204.05 15.1 2894092.95 3176012.07 510523 .02 16.1 2665489.05 "UBLIC SAFETY: POll CE 2010 4280674.00 23392.10 .5 4257281.90. 3790901.92 12471. 1 0 .3 3778430.82 CROSSING GUARDS COST 2020 42726.00 .00 42726.00 40926.26 .00 40926.26 AN I MAL CONTROL 2030 200124.00 .00 200124.00 110514.00 .00 110514.00 DISASTER PREAPREDNESS 2050 34030.00 62.43 .2 33967.57 25992.10 1594.56 6.1 24397 .5~ FIRE SERVICES 2060 3598953. DO 296149.85 8.2 3302803. 15 2539957.33 .00 2539957.33 ACTIVITY TOTAL 8156507.00 319604.38 3.9 1836902.62 6508291.61 14065.66 .2 64 94225 . 95 fRANSPORTATION: PUBLI C J.OU::S 3010 366732. DO 12785.56 3.5 353946.44 319005.00 13139.32 4.1 305865.68 STREET MAINTENANCE 3020 55770.00 .00 55770.00 29045.29 .00 29045.29 - . STREET TREE MAINTENANCE 3040 47700.00 .00 47700.00 48375.71 .00 48375.71 STREET LANDSCAPE MAINT. 3050 197170.00 .00 197170.00 213134.19 .00 213134.19 :. ACTIVITY TOTAL 667372.00 12785.56 1.9 654586.44 609560.19 13139.32 2.2 596420.87 iEALTH & \.IELFARE: -. WASTE MANAGEMENT 5020 5320.00 .00 5320.00 3595 .87 .00 3595.87 . . CH I III CARE 5030 12000.00 .00 12000.00 12000.00 .00 12000.00 .. ACTI VITY TOTAL 17320.00 .00 17320.00 15595.87 .00 15595.87 :ULTURE & L=ISURE SERVICES: LIBRARY SERVICES 8010 216994.00 . .00 216994.00 205874.00 .00 205874.00 CULTURAL ACTIVITIES 8011 10000.00 10000.00 100.0 .00 15000.00 .00 15000. HER IT AGE CENTER 8012 55930.00 1710.14 3.1 54219.86 54241.01 596.56 1.1 53644 b GL 1 04C THE CJTY OF DUBLJN STATEMENT SHOWJNG PAGE 2 8[28[97 REVENUES VERSUS EXPENDJTURE 9.02.11 FOR THE . PERJOD 7[97 THRCXJGH 7[97 GENERAL REVENUE FUND CURRENT PERJOD PREVJCXJS YEAR ENDJNG JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARJANCE FJSCAL YR Y-T-D DUBLIN CEMETERY 8013 16690.00 .00 16690.00 15661.93 .00 15661.93 PARI:: MAIIlTENANCE 8020 589455.00 .00 589455.00 545079.21 .00 545079.21 COMMUNI7Y CABLE TV 8030 37051-.00 .00 37051.00 34256.72 .00 34256.72 RECREATION ADMJN. 8040 256353.00 13419.71 5.2 242933.29 234707.54 10869.22 4.6 223838.32 PLAYliRCUlDS 8045 128003.00 8465.55 6.6 119537 .45 108257.69 9335 . 05 8.6 98922.64 SHANNON teNTER 8050 148006.00 4471. 14 3.0 143534.86 136213.43 4078.57 3.0 132134.86 PRESCHOOL 8055 54333.00 2707.19 5.0 51625.81 51629.57 2676.43 5.2 48953.14 TEENS J>ROGRAM 8060 35296.00 736.40 2.1 34559.60 25445.93 973.73 3.8 24472.20 ADULT SPORTS 8065 65350.00 2404.46 3.7 62945.54 60649.87 1933.86 3.2 58716.01 YOUTH SPORTS 8066 52406.00 3313.71 6.3 49092.29 39910.77 1915.09 4.8 37995.68 SPECIAL EVENTS 8070 42042.00 1495.77 3.6 40546.23 40133.97 1366.71 3.4 38767.26 SEN J OR teNTER 8080 104221.00 3031.13 2.9 101189.87 80392.97 4414.84 5.5 75978.13 RECREATION INSTRUCTION 8090 88555.00 14518.02 16.4 74036.98 89684.89 3000.10 3.3 86684 .79 AQUATICS 8100 219265.00 15735.67 7.2 203529.33 209946.85 22909.49 10.9 187037.36 ACTIVITY TOTAL 2119950.00 82008.89 3.9 2037941.11 1947086.35 64069.65 3.3 1883016.70 COMMUNJ7Y DEVELOPMENT: PLANNING 9010 744971.00 31223.90 4.2 713747.10 659308.79 30685 .97 4.7 628622.82 BUILDING SAFETY 9020 593826.00 6504.28 1.1 587321 .72 386171.15 7063.40 1.8 379107.75 ENGINEERING 9030 781875.00 32322.22 4.1 749552.78 620566.91 17090.89 2.8 603476.02 .rJ4I C DEVELOPMENT 9040 146213.00 4796.22 3.3 141416.78 106871.69 5069.24 4.7 101802.45 ACTIVITY TOTAL 2266885.00 74846.62 3.3 2192038.38 1m918.54 59909.50 3.4 1713009.04 L IMPROVEMENT PROJECTS: GENERAL tIP PROJECTS 93NN 560350.00 .00 560350.00 80137.74 .00 80137.74 COMMUNI7Y IMPROVEMENTS 94NN 66000.00 .00 66000.00 51681.62 ,.00 51681.62 PAR~ 95NN 192140.00 131.20 .1 192008.80 497423.22 1857.28 .4 495565.94 STREET OJNSTRCIIMPROVMT 96NN 312561.00 .00 312561.00 409250.39 .00 409250~39~ ACTIVI7Y TOTAL 1131051.00 131.20 1130919.80 1038492.97 1857.28 .2 1036635.69 lOT A L EXPENDITURES 17767382.00 1003580.70 5.6 16763801.30 15067957.60 663564 .43 4.4 14404393.17 EXCESS UR-~NUE>EXPENOITURES 134656.00- 281400.50 209.0. 416056.5o~ 1683477.57- 126509.09- 7.5 1556668.48- TRANSFERS IN FRrJ4 OTHER FUNDS .00 .00 .00 2097. DO. .00 2097.00- EXCESS tR:-vENUE> EXPENDITURE 134656.00- 281400.50 209.0- 416056.50- 1685574.57. 126809.09- 7.5 1558765.48- . 1 GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 8/28/97 REVENUES VERSUS EXPENDITURE 13.36.02 FOR THE PERIOD 7197 THROUGH 7/97 . SPECIAL REVENUE FUNDS CURRENT PERlOO PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FI SCAL YR Y-T~D .......6REVENUE~** :>ROPERTY TAXES 71500.00- .00 71500.00- .00 .00 .00 >ALES TAX 159300-.00- 10476.56~ 6.6 148823 .44- 152122.48- 9626.99- 6.3 142495.49- "INES & FORFEITURES 25000.00- .00 25000.00- 22506.62- 2105.03- 9.4 20401.59- JSES OF MONEY AND PROPERTY 78560.00- .00 7856o.o0~ 98044 .39- .00 98D44 .39- iNTERNGOVERNMENTAL FROM STATE 740859.0o~ 134/..71- .2 739514.29- 606015.48- 46614.52- 7.7 559400.96- :NTERGOV:ERNMENTAL FROM COUNTY 141460.00- .00 141460.00- 143136.00- .00 143136.00- INTERGOVERNMENTAL FROM FEDERAL 464889.00- .00 464889.00- 89148.90- .00 89148.90- :HARGES FOR SERVI CES 739000.00~ .00 739000.00- 780801.05- .00 780801.05- lTHER stlJRCES OF REVENUE 218000.00- .00 218000.00- 311205.00- 11394.00- 3.7 299811.00- TOTAL REVENUE 2638568.00- 11821.27- .4 2626746.73- 2202979.92~ 69740.54- 3.2 2133239_38- ----EXPENDITURES-- ;ENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 UBLl C SAFETY: POll Cf 93845.00 .00 93845.00 63146.44 .00 63146.44 TRAFFIC SIGNALS 108150.00 .00 108150.00 78617.71 .00 78617.71 FIRE SERVICES OF THE JPA 75960.00 .00 75960.00 .00 .00 .00 ACTIVITY TOTAL 277955.00 .00 277955.00 141764.15 .00 141764.. RANSPDRT A TI OH: PUBLIC ~S .00 .00 .00 24.47 .00 24.47 STREET MAINTENANCE 208910.00 .00 208910.00 215895.97 ._00 215895.97 STREET SliEEPING 80600.00 .00 80600.00 67675.22 .00 67675.22 ACTIVITY TOTAL 289510.00 .00 289510.00 283595.66 .00 283595.66 __ :AL TH & WELFARE: WASTE MANAGEMENT 808166.00 15.00 808151.00 718827.72 .00 718827.72 ACTIVITY TOTAL 808166.00 15.00 808151.00 718827.72 .00 718827.72 JLTURE & 1..EISURE SERVICES: PARle MAINTENANCE .00 .00 .00 7154.10 .00 7154.10 ACTIVITY TOTAL .00 .00 .00 7191.46 .00 7191.46 ~NITY DEVELOPMENT: ENGINEERING 88120.00 606.30 .7 87513.70 88980.07 1269.64 1.4 87710.43 ACTIVITY TOTAL 88120.00 606.30 .7 87513.70 88980.07 1269.64 1.4 87710.43 ,PITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 241447.00 1147.10 .5 240299.90 140364.57 .00 140364.57 PARKS 191902.00 1549.60 .8 190352.40 443802.84 .00 443802.84 STREET CDNSTRUCTIDN/IMPROVMT 766610.00 .00 766610.00 336274.66 6370.19 1.9 329904.47 ACTIVITY TOTAL 1199959.00 2696.70 .2 1197262.30 920442.07 6370.19 .7 914071.88 o TAL EXPENDITURES 2670755.00 3318.00 .1 2667437.00 2160801.13 7639.83 .4 2153161.30 CESS rREVENUE>EXPENDITURE 32187.00 8503.27- 26.4- 40690.27 42178.79- 62100.71- 147.2 19921.92 ANSFERS OUT TO OTHER FUNDS .00 .00 .00 2097.00 .00 2097.00 CESS IREVENUE> EXPENDITURE 32187.00 8503.27- 26.4- 40690.27 40081. 79- 62100.71- '54.9 22018.92 . ~ GL 1 04C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 8/28/97 REVENUES VERSUS EXPENDITURE 13.13.19 FOR THE . PERla> 7/97 THRCllGH 7/97 SPECIAL ASSESSMENT FUNDS c:LlRRENT PER I 00 PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y~T~D ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 274407.00. .00 274407.00~ 242789.85~ .00 242789.85- USES OF MONEY AND PROPERTY 13395.00. .00 13395. OO~ 18795.26~ .00 18795.26- OTHER SOURCES OF REVENUE 2000.00' .00 2000.00. .00 .00 .00 TOT Ai REVENUE 289802.00~ .00 289802.00~ 261585.11' .00 261585.11~ ~~~~"'EXPENDITURES******* GENERAl GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 pUBLIC SAFETY: TRFe SIGS/STREET LIGHTING 121705.00 1000.00 .8 120705.00 103264.91 1000.00 1.0 102264.91 ACTIVITY TOTAL 121705.00 1000.00 .8 120705.00 103264.91 1000.00 1.0 102264.91 TRANSPORT A TI ON: PUBLIC WRI::S 1300.00 154.18 11.9 1145.82 4240.27 127.63 3.0 4112.64 STREET TREE MAINTENANCE 11410.00 .00 11410.00 5697.32 .00 5697.32 STREET LANDSCAPE MAINTENANCE 139420.00 .00 139420.00 118256.51 .00 118256.51 ACTIVITY TOTAL 152130.00 154.18 .1 151975.82 128194.10 127.63 .1 128066.47 HEALTH & WELFARE: ~ & LEISURE SERVICES: ITY DEVELOPMENT: INEERING 4650.00 750.00 16.1 3900.00 3193.35 .00 3193.35 ACTIVITY TOTAL 4650.00 750.00 16.1 3900.00 3193.35 .00 3193.35 CAPITAL IMPROVEMENT PROJECTS: CClMJNITY IMPROVEMENTS 24000.00 .00 24000.00 16488.87 .00 16488.87 STREET CONSTRUCTION/IMPROVMT 45000.00 .00 45000.00 103000.00 .00 1 03000~ oq . ACTIVITY TOTAL 69000.00 .00 69000.00 119488.87 .00 119488.87 TOT A L EXPENDITURES 347485.00 1904.18 .5 345580.82 354141.23 1127.63 .3 353013.60 EXCESS IREVENUE>EXPEND I TURE 57683.00 1904.18 3.3 55778.82. 92556.12 1127.63 1.2 91428.49 EXCESS [fL;=veNUE> EXPENDITURE 57683.00 1904.18 3.3 5577B.82 92556.12 1127.63 1.2 91428.49 . 1 GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE , 8(28/97 REVENUES VERSUS EXPENDITURE B.40.45 FOR THE PER I 00 7/97 THROOGH 7/97 . CAPITAL IMPROVEMENT FUND CURRENT PERloo 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 .00 .00 .00 32293.87. .00 32293.87. OTHER SOURCES OF REVENUE 288941;!'.00- .00 2889412.00- 70429.55- .00 70429.55- TOTAL REVENUE 2889412.00- .00 2889412.00- 102723.42- .00 102723.42- ~**EXPENDITURES.&&.... GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULlURE & LEISURE SERVICES: RECREATION ADMINISTRATION .00 .00 .00 3250.00 .00 3250.00 ACTIVITY TOTAL .00 .00 .00 3250.00 .00 3250.00 COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 100000.00 .00 100000.00 9573.75 .00 9573 .75 CCMfUNITY IMPROVEMENTS 19000.00 .00 19000.00 .00 .00 .00 PARKS 239460.00 .00 239460.00 .00 .00 .00 STREET CONSTRUCTIDN/IMPROVMT 2515167.00 .00 2515167.00 449732.20 2055.15 .5 4476. ACTIVITY TOTAL 2873627.00 .00 2873627.00 459305.95 2055.15 . .4 45725 TOT A L EXPENDITURES 2813627.00 .00 2873627.00 462555.95 2055~15 .4 460500.80 EXCEss~NUE>fXPENDITURE 15785.00- .00 15785.00- 359832.53 2055.15 .6 357777.38 EXCESS [REVENUE> EXPENDllURE 15785.00- .00 15785.00- 359832.53 2055.15 .6 357777.38 : .' /0 . ~- . -' -.. . .... .....-. .....: - ~ _-r... . -r -:. ~..' ...... . Gl104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 8/ZB/97 REVENUES VERSUS EXPENDITURE 10.14.59 fOR THE . PERIOO 7/97 THROUGH 7/97 TRUST/AGENCY fUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997 BWGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE fISCAL YR Y-T-D .6_~.....REVENUE~~..66.. ,SPECIAL BENEfITS ASSESSMENTS .00 .00 .00 236036.28- .00 236036.28- 'USES Of tDIEY AND PROPERTY ..00 .00 .00 11496.84- .00 11496.84- ! TOTAL REVENUE .00 .00 .00 247533.12- .00 247533.12- ~ -EXJ>ENl)ITURES6 6 6 6 ...... GENERAL GOVERNMENT ACTIVITIES ~ NON-DEPARlMENTAL .00 .00 .00 232469.50 .00 232469.50 ! ACTIVITY TOTAL .00 .00 .00 232469.50 .00 232469.50 ;PUlL I C SAFETY: :.TRANSPDRTATION: ~lIEALTH & YfLfARE: ~CULTURE & LEISURE SERVICES: .:tCIMJN I TY DEVELOPMENT: '~tAPITAL IMPROVEMENT PROJECTS: IOTAL EXPBIDITURES .00 .00 .00 232469.50 .00 232469.50 EXCESS C REVENUE )EXPEND ITURE .00 .00 .00 15063.62- .00 15063.62- . C~) EXPENDITURE .00 .00 .00 15063.62- .00 15063.62- . II :>L104C 812B/97 444~~,.tEVENUE~44444" SES OF MONEY AND PROPERTY KARGES FOR SfRVI CES THfR SClJRCfS OF REVENUE TOTAL REVENUE -EXPENDITURES-- 5NERAl GOVERNMENT ACTIVITIES: N~-DEPARlMEHTAl ACTIVITY TOTAL JBLIC SAFETY: WSPORTATION : :AlTH & WELFARE: JllURE & LEISURE SERVICES: HUUTY DEVELOPMENT: U>ITAl IMPROVEMENT PROJECTS: o TAL EXPBIDIUES (CESS IRfVENUE>EXPEND ITURE :CESS [REVENUE> EXPEND I lURE /:1- .... . . .". .-..... . . -....... ......- . . .. ~ . . THE CITY OF DUBLIN STATEMENT SH~ING REVENUES VERSUS EXPENDITURE FOR THE PER I 00 7197 THROUGH 7/97 BlIlGET 13750.00- 243411-.00- 500.00- 257661.00- 266250.00 266250.00 266250.00 8589.00 8589.00 INTERNAL SERV I Cf CURRENT PERlOO ACTUAL PERCENT .00 24905.08- 10.2 .00 24905.08- 9.7 8510.00 3.2 8510.00 3.2 8510.00 16395.08- 3.2 190.9- 16395.08- 190.9- FUND VARIANCE 13750.00- 218505.92- 500.00- 232755.92- 257740.00 257740.00 257740.00 24984.08 24984.08 ".'.. - Ow.. ... PAGE 1 9.36.3' . PREVIOUS YEAR ENDING JUNE 3D, 1997 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y~T~O 18137.65- 211049.81- 21901.75. 251089.21- 121763.11 121763.11 121654.87 129434.34~ 129434.34- .00 '4004.19- .00 14004.19- 8385.47 8385.47 6.6 18137.65- 197045.62- 21901. 75- 237085.02- 5.6 6.9 6.9 113377.64 113377.64 8385.47 6.9 113269.40 5618.72- 4.3 123815.62~ 5618.72- 4.3 123815.. : .' :.' . .; .,... r _ .. + . . . .. . ~'. . _ . . ." - ..... .-. '.--' .".. . GL104C THE CITY OF OUSLIN STATEMENT SH~ING PAGE , 8J2B/97 REVENUES VERSUS EXPENDITURE 9.49.59 FOR THE . PERI 00 7/97 THROUGH 7/97 ENTERPRISE FUNDS CURRENT PER I 00 PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE F1 SCAL YR Y-T-P ..~~~~~~KEVENUESA~~~~~A USES OF MONEY AND PROPERTY 1708264.00- 361626.86- 21.2 1346637.14- 1557743.46. 381511.15- 24.5 1176232.31 - TOTAL REVENUE 1708264.00- 361626.86- 21.2 1346637 .14. 1557743.46- 381511.15- 24.5 1176232.31- . ....-exPENDITURES...... ~...I. GENERAL GOVERNMENT ACTIVITIES: NON-PEPARlMENTAL 1599939.00 69115.73 4.3 1530823.27 1699147.23 71609.88 4.2 1627537.35 ~ ADM I N SERVI CES 4260.00 .00 4260.00 4194.20 1000.00 23.8 3194.20 ACTIVITY TOTAL 1604199.00 69115.73 4.3 1535083.27 1703341.43 72609.88 4.3 1630731.55 ; l'UBLIt SAFETY: : llAN~TATIDN: ~HEAl.TH & YElFARE: {DJLTURE & LEISURE SERVICES: ; tofIIUNITY DEVELOPMENT: ~ CAPITAL ItlP'RDVEMENT PROJECTS: : lOT A L EXPENDITURES 1604199.00 69115.73 4.3 1535083.27 1703341.43 72609. B8 4.3 1630731.55 , "EXCESS [REYfNUE>EXPEND IlURES 104065.00- 292511.13- 281.1 188446.13 145597.97 308901.27- 212.2- 454499.24 EXCESS ~NUE> EXPENDITURE 104065.00- 292511.13- 281.1 188446.13 145597.97 308901.27- 212.2- 454499.24 . . 1:P