Loading...
HomeMy WebLinkAboutItem 4.04 FinRpt 11-97 (2) . CITY CLERK File # D[3][3J[QJ-[5J6] . AGENDA STATEMENT CITY COUNCIL MEETING DATE: (December 16,1997) SUBJECT: Financial Report For the Month of November 1997 qtReport Prepared by: Paul S. Rankin, Assistant City Manager EXIDBITS 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 November 30, 1997 RECOMMENDATION:~cePt and file the reports. FINANCIAL STATEMENT: See reports for detail of monthly fmancial activity. . DESCRIPTION: This item provides the report of the monthly fmancial statements for the month of November. The November report was prepared incorporating the audited records as of June 30, 1997. 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. Analvsis of November 1997 Revenue and Expenditure Report The November report represents the reporting of revenues and expenditures for the five months of the Fiscal Year. Major property tax revenues will not be received until December and the franchise fees from cable and utility operations will not be received until the latter part of the fiscal year. In the expenditure category, the November report includes expenses only for the first quarter of contract Police Services. 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 November 1997 approximately 31 % of the total budgeted General Fund Revenues, which is slightly higher than the 27% 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. Real Property Transfer Taxes have increased over the same period in the prior year due to an increase in assessed value and sales activity primarily for residential units within the City. In addition, the initial sale . ------------------------------------------------------------------- COPIES TO: G:\MONTHFS\FY98\1197 AG.DOC ITEM NO. 4.4 of large parcels in Eastern Dublin results in an increased amount of Transfer Taxes. As of November the City had already collected approximately 60% of the Fiscal Year 1997/98 budget for Real Property Transfer Tax. Transient Occupancy Taxes are higher than in the same period due to timing differences in the collectio>>. of these taxes. Licenses and Permits are higher than in the same period in the prior year, due to th issuance of several building permits and building plan check fees for several projects in the Eastern Dublin. Interest and Rentals are higher than in the same period in the prior year due to a higher cash balance. Initially all interest revenue is recorded in the General Fund and allocated to other funds on a pro rata basis at year end. The "Other Revenues" category is higher than in the same period in the prior year due to an increase in the equity distribution payment received from ABAG PLAN, the City's liability insurance coverage provider, and an increase in parking citations issued over the same period in the prior year. Based upon the limited information available there were not any areas with significant deviations from the current budget projections. General Fund Expenditures Overall, through the month of November expenditures in the General Fund totaled $5,287,643 and represented approximately 30% of the total budgeted expenditures in the General Fund. Of this amount, a total of $48,046 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 November 1997 was. comparable to the amounts expended for the same period in the prior Fiscal Year. As of November 30, 1997, the City had expended 32% of the General Fund Operating Budget, compared to 31 % 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. Culture and Community Services is higher than the same period in the prior year primarily due to higher payments for contract recreation instructors resulting from a large increase in enrollment for acting recreation classes. This program is offset by revenues collected from participants. 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. . -;J.- Exhibit 1 City of Dublin 1997-98 YTD Revenues and Budget Comparison For the Period Ending November 30,1997- Unaudited Sales Taxes .FY 97/98 II FY 96/97 . Total General Fund Revenues Property Taxes Transient Occupancy Taxes Franchise Taxes Licenses and Permits 4% Interest and Rentals . Intergovernmental from State Charges for Services Other Revenues 0% 30% 60% 90% 120% 150% 42% of Year Complete FY 97/98 FY 97/98 %of FY 96/97 % of Total for Budget YTD Actual Budget YTD Actual FY 96/97 Property Taxes 4,407,700 437,472 10% 380,551 9% Sales Taxes 6,850,000 2,623,643 38% 2,363,852 33% Transient Occupancy Taxes 231,000 110,295 48% 71,607 27% Franchise Taxes 750,500 127,113 17% 105,788 15% Licenses and Permits 1,043,350 560,059 54% 401,790 37% Interest and Rentals 1,328,450 524,112 39% 294,268 21% Intergovernmental 1,171,620 491,707 42% 464,005 40% . Charges for Services 1,631,918 607,452 37% 475,690 34% Other Revenues 505,665 160,887 32% 98,297 36% Total General Fund Revenues 17,920,203 5,642,740 31% 4,655,847 27% 12/9197 12:01 g:\monthfs\fy98\fs.xls loilS ExhLbit 2 City of Dublin 1997-98 YTD Expenses and Budget Comparison For the Period Ending November 30, 1997 - Unaudited Total General Fund Expenses - - -- --~- - - -- --=--~ 30% 32% . Fire .FY 97/98 II FY 96/97 General Government Civic Center Lease Police Other Public Safety Transportation Health and Welfare Culture & Community Services . Community Development Capital Improv. Projects 45% 42% of Year Complete I 0% 30% 60% 90% 120% FY 97/98 FY 97/98 % of FY 96/97 % of Total for Budget YTD Actual Budget YTD Actual FY 96/97 General Government 1,783,878 654,077 37% 596,402 35% Civic Center Lease 1,599,919 361,627 23% 376,881 25% Police 4,282,674 1,033,300 24% 901,979 24% Fire 3,598,953 1,431,385 40% 1,151,748 42% Other Public Safety 283,202 11,360 4% 20,595 12% Transportation 667,372 203,824 31% 201,679 32% Health and Welfare 17,320 0 0% 0 0% Culture and Community Services 2,120,250 784,793 37% 643,639 32% Community Development 2,266,885 759,231 33% 637,640 35% Capital Improvement Projects 1,202,912 48,046 4% 462,692 45%. Total General Fund Expenses 17,823,365 5,287,643 30% 4,993,256 32% General Fund Operating Expenses 16,620,453 5,239,597 32% 4,530,564 31% 1219/97 12:01 g:\monthfsIfy98\ts.xls ). Df J J . CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF NOVEl\1BER 1997 :.. . Prepared by The Finance Department December 5,1997 . EXHIBIT 3 c;5 I::' GL102 12/05/97 ASSETS CASH CASH ~ITH FISCAL AGENT UNAMORTI ZED BOND D I SCCXJNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOONTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMCXJNTS TO BE PROVIDED TOTAL ASSETS LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS FOR AB1600 FEES DEPOSITS OTHERS PAYABLES:ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILTIES FUND BALANCES TOTAL FUND EQUITY GENERAL REVENUE FUNDS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/97 THRCXJGH 11/97 SPECIAL REVENUE FUNDS 5036884.96- 1642278.82 29485321.17 179704.41 175681.50 248261.35 3311.35 25055394.82 453713.56- 637971. 14- 356227.32- 5804.67- .70 1453715.99- 23601678.83- 23601678.83- 11412.56 85226.76 1738918.14 3547.89- 2035.15- 5583.04- 1733335.10- 1733335.10- TOTAL LIAB,FND BAL, RETD EARNS 25055394.82- 1738918.14- SPECIAL ASSESSMENT FUNDS CAPITAL IMPROVEMENT FUNDS 181993.57 3019423.09 181993.57 181993.57- 181993.57- 3019423.09 3085725.01- 248261.35- 628.35 3333358.01- 313934.92 313934.92 TRUSTI AGENCY FUND 1m7.79 138694.98 2018500.00 2174932.77 2136000.00- 2136000.00- 38932.77- 38932.77- 181993.57- 3019423.09- 2174932.77- PAGE 1 14.44.23 TOT A L --- MEMORANDUM ONLY --- CURRENT JUNE 30, 1997 S. 175451.69- 138694.98 29485321.17 191116.97 175681.50 333488.11 3311.35 2018500.00 32170662.39 453713.56- 3085725.01- 889780.38- 357634.12- 5804.67- .70 2136000.00- 6928657.04- 25242005.35- 25242005.35- 862280.85- 132078.52 24978006.89 306200.31 12548.57 21596.01 7015.29 2090500.00 26685664.74 . 385183.67- 688222.47- 720766.40- 415650.63- 11136.74- 2042.80- 2208000.00- 4431002.71- 22254662.03- 22254662.03- 32170662.39- 26685664.74- . v ~ /3 GL102 CITY OF DUBLIN PAGE 1 12/05/97 BALANCE SHEET 14.44.39 FOR THE . PERlOO 7197 THROUGH 11/97 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG T 0 T A l S SERVICE FUNDS GROUP OF TERM DEBT --- MEMORANDUM ONLY _n FUND ACCOUNTS ACCOUNT GROUP CURRENT JUNE 30, 1997 ASSETS CASH 454440.48 1066.56- 453373.92 308865.91 CASH WITH FISCAL AGENT 1670390.81 1670390.81 1719345.08 UNAMORTI ZED BOIlD DISCOUNT INVESTMENTS AT COST RECEI VABLES: TAXES ACCOONTS CNET) INTEREST 46896.00 46896.00 ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS 350034.76 19616208.27 4066689. 17 24032932.20 21045462.27 AMOUNTS TO BE PROVIDED 18372224.42 18372224.42 5327970.26 TOTAL ASSETS 804475.24 21332428.52 4066689. 17 18372224.42 44575817.35 28401643.52 ~, FHD BAL, RETHD EARNINGS EPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 15535000.35- 18372224.42- 33907224.77- 21592970.26- TOTAL LIABILITIES 15535000.35- 18372224.42- 33907224.77- 21592970.26- FUND BALANCE 415305.55- 687538.17- 1102843.72- 838506.68- CONTRIBUTIONS 389169.69- 5109890.00- 5499059.69- 5459961.45- INVESTMENTS IN FIXED ASSETS 4066689.17- 4066689. 17- 510205.13- RETAINED EARNINGS TOTAL FUND EQUITY 804475 .24- 5797428.17- 4066689.17- 10668592.58- 6808673.26- TOTAL LIAB,FND SAL, RETD EARNS 804475.24- 21332428.52- 4066689.17- 18372224.42- 44575817.35- 28401643.52- . s ~ ;.5 GL104C THE CITY OF DUBLIN STATEMENT SHOVING PAGE 1 12/05/97 REVENUES VERSUS EXPENDITURE 13.57.41 FOR THE PERIOO 7/97 THROUGH 11/97 GENERAL REVENUE FUND . CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* PROPERTY TAXES 4286000.00- 364 111.95- 8.5 3921888.05- 3920897.29- 341481.25- 8.7 3579416.04- SALES TAX 6850000.00- 2623642.76- 38.3 4226357.24- 7108598.19- 2363851.58- 33.3 4744746.61 - REAL PROPERTY TRANSFERS 121700.00- 73360.18- 60.3 48339.82- 138062.47- 39069.99- 28.3 98992.48- TRANSIENT OCCUPANCY TAX 231000.00- 110295.00- 47.7 120705.00- 267007.09- 71606.72- 26.8 195400.37- FRANCKISE TAXES 750500.00- 127112.60- 16.9 623387.40- 723384.60- 105787.64- 14.6 617596.96- LICENSES & PERMITS 1043350.00- 560058.87- 53.7 483291.13- 1092182.95- 401789.70- 36.8 690393.25- FINES & FORFEITURES 33200.00- 15235.05- 45.9 17964.95- 38492.21- 20728.93- 53.9 17763.28- USES OF HONEY AND PROPERTY 1328450.00- 524112.37- 39.5 804337.63- 1388948.66- 294267.95- 21.2 1094680.71 - INTERGOVERNMENTAL FROM STATE 1171620.00- 491707.15- 42.0 679912.85- 1151275.49- 464005.38- 40.3 687270.11- CHARGES FOR SERVICES 1631918.00- 607451.85- 37.2 1024466.15- 1386418.59- 475690.31- 34.3 910728.28- OTHER SOURCES OF REVENUE 472465.25- 145651.72- 30.8 326813.53- 223207.32- m68.11- 34.8 145639.21- TOTAL REVENUE 17920203.25- 5642739.50- 31.5 12277463.75- 17438474.86- 4655847.56- 26.7 12782627.30- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 24064.00 187.40 .8 23876.60 27346.97 26.00- .1- 27372.97 CITY COUNCIL 1010 137334.00 55237.61 40.2 82096.39 127472.84 53527.78 42.0 73945.06 CITY MANAGER 1020 334487.00 118875.15 35.5 215611.85 291093.65 108127.98 37.1 182965.67 CITY ATTORNEY 1030 186794.00 54132.43 29.0 132661.57 201718.85 52689.97 26.1 1490~ ADMIN SERVICES 1040 637675.00 228666.80 35.9 409008.20 569247.12 201875.01 35.5 3673 BUILDING MANAGEMENT 1050 315955.00 97101.63 30.7 218853.37 331517.40 95977.63 29.0 235539. FACILITY REIHAL 1050-719 1599919.00 361626.86 22.6 1238292.14 1496816.41 376880.55 25.2 1119935.86 INSURANCE COST CENTER 1060 146803.00 99876.59 68.0 46926.41 122m.83 82325.38 67.1 40452.45 ELECTIONS COST CENTER 1070 766.00 .00 766.00 20511.92 1904.68 9.3 18607.24 ACTIVITY TOTAL 3383797.00 1015704.47 30.0 2368092.53 3188502.99 973282.98 30.5 2215220.01 PUBLI C SAFETY: POll CE 2010 4282674.00 1033300.35 24.1 3249373.65 3794625. 12 901979.47 23.8 2892645.65 CROSSING GUARDS COST. 2020 49048.00 9201.35 18.8 39846.65 40926.26 9246.51 22.6 31679.75 ANIMAL CONTROL 2030 200124.00 .00 200124.00 110514.00 .00 110514.00 DISASTER PREAPREDNESS 2050 34030.00 2158.94 6.3 31871.06 25992.10 11348.95 43.7 14643.15 FIRE SERVICES 2060 3598953.00 1431385.43 39.8 2167567.57 2751796.45 1151747.95 41.9 1600048.50 ACTIVITY TOTAL 8164829.00 2476046.07 30.3 5688782.93 6723853.93 2074322.88 30.9 4649531.05 TRANSPORTATION: PUBLI C IJORKS 3010 366732.00 127123.73 34.7 239608.27 319005.00 113834.07 35.7 205170.93 STREET MAINTENANCE 3020 55770.00 2736.72 4.9 53033.28 31593.44 28843.36 91.3 2750.08 STREET TREE MAINTENANCE 3040 47700.00 8340.64 17.5 39359.36 48375.71 7691.83 15.9 40683.88 STREET LANDSCAPE MAINT. 3050 197170.00 65622.66 33.3 131547.34 230289.60 51309.87 22.3 178979 . 73 ACTIVITY TOTAL 667372.00 203823.75 30.5 463548.25 629263.75 201679.13 32.1 427584.62 HEALTK & ~LFARE: ~ASTE MANAGEMENT 5020 5320.00 .00 5320.00 3595.87 .00 3595.87 CH I LD CARE 5030 12000.00 .00 12000.00 12000.00 .00 12000.00 ACTIVITY TOTAL 17320.00 .00 17320.00 15595.87 .00 15595.87 :ULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 216994.00 54249.25 25.0 162744.75 205874.00 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 20761.05 37.1 35168.95 54291. 08 20648.40 38.0 33642. DUBLIN CEMETERY 8013 16690.00 3882.85 23.3 12807.15 15749.25 1923.47 12.2 13825 b ~Jg GL1 O4C THE CITY OF DUBLIN STATEMENT SHOYING PAGE 2 12/05/97 REVENUES VERSUS EXPENDITURE 13.57.41 FOR THE . PERIOO 7/97 THROUGH 11/97 GENERAL REVENUE FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D PARK MAINTENANCE 8020 589455.00 183637.47 31.2 405817.53 594119.19 120589.70 20.3 473529.49 COMMUNITY CABLE TV 8030 37051.00 26020.00 70.2 11031.00 34256.72 23656.72 69.1 10600.00 RECREATION ADMIN. 8040 256353.00 93113.82 36.3 163239.18 234707.54 79927.90 34.1 154779.64 PLAYGROUNDS 8045 128003.00 52912.25 41.3 75090.75 108257.69 47764.58 44.1 60493.11 SHANNON CENTER 8050 148006.00 53879.08 36.4 94126.92 136660.43 49585.57 36.3 87074.86 PRESCHOOL 8055 54333.00 20252.12 37.3 34080.88 51629.57 19327.60 37.4 32301.97 TEENS PROGRAM 8060 35296.00 7984.59 22.6 27311.41 25445.93 10445.65 41.1 15000.28 ADULT SPORTS 8065 65350.00 24844.15 38.0 40505.85 61034.72 21541.55 35.3 39493.17 C: YCXJTH SPORTS 8066 52406.00 16300.30 31.1 36105.70 39910.77 12853.10 32.2 27057.67 '- SPECIAL EVENTS 8070 42042.00 13064.69 31.1 28977.31 40133.97 12915.89 32.2 27218.08 SENIOR CENTER 8080 104521.00 34535.58 33.0 69985.42 80392.97 30510.52 38.0 49882.45 RECREATION INSTRUCTION 8090 88555.00 58066.62 65.6 30488.38 89684.89 34608.12 38.6 55076.77 AQUATICS 8100 219265.00 111288.78 50.8 107976.22 215910.85 95871.62 44.4 120039.23 ACTIVITY TOTAL 2120250.00 784792.60 37.0 1335457.40 2000559.57 643638.89 32.2 1356920.68 COMMUNITY DEVELOPMENT: PLANNING 9010 744971.00 264680.03 35.5 480290.97 659318.79 254839.49 38.7 404479.30 BUILDING SAFETY 9020 593826.00 158075.91 26.6 435750.09 386171.15 131706.80 34.1 254464.35 ENGINEERING 9030 781875.00 268082.18 34.3 513792.82 684913.30 202528.81 29.6 482384.49 ECONOMIC DEVELOPMENT 9040 146213.00 68392.39 46.8 77820.61 108155.26 48564.80 44.9 59590.46 ACTIVITY TOTAL 2266885.00 759230.51 33.5 1507654.49 1838558.50 637639.90 34.7 1200918.60 ~TAL IMPROVEMENT PROJECTS: NERAL eIP PROJECTS 93NN 584850.00 26955.79 4.6 557894.21 80137.74 5589.85 7.0 74547.89 COMMUNITY IMPROVEMENTS 94NN 66000.00 4305.73 6.5 61694.27 51771.12 .00 51771.12 PARKS 951111 192140.00 9359.64 4.9 182780.36 497423.22 272541.49 54.8 224881.73 STREET DDNSTRC/IMPROVMT 96NN 359922.00 7424.80 2.1 352497.20 403724.50 184560.42 45.7 219164.08 ACTIVITY TOTAL 1202912.00 48045.96 4.0 1154866.04 1033056.58 462691.76 44.8 570364.82 TOT A L EXPENDITURES 17823365.00 5287643.36 29.7 12535721.64 15429391.19 4993255.54 32.4 10436135.65 EXCESS <REVENUE>EXPEIIDITURES 96838.25- 355096.14- 366.7 258257.89 2009083.67- 337407.98 16.8- 2346491.65- TRANSFERS IN FROM OTHER FUNDS .00 10785.46- 10785.46 5077.54- .00 5077.54- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 4211. 16 .00 4211.16 EXCESS <REVENUE> EXPENDITURE 96838.25- . 365881.60- 377.8 269043.35 2009950.05- 337407.98 16.8- 2347358.03- . ", /7 u6 )3 GL 1 04C THE CITY OF DUBLIN STATEMENT SHOJING PAGE 1 12/05/97 REVENUES VERSUS EXPENDITURE 14.07.55 FOR THE PERlOO 7197 THROUGH 11/97 SPECIAL REVENUE FUNDS . CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* PROPERTY TAXES 71500.00- .00 71500.00- .00 .00 .00 SALES TAX 159300.00- 64718.77- 40.6 94581.23- 152122.48- 60456.76- 39.7 91665.n- FINES & FORFEITURES 25000.00- 10219.81- 40.9 14780.19- 22506.62- 7828.43- 34.8 14678.19- USES OF MONEY AND PROPERTY 78560.00- .00 78560 . 00- 98044.39- .00 98044.39- INTERNGOVERNMENTAL FROM STATE 740859.00- 249096.11- 33.6 491762.89- 611716.48- 239681.67- 39.2 3n034.81- INTERGOVERNMENTAL FROM COUNTY 141460.00- 54492.00- 38.5 86968.00- 143136.00- 2m9.00- 19.4 115397.00- INTERGOVERNMENTAL FROM FEDERAL 464889.00- 10537.89- 2.3 454351.11- 185082.30- .00 185082.30- CHARGES FOR SERVICES 739000.00- 8855.73 1.2- 747855.73- 788267.59- .00 788267.59- OTHER SOURCES OF REVENUE 218000.00- .00 218000.00- 311205.00- 11394.00- 3.7 299811.00- TOTAL REVENUE 2638568.00- 380208.85- 14.4 2258359.15- 2312080.86- 347099.86- 15.0 1964981.00- *******EXPENDlTURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBLI C SAFETY: POLI CE 93845.00 20787.07 22.2 73057.93 63146.44 .00 63146.44 TRAFFIC SIGNALS 108150.00 21070.04 19.5 87079.96 78617.71 21507.55 27.4 57110.16 FIRE SERVICES 75960.00 2875 . 00 3.8 73085.00 .00 .00 .00 ACTIVITY TOTAL 277955.00 44732.11 16.1 233222.89 141764.15 21507.55 15.2 12025_ TRANSPORTATION: PUBLIC WORKS .00 .00 .00 1n.47 .00 1n. STREET MAINTENANCE 208910.00 40105.65 19.2 168804.35 213347.82 31863.60 14.9 181484.22 STREET SWEEPING 80600.00 25039.98 31.1 55560.02 67675.22 23748.74 35.1 43926.48 ACTIVITY TOTAL 289510.00 65145.63 22.5 224364.37 281195.51 55612.34 19.8 225583.17 HEALTH & WELFARE: ~ASTE MANAGEMENT 808166.00 1761.97 .2 806404.03 718827.n 19782.25 2.8 699045.47 ACTIVITY TOTAL 808166.00 1761.97 .2 806404.03 718827.n 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 8622.97 9.8 79497.03 88980.07 19440.96 21.8 69539.11 ACTIVITY TOTAL 88120.00 8622.97 9.8 79497.03 88980.07 19440.96 21.8 69539.11 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 250983.00 34078.89 13.6 216904.11 140454.07 .00 140454.07 PARKS 219102.23 31017.78 14.2 188084.45 443937.09 19643.11 4.4 424293.98 STREET CONSTRUCTION/IMPROVMT 766610.00 27703.07 3.6 738906.93 353418.05 216305.20 61.2 137112.85 ACTIVITY TOTAL 1236695 . 23 92799.74 7.5 1143895.49 937809.21 235948.31 25.2 701860.90 TOT .A L EXPENDITURES 2707491.23 213062.42 7.9 2494428.81 2175768.12 352291.41 16.2 1823476.71 EXCESS <REVENUE>EXPENDITURE 68923.23 167146.43- 242.5- 236069.66 136312.74- 5191.55 3.8- 141504.29- TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 3395.00 .00 3395.00 EXCESS <REVENUE> EXPENDITURE 68923.23 167146.43- 242.5- 236069.66 132917.74- 5191.55 3.9- 138109.29- . 1 c0 ;.3 GL 104C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 12/05/97 REVENUES VERSUS EXPENDITURE 14.18.06 FOR THE . PERIOO 7197 THROUGH 11/97 SPECIAL ASSESSMENT FUNDS CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 3D. 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 274407.00- .00 274407.00- 243986.94- .00 243986.94- USES OF MONEY AND PROPERTY 13395.00- .00 13395.00- 18795.26- 1672.49- 8.9 17122.77- OTHER SOURCES OF REVENUE 2000.00- .00 2000.00- .00 .00 .00 TOTAL REVENUE 289802.00- .00 289802.00- 262782.20- 1672.49- .6 261109.71- *******EXPENDI TURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 PUBU C SAFETY: TRFC SIGS/STREET LIGHTING 121705.00 28508.43 23.4 93196.57 103293.98 23661.14 22.9 79632.84 ACTIVITY TOTAL 121705.00 28508.43 23.4 93196.57 103293.98 23661.14 22.9 79632.84 TRANSPORTATION: PUBLIC WORKS 1300.00 1200.35 92.3 99.65 4247.66 1169.48 27.5 3078.18 STREET TREE MAINTENANCE 11410.00 1932.79 16.9 9477.21 5697.32 1015.76 17.8 4681.56 STREET.LANDSCAPE MAINTENANCE 139420.00 49948.74 35.8 89471.26 138868.81 32129.08 23.1 106739.73 ACTIVITY TOTAL 152130.00 53081.88 34.9 99048.12 148813.79 34314.32 23.1 114499.47 HEALTH & ~LFARE: ~URE & LEISURE SERVICES: UNITY DEVELOPMENT: NGINEERING 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 45000.00 .00 45000.00 103000.00 103106.75 100.1 106.75- ACTIVITY TOTAL 76815.00 7815.00 10.2 69000.00 119488.87 111174.67 93.0 8314.20 TOT A L EXPENDITURES 355300.00 92870.31 26.1 262429.69 374782.60 172173.57 45.9 202609.03 EXCESS<REVENUE>EXPENDITURE 65498.00 92870.31 141.8 27372.31- 112000.40 170501.08 152.2 58500.68- EXCESS <REVENUE> EXPENDITURE 65498.00 92870.31 141.8 27372.31- 112000.40 170501.08 152.2 58500.68- . (4)3 Gl1 04C THE CITY OF DUBLIN STATEMENT SHOVING PAGE 1 12/05/97 REVENUES VERSUS EXPENDITURE 14.35.23 FOR THE PERlOO 7/97 THROUGH 11/97 CAP IT Al IMPROVEMENT FUND . ! CURRENT PERlOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE I FISCAL YR Y-T-D , f , ;********REVENUES******* OTHER SOURCES OF REVENUE 2889412.00- 51796.03- 1.8 2837615.97- 328497.84- 70429.55- 21.4 258068.29- f TOTAL REVENUE 2889412.00- 51796.03- 1.8 2837615.97- 328497.84- 70429.55- 21.4 258068.29- ~ ,*******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: . ACTIVITY TOTAL .00 .00 .00 .00 .00 .00 ~ PUBU C SAFETY: ..< TRANSPORTATION: . HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 100000.00 9359.94 9.4 90640.06 12823.75 5461.25 42.6 7362.50 CDHMUNITY IMPROVEMENTS 19000.00 .00 19000.00 .00 .00 .00 PAR'S 239460.00 .00 239460.00 .00 .00 .00 STREET CONSTRUCTION/IMPROVHT 2515167.00 40878.66 1.6 2474288.34 449732.20 200318.22 44.5 249413.98 ACTIVITY TOTAL 2873627.00 50238.60 1.7 2823388.40 462555.95 205779.47 44.5 256776.48 TOT A L EXPENDITURES 2873627.00 50238.60 1.7 2823388.40 462555.95 205779.47 44.5 25677. EXCESS<REVENUE>EXPENDITURE 15785.00- 1557.43- 9.9 14227.57- 134058.11 135349.92 101.0 129 TRANSFERS OUT TO OTHER FUNDS .00 10785.46 10785.46- 1682.54 .00 168 EXCESS <REVENUE> EXPENDITURE 15785.00- 9228.03 58.5- 25013.03- 135740.65 135349.92 99.7 390.73 . j/J ~ ;:3 . GL104C THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 12/05/97 REVENUES VERSUS EXPENDITURE 14.40.24 FOR THE . PERIOO 7/97 THROUGH 11/97 TRUST/AGENCY FUND CURRENT PERIOO PREVIOUS YEAR ENDING JUNE 30, 1997 BUDGET ACTUAL PERCENT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS .00 .00 .00 236036.28- .00 236036.28- USES OF MONEY AND PROPERTY .00 2307.92- 2307.92 11962.96- 2161.30- 18.1 9801.66- TOTAL REVENUE .00 2307.92- 2307.92 247999.24- 2161.30- .9 245837.94- ~******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES f NOH-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: CAP IT AL IMPROV-cllENT PROJECTS: TOTAL EXPENDITURES .00 156154.75 156154.75- 232469.50 153314.75 66.0 79154.75 EXCESSCREVENUE)EXPENDITURE .00 153846.83 153846.83- 15529.74- 151153.45 973.3- 166683.19- ~SS (REVENUE) EXPENDITURE .00 153846.83 153846.83- 15529.74- 151153.45 973.3- 166683.19- . II c6 /3 . GL104C THE CITY OF DUBLIN STATEMENT SHOVING PAGE 1 12/05/97 REVENUES VERSUS EXPENDITURE 14.22.51 FOR THE PERIOO 7/97 THROUGH 11/97 . INTERNAL SERVICE FUND 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 13750.00- .00 13750.00- 18137.65- .00 18137.65- CHARGES FOR SERVICES 243411.00- 101227.98- 41.6 142183.02- 211049.81- 83354.29- 39.5 127695.52- OTHER SOURCES OF REVENUE 500.00- 50.00- 10.0 450.00- 21901.75- 1072.70- 4.9 20829.05- TOTAL REVENUE 257661.00- 101277.98- 39.3 156383.02- 251089.21- 84426.99- 33.6 166662.22- ~*******EXPENDITURES******* .GENERAL GOVERNMENT ACTIVITIES: ~ NON-DEPARTMENTAL 266250.00 51264.19 19.3 214985.81 262014.45 49654.71 19.0 212359.74 ACTIVITY TOTAL 266250.00 51264.19 19.3 214985.81 262014.45 49654.71 19.0 212359.74 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 266250.00 51264.19 19.3 214985.81 262014.45 49654.71 19.0 212359.74 EXCESS<REVENUE>EXPENDITURE 8589.00 50013.79- 582.3- 58602.79 10925.24 34m.28- 318.3- 45697.52 EXCESS <REVENUE> EXPENDITURE 8589.00 50013.79- 582.3- 58602.79 10925.24 34m.28- 318.3- 45697. . jJ-ci ):3 GL 1 04C THE CITY OF DUBLIN STATEMENT SH~ING PAGE 1 12/05/97 REVENUES VERSUS EXPENDITURE 14.30.35 FOR THE . PERIOO 7/97 THROUGH 11/97 ENTERPRISE FUNDS \ CURRENT PERlOO PREVIOUS YEAR ENDING JUNE 3D, 1997 BUDGET ACTUAL PERCEIlT VARIANCE ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D ;********REVENUES******* USES OF MONEY AND PROPERTY 1708264.00- 361816.75- 21.2 1346447.25- 1592321.83- 381843.09- 24.0 1210478.74- ,- TOTAL REVENUE 1708264.00- 361816.75- 21.2 1346447.25- 1592321.83- 381843.09- 24.0 1210478.74- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1599939.00 69132.29 4.3 1530806.71 1314726.23 71616.84 5.4 1243109.39 ~. ADMIN SERVICES 4260.00 1050.00 24.6 3210.00 4194.20 1000.00 23.8 3194.20 ACTIVITY TOTAL 1604199.00 70182.29 4.4 1534016.71 1318920.43 72616.84 5.5 1246303.59 PUBll C SAFETY: TRANSPORTATION: HEALTH & UELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A t EXPENDITURES 1604199.00 70182.29 4.4 1534016.71 1318920.43 72616.84 5.5 1246303.59 EXCESS<REVENUE>EXPENDITURES 104065.00- 291634.46- 280.2 187569.46 273401.40- 309226.25- 113.1 35824.85 TRANSFERS IN FROM OTHER FUNDS .00 . .00 .00 4211.16- .00 4211.16- ~S <REVENUE> EXPENDITURE 104065.00- 291634.46- 280.2 187569.46 277612.56- 309226.25- 111.4 31613.69 . JJ ~ ):3