Loading...
HomeMy WebLinkAboutItem 4.08 FinRpt Apr-May 99 -. AGENDA STATEMENT CITY COUNCIL MEETING DATE: 7/6/99 CITY CLERK File # 330-50 (July 6; 1999) SUBJECT: .. Financial Reports for April 1999 and May 1999 Report Prepared by: Fred Marsh, Finance'Manager ATTACHMENTS: Comparison of General Fund Revenue Co!!e.m.~9,~n~sJ3.~ ................................. Cun'ent Period To Previous Yearand Bgdget Comparison of General Fund Revenue Expenditures In Current Period To Previous Year and Budget o Balance Sheets ~.~.~..~gme S e_..men~_.~ts fo_~tl~ P~£riod__ .S ....... Ending April 1999 and May 1999 Accept and file the reports. FINANCIAL STATEMENT: See reports for detail of monthly financial activity. DESCRIPTION: This item provides the report of the financial statements~ ~c~r.~.~.~9~n.~s_p~f~April and May 1999. Consistent with prior reports the focus will be on General Fund Revenues ~d Expenditures, '-'.which represent the most significant portion of the City's operations. -Analvsis of May 1999 Revenue and Expenditure Report Ti~ May report represents the repOrting of revenues and expenditures for eleven months of the fiscal year. It sh, ould be noted that there is not an even distribution of revenues and expenditures on a monthly basis. Foi '~xample, expenditures for major contracts such as Police Services lag since the City is billed on a quarterly basis. A more detailed analysis of General Fund Revenue and Expenditures is shown on the attached graphs and discussed below. General Fund Revenues Total General Fund Revenues collected through May were collected at a rate ahead of ~first~.~e~l~exg~g months of the previous Fiscal Year. The City had collected through May 1999 approximately 90% of the total budgeted General Fund Revenues compared to approximately 87% in the prior Fiscal Year. Sales Tax is slightly, higher than the percentage collected in the same period in the previous as a result of the increased sales activity within the City, primarily related to autos. Transient Occupancy taxes are higher than in the same period in the prior year due to timing differences in the col!ecti~n The percentage of fi:anchise taxes collected is reflective of growth in the City. This report includes 100% of the Cable TV and Utility fi:anchise taxes and Garbage fi-anchise taxes covering July 1998 through April 1999. similar t~ends a~e keflected in the issuance .0fb~!~g permits. Through the month of May permits issued representedimprovements valued in excess of $179 million. COPIES TO: G:LMO~rHFS~99 Financ]:d Report~doc ITEM NO. 4~ pro and Rental revenue ~s the current report as the Fund for January through not i~nall°cated t°~' Calculati°ns: However it 'sh~fild'be:'n0ted~that:ih~iie~t' prepayment on February 1, 1 in mtei:~St i-ate~ Ch~ge~' for se~ices ~e h~er th~ revenues collected d~ng ~e sine period of~e prior ye~, primely due to revenues received for plmg =d engineering s~ices =soCim~ wi~ incre~ed"d~9~16~fii activiW~ifi' E~iSm DubiM~ ~d*~'~ est bhs~ent of ~eE~tem D~b~!n Sp~c!fic. P!~ ~plement~!0nFe~ a newre[ not occur t6 differences in'project' timifi~ due same penoa m ~ pnor ~endimres to date are approximately 94% 6f bud~t~6miS~e~d -iiS~'~£O0%"ifi~'~~-i~ri'6:d o[ semce payment, even though part of the Payment is °ffset b) Ci[yhas reqorded the full mount of the debt se~ce p//ymeiit to b~ made f0i~Fisc~i'i¥~"l'998/99~~ reeeiPi ~d:PaYm~nt i '~e~i:. case enclitures inthe current only at '66%~iompal-edto ~3%' in' the ..... current y~. made mJ~m conjuncuon with the Street Ov¢i:~ and Si~ Se~l~rojects. same period in the prior .ay in the'~re~tmen/~d app0ir/tment of stafft~°~ v//~ant'p6siti~ns and lower ~a~er'~ ~l:i~g~-s'~'~3~:~ ~ COmmunity De;Vel°Pm~ni ~x~:en~l~e~ a~' City Of Dublin 1998-99 YTD Revenues. andBudget Comparison - ' 'For tl~ l~e~i6~ E~di~ ~a~31, 1999'- 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 Other Revenues --'17% · is. 10~ 11~% ~6% '96% ~ I I 0% 30% 60% 90% 120% 92% Of Year Complete 150% · FY 98/99 m FY 97/98 Property Taxes Sales Taxes Transient Occupancy Taxes Franchise Taxes' Licenses and Permits Interest and Rentals Intergovernmental Charges for Services Other Revenues Total General Fund ReVenues FY 98/99 - FY 98/99 % of Budget YTD Actual Budget 5,091,100 - 4,672,438 92% 8,200,000 7,127,296 87% 337,000 290,054- 86% 815,000 772,732 95% 1,876,755 1,940,290 103% 1,225,530 1,373,678 1 t 2% 1,308,420 1,211,861 93% 3,175,878 2,731,969 86% 683,695 293,544 43% 22,713,378 20,413,862 90% FY 97/98 YTD Actual 4,182,101 6,663,934 233,573 693,924 1,354,710 1,488,751 1,098,265 1,915,403 525,037 18,155,698 % of Total for FY 97198 91% 83% 76% 91% 97% 98% 89% 77% 96% 87% A'i-FACHMENT 1 City of DubHn 1998~99 YTD ExpenSes and BUdget c~mparison For the p~ri~d E~di~g M~y 31, i999 ~ Unaudited Total General Fund Expenses 70% ] 830}, General Government Civic center Lease 94~00% Police Other Public Safe~ Transpo~ation Health and Welfare -- 65% Culture & CommuniW Se~ic~- 68% --179% Communi~ Development __ ..~.. Capital Improv. Prqec~ 45% ~ 93% '*' 0% 30% 60% 90% 120% : 92% of YearComplete FY 98~99 FY 98~99 % of FY 97/98 % of Total for Budget YTD Actual Budget YTD Actual FY 97~98 G~neral Government 2,277,735 1,771,930 78% 1,484,429 84% Civic Center Lease 1,719,374 1,614,407 94% 1,493,244 100% Police .... 4,458,863 '~' 2,320,450 52% 3,189,533 74% Fire 4,210,354 3,650,430 87% 3,321,199 92% Other Public Safety 272,131 106,670 39% 152,678 58% Transportation 794,440 520,368 66% 477,522 73% Health and Welfare 18,160 10,427 57% 11,090 65% Culture and Community Services 2,597,146 1,755,259 68% 1,718,020 79% Community Development 3,558,127 2,994,931 84% 2,187,642 79% Capital Improvement Projects 3,033,678 1,368,185 45% 922,596 93% Total General Fund Expenses General Fund Operating Expenses 22,940,008 16,113,057 19,906,330 14,744,872 70% 14,957,953 83' 74% 14,035,357 82% ATTACHMENT 2 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MAY I999 Prepared by The Finance Dc~parmaent June 23, 1999 ATTACHMENT 3 GL!02 6f23/99 ASSETS CASH CASH WITH FISCAL AGEN-F UN,~.HORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES --. ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXED ASSETS A~OUNTS TO BE PROVIDED TOTAL ASSETS LIAB. FND BAL. RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS'FOR AB1600 FEES DEPOSITS OTHERS PAYABLES:~gCOUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LtABILTIES FUND BALANCES TOTAL FUND EQUITY TOTAL LIAB.FND BAL. RETD EARNS CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/98 THROUGH GENERAL SPECIAL SPECIAL REVENUE REVENUE ASSESSMENT FUNDS FUNDS FUNDS 14971879.32- 34932864.17 168966.06 9070.16 7059.95 20146081.02 802258.01- 778884.92- 184730.25- 10539.76- 19235.70- 1795648.74- 18J50432.28- 18350432.28- 20146081.02- 5/99 2819968.86 346391.59 2531.41 106990.01 CAPITAL IMPROVEMENT FUNDS 11039459.02 TRUST/ AGENCY FUND 150538.01 149763.18 PAGE 8.19 TOTAL c --- MEMORANDUM ON,~- CURRENT JUNE 3'DT. 1! 615521.84- 1370798.~ 149763.18 !42234.5 34932864.17 37t84321.i 171497.47 t67459.1 175681,5, !!6D60.i7 333488.i] 7059.95 4619.3~ 1941500.00 1941500.00 2018500.00 2929490.28 346391.59 11039459.02 2241801.19 346391.59- 346391.59- 2059000.00- 2059000.D0- 182801.19- 182801.19- 2241801.!9- 992965.00- 3547.89- 3784.40- 1000297.29- 1929192.99- 1929192.99- 11504286.94- 9070.16- 1!513357.10- 473898.08 473898.08 11039459.02- 2929490.28- 346391.59- 36703223.10 38555' ~5 802258.01- 621010.89 12497251.94- 6929542.18 791502.97- 857540.29 188514.75- 181553.33 10539.76- 11853,27. 19235.70- 8007.11. 2059000.00- 2136000.00- 16368303.13- 10745607.07- 20234919.97- 27909898.18- 20334919.97- 27909898.18- 36703223.10- 38655505.25- 6/2 /99 CITY O~ DbBLIN BALANCE SHEET FOR THE PERIOD 7/98 THROUGH 5/99 INTERNAL ENTERPRISE FIXED ASSETS SERVICE FUNDS GROUP OF FUNDS ACCOUNTS GENERAL LONG TERM DEBT ACCOUNT GROUP PAGE .S' 8.20. TOTALS --- MEMORANDUM ONLY --- CURRENT JUNE 30. 19! ASSETS CASH CASH WITH FISCAL AGENT UK~.HORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES :TAXES " ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS iNVENTORY AT COST P,~PAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS L!A3. FND BAL, RETND EARNINGS DEPOSITS'FOR PRIVATE DEVELPMNT DEPOSITS~'.OTHERS PAYABLES ~4CCOUNTS i~EREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCE CDNTRIBLFFIONS INVESTMENTS IN FIXED ~SSETS RETAINED EARNINGS TOTAL FUND EQUITY TOTAL LIAB.FND BAL. RE'FO EARNS 956676.49 5172.33' 46896.00 1645067.31 19163436.42 6380137.99 2601743.80 19215504.75 !4770000.D0- 14770000.00- 792334.25- 664385.25' 1809409.55- 5109890.00- 2601743.B0- 4445504.75- 2601743.80- 19215504.75- 6380137.99 6380137.99- 6380137.99- 6380137.99- 28543491.59 28543491.59 28543491.59- 28543491.59- 28543491.59- 961848,82 523947.52 1728821.03 46896.00 46896,00 271BB641.72 24032932.20 28543491.59 18091721.7! 56740B78.13 44424318.47 43313491.59- 33626721.7t- 43313491.59- 33626721.71- 127949.00- 1231847.90- 6919299.55- 5499059.69- 6380137.99- 4066689.17- 13427386.54- 10797596.76- 56740B78.13- 44424318.47- GL!04C 6/23/99 x~===X=REVENUESXXXx~x PROPERTY TAXES SALES TAX REAL PROPERTY TRANSFERS TRANSIENT OCCUPANCY T~X FRANCHISE TAXES LICENSES & PERHiTS FINES'& FORFEITURES USES DF MONEY AND PROPERTY INTERGOVERNMENTAL FROM STATE CKARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE BUDGET 4856100,00- 8200000,00- 235000,00- 337000,00- 815000.00- 1876755,00- 45950,00- 1225530,00- 1308420,00- 3175878,00- 637745,00- 22713378.00- THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 5/99 GENERAL REVENUE FUND CURRENT PERIOD ACTUAL PERCENT VARIANCE 4429935,26- 91,2 426164,74- 7127296.41- 86,9 1072703,59- 242502.54- 103,2 7502,54 290054,16- 86,1 46945,84- 772732.28- 94.8 42267,72- 1940290,30- 103,4 63535.30 53365,28- t16,1 7415,28 1373677,78- 112,1 148147,78 1211861,36- 92,6 96558.64- 2731968,74- 86.0 443909.26- 240178.6t- 37,7 397566.39- 20413852.72- 89,9 22995!5.28- ACTUAL FISCAL YR 4351858,66- 8025447,79- 231331,24- 306318,00- 759803.34- 1398676,76- 40421,45- 1556181.29- 1233812,25- 2483860,91- 507052,04- 20894763.73- PAGE PREVIOUS YEAR ENDING JUNE 3~9 ACTUAL PERCENT VARIANC! Y-T-D 4005418,90- 92.0 346439,7( 6663934.16- 83.0 1361513,6: 176682,06- 76,4 54649,1~ 232573.00- 76,3 72745.0C 693924.34- 91.3 65879.0C 1354709.94- 96,9 43966.82 38722.49- 95.8 1698,96 1488750,58- 95,7 67430,71 1098265,35- 89.0 135546.90 1915402,96- 77,1 568457,95 486314,94- 95,9' 20737.10 18155698.72- $5.9 2739055.0i GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 29700.00 CiTY COUNCIL 10t0 150673,00 CiTY MANAGER 1020. 350365.00 CITY ATTORNEY 1030 306800,D0 ADHIN SERVICES 1040 743465,00 BUILDING MANAGEMEN~ t050 537270,00 FACILITY~RENTAL 1050-7!9 1719374,00 INSURANCE COST CE~ER 1060 143047.00 ELECTIONS. COST CEN~ER 1070 6415,00 ACTIVITY TOTAL 3997109,00 PUBLIC SAFETY: POLICE 2010 4458863,00 CROSSING GUARDS COST 2020 52887,00 ANIMAL CONTROL 2030 180700,00 DISASTER PREAPREDNESS 2O50 38544,00 FIRE SERVICES 2060 4210354,00 ACTIVITY TOTAL 8941348.00 TRANSPORTATION: PUBLIC WORKS 3010 393130,00 STREET MAINTENANCE 3020 141720,00 STREET TREE MAINTENANCE 3040 44990,00 STREET LANDSCAPE MAIN~, 3050 214600,00 ACTIVITY TOTAL 794440,00 HEALTH & WELFARE: WASTE MANAGEMENT 5020 6160.00 CHILD CARE 5030 12000.00 ACTIVITY TOTAL 18160,00 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 258848,00 CULTURAL ACTIVITIES 8011 20000,OD HERITAGE CENTER 8012 55272,00 DUBLIN CEM~ERY 8013 21624,DD 33,83- .t- 39733,83 125855,95 83,5 24817,05 295181,34 84.2 55183,66 247807,72 80,8 58992.28 571622,20 76,9 17!842,80 439322,46 81.8 97947,64 1614407,09 93,9 104966,91 85866.28 60,0 57180,72 6308.27 98,3 !06,73 3386337.48 84,7 610771.52 2320450,17 52.0 2138412,83 40564,97 76,7 12322.03 35435,76 19,6 145264,24 30668,94 79.6 7875,06 3650429,83 86,7 559924.t7 6077549,67 68,0 2863798,33 328810,06 83.6 64319,94 114,30 ,1 141605,70 27688,74 61,5 17301,26 163755,16 76,3 508<~,84 520368,26 65,5 274071.74 726,50 11,8 5433,50 9700,71 80,8 2299,29 10427,21 57.4 7732.79 182326,75 70,4 76521,25 20000,00 100.0 .00 37370,93 67,6 17901,07 11433,21 52,9 10190,79 300.15 120445,28 316766.51 220439.41 623479,37 315482,27 1493347.61 164079,95 650.04 3254990,59 4313328,45 48727,64 191931,2t 22300,28 3628257.63 8204545,2t 355585,01 55741,35 43154,47 196217,21 650709,04 5039,06 12000,00 17039.06 216997,00 10000.00 53873,76 36931.78 187.40 62.4 111217,99 92.3 280486.49 BB,5 170553.06 77,4 538820.85 85.4 244509.55 77.5 1493243.6i 100.0 138009,11 84,1 645.24 99.3 2977673.31 91.5 3189532,56 73.9 39053,40 80,2 95892.33 50,0 17721,79 79,5 3321198.91 91,5 6663408,99 81,2 304369,92 85,6 2930,97 5,3 21968.42 50,9 148252,99 75.6 477522.30 73,4 !946.43 38,6 9143.17 76.2 11089,60 65,1 162747,75 75,0 tOOO0,O0 100.0 44033.92 81,7 15764,88 42,7 !12.: 9227.2~ 36280.0Z 49~ '5 84~1~1 70972.72 104.00 26070.84 4.$? 277317.25 1123795,89 9664.24 96038.88 °4578,49 307058,72 1541135.22 51216,09 52810,38 21196,05 47964.22 173185.74 3092,63 2855,83 5949,46 9839,84 21166.90 GL!04C 6/23/99 BUDGET PARK MAINTENANCE 8020 619429.00 COK~UNITY CABLE TV 8030 71141.00 RECREATION ADMIN. 8040 290509.00 PLAYGROUNDS 6045 137665.00 SKANNON CENTER 8050 153998.00 PRESCHOOL 8055 56878.00 TEENS PROGRAM 8060 52778.00 .ADULT SPORTS 8065 84219.00 YOUTH SPORTS 8066 99301.00 SPECIAL EVENTS 8070 145976.00 SENIOR CENTER 8080 124910.00 RECREATION INSTRUCTION B090 122588.00 AgUATiCS 8t00 255751.00 PARKS/FACILiTIES MS,,~TI 8200 26259.00 ACTiViTY TOTAL 2597146.00 COMMUNITY DEVELOPMENT: PLANNING 90t0 944988.00 BUILDING 9020 880947.00 ENGINEERING 9030 1548161.00 /.'*~CONOHIC DEVELOPMENT 9040 184031.00 ACTIVITY TOTAL 3558127.00 CAPITAL IMPROVEMENT FPROBECTS: GENERAL CiP PRO3ECTS 93NN 1330861.76 CO~UNII.-Y IMPROVEMENTS 94NN 72994.DD PARKS 95NN 1261760.00 STRE~ cONSTRC/IMPRV,NFF 96NN 368062.00 ACTIVITY TOTAL 3033677.76 T 0 T A L EXPENDITURES EXCESS (REVENUE)EXPENDITURES TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS THE CITY OF DUBlIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 5/99 GENERAL REVENUE FUND EXCESS (REVENUE)/EXPENDiTURES CURRENT PERIOD ACTUAL PERCENT VARIANCE 370170.35 59.8 51908.52 73.0 231454.28 79.7 1t4176.41 82.9 130282.01 84.6 44063.23 77.5 39399.73 74.7 45709.96 54.3 51123.41 51.5 83524.59 57.2 86O54.64 58.9 96718.9! 78.9 159541.65 62.4 .00 1755258.59 67.6 829117.80 87.7 662459.09 75.2 1388809.01 89.7 114535.00 62.2 2994930.90 84.2 221470.07 16.6 12685.45 17.4 889951.50 70.5 244078.38 -66.3 1368185.40 45.1 22940007.76 16113057.5t 70.2 226629.76 4300805.2!- !897.7- .DO .OD 2531.00 12134212.45 9423.6 249258.65 19232.48 59054.72 23489.59 23715.99 12814.77 13378.27 38509.04 48177.59 62451,41 38855.35 25859.09 96209.34 26259.00 84:i887.41 115870.20 218477.91 159351.99 69496.00 563!96.10 1109391.69 60305.55 371808.50 123983.62 1665492.36 6826950.25 4527434.97 .00 12131681.45- ACTUAL FISCAL YR 551611.39 36347.00 247451.23 119477.39 145355.49 52096.88 34249.32 57312.65 45215.51 95680.81 96151.47 136049.81 23!!82.41 .00 2168993.90 814255.37 6050!1.10 1186462.85 154403.41 2761132.73 412250.17 62322.25 146393.97 366233.78 987200.t7 18044610.70 2850153.03- 24136.65- 8384.92 PAGE PREVIOUS YEAR ENDING JUNE 30. !99-" A~. I U~ P~R~.z N I VARiANZE Y-T-D 394718.94 7!.6 156892.~5 30838.00 B~.8 5509.02 216026.86 87.3 31434.37 99495.!2 S3.3 19981.27 125764.iO 86.5 19591.29 46548.!8 S9.3 5548.70 29630.73 86.5 46i8.59 49344.37 86.1 7958.28 39059.40 85.J 6!55.!i 92376.30 93.6 6304.5! 81051.24 8~.3 15100.23 99480.72 73.2 35569.09 18113~.57 78.4 53043.7z .00 1718020.!8 79.2 ~50973.72 683628.54 54.0 130525.73 507652.17 83.8 98355.92 8o~_.~.37 73.0 320253.45 t30!56.~6 84.3 24235.95 2187641.64 79.2 573491.09 .346079.03 83.9 65!7!.!4 11477.24 18.4 50845.0i 139367.71 95.2 7025.26 425672.i3 1!6.2 59438.25- 922596.!1 93.5 64604.05 14957952.13 82.9 3086558.57 3!97746.59- 112.2 347593.55 10785.46- 44.7 !335!.!9- .00 8384.92 229160.76 7833407.24 3418.3 7604246.48- 2865904.76- 3208532.05- 1i2.0 342627.29 GL!04C 6/23/99 ~REVENUES*~*~x~ PROPERTY TAXES SALES TAX FINES & FORFEITURES USES OF MONEY AND PROPERTY tNTERNGOVERNMENTAL FROM STATE IkqTERGOVERNMENTAL FROM COUNTY INTERGOVERNMENTAL FROM FEDERAL CHkRGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE THE CITY OF DUBLIN sTATEMENT.SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 5/99 SPECIAL REVENUE FUNDS BUDGET CURRENT PERIOD ACTUAL PERCENT VARIANCE 76680.O0- 175500.00- 42400.00- 97330.00- 1493845.00- 145065.00- 330495.40- 698080.00- 139810.00- 3199205.40- 70116.13- 91.4 156263.74- 89.0 53902.36- 127.1 42225.77- 43.4 581746.87- 38.9 149244.00- t02.9 18153.08- 5.5 653002.17- 93.5 22439.87- 16.1 1747093.99- 54.6 6563.87- 19236.26- 11502.36 55104.23- 912098.13- 4179.00 312342.32- 45077.83- t17370.13- 1452111.41- ACTUAL FISCAL YR 74722.5t- 166074.24- 30595.76- 99595.22- 650748.42- 143024.00- 136885.41- 715254.01- 244641.83- 2261541.40- PAGE ¢. 8.1,.: PREVIOUS YEAR ENDING JUNE 3~E ACTUAL PERCENT VAR~NCE Y-T-D 68t52.98- 91.2 6569.53 149858.05- 90.2 16216.19 27628.96- 90.3 2966.80 .00 99595.22 485591.64- 74.6 165056.78 138164.00- 96.6 4860.00. 11440.55- 8.4 125444.86. 658224.63- 92.0 57029.38- 14021.83- 5.7 230620.00- 1553182.64- 68.7 708358.76- ~*~*EXPENDITURES~x~ GENERAL GOVERNMENT ACTiViTIES: BUILDING MANAGEMENT ACTIVITY TOTAL PUBLIC SAFETY: POLICE iT, AFFtC SIGNALS FiRE SERVICES ~ ACTIVITY TOTAL TRANSPORTATION: STREET MAINTENANCE STREE%SWEEPING ~ ACTIVITY TOTAL HEALTH & WELFARE: WASTE MANAGEMENT SENIOR SUPPORT CARE ACTIVITY TOTAL CULTURE & LEISURE SERVICES: PARK MAINTENANCE ACTIVITY TOTAL COMMUNITY DEVELOPMENT: ENGINEERING' ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS PARKS STREET CDNSTRUCTIDN/IMPROV~FF ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE> EXPENDITURE .OD .00 77844.00 104750.00 8t745.00 264339.00 255099.15 90070.00 345169.15 859499.00 7044.00 866543.O0 .00 .00 38900.00 38900.00 60549.40 255307.00 1412027.00 1727883.40 .OD .OD 40916.57 52.6 56731.71 54.2 38986.96 47.7 136635.24 51.7 82357.6t 32.3 69081.85 76.7 151439.46 43.9 809472.15 94.2 5283.00 75.O 814755.15 94.0 .00 .DO 9766.59 25.1 9766.59 25.1 13184.31 21.8 96428.98 37.8 414462.29 29.4 524075.58 30.3 .00 .DO 36927.43 48018.29 42758.04 127703.76 172741.54 20988.15 193729.69 50025.85 1761.00 51787.85 .00 .00 29133.41 29133.4t 47365.09 158878.02 997564.71 1203807.82 175.00 175.00 87354.31 80070.46 79808.20 247232.97 249796.03 78539.83 328335.86 740895.48 7044.00 747939.48 3329.51 3428.52 56396.92 56396.92 233611.81 95432.22 286937.98 615982.01 3242834.55 1636672.02 50.5 1606162.53 1999490.76 43629.15 110421.97- 253.1- 154051.12 262050.64- .OD .00 .00 9468.29 43629.15 110421.97- 253.1- 154051.12 252582.35- i75.00 100.0 175.00 100.0 62112.26 71.1 25242.05 61836.90 77]2 18233.56 44862.32 56]2 168811.48 68.3 152223.83 60.9 97572.20 59642.93 75~9 18896.90 211866.76 64.5 !!6469.!0 739929.69 99.9 965.79 5668.35 80.5 t375.65 745598.04 99.7 2341.44 4431.90 133.1 1102.39- 4530.91 132.2 1102.39- 53389.71 94.7 3007.21 53389.71 94.7 3007.21 228137.66 97.7 5474.15 87569.08 91.8 7863.14 205597.22 71.7 81340.76 521303.96 84.6 94678.05 1705675.86 85'. 3 293814.90 152493.22 58.2- 414543.85- · O0 9468 29 152493.22 60.4- 4o5o t ¢- ~!04C 6/23/99 · SPECIAL BENEFITS ASSESSMENTS USES OF MONEY AND PROPERTY OTHER SOURCES OF REVENUE TOTAL REVENUE THE CITYOF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 5/99 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE 254580.00- 225494.50- 88.6 29085.50- 10300.00- 4691.75- 45.6 5608.25- 2000.00- 2736.05- 136.8 736.05 266880.00- 232922.30- 87.3 33957.70- ACTUAL FISCAL YR 276342.55- 15100.80- 2026.04- 293469.39- PAGE PREVIOUS YEAR ENDING JUNE 30. 199! ACTUAL PERCENT VARIANC~ Y-T-D 234286.68- 84.8 42055.87 .00 15100.80 .00 2026.04 234285.68- 79.8 59182.7! *~.!*EXPENDITURES*****=* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING ACTIVITY TOTAL TEANSPORTATION: PU3L~C WORKS STREET TREE MAINTENANCE STRE~ LANDSCAPE FAiNTENANCE ACTIVZTY TOTAL. HEALTH & WELFARE: ~'~ULTURE & LEISURE SERVICES: D~V~LOPM~NT. ENGINEERING -,. ACTIVITY TOTAL CAPITAL !~ROVEMENT PROJECTS: COMHUNI.~ IMPROVEHENTS STREET CONSTRUCTION/IMPROVHT ~ ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS<REVENUE>EXPENDiTURE EXCESS <REVENUE> EXPENDITURE .00 .00 .OD .00 .00 130987.00 130987.00 4229.00 9600.00 128770.00 142599.00 3980.00 3980.00 .00 .00 .00 277566.OO 10686.00 10686.00 67726.36 51.7 63260.64 67726.36 51.7 63260.64 1991.75 47.1 2237.25 4213.11 43.9 5385.89 72358.37 56.2 56411.63 78563,23 55.1 64035.77 2957.04 74.3. 2957.04 74.3 .00 .00 .00 149246.63 63675.67- 83675.67- 53.8 783.0- 783.0- 1022.96 1022.96 .00 .00 .00 128319.37 94361.67 94361.67 114852.44 t14852.44 3578.12 4084.90 103582.99 111246.01 3465.00 3465.00 27115.00 48938.90 76053.9O 305617.35 12147.96 12147.96 90885.52 79.t 23955.92 90885.52 .79.1 23956.92 3108.19 86.9 469.93 2896.26 70.9 t!88.64 80929.98 78.1 22653.0i 86934.43 78.1 24311.58 3465.00 100.0 .00 3465.00 100.0 .00 7815.D0 28.8 19300.00 47923.88 97.9 1015.02 55738.88 73.3 20315.02 237023.83 77.6 68593.52 2737.15 22.5 9410.81 2737.!5 22.5 94t0.81 ~_!04C 6/23/99 *********************** USES OF MONEY AND PROPERTY O~ER SOURCES OF REVENUE TOTAL REVENUE THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 5/99 CAPITAL IMPROVEMENT FUND BUDGET CURRENT PERIOD ACTUAL PERCENT VARIANCE .00 t1358525.00- 11358525.00- 176098.41- 557839.10- 733937.5!- 176098.41 4.9 10800685.90- 6.5' 10624587.49- ACTUAL FISCAL YR .00 6t5328.94- 615328.94- PAGE 8.19 PREVIOUS YEAR ENDING JUNE ~ ACTUAL PERCENT VARIANt Y-T-D .00 .0 51796.03- 8.4 563532.9 51796.03- 8.4 563532.9 x~**,*xEXPENDiTURES*~xxx* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVtTY TOTAL COMMUNITY DEVELOPMENrT: PLANNING ACTIVITY TOTAL CAPITAL IMPRDVEHENT PRO3ECTS: GENERAL CIP PRO2ECTS COMMUNITY IMPROVEMEk~S PARKS STREET CONSTRUCTION/IMPROVHT :-. ACTIVITY TOTAL T D T A L 'EXPENDITURES EXCESS<REVENUE>EXPENDiTURE TRANSFERS IN FROM OTHER FUNDS TRANSFERS DUTTO OTHER FUNDS EXCESS <REVENUE> EXPENDITURE .00 14500.00 14500.00 16226.00 16226.00 986984.00 94024.00 2768475.00 7481847.00 11331330.00 t1362056.00 3531.00 .00 .00 3531.00 .00 15507.06 15507.05 145.!4 145.!4 105380.44 .00 351656.16 487098.63 944135.23 959787.43 225849.92 .00 .00 225849.92 .00 106.9 1007.06- 106.9 1007.06- 10.7 12.7 6.5 8.3 8.4 6395.2 6396.2 .00 .00 .00 .9 16080.86 3248.58 .9 16080.86 3248.58 881603.55 94024.00 2416818.84 6994748.37 10387194.77 10402268.57 222318.92- .00 .00 22818.06 12000.62 86242.07 419692.52 540753.27 544001.85 71327.09- 27964.95- 42633.31 55658.73- 2223t8.92- .00 .00 .00 32i3.t0 98.9 25.4S 32!3.!0 92.9 35.~ 22934.44 100.5 ]"= SF 11705.62 97:6 77640.34 90.0 180897.69 43.1 238794.83 293179.09 54.2 247574.1~ 295392.19 54.5 247609.56 244596.!6 342.9- 315923.25. · 00 27964.95. 10785.46 25.3 31847.85 255381.62 450.7- 312040.35- 6123/99 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 5/99 TRUST/AGENCY FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE SPECIAL BENEFITS ASSESSMENTS USES OF MONEY AND PROPERTY TOTAL REVENUE .00 199386.71- 199386.71 .00 7537.68- 7537.68 .00 206924.29- 206924.39 PAGE ACTUAL FISCAL YR PREVIOUS YEAR ENDING JUNE 30. 1998 ACTUAL PERCENT VARIANCE Y-T-D 234497.12- 13367.83- 247864.95- 219502.30- 93.6 14994.82- 5847.46- 43.7 7520.37- 225349.76- 90.9 22515.!9- xx~x~xxEXPENDITURES* x*~ x x* GENERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATI ON: HEALTH & WELFARE: ~ULTURE & LEISURE SERVICES: Cb~MUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PRO,]ECTS: TOTAL EXPENDITURES EXCESS(REVENUE)EXPENDiTURE ~'"'"7.SS (REVENUE) EXPENDITURE .,:' · 00 231864.50 231864.50- .00 231864.50 231864.50- .00 .00 232903.25 232903.25 231864.50 23t864.50- 232903.25 24940.!1 24940.11- 14961.70- .00 24940.11 24940.11- 14961.70- 232903.25 100.0 .00 232903.25 100.0 .00 232903.25 100.0 .00 75~3.49 50.5- 22515.19- 7553.49 50.5- 225!5.!9- GL!04C 6f23/99 ~x~*~REVENUES~X~*~ USES oF MONEY AND PROPERTY CRkRGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS'EXPENDITURE FOR THE PERIOD 7/98 THRDUGH 5/99 INTERNAL SERVICE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL FISCAL YR 39604.00- 11928.19- 30.1 27675.81- 26288.45- 737923.00- 666911.73- 90.4 71011.27- 24!988.5t- 30000.00- 17455.06- 58.2 12544.94- 6782.95- 807527.00- 696294.98- 86.2 111232.02- 275059.91- PAGE 8.18.: PREVIOUS YEAR ENDING JUNE ACTUAL PERCENT VARIANCE Y-T-D .00 26288.45 222378.31- 91.9 19610.2C t109.68- 16.4 5673.27 223487.99- 81.3 5157!.92 ~x~EXPENDITURESx~z GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COKMUN~TY DEVELOPMENT: CAPITAL IMPROVEMENT PREL]ECTS: T 0 T A L EXPENDITURES EXCESS<REVENUE>EXPENDiTURE EXCESS <REVENUE> EXPENDTTURE 728134.00 308835.61 42.4 419298.39 235476.79 728134.00 308835.61 42.4 419298.39 235476.79 728134.00 3~8835.61 42.4 419298.39 22~76.79 79393.00- 387459.37- 488.0' 308066.37 39583.12- 79393.00- 387459.37- 488.0 308066.37 39583.12- 96582.23 41.0 138894.55 96582.23 4t.0 138894.56 9~682.23 41.0 138~94.~3 126905.76- 320.6 87322~' 126905.76- 320.6 873~ GL!04C THE CIl~ OF DUBLIN STATEMENT SHOWING PAGE 6/23/99 REVENUES VERSUS EXPENDITURE y?~ ~ ~' -8.18. FOR THE PERIOD 7/98 THROUGH 5/99 ENTERPRISE FUNDS ~xx~,~,REVENUES~ USES OF MONEY AND PROPERTY TOTAL REVENUE CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL FISCAL YR 1827244.00- 1718528.89- 94.1 108715.11- 1590062.53- 1827244.00- 1718528.89- 94.1 108715.11- 1590062.53- PREVIOUS YEAR ENDING JUNE 30. 199, ACTUAL PERCENT VARIANCi Y-T-D 1599941.35- 100.6 9878.8: 1599941.35- 100.6 9878.8~ x~X~EXPENDITURES~x GENERAL GOVERNMENT ACTIVITIES: NO~-DEPARTMENTAL ADMIN SERVICES ACT!Vii~F TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T D T A L EXPENDITURES EXCESS<REVENUE>EXPENDITURES /.jTJ~ANSFERS IN FROM OTHER FUNDS ~ACESS ~REVENUE> EXPENDITURE 17t9394.00 15234638.82 886.0 13515244.82- 1272423.93 3435.00 .DO 3435.00 44~5.00 1722829.00 15234638.82 884.3 13511809.82- 1276838.93 1722829.00 15234638.82 884.3 13511809.82- 1276838.93 104415.00- 13516109.93 2944.6- 13620524.93- 313223.60- .DO 12134212.45- 12134212.45 8384.92- 1252779.68 98.5 19644.25 3415.D0 77.3 t000.00 1256194.68 98.4 20644.25 1256194.68 98.4 20644.25 343746.67- 109.7 30523.07 .OD 8384.92- 1044.15.00- 1381897.48 1323.5- 1486312.48- 321608.52- 343746.67- !06.9 22138.15 /? CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF APRIL I999 Prepared by The Finance Department May 5, 1999 ATTACHMENT 3 '~ GL102 ~ C]TY OF DUBLIN PAGE 1 5/05/99 BALANCE SHEET /5 ~2~'~:' ~ ~/ 10.55.04 FOR THE PER]OD 7/98 THROUGH 4/99 GENERAL SPECIAL SPECIAL CAPITAL TRUST/ T 0 T A L S REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY --- MEMORANDUM ONLY --- FUNDS FUNDS FUNDS FUNDS FUND CURRENT 2UNE 30. 1998 ASSETS CASH CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES -. ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS F!XEDASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS LIAB. FN[~i. BAL. RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS FOR AB1600 FEES DEPOSITS OT~RS PAYABLES :ACCDUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILTIES FUND BALANCES TOTAL FUND EQUITY TOTAL LIAB.FNDBAL. RETD EARNS 14914945.42- 3107741.25 356658.88 10951196.87 150538.01 348810.41- 246580.90- 148685.75 148685.75 142234.52 34888331.85 34888331.85 37174321.17 165501.58 56552.15 222053.73 199287.30 175581.50 9070.t6 8927.86 106990.0t 1941500.00 20156886.03 3271283.41 356658.88 10951196.87 2240723.76 946977.70- 992965.00- 11267419.60- 764981.46- 3547.89- 9070.16- 163315.75- 628.34- 628.25 8114.47- 23878.80- 2059000.00- 1907268.18- 997141.23- 11275861.41- 2059000.00- 18249617.85- 2274142.18- 256658.88- 224664.54 181723.76- 18249617.85- 2274142.18- 356658.88- 324664.54 181723.76- 20156886.03- 3271283.41- 356658.88- 10951196.87- 2240723.76- 1!6060.17 333488.11 8927.85 6263.21 1941500.00 2018500.00 36976748.95 39803194.91 946977.70- 584219.27- 12260384.60- 6825947.03- 777599.51- 844842.39- 163315.74- 147458.06- 8114.47- 39354.56- 23878.80- 71845.25- 2059000.00- 2136000.00- 16239270.82- 10649666.56- 20737478.t3- 29153528.35- 20737478.13- 29153528.35- 36976748.95- 39803194.91- GLi02 5/05/99 CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD 7/98 THROUGH 4/99 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUNDS GROUP OF TERM DEBT FUNDS ACCOUNTS ACCOUNT GROUP PAGE 1 .1o.55.13 TOTALS --- MEMORANDUM ONLY CURRENT JUNE 30"~8 ASSETS CASH CASH WITH FISCAL AGENT UN.AMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS FIXEDASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS LtAB. FND, BAL. RETND E]kRNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES :A~OUNTS INTEREST pAyROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES FUND BALANCE CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY TOTAL LIAB,FND BAL. RE-TD EARNS 880888.97 5172.33 46896,00 1645067.31 19163436.42 6380137.99 2525956.28 19215504.75 6380137.99 28642575.29 28642575.39 14770000.00- 28642575.39- 14770000.00- 28642575.39- 716546.73- 664385.25 1809409.55- 5109890.00- 6380137.99- 2525956.28- 4445504.75- 6380137.99- 2525956.28- 19215504.75- 6380137.99- 28642575.39- 886061.30 521156.65 1728821.03 46895.00 46896.00 27188641.72 24032932.20 28642575.39 18091721.71 56764174.41 44421527 43412575.39- 33626721.71- 43412575.39- 33626721.71- 52161.48- 1229057.02- 6919299.55- 5499059.69- 6380137.99- 4066689.17- 13351599.02- 10794805.88- 56764174.41- 44421527.59- GLI04C ~ THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 5/~5/99 REVENUES VERSUS EXPENDITURE '~ 9.44.59 FOR THE //~ ~ ~¢- ~/ ' PERIOB 7/98 THROUGH 4/99 BUDGET GENERAL REVENUE FUND CURRENT PERIOD ACTUAL PERCENT 'VARIANCE PREVIOUS YEAR ENDING JUNE 30, 1998 ACTUAL ACTUAL PERCENT VARIANCE FISCAL YR Y-T-D *********************** PROPERTY TAXES SALES TAX REAL PROPERTY TRANSFERS TRANSIENT OCCUPANCY TAX FRANCHISE TAXES LICENSES & PERMITS FINES ~ FORFEITURES USES OF MONEY AND PROPERLY INTERGOVERNMENTAL FROM STATE CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 4856100.00- 8200000.00- 235000.00- 337000.00- 815000.00- 1876755.00- 45950.00- 1225530,00- 1308420.00- 3155078.00- 635995.00- 22690828.00- 4429935.26- 91.2 426164.74- 6408796.41- 78.2 1791203.59- 183581.04- 78.1 51418.95- 253622.50- 75.3 83377.50- 733475.28- 90.0 81524.72- 1795829.76- 95,7 80925.24- 50645.67- 110.2 4695.67 1354257.17- 110.5 128727.17 1088982,88- 83.2 219437.12- 2400959.08- 76.1 754118.92- 248053.69¢ 39.0 387941.31- 18948138.74- 83.5 3742689.25- 4351858.66- 3952179.70- 8025447.79- 6040934.16- 231231.24- 134653.50- 306318.00- 233573.00- 759803.34- 662127.34- 1298676.76- 1275111.53- 40421.45- 34325.12- 1556181.29- 1257275.09- 1233812.25- 1010380.!4- 2483860.91- 1610688.35- 507052,04- 462584.96- 20894763.73- 16673832.89- 90.8 399678.96- 75.3 1984513.63- 58.2 96677.74- 76.3 72745.00- 87.1 97676.00- 91.2 123565.23- 84.9 6096.33- 80.8 298906.20- 8!.9 223432.!!- 64.8 873172.56- 91.2 44467.08- 79.8 4220930.84- GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 39700.00  [~COUNCIL 1010 150673.00 ,~ MANAGER 1020' 350365.00 ~iTY A'FfORNEY 1030 306800.00 ADMIN SERVICES 1040 732965.00 BUILDING MANAGEMENT 1050 537270.00 FACILITY RENTAL 1050-7t9 1719374.00 INSURANCE COST CENTER 1060 143047.00 ELECTIONS COST CENTER 1070 6415.00 ACTIVITY TOTAL 3986609.00 PUBLIC SAFETY: POLICE 2010 4457863.00 CROSSING GUARDS COST 2020 52887.00 ANIMAL CONTROL 2030 1807D0.00 DISASTER PREAPREDNESS 2050 38544.00 FIRE SERVICES 2060 4210354.00 ACTIVITY TOTAL 8940348.00 TRARSPORTATtON! PUBLIC WORKS 3010 393130.00 STREET MAINTENANCE 3020 141720.00 STREET TREE MAINTENANCE 3040 44990.00 STRE_~-T LANDSCAPE MAtNT. 3050 214600.00 ACTIVITY TOTAL 794440.00 HEALTH & WELFARE: WASTE MANAGEMENT 5020 6160.00 CHILD CARE 5030 12000.00 ACTIVITY TOTAL 18160.00 ~RE & LEISURE SERVICES: ~RARY SERVICES 8010 258848.00 CULTURAL ACTIVITIES 8011 200DO.O0 HERITAGE CENTER 8012 55272.00 DUBLIN CEM~ERY 8013 21624.00 .00 39700.00 114244.16 75.8 36428.84 266261,07 76.0 84103.93 209190.07 68]2 97609]93 523994.39 71.5 208970.61 402406.32 74.9 134863.68 1614407.09 93.9 104966.91 85779.10 60.0 57267.90 6308.27 98.3 106.73 3222590.47 80.8 764018.53 2272867.72 51.0 2184995.28 36455.41 68.9 16431.59 31530.50 17,4 149169.50 28320.51 7-3.5 10223.49 3324872.87 79.0 88548t.13 5694047,01 63.7 3246300.99 297921.26 75.8 95208.74 114.30 .1 141605.70 23776.10 52.8 21213.90 136587.61 63.6 78012.39 458399.27 57.7 336040.73 726.50 11.8 5433.50 7648.26 63.7 4351.74 8374.76 46,1 9785.24 182326.75 70.4 76521.25 20000.00 100.0 .00 34041.44 61.6 21230.56 10217.26 47.2 11406.74 300.t5 187.40 120445.28 105282,06 316766.51 252040.73 220439.41 170062.02 623479.37 486286,79 315482.27 219810.06 1493347.61 !493243.61 164079.95 101398.25 650.04 6!5.91 3254990.59 2828926.82 4313328.45 2229808.39 48727.64 34953.84 191931.21 95892.33 22300.28 15360.72 3628257.63 3022974.37 8204545.21 5398989.65 355586.01 274743.23 55741.35 2913.54 43164,47 19036.73 196217.21 128629.75 650709.04 425223.25 5039.06 .00 12000.00 7059.26 17039.06 7059.26 216997.00 162747.75 10000.00 10000.00 53873.76 40704.47 36931.78 15206.50 62.4 112.75 87.4 15163.23 79.6 64725.78 77.1 50377.39 78.0 137192.58 69.7 95672.21 100.0 104.00 61.8 62681.70 94.7 34.13 86.9 426063.77 51.7 2083520.05 71.7 13773.80 50]0 96038.88 68.9 6939.56 83.3 605283.26 65.8 2805555.56 77.3 80842,78 5.2 52827.81 44.1 24127.74 65.5 67687.46 65.3 225485.79 5039.06 58.8 4940.74 41.4 9979.80 75.0 54249.25 100.0 .00 75.6 13169.29 41,2 21725.28 GLI04C 5/05/99 PARK MAINTENANCE 8020 COKMUNITY CABLE TV 8030 RECREATION ADMIN. 8040 PLAYGROUNDS 8045 SHANNON CENTER 8050 PRESCHOOL 8055 TEENS PROGRAM 8060 ADUL~'SPORTS 8065 YOUTH SPORTS 8066 SPECIAL EVENTS 8070 SENIOR CENTER 8080 RECREATION INSTRUCTION 8090 AQUATICS 8t00 PARKS/FACILITIES MG,HT 8200 ACTIVITY TOTAL COMMUNITY DEVELOPMENT: PLANNING 9010 BUILDING 9020 ENGINEERING 9030 ECONOMIC DEVELOPMENT 9040 ACTIVITY TOTAL CAPITAL IMPROVEMENT PPROJECTS: GENERAL CIP PROJECTS 93NN COMMUNITY!~'IMPRDVEMENq'S 94NN PARKS ::. 95NN STREET CON~TRC/IMPRVMT 96NN ~' ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS (REVENUE)EXPENDITURES TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS (REVENUE)/EXPENDITURES BUDGET 619429.00 71141.00 290509.00 137665.O0 153998.00 56878.00 5 o28.oo 84219.00 99301.00 130591.00 124910.00 122588.00 255751.00 26259.00 2581011.00 944988.00 880947.00 1548161.00 184031.00 3558127.00 1330418.00 72994.00 1261760.00 368062.00 3033234.00 22911929.00 221101.00 .00 2531.00 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 4/99 GENERAL REVENUE FUND CURRENT PERIOD ACTUAL PERCENT VARIANCE 328112.39 53.0 29t316.61 51908.52 73.0 19232.48 211538.08 72.8 78970.92 103868.09 75.4 23796.91 117588.63 76.4 36409.37 39997.63 70.3 16880.37 34836.57 67.0 17191.43 40573.26 48.2 43645.74 48627.84 49.0 50673.16 79222.84 60.7 51368.16 75877.09 60.7 49032.91 92142.47 75.2 30445.53 154493.16 60.4 101257.84 .00 26259.00 1625372.02 63.0 955638.98 746055.79 78.9 198932.21 589089.22 66.9 291857.78 1216724.42 78.6 331436.58 111169.21 60.4 72861.79 2663038.64 74.8 895088.36 171515.49 ~2.9 1158902.51 11340.64 15.5 61653.26 652556.16 51.7 609193.84 240903.50 65.5 127158.50 1076325.79 35.5 1956908.21 14748147.96 64.4 8163781.04 4199990.78- 1899.6- 4421091.78 .00 .00 12134212.45 9423.6 12131681.45- ACTUAL FISCAL YR 551611.39 36347.00 247461.23 119477.39 145355.49 52096.88 34249.32 57312.65 45215.51 98680.81 96151.47 136049.81 231182.41 .00 2168993.90 814255.37 606011.t0 1186462.85 154403.41 2761132.73 412250.17 62322.25 146393.97 366233.78 987200.t7 18044610.70 2850153.03- 24136.65- 8384.92 PAGE 2 · 9.44.59 PREVIOUS YEAR ENDING JUNE 30, i5~3B ACTUAL PERCENT VARIANCE Y-T-D 355367.20 64.4 196244.19 30035.00 82.6 6312.00 195067.1t 78.8 52394.12 90916.22 76.1 28561.17 114665.84 78.9 30689.65 42192.46 81.0 9904.42 24371.21 71.2 9878.11 43298.97 75.5 14013.68 37873.t5 83.8 7342.36 88326.41 89.5 10354.40 73581.17 76.5 22570.30 94347.59 69.3 41702.22 159942.10 69.2 71240.3t .00 .00 1578643.15 72.8 590350.75 616653.12 75.7 197602.25 452581.26 74.7 153429.84 772688.59 65.1 413774.26 123279.14 79.8 3112~ '- 1965202.11 71.2 79593~ 340629.53 82.6 71620.64 9717.32 15.6 52604.93 136430.80 93.2 9963.17 303755.85 82.9 62477.92 790533.51 80.1 196666.66 12994577.75 72.0 5050032.95 3679255.14- 129.1 829102.11 10785.46- 44.7 13351.19- .00 8384.92 223632.00 7934221.67 3547.9 7710589.67- 2865904.76- 3690040.60- 128.8 824135.84 GLI04C " THE CITY OF DUBLIN]STATEMENT SHOWING PAGE 1 5/05/99 REVENUES VERSUS EXPENDITURE FOR THE / ¢ T''Z '/ 9.46.04 PERiO 7 98 THROUG 4 99 SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL FISCAL YR PREVIOUS YEAR ENDING JUNE 30, 1998 ACTUAL PERCENT VARIANCE Y-T-D *********************** PROPERTY TAXES SALES TAX FINES & FORFEITURES USES OF MONEY AND PROPERTY INTERNGOVERNMENTAL FROM STATE INTERGOVERNMENTAL FROM COUNTY INTERGOVERNMENTAL FROM FEDERAL CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE 76680,00- 70116,13- 91,4 6563,87- 74722,51- 175500,00- 141481.55- 80,6 34018,45- 166074,24- 42400,00- 47571,43- 112.2 5171,43 30595,76- 97330,00- 42225,77- 43,4 55104,23- 99595.22- 1493845,00- 503233,65- 33,7 990611,35- 650748,42- 145065,00- 118444,00- 81,6 26621,00- 143024,00- 328480,00- 16435,96- 5,0 312044,04- 136885,41- 698080,00- 653002,17- 93.5 45077,83- 715254,01- 129810,00- 22150,01- 15,8 117659,99- 244641,83- 3197190,00- 1614660,67- 50,5 1582529,33- 2261541,40- 68152,98- 91,2 135928,49- 81,8 24288,71- 79,4 .00 485110,64- 74,5 114867,00- 80.3 11440,55- 814 654990,35- 91,6 14021,83- 5,7 1508800,55- 66.7 6569,53- 30145.75- 6307,05- 99595,22- 165637,78- 28157.00- 125444,86- 60263,65- 230620,00- 752740.85- x*~*EXPENDITURES~*~ GENERAL GOVERNMENT ACTIVITIES: BUILDING MANAGEMENT ACTIVITY TOTAL PUBLIC SAFETY: '~FFIC SIGNALS ~ ,~RE S~VICES ~:: ACTIVITY TOTAL TRANSPORTATION: STREET MAinTENANCE STREET SWEEPING '~ ACTIVITY TOTAL HEALTH & WELFARE: WASTE MANAGEMENT '. SENIOR SUPPORT CARE ACTIVITY TOTAL CULTURE & LEISURE SERVICES: PARK MAINTENANCE ACTIVITY TOTAL COMMUNITY DEVELOPMENT: ENGINEERING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS PARKS STRE~ CONSTRUCTION/IMPROVMT ACTIVITY TOTAL T 0 T A L EXPENDITURES EXCESS <REVENUE>EXPENDITURE ?-""FERS OUT TO OTHER FUNDS · 00 .00 .00 175.00 .00 .00 .00 175.00 77844,00 104~50,00 81745.00 264339,00 245020,00 90070,00 335090.00 859499,00 7044,00 866543.00 ,00 .00 38900,00 38900,00 58534.00 255307.00 1412027,00 1725868,00 40916,57 52,6 36927,43 87354.31 48387,70 46.2 56362,30 80070.46 38986,96 47,7 42758,04 79808,20 128291,23 48,5 136047,77 247232.97 75147,17 30,7 169872,83 249796,03 62661,67 69.6 27408,33 78539,83 137808,84 41,1 197281,16 328335,86 406234,85 47,3 453264,15 740895,48 5283,00 75.0 1761,00 7044,00 411517,85 47,5 455025,15 747939,48 ,00 .00 3329,51 ,00 .DO 3428,52 6049,79 15,6 32850,21 56396,92 6049,79 15,6 32850,21 56396,92 9067.50 15,5 49466,50 2336tl,81 56445.70 22,1 198861.30 95432,22 410108,60 29,0 1001918,40 286937.98 475621.80 27,6 1250246.20 615982,01 3230740,00 1t59289,51 35,9 2071450.49 1999490,76 33550,00 455371,16- 1357,3- 488921,16 262050.64- · 00 .00 ,00 9468.29 175.00 100.0 175.00 100.0 42540.62 48,7 51068.41 63.8 44862.32 56,2 138471,35 56.0 103353,95 41,4 59642.93 75,9 162996.88 49.6 368911.43 49.8 4773.57 67,8 373685,00 50,0 4431.90 133,1 4530,91 132.2 52555.80 93,2 52555,80 93,2 140927.22 60.3 87569.08 91.8 49105,97 17,1 277602,27 45,1 1010017,2! 50,5 498783.34- 190.3 ,00 .OD .00 44'813.69 29002,05 34945.88 108761.62 146442.08 18896,90 165338,98 371984,05 2270.43 374254.48 1102.39- 1102.39- 3841,12 3841,12 92684.59 7863,14 237832,01 338379,74 989473,55 236732.70 9468,29 EXCESS <REVENUE> EXPENDITURE 33550.00 455371,16- 1357.3- 488921.16 252582,35- 498783,34- 197.5 246200,99 GLI04C 5/05/99 SPECIAL BENEFITS ASSESSMENTS USES OF MONEY AND PROPERTY OTHER SOURCES OF REVENUE TOTAL REVENUE THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 4/99 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE 254580.00- 225494.50- 88.6 29085.50- 10300.00- 4691.75- 45.6 5608.25- 2000.00- .00 2000.00- 266880.00- 230186.25- 86.3 36693.75- ACTUAL FISCAL YR 276342.55- 15100.80- 2026.04- 293469.39- PAGE PREVIOUS YEAR ENDING JUNE 305~ ACT~L PERCENT VARIANCE Y-T-D 227106.64- 82.2 49235,91- .00 15100.80- .00 2026.04- 227106.64- 77.4 66362.75- ~EXPENDITURES~ GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING ACTIVITY TOTAL TRANSPORTATION: PUBLIC WORKS STREET TREE MAINTENANCE STREET LANDSCAPE MAINTENANCE ACTIVITY TOTAL HE~J_TH & WELFARE: CULTURE & LEISURE sERvIcES: COMMUNITY., DEVELOPMENT: ENGINEERING '. ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: CO~2~UNII¥:.IMPROVEMENTS STREET CONSTRUCTION/IMPROVMT ~ ACTIVITY TOTAL 'T 0 T A L EXPENDITURES EXCESS<REVENUE>EXPENDITURE EXCESS <REVENUE> EXPENDITURE .00 .00 .00 .00 .00 130987.00 130987.00 4229.00 9600.00 128770.00 142599.00 3980.00 3980.00 60566.69 46.2 70420.31 60566.69- 46.2 70420.31 1673.32 39.6 2555.68 3755.71 39.1 5844.29 67290.53 52.3 61479.47 72719.56 51.0 69879.44 2957.04 74.3 1022.96 2957.04 74.3 1022.96 .00 .00 .00 .00 .00 .00 .00 .00 .00 277566.00 10686.00 10686.00- 136243.29 93942.96- 93942.96- 49.1 141322.71 879.1- 104628.96 879.1- 104628.96 114852.44 114852.44 3578.12 4084.90 103582.99 111246.01 3465.00 3465.00 27115.00 48938.90 76053.90 305617.35 12147.96 12147.96 73354.17 63.9 41498.27 73254.17 63.9 41498.27 2697.17 75.4 880.95 2528.76 6t.9 1556.14 79234.40 76.5 24348.59 84460.33 75.9 26785.68 3465.00 lDO.O ~ 3465.00 100.0 .00 7815.00 28.8 19300.00 47648.88 97.4 1290.02 55463.88 72.9 20590.02 216743.38 70.9 88873.97 10363.26- 85.3- 22511,22 10363.26- 85.3- 22511.22 GLi04C~ ~ THE CITY OF DU~[I~I STATEMENT SHOWING PAGE i ~/05/99 REVENUES VERSUS EXPENDITURE ~/ ~,~/ 10.1B.27 FOR THE PERIOD 7/98 THROUGH 4/99 CAPITAL IMPROVEMENT FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL FISCAL YR PREVIOUS YEAR ENDING JUNE 30. 1998 ACTUAL PERCENT VARIANCE Y-T-D ~==~REVENUES**X*x** USES OF MONEY AND PROPERTY OTHER SOURCES OF REVENUE TOTAL REVENUE .00 176098.41- 176098.41 .00 11358525.00- 557789.74- 4.9 10800735.26- 615328.94- 11358525.00- 733888.15- 6.5 10624636.85- 615328.94- .00 .00 51796.03- 8.4 563532.91- 51796.03- 8.4 563532.91- GENERAl'- GOVERNMENT ACTIVITI ES: ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATI ON: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION ACTIVITY TOTAL COMMUNITY DEVELOPMENT: PLANNING ACTIVITY TOTAL CAPITAL IMPROVEMENT PROJECTS: 4"-'- ERAL cIP PRO ECTS :.,qMUN }-TY IMPROVEMENTS PARKS ~ STREET CONSTRUCTI ON/I MPROVMT ACTIVITY TOTAL T 0 T A L EXI~ENDITURES EXCESS<REVENUe>EXPENDITURE TRANSFERS IN FROM OTHER FUNDS TRANSFERS OUT TO OTHER FUNDS EXCESS <REVENUE> EXPENDITURE .00 .00 .00 .00 .00 .00 14500.00 14737.06 101.6 237.06- .00 14500.00 14737.06 101.6 237.06- .00 16226.00 145.14 .9 16080.86 3248.58 16226.00 145.14 .9 16080.86 3248.58 986984.00 100737.79 10.2 886246.21 22818.06 94024.00 .00 94024.00 12000.62 2768475.00 323719.73 1t.7 2444755.27 86242.07 7481847.00 371164.81 5.0 7110682.19 419692.52 11331330.00 795622.33 7.0 10535707.67 540753.27 11362056.00 810504.53 7.1 10551551.47 544001.85 3531.00 76616.38 2169.8 73085.38- 71327.09- .00 .00 .00 27964.95- .00 .00 .00 42633.31 .00 .00 .00 .00 2736.04 84.2 512.54 2735.04 84.2 512.54 22667.54 11636.62 41795.14 119812.20 195911.50 198647.54 146851.51 .00 10785.46 3531.00 76616.38 2169.8 73085.38- 56658.73- 157636.97 99.3 150.52 97.0 364.00 48.5 44446.93 28.5 299880.32 35.2 344841.77 36.5 345354.31 205.9- 218178.60- 27964.95- 25.3 31847.85 278.2- 214295.70- GLI04C THE CITY OF DUBLIN STATEMENT SHOW!,~ 5~05~99 REVENUES VE.SUS EXPENDITURE ~OR THE ~ PERIOD ~98 TH~O~H 4~99 PAGE 1 ~10.54.09 TRUST/AGENCY FUND CURRENT PERIOD ACTUAL PERCENT BUDGET VARIANCE ACTUAL FISCAL YR PREVIOUS YEAR ENDING OUNE 30.~'~,1~11¢ ACTUAL PERCENT VARIANCE Y-T-D SPECIAL BENEFITS ASSESSMENTS USES OF MONEY AND PROPERTY TOTAL REVENUE .00 199386.71- 199386.71 234497.12- .00 6460.25- 6460.25 13367.83- .00 205846.96- 205846.96 247864.95- 219502.30- 93.6 14994.82- 5847.46' 43.7 7520.37- 225349.76- 90.9 22515.19- *i*ii*~EXPENDITURES***llxl GENERAC GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROSECTS: TOTAL EXPENDITURES EXCESS(REVENUE)EXPENDITURE EXCESS (REVENUE) EXPENDITURE .00 231864.50 .00 231864.50 231864.5O- 231864.50- 232903.25 232903.25 .00 231864.50 231864.50- 232903.25 .00 26017.54 26017.54- 14961.70- .00 26017.54 260t7.54- 14961.70- 232903.25 100.0 .00 232903.25 100.0 .00 232903.25 t00.0 .00 7553.49 50.5- 225t5.19- 7553.49 50.5- 22515. ~ 9- GLI04C' ~ THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 5/05/99 REVENUES VERSUS EXPENDITURE' 10.!0.32 FOR PERIOD 7/98 THROUGH 4/99 INTERNAL SERVICE FUNDS ~,;;;;;~REVENUES~Xxx;x USES OF MONEY AND PROPERTY CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE CURRENT PERIOD BUDGET ACTUAL PERCENT VARI~J~CE ACTUAL FISCAL YR 39604.00- 11928.19- 30.1 27675.81- 737923.00- 605891.17- 821i 132031:83. 30000.00- 895.06- 3.0 29104.94- 807527.00- 618714.42- 76.6 188812.58- 26288.45- 241988.51- 6782.95- 275059.91- PREVIOUS YEAR ENDING JUNE 30. 1998 ACTUAL PERCENT VARIANCE Y-T-D .00 26288.45- 201144.30- 83.1 40844,21. 1109.68- 16.4 5673.27- 202253.98- 73.5 72805.93- **x,**ZEXPENDITURES**x**** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL PUBLIC'SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PRO2ECTS: TOTAL EXPENDITURES ~E~S<REVENUE>EXPENDITURE~. b^~£SS <~EVENUE> EXPENDITURE 728134.00 307042.57 42.2 421091.43 728134.00 307042.57 42.2 421091.43 728134.00 307042.57 42.2 421091.43 79393.80- 311671.85- 392.6 232278.85 79393.00- 311671.85- 392.6 232278.85 235476.79 235476.79 235476.79 39583.12- 78130.00 33.2 157345.79 78130.00 33.2 157346.79 78130.00 33.2 157346.79 124123.98- 313.6 84540.86 39583.12- 124123.98- 313.6 84540.86 GL!04C 5/05/99 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/98 THROUGH 4/99 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ACTUAL FISCAL YR PAGE PREVIOUS YEAR ENDING JUNE 30~,~mJBsJ ACTUAL PERCENT VARIANCE Y-T-D ~xXX*REVENUES~X~xxxx USES OF MONEY AND PROPERTY TOTAL REVENUE 1827244,00- 1718528,89- 94,1 108715,11- 1827244,00- 1718528,89.- 94,1 108715,!1- 1590062,53- 1599941,35- 100,6 9878.82 1590062,53- 1599941,35- 100,6 9878,82 ~EXPENDITURES~ GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ADMIN SERVICES ACTIVITY TOTAL PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COP~UNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES EXCESS<REVENUE>EXPENDITURES TRANSFERS IN FROM OTHER FUNDS EXCESS JREVENUE> EXPENDITURE 1719394.00 15234638,82 886,0 12515244,82- 1272423,93 3435,00 ,00 3435,00 4415,00 1722829,00 15234638,82 884,3 13511809,B2- 1276838,93 1722829,00 15234638.82 884.3 13511809,82- 1276838,93 1044t5,00- 13516109,93 2944,6- 13620524,93- 313223,60- ,00 12134212,45- 12134212,45 8384,92- 104415,00- 1381897,48 1323,5- 1486312.48- 321608.52- 1252788,78 98,5 19635.i5 3415,00 77,3 1000]00 1256203.78 98,4 20635,15 1256203.78 98,4 20635.15 343737,57- t09,7 30513.97 .00 8384.~· 343737,57- 106,9 221~