Loading...
HomeMy WebLinkAbout4.05 FinRpt2-94 ~ "' e e CITY OF DUBLIN AGENDA STATEMENT CITY COUNCIL MEETING DATE: March 14, 1994 .0JFinancial Report For The Month of February 1994. ~~ (Prepared by: Paul S. Rankin, Assistant city Manager) EXHIBITS ATTACHED: 1. / Balance Sheet and Income Statements for the Period Ending February 28, 1994 RECOMMENDATION:~ccePt and file the report. FINANCIAL: ~ See report for monthly financial activity. SUBJECT: DESCRIPTION: This item provides the monthly financial statement for the month of February 1994. This report will highlight significant trends, which differ from information presented in earlier monthly reports. GENERAL FUND REVENUES The General Fund accounts for the majority of the city's annual revenue and expenses. OVerall, when co~pared to the prior year, Revenues are traCking at approximately the same level. In Fiscal Year 1992/93 as of February the City had collected nearly 60.4% of the budgeted General Fund Revenues as compared to 60.4% for the same period in Fiscal Year 1993/1994. There are specific General Fund Revenues which may not meet the original budget estimate. The City has received preliminary estimates of 1993/94 Pro~rty Tax Revenue. It is too early to have precise information on de11nquencies. Therefore, the County has applied estimates to the amount, which was levied on the tax roll. It appears that Property Tax revenues may be off by approximately 2.14% from the Budget Estimate which excluded the state of California 93/94 tax shift. As the City Council is aware, the formula for this tax shift did not impact the City of Dublin, due to the City'S date of incorporation. The city was impacted by the permanent property tax shift enacted in Fiscal Year 1992/93, which reduced Property Tax Revenue by approximately $364,000 in the current Fiscal Year. In Fiscal Year 1993/94 it appears that the reduced revenue will equate to a reduction from the budget estimate (assuming no 93/94 State Reduction) of approximately $80,000. In the upcoming months, Staff will investigate further wi th the County Audi tor-Controller the reason for the revenue reduction. Franchise Taxes collected are also running slightly behind in the area of Cable Television. The Budget estimate was prepared prior to the rate decrease enacted in September of 1993. The actual receipt for this revenue was approximately 2.2% less than the Budget estimate. This is a reduction of $3,377. Staff has also noted that Business License revenue is lagging behind the amount collected last fiscal year. It appears that in part this is attributable to the decline in building repair/construction business. Staff will also be analyzing this trend in the upcoming months. EXPENDITURES Total expendi tures as of February 28th for the General Fund, represent 62.1% authorized budget, which corresponds very closely to the percentage of the year which has passed (i.e. 67% from July - February). The February report reflects the Police Services Expenses for the first six months of the year. The city still has not received any billing for Animal Control Services. Ma jor deviations in other Departments have been discussed in previous monthly reports. For example, Engineering Expenses in the General Fund are traCking faster than anticipated due to a delay on several Capital Projects. It is recommended that the City Council receive and file these reports as authorized by section 41004 of the California Government Code. ---------------------------------------------------------------------- ITEM NO. 4~5 COPIES TO: CITY CLERK FILE ~ ...~.~_~h,_~~::....: e CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF FEBRUARY 1994 Prepared by. The Finance Department e e e BGLl02 CITY OF DUBLIN PAGE 1 3/01/94 BU,-~JlCE SHEET 15.12.58 FOR m PERIOD 7/93 THROUGH 2/94 GENERAL SPECH.L SPECIAL CAPIT.l.L REVENUE REVENUE ].$SESSHEHT IMPROVEMENT FUNDS FUNDS FUNDS FUNDS ]..5SETS CASH 2007450.15- 710472.48 363634.02 29579.71- CASH WITH FISCJ..L AGENT 121210.04 UNAMORTIZED BOND DISCOm INVESTHENTS AT COST 18413698.63 RECEIVABLES: TAXES ACCOUlITS lHET) 191123.00 110795.71 INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS Ilf\lEllTORY AT COST PREPAID ITEMS 5164.98 FIXED ASSETS AJ400HTS TO BE PROVIDED 2232500.00 TOTAL ASSETS 16602536.46 710472.48 2717344.06 81216.00 LIAB, FHO BAL, RETHD EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT 11112.75- DEPOSITS FOR AB1600 FEES 188478.46- DEPOSITS OTHERS 189983.66- 3125.00- P'ilBLES:ACCOONTS 217855.67- INTEREST PAYROLL 37100.70- DUE TO OTHERS DEBT INSTRUMENTS PAYABLE 2790000.00- TOTAL LIABILTIES 238197.11- 217855.67- 2793125.00- 188478.46- mID BALANCES 16364339.35- 492616.81- 75780.94 107262.46 TOTAL FUND EQUITY 16364339.35- 492616.81- 75780.94 107262.46 'rol'AL LIAB,FND BAL, RETD EARNS 16602536.46- 710472.48- 2717344.06- 81216.00- .. e e BGLl02 CITY OF DUBLIN PAGE 1 3/01/94 BAIJ.HCE SHEET 15.14.20 FOR m PERIOD 7/93 THROUGH 2/94 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUlfDS GROUP OF TERM DEBT FUND ACCOUNTS ACCOUNT GROUP ASSETS CASH 316579.60 6932.72- CASH WITH FISCAL AGENT 1726901.55 UlWIORTIZED BOND DISCOUNT IlfVESTMENTS AT COST RECEIVABLES: TAXES ACCOUNTS (NET) INTEREST 46871.38 ASSESSMENTS RENTS NOTES DUE FROM OTHERS IlfVENTORY AT COST PREPAID ITEMS 119.60 FIXED ASSETS 165970.10 21623460.54 470014.62 AlllUllTS TO BE PROVIDED 2548360.41 TOTAL ASSETS 482669.30 23390300.75 470014 .62 2548360.41 LIAB, FHO BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMNT DEPOSITS OO'HERS PAYABLES:ACCOUlITS 25603.30- INTEREST PAYROLL DOE TQ OTHERS DEBT IHSTRUHEHTS PAYABLE 18602851.88- 2548360.41- TOTAL LIABILITIES 18628455.18- 2548360.41- FUND BALANCE 314411.56- 348044.43 CONTRIBUTIONS 168257.74- 5109890.00- IHVESTMENTS IN FIXED ASSETS 470014.62- RETAINED EARNINGS TOl'At FUND EQUITY 482669.30- 4761845.57- 470014.62- TOTAL liAB, FND BAL, RETD EARNS 482669.30- 23390300.75- 470014.62- 2548360.41- e e BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/02/94 REVENUES VERSUS EXPEHDITURE 11.55.51 FOR THE PERIOD 7/93 THROUGH 2/94 GENERAL REVENUE FUND CURRENT PERIOD BOIX;ET ).CTUAL PERCENT VARH.NCE ********REVENUES******* PROPERTY TAXES 3839040.00- 2128220.44. 55.4 1710819.56. SALES TAX 5560000.00- 3696592.55- 66.5 1863407.45- REAL PROPERTY TRANSFERS 73000.00- 40058.24- 54.9 32941. 76- TRANSIENT OCCUPANCY TAX 86000.00- 67468.00- 78.5 18532.00- FRANCHISE TAXES 505900.00- 222772.14- 44.0 283127.86- LICENSES & PERMITS 375600.00- 244834.22- 65.2 130765.78- FINES & FORFEITURES 32000.00- 23641. 39- 73.9 8358.61- OSES OF HOBEY A1fD PROPERTY 881100.00- 419205.24- 47.6 461894.76- IlITERNGOVERNMEHTAL FROM STATE 964425.00- 555561.32- 57.6 408863.68- CBARGES FOR SERVICES 714533.00- 355798.88- 49.8 358734.12- -RER SOURCES OF REVENUE 28100.00- 132001.69- 469.8 103901.69 /JTAL REVENUE 13059698.00- 7886154.11- 60.4 5173543.89- *~*****EXPENDITURES******* GENERAL GOVERHKElfT ACTIVITIES: NOH-DEPARTHEHT).1 45625.00 .00 45625.00 cm COOIfCIL 1010 112438.00 64187.12 57.1 48250.88 CITY MAHAGER 1020 258909.00 163966.63 63.3 94942.37 CITY ATTORlfEY 1030 306170.00 158728.46 51.8 147441.54 ADMIN SERVICES 1040 414253.00 242254.13 58.5 171998.87 BUILDING KAHAGEHENT 1050 334867.00 191412.75 57.2 143454.25 FACILITY RENTAL 1050-719 1532816.00 1444778.58 94.3 88037.42 IHSURAlfCE COST CENTER 1060 169656.00 145388.59 85.7 24267.41 ELECrIONS COST CEllTER 1070 12910.00 10548.15 81.7 2361. 85 ACTIVITY TOTAL 3187644.00 2421264.41 76.0 766379.59 PUBLIC SAFETY: POLl CE 2010 3109012.00 1564759.97 SO.3 1544252.03 CROSSING GUARDS COST 2020 .00 .00 .00 AlUHAL CONTROL 2030 103100.00 .00 103100.00 TRAFFIC SIGNALS 2040 .00 .00 .00 DISASTER PREAPREDNESS 2050 37067.00 20196.70 54.5 16870.30 FIRE SERVICES JPA 2060 2733103.00 1961425.44 71.8 771677.56 }.Cl'IVITY TOTAL 5982282.00 3546382.11 59.3 2435899.89 TRAHSPORTATIOB: PUBLIC WORKS 3010 288715.00 173015.27 59.9 115699.73 STREET KAINTENAllCE 3020 165025.00 707.91 .4 164317.09 STREET TREE MAINTENANCE 3040 48960.00 24029.86 49.1 24930.14 STREET LAlfDSCAPE KAINT. 3050 160260.00 97304.67 60.7 62955.33 PARATRADSIT SERVICES 3060 .00 .00 .00 ACTIVITY TOT).L 662960.00 295057.71 44.5 367902.29 HEALTH & WELFARE: VECl'OR CONTROL 5010 .00 .00 .00 WASTE KANAGEMENT 5020 100.00 18.24 18.2 81.76 ACl'IVITY TOTH 100.00 18.24 18.2 81.76 CULTURE & LEISURE SERVICES: LIBRARY SERVICES 8010 165000.00 82500.00 50.0 82500.00 CULTURAL ACTIVITIES 8011 8000.00 8000.00 100.0 .00 HERITAGE CENTER 8012 10850.00 527 . 73 4.9 10322.27 e e GL104 THE CITY OF DUBLIN STA'fEMEN'l' SHOWING PJ..GE 2 3/02/94 REVENUES VERSUS EXPElIDlTURE 11.55.51 FOR THE PERIOD 7/93 THROUGH 2/94 GENERAL REVENUE FUND CURRENT PERIOD B(ITX;ET ACTUAL PERCErfl' VARIANCE DUBLIN CEMETERY 8013 .00 1192.83 1192.83... PARK MAIHTEN~..NCE 8020 591955.00 333553.60 56.3 258401.40 COMMUNITY CABLE TV 8030 20279.00 20279.00 100.0 .00 RECREATION ADMIN. 8040 176453.00 112743.36 63.9 63709.64 PLAYGROUNDS 8045 80378.00 45152.12 56.2 35225.88 SllANNONCENTER 8050 125344.00 70470.60 56.2 54873.40 PRESCHOOL 8055 36966.00 21427.34 58.0 15538.66 TEKNS PROGRAM 8060 34350.00 16963.80 49.4 17386.20 FIELD SCHEDULING 8065 105635.00 46243.24 43.8 59391. 76 YOUTH SPORTS 8066 31043.00 19299.99 62.2 11743.01 SPECIAL EVENTS 8070 31070.00 14150.12 45.5 16919.88 SENIOR CENTER 8080 137449.00 60818.76 44.2 76630.24 "'~CREATIOH INSTRUCTION 8090 91764.00 44927.52 49.0 46836.48 ,.QUATICS 8100 199966.00 122145.16 61.1 77820.84 ACTIVITY TOTAL 1846502.00 1020395.17 55.3 826106.83 COMMUNITY DEVELOPMENT: PLAlINING 9010 560879.00 310197.61 55.3 250681.39 BUILDING SAFETY 9020 256241.00 149038.82 58.2 107202.18 ENGIDEERING 9030 173970.00 154190.31 88.6 19779.69 ECONOMIC DEVELOPMENT 9040 9610.00 5367.29 55.9 4242.71 ACUVITY Tlm.L 1000700.00 618794.03 61.8 381905.97 CAPITAL IMPROVEMENT PROJECTS: COMMUHITY IMPROVEMENTS 94NN .00 662.32 662.32- PARKS 95NN 20000.00 .00 20000.00 STREET CONSTRC/IMPROVMT 96NN 37000.00 12923.59 34.9 24076.41 ACTIVITY TOTAL 57000.00 13585.91 23.8 43414.09 rOT A L EXPENDITURES 12737188.00 7915497.58 ' 62.1 4821690.42 E),\~ESS <REVENUE>EXPEHDITURES 322510.00- 29343.47 . 9.1- 351853.47- TRANSFERS IN FROM Ol'HER FUNDS .00 .00 .00 TRANSFERS OUT TO OTHER FONDS .00 29875.68 29875.68- EXCESS <REVENUE> EXPENDITURE 322510.00- 59219.15 18.4- 381729.15- e e BGL104 THE CI'l'Y OF DUBLIlf STATEMENT SH~IHG PAGE 1 3/01/94 REVENUES VERSUS EXPEHDITURE 14.48.08 FOR THE PERIOD 7/93 THROOGH 2/94 SPECIAL REVEHUE FUNDS CURRIDIT PERIOD BUDGET ACTUAL PERCENT VARllNCE ********REVEHUES******* SALES TAX 114000.00- 77712.92- 68.2 36287.08- FINES & FORFEITURES 26500.00- 22208.80- 83.8 4291.20- USES OF MONEY AND PROPER'l'Y 16430.00- .00 16430.00- IlfTERlfGOVERlOOlfTAL FROM STATE 719440.00- 275125.35- 38.2 444314.65- INTERGOVERNMENTAL FROM COUHTY 38265.50- 56526.00- 147.7 18260.50 IHTERGOVERllHElfTAL FROM FEDERAL 2147125.00- 51835.43- 2.4 2095289.57- CHARGES FOR SERVICES 716557.00- 382330.38. 53.4 334226.62- OTHER SOURCES OF REVENUE 5000.00- 8294,03- 165.9 3294.03 TO'l'AL REVENUE 3783317.50- 874032.91- 23.1 2909284.59- *******EXPEHDITURES******* GENERAL GOVERNMENT ACTIVITIES: HON.DEPARTMENTAL .00 .00 .00 CITY COONCIL 2450.00 .00 2450.00 CITY MANAGER .00 .00 .00 CITY ATTORNEY .00 .00 .00 AC'rIVITY TOTAL 2450.00 .00 2450.00 PUBLIC SAFETY: POLICE 18170.00 5395.28 29.7 12774.72 TRAFFIC SIGNAlS 93500.00 43587.33 46.6 49912.67 AC'rIVITY TOTAL 111670.00 48982.61 43.9 62687.39 TRAlfSPORTATIOlf: STREET MAINTENANCE 177865.00 128232.58 72.1 49632.42 STREET SWEEPING 67200 . 00 41930.20 62.4 25269.80 .5TREET LAlIDSCAPE MAINTElfAlfCE .00 .00 .00 ACTIVITY TOTAL 245065.00 170162.78 69.4 74902.22 ffEAtTH & WELFARE: WASTE MANAGEMENT 572236.00 261948.60 45.8 310287.40 CULTURE & LEISURE SERVICES: COHMUNI'l'Y DEVELOPKEllT: EHGINEERnlG 116497.00 30145.87 25.9 86351.13 ACTIVITY TOTAL 116497.00 30145.87 25.9 86351.13 CAPITAL IMPROVEMENT PROJEctS: GENERAL CIP PROJECTS .00 .00 .00 COMHUNITY IMPROVF8ENTS 181223.50 34116.57 18.8 14 7106.93 PARKS 127971.00 99584.55 77.8 28386.45 STREET CONSTROCTION/IHPROVMT 2334975.00 42428.01 1.8 2292546.99 ACfIVITY TOtAL 2644169.50 176129.13 6.7 2468040.37 TOT A L EXPENDITURES 3692087.50 687368.99 18.6 3004718.51 EXCESS <R~rnE>EXPENDlTURE 91230.00- 186663.92- 204.6 95433.92 TRANSFERS TIt FROM OTHER FUNDS .00 32728.18- 32728.18 TRANSFERS OUT TO OTHER FUNDS .00 2852.50 2852.50- EXCESS <REVENUE> EXPENDITURE 91230.00- 216539.60- 237.4 125309.60 e e BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/01/94 REVENUES VERSOS EXPENDITURE 14 .51. 47 FOR THE PERIOD 7/93 THROOGH 2/94 SPECIAL ASSESSMENT FUlIDS CURRENT PERIOD BUDGET ACTUll PERCENT VARIANCE ********REVENUES******* SPECIAL BENEFITS ASSESSMENTS 523913.00~ 265991.14- 50.8 257921.86~ USES OF MONEY AND PROPERTY 28260.00- .00 28260.00- OTHER SOURCES OF REVENUE 10400.00- 10116.76- 97.3 283.24- TOTAL REVENUE 562573.00- 276107.90- 49.1 286465.10- *******EXPENDITURES******* GENERAL GOVERlfHEHT ACTIVITIES: HON-DEPARTMENTAL 650731.00 650730.75 100.0 .25 FINANCE DEPARTMENT .00 .00 .00 ACTIVITY TOTAL 650731. 00 650730.75 100.0 .25 .LC SAFETY: .<FC SIGS/STREET LIGHTING 202300.00 106834.93 52.8 95465.07 ACTIVITY TOTAL 202300.00 106834.93 52.8 95465.07 TRANSPORTATION: PUBLIC WORKS 1701. 00 1599.20 94.0 101.80 STREET TREE MAINTENANCE 11350.00 3377.94 29.8 7972.06 STREET LANDSCAPE MAINTENANCE 110085.00 61814 .92 56.2 48270.08 ACTIVITY TOTAL 123136.00 66792.06 54.2 56343.94 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: roMMUlfITY DEVELOPMENT: EHGOOERING 7550.00 3546.10 47.0 4003.90 ACTIVITY TOTAL 7550.00 3546.10 47.0 4003.90 CAPITAL IMPROVEMENT PROJECTS: COMMIlNITY IMPROVEMENTS .00 4500.00 4500.00- STREET CONSTRUCTIOH/IMPROVMT .00 .00 .00 ACTIVITY TOTAL .00 4500.00 4500.00- TOT A L EXPENDITURES 983717.00 832403.84 84.6 151313 .16 EXCESS<REVENUE>EXPENDITURE 421144.00 556295.94 132.1 135151.94- TRANSFERS IN FRCf( 0TliER FUNDS .00 110995.44- 110995. U TRANSFERS OUT TO OTHER FUNDS .00 110995. 44 110995.44- EXCESS <REVENUE> EXPENDITURE 421144.00 556295.94 132.1 135151.94- e e BGL104 THE CITY OF DUBLIll STATEMENT SHOWING PAGE 1 3/01/94 REVENUES VERSUS EXPENDITURE 15.08.48 FOR m PERIOD 7/93 THROUGH 2/94 CAPITAL nlPROVID4ENT },UlID CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 4340.00- .00 4340.00- OTHER SOURCES OF REVElfUE 925445.00- 19312.00- 2.1 906133.00- TOTAL REVENUE 929785.00- 19312.00- 2.1 910473.00- *******EXPEHDlTURES******* GENERAL GOVERNMENT ACTIVITIES: ACrrVITY TOTAL .00 .00 .00 pOELIC SAFETY: TRAliSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMKUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 50000.00 .00 50000.00 STREET a:JlfSTRUCTIOH/IKPROVMT 646136.00 78002.03 12.1 568133.97 ACTIVITY TOTAL 696136.00 78002.03 11.2 618133.97 TOT A L EXPENDITURES 696136.00 78002.03 11.2 618133.97 EXCESS<REVRNUE>EXPENDITURE 233649.00- 58690.03 25.1- 292339.03- EXCESS <REVENUE> EXPENDITURE 233649.00- 58690.03 25.1- 292339.03- e e BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 3/01/94 REVENUES VERSUS EXPENDITURE 14.58.58 FOR THE PERIOD 7/93 THROOGR 2/94 INTERNAL SERVICE FUND CURRENT PERIOD Bmx;ET ACTUAL PERCENT VARDlJCE *tt*ttt*REVEHUES******* USES OF KOHEY AND PROPERTY 9360.00- .00 9360.00- CHARGES FOR SERVICES 137229.00- 86047.44- 62.7 51181.56- OTHER SOURCES OF REVENUE 5676.00- 6305.5<l- 111.1 629.5<l TOTAL REVENUE 152265.00- 92352.94- 60.7 59912.06- *******EXPENDlTURES******* GENERAL GOVERNHElfT ACTIVITIES: NON-DEPARTMENTAL 200479.00 74842.38 37.3 125636.62 ACTIVITY TOTAL 200479.00 74842.38 37.3 125636.62 ?1:8LIC SAFETY: Tk.~JISPORTATION : BE}.LTH & WELFARE: CULTURE & LEISURE SERVICES: COMKUHITY DEVElOPHElfT: CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 TOT A L EXPENDITURES 200479.00 74842.38 37.3 125636.62 EXCESS<REVENUE>EXPENDITURE 48214.00 17510.56- 36.3- 65724.56 TRANSFERS OUT TO OTHER FUNDS .00 .00 .00 EXCESS <REVENUE> EXPENDITURE 48214.00 17510.56~ 36.3- 65724.56 e e OOL104 THE CITY OF DUBLIN STATEHENT SHOWING PAGE 1 3/01/94 REVENUES VERSUS EXPENDITURE 15.02.34 FOR THE PERIOD 7/93 THROUGH 2/94 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 1611177 .00- 1533682.44- 95.2 77494.56~ TOTAL REVENUE 1611177 .00p 1533682.44- 95.2 77494.56~ *******EXPENDlTURES******* GENERAL GOVERHHElIT ACTIVITIES: NON-DEPARTMENTAL 1532876.00 1532852.53 100.0 23.47 CITY MANAGER .00 .00 .00 FINANCE DEPARTMENT 8250.00 976.20 11.8 7273.80 ACTIVITY TOTAL 1541126.00 1533828.73 99.5 , 7297.27 PUBLIC SAFETY: DISASTER PREAPREDNESS 1140.00 .00 1140.00 ACTIVITY TOTAL 1140.00 .00 1140.00 TRANSpORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATIOll 11800.00 6808.22 57.7 4991. 78 SENIOR CElITER 450.00 238.14 52.9 211.86 ACrrVITY TOTAL 12250.00 7046.36 57.5 5203.64 COlOOJ1{ITY DEVELDPKElIT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 1554516.00 1540875.09 99.1 13640.91 EXCESS<REVENOE>EXPENDITURES 56661.00~ 7192.65 12.7- 63853.65- EXCESS <REVENUE> EXPENDITURE 56661.00p 7192.65 12.7~ 63853.65~