Loading...
HomeMy WebLinkAbout4.08 Financial Report 06-30-1989 s V CITY OF DUBLIN AGENDA STATEMENT CITY COUNCIL MEETING DATE: August 14, 1989 SUBJECT Financial Statements for Period Ending June 30, 1989 Report prepared by Finance Director EXHIBITS ATTACHED Preliminary Financial Statements RECOMMENDATION (J�( Review and accept report FINANCIAL STATEMENT: See attached DESCRIPTION Attached are the financial statements for the period ending June 30, 1989 . These statements are preliminary in that they do not reflect adjustments that will be made for accruals and the audit. -------------------------------------------------------------------------- i COPIES T0: ITED1 N0. �"'� �} i i i ,i j CITY OF DUBLIN i FINANCIAL STATEMENTS i (PRELIMINARY) FOR THE MONTH OF JUNE 1989 Prepared by The Finance Department i ,LNj2 CITY UP 1A18LIN PDJ 7 1 j 6/30/89 BALANCE SHEET 10.44.71 FOR THE 1 PERIOD 7/88 M", 6/89 (;ENERAL SPECIAL SPECIAL CAPITAL EWMPP.ISE REVENUE REVENUE ASSESSMENT IMPROVEMENt FUNDS FUNDS FUNDS FUNDS FUNDS ASSETS CASH 3155519.51- 1236828.09 705172.32 10108.87 851242.29 i! UNAMORTIZED BOND DISCOUNT j INVES-,� AT COST 15391487.37 1772391.10 RECEIVABLES:TAXES ACCOUNTS (!JET) 1625.22 INTEREST 50499.00 ASSESSMENTS 456092.26 REHTS NOTES DUE FROM OTHERS 76469.7799 INVE)MRT AT COST PREPAID ITEMS 16553.55 FIM ASSETS 118934%.33 AMOUNTS TO BE PROVIDED TOTAL ASSETS 12330616.40 1236828.09 1161264.58 10108.87 14618127.72 LIAB, FND BAL, RETND E- INGS DEPOSITS FOR PRIVATE DEVELPMNT 338628.01- ; DEPOSITS OTHERS 50152.90- 3L5.00- PAYABLES:A000UNTS 3164.35- INTEREST PAYROLL 32.15 DUE TO OTHERS 1089.09 8660.00- 1500.00- 60748.06- :: DEBT INSTRUMENTS PAYABLE 715000.00- 17286093.00- TOTAL LIABII TIES 390824.02- 8660.00- 71 9625.00- 60748.06- 17286093.00- FUND BALANCES 11939792.38- 1228168.09- 441639.58- 50639.19 2667%5.28 CONTRIBUTIONS INVES'i!(SATS IN FIXED ASSETS RETAINED EARNINGS ' j TOTAL FUND EQUITY 11939792.38- 1228168.09- 441639.53- 50639.19 2667 965.28 TOTAL LIAB,FND BAL, WrD EARNS 12330616.40- 1236928.09- 116126:1.58- 10108.87- 14618127.72- L1CIl CIT7 UP DUBLIN � PAGE 1 G 6/30/89 BALANCE SHEET 10.45.33 FOR THE ' PERIOD 7/88 THROUGH 6/89 INTERNAL TPOST/AGENCY FIRED ASSETS SERVICE FUND GROUP OF FUND ACCOUNTS ASSETS CASH 204884.99 114838.37 i UNAMORTIZED BOND DISCOUNT j i DVI S AOM AT COST RBCEIVABLES:TAXES ACCOUNTS (ITLT) INTEREST ASSESSMENTS RENTS ' NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 8616.00 FIRED ASSETS 153884.21 179451.00 A."SOU lrS TO BE PROVIDED TOTAL ASSETS 367385.20 114838.37 179451.00 L1AB, FND BAL, REM Er I)r-rNGS DEPOSITS FOR PRIVATE UEVELPPWT DEPOSITS OTHERS 96328.75- PAYABLFS:A000UNPS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES 96328.75- FUND BALANCE 367385.20- 18509.62- COWRiBUTIONS 63309.00- INVESTTIE}TPS IN FIXED ASSETS }79151.00- RETAINED EARNINGS TOTAL FUND EQUITY 367385.20- 18509.62- 179451.00- ' TOTAL LIAB,FND BAL, RETD EARNS 367385.20- 114838.37- 179-151.00- I GLICA THE CITI OF DUBLIN S7ATEMEN? SiirJ4fIN(I PAGE ] 6/30/89 REVENUES VERSUS E7.PENDI7URE 10.24.32 FOR THE PERIOD 7/88 THRO 3H 6/89 GENERAL REVE'fUE FUNDS ' CURRENT PERIOD BUDG1'1 ACTUAL PERCENT VARIANCE PROPERT7 TP ES 2741700.00- 3039269.80- 110.9 297569.80 SALES TAX 5164000.00- 5259902.13- 101.9 95902.13 REAL PP.OPERTI TRANSFERS 92140.00- • 95436.61- 103.6 3296.61 TRANSIENT OCCUPANCY TAX 100000.00- 108197.25- 108.2 8197.25 'j FRANCHISE TAXES 301850.00- 319468.23- 105.8 17618.23 LICENSES & PERMITS 355250.00- 292099.37- 82.2 63150.63- FINES & FORFEITURES 20000.00- 16197.75- 81.0 3802.25- USES OF MONE7 AND PR.OPERTI 747500.00- 1309861.92- 175.2 562341.92 :? D -TERNGO'.'ERNKENTAL FROK STATE 790600.00- 873472.81- 110.5 82872.81 CHARGES FOR SERVICES 810300.00- 774554.32- 95.6 35745.68- ! OTHER SOURCES OF REVENUE 4000.00- 39629.04- 990.7 35629.04 TtTkL REVENUE 11127340.00- 12128089.73- 179.0 1000749.23 *******EeENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPA.RTKE'TTAL 617195.00 60073.49 9.7 557121.51 CITY COUNCIL 83490.00 72126.01 86.4 11363.99 rill KLITAGER 350335.00 320798.00 91.6 29537.00 C'jTY ATTORNEY 118700.00 93031.47 "0•£.4 25668.53 FINANCE DEPARTMENT 159280.00 147900.11 92.9 11379.39 BUILDING MANAGEMENT 1380150.00 276993.71 20.1 1103156.29 INSURANCE COST CENTER 223925.00 181853.70 31.2 42071.30 ELECTIONS COST CENTER 2650.00 2171.12 81.9 978.88 ACTIVI'Ff TOTAL 2935725.00 1114947.61 39.3 1780777.39 PUBLIC SIFETY: POLICE 1891910.00 1315746.92 69.5 576163.03 CROSSING GUARDS COST •00 •00 •00 ANIMAL CONTROL 43000.00 34011.89 79.1 8983.11 TRAFFIC SIGNALS .00 .00 .00 DISASTER PREAPREDNESS 17300.00 3223.86 18.6 14076.14 FIRE SERVICES OF THE JPA 1864904.00 1864904.00 100.0 .00 ACTIVITY TOTAL 3817114.00 3217886.67 84.3 599227.33 i TRANSPORTATION: PUBLIC 4()RKS 199300.00 172155.30 86.8 26144.70 STREET MAINTENANCE 26100.00 22708.17 87.0 3391.83 STREET SWEEPING 52300.00 45167.40 86.1 7332.60 57REL7 'fRFF MAINTENANCE 80600.00 49672.0.1 61.6 30927.96 SI RKET LANDSCAPE: HA I KrFNm+CE 1581A0.00 135338.89 85.4 23221.11 i,,wvmANSIT SERVICES A100.00 2000.(() 100,0 ,00 ACTIVITY 'Rrl'Al. 518360.(K1 -1273.11.011 82.4 91U1U.:ll HEALTH & NFLFARE: VE:I'NR Ct1Nl'RI�I, ?,(1!11(1.0(1 14!� l.pt1 77..8 "1''02.92 •' ('UI:111RK ,1. LE t"llkh: :�E:RV I�k:t: i I.1tZARY SiliVlt'F-lS 1.10,111.(K) !t0'il_I iXl 71.2 ln!�Ul.(KI 1'.1RK MAIYCF'NAttCE: 1611(i(KL(K1 02.1 06015.:1!i c'(WRINITY CANX TV 20!101,0(1 711.410.(xi >t..S 1000.(KI RECREATION N)MINI: (RATION I1!160A.00 1110.1,1. 1;? 14.5 6564.6A 6L1(4 T,. ;1 OF DUBLIN SCI?Tf}On SHOVING PAGE 2 6/30/89 REVENUES VERSUS MENDITURE 10.24.32 FOP. THE PERIOD 7/88 THROUGH 6/89 i i GENERAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PEP.CENT VARIANCE PLAYGROUNDS 60655.CA 53801.93 88.7 6853.07 SHANNON CENTER 60823.00 51438.39 84.6 9384.61 PRESCHOOL 32708.00 29778.03 91.0 2929.97 TEENS PROGRAM 16398.00 15282.82 93.2 1115.18 FIELD SCHEDULING 3668.00 291.7.45 79.5 750.55 SPECIAL EVENTS 28025.00 20686.45 73.8 7338.54 SENIOR CENTER 69580.00 55905.95 80.3 13674.05 Rc6r.EATION INSTRUCTION 49787.00 ,42710.60 84.9 7516.40 AQUATICS 104543.00 96156.57 92.0 8386.43 ACTIVITi TOTAL 1053205.00 892095.17 84.7 161109.83 CGY4iUNITY DEVELOPMENT: PLA1DUG 743010,00 671859.47 90.4 71150.53 BUILDING SAFETY 334385.00 270980.27 81.0 63404.73 ENGINEERING 301500-00 242936.11 80.6 58563.89 Acn ITi TOTAL 1378895.00 1185775.85 86.0 193119.15 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 63000.00 30601.35 48.6 32398.65 CA`RT'J4ITY I)TROVEM"'S 720070.00 502672.85 69.8 217397.15 PAS 887329.44 370160.06 41.7 517169.38 STREET CONSTRUCTION/FROM 815294.15 378964.10 46.5 436330.05 ACT14'ITY TOTAL 2485693.59 1282398.36 51.6 1203295.23 T O T A L EXPENDITURES 12209492.59 8175372.54 67.0 4034120.05 EXCESS <REVENDFJEXPENDITURYS 1082152.59 3952716.69- 365.3- 5034869.28 TRANSFERS IN FROM OTHER FUNDS .00 10839.50- 10839.50 TRANSFERS OUT TO OTHER FUND6 .00 1627611.00 1627611.00- EXCESS <REVENUE> EXPENDITURE 1082152.59. 2335945.19- 215.9- 3418097.78 i i :j GL1CN THE CITY OF DUBLIN STATEMENT SHOWING 6/:4/89 REVENUES VEPZUS EXPENDITURE 10.27.11 • FOP. THE PERIOD 7/88 THROUGH 6/89 SPECIAL REVENUE FU1rDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ***A****RLVE1lUES*****- '. SALES TAR 83000.00- 8YA16.00- 106.5 5416.00 ' FIVES & FORFEITURE., 85000.00- 88442.97- 1(4.1 3442.97 USES OF MONE'i A11D PROPERTY 40000.00- .00 40000.00- ,! D17ERNGOVERNMENTAL FROM STATE 364600.00- 595475.20- 163.3 230875.20 IyrERGOVBRNM N TAL FROM FEDERAL 1191100.00- 1054226.37- 88.5 136873.63- ' 7THER SOURCES OF REVENUE 288000.00- 4237.95- 1.5 283762.15- ' TOTAL REVENUE 2051700.00- 1830793.39- 89.2 220901.61- • GENERAL GOVE]UMi n ACTIVITIES: CIT7 COUNCIL DO 2478.25 2478.25- ACTIVITY TOTAL .00 2478.25 2478.25- ' PUBLIC SAFETY: POLICE 11550.00 6065.15 52.5 5484.85 CROSSING GUARDS COST 22950.00 15010.40 65.4 7939.60 TRAFFIC SIGNALS 78100.00 52000.11 66.6 26093.89 ACTIVITY TOTAL 112600.00 73081.66 64.9 39518.34 TRANSPORTATION: BEST MAINTEMCE 535927.00 402086.17 75.0 133840.83 PARATRANSIT SERVICES .00 .00 .00 ACTIVITY TOTAL 535927.00 402036.17 75.0 133840.83 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: CCMUNITY DEVELOPMENT: ENGINEERING 16566.00 6561.43 39.6 10004.57 ACTIVITY TOTAL 16566.00 6561.43 39.6 10004.57 CAPITAL I!g'ROVEMFNT PROJECTS: CCrMNITY IMPROVEMEINTS 101100.00 104060.00 102.9 2960.00- PARRS 384200.00 160416.84 41.8 223733.16 STREET CONSTRUCTION/I'O?ROVMT 1330654.00 1165544.23 87.6 165109.77 ACTIVITY TUTAL 1815954.00 1430021.07 78.7 385932.93 T O T A L EXPENDITURES 2481047.00 1914228.59 77.2 566818.42 EXCESS <REVENUFJEXPENDITURE 429347.00 83430.19 19.4 345916.81 TRANSFERS OUT TO 0711ER FUNDS .00 50000.00 50000.00- EXCESS <RF.VF.NIIFJ F.XPk•.NDlTl1RE 4293.17.00 133430.19 31.1 295916.81 '•i T}:F. CITY OF DUBLIN STATEMENT SIMIN9 PAGE GL104 ]0.'/).41 6/Jj�9 Y,b"VENUES VERSUS MENDITURE FOP. THE PERIOD 7/B8 THROUGH 6/B9 SPECIAL PSSESMon FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE *R******REVENUES******* SPECIAL BENEFITS ASSESS NTS 363140.00- 388687.42- 101.0 25547.42 USES OF HONEY AND PPOPER7Y 39200.00- .00 35000 �.00- :• OTHLR SOURCES OF REVE:+'T)E `x•00- �� ' ;YRAL REVEN[1E 407340.00- 388687.42- 95.4 18652.58- *******EXPENDITURES******" GENERAL GOVERNMENT ACTIVITIES: ` NON-DEPARTMENPAL 117638.00 117150.00 99.6 488.00 2CTIVITY TOTAL 117638.00 117150.00 99.6 488.00 PUBLIC SAFETY: TRFC SIGS/STREET LIG1 MG 14450O.D0 121645.76 84.2 22854.24 ACPIVITj TOTAL 144500.00 121645.76 84.2 22854.24 TRANSPORTATION: STREET TREE MAIN'PF.'IKCE 10300.00 1367.16 13.3 8932.84 STREET LANDSCAPE N I'fiPLNANCE 64250.00 35407.04 55.1 28842.96 ,ICTIV-I-1Y TOTAL 74550.00 36774.20 44.3 37775.80 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: PARK MAINTENANCE 13600.00 11588.64 85.2 2011.31 ACTTVI-11 TOTAL 13600.00 11588.69 85.2 2011.31 Ca...SJNITY DEVELOPMENP: ENGMERING 13500,00 10574.50 78.3 2925.50 ACTB= TOTAL 13500.00 10574.50 78.3 2925.50 CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES 363788.00 297733.15 81.8 66054.85 EXCESSQtEVENUFJEXPENDITURE 43552.00- 90954.27- 203.8 47402.27 EXCESS <REVENUF> EXPENMITURE 43552.00- 90954.27- 208.8 47402.27 I • GL 104 741E CITI OF DUBLIN STATEMENT S11C1dlA PAGE 1 6/YJ/89 REVENUES VERSUS E10MITURE 10,40.50 FOR THE PERIOD 7/88 THROUGH 6/89 CAPITAL IHPP.07E O" FUIID .i CURRENT PERIOD BUIJ;ET ACTUAL PERCENT VAP.IANCE • *****'�**REVENUES***'�*"* USFS GF MOM AND PP.OPERT7 •00 •00 •00 ` OTHER SOURCES OF REVENUE 131.00- 18434.17- 4071.9 18'03.17 TOTAL REVENUE 131.00- 18434.17- 4071.9 18303.17 I; ****A**ERPENDITURES*x***** GENERAL GOVERL1tLENT ACTIVITIES: -- .00 .00 .00 NUN-DEPARTMENTAL ACTIVITY TOTAL .00 .00 .Do PUBLIC SAFETY: ' TRANSPORTATION: ST T1+'f REET LANDSCAPE HAENANCE .00 •00 .00 ACTIVITY TOTAL .00 •00 .00 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COelUNITY DEVELOPMENT: ENGLWJ3MIG .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 CAPITAL IMPROVEM11T PROJECTS: MMUNITY IHPP.OVE On S 4000.00 4000.00 100.0 .00 PARKS 11665.00 12327.63 105.7 662.63- .. ACTIVITY TOTAL 15665.00 16327.63 104.2 662.63- T O T )! L EhPENDITURES 15665.00 16327.63 104.2 662.63- : EXCESS<2EVENUFJE%PENDITURE 15534.00 2106.54- 13.6- 17640.54 TRANSFERS IN FROM OTHER FUNDS .00 50000.00- 50000.00 i EYCFja <REVENU© EXPENDITURE 15534.00 52106.54- 335.4- 67640.54 i GL 104' THE wT7 OF DUBLIN STATEM?T Slir-PING PAGE 1 6/30/89 REVENUES VERSUS E7PE}fUTI'JRE 10.37.21 • flop T11E •j PEP.IOD 7/88 T1'P Lvll 6/69 ENTERPRISE FUNDS 1 l CURRENT PERIOD BUDGET ACTUAL PERCENT VARDIKE ********REVENUES"****** USES OF MONEY AND PROI'ERT7 1405183.00- 181150.73- 22.9 1224032.27- ; OTHER SOURCES OF REVERE 00 4370.00- 4370.00 TrrAL REVENUE 1'105183.00- 185520.73- 13.2 1219662.27- ******EXPENDITURES** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1204783.00 157613.78 13.1 1047169.22 CITY MANAGER 21875.00 13075.15 59.8 8799.85 CITY ATTORNEY .00 .00 r .00 • FINANCE DEPARTMENT 9750.00 8314.89 85.3 1435.11 ACnVIT-1 TOTAL, 1236408.00 179003.82 14.5 1057404.18 PUBLL, SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 13775.00 11935.31 86.6 1839.69 • ACTIVITY TOTAL 13775.00 11935.31 86.6 1839.69 COf2fUtITY DEVELOPMENT: e"NGINTERING 249840.00 316322.26 126.6 66482.26 - ACTIVITY TOTAL 249840.00 316322.26 126.6 66482.26- CAPITAL IMPROVEMENT PROJECTS: CIVIC CENTER COSTS 8010000.00 6038338.65 75.4 1971661.35 ACTIVITY TOTAL, 8010000.00 6038338.65 75.4 1971661.35 T 0 T A L EXPENDITURES 9510023.00 6545600.04 68.8 2964422.96 EXCESS<REVENUFJEXPENDITURES 8104840.00 6360079.31 78.5 1744760.69 TRANSFERS IN FROM OTHER FUNDS .00 1627611.00- 1627621.00 TRANSFERS OUT TO OTHER FU.`NLl4 .00 5339.50 5839.50- ' EXCESS <REVENUE> EXPENDITURE 8104840.00 4738307.81 58.5 3366532.19 THE CITI OF DUBLIN STATEMENT SlUaNG PDbE l GLiD4. 10.33.53 ' LI04.89 REVENUES VEP,SUS EXPENDITUP.E FOR THE PERIOD 7/88 THROU H 6/89 ILTPEPHAL SERVICE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF YMEY AND PROPERT7 1410.00- .00 1440.00- CHARGES FOR SERVICES 130060.00- 97076.80- 74.6 32983.20- TOTAL REVENUE 131500.00- 97076.80- 73.8 34423.20- 1 ******* ******* EXPENDITURES GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 116050.00 42696.98 36.8 73353.52 ACTIVITY TOTAL 116050.00 42696.48 36.8 73353.52 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMmUKM DEVELOPMENT: CAPITAL IMPROVDOn P.40JECTS: T O T A L EXPENDITURES 116050.00 42696.48 36.8 73353.52 EXCESSGEVENMEXPENDI"IM 15450.00- 54380.32- 352.0 38930.32 EXCESS CREVENUEJ EXPENDITURE 15450.00- 54380.32- 352.0 33930.32 i i