Loading...
HomeMy WebLinkAbout4.02 Financial Report 03-31-1987 ' CLTY OF DMI N r tc F BATANM SHEET FOR ME PERIOD ROM M1RM 31, 1987 CIm UM 7RAFFTC RB04LE W-,`E1DRBT FEDERAL 9RANSl3RM IUM OFFICE OF PARK MASTER SIIM LQMSCAPE SAN RAM3N RD SAN RMtbl RD MIST CAPrDkL FT1Q•D INTERNAL DIM, GENERAL SAFETY SME GAS SHARDr. BIM GMT AID URBAN DElE]IZPtEM' TRAFFIC SAFETY DEDICATION ASSLSTANM LSGt r AS'SIl' ASSIl'DIM r, PLAN M REMn Eff= PR[JBM ASSETS SERVICE INFO INC. IMAL ALL FUND FUND TAX FUND FLM FIND FUND ACT RM- FUND FUND RM 83-1 RM 83-2 RkM ASW FUND HIND RAND FUND FUND FUND RkM RNS '$ ASSETS A Cash&Investments 8263117 35745 240580 48325 68700 401116 Due Frao Other Funds 478844 729952 31488 32852 353092 67131 110105 395714 58459 79 0829 18767705 478844 i Die From Oilier Govt's 5562 460498 466060 Accounts Receivable 710 318 1028 Assessments Receivable 701624 701624 Prepaid Itms. 13 8516 8629 s' Amt Provided- Tm Dbt 0 Fixed Assets 124482 88424 5650000 5362906 t c TCIPAL ASSETS 8748246 35745 MOM 48825 68700 861614 0 0 729952 0 31488 32822 1054716 67131 110105 395714 124482 155499 13580829 262867% n9",a TTAH9ZITES Deposits from Others 237156 3125 110105 350386 Payroll Taxes Payable p ;5 Allwnc-Depreciation 25115 25115 it Advance Due Othr Fnds 63309 63309 k` Due to Other Funds 460498 18346 478844 Deferred Reveries 577331 577331 r Accounts Payable 14047 14047 Bands&Ca-tif Pybl 857869 11968000 12825869 TOTAL LIAS[11TIES 2512003 0 0 0 0 460+98 0 0 0 0 1438325 110105 18346 88424 11968000 14334901 RAID 15= •` Fund Rive 5623254 3574 179416 486 520074 28820 32476 286969 67131 2221756 114482 25115 2918364 11457979 Fled Balance 2887239 32171 61482 48339 68700 401116 209378 2668 376 -%W -18474388 28510 -1305535 '493916 Fund Transfers -13450 13450 0 '. s 10fAI.RM BILIM 8497043 35745 21CB98 48325 68700 401116 0 0 729952 0 31483 32852 383609 67131 0 377368 121+482 67075 1612829 11951895 A'' Tt]!'A1,TTABUXIIES& 8748'146 35745 240893 48625 68700 861614 0 0 729952 0 31488 32852 1054716 67131 110105 395714 124482 155499 13580829 26286796 i 7 0 J CITY--OF DUBLIN SUMMARY REVENUE & EXPENDITURE REPORT ALL FUNDS CONSOLIDATED FOR THE PERIOD ENDED MARCH 31, 1987 REVENUES CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD Property Tax 524900 25773 415280 109620 .79 Other Taxes 5005000 428445 3498536 1506464 .70 Licenses & Permits 663300 68989 506632 156668 .76 Fines & Forfeitures 78500 59 60315 18185 .77 Special Assessments 287393 4099 96734 190659 .34 For Use of Money & Property 2732491 56455 1524120 1208371 .56 Intergovernmental Revenue 2754684 542008 1183116 1571568 .43 Charges for Services 593150 49371 395663 197487 .67 Other Revenue 692250 355 383232 309018 .55 TOTAL REVENUES 13331668 1175554 8063628 5268040 .60 EXPENDITURES General Government 101 City Council 71690 2466 37906 33784 .53 102 City Manager/Clerk 243000 19221 165062 77938 .68 103 Legal Services 86510 4916 50921 35589 .59 104 Finance 117855 11971 74368 43487 .63 105 Building Management 1503101 9781 759012 744089 .50 106 Insurance 143200 55323 87877 .39 107 Elections 4300 2620 1680 .61 108 Non-Departmental 24619 24619 Total General Government 2194275 ~48355 1145212 1049063 .52 Public Safety 201 Police Services 1584915 138057 842067 742848 .53 202 Crossing Guards 21800 3346 6549 15251 .30 203 Animal Control 50700 19112 ' 31588 .38 204 Traffic Signals & Safety Lighting 238700 15410 102134 136566 .43 20 5. Disaster Preparedness 23600 250 4452 19148 .19 Total Public Safety 1919715 157063 974314 945401 .51 Transportation 301 Public Works 108850 8551 87521 21329 .80 302 Street Maintenance 468560 15277 106068 362492 .23 303 Street Sweeping 57600 4051 32637 24963 .57 304 Street Tree Maintenance 74400 1431 14431 59969 .19 305 Street Landscape Maintenance 170550 9287 98047 72503 .57 306 Paratransit Service 28039 3697 17262 10777 .62 Total Transportation 907999 - 42294 355966 552033 - `-qQ Health & Welfare 501 Vector Control Service 6000 1166 4834 .19 Total Health & Welfare r 6000 �- ~-1166 - 4834 ^.19 Summary Revenue & Expenditure ..eport - Page 2 CURRENT YEAR TO PERCENT OF All Funds Consolidated . BUDGET MONTH DATE BALANCE BUDGET-YTD Culture & Leisure Services 701 Library Service 91984 35842 56142 .39 702 Parks & Recreation 369035 27113 186708 182327 .51 703 Park Maintenance 26300 26300 Total Culture & Leisure Services 487319 27113 222550 264769 .46 Community Development 901 Planning 409780 25279 214505 195275 .52 902 Building & Safety 287700 17095 146781 140919 :51 903 Engineering 417700 44421 353758 63942 .85 Total Community Development 1115180 86795 715044 400136 .64 Internal Service Fund Charges 13450 15388 32287 -18837 2.40 Dublin Info Inc Optg Exps 47212 19478 45959 1253 .97 TOTAL OPERATING EXPENDITURES 6691150 396486 3492498 3198652 .52 DEBT SERVICE EXPENDITURES 1538641 1538638 3 1.00 CAPITAL IMPROVEMENT EXPENDITURES Public Facilities Project 546000 278 547537 -1537 1.00 General Improvements 1682625 58174 337808 1344817 .20 Community Improvements 936981 6008 63219 873762 .07 Parks Improvements 1930045 19380 57978 1872067 .03 Street Improvements 3873276 233631 1532032 2341244 .40 TOTAL CAPITAL IMPROVEMENT EXPENDITURES 8968927 -317471 2538574 6430353 .28 TOTAL ALL EXPENDITURES 17198718 713957 7569710 9629008 .44 APPROPRIATIONS FROM RESERVES 3867050 -461597 -493918 4360968 -.13 CITY OF DUBLIN STATEMENT OF REVENUE & EXPh.._,TURES FOR THE PERIOD ENDING MARCH 31, 1987 REVENUE REPORT 1986-87 1986-87 Percent of Estimated Current Received Estimate GENERAL FUND (FUND # 1-1) Revenue Month Year to Date Received PROPERTY TAX 510.01 Current Year Secured 444000 15470 286351 .64 510.02 Current Year Unsecured 51500 -48 38409 .75 510.03 Prior Year Secured 19400 3113 12430 .64 510.04 Prior Year Unsecured 2000 621 .31 510.05 Supplemental Property Tax 8000 7238 15322 1.92 Total Property Tax 524900 25773 353133 .67 OTHER TAXES 515.00 Sales & Use Tax 4500000 421626 3287025 .73 517.00 Real Property Transfer Tax 58000 3238 47275 .82 518.00 Transient Occupancy Tax 160000 54474 .34 519.00 Electric Franchise Tax 121000 521.00 Gas Franchise Tax 38000 522.00 Garbage Franchise Tax 60000 3581 41752 .70 523.00 CATV Franchise Tax 68000 68010 1.00 Total Other Taxes 5005000 428445 3498536 -.70 LICENSES & PERMITS 530.01 Building Permits 651000 68494 500146 .77 530.02 Animal Licenses 8000 3952 .49 530.03 Bus Bench Ad Permits 300 612 2.04 530.04 Enchroachment Permits 4000 495 1842 .46 530.05 Other Permits 30 30.00 530.06 Recycling Transporter Permits 50 50.00 Total Licenses & Permits 663300 68989 506632 .76 FINES & FORFEITURES 532.02 Other Court Fines 14500 59 9724 .67 Total Fines & Forefeitures -14500 l 59 -- 9724 .67 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest 800000 52985 829011 1.04 550.03 Rents & Concessions 53790 3470 27298 .51 -- ------- --- Total Revenue from Use of Money & Property 853790 56455 856309 1.00 INTERGOVERNMENTAL REVENUES - STATE 555.01 Motor Vehicle in Lieu Tax 570000 44400 362948 .64 555.02 Trailer Coach in Lieu Tax 5000 2894 2894 .58 555.03 Cigarette Tax 97000 8506 67495 .70 555.04 Off Highway Vehicle in Lieu Tax 450 163 .36 555.05 Homeowner's Property Tax Relief 18000 9457 .53 555.06 SB 300 Allocation 46500 39166 .84 Total Intrgvrmmntl Rvnues - State 736950 55800 482123 .65 Revenue .Report - Page 2 Estimated C1 t Received Estimate Revenue Mu-n Year to Date Received CHARGES FOR SERVICES - 565.01 Zoning & Subdivision Fees 115000 890 20405 .18 565.02 Plan Checks & Inspection Fees 371000 -2161 234689 .63 565.04 Sales of Maps & Documents 5500 502 4567 .83 565.06 Special Police Dept. Services 6400 295 4695 .73 565.12 Park & Recreation Fees 78650 5181 45882 .58 565.15 Other Charges for Services 7500 6536 .87 565.16 Building Use Insurance 6200 300 3500 .56 565.18 Zone 7 Drainage Fees 2900 -18935 11249 3.88 565.19 Field Use Fees 2501 3342 334.00 Total Charges for Services 593150 -11427 334865 .56 OTHER REVENUES 570.02 Reimbursements 4750 570.03 Miscellaneous 1000 -17875 4557 4.56 570.05 Reimbursements - General 17875 17875 179.00 570.06 Reimbursement for Public Damage 4000 649 .16 570.07 Trash Bag Program 1000 355 3625 3.63 Total Other Revenue -10750 _^355 26706 2.48 TOTAL GENERAL FUND REVENUES 8402340 624449 6068028 .72 TRAFFIC SAFETY FUND (FUND # 2-5) FINES & FOEFEITURES 532.01 Vehicle Code Fines 64000 50591 .79 TOTAL TRAFFIC SAFETY FUND 64000 ` - 50591 .79 STATE GAS TAX FUND (FUND # 2-6) REVENUE FROM THE USE OF MONEY 550.01 Interest 12000 INTERGOVERNMENTAL REVENUES - STATE 555.07 State Gas Tax (2106) 85900 5053 57596 .67 555.08 State Gas Tax (2107) 169200 12339 115070 .68 555.09 State Gas Tax (2107.5) 4000 4000 1.00 Total State Gas Tax 259100 !17392 -176666 `.68 TOTAL STATE GAS TAX FUND 271100 17392 176666 .65 REVENUE SHARING FUND (FUND # 2-8) INTERGOVERNMENTAL-REVENUES - FEDERAL 559.01 Revenue Sharing 48339 48339 1.00 TOTAL REVENUE SHARING FUND 48339 ^M! 48339 1.00 COMMUNITY DVLPMNT BLOCK GRANT FUND (FUND # 2-9) INTERGOVERNMENTAL REVENUES - FEDERAL 559.02 Community Development Block Grant 68000 68700 68700 1.01 TOTAL COMMUNITY DVLPMNT BLOCK GRANT FUND `68000 68700 68700 1.01 Rewenue 'Report — Page 3 Percent of Estimated Current Received Estimate Revenue Month Year to Date Received FEDERAL AID URBAN FUND (FUND # 2-10) INTERGOVERNMENTAL REVENUES — FEDERAL 559.03 Federal Aid Urban Funds 1541000 400116 401116 .26 TOTAL FEDERAL AID URBAN FUND 1541000 400116 401116 .26 TRANSPORTATION DVLPMNT ACT FUND (FUND # 2-11) INTERGOVERNMENTAL REVENUES 555.10 Article 4.5 Funds (Paratransit) 12345 6172 .50 TOTAL TRANSPORTATION DEVELOPMENT ACT FUND 12345 6172 .50 OFFICE OF TRAFFIC SAFETY GRANT FUND (FUND # 2-12) INTERGOVERNMENTAL REVENUES — STATE 555.11 Office of Traffice Safety Grant TOTAL TRAFFICE SAFETY GRANT FUND 0 PARK DEDICATION FUND (FUND # 2-15) REVENUE FROM THE USE OF MONEY 550.01 Interest 15850 OTHER 570.04 Park Dedication Fees 191400 209878 1.10 570.05 Shannon Lease Subsidy TOTAL PARK DEDICATION FUND 207250 —209878 1.01 DISASTER ASSISTANCE FUND (FUND # 2-17) 559.04 Intergvtl Revenue—Flood Grant STREET LIGHTING ASSESSMENT DISTR 83-1 (FUND # 2-18) 534.03 Special Benefit Assessments 3805 82239 .59 550.01 Interest TOTAL STREET LIGHTING ASSMNT DISTR 83-1 139000 3805 —82239 .59 LANDSCAPE ASSESSMENT DISTRICT 83-2 (FUND # 2-19) 534.03 Special Benefit Assessments— ~--�-24100 294 14495 .60 550.01 Interest TOTAL LANDSCAPE ASSMNT DISTR 83-2 24100 294 — 14495 —.60 SAN RAMON RD SPECIFIC PLAN ASSMT DISTR (FUND # 5-20) 510.01 Property Tax—Current Year 62147 621.00 534.03 Special Benefit Assessments 124293 550.01 Interest 27000 TOTAL SAN RAMON RD SPECIFIC PLN ASSMT FUND 151293 -- —62147 .41 Revenue Report - Page 4 Percent of Estimated Current Received Estimate Revenue Month Year to Date Received DUBLIN INFORMATION, INC. FUND (FUND # 6-1)-_--~--! 550.01 Interest 444000 550.03 Rents & Concessions 1379851 667811 .48 TOTAL DUBLIN INFORMATION, INC. FUND 1823851 667811 .37 STATE PARK BOND ACT FUND INTERGOVERNMENTAL REVENUES - STATE 555.12 Roberti-Z'Berg Allocation 15300 TOTAL STATE PARK BOND ACT FUND 15300 SENIOR CITIZENS BOND ACT FUND 553.13 Senior Citizens Bond Act Grant 73650 TOTAL SENIOR CITIZENS BOND ACT FUND 73650 V CAPITAL PROJECTS FUND (FUND # 3-XXX) OTHER REVENUES 570.02 Non-Government Contributions 490100 146648 .30 TOTAL CAPITAL PROJECTS FUND 490100 !! 146648 .30 INTERNAL SERVICE FUND (FUND # 10-30) CHARGES FOR SERVICES 565.17 Equipment Usage Charges 60798 60798 608.00 TOTAL INTERNAL SERVICE FUND - 60798 60798 608.00 TOTAL REVENUE - ALL FUNDS 13331668 1175554 8063628 .60 -------- ------_ ________ BUDGET TRANSFERS IN To Operating Fund 832500 To Dublin Information, Inc. Fund 1379851 To Capital Projects Fund 5508000 To Internal Service Fund 13450 13450 135.00 TOTAL BUDGET TRANSFERS IN 7720351 13450 W13450 .00 CITY OF DUBLIN ' STATEMENT OF REVENUE AND EXl- .ITURES FOR THE PERIOD ENDING MARCH 31, 1987 EXPENDITURE REPORT GENERAL FUND CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD GENERAL GOVERNMENT 101 CITY COUNCIL 701 Personal Services .02 Salaries, Part Time 18000 1386 13167 4833 .73 .04 Retirement 1170 77 782 388 .67 .05 Group Insurance 13560 661 5915 7645 .44 .06 Worker's Compensation 100 100 - -- Total Personal Services 32830 2124 . 19864 12966 .61 705 Services & Supplies .01 Office Supplies 250 - 5 86 X64 .34 .02 Postage 100 2 81 19 .81 .05 Professional Services 4400 3500 900 .80 .08 Advertising 1500 771 729 .51 .09 Printing 250 -178 169 81 .68 .14 Books, Publs & Subscp 200 200 .15 Memberships & Dues 5600 1263 4337 .23 .17 Trvl, Confs & Meetings 9400 388 5681 3719 .60 .18 Training 6500 6500 .19 Community Promotion 9960 125 6448 3512 .65 Total Services & Supplies 38160 342 17999 20161 -.47 757 Capital Outlay 700 43 657 .06 TOTAL CITY COUNCIL 71690 2466 37906 33784 .53 102 CITY MANAGER / CLERK 701 Personal Services .01 Salaries, Full Time 152500 11802 108183 44317 .71 .02 Salaries, Part Time 2000 1900 100 .95 .03 Salaries, Overtime 440 80 694 -254 1.58 .04 Retirement 14050 1010 9587 4463 .68 .05 Group Insurance 15600 700 7619 7981 .49 .06 Worker's Compensation 3530 2815 715 .80 .08 Medicare FICA 275 22 145 130 .53 Total Personal Services -188395 --13614 130943 57452 .70 705 Services & Supplies .01 Office Supplies 3150 110 2596 554 .82 .02 Postage 2900 74 1831 1069 .63 .03 Reproduction Svcs 2100 72 1383 717 .66 .08 Advertising 1800 541 1259 .30 .09 Printing 12500 10914 1586 .87 .12 Repairs & Maintenance 200 191 9 .96 .14 Books, Publs & Subscps 1700 22 1650 50 .97 .15 Memberships & Dues 550 80 526 24 .96 .16 Auto Mileage & Allow. 5000 352 3566 1434 .71 Expenditure Report - Page 2 CURRENT AR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD CITY MANAGER / CLERK - Services & Supplies (Continued) .17 Trvl, Confs & Meetings 5700 408 3285 2415 .58 .18 Training 2975 263 2103 872 .71 .25 Intrnl Srvc Fund Chrgs 5830 3960 3960 1870 .68 Total Services & Supplies 44405 5341 32546 11859 .73 722 Contract Services 7500 7500 757 Capital Outlay-Mchnry & Eqp 2700 266 1573 1127 .58 TOTAL CITY MANAGER / CLERK 243000 19221 165062 77938 .68 103 LEGAL SERVICES 701 Personal Services .04 Retirement 4300 47 1222 3078 .28 .05 Group Insurance 2710 - 2710 Total Personal Services 7010 47 1222 5788 .17 705 Services & Supplies .05 Professional Services 79500 4869 49699 29801 .63 Total Services & Supplies 79500 4869 49699 29801 .63 TOTAL LEGAL SERVICES 86510 4916 50921 35589 .59 104 FINANCE 701 Personal Services .01 Salaries, Full Time 56240 5487 37552 18688 .67 .03 Salaries, Overtime 500 9 120 380 .24 .04 Retirement 4520 330 2289 2231 .51 .05 Group Insurance 8245 226 233.4 5911 .28 .06 Worker's Compensation 1450 1450 .08 Medicare FICA 600 53 302 298 .50 Total Personal Services 71555 6105 42597 28958 .60 705 Services & Supplies .01 Office Supplies 1250 87 1060 190. .85 .05 Professional Services 33300 4506 24215 9085 .73 .09 Printing & Binding 1300 142 1173 127 .90 .12 Repairs & Maintenance 220 220 .14 Books Publs & Subscrps 770 426 861 -91 1.12 .15 Memberships & Dues 400 50 75 325 .19 .16 Auto Mileage & Allwnc 2300 186 1141 1159 .50 .17 Trvl, Confs & Meetings 2100 4 2096 .18 Training 400 17 383 .04 .20 Miscellaneous 260 19 163 97 .63 .25 Intrnl Srvc Fnd Chrgs 600 450 450 150 .75 Total Services & Supplies 42900 5866 29159 13741 .68 722 Contract Services 1400 1399 1 1.00 757 Capital Outlay-Mchnry & Eqp 2000 1213 787 .61 TOTAL FINANCE 117855 11971 74368 43487 .63 Expenditure Report - Page 3 CURRENT R TO PERCENT OF BUDGET MONTH -ATE BALANCE BUDGET-YTD 105 BUILDING MANAGEMENT 705 Services & Supplies .01 Office Supplies 250 15 226- 24 .90 .04 Operating Supplies 300 16 284 .05 .07 Communication 25500 2007 18398 7102 .72 .13 Rentals 1469651 7465 735351 734300 .50 .21 Utilities 1200 . 22 246 954 .21 Total Services & Supplies 1496901 9509 754237 742664 .50 722 Contract Services 2200 1814 386 .82 Capital Outlay 755 Improvements Othr Than Bldgs 699 699 0 1.00 757 Machinery & Equipment 3301 272 2262 1039 .69 Total Capital Outlay 4000 272 2961 1039 .74 TOTAL BUILDING MANAGEMENT 1503101 9781 759012 744089 .50 106 INSURANCE 705 Services & Supplies .05 Professional Services 200 192 8 .96 :10 Insurance Premiums 93200 55131 38069 .59 .11 Insurance Claims Expns 49800 49800 Total Services & Supplies 143200 55323 87877 .39 TOTAL INSURANCE 143200 55323 87877 .39 107 ELECTIONS 705 .01 Srvc & Supp-Ofc Supp 705 .02 Postage 950 847 .89 705 .08 Srvc & Supp-Advertising 220 12 208 .05 705 .09 Srvc & Supp-Prntng/Bnd 850 329 521 .39 722 Cntrct Svc-Registrar of Vtrs 2280 1432 848 .63 TOTAL ELECTIONS 4300 2620 1680 .61 108 NON-DEPARTMENTAL 705 Contingent Reserve 24619 24619 TOTAL NON-DEPARTMENTAL 24619 24619 TOTAL GENERAL GOVERNMENT 2194275 48355 1145212 1049063 .52 PUBLIC SAFETY 201 POLICE SERVICES 701 Personal Services .02 Salaries, Part Time 12400 871 7297 5103 .59 .06 Worker's Compensation 350 350 1 Total Personal Services 12750 871 7297 5453 .57 Expenditure Report - Page 4 CURRENT ,AR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD 201 POLICE SERVICES (CONTINUED) 705 Services & Supplies .01 Office Supplies 2500 119 1837 663 .73 .02 Postage 900 38 655 245 .73 .03 Reproduction Supplies 1750 56 1102 648 .63 .04 Operating Supplies 14350 114 1774 12576 .12 .09 Printing & Binding 2000 49 660 1340 .33 .12 Repairs & Maintenance 2950 110 705 2245 .24 .13 Rentals 150 62 62 88 .41 .14 Books, Publs & Subscrps 100 27 70 30 .70 .15 Memberships & Dues 100 80 20 .80 .16 Auto Mileage & Allownc 600 32 210 390 .35 .17 Trvl, Confs & Meetings 1500 384 1404 96 .94 .18 Training Expense 400 94 99 301 .25 .19 Community Promotion 200 5 195 .03 .25 Intrnl Svc Chg-Ofc Eqp 4200 =11210 3150 1050 .75 .27 Intrnl Svc Chg-Vehicles 111500 45948 45948 65552 .41 -- -- Total Services & Supplies 143200 35823 57761 - 85439 x.40 710 Contract Services .01 Personnel Costs 1139940 87881 621647 518293 .55 .02 Vehicle Costs 26000 1277 25409 591 .98 .03 Indirect Costs 73240 12205 48821 24419 .67 .04 Dispatch 115000 54993 60007 .48 .05 Admin. - Financial Svcs 20605 10302 10303 .50 .06 Services & Supplies 50180 12786 37394 .25 Total Contract Services 1424965 101363 773958 651007 .54 757 Capital Outlay-Mchnry & Eqp 4000 3051 949 .76 TOTAL POLICE SERVICES 1584915 138057 842067 742848 .53 202 CROSSING GUARDS 705 .04 Srvc & Supp-Optg Supp 712 .16 Contract Services 21800 3346 6549 15251 .30 TOTAL CROSSING GUARDS - 21800 -3346 -6549 - 15251 1.30 203 ANIMAL CONTROL 716 Contract Services .01 Shelter Services 10700 5117 5583 .48 .02 Field Service 40000 13995 26005 .35 Total Contract Services 50700 ,-� - 19112 31588 ~.38 TOTAL ANIMAL CONTROL 50700 19112 31588 .38 204 TRAFFIC SIGNALS & SAFETY LIGHTING 705 .21 Srvc & Supp-Utilities 12600 8243 4357 .65 712 .01 Contract Services 25600 4484 3517 22083 .14 757 Cptl Outlay-Mchnry & Eq 4000 4000 - TOTAL TRAFFIC SGNLS-SFTY LIGHTING -42200 M-4484 11760 30440 - .28 Expenditure Report - Page 5 CURRENT ,R TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD 205 DISASTER PREPAREDNESS 705 Services & Supplies .09 Printing & .Binding 500 500 .14 Books, Publ & Subscrps 200 200 .15 Memberships & Dues 200 200 .18 Training 700 700 Total Services & Supplies 1600 1600 722 Contract Services 15000 250 4452 10548 .30 757 Capital Outlay-Mchnry & Eqp 7000 7000 TOTAL DISASTER PREPAREDNESS 23600 250 4452 19148 .19 TOTAL PUBLIC SAFETY 1723215 146137 883940 839275 .51 TRANSPORTATION 301 PUBLIC WORKS ADMINISTRATION 701 Personal Services .01 Salaries, Full Time 22200 1689 15628 6572 .70 .03 Salaries, Overtime 100 103 291 -191 2.91 .04 Retirement 1400 95 931 469 .67 .05 Group Insurance 4020 89 1257 2763 .31 .06 Worker's Compensation 120 120 Total Personal Services 27840 1976 18107 9733 .65 705 Services & Supplies .01 Office Supplies 800 67 715 85 .89 .02 Postage 505 10 345 160 .68 .03 Reporduction Services 325 12 225 100 .69 .12 Repairs & Maintenance .14 Books 20 18 18 2 .90 .16 Auto Allwnc & Mileage 50 50 .18 Training 630 31 599 .05 .25 Intrnl Svc Fund Chrgs 2830 1710 1710 1120 .60 Total Services & Supplies 5160 1817 3044 2116 .59 712 .17 Contract Services 73200 4758 66204 6996 .90 757 Capital Outlay-Mchnry & Eqp 2650 166 2484 .06 TOTAL PUBLIC WORKS ADMINISTRATION 108850 8551 87521 21329 .80 302 STREET MAINTENANCE 705 .04 Srvc & Supp-Optg Supp 2500 405 2095 .16 712 .02 Cntr Svc-St. Repair 173500 7752 22887 150613 .13 712 .06 Cntr Svc-Sign Rpr/Instl 2000 229 1771 .11 755 Imprvmt Othr Thn Bldgs 10410 10410 TOTAL STREET MAINTENANCE 188410 7752 23521 164889 .12 304 STREET TREE MAINTENANCE 705 .21 Svc & Supp-Utilities 712 .09 Cntr Svc-Public Works 74400 1431 14431 59969 .19 TOTAL STREET TREE MAINTENANCE 74400 1431 14431 ^59969 ~.19 Expenditure Report - Page 6 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD 305 STREET LANDSCAPE MAINTENANCE 705 .21 Svc & Supp-Utilities 11100 62 4956 6144 .45 712 .15 Cntr Svc-Public Works 110350 8350 74669 35681 .68 718 .02 Cntr Svc-Litter Pickup 7000 479 5624 1376 .80 757 Cptl Outlay-Mchnry/Eqp 4000 4000 TOTAL STREET LANDSCAPE MAINTENANC 132450 8891 85249 47201 .64 306 PARATRANSIT SERVICE 714 Cntrct Svc-SRV Community Ctr 15694 3697 11090 4604 .71 TOTAL PARATRANSIT SERVICE 15694 3697 11090 4604 .71 TOTAL TRANSPORTATION 519804 30322 221812 297992 .43 HEALTH & WELFARE SERVICES 501 VECTOR CONTROL SERVICES 722 Contract Services 6000 1166 4834 .19 TOTAL VECTOR CONTROL SERVICES 6000 1166 4834 .19 CULTURE & LEISURE SERVICES 701 LIBRARY SERVICE 722 Cntrct Svcs - County Library 91984 35842 56142 .39 TOTAL LIBRARY SERVICE 91984 35842 56142 .39 702 RECREATION 701 Personal Services .01 Salaries, Full Time 84000 8228 67024 16976 .80 .02 Salaries, Part Time 86760 4247 34096 52664 .39 .03 Salaries, Overtime . 500 46 204 296 .41 .04 Retirement 7400 471 4001 3399 .54 .05 Group Insurance 19530 609 6391 13139 .33 .06 Worker's Compensation 6460 2320 4140 .36 .07 Unemployment Ins Claims .08 Medicare FICA 1245 54 408 837 Total Personal Services 205895 13655 114444 91451 .56 705 Services & Supplies .01 Office Supplies 2400 173 1556 844 .65 .02 Postage 4720 728 3746 974 .79 .03 Reproduction Services 2400 25 1314 1086 .55 .04 Program Materials 14630 144 4654 9976 .32 .07 Communications 4600 437 1269 3331 .28 .08 Advertising 550 124 317 233 .58 .09 Printing 13800 2684 9458 4342 .69 .12 Repairs & Maintenance 1700 71 1629 .04 .13 Rentals 7380 111 4086 3294 .55 .14 Books, Pubis & Subscrip 200 25 157 43 .79 Expenditure Report - Page 7 CURRENT %R TO PERCENT OF BUDGET MONTH ATE BALANCE BUDGET YTD 702 RECREATION.- Services & Supplies (Continued) .15 Memberships & Dues 360 360 0 1.00 .16 Auto Mileage & Allow. 3790 313 •2256 1534 .60 .17 Trvl-Confrncs-Meetings 3870 290 1514 2356 .39 .18 Training Expense 1000 1000 .19 Community Promotion 8000 555 4435 3565 .55 .21 Utilities 20700 1449 6126 14574 .30 .25 Intrnl Svc Fund Chrgs 2160 1620 1620 540 .75 Total Services & Supplies 92260 8678 ~42939 49321 �.47 725 Contract Services .01 Recreation Instruction 34900 3427 17538 17362 .50 .02 Shannon Services 19560 1353 10578 8982 .54 .03 Senior Center Services 9300 9300 Total Contract Services 63760. 4780 28116 35644 .44 757 Cptl Outlay-Mchnry & Eqp 7120 1209 5911 .17 TOTAL RECREATION DEPT. 369035 27113 186708 182327 .51 703 PARK MAINTENANCE 705 .21 Srvc & Supp-Utilities 5000 5000 722 Contract Services 21300 21300 TOTAL PARK MAINTENANCE 26300 26300 TOTAL CULTURE & LEISURE SERVICES 487319 27113 222550 264769 .46 COMMUNITY DEVELOPMENT 901 PLANNING 701 Personal Services .01 Salaries, Full Time 172900 11188 105673 67227 .61 .02 Salaries, Part Time 3880 3880 .03 Salaries, Overtime 2300 173 14.01 899 .61 .04 Retirement 11260 630 6291 4969 .56 .05 Group Insurance 20240 835 8566 11674 .42 .06 Worker's Compensation 4510 4510 Total Personal Services 215090 12826 121931 93159 .57 705 Services & Supplies .01 Office Supplies 4150 176 2671 1479 .64 .02 Postage 3200 78 2706 494 .85 .03 Reproduction Supplies 3500 65 1282 2218 .37 .05 Professional Services 149980 7948 71060 78920 .47 .08 Advertising 1850 285 1525 325 .82 .09 Printing & Binding 7600 5 1486 6114 .20 .12 Repairs & Maintenance 1000 425 575 .43 .14 Books, Publs & Subscrps 1200 25 253 947 .21 .15 Memberships & Dues 340 15 332 8 .98 .16 Auto Mileage & Allow. 2530 175 1706 824 .67 .17 Trvl, Confs & Meetings 5700 693 3339 2361 .59 Expenditure Report - Page 8 CURRENT 7AR TO PERCENT OF BUDGET MONTH )ATE BALANCE BUDGET YTD 901 PLANNING - Services & Supplies (Continued) .18 Training 1200 422 778 .35 .24 Annexations/Filing Fees 4100 2270 1830 .55 .25 Intrnl Svc Fund Chrgs 4550 2988 2988 1562 .66 Total Services & Supplies 190900 12453 92465 -`98435 �.48 757 Capital Outlay-Mchnry & Eqp 3790 109 3681 .03 TOTAL PLANNING 409780 25279 214505 195275 .52 902 BUILDING & SAFETY 701 Personal Services .01 Salaries, Full Time 26000 1938 17862 8138 .69 .03 Salaries, Overtime 700 307 393 .44 .04 Retirement 1620 109 1063 557 .66 .05 Group Insurance 4040 85 1688 2352 .42 .06 Worker's Compensation 140 - 140 Total Personal Services 32500 2132 20920 11580 .64 705 Services & Supplies .01 Office Supplies 1000 102 851 149 .85 .02 Postage 400 8 268 132 .67 .03 Reproduction Supplies 300 2 45 255 .15 .09 Printing & Binding 1600 103 1233 367 .77 .12 Repairs .14 Books, Publs & Subscps 350 36 314 .10 .15 Memberships & Dues 250 235 15 .94 .16 Auto Mileage & Allow. 50 50 .18 Training Expense 750 403 347 .54 .25 Intrnl Svc Fund Chrgs 1850 972 972 878 .53 Total Services & Supplies 6550 1187 4043 2507 ^.62 722 Contract Services 247200 13597 121639 125561 .49 757 Cptl Outlay-Mchnry & Eqp 1450 179 179 1271 .12 TOTAL BUILDING & SAFETY 287700 17095 146781 140919 .51 903 ENGINEERING 705 Services & Supplies .01 Office Supplies 600 50 394 206 .66 .02 Postage 700 10 377 323 .54 .03 Reproduction .09 Printing & Binding 1900 488 1661 239 .87 Total Services & Supplies 3200 548 2432 -` 768 �.76 722 Contract Services 400000 43586 340396 59604 .85 757 Cptl Outlay-Mchnry & Eqp 2000 287 1994 6 1.00 TOTAL ENGINEERING 405200 44421 344822 60378 .85 TOTAL COMMUNITY DEVELOPMENT 1102680 86795 706108 396572 .64 TOTAL- GENERAL FUND 6033293 338722 3180788 2852505 .53 Expenditure Report - pr 9 TRAFFIC SAFETY FUND (FUND # 2_5) BUDGET M r YEAR TO PERCEN' MO'V1H DATE BALANCE BUDGET- '. � . 204 TRAFFIC SIGNALS & STREET LIGHTING 705 .21 Srvc & Su pp-Utilities 21400 2239 10172 712 .O1 Cntrct Svc-Trfc Signls 42600 11228 .48 112 8247 34353 TOT•AZ TRArFIG-31CNALS-&_, .19 ! STREET LG 64000 2351 TOTAL TRAFFIC SAFETY FUND 18419 45581 .29 STATE GAS TAX FUND 64000 2351 18419 _ 45581 i (FUND # 2-6) -�— — - - .29 TRANSPORTATION 302 STREET MAINTENANCE 712 Contract Services 902 Street Repair .03 Drainage & Maintenance 110000 _ 22500 110000 .04 Storm Patrol & Clean-up 13150 351 17389 .05 Curbs Gutters Sidewalks 303 5111 .77 •04 Si-n R^r & Tns'al� 24000 133 709 12441 .05 .07 Striping at'°n 23500 9548 14452 .40 . .08 Guardrail Repair pairng 40000 3 2 14594 8906 .10 Weed Control 2000 184 20183 19817 62 2000 •50 .13 Bike Path Maintenance 3000 1836 7000 80 1164 .61 Total Contract Services 2187 4813 .31 245150 4263 ��- ---- 755 Imprvmts Othr Thn Bldgs 66446 178704 .27 35000 3262 16101 18899 .46 .i TOTAL STREET MAINTENANCE 280150 7525 303 STREET SWEEPING 82547 197603 .29 718 Contract Services .01 Street Sweeping 57600 4051 32637 24963 Total Contract Services - --� - -"- ------- —_57 57600 TOTAL STREET SWEEPING 4051 32637 24963 .57 TOTAL TRANSPORTATION 57600 4051 32637 24963_ 337750 .57 COMMUNITY DEVELOPMENT 11576 115184 222566 903 ENGINEERING-TRAFFIC .34 722 Contract Services TOTAL ENGINEERING 4000 4000 TOTAL STATE GAS TAX FUND 4000 4000 TRANSPORTATION DEVELOPMENT ACT FUND 341750 11576 115184 226566 306 PARATRANSIT SERVICE (FUND # 2-11) .34 714 Cntrct Svc-SRV Community Ctr 12345 TOTAL TRANSPORTATION DVLPMNT ACT.FUND 6172 6173 .50 12345 6172 6173 .50 Expenditure Report - Page 10 CURRENT °EAR TO PERCENT OF BUDGET MONTH ATE BALANCE BUDGET-YTD ST. LIGHTING ASSESSMENT DISTRICT 83-1 FUND (FUND # 2-18) 204 SAFETY LIGHTING 705 .21 Srvc & Supp-Utilities 132500 8575 71955 60545 .54 903 ENGINEERING SERVICES 722 Contract Services 6500 7616 -1116 1.17 TOTAL ST. LIGHTING ASSMNT DISTR. FUND 139000 8575 79571 59429 .57 LANDSCAPE DISTRICT ASSESSMENT FUND 83-2 (FUND # 2-19) 305 STREET LANDSCAPE MAINTENANCE 705 .21 Srvc & Supp-Utilities 11600 26 4358 7242 .38 712 .15 Cntrct Svc-Public Works 26500 370 8440 18060 .32 TOTAL STREET LANDSCAPE MAINTENANC 38100 396 12798 25302 1.34 703 PARK MAINTENANCE 722 Contract Services 903 ENGINEERING SERVICES - 722 Contract Services 2000. 1320 680 .66 TOTAL LANDSCAPE DISTR. ASSMNT FUND 83-2 40100 396 14118 25982 .35 INTERNAL SERVICE FUND (FUND # 10-30) 705 Services & Supplies .01 Office Supplies 1000 1000 .04 Operating Supplies 32031 8686 10992 21039 .34 .10 Insurance Premium 10800 10800 .12 Repairs & Maintenance 22015 6702 16951 5064 .77 Total Services & Supplies 65846 15388 27943 --37903 -~.42 757 Machinery & Equipment 15935 4344 11591 .27 764 Depreciation & Replacement 63969 63969 Internal Service Credits -132300 -132300 TOTAL INTERNAL SERVICE FUND 13450 15388 32287 -18837 2.40 TOTAL OPERATING FUND EXPENDITURES 6643938 377008 3446539 3197399 .52 DEBT SERVICE & OPERATING FUND EXPENDITURES SAN RAMON RD SPECIFIC PLAN ASSMT DISTR FUND (FUND # 5-20) 730 Debt Service .01 Principal Payments 87869 87869 0 1.00 .02 Interest Payments 70921 70918 3 1.00 TOTAL SAN RAMON RD ASSMT DSTR FUND 158790 -^ -158787 -�- 3 1.00 DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 705 .24 Filing Fees 3 -3 3.00 705 .26 Property Tax .41467 19478 40211 1256 .97 722 Contract Services 5745 5745 0 1.00 Subtotal - Operating Expenditures 47212 19478 45959 1253 .97 Expenditure Report - Page 11 CURRENT YEAR TO PERCENT OF BUDGET MONTH kTE BALANCE BUDGET-YTD 'DUBLIN INFORMATION, INC. FUND ,%;ONTINUED) 730 .01 Debt Service-Principal 173000 173000 0 1.00 730 .02 Debt Service-Interest 1206851 1206851 0 1.00 Subtotal - Debt Srvc. Expenditures 1379851 1379851 0 1.00 TOTAL DUBLIN INFORMATION, INC. FUND 1427063 19478 1425810 1253 1.00 TOTAL DEBT SRVC & OPERATING EXPENDITURES 1585853 19478 1584597 1256 1.00 CAPITAL IMPROVEMENTS EXPENDITURES DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 751 Land 755 .01 Sierra Ct Sthrn Extnsn 546000 278 547537 -1537 1.00 TOTAL DUBLIN INFO INC. CAPTL EXPS 546000 278 547537 -1537 1.00 CAPTIAL PROJECTS FUNDS (FUND # 3-XXXX) - General Improvements 0024 Civic Center 1541675 58174 207355 1334320 .13 0030 Word Processing 16000 15999 1 1.00 0049 DSRSD Services Study 8800 8796 4 1.00 0066 Police Vehicles 103550 105658 -2108 1.02 0074 Fuel Effcnt Trfc Sgnl Study 12600 12600 ~ - Total General Improvements 1682625 58174 337808 1344817 ^.20 Community Improvements . 0020 Sewage Facility Expansion 800000 800000 0025 Sidewlk Sfty/Bus Stop Pads 57200 2103 11576 45624 .20 0032 Downtown Improvement Plan 44550 3905 44011 539 .99 0033 Dublin Blvd Undergrounding 5231 5231 0 1.00 0067 Doherty Rd Fencing-Est Side 20000 1425 18575 .07 0068 Major Artrl Fence Replacemnt 10000 976 9024 .10 Total Community Improvements 936981 6008 63219 873762 .07 Park Improvments 0035 Kolb Park 817300 668 2212 815088 0060 Park Development Plan 17000 2293 15296 1704 .90 0061 Shannon Park Renovation 456130 456130 0063 Dolan Park 407020 1199 5251 401769 .01 0065 Amador Lakes Mini Park 72595 522 2568 70027 .04 0069 Senior Citizens Center 102000 102000 0070 Doherty Hills Park 58000 14698 32651 25349 .56 Total Park Improvements 1930045 19380 57978 1872067 �.03 Street Improvements 0029 Annual Street Overlay 111769 6495 17312 94457 .15 0036 San Ramon Rd Phase II 1892100 39351 393503 1498597 .21 0037 Sn Rmn Rd-III/Hillsd Lndscp 32000 250 37083 -5083 1.16 0038 Trfc Sgt-Alcosta/San Rmn Rd 43507 43599 -92 1.00 0039 Trfc Sgl-Dbin Blvd/Sierra 218000 229 145634 72366 .67 0042 Traffic Signal Interconnect 150000 3574 37825 . 112175 .25 'Expenditure Report - Page 12 CURRENT .cAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD CAPITAL PROJECTS - STREET IMPROVEMENTS (CONTIN) 0044 Lndscp Vllg Pkwy to Kimball 44200 37392 6808 .85 0053 Arroyo Vista Sidewalks 5900 5788 112 .98 0055 Dghrty Rd Wdng at SP Rlyd 129300 123497 130313 -1013 1.01 0056 Rehb/Lndscp AVB-VP to Dghrty 1009500 60204 599247 . 410253 .59 0059 San Ramon Rd Phase IV 47000 44017 2983 .94 0071 Dbin Blvd NW Frntg at Clark 161000 11615 149385 .07 0072 Trfc Sgnls & St Light Addtns 29000 31 28704 296 .99 Total Street Improvements 3873276 233631 1532032 2341244 .40 TOTAL CAPITAL PROJECTS FUND 8422927 317193 1991037 6431890 .24 TOTAL CAPITAL EXPENDITURES 8968927 317471 2538574 6430353 .28 TOTAL EXPENDITURES - ALL FUNDS 17198718 713957 7569710 9629008 .44 BUDGET TRANSFERS OUT From General Fund 5095151 13450 13450 5081701 From Community Developent Block Grant 58700 58700 From Federal Aid Urban Fund 1541000 1541000 From Park Dedication Fund 768650 768650 From Assessment District Funds 167900 167900 From State Park Bond Act Fund 15300 15300 From Senior Citizen Bond Act Fund 73650 73650 TOTAL TRANSFERS OUT 7720351 - 13450 13450 7706901 �~