The URL can be used to link to this page

Home My WebLink AboutItem 4.7 Financial Report 04-30-1992 CITY OF DUBLIN AGENDA STATEMENT MEETING DATE: May 11,1992 SUBJECT :Financial reports for the month of April 1992 (Report prepared by Phillip S. Molina) EXHIBITS :Balance Sheets and Income Statements FINANCIAL STATEMENT :(See Report) RECOMMENDATIONS :Accept, review and fife the financial /z reports. DESCRIPTION: Over eighty percent of the 91-92 fiscal year is completed. The City's cash accounts are greater today than they were last year at this time. The biggest contributor to this temporary position is the property tax revenues ($1,118,730) plus the quarterly investment income from LAIF ($206,551) received in April . Concentrating on the General Fund where most of the operating revenues are posted and expenditures occur, reveals that revenues are still performing behind the previous year's levels. Looking at the monthly cumulative data, the City's General Fund continues to show an increase in the spread between the two years: REVENUES OF THE GENERAL FUND CUMULATIVE FOR EACH YEAR: This year Last year spread TOTAL YTD December 6,019,020 6,541,969 (522,949) TOTAL YTD January 7,027,117 7,500,922 (473,805) TOTAL YTD February 7,831,824 8,515,132 (683,308) TOTAL YTD March 8,943,653 9,647,478 (703,825) TOTAL YTD April 11,072,626 11,833,693 (761,067) With the bad news is some positive data. Four revenue types continue to do better than last year (See the graphs for details): Franchise Taxes Licenses & Permits Fines & Forfeitures Other revenues (misc.) Property Tax remains almost dead even with last year. The difference is so slight that the graph for property tax appears to be flat compared to last year: Current Prior Year spread percent All property taxes: $3,539,854 $3,543,516 $-3662 -.00103 The worst revenue performer continues to be Sales Tax, which is down by $558,753 compared to last year at this time. This represents an eleven percent drop in this revenue. Overall General Fund Revenues are down by 6.4% compare to the same time period last year. Expenditures are up $70,278 over last year, which represents a .007 increase. This is obviously a very small spread. The cost of Fire and Police services have generated the largest increase in expenditures between April of last year and this April . --------------------------------------------------------- COPIES TO: ITEM N0. CITY CLE _Rj�K'�� FILE � NIV1 4 years of Revenue cumulative through April Thousands' $5,000 - ' $4,000 --I. $3,000 $2,000 $1,000 $0 1988-89 1 1989-90 1990-91 1991-92 Sales tax $4,341,231$4,383,329$4,722,101$4,163,34 Property tax $2,054,291$3,037,446$3,543,516$3,539,85 4 years of Revenue cumulative through April Thousands 1,200 1,000 800 ............ 600 400 - * \� \ \ 200 � �•,,\\, \ , 1988-89 1989-90 1 1990-91 1991-92 Uses of Assets 1,099,458 1,157,676 1,150,633 887393 Intergovernmental 0 6323858 782,306 847957 6961271 Charges for Services 674,898 780,545 1 802,728 730,173 4 years of Revenue cumulative through April Thousands $500 -1 ............_..._..__................._................._....!.� . . _._......_.._........ . _ __. $400 -1 ..........._.._.... .......... ............ _ ........................ ..........._..... $300 $200 $100 $0 1988-89 1989-90 1990-91 1991-92 Franchise tax OI $305,731 $347,458 $386,153 $421,411 License & permits $185,163 $236,394 $189,867 $208,881 Transient Occ. I $83,154 $105,663 $77,801 $93,958 Real Prop Trnsf 0 $65,941 $47,091 $51,018 $48,518 4 years of Revenue cumulative through April Thousands ..................... ....._........_, ....._.........__._..._.................................................. ._....._..........._........__....... $300 ............... . ............ ....... , $250 - .. _._ ........... _.. $200 $150 L $100 i $50 $0 1988-89 1989-90 1990-91 1991-92 Other M I $301553 $62,981 $44,456 $264,474 Fines & Forft. $14,357 $16,017 $17,458 $18,346 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF APRIL 1992 Prepared by The Finance Department. BGL102 CITY OF DUBLIN PAGE 1 5/04/92 BALANCE SHEET 12.21.29 FOR THE PERIOD 7/91 THROUGH 4/92 GENERAL SPECIAL SPECIAL CAPITAL REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS FUNDS FUNDS FUNDS ASSETS CASH 999252.27- 1674400.54 1185457.08 177345.08 CASH WITH FISCAL AGENT UNA.MORTIZED BOND DISCOUNT 1250.00 INVESTMENTS AT COST 16620000.00 RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS 1272098.35 INVENTORY AT COST PREPAID ITEMS FIXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS 16894096.08 1674400.54 1185457.08 177345.08 LIAB, END BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 56350.77- DEPOSITS FOR AB1600 FEES 161944.40- DEPOSITS OTHERS 153069.37- 3125.00- PAYABLES:A00OUNTS 4234.18- 4552.00 24.00- INTEREST PAYROLL 21346.66- DUE TO OTHERS 1247492.88- 1500.00- 23105.47- DEBT INSTRUMENTS PAYABLE 550000.00- TOTAL LIABILTIES 235000.98- 1242940.88- 554649.00- 185049.87- FUND BALANCES 16659095.10- 431459.66- 630808.08- 7704.79 TOTAL FUND EQUITY 16659095.10- 431459.66- 630808.08- 7704.79 TOTAL LIAB,FND K L, RETD EARNS 16894096.08- 1674400.54- 1185457.08- 177345.08- BGL102 CITY OF DUBLIN PAGE 1 5/04/92 BALANCE SHEET 12.21.50 FOR THE PERIOD 7/91 THROUGH 4/92 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUNDS GROUP OF TERM DEBT FUND ACCOUNTS ACCOUNT GROUP ASSETS CASH 325538.39 44923.76- - CASH WITH FISCAL AGENT 1718575.90 UVAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST 64500.15 ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 108.75 1724.03 FIXED ASSETS 182941.50 21892690.65 444274.67 AM0U`NTS TO BE PROVIDED 2285000.00 TOT.'.'--L ASSETS 508588.64 23632566.97 444274.67 2285000.00 LIAR, FND BAL, RE'TRD EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:A.000UNTS 457.68- INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 16983728.08- 2285000.00- TOT11, LIABILITIES 457.68- 16983728.08- 2285000.00- FUND BALANCE 392132.78- 1545715.89- CONTRIBUTIONS 115998.18- 5103123.00- INVESTMENTS IN FIXED ASSETS 444274.67- RETAINED E=-RHINGS TOT.'.'-.L FUND EQUITY 508130.96- 6648838.89- 444274.67- TOTAL LIAB,FND BAL, RETD EARNS 508588.64- 23632566.97- 444274.67- 2285000.00- BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 5/04/92 REVENUES VERSUS EXPENDITURE 11.48.33 FOR THE PERIOD 7/91 THROUGH 4/92 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* PROPERTY TAXES 4034100.00- 3539854.18- 87.7 494245.82- SALES TAX 6300000.00- 4163347.07- 66.1 2136652.93- REAL PROPERTY TRANSFERS 76000.00- 48518.30- 63.8 27481.70- TRANSIENT OCCUPANCY TAX 100000.00- 93958.00- 94.0 6042.00- FRANCHISE TAXES 434500.00- 421410.19- 97.0 13089.81- LICENSES & PERMITS 474700.00- 208881.90- 44.0 265818.10- FINES & FORFEITURES 19500.00- 18346.43- 94.1 1153.57- USES OF MONEY AND PROPERTY 1091100.00- 887393.01- 81.3 203706.99- INTERNGOVERNMENTAL FROM STATE 939366.00- 696270.00- 74.1 243096.00- CHARGES FOR SERVICES 1209905.00- 730173.46- 60.3 479731.54- OTHER SOURCES OF REVENUE 54600.00- 264474.34- 484.4 209874.34 TOTAL REVENUE 14733771.00- 11072626.88- 75.2 3661144.12- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 388867.00 289508.41 74.4 99358.59 CITY COUNCIL 1010 160669.00 105610.97 65.7 55058.03 CITY MANAGER 1020 506645.00 367787.39 72.6 138857.61 CITY ATTORNEY 1030 196450.00 156736.64 79.8 39713.36 FINANCE DEPARTMENT 1040 247049.00 179044.58 72.5 68004.42 DATA PROCESSING (FIN) 1045 35500.00 6253.04 17.6 29246.96 BUILDING MANAGEMENT 1050 363220.00 238091.13 65.6 125128.87 FACILITY RENTAL 1050-719 1720670.00 1544609.17 89.8 176060.83 INSURANCE COST CENTER 1060 166600.00 144045.21 86.5 22554.79 ELECTIONS COST CENTER 1070 3000.00 260.00 8.7 2740.00 ACTIVITY TOTAL 3788670.00 3031946.54 80.0 756723.46 PUBLIC SAFETY: POLICE 2010 2794073.00 1476291.17 52.8 1317781.83 CROSSING GUARDS COST 2020 33120.00 18778.96 56.7 14341.04 ANIMAL CONTROL 2030 56000.00 39120.27 69.9 16879.73 TRAFFIC SIGNALS 2040 73550.00 44535.48 60.6 29014.52 DISASTER PREAPREDNESS 2050 42085.00 21387.28 50.8 20697.72 FIRE SERVICES JPA 2060 2578993.00 2063190.00 80.0 515803.00 ACTIVITY TOTAL 5577821.00 3663303.16 65.7 1914517.84 TRANSPORTATION: PUBLIC WORKS 3010 282015.00 199162.11 70.6 82852.89 STREET MAINTENANCE 3020 328100.00 45042.69 13.7 283057.31 STREET SWEEPING . 3030 62000.00 46538.50 75.1 15461.50 STREET TREE MAINTENANCE 3040 66500.00 26960.78 40.5 39539.22 STREET LANDSCAPE MAINT. 3050 208850.00 122751.36 58.8 86098.64 PARATRkNSIT SERVICES 3060 1500.00 1500.00 100.0 .00 ACTIVITY TOTAL 948965.00 441955.44 46.6 507009.56 HEALTH & WELFARE: VECTOR CONTROL 5010 28296.00 14271.00 50.4 14025.00 WASTE MANAGEMENT 5020 33255.00 8131.95 24.5 25123.05 ACTIVITY TOTAL 61551.00 22402.95 36.4 39148.05 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 156007.00 117005.25 75.0 39001.75 GL104 CITY OF DUBLIN STATEMENT SHOWING PAGE 2 5/44/92 REVENUES VERSUS EXPENDITURE. 11.48.33 FOR THE PERIOD 7/91 THROUGH 4/92 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE CULTURAL ACTIVITIES 8011 44140.00 23034.55 52.2 21105.45 PARK MAINTENANCE 8020 545270.00 349537.43 64.1 195`132.57 COMMUNITY CABLE TV 8030 49000.00 48000.00 98.0 1000.00 RECREATION ADMIN. 8040 171625.00 126517.84 73.7 45107.16 PLAYGROUNDS 8045 66924.00 52150.43 77.9 14773.57 SHANNON CENTER 8050 105787.00 78500.41 74.2 27286.59 PRESCHOOL 8055 32194.79 26095.79 81.1 6099.00 TEENS PROGRAM 8060 47185.00 25080.67 53.2 22104.33 FIELD SCHEDULING 8065 133395.00 75305.49 56.5 58089.51 YOUTH SPORTS 8066 31739.00 16685.11 52.6 15053.89 SPECIAL EVENTS 8070 27791.00 20892.09 75.2 6898.91 SENIOR CENTER 8080 104120.00 71083.78 68.3 33036.22 RECREATION INSTRUCTION 8090 76921.00 63900.76 83.1 13020.24 AQUATICS 8100 192225.00 120029.51 62.4 72195.49 ACTIVITY TOTAL 1784323.79 1213819.11 68.0 570504.68 COMMUNITY DEVELOPMENT: PLANNING 9010 1050075.00 792297.44 75.5 257777.56 BUILDING SAFETY 9020 326796.00 197363.90 60.4 129432.10 ENGINEERING 9030 429791.00 199311.58 46.4 230479.42 ECONOMIC DEVELOPMENT 9040 57250.00 5905.24 10.3 51344.76 ACTIVITY TOTAL 1863912.00 1194878.16 64.1 669033.84 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 93NN 88850.00 450.12 .5 88399.88 COMMUNITY IMPROVEMENTS 9411N 66300.00 52245.34 7.8.8 14054.66 PARKS 95191 194162.00 108559.45 55.9 85602.55 STREET CONSTRC/IMPROVMT 96NN 235958.00 3703.59 1.6 232254.41 ACTIVITY TOTAL 585270.00 164958.50 28.2 420311.50 T 0 T A L EXPENDITURES 14610512.79 9733263.86 66.6 4877248.93 EXCESS <REVENUE>EXPENDITURES 123258.21- 1339363.02- 1086.6 1216104.81 EXCESS <REVENUE> EXPENDITURE 123258.21- 1339363.02- 1086.6 1216104.81 BGL104 __c CITY OF DUBLIN STATEMENT SHOWING PAGE 1 5/01/92 REVENUES VERSUS EXPENDITURE- 11.51.12 FOR THE PERIOD 7/91 THROUGH 4/92 SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* - SALES TAX 114000.00- 86363.50- 75.8 27636.50- FINES & FORFEITURES 15250.00- 26692.48- 175.0 11442.48 USES OF MONEY AND PROPERTY 19360.00- .00 19360.00- INTERNGOVERNMENTAL FROM STATE 797071.00- 635179.91- 79.7 161891.09- INTERGOVERNMENTAL FROM FEDERAL 958558.00- 879919.96- 91.8 78638.04- CHARGES FOR SERVICES 132065.00- 137693.57- 104.3 5628.57 OTHER SOURCES OF REVENUE 1037300..00- 2614267.00- 252.0 1576967.00 TOTAL REVENUE 3073604.00- 4380116.42- 142.5 1306512.42 *******EXPEDDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 3142.00 .00 3142.00 ACTIVITY TOTAL 3142.00 .00 3142.00 PUBLIC SAFETY: POLICE 13295.00 5110.37 38.4 8184.63 CROSSING GUARDS COST .00 .00 .00 TRAFFIC SIGNALS 15250.00 15250.00 100.0 .00 ACTIVITY TOTAL 28545.00 20360.37 71.3 8184.63 TRANSPORTATION: STREET MAINTENANCE 151300.00 18886.32 12.5 132413.68 ACTIVITY TOTAL 151300.00 18886.32 12.5 132413.68 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 132365.00 86297.62 65.2 46067.38 ACTIVITY TOTAL 132365.00 86297.62 65.2 46067.38 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 35024.00 43174.52 123.3 8150.52- PARKS 437078.00 146827.77 33.6 290250.23 STREET CONSTRUCTION/IMPROV14T 4223010.00 2950424.08 69.9 1272585.92 ACTIVITY TOTAL 4695112.00 3140426.37 66.9 1554685.63 T 0 T A L EXPENDITURES 5010464.00 3265970.68 65.2 1744493.32 EXCESS <REVENUE>EXPENDITURE 1936860.00 1114145.74- 57.5- 3051005.74 EXCESS <REVENUE> EXPENDITURE 1936860.00 1114145.74- 57.5- 3051005.74 BGL104 .... CITY OF DUBLIN STATEMENT SHOWING PAGE 1 5/0t/92 REVENUES VERSUS EXPENDITURE 11.56.01 FOR THE PERIOD 7/91 THROUGH 4/92 SPECIA-L ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 391430.00- 355335.54- 90.8 36094.46- USES OF MONEY AND PROPERTY 17400.00- .00 17400.00- OTHER SOURCES OF REVENUE 7000.00- 29549.17- 422.1 22549.17 TOTAL REVENUE 415830.00- 384884.71- 92.6 30945.29- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 103813.00 103812.50 100.0 .50 ACTIVITY TOTAL 103813.00 103812.50 100.0 .50 PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING 173550.00 128019.14 73.8 45530.86 ACTIVITY TOTAL 173550.00 128019.14 73.8 45530.86 TRANSPORTATION: STREET TREE MAINTENANCE 13100.00 2747.23 21.0 10352.77 STREET LANDSCAPE MAINTENANCE 100880.00 74519.42 73.9 26360.58 ACTIVITY TOTAL 113980.00 77266.65 67.8 36713.35 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: PARK MAINTENANCE .00 34.45 34.45- ACTIVITY TOTAL .00 34.45 34.45- 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 20746.96 1.4 1513653.04 ACTIVITY TOTAL 1534400.00 20746.96 1.4 1513653.04 T 0 T A L EXPENDITURES 1936743.00 333630.29 17.2 1603112.71 EXCESS<REVENUE>EXPENDITURE 1520913.00 51254.42- 3.4- 1572167.42 EXCESS <REVENUE> EXPENDITURE 1520913.00 51254.42- 3.4- 1572167.42 BGL104 CITY OF DUBLIN STATEMENT SHOWING PAGE 1 5/04/92 REVENUES VERSUS EXPENDITURE. 12.08.37 FOR THE PERIOD 7/91 THROUGH 4/92 CAPITAL IMPROVEMENT FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 3200.00- .00 3�00.00- OTHER SOURCES OF REVENUE 649442.00- 211710.31- 32.6 437731.69- TOTAL REVENUE 652642.00- 211710.31- 32.4 440931.69- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS .00 .00 .00 PARKS 49592.00 31861.08 64.2 17730.92 STREET CONSTRUCTION/IMPROVMT 723850.00 92218.55 12.7 631631.45 ACTIVITY TOTAL 773442.00 124079.63 16.0 649362.37 T 0 T A L EXPENDITURES 773442.00 124079.63 16.0 649362.37 EXCESS<REVENUE>EXPENDITURE 120800.00 87630.68- 72.5- 208430.68 EXCESS <REVENUE> EXPENDITURE 120800.00 87630.68- 72.5- 208430.68 BGL104 rnS CITY OF DUBLIN STATEMENT SHOWING PAGE 1 5/04/92 REVENUES VERSUS EXPENDITURE, 12.04.00 FOR THE PERIOD 7/91 THROUGH 4/92 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* .- USES OF MONEY AND PROPERTY 1862699.00- 1544609.17- 82.9 318089.83- TOTAL REVENUE 1862699.00- 1544609.17- 82.9 318089.83- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1720770.00 1544659.43 89.8 176110.57 CITY MANAGER 19465.00 18289.72 94.0 1175.28 FINANCE DEPARTMENT 10151.00 6969.55 68.7 3181.45 ACTIVITY TOTAL 1750386.00 1569918.70 89.7 180467.30 PUBLIC SAFETY: DISASTER PREAPREDNESS 10900.00 4731.07 43.4 6168.93 ACTIVITY TOTAL 10900.00 4731.07 43.4 6168.93 TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 13080.00 8069.60 61.7 5010.40 SENIOR CENTER 500.00 351.46 70.3 148.54 ACTIVITY TOTAL 13580.00 8421.06 62.0 5158.94 COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: CIVIC CENTER COSTS .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 T O T A L EXPENDITURES 1774866.00 1583070.83 89.2 191795.17 EXCESS<REVENUE>EXPENDITURES 87833.00- 38461.66 43.8- 126294.66- EXCESS <REVENUE> EXPENDITURE 87833.00- 38461.66 43.8- 126294.66- BGL104 CITY OF DUBLIN STATEMENT SHOWING PAGE 1 5/04/92 REVENUES VERSUS EXPENDITURE 12.00.00 FOR THE PERIOD 7/91 THROUGH 4/92 INTERNAL SERVICE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPER'T'Y 15000.00- .00 15600.00- CHARGES FOR SERVICES 148354.00- 121193.80- 81.7 27155.20- OTHER SOURCES OF REVENUE .00 .00 .00 TOTAL REVENUE 163354.00- 121198.80- 74.2 42155.20- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 161069.00 64545.51 40.1 96523.49 ACTIVITY TOTAL 161069.00 64545.51 40.1 96523.49 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 0 T A L EXPENDITURES 177769.00 64545.51 36.3 113223.49 EXCESS<REVENUE>EXPEIIDITURE 14415.00 56653.29- 393.0- 71068.29 EXCESS <REVEITUE> EXPENDITURE 14415.00 56653.29- 393.0- 71068.29