The URL can be used to link to this page

Home My WebLink About4.12 Financial Report 02-28-1989 CITY OF DUBLIN AGENDA STATEMENT CITY COUNCIL MEETING DATE: March 13, 1989 SUBJECT Financial Statements for February, 1989 EXHIBITS ATTACHED Balance Sheets and Income Statements RECOMMENDATION : Accept and approve February Financial Statements DESCRIPTION See attached ,/../ y ; COPIES TO: ITEM NO. / -') '._ 7 _, CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF FEBRUARY 1989 Prepared by the Finance Department • • • GLIUZ CITY OF DUBLIN PAGE 1 3/01/89 BALANCE SHEET 12.58.09 FOR THE • PERIOD 7/88 THROUGH 2/89 GENERAL SPECIAL SPECIAL CAPITAL ENTERPRISE REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS . FUNDS FUNDS FUNDS FUNDS ASSETS CASH 6077814.88- 1710964.27 524594.15 1436051.54 2920551.96 UHAHORTIZED BOND DISCOUNT INVESTMENTS AT COST 13994487.37 1772391.10 RECEIVABLES:TAXES ACCOUNTS (NET) 1625.22 • INTEREST 50499.00 ASSESSMENTS 456092.26 RENTS NOTES DUE FROM OTHERS 145289.99 2093692.56 50499.00 INVENTORY AT COST PREPAID ITEMS 2717.00- FIXED ASSETS 11893496.33 AMOUNTS TO BE PROVIDED TOTAL ASSETS .- - - 8060870.70 1710964.27 980686.41 3529744.10 16687437.39 LIAB, END BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 307987.74- . DEPOSITS OTHERS 50622.83- 3125.00- PAYABLES:ACCOUNTS 1449.24- INTEREST PAYROLL 5950.81 DUE TO OTHERS 43653.40 119881.89- 1500.00- 2112038.95- DEBT INSTRUMENTS PAYABLE 715000.00- 17286093.00- TOTAL LIABILTIES 310455.60- 119881.89- 719625.00- 2112038.95- 17286093.00- FUND BALANCES 7750415.10- 1591082.38- 261061.41- 1417705.15- 598655.61 CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 7750415.10- 1591082.38- 261061.41- 1417705.15- 598655.61 TOTAL LIAB,FND BAL, RETD EARNS 8060870.70- 1710964.27- 980686.41- 3529744.10- 16687437.39- • • GL102 . CITY OF DUBLIN PAGE 1 • 3/01/89 BALANCE SHEET 12.58.36 FOR THE • PERIOD 7/88 THROUGH 2/89 INTERNAL TRUST/AGENCY FIXED ASSETS SERVICE FUND GROUP OF FUND ACCOUNTS ASSETS CASH 147592.81 120738.37 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS • RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 8616.00 FIXED ASSETS 153884.21 179451.00 AMOUNTS TO BE PROVIDED TOTAL ASSETS 310093.02 120738.37 179451.00 LIAR, END BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS 102228.75- PAYABLES:ACCOUNTS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE, TOTAL LIABILITIES 102228.75- FUND BALANCE 310093.02- 18509.62- CONTRIBUTIONS • 63309.00- INVESTMENTS IN FIXED ASSETS 179451.00- RETAINED EARNINGS TOTAL FUND EQUITY 310093.02- 18509.62- 179451.00- TOTAL LIAB,FND BAL, RETD EARNS 310093.02- 120738.37- 179451.00- GL104 ITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/01/89 "KEVENUES VERSUS EXPENDITURE 12.34.39 FOR THE PERIOD 7/88 THROUGH 2/89 • GENERAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* PROPERTY TAXES 2741700.00- 1584960.23- 57.8 1156739.77- SALES TAX 5164000.00- 3352056.25- 64.9 1811943.75- . REAL PROPERTY TRANSFERS 92140.00- 56313.14- 61.1 35826.86- TRANSIENT OCCUPANCY TAX 100000.00- 83154.31- 83.2 16845.69- FRANCHISE TAXES 301850.00- 139075.11- 46.1 162774.89- LICENSES & PERMITS 355250.00- 141369.13- 39.8 213880.87- FINES & FORFEITURES 20000.00- 10142.89- 50.7 9857.11- USES OF MONEY AND PROPERTY 747500.00- 816657.48- 109.3 69157.48 INTERNGOVERIIMENTAL FROM STATE 790600.00- 522227.22- 66.1 268372.78- CHARGES FOR SERVICES 810300.00- 343480.55- 42.4 466819.45- OTHER SOURCES OF REVENUE 4000.00- 23293.62- 582.3 19293.62 TOTAL REVENUE 11127340.00- 7072729.93- 63.6 4054610.077 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 617195.00 31.71 617163.29 CITY COUNCIL 83490.00 51770.87 62.0 31719.13 CITY MANAGER 350335.00 198225.78 56.6 152109.22 CITY ATTORNEY 118700.00 62790.68 52.9 55909.32 FINANCE DEPARTMENT 159280.00 86442.82 54.3 72837.18 BUILDING MANAGEMENT 1380150.00 305022.76 22.1 1075127.24 INSURANCE COST CENTER 213125.00 166476.66 78.1 46648.34 ELECTIONS COST CENTER 2650.00 2171.12 81.9 478.88 ACTIVITY TOTAL 2924925.00 872932.40 29.8 2051992.60 PUBLIC SAFETY: POLICE 1891910.00 851117.84 45.0 1040792.16 CROSSING GUARDS COST .00 .00 .00 ANIMAL CONTROL 43000.00 .00 43000.00 TRAFFIC SIGNALS .00 .00 .00 DISASTER PREAPREDNESS 17300.00- 2118.48 12.2 15181.52 FIRE SERVICES OF THE JPA 1864904.00 1707485.50• 91.6 157418.50 ACTIVITY TOTAL 3817114.00 2560721.82 67.1 1256392.18 TRANSPORTATION: PUBLIC WORKS 198300.00 105255.53 53.1 93044.47 STREET MAINTENANCE 42100.00 13373.09 31.8 28726.91 STREET SWEEPING 52800.00 2843.45 54.0 24266.55 STREET TREE MAINTENANCE 80600.00 23421.21 29.1 57178.79 STREET LANDSCAPE MAINTENANCE 158560.00 86459.69 54.5 72100.31 PARATRANSIT SERVICES 2000.00 .00 2000.00 ACTIVITY TOTAL 534360.00 257042.97 48.1 277317.03 HEALTH & WELFARE: VECTOR CONTROL 20500.00 10053.08 49.0 10446.92 . ACTIVITY TOTAL 20500..00 -,-,._,10053.03.. 49.0 10446.92 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 110315.00 53156.00 48.2 57159.00 PARK MAINTENANCE 363600.0 204384.48 55.4 164215.52 COMMUNITY CABLE TV 28500.00 27500.00 96.5 1000.00 RECREATION ADMINISTRATION 119603.00 69869.63 58.4 49733.32 "GL104 I. IT? OF DUBLIN STATEMENT SNOWING PAGE 2 3/01/89 '' ZEVENUES VERSUS EXPENDITURE 12.34.39 FOR THE PERIOD 7/88 THROUGH 2/89 GENERAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE PLAYGROUNDS 60655.00 33239.50 54.8 27415.50 SHANNON CENTER 60823.00 34391.93 56.5 26431.07 PRESCHOOL 32708.00 16169.05 49.4 16538.95 ' TEENS PROGRAM 16398.00 4589.41 28.0 11808.59 FIELD SCHEDULING 3668.00 1590.43 43.4 2077.57 SPECIAL EVENTS 28025.00 11079.39 39.5 16945.61 SENIOR CENTER 69580.00 30117.27 43.3 39462.73 RECREATION INSTRUCTION 49787.00 24509.35 49.2 25277.65 AQUATICS 104543.00 49394.09 47.2 55148.91 ACTIVITY TOTAL 1053205.00 559990.58 53.2 493214.42 COMMUNITY DEVELOPMENT: •• PLANNING 743010.00 274616.39 37.0 468393.61 BUILDING SAFETY 334385.00 168023.48 50.2 166361.52 ENGINEERING 301500.00 135017.69 44.8 166482.31 ACTIVITY TOTAL 1378895.00 577657.56 41.9 801237.44 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 63000.00 24209.08 38.4 38790.92 COh4(UNITY IMPROVEMENTS 712354.00 312963.24 43.9 399390.76 PARKS 523850.63 203826.69 38.9 320023.94 STREET CONSTRUCTION/IHPROVMT 1090294.15 399810.25 36.7 690483.90 ACTIVITY TOTAL 2389498.78 940809.26. 39.4 _._1448689.52 T 0 T A L EXPENDITURES 12118497.78 5779207.67 47.7 633929.0.11 EXCESS <REVENUE>EXPENDITURES 991157.78 1293522.26- 130.5- 2284680.04 TRANSFERS OUT TO OTHER FUNDS .00 1627611.00 1627611.00- EXCESS <REVENUE> EXPENDITURE 991157.78 334088.74 33.7 657069.04 GL104 7 ITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/O]/89 REVENUES VERSUS EXPENDITURE 12.36.51 FOR THE PERIOD 7/88 THROUGH 2/89 • SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SALES TAX 83000.00- 52286.00- 63.0 30714.00- FINES & FORFEITURES 85000.00- 58531.20- 68.9 26468.80- USES OF MONEY AND PROPERTY 40000.00- .00 40000.00 INTERNGOVERNMENTAL FROM STATE 364600.00- 418882.65- 114.9 54282.65 INTERGOVERNMENTAL FROM FEDERAL 1191100.00- 532263.43- 44.7 658836.57- CHARGES FOR SERVICES .00 3250.00- 3250.00 OTHER SOURCES OF REVENUE 288000.00- 1304.25- .5 286695.75- TOTAL REVENUE 2051700.00- 1066517.53- 52.0 985182.47- • *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 PUBLIC SAFETY: POLICE 11550.00 4016.51 34.8 7533.49 CROSSING GUARDS COST 22950.00 .00 22950.00 TRAFFIC SIGNALS 78100.00 41180.17 52.7 36919.83 ACTIVITY TOTAL 112600.00 45196.68 40.1 67403.32 TRANSPORTATION: STREET MAINTENANCE 469700.00 127622.31 27.2 342077.69 PARATRANSIT SERVICES .00 .00 .00 ACTIVITY TOTAL 469700.00 127622.31 27.2 342077.69 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 5000.00 2000.00 40.0 3000.00 ACTIVITY TOTAL 5000.00 2000.00 40.0 3000.00 CAPITAL IMPROVEMENT PROJECTS: CCMIMUNITY IMPROVEMENTS 101100.00 104060.00 102.9 2960.00- PARKS 384200.00 867.60 .2 383332.40 STREET CONSTRUCTION/IMPROVMT 1254300.00 564268.80 45.0 690031.20 ACTIVITY TOTAL 1739600.00 669196.40 38.5 1070403.60 T 0 T A L EXPENDITURES 2326900.00 844015.39 36.3 1482884.61 EXCESS <REVENUE>EXPENDITURE 275200.00 231849.14- 84.2- 507049.14 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 EXCESS <REVENUE> EXPENDITURE 275200.00 231849.14- 84.2- 507049.14 GL1O4 CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/01/89 '.REVENUES VERSUS EXPENDITURE 12.41.04 FOR THE PERIOD 7/88 THROUGH 2/89 • SPECIAL ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 363140.00- 142872.20- 39.3 220267.80- USES OF MONEY AND PROPERTY 39200.00- .00 39200.00- OTHER SOURCES OF REVENUE 5000.00- .00 5000.00- TOTAL REVENUE 407340.00- 142872.20- 35.1 264467.80- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 117638.00 117150.00 99.6 488.00 ACTIVITY TOTAL 117638.00 117150.00 99.6 488.00 PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING 144500.00 75897.14 52.5 68602.86 ACTIVITY TOTAL 144500.00 75897.14 52.5 68602.86 TRANSPORTATION: STREET TREE MAINTENANCE 10300.00 693.36 6.7 9606.64 STREET LANDSCAPE MAINTENANCE 64250.00 21347.44 33.2 42902.56 ACTIVITY TOTAL 74550.00 22040.80 29.6 52509.20 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: PARK MAINTENANCE 13600.00 7209.55 - 53.0 6390.45 - - ACTIVITY TOTAL 13600.00 7209.55 53.0 6390.45 COMMUNITY DEVELOPMENT: ENGINEERING 13500.00 8381.65 62.1 5118.35 ACTIVITY TOTAL 13500.00 8381.65 62.1 5118.35 CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 363788.00 230679.14 63.4 133108.86 EXCESS<REVENUE>EXPENDITURE 43552.00- 87806.94 201.6- 131358.94- EXCESS <REVENUE> EXPENDITURE 43552.00- 87806.94 201.6- 131358.94- •GLIO4 CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/01/89 REVENUES VERSUS EXPENDITURE 12.53.57 FOR THE • PERIOD 7/88 THROUGH 2/89 CAPITAL IMPROVEMENT FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY .00 .00 .00 OTHER SOURCES OF REVENUE 7898.00- 12819.17- 162.3 4921.17 TOTAL REVENUE 7898.00- 12819.17- 162.3 4921.17 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 4000.00 .00 4000.00 PARKS 3898.00 8414.27 215.9 4516.27- ACTIVITY TOTAL 7898.00 8414.27 106.5 516.27- T 0 T A L EXPENDITURES 7898.00 8414.27 106.5 516.27- EXCESS<REVENUE>EXPE}IDITURE .00 4404.90- 4404.90 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 EXCESS <REVENUE> EXPENDITURE .00 4404.90- 4404.90 GL104 ;ITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/0l/89 REVENUES VERSUS EXPENDITURE 12.49.50 • FOR THE PERIOD 7/88 THROUGH 2/89 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 1405183.00- 251204.74- 17.9 1153978.26- OTHER SOURCES OF REVENUE .00 .00 .00 TOTAL REVENUE 1405183.00- 251204.74- 17.9 1153978.26- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1191503.00 183262.76 15.4 1008240.24 CITY MANAGER 21875.00 1288.30 5.9 .20586.70 . FINANCE DEPARTMENT 9750.00 2597.80 26.6 ' 7152.20 ACTIVITY TOTAL 1223128.00 187148.86 15.3 1.035979.14 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADPIINISTRATION 13775.00 5388.37 39.1 8386.63 ACTIVITY TOTAL 13775.00 5388.37 39.1 8386.63 COMMUNITY DEVELOPMENT: ENGINEERING .00 178026.95 178026.95- -- ACTIVITY TOTAL .00 178026.95 178026.95- -"-- CAPITAL IMPROVEMENT PROJECTS: CIVIC CENTER COSTS 8273120.00 • 4177249.70 50.5 4095870.30 ACTIVITY TOTAL 8273120.00 4177249.70 50.5 4095870.30 T 0 T A L EXPENDITURES 9510023.00 4547813.88 47.8 4962209.12 EXCESS<REVENUE>EXPENDITURES 8104840.00 4296609.14 53.0 3808230.86 TRANSFERS IN FROM OTHER FUNDS .00 1627611.00- 1627611.00 EXCESS <REVENUE> EXPENDITURE 8104840.00 2668998.14 32.9 5435841.86 GL104 :ITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/01/89 REVENUES VERSUS EXPENDITURE 12.45.29 FOR THE PERIOD 7/88 THROUGH 2/89 INTERNAL SERVICE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 1440.00- .00 1440.00- CHARGES FOR SERVICES 130060.00- 24417.00- 18.8 105643.00- TOTAL REVENUE 131500.00- 24417.00- 18.6 107083.00- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: N0N-DEPARTMEN1AL 116050.00 27328.86 23.5 88721.14 ACTIVITY TOTAL 116050.00 27328.86 23.5 . 88721.14 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 116050.00 27328.86 23.5 88721.14 EXCESS<REVENUE>EXPENDITURE 15450.00- 2911.86 18.8- 18361.86- EXCESS <REVENUE> EXPENDITURE 15450.00- 2911.86 18.8- 18361.86- . CITY oF DUBLIN Cumulative revenue by fund types MI BUDGET --- ACTUAL `Y.:, ,e z.',.•''Wm"vt .In5': a'S .t.s..w�r rwo". . tt;...'."_':i3 A0 vin Millions 12 10 - 4 \ 0 \ - l• \ Ammoror \ -•� . GENERAL SPECIAL ASSSSMNTS CAPITAL ENTERPR !NTFPNAL S F p.s. molina • • .4) . . CITY OF DUBLiN General Funds REVENUE Vs .EXPENDITURES Millions 14 — - . �_.- -• • i , 12 budgeted expenditure 1 I actual expenditures 6 --- • estimated revenues . . ')"4';5' actual receipts . _ • t.�l Lr1 ,,7* _�• . . ... ,. NEM:',',:! : E . , — <- MIMI 1111111•1111111 • . ''e'd,:g,' •IaL"',.. ----'''Ae.t ='ilIC':ts i', : 11111111111111 :::: ..•... July Aug Sept Oct Nov Dec Jan Feb . . p.s. molina 12-05-88 . •