The URL can be used to link to this page

Home My WebLink About4.14 Financial Report 03-31-1989 CITY OF DUBLIN AGENDA STATEMENT CITY COUNCIL MEETING DATE: April 10, 1989 SUBJECT Financial Statements for March 1989 (prepared by Phillip S. Molina) EXHIBITS ATTACHED March 1989 Financial Statements RECOMMENDATION : n Rev accept and file the Statements . FINANCIAL STATEMENT: See below. DESCRIPTION Seventy-five percent of the Fiscal Year is now over. The City has received 79 . 6% of total budgeted revenues. But when the Internal Service fund, the Enterprise fund revenues, and transfer between funds are eliminated, the City shows amounts received at 74. 1 % of net estimated revenues : ACTUAL BUDGET TOTAL ALL FUND $12, 046, 617 . 35 $15, 130, 961 . 00 TRANSFERS IN 1 , 627, 611 . 00 -0- ENTERPRISE 251 , 204. 74 1 , 405, 183 . 00 ISF 86, 609 .80 131 , 500 . 00 NET $10, 081 , 191 .81 $13, 594, 278. 00 On March 31st, the City had spent 60 . 7% of its budget. Eliminating transfers between funds, the Enterprise fund and the Internal Seri, ce Fund- expenditures, the City expended 54. 6% of its budget: ACTUAL BUDGET TOTAL ALL FUNDS $14, 873, 823 . 62 $24, 515, 635 . 95 TRANSFERS OUT 1 , 627, 611 . 00 -0- ENTERPRISE 5, 066, 931 . 00 9, 510, 023 . 00 ISF 30, 135 . 73 116, 050 . 00 NET 8, 149, 145 . 89 14, 889, 562 .95 Noteworthy points of interest in this month' s Financial Report are as follows : Interest Income currently exceeds the projected earnings for this period. The City has already earned $913, 000 compared to total estimated revenues_ of $1 , 004, 820 . Intergovernmental revenue from the State has exceeded the estimated revenues for 1988-89 . This is primarily attributable to. the Transportation Development Act Fund. There was $15, 600 estimated for TDA revenue this year, but the City received $160, 600 from this funding source. The difference between the amount estimated and the amount received this year is the amount that was due last year, but not received from the Metropolitan Transportation Commission until November of this fiscal year. These funds wi` I -e 4Fed to pay back the advances made by the General Fund last fiscal year for those TDA projects . The Staff recommends that the City Council review, accept and file the Financial Statements for March 1989 . ---------------------------------------------------------------------------- COPIES TO: ITEM NO. !, "- CITY OF DUBLIN INTEREST INCOME $ (000 ) July 47.874 1004.82 August 84.688 1004.82 September 170.766 1004.82 October 396.296 1004.82 November - 448.664; 1004.82 December 488.748 1004.82 January 889.884 1004.82 February 793.444 1004.82 March 913• 804.82 April May - June Q 200 400 600 800 1000 1200 Thousands cumulative receipts budgeted p.s. molina CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF MARCH 1989 Prepared by The Finance Department CITY OF DUBLIN General Funds REVENUE Vs . EXPENDITURES Millions 14 12 - - - - - - - - - - - - - - - -- - - - - - 4�- - - - - =tom- - - - - - - - - - 4, - - - - 10 budgeted expenditure 8 ® actual expenditures 6 estimated revenues actual receipts 4 2 0 ' July Aug Sept Oct Nov Dec Jan Feb Mar p.s. miina 12-05-88 GL102 CITY OF DUBLIN PAGE 1 4/04/89 BALANCE SHEET 14.29.56 FOR THE PERIOD 7/88 THROUGH 3/89 GENERAL SPECIAL SPECIAL CAPITAL ENTERPRISE REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS FUNDS FUNDS FUNDS FUNDS ASSETS CASH 5773542.88- 1909828.64 541213.36 1436051.54 2401434.74 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 13995487.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 IiNENTORY AT COST PREPAID ITEMS 2717.00- FIXED ASSETS 11893496.33 AMOUNTS TO BE PROVIDED TOTAL ASSETS 8366142.70 1909828.64 997305.62 3529744.10 16168320.17 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 268264.79- DEPOSITS OTHERS 50369.33- 3125.00- PAYABLES:A000UNTS 1449.24- INTEREST PAYROLL 1589.94- DUE TO OTHERS 17934.49- 119881.89- 1500.00- 2112038.95- DEBT INSTRUMENTS PAYABLE 715000.00- 17286093.00- TOTAL LIABILTIES 339607.79- 119881.89- 719625.00- 2112038.95- 17286093.00- FUND BALANCES 8026534.91- 1789946.75- 277680.62- 1417705.15- 1117772.83 CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 8026534.91- 1789946.75- 277680.62- 1417705.15- 1117772.83 TOTAL LIAB,FND BAL, RETD EARNS 8366142.70- 1909828.64- 997305.62- 3529744.10- 16168320.17- GI.102 CITY OF DUBLIN PAUL 1 4/04/89 BALANCE SHEET 14.30.20 FOR THE PERIOD 7/88 THROUGH 3/89 INTERNAL TRUST/AGENCY FIXED ASSETS SERVICE FUND GROUP OF FUND ACCOUNTS ASSETS CASH 206978.74 121218.37 UNAMORTIZED BOND DISCOUtTf INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSML7iTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 8616.00 FIXED ASSETS 153884.21 179451.00 AMOUNTS TO BE PROVIDED TOTAL ASSETS 369478.95 121218.37 179451.00 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OTHERS 102708.75- PAYABLES:ACCOUITS INTEREST PAYROLL DUE TO OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES 102708.75- FUND BALANCE 369478.95- 18509.62- CONTRIBUTIONS 63309.00- INVESTMENTS IN FIXED ASSETS 179451.00- RETAINED EARNINGS TOTAL FUND EQUITY 369478.95- 18509.62- 179451.00- TOTAL LIAB,FND BAL, RETD EARNS 369478.95- 121218.37- 179451.00- 11 1O4 1111F CITY OF DUBLIN STATEMENT SHMING PA..13E i 4/O`,/89 Rf :E; VERSUS EXPENDITURE 1i'j 23.f FOR THE PERIOD 7/88 THROUGH 3/89 GENERAL PEVENUE FIRMS CURRENT PERIOD BODGET ACTUAL PERCENT VARTANCE **•x*x**RE'1E1111F.S******* ROPEY TAXES 2741700.00- 1726868.98- 63.0 1014831.02- ALFS TAX 51(A0OO.00- 3993630.06- 77.3 1170369.94- EAL PROPERTY TRANSFERS 92140.00- 659tO.62- 71.6 26199.38- TANSIENT OCCUPANCY TAX 100000.00- 83154.31- 83.2 16845.69- 1:ANCHISF. TAXES 301850.00- 143079.52- 47.4 158770.48- ,ICEIISES & PEPUMTS 355250.00- 165720.63- 46.6 189529.37- 'INES & FORFEITURES 20000.00- 13023.09- 65.1 6976.91- ISES OF MONEY AND PROPERTY 747500.(\7- 889587.38- 119.0 142087.38 11TERIRIVERNMF.NTAL FROM STATE 790600.00- 618413.53- 78.2 17216.47- 'HARGES FuR SERVICES 810300.0(1- 653924.02- 80.7 156375.98- 1fHER SOURCES OF REVENUE 4000.00- 29596.71- 739.9 25596,.71 70TAL P,EVENUE 1.1127340.00- 8382938.85- 75.3 2744401.15- 2 k******EXPFNDITURES******* )ENERAL GOVERIME:NT ACTIVITIFS: 11011-DEPARTMENTAL 617195.00 118.00 617077.iW CITY COUNCIL 83490.00 55405.25 66.4 28084.75-- CITY MANAGER 3 5033 5.00 2.35877.30 67.3 114457.70 CITY ATTORNEY 118700.00 71758.29 60.5 46(341.71 FINANCE DEPARTMENT 159280.00 1O2514.58 64.4 56765.42 BUILUIM MANAGEMENT 1380150.00 317521.18 23.0 1042625.82 1: INSURANCE COST CENTER 213125.00 166541.66 78.1 46583.34 1 ELECTIONS COST (EATER "2650.00 2171.12 81.9 478.88 ACTIVITY TOTAL 2921925.00 951910.38 32.5 1973014.62 2 PUBLIC SAFETY: POLICE 1891910.00 1102121.64 58.3 789788.36 1E CROSSING GULRDS COST .00 .00 .00 ANIMAL CONTROL 43000.00 .00 43000.00 TRAFFIC SIGNALS .00 .O0 .00 DISASTER PREAPREDNESS 17300.00 2253.0; 13.0 150-16.92 FIRE SERVICES OF 'THE JPA 1864904.00 1864904.00 100.0 .00 AC"T.IVITY TOTAL 3817114.00 2969278.72 77.8 847835.28 14 TRANSPORTATION: PUBLIC VX)RKS 198300.00 122341.81 61.7 75958.19 1! STREET MAINTENANCE 42100.00 13604.33 32.3 23495.67 '. STREET SWEEPING 52800.00 28533.45 5-1.0 24266.55 STREFT TREE FAINTENANCE 80600.00 2.11.75.17 33.7 53424.83 f STREET LANDSCAPE MAINTENANCE 158560.00 95467.80 60.2 63092.20 2`< PARATRANSIT SERVICES 2000.00 .00 24100.00 1 ACTIVITY 'T47fAL 534360.00 287122.56 53.7 247237.44 61 HEALTH & WELFARE: VEC'M CCHTROI. 20500.(11 10053.08 49.0 10446.92 1 ACTIVITY TOTAL 20500.00 1.0053.08 49.0 10446.92 1 C1113PRE & LEISURE SERVICES: LIBRARY SERVICES 17.0315.00 80734.00 73.2 29531.00 34� PARK MAI11'TENANCE 368600.(\)I 225`-,8.87 61.2 1-13011.13 D CORL*I1INITY CABLE TV 28500.00 27500.00 96.5 1000.00 RECREATION AUMINISTRAtION 119603.00 83085.71 69.5 36517.29 GL1 CA THE ("" OF DUBLIN STATEMENT SHCkn.NG PAGE 2 4/05/89 JES VERSUS EXPENDITURE 10.23.00 FOR THE PERIOD 7/88 THROUGH 3/ 9 GENERAL REVENUE FUNDS CURRENT PERIOD BI>TfET ACTUAL PERCENT VARIANCE PLAYGROUNDS 60655.W 33555.21 63.6 22099.79 SHAIDION CENTER 60823.00 40326.13 66.3 20496.87 PRESCHOOL 32708.00 20187.27 61.7 12520.73 TEENS PROGRPM 16398.00 7859.42 47.9 88538.58 FIELD SCHEDULING 3668.00 1980.55 54.0 1.687.45 SPECIAL EVENTS 28025.00 14414.39 51.4 13610.61 SENIOR CENTER 69580.00 35066.44 50.4 34513.56 RECP.EATI0N1 INSTRUCTION 49787.00 31614.53 63.5 18172.47 AQUATIC'S 104543.0 50651.92 48.5 53891.(03 ACTIVITY TOTAL 1053205.00 657564.44 62.4 395640.56 COEIEIUNITY DEVELOPMENT: PLANNIING 743010.00 519102.35 69.9 223907.65 BUILDING SAFETY 334385.00 191194.03 57.2 143190.97 ENGINEERM 301500.03 187690.64 62.3 113809.36 ACTIVITY TOTAL 13'18895.IN1 897987.02 65.1 450907.98 CAPITAL I)IPROVEMENTT PROJECTS: GENERAL CIP PROJECTS 63000.00 24321.52 38.6 38678.48 COE"IUNITY IMPROVEMENTS 712354.00 373370.49 52.4 338983.51 PARKS 87.1323.44 220324.84 25.3 650504.60 SPREET CONSTRUCTION/IEIPROVETT 815293.15 4193=13.48 51.4 395950.67 ACTIVITY TOTAL 2461977.59 1037860.33 42.2 1424117.26 T 0 T A L EXPENDITURES 121909'76.59 6811776.53 55.9 5379200.06 EXCESS <REVENUF>EXPENDITURES 1063636.59 1571162.32- 147.7- 2634798.91 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 TRANSFERS OUT TO OTHER FUNDS .00 1627611.00 1627611.00- EXCESS <REVENUE> EXPEMITURE 1063636.59 5EA48.68 5.3 1007187.91 St.)04 THE CITY OF DUBLIN STATEMENT Sill.-WNG PAGE 1 9/05/89 R IES VERSUS EXPENUTTURE 10.7.5.18 FOR THE PERIOD 7/88 THROUGH 3/89 SPECIAL REVIJLUE FUNDS CURRENT PERIOD BUDGET ACTUAL, PERCE1rr 'JAP.IANCE "*******REVENUES******* SALES TAY 83000.00- 68862.00- 83.0 14138.00- F[IfES & FORFEITURES 85000.00- 73075.22- 86.0 11924.78- USES OF MONBY AND PROPERTY 40000.00- .00 40000.00- INTERIIGOVERNMENTAL FROM STATE 36i9jO.O0- 431778.43- 118.4 67178.43 fliTERGOVERN19MrAL FROM FEDERAL. 1191100.00- 933195.65- 78.3 257904.35- CYrHER SOURCES OF REVENUE 2880(0.00- 4554.25- 1.6 283445.75- TOTAL REVENUE 2051700.00- 151146 5.55- 73.7 540234.45- O******EXPENDITURES******* GENERAL WVERNMT:NT ACTIVITIES: ACTIVITY TOTAL 00 .00 00 PUBLIC SAFETY: POLICE 11550.00 5543.24 48.0 6006.76 CROSSING GUARDS COST 22950.00 11368.31 49.5 11581.69 TRAFFIC SIGNALS 78100.00 35725.82 45.7 42374.18 ACTIVITY TOTAL 112fm.DO 52637.37 46.7 59962.63 TRANSPORTATION: STREET MAINTENANCE 469700.00 131594.68 28.0 338105.32 PARATRANSIT SERVICES .00 .00 .00 ACTIVITY TOTAL 469700.00 131594.68 28.0 338105.32 HEALTH & WELFARE: - - - CULTURE & LEISURE SERVICES: COF IUNITY DF.VEL OPT*,14T: ENGINEERING 5000.00 2000.00 40.0 3000.00 ACTIVITY TOTAL 5000.00 2000.00 40.0 30W.00 CAPITAL IMPROVEMENT PROJECTS: CCHAUILITY II.IPROVEMENTS 101100.00 104060.00 102.9 2950.00- PARKS 3842100.00 17589.54 4.6 366610.46 STREET CONSTRUCTION%IMPROVMT 1254300.00 775917.4:3 61.9 478382.57 ACTIVITY TOTAL 1739600.00 897/566.97 51.6 842033.03 T O T A L EXPENDITURES 2326900.0 10:;3799.02 46.6 1243100.98 EXCESS <REVElIUE>EXPEIIDITURE 275200.00 427666.53- 155.4- 702866.53 TRAIISFERS OUT TO OTHER FUNDS .00 .00 .DO EXCESS QZEVENUE> EXPENDITURE 275200.00 427666.53- 155.4- 702866.53 GL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 4/04/89 3JUES VERSUS EXPENDITURE 14.26.24 FOR THE • PERIOD 7/88 THROUGH 3/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 ACTMTIES: 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<REVENUFJEXPENDITURE .00 4404.90- 4404.90 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 EXCESS <REVENUE> EXPENDITURE .00 4404.90- 4404.90 GL104 THE ^""Y OF DUBLIN STATEMENT SHOWING PAGE 1 4/04/89 NUES VERSUS EXPENDITURE 14.22.47 FOR THE PERIOD 7/88 THROUGH 3/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 157325.72 13.2 1034177.28 CITY MANAGER 21875.00 13075.15 59.8 8799.85 CITY ATTORNEY .00 .00 .00 FINANCE DEPARTMENT 9750.00 2597.80 26.6 7152.20 ACTIVITY TOTAL 1223128.00 172998.67 14.1 1050129.33 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINI STRATION 13775.00 7897.78 57.3 5877.22 ACTIVITY TOTAL 13775.00 7897.78 57.3 5877:22 COMMUNITY DEVELOPMENT: ENGINEERING .00 199072.95 199072.95- ACTIVITY TOTAL .00 199072.95 199072.95- CAPITAL IMPROVEMENT PROJECTS: CIVIC CENTER COSTS 8273120.00 4686961.70 56.7 3586158.30 ACTIVITY TOTAL 8273120.00 4686961.70 56.7 3586158.30 T O T A L EXPENDITURES 9510023.00 5066931.10 53.3 4443091.90 EXCESS<REVENUE>EXPENDITURES 8104840.00 4815726.36 59.4 3289113.64 TRANSFERS IN FROM OTHER FUNDS, .00 1627611.00- 1627611.00 EXCESS <REVENUE> EXPENDITURE 8104840.00 3188115.36 39.3 4916724.64 GL104 THE CITY OF DUBLIN STATEMENT SHOWING PAUL 1 4/04/89 'ENUES VERSUS EXPENDITURE 14.19.14 FOR THE PERIOD 7/88 THROUGH 3/89 INTERNAL SERVICE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF HONEY AND PROPERTY 1440.00- .00 1440.00- CHARGES FOR SERVICES 130060.00- 86609.80- 66.6 43450.20- TOTAL REVENUE 131500.00- 86609.80- 65.9 44890.20- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 116050.00 30135.73 26.0 85914.27 ACTIVITY TOTAL 116050.00 30135.73 26.0 85914.27 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES 116050.00 30135.73 26.0 85914.27 EXCESS<REVENUE>EXPENDITURE 15450.00- 56474.07- 365.5 41024.07 EXCESS <REVENUE> EXPENDITURE 15450.00- '56474.07- 365.5 41024.07