The URL can be used to link to this page

Home My WebLink About4.09 Financial Report 06-30-1992 CITY OF DUBLIN AGENDA STATEMENT MEETING DATE: July 13, 1992 SUBJECT :Preliminary Financial report for the month of June 1992 (Report prepared by Phillip S. Molina) EXHIBITS :Balance Sheets and Income Statements FINANCIAL STATEMENT:(See report) RECOMMENDATIONS JA9 Review, accept and file the financial reports. DESCRIPTION:This is the first or preliminary June financial report. The final report will be submitted along with the auditor's report in November or December. This report is incomplete only with regards to accruals that will need to be posted over the next 45 days, plus any year-end closing entries that become necessary. The City's General Fund total revenue is 93.4% of the amount received through June 30th of last year: General Fund REVENUES This Year Last Year Spread TOTAL YTD JUNE $12,663,373.95 $13,553,795.29 ($890,421.34) The 91-92 expenditures posted in the General fund are less than the 91-92 revenue received, and also less than the expenditures posted last year: Expenditures This Year Last Year Spread TOTAL YTD JUNE $11,992,098.76 $12,222,691.10 ($230,592.34) To show where the 91-92 General Fund Revenues came from and how the City used those resources, two new pie chart graphs have been added to this report. One shows the revenues by type, and the other shows expenditures by major activity. Though the specific dollar amounts used to generate these graphs will change before the final report is prepared, the changes in those dollar amounts will not gravely impact these pie charts because the charts reflect percentages of the total . CITY CLERK FILE J? 0 a 4W. General Fund Expenditures Showing Major Activites sorted by percent of total Public Safety 40% General Government 15% Health & Safety 6% Capital Impr lid 12% 1;�b Transportation Facility Rental Community Development Culture & Leisure General Fund Revenue Sources of Revenue Sorted by percent of total Sales Tax 40% Property Tax Fines E Forfeitures -� Real Prop Transf Transient 0 cc. 30% % License E Permits 7% �r 7% 7% /ICJ Other Sources Franchise Taxes Intergovernmental Charges for Services uses of Assets CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JUNE 1992 Prepared by The Finance Department BGLl02 CITY OF DUBLIN PAGE 1 BALANCE SHEET 13.10.02 6/30/92 FOR THE PERIOD 7/91 THROUGH 6/92 GENERAL SPECIAL SPECIAL CAPITAL REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS FUNDS FUITDS FUNDS ASSETS C.'-.SH 1889462.43- 1294984.45 1140000.94 786776.65- CASH WITH FISCAL AGENT 117500.00 UllAMORTIZED BOND DISCOUNT 1250.00 INVESTMENTS AT COST 17013671.88 197528.00 1987972.00 RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS 1122531.01 IN7VENTORY AT COST PREPAID ITEMS 1938.67 FIXED ASSETS AMOUNTS TO BE PROVIDED 2232500.00 TOTAL ASSETS 16249929.13 1294984.45 3687528.94 1201195.35 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 15395.04 DEPOSITS FOR AB1600 FEES 132301.09- DEPOSITS OTHERS 154494.37- 3125.00- PAYABLES:A000UNTS 317.82 24.00- INTEREST PAYROLL 80467.60- DUE TO OTHERS 24649.79- 1121031.01- 1500.00- DEBT INSTRUMENTS PAYABLE 2900000.00- TOTAL LIABILTIES 243898.90- 1121031.01- 2904649.00- 132301.09- FU`NID BALANCES 16006030.23- 173953.44- 782879.94- 1068894.26- TOTAL FUND EQUITY 16006030.23- 173953.44- 782879.94- 1068894.26- TOTAL LIA.B,FND BAL, RETD EARNS 16249929.13- 1294984.45- 3687528.94- 1201195.35- BGL102 CITY OF DUBLIN PAGE 1 6/30/92 BALANCE SHEET 13.10.57 FOR THE PERIOD 7/91 THROUGH 6/92 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUNDS GROUP OF TERM DEBT FUND ACCOUNTS ACCOUNT GROUP ASSETS C.'-_SH 332038.21 47545.08- CASH WITH FISCAL AGENT 1718575.90 UNAMOR'T'IZED 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 AMOUNTS TO BE PROVIDED 2285000.00 TOTAL ASSETS 515088.46 23629945.65 444274.67 2285000.00 LIAR, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS PAYABLES:A000UNTS 457.68- INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 16983728.08- 2285000.00- TOTAL LIABILITIES 457.68- 16983728.08- 2285000.00- FUND BALANCE 398584.61- 1543094.57- CONTRIBUTIONS 115998.18- 5103123.00- INVESTMENTS IN FIXED ASSETS 444274.67- RETAINED EARNINGS TOTAL FUND EQUITY 514630.78- 6646217.57- 444274.67- TOTAL LIAB,FND BAL, RETD EARNS 515088.46- 23629945.65- 444274.67- 2285000.00- BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PA 6/30/92 REVENUES VERSUS EXPENDITURE 12.40.47 FOR THE PERIOD 7/91 THROUGH 6/92 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* PROPERTY TAXES 4034100.00- 3769194.27- 93.4 264905.73- SALES TAX 6300000.00- 5078510.47- 80.6 1221489.53- REAL PROPERTY TRANSFERS 76000.00- 62318.57- 82.0 13681.43- TRANSIENT OCCUPANCY TAX 100000.00- 93958.00- 94.0 6042.00- FR11ICHISE TAXES 434500.00- 443012.78- 102.0 8512.78 LICENSES & PERMITS 474700.00- 246458.50- 51.9 228241.50- FINES & FORFEITURES 19500.00- 23652.76- 121.3 4152.76 USES OF MONEY AND PROPERTY 1091100.00- 907476.60- 83.2 183623.40- INI`ERNGOVERNMENTAL FROM STATE 939366.00- 864646.98- 92.0 74719.02- CHARGES FOR SERVICES 1209905.00- 915200.69- 75.6 294704.31- OTHER SOURCES OF REVENUE 54600.00- 258944.33- 474.3 204344.33 TOTAL REVENUE 14733771.00- 12663373.95- 85.9 2070397.05- *******EXPEIIDITURES******* GENERAL GOVERNMENT ACTIVITIES: 11ON-DEPARTMENTAL 388867.00 289508.41 74.4 99358.59 CITY COUNCIL 1010 159669.00 122927.55 77.0 36741.45 CITY MANAGER 1020 506645.00 456941.24 90.2 49703.76 CITY ATTORNEY 1030 196450.00 193435.10 98.5 3014.90 FINANCE DEPARTMENT 1040 247049.00 222804.19 90.2 24244.81 DATA PROCESSING (FIN) 1045 35500.00 6253.04 17.6 29246.96 BUILDING MANAGEMENT 1050 363220.00 306582.51 84.4 56637.49 FICILITY RENTAL 1050-719 1720670.00 1544702.17 89.8 175967.83 INSURANCE COST CENTER 1060 166600.00 144335.21 86.6 22264.79 ELECTIONS COST CENTER 1070 3000.00 460.00 15.3 2540.00 ACTIVITY TOTAL 3787670.00 3287949.42 86.8 499720.58 PUBLIC SAFETY: POLICE 2010 2794073.00 2108832.88 75.5 685240.12 CROSSING GUARDS COST 2020 33120.00 26781.67 80.9 6338.33 ANIMAL CONTROL 2030 56000.00 39120.27 69.9 16879.73 TRAFFIC SIGNALS 2040 73550.00 64751.66 88.0 8798.34 DISASTER PREAPREDNESS 2050 42085.00 29146.00 69.3 12939.00 FIRE SERVICES JPA 2060 2578993.00 2475828.00 96.0 103165.00 ACTIVITY TOTAL 5577821.00 4744460.48 85.1 833360.52 TR'-.NSPORTATION: PUBLIC WORKS 3010 282015.00 254073.80 90.1 27941.20 STREET MAINTENANCE 3020 328100.00 224463.71 68.4 103636.29 STREET SWEEPING 3030 62000.00 56560.00 91.2 5440.00 STREET TREE MAINTENANCE 3040 66500.00 42050.03 63.2 24449.97 STREET LANDSCAPE MAINT. 3050 208850.00 176855.65 84.7 31994.35 PARATRA.IISIT SERVICES 3060 1500.00 1500.00 100.0 .00 ACTIVITY TOTAL 948965.00 755503.19 79.6 193461.81 HEALTH & WELFARE: VECTOR CONTROL 5010 28296.00 21394.00 75.6 6902.00 WASTE MANAGEMENT 5020 33255.00 8131.95 24.5 25123.05 ACTIVITY TOTAL 61551.00 29525.95 48.0 32025.05 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 156007.00 156007.00 100.0 .00 GL104 i,._ CITY OF DUBLIN STATEMENT SHOWING PACE 2 6/30/92 REVENUES VERSUS EXPENDITURE 12.40.47 FOR THE PERIOD 7/91 THROUGH 6/92 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE CULTURAL ACTIVITIES 8011 44140.00 24137.36 54.7 20002.64 PARK MAINTENANCE 8020 545270.00 487792.15 89.5 57477.85 COMMUNITY CABLE TV 8030 49000.00 48000.00 98.0 1000.00 RECREATION ADMIN. 8040 171625.00 156072.06 90.9 15552.94 PLAYGROUNDS 8045 66924.00 63714.04 95.2 3209.96 SHANNON CENTER 8050 105787.00 95600.70 90.4 10186.30 PRESCHOOL 8055 32194.79 31639.63 98.3 555.16 TEENS PROGRAM 8060 47185.00 29765.46 63.1 17419.54 FIELD SCHEDULING 8065 133395.00 103491.29 77.6 29903.71 YOUTH SPORTS 8066 31739.00 21799.29 68.7 9939.71 SPECIAL EVENTS 8070 27791.00 24114.50 86.8 3676.50 SENIOR CENTER 8080 104120.00 91022.45 87.4 13097.55 RECREATION INSTRUCTION 8090 76921.00 80394.48 104.5 3473.48- AQUATICS 8100 192225.00 175119.31 91.1 17105.69 ACTIVITY TOTAL 1784323.79 1588669.72 89.0 195654.07 COMMUNITY DEVELOPMENT: PLANING 9010 1050075.00 939071.96 89.4 111003.04 BUILDING SAFETY 9020 326796.00 242134.57 74.1 84661.43 ENGINEERING 9030 429791.00 218639.50 50.9 211151.50 ECONOMIC DEVELOPMENT 9040 57250.00 5920.47 10.3 51329.53 ACTIVITY TOTAL 1863912.00 1405766.50 75.4 458145.50 Q-PITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 931RI 88850.00 3203.07 3.6 85646.93 COMMUNITY IMPROVEMENTS 94NN 67300.00 60356.17 89.7 6943.83 PARKS 951RI 194162.00 110344.23 56.8 83817.77 STREET CONSTRC/IMPROVMT 96NN 235958.00 6320.03 2.7 229637.97 ACTIVITY TOTAL 586270.00 180223.50 30.7 406046.50 T 0 T A L EXPENDITURES 14610512.79 11992098.76 82.1 2618414.03 1 EXCESS <REVENUE>EXPENDITURES 123258.21- 671275.19- 544.6 548016.98 TR=.NSFERS IN FROM OTHER FUNDS .00 15022.96- 15022.96 EXCESS <REVENUE> EXPENDITURE 123258.21- 686298.15- 556.8 563039.94 BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 6/30/92 REVENUES VERSUS EXPENDITURE 12.43.31 FOR THE PERIOD 7/91 THROUGH 6/92 SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SALES TAX 114000.00- 105484.20- 92.5 8515.80- FINES & FORFEITURES 15250.00- 30716.78- 201.4 15466.78 USES OF MONEY AND PROPERTY 19360.00- .00 19360.00- INTER11GOVERNMENTAL FROM STATE 797071.00- 735974.36- 92.3 61096.64- INTERGOVERNMENTAL FROM FEDERAL 987339.00- 888569.24- 90.0 98769.76- CHA.RGES FOR SERVICES 132065.00- 145417.33- 110.1 13352.33 OTHER SOURCES OF REVENUE 1037300.00- 2614367.00- 252.0 1577067.00 TOTAL REVENUE 3102385.00- 4520528.91- 145.7 1418143.91 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: 11011-DEPARTMENTAL 28781.00 .00 28781.00 CITY COUNCIL 3142.00 3142.00 100.0 .00 ACTIVITY TOTAL 31923.00 3142.00 9.8 28781.00 PUBLIC SAFETY: POLICE 13295.00 6018.30 45.3 7276.70 CROSSING GUARDS COST .00 .00 .00 TRAFFIC SIGNALS 15250.00 15250.00 100.0 .00 ACTIVITY TOTAL 28545.00 21268.30 74.5 7276.70 TRANSPORTATION: STREET MAINTENANCE 151300.00 32345.38 21.4 118954.62 ACTIVITY TOTAL 151300.00 32345.38 21.4 118954.62 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: PLAIRIING .00 5000.00 5000.00- ENGINEERING 132365.00 99976.71 75.5 32388.29 ACTIVITY TOTAL 132365.00 104976.71 79.3 27388.29 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 35024.00 33972.00 97.0 1052.00 PAR 437078.00 140982.70 32.3 296095.30 STREET CONSTRUCTION/IMPROVMT 4223010.00 2088234.34 49.4 2134775.66 ACTIVITY TOTAL 4695112.00 2263189.04 48.2 2431922.96 T 0 T A L EXPENDITURES 5068026.00 2424921.43 47.8 2643104.57 EXCESS <REVENUE>EXPENDITURE 1936860.00 2095607.48- 108.2- 4032467.48 TRANSFERS OUT TO OTHER FUNDS .00 15022.96 15022.96- EXCESS <REVENUE> EXPENDITURE 1936860.00 2080584.52- 107.4- 4017444.52 BC-L104 rHE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 6/30/92 REVENUES VERSUS EXPENDITURE 12.46.52 FOR THE PERIOD 7/91 THROUGH 6/92 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 391430.00- 380181.82- 97.1 11248.18- USES OF MONEY AND PROPERTY 17400.00- .00 17400.00- OTHER SOURCES OF REVENUE 7000.00- 39804.87- 568.6 32804.87 TOTAL REVENUE 415830.00- 419986.69- 101.0 4156.69 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 103813.00 150812.50 145.3 46999.50- ACTIVITY TOTAL 103813.00 150812.50 145.3 46999.50- PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING 173550.00 155679.99 89.7 17870.01 ACTIVITY TOTAL 173550.00 155679.99 89.7 17870.01 TRANSPORTATION: STREET TREE MAINTENANCE 13100.00 4188.63 32.0 8911.37 STREET LANDSCAPE MAINTENANCE 100880.00 102374.79 101.5 1494.79- ACTIVITY TOTAL 113980.00 106563.42 93.5 7416.58 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: - PARK MAINTENANCE .00 34.45 34.45- ACTIVITY TOTAL .00 34.45 34.45- COMMUNITY DEVELOPMENT: ENGINEERING 11000.00 3851.09 35.0 7148.91 ACTIVITY TOTAL 11000.00 3851.09 35.0 7148.91 CAPITAL IMPROVEMENT PROJECTS: STREET CONSTRUCTION/IMPROIjMT 1534400.00 44246.96 2.9 1490153.04 ACTIVITY TOTAL 1534400.00 44246.96 2.9 1490153.04 T O T A L EXPENDITURES 1936743.00 461188.41 23.8 1475554.59 EXCESS<REVENUE>EXPENDITURE 1520913.00 41201.72 2.7 1479711.28 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 EXCESS <REVENUE> EXPENDITURE 1520913.00 41201.72 2.7 1479711.28 BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PACE 1 6/30/92 REVENUES VERSUS EXPENDITURE 13.06.03 FOR THE PERIOD 7/91 THROUGH 6/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- 2237725.62- 344.6 1588283.62 TOTAL REVENUE 652642.00- 2237725.62- 342.9 1585083.62 *******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 57433.10 115.8 7841.10- STREET CONSTRUCTION/IMPROVMT 723850.00 1016062.79 140.4 292212.79- ACTIVITY TOTAL 773442.00 1073495.89 138.8 300053.89.- T 0 T A L EXPENDITURES 773442.00 1073495.89 138.8 300053.89- EXCESS<REVEHUE>EXPENDITURE 120800.00 1164229.73- 963.8- 1285029.73 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 EXCESS <REVENUE> EXPENDITURE 120800.00 1164229.73- 963.8- 1285029.73 BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 6/30/92 REVENUES VERSUS EXPENDITURE 12.55.01 FOR THE PERIOD 7/91 THROUGH 6/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- 136550.95- 92.0 11803.05- OTHER SOURCES OF REVENUE .00 .00 .00 TOTAL REVENUE 163354.00- 136550.95- 83.6 26803.05- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: 11011-DEPARTMENTAL 161069.00 73445.83 45.6 87623.17 ACTIVITY TOTAL 161069.00 73445.83 45.6 87623.17 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: GENERAL CIP PROJECTS .00 47.99- 47.99 ACTIVITY TOTAL .00 47.99- 47.99 T 0 T A L EXPENDITURES 177769.00 73397.84 41.3 104371.16 EXCESS<REVENUE>EXPENDITURE 14415.00 63153.11- 438.1- 77568.11 EXCESS <REVENUE> EXPENDITURE 14415.00 63153.11- 438.1- 77568.11 BGL104 AE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 6/30/92 REVENUES VERSUS EXPENDITURE 12.59.24 FOR THE PERIOD 7/91 THROUGH 6/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 18364.72 94.3 1100.28 FINANCE DEPARTMENT 10151.00 6969.55 68.7 3181.45 ACTIVITY TOTAL 1750386.00 1569993.70 89.7 180392.30 PUBLIC SAFETY: DISASTER PREA.PREDNESS 10900.00 4731.07 43.4 6168.93 ACTIVITY TOTAL 10900.00 4731.07 43.4 6168.93 TRi11SPORTATION: HEA-LTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 13080.00 10584.56 80.9 2495.44 SENIOR CENTER 500.00 382.82 76.6 117.18 ACTIVITY TOTAL 13580.00 10967.38 80.8 2612.62 COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: CIVIC CENTER COSTS .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 T O T A L EXPENDITURES 1774866.00 1585692.15 89.3 189173.85 EXCESS<REVENUE>EXPENDITURES 87833.00- 41082.90 46.8- 128915.98- EXCESS <REVENUE> EXPENDITURE 87833.00- 41082.98 46.8- 128915.98-