The URL can be used to link to this page

Home My WebLink About4.10 Financial Report 03-31-1992 CITY OF DUBLIN AGENDA STATEMENT MEETING DATE: April 27, 1992 SUBJECT :Financial reports for the month of March 1992 (Report prepared by Phillip S. Molina) EXHIBITS PBalance Sheets and Income Statements FINANCIAL STATEMENT :(See report) RECOMMENDATIONS � .-Accept, review and file the financial reports. DESCRIPTION: The financial condition of the City for the first three quarters of this fiscal year is reflected in the financial reports that are attached. Again it is important to keep an eye on the revenues in the General Fund to determine the impact of the economic condition of the nation to the City's operations. Four graphs have been prepared on a cumulative revenue basis that show downturns, upswings, and status quo conditions. The year-to-date method is used to help identify any trends in certain revenue types in anticipation of the final outcome for the year. An `Upswing' for purposes of categorizing revenues occurs when current year's revenue is at least 40% greater than the same revenue in 1988-89. `Downturns' are represented by those revenues that show a decrease when compared to the 88-89 amount; and a `Status Quo' condition is where the current revenue has remained relatively unchanged compared to the 88-89 amount. REVENUES SHOWING UPSWINGS Property taxes Franchise taxes and Other revenues(*) REVENUES SHOWING STATUS QUO Licenses & permits Fines & Forfeitures Intergovernmental Charges for Services REVENUES SHOWING DOWNTURNS Sales Taxes Real Property Transfer tax Uses of Assets Transient Occupancy Tax (*) `Other' revenues are up due primarily to recent collection from the courts on litigation decided in favor of the City. Comparing the total General Fund revenues year-to-date for the last four months illustrates the spread between the two years, which is widening since January: REVENUES OF THE GENERAL. FUND CUMULATIVE FOR EACH YEAR: This Year Last Year s read 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) Expenditures in the General Fund were less last year than the current year. The two biggest contributors to this higher expenditure level in the current year are Police and Fire Services expenditures. The County's delay in charging the City for $126,969 of Police contract cost until the last quarter last year is part of the reason for this anomaly, as well as the fact that County booking fees were not paid until the last quarter of last year. Both the Police and the Fire Services activities are still within their budgeted amounts. ---------------------------------------------------------------------- COPIES TO: ITEM NO. 4AO CITY CLERK FILE 1,310 4 years of Revenues cumulative through March Thousands \\ \ g 5,000 \ 4,000 \ 3,000 �...., ........:. \ 2,000 \. 1,000 0 1988-89 1 1989-90 1990-91 1991-92 Sales tax ® 1 3,993,631 4,036,326 4,344,001 3,828,247 Property tax = 1,726,868 2,133,326 2,373,199 2,421,123 4 years of Revenues cumulative through March Thousands i $1000 l ................................ ........ $800 $600 $400 \ $200 \ \ 1 IM \ \ $0 88-89 89-90 90-91 91-92 Uses of Assets $889,587 $918,371 $891,205 $623,984 Charges for Services $653,924 $761,968 $714,773 $659,336 Intergovernmental $618,413 $703,418 $773,472 $625,681 4 years of Revenues cumulative through March Thousands .......................................... . .._.. $250 ?r :::! ................................................ $200 - $100 $50 i $0 1988-89 1989-90 1990-91 1991-92 License & permits $165,721 $219,891 $179,587 $176,022 Franchise tax $143,079 $161,821 $187,841 $210055 Transient Occ. $83,154 $81,865 $77,801 $74,501 Real Prop Trnsf $65,941 $47,091 $45,701 $43,725 4 years of Revenues cumulative through March Thousands i i $300 $250 __.-__...._......_..........._..... ............ ...........................III $200 ................._............._........._.........................._....................f I� $150 $100:: $50 $0 1988-89 1989-90 1990-91 1991-92 other ® $29,596 $68,074 $44,191 $263,389 Fines & Forft. = $13,023 $14,536 $15,804 $17,487 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 1992 Prepared by The Finance Department BGL1Q2 CITY OF DUBLIN PAGE 1 4/02/92 BALANCE SHEET 12.04.34 FOR THE PERIOD 7/91 THROUGH 3/92 GENERAL SPECIAL SPECIAL CAPITAL REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS FUNDS FUNDS FUNDS ASSETS CASH 2507848.99- 1588061.29 1079882.52 155025.80 CASH WITH FISCAL AGENT UNAMORTIZED BOND DISCOUNT 1250.00 INVESTMENTS AT COST 16620015.00 RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS 1272098.35 INVENTORY AT COST PREPAID ITEMS 5935.50 FIXED ASSETS AMOUNTS TO BE PROVIDED TOTAL ASSETS 15391449.86 1588061.29 1079882.52 155025.80 LIAB, FND BAL, RETHD EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 17076.70- DEPOSITS FOR AB1600 FEES 156144.40- DEPOSITS OTHERS 153956.30- 3125.00- PAYABLES:A000UNTS 4234.18- 4552.00 24.00- INTEREST PAYROLL 10653.04- DUE TO OTHERS 25433.12- 1247492.88- 1500.00- 23105.47- DEBT INSTRUMENTS PAYABLE 550000.00- TOTAL LIABILTIES 211353.34- 1242940.88- 554649.00- 179249.87- FUND BALANCES 15180096.52- 345120.41- 525233.52- 24224.07 TOTAL FUZED EQUITY 15180096.52- 345120.41- 525233.52- 24224.07 TOTAL LIAB,FND BAL, RETD EARNS 15391449.86- 1588061.29- 1079882.52 155025.80- , BGL102 CITY OF DUBLIN PAGE 1 4/02/92 BALANCE SHEET 12.04.52 FOR THE PERIOD 7/91 THROUGH 3/92 INTERNAL ENTERPRISE FIXED ASSETS SERVICE FUNDS GROUP OF FUND ACCOUNTS ASSETS CASH 317835.04 38258.67- CASH WITH FISCAL AGENT 1718575.90 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST 64500.15 ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 8724.75 1724.03 FIXED ASSETS 182941.50 21892690.65 444274.67 AMOUNTS TO BE PROVIDED TOTAL ASSETS 509501.29 23639232.06 444274.67 LIAB, END BAL•, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPWIT DEPOSITS OTHERS PAYABLES:A000UNTS 457.68- INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 16983728.08- TOTAL LIABILITIES 457.60- 16983728.08- FUND BALANCE 393045.43- 1552380.98- CONTRIBUTIONS 115998.18- 5103123.00- INVESTMENTS IN FIXED ASSETS 444274.67- RETAINED EARNINGS TOTAL FUND EQUITY 509043.61- 6655503.98= 444274.67- TOTAL LIAB,F]ID BAL, RETD EARNS 509501.29- 23639232.06- 444274.67- BGL104 .:ITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/02/92 REVENUES VERSUS EXPENDITURE 11.28.41 FOR THE PERIOD 7/91 THROUGH 3/92 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* PROPERTY TAXES 4034100.00- 2421123.78- 60.0 1612976.22- SALES TAX 6300000.00- 3828247.07- 60.8 2471752.93- REAL PROPERTY TRANSFERS 76000.00- 43725.36- 57.5 32274.64- TRANSIENT OCCUPANCY TAX 100000.00- 74501.00- 74.5 25499.00- FRANCHISE TAXES 434500.00- 210155.45- 48.4 224344.55- LICENSES & PERMITS 474700.00- 176022.77- 37.1 298677.23- FINES & FORFEITURES 19500.00- 17487.10- 89.7 2012.90- USES OF MONEY AND PROPERTY 1091100.00- 623984.25- 57.2 467115.75- INTERNGOVERHMENTAL FROM STATE 939366.00- 625680.86- 66.6 313685.14- CHARGES FOR SERVICES 1209905.00- 659336.59- 54.5 550568.41- OTHER SOURCES OF REVENUE 54600.00- 263389.01- 482.4 208789.01 TOTAL REVENUE 14733771.00- 8943653.24- 60.7 5790117.76- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 388867.00 289508.41 74.4 99358.59 CITY COUNCIL 1010 160669.00 95671.69 59.5 64997.31 CITY MANAGER 1020 506645.00 328945.63 64.9 177699.37 CITY ATTORNEY 1030 196450.00 133940.74 68.2 62509.26 FINANCE DEPARTMENT 1040 247049.00 160535.17 65.0 86513.83 DATA PROCESSING (FIN)1045 35500.00 3000.00 8.5 32500.00 BUILDING MANAGEMENT 1050 363220.00 210166.56 57.9 153053.44 FACILITY RENTAL 1050-719 1720670.00 1544609.17 89.8 176060.83 INSURANCE COST CENTER 1060 166600.00 143668.59 86.2 22931.41 ELECTIONS COST CENTER 1070 3000.00 .00 3000.00 ACTIVITY TOTAL 3788670.00 2910045.96 76.8 878624.04 PUBLIC SAFETY: POLICE 2010 2794073.00 1457501.70 52.2 1336571.30 CROSSING GUARDS COST 2020 33120.00 14149.55 42.7 18970.45 ANIMAL CONTROL 2030 56000.00 20625.75 36.8 35374.25 TRAFFIC SIGNALS 2040 73550.00 39611.42 53.9 33938.58 DISASTER PREAPREDNESS 2050 42085.00 18893.35 44.9 23191.65 FIRE SERVICES JPA 2060 2578993.00 1856871.00 72.0 722122.00 ACTIVITY TOTAL 5577821.00 3407652.77 61.1 2170168.23 TR.I.NSPORTATION: PUBLIC WORKS 3010 282015.00 183803.35 65.2 98211.65 STREET MAINTENANCE 3020 328100.00 45042.69 13.7 283057.31 STREET SWEEPING 3030 . 62000.00 41596.00 67.1 20404.00 STREET TREE MAINTENANCE 3040 66500.00 26960.78 40.5 39539.22 STREET LANDSCAPE MAINT. 3050 208850.00 121470.24 58.2 87379.76 PARATRA.NSIT SERVICES 3060 1500.00 1500.00 100.0 .00 ` ACTIVITY TOTAL 948965.00 ` 420373.06 44.3 528591.94 HEALTH & WELFARE: VECTOR CONTROL 5010 28296.00 14271.00 50.4 14025.00 WASTE MANAGEMENT 5020 33255.00 7980.20 24.0 25274.80 ACTIVITY TOTAL 61551.00 22251.20 36.2 39299.80 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 156007.00 78003.50 50.0 78003.50 GL104' Th. _iY OF DUBLIN STATEMENT SHOWING PAGE 2 REVENUES VERSUS EXPENDITURE 11.28.41 4/02/92 FOR THE PERIOD 7/91 THROUGH 3/92 GEIIEP-11 REVE14UE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE CULTURAL ACTIVITIES 8011 44140.00 22534.55 51.1 21605.45 PARK MAINTENANCE 8020 545270.00 345484.73 63.4 199785.27 COMMUNITY CABLE TV 8030 49000.00 48000.00 98.0 1000.00 RECREATION )WIN. 8040 171625.00 113886.56 66.4 57738.44 PLAYGROUNDS 8045 66924.00 48031.60 71.8 18892.40 SHANNON CENTER 8050 105787.00 70126.22 66.3 35660.78 PRESCHOOL 8055 32194.79 22968.08 71.3 9226.71 TEENS PROGRAM 8060 47185.00 22924.50 48.6 24260.50 FIELD SCHEDULING 8065 133395.00 67634.31 50.7 65760.69 YOUTH SPORTS 8066 31739.00 14853.26 46.8 16885.74 SPECIAL EVENTS 8070 27791.00 15042.40 54.1 12748.60 SENIOR CENTER 8080 104120.00 64510.05 62.0 39609.95 RECREATION INSTRUCTION 8090 76921.00 51697.65 67.2 25223.35 AQUATICS 8100 192225.00 113636.48 59.1 78588.52 ACTIVITY TOTAL 1784323.79 1099333.89 61.6 684989.90 COMMUNITY DEVELOPMENT: PLANNING 9010 1050075.00 719382.56 68.5 330692.44 BUILDING SAFETY 9020 326796.00 176022.92 53.9 150773.08 ENGINEERING 9030 429791.00 179406.37 41.7 250384.63 ECONOMIC DEVELOPMENT 9040 57250.00 5852.79 10.2 51397.21 ACTIVITY TOTAL 1863912.00 1080664.64 58.0 783247.36 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS � 93NN 88850.00 362.12 .4 88487.88 COMMUNITY IMPROVEMENTS 94EN 66300.00 52245.34 78.8 14054.66 PAS 95NN 194162.00 92671.95 47.7 101490.05 STREET CONSTRC/IMPROVMT 96NN 235958.00 2966.41 1.3 232991.59 ACTIVITY TOTAL 585270.00 148245.82 25.3 437024.18 T O T A L EXPENDITURES 14610512.79 9088567.34 62.2 5521945.45 EXCESS <REVENUE>EXPENDITURES 123258.21- 144914.10 117.6- 268172.31- EXCESS <REVENUE> EXPENDITURE 123258.21- 144914.10 117.6- 268172.31- , BGL104 5 _'TY OF DUBLIN STATEMENT SHOWING PAGE 1 4/02/92 REVENUES VERSUS EXPENDITURE 11.30.55 FOR THE PERIOD 7/91 THROUGH 3/92 SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SALES TAX 114000.00- 79572.32- 69.8 34427.68- FINES & FORFEITURES 15250.00- 26692.48- 175.0 11442.48 USES OF MONEY AND PROPERTY 19360.00- .00 19360.00- INTER11C-0VERNMENTAL FROM STATE 797071.00- 554088.82- 69.5 242982.18- INTERGOVERNMENTAL FROM FEDERAL 958558.00- 874919.96- 91.3 83638.04- CHARGES FOR SERVICES 132065.00- 87376.08- 66.2 44688.92- OTHER SOURCES OF REVENUE 1037300.00- 2614267.00- 252.0 1576967.00 TOTAL REVENUE 3073604.00- 4236916.66- 137.8 1163312.66 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 3142.00 .00 3142.00 ACTIVITY TOTAL 3142.00 .00 3142.00 PUBLIC SAFETY: POLICE 13295.00 4639.05 34.9 8655.95 CROSSING GUARDS COST .00 .00 .00 TRAFFIC SIGNALS 15250.00 15250.00 100.0 .00 ACTIVITY TOTAL 28545.00 19889.05 69.7 8655.95 TRANSPORTATION: STREET MAINTENANCE 151300.00 16885.74 11.2 134414.26 ACTIVITY TOTAL 151300.00 16885.74 11.2 134414.26 HEALTH & WELFARE: . CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 132365.00 81167.63 61.3 51197.37 ACTIVITY TOTAL 132365.00 81167.63 61.3 51197.37 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 35024.00 43174.52 123.3 8150.52- PARKS 437078.00 .111392.74 25.5 325685.26 STREET CONSTRUCTION/IMPROVMT 4223010.00 2936600.49 69.5 1286409.51 ACTIVITY TOTAL 4695112.00 3091167.75 65.8 1603944.25 T 0 T A L EXPENDITURES 5010464.00 3209110.17 64.0 1801353.83 EXCESS <REVENUE>EXPENDITURE 1936860.00 1027806.49- 53.1- 2964666.49 EXCESS <REVENUE> EXPENDITURE 1936860.00 1027806.49- 53.1- 2964666.49 BGL194 _ CITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/02/92 REVENUES VERSUS EXPENDITURE 11.34.03 FOR THE PERIOD 7/91 THROUGH 3/92 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 391430.00- 234733.84- 60.0 156696.16- 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- 264283.01- 63.6 151546.99- *******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 114229.39 65.8 59320.61 ACTIVITY TOTAL 173550.00 114229.39 65.8 59320.61 TRANSPORTATION: STREET TREE MAINTENANCE 13100.00 2747.23 21.0 10352.77 STREET LANDSCAPE MAINTENANCE 100880.00 73458.98 72.8 27421.02 ACTIVITY TOTAL 113980.00 76206.21 66.9 37773.79 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 20604.46 1.3 1513795.54 ACTIVITY TOTAL 1534400.00 20604.46 1.3 1513795.54 T 0 T A L EXPENDITURES 1936743.00 318603.15 16.5 1618139.85 EXCESS<REVENUE>EXPENDITURE 1520913.00 54320.14 3.6 1466592.86 EXCESS <REVENUE> EXPENDITURE 1520913.00 54320.14 3.6 1466592.86 BGL104 2ITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/02/92 REVENUES VERSUS EXPENDITURE 11.46.03 FOR THE PERIOD 7/91 THROUGH 3/92 CAPITAL IMPROVEMENT FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 3200.00- .00 3200.00- OTHER SOURCES OF REVENUE 649442.00- 190710.31- 29.4 458731.69- TOTAL REVENUE 652642.00- 190710.31- 29.2 461931.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 31469.46 63.5 18122.54 STREET CONSTRUCTION/IMPROVMT 723850.00 88129.45 12.2 635720.55 ACTIVITY TOTAL 773442.00 119598.91 15.5 653843.09 T 0 T A L EXPENDITURES 773442.00 119598.91 15.5 653843.09 EXCESS<REVENUE>EXPENDITURE 120800.00 71111.40- 58.9- 191911.40 EXCESS <REVENUE> EXPENDITURE 120800.00 71111.40- 58.9- 191911.40 BGL104 -iTY OF DUBLIN STATEMENT SHOWING PAGE 1 4/02/92 REVENUES VERSUS EXPENDITURE 11.41.43 FOR THE PERIOD 7/91 THROUGH 3/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 313089.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 5066.50 49.9 5084.50 ACTIVITY TOTAL 1750386.00 1568015.65 89.6 182370.35 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 8069.60 61.7 5010.40 SENIOR CENTER 500.00 320.49 64.1 179.51 ACTIVITY TOTAL 13580.00 8390.09 61.8 5189.91 COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: CIVIC CENTER COSTS .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 T O T A L EXPENDITURES 1774866.00 1576405.74 88.8 198460.26 EXCESS<REVEHUE>EXPENDITURES 87833.00- 31796.57 36.2- 119629.57- EXCESS <REVENUE> EXPENDITURE 87833.00- 31796.57 36.2- 119629.57- BGL104. ;ITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/02/92 REVENUES VERSUS EXPENDITURE 11.37.36 FOR THE PERIOD 7/91 THROUGH 3/92 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- 108444.25- 73.1 39909.75- OTHER SOURCES OF REVENUE .00 .00 .00 TOTAL REVENUE 163354.00- 108444.25- 66.4 54909.75- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 161069.00 59494.31 36.9 101574.69 ACTIVITY TOTAL 161069.00 59494.31 36.9 101574.69 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 59494.31 33.5 118274.69 EXCESS<REVENUE>EXPENDITURE 14415.00 48949.94- 339.6- 63364.94 EXCESS <REVENNE> EXPENDITURE 14415.00 48939.94- 339.6- 63364.94