The URL can be used to link to this page

Home My WebLink About4.03 FinRpt 1-94 . e CITY OF DUBLIN AGENDA STATEMENT CITY COUNCIL MEETING DATE: February 28, 1994 SUBJECT: roJIn Financial Report For The Month of January 1994. ~~ (Prepared by: Paul S. Rankin, Assistant City Manager) Statements for the Period 1. EXHIBITS ATTACHED: Balance Sheet and Income Ending January 31, 1993. ~ccePt and file the report. RECOMMENDATION: FINANCIAL: See report for monthly financial activity. DESCRIPTION: This item provides the monthly financial statement for the month of January 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. Compared to the prior year, Revenues are tracking slightly below the anticipated level. In Fiscal Year 1992/93 as of January the city had collected nearly 55.5% of the budgeted General Fund Revenues as compared to 53.2%% for the same period in Fiscal Year 1993/94. This is partially impacted by the fact that the 1993/94 annual Cable TV Franchise payment was not received until February. If an adjustment were made for this factor, the January 1993/94 General Fund Revenues would reflect 54.3% collected. EXPENDITURES Total expenditures as of January 31st for the General Fund, represent 46.4% authorized budget. Significant portions of the Public safety Budgets including Police Services have not been expended due to delays in receipt of billing statements from the provider of these services. This lag is expected to be eliminated in the upcoming month. Planning Department expenses are at approximately 47.8% of their authorized budget. Two significant factors have impacted expenses for this Department. First, the Department has had employee turnover, which resul ted in a vacant posi tion during the time required to complete the recruitment. The second impact has been a delay in receipt of the final billing for consultant services, related to finalizing the East Dublin General Plan Amendment and specific Plan. The Engineering Department Expenses in the General Fund are currently tracking at a faster pace than experienced in the previous year. As of January 31, 1994 the General Fund Engineering Department expense is 79.0% of its budget. This is primarily attributable to less activity on Capital Improvement Projects, which increases the proportion of expense incurred under General Engineering. The adopted Budget assumed that several major construction projects would be underway in Fiscal 'Year 1993/94. It now appears that the following projects will not be as far along and will be carried over into next Fiscal Year: Bike Path Project / Dougherty Road Improvements south of SP Railroad Right of Way / Dublin Blvd Improvements From Donlon To Village Parkway_ As a result of being carried over there will be limited staff inspection time incurred on these projects. Expenses in most of the other divisions tend to follow expected expenditure patterns. 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.7 COPIES TO: CITY CLERK FILE~ e CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE MONTH OF JANUARY 1994 Prepared by The Finance Department e e e BCLlO2 CITY OF DUBLIN PAGE 1 2/17/94 BALANCE SHEET 15.46.17 FOR THE PERIOD 7/93 THROUGH 1/94 GENERAL SPECIAL SPECIAL CAPITAL REVENUE REVENUE ASSESSHElfT IMPROVEMENT FUlIDS FUNDS FUNDS FUNDS ASSETS CASH 902343.42- 644236.65 470537.90 89133.11- CASH WITH FISCAL AGENT 121210.04 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST 18368948.63 RECEIVABLES: TAXES ACCOUNTS (NET) 191123.00 110795.71 INTEREST ASSESSMENTS RENTS NOTES DUE FROM OTHERS INVENTORY AT COST PREPAID ITEMS 6650.84 FIXED ASSETS AMOUNTS TO BE PROVIDED 2232500.00 TOTAL ASSETS 17664379.05 644236.65 2824247.94 21662.60 LIAB, FND BALI RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPHNT 34472.02~ DEPOSITS FOR AB1600 FEES 145648.46- DEPOSITS OTHERS 191458.66~ 3125.00- PAYABLES:ACCOUNTS 217855.67- INTEREST PAYROLL 7891.99- "I"': TO OTHERS 1155.00- .. ':>1' INSTRUMEHTS PAYABLE 2790000.00- TOTAL LIABILTIES 234977.67- 217855.67- 2793125.00- 145648.46- FUND BALANCES 17429401. 38- 426380.98- 31122.94- 123985.86 TOTAL FUND EQUITY 17429401.38- 426380.98- 31122.94- 123985.86 TOTAL LIAB,FlID BAL, RETD EARNS 17664379.05- 644236.65- 2824247.94- 21662.60- e e BGL102 CITY OF DUBLIN PAGE 1 2/17/94 BALANCE SHEET 15.47 . 54 FOR THE PERIOD 7/93 THROUGH 1/94 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG SERVICE FUNDS GROUP OF TERM DEBT FUND ACCOUNTS ACCOUNT GROUP ASSETS CASH 308248.28 3664.25- CASH WITH FISCAL AGENT 1726901.55 UNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST RECEIVABLES:TAXES ACCOUNTS (NET) INTEREST 46871.38 ASSESSMENTS RENTS NOTES "UE FROM OTHERS ,NVENTORY AT COST PREPAID ITEMS 119.60 FIXED ASSETS 165970.10 21623460.54 470014.62 AJ<<>UHTS TO BE PROVIDED 2548360.41 TOTAL ASSETS 474337.98 23393569.22 470014.62 2548360.41 LIAB, FND BAL, RETND EARNINGS DEPOSITS FOR PRIVATE DEVELPMlfT DEPOSITS OTHERS PAYABLES:ACCOUNTS 25603.30- INTEREST PAYROLL )UE TO OTHERS DEBT INSTRUMENTS PAYABLE 18602851.88~ 2548360.41- TOTAL LIABILITIES 18628455.18- 2548360.41- i ' ;;D BALANCE 306080.24- 344775.96 CONTRIBUTIONS 168257.74- 5109890.00- INVESTMENTS IN FIXED ASSETS 470014.62- RETAINED EARNINGS TOTAL FUND EQUITY 474337.98- 4765114.04- 470014.62- TOTAL LIAB,FHD BAL, RETD EARNS 474337.98- 23393569.22- 470014.62~ 2548360.41- e e BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/17/94 REVENUES VERSUS EXPENDITURE 15.02.50 FOR THE PERIOD 7/93 THROUGH 1/94 GENERAL REVENUE ' FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* PROPERTY TAXES 3839040.00- 2128220.44- 55.4 1710819.56- SALES TAX 5560000.00- 3132197.61~ 56.3 2427202.39- REAL PROPERTY TRANSFERS 73000.00- 30007.57- 41.1 42992.43- TRAlfSIElfT oca1PANCY TAX 86000.00- 67468.00- 78.5 18532.00- FRAHCHISE TAXES 505900.00- 57973.57- 11.5 447926.43- LICENSES & PERMITS 315600.00~ 215909.54- 57.5 159690.46- FINES & FORFEITURES 32000.00- 21688.33- 67.8 10311. 67- USES OF MONEY AND PROPERTY 881100.00- 382760.86- 43.4 498339.14- INTERNGOVERNMENTAL FROM STATE 964425.00- 482525.36- 50.0 481899.64- CHARGES FOR SERVICES 714533.00- 290314.12- 40.6 424218.88- OTDER SOURCES OF REVENUE 28100.00- 131578.45- 468.3 103478.45 TOTAL REVENUE 13059698.00- 6941243.85- 53.2 6118454.15- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 45625.00 .00 45625.00 CITY COUNCIL 1010 112438.00 54522.81 48.5 57915.19 CITY MANAGER 1020 258909.00 144826.79 55.9 114082.21 CITY ATTORNEY 1030 306170.00 127899.85 41.8 178270.15 ADMIN SERVICES 1040 414253.00 209305.47 50.5 204947.53 BUILDING MANAGEMENT 1050 334867.00 158827.04 47.4 176039.96 FACILITY RENTAL 1050-719 1532816.00 1444778.58 94.3 88037.42 INSURAlfCE COST CENTER 1060 169656.00 134987.01 79.6 34668.99 ELECTIONS COST CENTER 1070 12910.00 10548.15 81.7 2361. 85 ACTIVITY TOTAL 3187644.00 2285695.10 71.7 901948.30 PUBLIC SAFETY: POLICE 2010 3109012.00 134896.77 4.3 2974115.23 CROSSING GUARDS COST 2020 .00 .00 .00 ANIMAL CONTROL 2030 103100.00 .00 103100.00 TRAFFIC SIGNALS 2040 .00 .00 .00 DISASTER PREAPREDNESS 2050 37067.00 17783.46 48.0 19283.54 FIRE SERVICES JPA 2060 2733103.00 1743489.28 63.8 989613.72 ACTIVITY TOTAL 5982282.00 1896169.51 31.7 4086112.49 TRAlfSPORTATION: PUBLIC WORKS 3010 288715.00 149763.83 51.9 '138951.17 STREET MAINTENANCE 3020 165025.00 707.91 .4 164317.09 STREET TREE HAINTENANCE 3040 48960.00 22610.93 46.2 26349.07 STREET LANDSCAPE RAINT. 3050 160260.00 85361.73 53.3 74898.27 PARATRANSIT SERVICES 3060 .00 .00 .00 ACTIVITY TOTAL 662960.00 258444.40 39.0 404515.60 HEALTH & WELFARE: VECl'OR CONTROL 5010 .00 .00 .00 WASTE MANAGEMENT 5020 100.00 18.24 18.2 81.76 ACTIVITY TOTAL 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 193.47 1.8 10656.53 tit e GL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 2 2/17/94 REVENUES VERSUS EXPENDITURE 15.02.50 FOR THE ' PERIOD 7/93 THROOGH 1/94 GENERAL REVENUE FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIABCE PARK MAINTENANCE 8020 591955.00 302471.07 51.1 1289483.93 COHM\JNITY CABLE TV 8030 20279.00 9000.00 44.4 11279.00 RECREATION ADMIN. 8040 176453.00 97016.15 55.0 79436.85 PLAYGROUNDS 8045 80378.00 40837.07 50.8 39540.93 SHANNON CENTER 8050 125344.00 60744.84 48.5 64599.16 PRESCHOOL 8055 36966.00 18238.18 49.3 18727.82 TEENS PROGRAM 8060 34350.00 14575.86 42.4 19774.14 FIELD SCHEDULING 8065 105635.00 43206.15 40.9 62428.85 YOUTH SPORTS 8066 31043.00 15484.42 49.9 15558.58 SPECIAL EVEIlTS 8070 31070.00 10966.52 35.3 20103.48 SENIOR CENTER 8080 137449.00 53832.65 39.2 83616.35 RECREATION INSTRUCTION 8090 91764.00 39634.97 43.2 52129.03 AQUATICS 8100 199966.00 116149.06 58.1 83816.94 ACTIVITY TOTAL 1846502.00 912850.41 49.4 933651.59 COMMUNITY DEVELOPMENT: PLANNING 9010 560879.00 267979.49 47.8 292899.51 BUILDING SAFETY 9020 256241.00 128645.45 50.2 127595.55 ENGINEERING 9030 173970.00 137481. 52 79.0 36488.48 ECONOHIC DEVELOPMENT 9040 9610.00 5322.05 55.4 4287.95 ACTIVITY TOTAL 1000700.00 539428.51 53.9 461271. 49 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 94NH .00 .00 .00 I PARKS 95NN 20000.00 .00 20000.00 STREET CONSTRCjIMPROVMT 96HN 37000.00 12918.52 34.9 24081. 48 ACTIVITY TOTAL 57000.00 12918.52 22.7 44081. 48 TOT A L EXPENDITURES 12737188.00 5905525.29 46.4 6831662.71 , EXCESS <REVENUE>EXPENDITURES 322510.00~ 1035718. 56~ 321.1 713208.56 TRANSFERS IN FROM OTHER FUNDS .00 .00 .00 TRANSFERS OUT ro OTHER FUNDS .00 29875.68 29875.68- EXCESS <REVENUE> EXPENDITURE 322510.00- 1oo5842.88~ 311. 9 683332.88 e e BGL104 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/17/94 REVENUES VERSUS EXPENDITURE 15.07.49 FOR THE PERIOD 7/93 THROUGH 1/94 SPECIAL REVENUE FUHDS CURRENT PERIOD BuDGET ACTUAL PERCENT VARIANCE ********REVENUES******* SALES TAX 114000.00- 65999.69- 57.9 48000.31- FINES & FORFEITURES 26500.00- 22208.80- 83.8 4291.20- USES OF MONEY AND PROPERTY 16430.00- .00 16430.00- . IlfTERHGOVERlfMElfTAL FROM STATE 719440.00- 247666.77- 34.4 471773.23- INTERGOVERNMENTAL FROM COUNTY 38265.50- 21532.00- 56.3 16733.50- IlfTERGOVERHMElfTAL FROM FEDERAL 2147125.00- .00 2147125.00- CHARGES FOR SERVICES 716557.00- 382330.38- 53.4 334226.62- OTHER SOURCES OF REVENUE 5000.00- 8294.03~ 165.9 3294.03 TotAL REVENUE 3783317.50- 748031.67- 19.8 3035285.83- ~*****EXPENDITURES******* HfERAL GOVERNMENT ACTIVITIES: CTTY COUNCIL 2450.00 .00 2450.00 C1TY MANAGER .00 .00 .00 ACTIVITY TotAL 2450.00 .00 2450.00 PUBLIC SAFETY: POLICE 18170.00 2182.43 12.0 , 15987.57 TRAFFIC SIGNALS 93500.00 38313.69 41.0 55186.31 ACTIVITY TotAL 111670.00 40496.12 36.3 71173.88 TRAlfSPORTATION: STREET MAINTENANCE 177865.00 125311. 49 70.5 52553.51 STREET SWEEPING 67200 .00 35900.02 53.4 31299.98 STREET LANDSCAPE MAINTENANCE .00 .00 .00 ACrIVITY TOTAL 245065.00 161211.51 65.8 83853.49 HEALTH & WELFARE: WAf,'fE MANAGEMENT 572236.00 261919.20 45.8 310316.80 CUL'ftkE & LEISURE SERVICES: C()M}~;;NITY DEVELOPMENT: :.!/GINEERING 116497.00 22832.44 19.6 93664.56 ACTIVITY TOTAL 116497.00 22832.44 19.6 93664.56 CAPITAL IMPROVEMENT PROJECTS: GENERAL CIP PROJECTS .00 .00 .00 COMMUNITY IMPROVEMENTS 181223.50 34108.33 18.8 147115.17 PARKS 127971.00 73014.99 57.1 54956.01 STREET CONSTRUCTION/IMPROVMT 2334975.00 34020.99 1.5 2300954 .01 ACTIVITY TOTAL 2644169.50 141144.31 5.3 2503025.19 TOT A L EXPENDITURES 3692087.50 627603.58 17.0 3064483.92 EXCESS <REVENUE>EXPEHDITURE 91230.00- 120428.09- 132.0 29198.09 TRANSFERS IN FROM OTHER FUNDS .00 32728.18- 32728.18 TRANSFERS OUT TO otHER FUNDS .00 2852.50 2852.50- EXCESS <REVENUE> EXPENDITURE 91230.00- 150303.77- 164.8 59073.77 e e BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/17/94 REVENUES VERSUS EXPENDITURE 15.13.44 FOR THE PERIOD 7/93 THROUGH 1/94 SPECIAL ASSESSMENT FUNDS CURRENT PERIOD BUDGET ACTUAL 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- 8960.15- 86.2 1439.85- TOTAL REVENUE 562573.00- 274951. 29- 48.9 287621.71- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: HOH-DEPARTMENTAL 650731. 00 565406.00 86.9 85325.00 FINANCE DEPARTMENT .00 .00 .00 ACTIVITY TOTAL 650731. 00 565406.00 86.9 85325.00 PUHLIC SAFETY: TRFC SIGS/STREET LIGHTING 202300.00 91646.59 45.3 110653. 41 ACTIVITY TOTAL 202300.00 91646.59 4~.3 110653.41 TRANSPORTATION: PUBLIC WORKS 1701. 00 1599.20 94.0 101.80 STREET TREE MAINTENANCE 11350.00 2864.53 25.2 8485.47 STREET LAHDSCAPE MAINTENANCE 110085.00 54782.09 49.8 55302.91 ACTIVITY TOTAL 123136.00 59245.82 48.1 63890.18 HEALTH & WELFARE: CULTURE & LEISURE SERVICES: OOHHUNITY DEVELOPMENT: ENGINEERING 7550.00 3544.94 47.0 4005.06 ACTIVITY TOTAL 7550.00 3544.94 47.0 4005.06 CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS .00 4500.00 4500.00- STREET CONSTRUCTION/IMPROVMT .00 .00 .00 ACTIVITY TOTAL .00 4500.00 4500.00- TOT A L EXPEnDITURES 983717.00 724343.35 73.6 259373.65 EXCESS<REVENUE>EXPEHDITURE 421144.00 449392.06 106.7 28248.06. TRANSFERS IN FRO!( OTHER FUNDS .00 110995.44- 110995.44 TRANSFERS OUT TO OTHER FUNDS .00 110995.44 110995.44- EXCESS <REVENUE> EXPENDITURE 421144.00 449392.06 106.7 28248.06- e e BGLl04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/17/94 REVENUES VERSUS EXPENDITURE 15.25.16 FOR THE PERIOD 7/93 THROUGH 1/94, CAPITAL IMPROVEMENT FUND CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF HONEY AND PROPERTY 4340.00- .00 4340.00- OTHER SOURCES OF REVENUE 925445.00- .00 925445.00- TOTAL REVENUE 929785.00- .00 929785.00- *******EXPEHDITURES******* GENERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL .00 .00 .00 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: COMMUNITY IMPROVEMENTS 50000.00 .00 50000.00 STREET CONSTRUCTIOH/IMPROVMT 646136.00 75413.43 11.7 570722.57 ACTIVITY TOTAL 696136.00 75413.43 10.8 620722.57 TOT A L EXPENDITURES 696136.00 75413.43 10.8 620722.57 EXCESS<REVENUE>EXPENDITURE 233649.00- 75413.43 32.3- 309062.43- EXCESS <REVENUE> EXPENDITURE 233649.00- 75413.43 32.3- 309062.43- e e BGLl04 THE CITY OF DUBLIlI STATEMENT SHOWING PAGE 1 2/17/94 REVENUES VERSUS EXPENDITURE 15.17.24 FOR THE PERIOD 7/93 THROUGH 1/94 INTERNAL SERVICE FUllD CURRENT PERIOD BUDGET ACTUAL PERCENT I VARIANCE ********REVENUES******* USES OF HONEY AND PROPERTY 9360.00- .00 9360.00- CHARGES FOR SERVICES 137229.00- 75807.13- 55.2 61421. 87- OTHER SOURCES OF REVENUE 4500.00- 6275.50- 139.5 1775.50 TOTAL REVElfUE 151089.00- 82082.63- 54.3 69006.37- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: HOH-DEPARTMENTAL 188239.00 72903.39 38.7 115335.61 ACTIVITY TOTAL 188239.00 72903.39 38.7 115335.61 PUBLIC SAFETY: TRANSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: COHMUlfITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: GEHERAL CIP PROJECTS .00 .00 .00 ACTIVITY TOTAL .00 .00 .00 TOT A L EXPENDITURES 188239.00 72903.39 38.7 115335.61 EXCESS<REVEKUE>EXPENDITURE 37150.00 9179.24- 24.7- 46329.24 TRAlfSFERS OUT TO OTHER FUNDS .00 .00 .00 EXCESS <REVENUE> EXPENDITURE 37150.00 9179.24- 24.7- 46329.24 e ft BGLl 04 THE CITY OF DUBLIN STATEMENT SHOWING PAGE 1 2/17/94 REVENUES VERSUS EXPENDITURE 15.21.00 FOR THE PERIOD 7/93 THROUGH 1/94 ENTERPRISE FUNDS CURRENT PERIOD BUDGET ACTUAL PERCENT VARIANCE ********REVENUES******* USES OF MONEY AND PROPERTY 1611177.00- 1533682.44- 9~.2 77494.56~ TOTAL REVENUE 1611177.00- 1533682.44- 95.2 77494.56- *******EXPENDITURES******* GENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL 1532876.00 1532852.53 100.0 23.47 CITY WAGER .00 .00 .00 FINANCE DEPARTMENT 8250.00 688.75 8.3 7561. 25 ACTIVITY TOTAL 1541126.00 1533541. 28 99.5 7584.72 PUBLIC SAFETY: DISASTER PREAPREDNESS 1140.00 .00 1140.00 ACTIVITY TOTAL 1140.00 .00 1140.00 J ,:,AHSPORTATION: HEALTH & WELFARE: CULTURE & LEISURE SERVICES: RECREATION ADMINISTRATION 11800.00 3827.20 32.4 7972.80 SENIOR CENTER 450.00 238.14 52.9 211. 86 ACTIVITY TOTAL 12250.00 4065.34 33.2 8184.66 COMMUNITY DEVELOPMENT: CAPITAL IMPROVEMENT PROJECTS: TOT A L EXPENDITURES 1554516.00 1537606.62 98.9 16909.38 EXCESS<REVENUE>EXPENDITURES 56661.00- 3924.18 6.9- 60585.18- EXCESS <REVENUE> EXPENDITURE 56661.00- 3924.18 6.9- 60585.18-