The URL can be used to link to this page

Home My WebLink About4.8 Financial Report 09-30-1991 CITY OF DUBLIN AGENDA STATEMENT MEETING DATE: October 10, 1991 SUBJECT :Financial reports for the month of September 1991 Prepared by Phillip S. Molina EXHIBITS ATTACHED :B ance Sheets and Income Statements RECOMMENDATIO \ Accept and file the financial reports FINANCIAL STATEMENT:(See reports) DESCRIPTION: These reports represent the results of all the financial transactions for the first quarter in this fiscal year. There are two trends in the Income statements that are present. The first trend is the overall decrease in the General Fund revenues when compared to the amount received at this time last year. Though this amount is not large (less than $6,000) it represents the first time that Dublin has revenues in the first quarter that is less than the same quarter of the prior year: FIRST QUARTER DATA GENERAL FUND TOTAL REVENUES year amount change percent 91192 $2,156,822.42 (5,201.88) -.24% ,90/91 $2,162,024.30 187,779.34 9.51% 89190 $1,974,244.96 251,546.96 14.60% 88189 $1,722,698.00 - The main reason for the decrease in revenues in the current year is the decrease in the sales tax revenues received. The State Board of Equalization, which is the State agency charged with sales tax collection, identified that the total taxable sales revenue collected and allocated to the City is down compared to the same quarter last year. The State also made a mistake and paid the City $153,446.91 too much in June. The adjustment for this overpayment was made in August. When both factors are combined, the overall decrease in taxable sale is 6%. According to the State and other Municipal Finance Directors, the sales tax revenues in some other cities are down for September by as much as 21%. This situation is .being monitored for any changes. The second trend is the higher expenditures in the General Fund than in prior years. The main transaction that produced this anomaly is the amounts paid to Foster City for FAU funds. The anomaly, which is an unusual occurrence, is simply due to the fact that there were no payments for FAU fund in the first quarter of last year. The FAU payments began in February 1991 and will continue through the current month. ------------------------------------------------ --- fi'T"1f-- Ct-E-FfF COPIES T0: ITEM NO. FILE 3 Q CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF SEPTEMBER 1991 Prepared by The Finance Department BGL102 CITY OF DUBLIN PAGE 1 BGL10291 BALANCE SHEET 13.59.17 FOR THE PERIOD 7/91 THROUGH 9191 GENERAL SPECIAL SPECIAL CAPITAL REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS FUNDS FUNDS FUNDS ASSETS CASH 229852.89 602476.87- 961210.24 90682.95- CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 1250.00 INVESTMENTS AT COST 15265310.26 RECEIVABLES:TAXES 230898.13- ACCOUNTS (NET) 89360.01- 497800.15- INTEREST 199249.44- ASSESSMENTS 270572.83 RENTS NOTES DUE FROM OTHERS 250696.49 INVENNTORY AT COST PREPAID ITEMS 4685.50 FIXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS 15232287.56 1100277.02- 1231783.07 90682.95- LIAB, FND BAL, RETHD EARNINGS DEPOSITS FOR PRIVATE DEVELPMMT 244786.54- DEPOSITS OTHERS 130926.92- 3125.00- PAYABLES:A000UNTS 1178394.28 124672.47 26048.58 925.00 INNTEREST PAYROLL 74197.08 DUE TO OTHERS 48020.35- 240536.49- 1500.00- DEBT INNSTRUMENNTS PAYABLE 605000.00- TOTAL LIABILTIES 828857.55 115864.02- 583576.42- 925.00 FUND BALANCES 16061145.11- 1216141.04 648206.65- 89757.95 TOTAL FUND EQUITY 16061145.11- 1216141.04 648206.65- 89757.95 TOTAL LIAB,FNND BAL, RETD EARNS 15232287.56- 1100277.02 1231783.07- 90682.95 CITY OF DUBLIN PAGE 1 BGL102 BGL10291 BAL31 10E SHEET 14.00.08 FOR THE PERIOD 7/91 THROUGH 9191 INTERNAL ENTERPRISE FIXED ASSETS SERVICE FUNDS GROUP OF FUND ACCOUNTS ASSETS CASH 251468.01 540263.50- CASH WITH FISCAL AGENT 1714537.60 UNAMORTISED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) 768.68- INTEREST 44632.03 ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 8616.00 1724.03 FIXED ASSETS 190856.57 22364521.57 379709.98 AMOUNTS TO BE PROVIDED TOTAL ASSETS 450171.90 23585151.73 379709.98 LIAB, FND BALI RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:A000UNTS 104847.90- INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 17320767.00- TOTAL LIABILITIES 17425614.90- FUND BALANCE 355893.90- 1056413.83- CONTRIBUTIONS 94278.00- 5103123.00- INVESTMENTS IN FIXED ASSETS 379709.98- RETAINED EARNINGS TOTAL FUND EQUITY 450171.90- 6159536.83- 379709.98- TOTAL LIAB,FNN) BALI RETD EARNS 450171.90- 23585151.73- 379709.98- BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 REVENUES VERSUS EXPENDITURE 13.32.52 10/01191 FOR THE PERIOD 7/91 THROUGH 9/91 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* PROPERTY TAXES 4034100.00- 266307.72- 6.6 3767792.28- SALES TAX 6300000.00- 1075429.94- 17.1 5224570.06- REAL PROPERTY TRANSFERS 76000.00- 19420.96- 25.6 56579.04- TRANSIENT OCCUPANCY TAX 100000.00- 23284.00- 23.3 76716.00- FRANCHISE TAXES 434500.00- 26958.39- 6.2 407541.61- LICENSES & PERMITS 474700.00- 74752.78- 15.7 399947.22- FINES & FORFEITURES 19500.00- 5299.19- 27.2 14200.81- USES OF MONEY MID PROPERTY 1091100.00- 103096.36- 9.4 988003.64- INTERNGOVERNMENTAL FROM STATE 939366.00- 222385.90- 23.7 716980.10- CHARGES FOR SERVICES 1209905.00- 208262.51- 17.2 1001642.49- OTHER SOURCES OF REVENUE 54600.00- 131624.67- 241.1 77024.67 TOTAL REVENUE 14733771.00- 2156822.42- 14.6 12576948.58- *******EXPENIDITURES-****** GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 388913.00 243200.00 62.5 145713.00 CITY COUNCIL 1010 160669.00 21814.06 13.6 138854.94 CITY MANAGER 1020 506645.00 87088.88 17.2 419556.12 CITY ATTORNEY 1030 128250.00 26405.13 20.6 101844.87 FINANCE DEPARTMENT 1040 247049.00 46589.62 18.9 200459.38 DATA PROCESSING (FIN) 1045 35500.00 .00 35500.00 BUILDING MANAGEMENT 1050 2083890.00 62451.92 3.0 2021438.08 INSURANCE COST CENTER 1060 166600.00 142810.11 85.7 23789.89 ELECTIONS COST CENTER 1070 .00 .00 .00 ACTIVITY TOTAL 3717516.00 630359.72 17.0 3087156.28 PUBLIC SAFETY: POLICE 2010 2794073.00 19896.28 .7 2774176.72 CROSSING GUARDS COST 2020 33120.00 .00 33120.00 ANIMAL CONTROL 2030 56000.00 12554.75 22.4 43445.25 TRAFFIC SIGNALS 2040 72550.00 4356.01 6.0 68193.99 DISASTER PREAPREDNNESS 2050 42085.00 4000.82 9.5 38084.18 FIRE SERVICES JPA 2060 2578993.00 618957.00 24.0 1960036.00 ACTIVITY TOTAL 5576821.00 659764.86 11.8 4917056.14 TRANSPORTATION: PUBLIC WORKS 3010 282015.00 50023.89 17.7 231991.11 STREET MAINTENANCE 3020 328100.00 14607.17 4.5 313492.83 STREET SWEEPING 3030 62000.00 9763.00 15.7 52237.00 STREET TREE MAINTENANCE 3040 66500.00 6591.67 9.9 59908.33 STREET LANDSCAPE MAINT. 3050 208850.00 27112.04 13.0 181737.96 PARATRA.NSIT SERVICES 3060 1500.00 1500.00 100.0 .00 ACTIVITY TOTAL 948965.00 109597.77 11.5 839367.23 HEALTH & WELFARE: VECTOR CONTROL 5010 28296.00 .00 28296.00 W.STE MANAGEMENT 5020 33255.00 4023.00 12.1 29232.00 ACTIVITY TOTAL 61551.00 4023.00 6.5 57528.00 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 156007.00 .00 156007.00 CULTURAL ACTIVITIES 8011 44140.00 8000.00 18.1 36140.00 GL104 THE CITY OF DUBLIN STATEMENT SHOWING P'-..GE 2 10/01/91 REVENUES VERSUS EXPENDITURE 13.32.52 FOR THE PERIOD 7/91 THROUGH 9/91 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIJICE PARK MAINTENANCE 8020 545270.00 92481.84 17.0 452788.16 COMMUNITY CABLE TV 8030 49000.00 24000.00 49.0 25000.00 RECREATION ADMIN. 8040 171625.00 32618.17 19.0 139006.83 PLAYGROUNDS 8045 66924.00 17559.59 26.2 49364.41 SH.b.NNON CENTER 8050 105787.00 19571.27 18.5 86215.73 PRESCHOOL 8055 32057.00 3952.13 12.3 28104.87 TEENS PROGRAM 8060 47185.00 8562.37 18.1 38622.63 FIELD SCHEDULING 8065 133395.00 30561.88 22.9 102833.12 YOUTH SPORTS 8066 31739.00 2316.92 7.3 29422.08 SPECIAL EVENTS 8070 27791.00 3466.98 12.5 24324.02 SENIOR CENTER 8080 103970.00 17552.55 16.9 86417.45 RECREATION INSTRUCTION 8090 76921.00 13039.07 17.0 63881.93 AQUATICS 8100 192225.00 59216.93 30.8 133008.07 ACTIVITY TOTAL 1784036.00 332899.70 18.7 1451136.30 COMMUNITY DEVELOPMENT: PLANNING 9010 1050075.00 190455.60 18.1 859619.40 BUILDING SAFETY 9020 326796.00 44683.08 13.7 282112.92 ENGINEERING 9030 429791.00 44967.62 10.5 384823.38 ECONOMIC DEVELOP14E11T 9040 57250.00 197.81 .3 57052.19 ACTIVITY TOTAL 1863912.00 280304.11 15.0 1583607.89 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 93181 88850.00 205.17 .2 88644.83 COMMUNITY IMPROVEMENTS 941111 66300.00 361.67 .5 65938.33 PARKS 95NN 213216.00 17025.84 8.0 196190.16 STREET CONSTRC/IMPROVMT 96NN 266458.00 1331.92 .5 265126.08 ACTIVITY TOTAL 634824.00 18924.60 3.0 615899.40 T O T A L EXPENDITURES 14587625.00 2035873.76 14.0 12551751.24 EXCESS <REVENUE>EXPENDITURES 146146.00- 120948.66- 82.8 25197.34- EXCESS <REVENUE) EXPENDITURE 146146.00- 120948.66- 82.8 25197.34- BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 10/01/91 REVENUES VERSUS EXPENDITURE 13.39.17 FOR THE PERIOD 7/91 THROUGH 9/91 SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SALES TAX 114000.00- 24673.67- 21.6 89326.33- FINES & FORFEITURES 15250.00- 8271.14- 54.2 6978.86- USES OF MONEY AND PROPERTY 19360.00- .00 19360.00- INTERNGOVERNMENTaL FROM STATE 797071.00- 97226.11- 12.2 699844.a9- INTERGOVERNMENTAL FROM FEDERAL 958558.00- .00 958558.00- CHARGES FOR SERVICES 132065.00- .00 132065.00- OTHER SOURCES OF REVENUE 1037300.00- 4050.00- .4 1033250.00- TOTAL REVENUE 3073604.00- 134220.92- 4.4 2939383.08- *******EXPENDITURES*****Y* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 3142.00 .00 3142.00 ACTIVITY TOTAL 3142.00 .00 3142.00 PUBLIC SAFETY: POLICE 13295.00 895.99 6.7 12399.01 CROSSING GUARDS COST .00 .00 .00 TRAFFIC SIGIIALS 15250.00 .00 15250.00 ACTIVITY TOTAL 28545.00 895.99 3.1 27649.01 TRANSPORTATION: STREET MAINTENANCE 151300.00 6722.26 4.4 144577.74 ACTIVITY TOTAL 151300.00 6722.26 4.4 144577.74 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 132365.00 2950.00 2.2 129415.00 ACTIVITY TOTAL 132365.00 2950.00 2.2 129415.00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 35024.00 3198.00 9.1 31826.00 PARKS 412475.00 8673.25 2.1 403801.75 STREET CONSTRUCTION/IMPROVMT 4192510.00 518658.36 12.4 3673851.64 ACTIVITY TOTAL 4640009.00 530529.61 11.4 4109479.39 T O T A L EXPENDITURES 4955361.00 541097.86 10.9 4414263.14 EXCESS <REVENUE>EXPENDITURE 1881757.00 406876.94 21.6 1474880.06 EXCESS <REVENUE> EXPENDITURE 1881757.00 406876.94 21.6 1474880.06 BGL104 THE CITY OF DUBLIN STATEMENT SNOWING PAGE 1 REVENUES VERSUS EXPENDITURE 13.42.35 10!01/91 FOR THE PERIOD 7191 THROUGH 9/91 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 391430.00- 12732.64- 3.3 378697.36- USES OF MONEY Ali) PROPERTY 17400.00- .00 17400.00- OTHER SOURCES OF REVENUE 7000.00- 26187.80- 374.1 19187.80 TOTAL REVENUE 415830.00- 38920.44- 9.4 376909.56- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 103813.00 80575.00 77.6 23238.00 ACTIVITY TOTAL 103813.00 80575.00 77.6 23238.00 PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING 173550.00 26959.91 15.5 146590.09 ACTIVITY TOTAL 173550.00 26959.91 15.5 146590.09 TRANSPORTATION{ STREET TREE MAINTENANCE 13100.00 1347.65 10.3 11752.35 STREET LANDSCAPE WtINTENA.NCE 100880.00 21342.38 21.2 79537.62 ACTIVITY TOTAL 113980.00 22690.03 19.9 91289.97 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 11000.00 3750.59 34.1 7249.41 ACTIVITY TOTAL 11000.00 3750.59 34.1 7249.41 CAPITAL IMPROVEMENT PROJECTS: STREET CONSTRUCTION/IMPROVMT 1534400.00 .00 1534400.00 ACTIVITY TOTAL 1534400.00 .00 1534400.00 T O T A L EXPENDITURES 1936743.00 133975.53 6.9 1802767.47 EXCESS<REVENUE>EXPENDITURE 1520913.00 95055.09 6.2 1425857.91 EXCESS <REVENUE> EXPENDITURE 1520913.00 95055.09 6.2 1425857.91 TAE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 BGL104 13.55.00 10/O1/91 REVENUES VERSUS EXPENDITURE , FOR THE PERIOD 7/91 THROUGH 9/91 CAPITAL IMPROVEMENT FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY MID PROPERTY 3200.00- .00 3200.00- OTHER SOURCES OF REVENUE 649442.00- .00 649442.00- TOTAL REVENUE 652642.00- 00 652642.00- *******EXPEIIDITURES******* GENERAL GOVERNMENT ACTIVITIES: .00 ACTIVITY TOTAL .00 .00 PUBLIC SAFETY: TRAIISPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: .00 COMMUIIITY IMPROVEMENTS .00 .00 PARRS 49592.00 4863.00 9.8 44729.00 STREET CONSTRUCTION/II4PROV14T 695000.00 9621.55 1.4 685378.45 ACTIVITY TOTAL 744592.00 14484.55 1.9 730107.45 T 0 T A L EXPENDITURES 744592.00 14484.55 1.9 730107.45 EXCESS<REVENUE>EXPENDITURE 91950.00 14484.55 15.8 77465.45 EXCESS <REVEIIUE> EXPENDITURE 91950.00 14484.55 15.8 77465.45 BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 REVENUES VERSUS EXPENDITURE 13.51.25 10101/91 FOR THE PERIOD 7/91 THROUGH 9/91 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 1862699.00- .00 1862699.00- TOTAL REVENUE 1862699.00- .00 1862699.00- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1720770.00 519972.92 30.2 1200797.08 CITY MANAGER 19465.00 4655.23 23.9 14809.77 FINANCE DEPARTMENT 10151.00 2000.00 19.7 8151.00 ACTIVITY TOTAL 1750386.00 526628.15 30.1 1223757.85 PUBLIC SAFETY: DISASTER PREAPREDNESS 10900.00 .00 10900.00 ACTIVITY TOTAL 10900.00 .00 10900.00 TRANSPORTATION: HEALTH & WELFARE: } CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 13080.00 2999.69 22.9 10080.31 SENIOR CENTER 500.00 .00 500.00 ACTIVITY TOTAL 13580.00 2999.69 22.1 10580.31 COMMUNITY DEVELOPMENP: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 1774866.00 529627.84 29.8 1245238.16 EXCESS<REVENUE>EXPENDITURES 87833.00- 529627.84 603.0- 617460.84- EXCESS <REVEITUE> EXPENDITURE 87833.00- 529627.84 603.0- 617460.84- THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 BGL104 13.47.39 10/01/91 REVENUES VERSUS EXPENDITURE FOR THE PERIOD 7/91 THROUGH 9/91 INTERNAL SERVICE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 15000.00- 00 15000.00- CHARGES FOR SERVICES 148354.00- 11095.00- 7.5 137259.00- TOTAL REVENUE 163354.00- 11095.00- 6.8 152259.00- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 161069.00 22952.08 14.2 138116.92 ACTIVITY TOTAL 161069.00 22952.08 14.2 138116.92 PUBLIC SAFETY: POLICE 16700.00 .00 16700.00 ACTIVITY TOTAL 16700.00 .00 16700.00 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES 177769.00 22952.08 12.9 154816.92 EXCESS<REVENUE>EXPENDITURE 14415.00 11857.08 82.3 2557.92 EXCESS <REVENUE> EXPENDITURE 14415.00 11857.08 82.3 2557.92 i i i