Loading...
HomeMy WebLinkAbout4.07 Financial Report 04-30-1989 CITY OF DUBLIN AGENDA S'T'ATEMENT 14EETI NG DATE: May 8 , ]_9 8 9 SUBJECT :April 1989 F'i-nancial Statements EXHIBITS ATTACHED :The April 1989 Financial Statements prepared by Phillip S. Molina RECOMMENDATION W : Review, accept and file the Statements DESCRIPTION :With over 83 percent of the 89-90 fiscal year over. , the City has received 85% of the estimated General Fund revenues . Franchise taxes have exceeded projections because of the Electric and Gas franchise revenues. The estimated amounts are provided from Pacific Gas and Electric Company each year: Estimated Actual GAS franchise $ 29,700 $ 30 , 234 . 24 Electric 121 , 500 128, 569 . 82 Other sources of revenue show a large percentage .increase, but a relatively small. dollar increase in actual revenues year.-to-date compared to the budget. A large portion of this difference is the "Reimbursements from Public Damage" . This account booked $8,787 as income with only $1, 000 budgeted. The Enterprise fund revenues are down, but this is due to the difference between the amount required to be budgeted for debt service and the actual amount paid. (Debt service payments made in the Enterprise fund are charged as rental fees to the General Fund. ) Total General Fund expenditures ( excluding transfers out) are 60. 60 of the current budget. Including transfers total expenditures equal 73 . 90 of the current budget. Capital Improvements continue through April to be below the 830 completion mark, however, the remainder of the fiscal year (May and June) are the months when construction can be expected to escalate due to the good weather conditions. Additionally expenditures are fully accrued, meaning that all bills received in July and August of the next fiscal year for services and products received this fiscal year are posted as expended in this fiscal year. The Fire Service JPA is 100% funded and no more expenditures is expected for the remainder of the yeas. . 1 CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF APRIL 1989 Prepared by The Finance Department CITY DUBLIN General Funds REVENUE Vs . EXPENDITURES ('Millions 14 12 - - - - - - - - -{� - - - -4K- - - - - - - - - - - - - - - - - - - - - - -� - - - -- 10 - - budgeted expenditure 8 actual expenditures 6 44, estimated revenues actual receipts 4 — 2 0 July Aug Sept Oct Nov Dec Jan Feb Mar April p.s. molina 12-05-88 GL102 CITY OF DUBLIN PAGE 1 5/01/89 BALANCE SHEET 9.48.43 FOR THE PERIOD 7/88 THROUGH 4/89 GENERAL SPECIAL SPECIAL CAPITAL ENTERPRISE REVENUE REVENUE ASSESSMENT IMPROVEMENT FUNDS FUNDS FUNDS FUNDS FUNDS ASSETS CASH 5603733.76- 1745098.76 546992.20 1435858.74 1929447.17 UNAMOP.TIZED BOND DISCOUNT INVESTMENTS AT COST 14490487.37 1772391.10 RECEIVABLES:TAXES ACCOUNTS (NET) 1625.22 INTEREST 50499.00 ASSESSMENTS 456092.26 RENTS NOTES DUE FRA OTHERS 15931.90- 2093692.56 50499.00 INVENTORY AT COST PREPAID ITEMS 2467.00- FIXED ASSETS 11893496.33 .AMOUNTS TO BE PROVIDED TOTAL ASSETS 8869979.93 1745098.76 1003084.46 3529551.30 15696332.60 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 258335.04- DEPOSITS OTHERS 48752.50- 3125.00- PAYABLES:A000UNTS 1449.24- INTEREST PAYROLL 1668.98- DUE TO OTHERS 1089.09 8660.00- 1500.00- 2052038.95- DEBT INSTRUMENTS PAYABLE 715000.00- 17286093.00- TOTAL LIABILTIES 309116.67- 8660.00- 719625.00- 2062038.95- 17286093.00- FUND BALANCES 8560863.26- 1736438.76- 283459.46- 1467512.35- 1589760.40 CONTRIBUTIONS INVESTMENTS IN FIXED ASSETS RETAINED EARNINGS TOTAL FUND EQUITY 8560863.26- 1736438.76- 283459.46- 1467512.35- 1589760.40 TOTAL LIAB,FND BAL, RETD EARNS 8869979.93- 1745098.76- 1003084.46- 3529551.30- 15696332.60- 'GL102 CITY OF DUBLIN PAGE 1 5/01/89 BALANCE SHEET 9.52.00 FOR THE PERIOD 7/88 THROUGH 4/89 INTERNAL TRUST/AGENCY FIXED ASSETS SERVICE FUND GROUP OF FUND ACCOUNTS ASSETS CASH 207469.03 126963.37 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 8616.00 FIXED ASSETS 153884.21 179451.00 AMOUNTS TO BE PROVIDED TOTAL ASSETS 369969.24 126963.J7 179451.00- LIAB, FIND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVE.PMNT DEPOSITS OTHERS 1U8453.75- PAYABLES:A000UNTS INTEREST PAYROLL DUE Tv OTHERS DEBT INSTRUMENTS PAYABLE TOTAL LIABILITIES 108453.75- FUND BALANCE 369969.24- 18509.62- CONTRIBUTIONS 63309.00- ; INVESTMENTS IN FIXED ASSETS 179451.00- RETAINED EARNINGS TOTAL FUND EQUITY 369969.24- 18509.62- 179451.00- TOTAL LIAB,FND BAL, RETD EARNS 369969.24- 126963.37- 179451.00- I GL104 Th. -iTY OF DUBLIN STATEMENT SHOWING PAGE 1 5/01/89 REVENUES VERSUS EXPENDITURE 9.25.30 FOR THE PERIOD 7/88 THROUGH 4/89 GENERAL REVENUE FUNDS CURRENT PERIOD. BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* PROPERTY TAXES 2741700.00- 2054290.60- 74.9 687409.40- SALES TAX 5164000.00- 4341230.06- '84.1 822769.94- REAL PROPERTY TRANSFERS 92140.00- 65940.62- 71.6 26199.38- TRANSIENT OCCUPANCY TAX 100000.00- 83154.31- 83.2 16845.69- FRANCHISE TAXES 301850.00- 305731.45- 101.3 3881.45 LICENSES & PERMITS 355250.00- 185163.67- 52.1 170086.33- FINES & FORFEITURES 20000.00- 14357.16- 71.8 5642.84- USES OF MONEY AND PROPERTY 747500.00- 1099458.71- 147.1 351958.71 INTERNGOVERNMENTAL FROM STATE 790600.00- 692813.35- 87.6 9786.65- INTERGOVERNMENTAL FROM FEDERAL .00 59955.49 59955.49- CHARGES FOR SERVICES 810300.00- 674898.07- 83.3 135401.93- OTHER SOURCES OF REVENUE 4000.00- 30553.16- 763.8 26553.16 TOTAL REVENUE 11127340.00- 9487635.67- 85.3 1639704.33- *******EXPENDITURES******* GENERAL. GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 617195.00 118.00 617077.00 CITY COUNCIL 83490.00 59941.40 71.8 23548.60 CITY MANAGER 350335.00 261290.35 74.6 . 89044.65 CITY ATTORNEY 118700.00 79622.39 67.1 39077.61 FINANCE DEPARTMENT 159280.00 113412.84 71.2 45867.16 BUILDING MANAGEMENT 1380150.00 320290.11 23.2 1059859.89 INSURANCE COST CENTER 213125.00 170409.94 80.0 42715.06 ELECTIONS COST CENTER 2650.00 2171.12 81.9 478.88 ACTIVITY TOTAL, 2924925.00 1007256.15 34.4 1917668.85 PUBLIC SAFETY: POLICE 1891910.00 1301267.18 - 68.8 590642.82 CROSSING GUARDS COST .00 .00 •00 ANIMAL CONTROL 43000.00 31959.90 74.3 11040.10 TRAFFIC SIGNALS .00 .00 .00 DIS&STER PREAPREDNESS . 17300.00 2662.78 15.4 14637.22 FIRE SERVICES OF THE JPA 1864904.00 1864904.00 100.0 .00 ACTIVITY TOTAL 3817114.00 3200793.86 83.9 616320.14 TRANSPORTATION: PUBLIC WORKS 198300.00 138796.04 70.0 59503.96 STREET MAINTENANCE 26100.00 20576.74 78.8 5523.26 STREET SWEEPING 52800.00 28533.45 54.0 24266.55 STREET TREE MAINTENANCE 80600.00 38105.75 47.3 42494.25 STREET LANDSCAPE MAINTENANCE 158560.00 109802.27 69.2 48757.73 PARATRANSIT SERVICES 2000.00 .00 2000.00 ACTIVITY TOTAL 518360.00 335814.25 64.8 182545.75 tiKALTH & WELFARE: VECTOR CONTROL 20500.00 14927.08 72.8 5572.92 ACTIVITY TOTAL 20500.00 14927.08 72.8 5572.92 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 110315.00 81111.59 73.5 29203.41 PARK MAINTENANCE 368600.00 238533.22 64.7 130066.78 COMMUNITY CABLE TV. 28500.00 27500.00 96.5 1000.00 OL104 THL .Y OF DUBLIN STATEMENT SIUIING PAGE 2 5/01/89 REVENUES VERSUS EXPENDITURE 9.25.30 FOR THE PERIOD 7/88 THROUGH 4/89 GENERAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE RECREATION ADMINISTRATION 119603.00 91665.98 76.6 27937.02 PLAYGROUNDS 60655.00 42251.82 69.7 18403.18 SHANNON CENTER 60823.00 44028.52 '72.4 16794.48 PRE.3CHOOL 32708.00 22510.51 68.8 10197.49 'TEENS PROGRAM 16398.00 10669.26 65.1 5728.74 FIELD SCHEDULING 3668.00 2240.70 61.1 1427.30 SPECIAL EVENTS 28025.00 18131.96 64.7 9893.04 SENIOR CENTER 69580.00 39082.25 56.2 30497.75 RECREATION INSTRUCTION 49787.00 30358.53 61.0 19428.47 AQUATICS 104543.00 69725.78 66.7 34817.22 ACTIVITY TOTAL 1053205.00 717810.12 68.2 335394.88 COMMUNITY DEVELOPMENT: PLANNING 743010.00 558491.49 75.2 184518.51 BUILDING SAFETY 334385.00 216207.45 64.7 118177.55 ENGINEERING 301500.00 203939.05 67.6 97560.95 ACTIVITY TOTAL 1378895.00 978637.99 71.0 400257.01 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS 63000.00 29053.06 46.1 33946.94 COMMUNITY IMPROVE14ENTS 712354.00 447392.78 62.8 264961.22 PARKS 887329.44 272728.89 30.7 614600.55 STRaET CONSTRUCTION/IMPROVMT 815294.15 385700.97 47.3 429593.18 ACTIVITY TOTAL 2477977.59 1134875.70 45.8 1343101.89 T O T A L EXPENDITURES 12190976.59 7390115.15 60.6 4800861.44 EXCESS <REVENU©EXPENDITURES 1063636.59 2097520.52- 197.2- 3161157.11 TRANSFERS IN FROK OTHER FUNDS .00 .00 .00 `TRANSFERS OUT TO OTHER FUNDS' .00 1627611.00 1627611.00= EXCESS < EVENUFJ EXPENDITURE 1063636.59 469909.52- 44.2- 1533546.11 •GL104 Thy �TY OF DUBLIN STATEMENT SNOWING PAGE 1 5/01/69 REVENUES VERSUS EXPENDITURE 9•ZI•56 FOR THE PERIOD 7/88 THROUGH 4/89 SPECIAL REVENUE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SALES TAX 83000.00- 75467.00- 90.9 7533.00- FINES & FORFEITURES 85000.00- 81205.34- '95.5 3794.66- USES OF MONEY AND PROPERTY 40000.00- .00 40000.00- INTERNGOVERHMENTAL FROM STATE 364600.00- 521820.44- 143.1 157220.44 INTERGOVERNMENTAL FROM FEDERAL 1191100.00- 933195.65- 78.3 257904.35- OTHER SOURCES OF REVENUE 288000.00- 4554.25- 1.6 283445.75- TOTAL REVENUE 2051700.00- 1616242.68- 78.8 435457.32- *******EXPENDITURES*"*"* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 PUBLIC SAFETY: POLICE 11550.00 5600.65 48.5 5949.35 CROSSING GUARDS COST 22950.00 11168.00 48.7 11782.00 TRAFFIC SIGNALS 78100.00 41861.84 53.6 36238.16 ACTIVITY TOTAL 112600.00 58630.49 52.1 53969.51 TRANSiORTATION: STREET MAINTENANCE 469700.00 163309.19 34.8 306390.81 PA.RAiRANSIT SERVICES .00 .00 .00 ACTIVITY TOTAL 469700.00 163309.19 34.8 306390..81 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: ENGINEERING 5000.00 2000.00 4040 3000.00 ACTI4TTY TOTAL 5000.00 2000.00 40.0 3000.00 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 101100.00 104060.00 102.9 2960.00- PARKS 384200.00 17637.74 4.6 366562.26 STREET CONSTRUCTION/IMPROVMT 1254300.00 844983.88 67.4 409316.12 ACTIVITY TOTAL 1739600.00 966681.62 55.6 772918.38 T 0 T A L EXPENDITURES 2326900.00 1190621.30 51.2 1136278.70 EXCESS <REVENUFJEXPENDITURE 275200.00 425621.38- 154.7- 700821.38 'TRANSFERS OUT TT OTTER FUNKS` .00 °'50000.00, "50000.00= EXCESS <REVENUE> EXPENDITURE 275200.00 375621.38- 136.5- 650821.38 GL104 THE ti OF DUBLIN STATEMENT SHOWING PAGE 1 5/01/89 REVENUES VERSUS EXPENDITURE 9.34.33 FOR THE PERIOD 7/88 THROUGH 4/89 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 363140.00- 193685.27- 53.3 169454.73- USES OF HONEY AND PROPERTY 39200.00- .00 39200.00- OTHER SOURCES OF REVENUE 5000.00- .00 5000.00- TOTAL REVENUE 407340.00- 193685.27- 47.5 213654.73- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 117638.00 117150.00 99.6 488.00 ACTIVITY TOTAL 117638.00 117150.00 99.6 488.00 PUBLIC SAFETY: TRFC SIGS/STREET LIGHTING 144500.00 99199.33 68.7 45300.67 ACTIVITY TOTAL 144500.00 99199.33 68.7 45300.67 TRANSPORTATION: STREET TREE MAINTENANCE 10300.00 951.24 9.2 9348.76 STREET LANDSCAPE MAINTENANCE 64250.00 24336.61 37.9 39913.39 ACTIVITY TOTAL 74550.00 25287.85 33.9 49262.15 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: PARR MAINTENANCE 13600.00 9075.33 66.7 4524.67 ACTIVITY TOTAL 13600.00 9075.33 66.7 4524.67 COMMUNITY DEVELOPMENT: ENGINEERING 13500.00 8381.65 62.1 5118.35 ACTIVITY TOTAL 13500.00 8381.65 62.1 5118.35 CAPITAL IMPROVEMENT PROJECTS: T O T A L EXPENDITURES 363788.00 259094.16 71.2 104693.84 EXCESS<REVENUFJEXPENDITURE 43552.00- 65408.89 150.2- 108960.89- EXCESS GEVENUFJ EXPENDITURE 43552.00- 65408.89 150.2- 108960.89- t GL104 THE -iY OF DUBLIN STATEMENT SHOWING PAGE 1 5/01/89 REVENUES VERSUS EXPENDITURE 9.44.51 FOR THE PERIOD 7/88 THROUGH 4/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- 16819.17- 213.0 8921.17 TOTAL REVENUE 7898.00- 16819.17- 213.0 8921.17 *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: STREET LANDSCAPE MAINTENANCE .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 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 PAS 3898.00 8607.07 220.8 4709.07- ACTIVITY TOTAL 7898.00 8607.07 109.0 709.07- T 0 T A L EXPENDITURES 7898.00 8607.07 109.0 709.07- EXCESS<REVENUFJEXPENDITURE .00 8212.10- 8212.10 TRANSFERS-IN-FROM OTHER FUNDS .00 "50000.00- "50000.00' EXCESS <REVENUE> EXPENDITURE .00 58212.10- 58212.10 GL104 THE t OF DUBLIN STATEMENT SHOWING PAGE 1 5/01/89 REVENUES VERSOS EXPENDITURE 9.41.24 FOR THE PERIOD 7/88 THROUGH 4/B9 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF HONEY AND PROPERTY 1405183.00- 251204.74- 17.9 1153978.26- OTHER SOURCES OF REVENUE .00 .00 •00 TOTAL REVUE 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 8199.85 CITY ATTORNEY .00 .00 .00 FINANCE DEPARTMENT 9750.00 4696.70 48.2 5053.30 ACTIVITY TOTAL 1223128.00 175097.57 14.3 1048030.43 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 13775.00 8334.82 60.5 5440.18 ACTIVITY TOTAL 13775.00 8334.82 60.5 5440.18 COMMUNITY DEVELOPMENT: ENGINEERING .00 218193.58 218193.58- ACTIVITY TOTAL .00 218193.58 218193.58- CAPITAL IMPROVEMENT PROJECTS: CIVIC CENTER COSTS 8273120.00 5137292.70 62.1 3135827.30 ACTIVITY TOTAL 8273120.00 5137292.70 62.1 3135827.30 T O T A L EXPENDITURES 9510023.00 5538918.67 58.2 3971104.33 EXCESSQtEVENUE>EXPENDITURES 8104840.00 5287713.93 65.2 2817126.07 TRANSFERS,IN-FROM.OTHER'FUNDS' .00 ``1627611.00 °1627611.00:, TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 EXCESS TEVENUE> EXPENDITURE 8104840.00 3660102.93 45.2 4444737.07 GL104 v THE CITY OF DUBLIN STATEMENT SH94M _ PAGE 1 5/01/89 REVENUES VERSUS EXPENDITURE 9.38.00 FOR THE PERIOD 7/88 THROUGH 4/89 INTERNAL SERVICE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES*****" USES OF MONEY AND PROPERTY 1440.00- .00 1440.00- CHARGES FOR SERVICES 130060.00- 90097.80- '69.3 39962.20- TOTAL REVENUE 131500.00- 90097.80- 68.5 41402.20- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 116050.00 33133.44 28.6 82916.56 ACTIVITY TOTAL 116050.00 33133.44 28.6 82816.56 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: T 0 T A L EXPENDITURES 116050.00 33133.44 28.6 82916.56 EXCESS<TEVENUFJEXPENDITURE 15450.00- 56964.36- 368.7 41514.36 EXCESS <REVENUb EXPENDITURE 15450:00- 56964:36- 368.7 41514.36