Loading...
HomeMy WebLinkAbout4.05 Financial Report 11-30-1986 t n :^n ( CM OF MHUN BAIANM SIM _ FOR M PERIOD RMC WNFMT43IR 30, 1986 (As Revised aumary 6, 1987) : ) TRAFFIC REVEMIE LEVELER-09 FEDERAL TRAI�TATICN CMCE OF PARK DISASIFR S1 M LAM 9ZAPE SAN FAM RD SAN RMLN RD IM9 CAPITAL FTXID INIERIAL I�BI FUEL FAf IL s GNERAL SAFETY STATE CAS SNARING MM GRANT AID URBAN DMatfn TRAFFIC SAFETY IEDICATICN AS9SIMICE LIGHT ASW ASSII'MM SPElF R M BID RAVE D>EF= PR(JEM ASSETS SERVICE IM'Ol INC. PRM DST TOTAL ALL FLDND FUN) TAX RM FUND FM FUND ACT FOAM FUND RAID FIND 63-1 FM 83-2 RYDD ASW RIND RIND FM FUN) FLWD RPID RIM DL4DV FtM FE t; pSS fAW Cash&Investments 5411857 12490 211535 44533 1000 3086 729952 -14042 25768 324976 67131 101550 1381620 18659 9420865 177400 Dne Fnm Other Plaids 478844 478844 `+ ! Doe Fran Other Govt's' 5562 460498 466060 ,:. ! Accounts Receivable 710 318 IO28 4'r�41 Assessments Receivable 701624 701624 Prepaid Items 13 Amt Avvided IN Ttm Ibt 0 `k Fixed Assets 124482 88424 5650000 '6 TOTAL ASSETS 5896+986 11b90 211853 44533 0 461498 3086 0 729952 0 -14442 25768 1026600 67131 101550 1381620 124482 107083 15070865 0 S LLtBnxm 'I - Deposits from Others 134348 3125 101550 239023 Payroll Taxes Payable 4065 4055 AlluTc-Deprec.iation 25115 25115 Advance Dine Otis Fhds 63309 63309 Doe to Other Funds 460498 18346 478844 Deferred Reveranes 577331 577331 Accounts Payable 15316 15316 Bands&Certif Pybl 857869 11968000 12825869 TOTAL LIAE n.TTfE:4 153719 0 0 0 0 460498 0 0 0 0 1438325 101550 18346 88424 11968000 14228862 + { EM 97jM Fund Deserve 5623266 3574 179416 486 520074 288713 31476 -286969 67131 2221756 1914+82 25115 2918364 11457991 Rmd Balance 787812 8916 321437 44047 1000 3086 27)878 -42862 -6708 -124756 -658482 -6456 -483310 -435398 Rand Tn=fers -667811 667811 0 TOTAL RAID D= 5743267 12490 211853 44533 0 1000 3a,16 0 729952 0 -14052 25768 -411725 67131 0 1363274 12tAM 18659 3102865 0 lx. -B UAL UAffi11TIL5& 5896986 12490 211853 44533 0 461498 3086 0 729952 0 -14052 25768 1026600 67131 101550 1381620 124482 107C63 15070865 0 25251455 RAID I11 M V v o � CITY OF DUBLIN _ STATEMENT OF REVENUE & EXPENDITURES FOR THE PERIOD ENDING NOVEMBER 30, 1986 (As Revised January 5, 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 r - 510.01 Current Year Secured 444000 7189 7189 .02 510.02 Current Year Unsecured 51500 38457 .75 510.03 Prior Year Secured 19400 4608 .24 510.04 Prior Year Unsecured 2000 621 .31 510.05 Supplemental Property Tax 8000 6272 .78 Total Property Tax 524900 7189 57147 .11 OTHER TAXES 515.00 Sales & Use Tax 4500000 400000 1550391 .34 517.00 Real Property Transfer Tax 58000 4619 26070 .45 _ 518.00 Transient Occupancy Tax 160000 30556 30556 .19 519.00 Electric Franchise Tax 121000 521.00 Gas Franchise Tax 38000 522.00 Garbage Franchise Tax 60000 8018 23326 .39 523.00 CATV Franchise Tax 68000 Total Other Taxes 5005000 443193 1630343 .33 LICENSES & PERMITS 530.01 Building Permits 651000 17426 167527 .26 530.02 Animal Licenses 8000 2797 .35 530.03 Bus Bench Ad Permits 300 530.04 Enchroachment Permits. 4000 143 862 .22 530.05 Other Permits 50 50.00 Total Licenses & Permits 663300 17569 -171236 .26 FINES & FORFEITURES 532.02 Other Court Fines 14500 29 3680 .25 Total Fines & Forefeitures 14500 29 - 3680 .25 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest 800000 31476 428188 .54 550.03 Rents & Concessions 53790 2184 14843 .28 Total Revenue from Use of Money & Property 853790 33660 443031 .52 INTERGOVERNMENTAL REVENUES - STATE ` 555.01 Motor Vehicle in Lieu Tax 570000 51681 192562 .34 555.02 Trailer Coach in Lieu Tax 5000 555.03 Cigarette Tax 97000 8627 36224 .37 555.04 Off Highway Vehicle in Lieu Tax 450 555.05 Homeowner's Property Tax Relief 18000 555.06 SB 300 Allocation 46500 39166 .84 Total Intrgvrmmntl Rvnues - State 736950 60308 267952 -.36 Percent of Revenue Report - Page 2 Estimated Current Received Estimate s` Revenue Month Year to Date Received CHARGES FOR SERVICES - -- -- 565.01 Zoning & Subdivision Fees 115000 8540 11838 .10 565.02 Plan Checks & Inspection Fees 371000 149325 149325 .40 565.04 Sales of Maps & Documents 5500 132 2591 .47 565.06 Special Police Dept. Services 6400 1450 3297 .52 565.12 Park & Recreation Fees 78650 4723 23247 .30 565.15 Other Charges for Services 7500 565.16 Building Use Insurance 6200 225 2700 .44 565.18 Zone' 7 Drainage Fees 2900 30 144 .05 565.19 Field Use Fees 4 5582 558.00 Total Charges for Services 593150 164429 198724 .34 OTHER REVENUES - 570.02 Reimbursements 4750 570.03 Miscellaneous 1000 14375 22224 22.22 570.06 Reimbursement for Public Damage 4000 566 .14 570.07 Trash Bag Program 1000 330 2210 2.21 Total Other Revenue 10750 14705 25000 2.33 TOTAL GENERAL FUND REVENUES 8402340 741082 2797113 .33 TRAFFIC SAFETY FUND (FUND # 2-5) FINES & FOEFEITURES 532.01 Vehicle Code Fines 64000 15998 .25 TOTAL TRAFFIC SAFETY FUND 64000 15998 .25 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 30660 .36 555.08 State Gas Tax (2107) 169200; 59572 .35 555.09 State Gas Tax (2107.5) 4000 4000 1.00 Total State Gas Tax 259100" 94232 .36 TOTAL STATE GAS TAX FUND 271100 94232 .35 REVENUE SHARING FUND (FUND # 2-8) INTERGOVERNMENTAL REVENUES - FEDERAL 559.01 Revenue Sharing 44047 441.00 TOTAL REVENUE SHARING FUND 44047 441.00 COMMUNITY DVLPMNT BLOCK GRANT FUND (FUND # 2-9) INTERGOVERNMENTAL REVENUES- FEDERAL 559.02 Community Development Block Grant 58700:_ :• :' :;'• TOTAL COMMUNITY DVLPMNT BLOCK GRANT FUND ;_ 58700'.-.* - - -�- „Revenue 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 1000 1000 TOTAL FEDERAL AID URBAN FUND 1541000 1000 1000 TRANSPORTATION DVLPMNT ACT FUND (FUND # 2-11) INTERGOVERNMENTAL REVENUES 555.10 Article 4.5 Funds (Paratransit) 12345 3086 .25 TOTAL TRANSPORTATION DEVELOPMENT ACT FUND 12345 3086 .25 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 —5737 STREET LIGHTING ASSESSMENT DISTR 83-1 (FUND # 2-18) 534.03 Special Benefit Assessments 1390.00 1694 .01 550.01 Interest TOTAL STREET LIGHTING ASSMNT DISTR 83-1 139000 -1694 .01 LANDSCAPE ASSESSMENT DISTRICT 83-2 (FUND # 2-19) = 534.03 Special Benefit Assessments 24100 550.01 Interest TOTAL LANDSCAPE ASSMNT DISTR 83-2 24100 SAN RAMON RD SPECIFIC PLAN ASSMT DISTR (FUND # 5-20) 534.03 Special Benefit Assessments 124293 550.01 Interest 27000 TOTAL SAN RAMON RD SPECIFIC PLN ASSMT FUND 151-293 i Revenue Report — Page 4 Percent of Estimated 7 Current Received Estimate Revenue Month Year to Date Received DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 550.01 Interest 444000 550.03 Rents & Concessions 667811 667811 668.00 TOTAL DUBLIN INFORMATION, INC. FUND 444000 667811 667811 1.50 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 CAPITAL PROJECTS FUND (FUND # 3—XXX) OTHER REVENUES 570.02 Non—Government Contributions 490100 2779 126648 .26 TOTAL CAPITAL PROJECTS FUND 490100 2779 126648 .26 TOTAL REVENUE — ALL FUNDS 11894178 1406935 3961507 .33 BUDGET TRANSFERS IN To Operating Fund 832500 To Dublin Information, Inc. Fund 1379851 667811 .48 To Capital Projects Fund 5508000 = TOTAL BUDGET TRANSFERS IN 7720351 667811- .09 CITY OF DUBLIN SUMMARY REVENUE & EXPENDITURE REPORT ALL FUNDS CONSOLIDATED FOR THE PERIOD ENDED NOVEMBER 30, 1986 (Revised January 6, 1987) CURRENT YEAR TO PERCENT OF REVENUES BUDGET MONTH DATE BALANCE BUDGET-YTD Property Tax 524900 7189 57147 467753 .11 Other Taxes 5005000 443193 1630343 3374657 .33 Licenses & Permits 663300 17569 171236 492064 .26 Fines, & Forfeitures 78500 29 19678 58822 .25 Special Assessments 287393 1694 285699 .01 For Use of Money & Property 1352640 701471 . 1110842 241798 .82 Intergovernmental Revenue 2697045 55571 410317 2286728 .15 Charges for Services 593150 164429 198724 394426 .34 Other Revenue 692250 17484 361526 330724 .52 TOTAL REVENUES 11894178 1406935 3961507 7932671 .33 EXPENDITURES General Government 101 City Council 71390 4087 24246 47144 .34 102 City Manager/Clerk 241125 14906 85658 155467 .36 103 Legal Services 86510 6767 30470 56040 .35 104 Finance 117855 9008 33548 84307 .28 105 Building Management 1503101 679862 719320 783781 .48 106 Insurance 143200 51841 91359 .36 107 Elections 4300 100 1412 2888 .33 108 Non-Departmental 126820 126820 Total General- Government 2294301 714730 946495 1347806 .41 Public Safety 201 Police Services 1581915 172400 461776 1120139 .29 202 Crossing Guards 15500 15500 203 Animal Control 50700 50700 204 Traffic Signals & Safety Lighting 238700 11688 49580 189120 .21 205 Disaster Preparedness 23600 2512 5198 18402 .22 Total Public.JSafety 1910415 186600 516554 1393861 .27 Transportation 301 Public Works 108850 7729 32079 76771 .29 302 Street Maintenance 463150 21947 52215 410935 .11 303 Street Sweeping 57600 4508 15920 41680 .28 304 Street Tree Maintenance 74400 -3136 7302 67098 .10 305 Street Landscape Maintenance 149050 18896 53975 95075 .36 306 Paratransit Service 24118 24118 Total Transportation 877168 49944 161491 715677 .18 Health & Welfare 501 Vector Control Service 6000 490 5510 .08 Total Health. & Welfare 6000 0 490 - 5510 .08 i .. .... -n. ....... .. -n+-.^-.:M.-xeo-.ie:an•rer•cmfmT-wnviz-se_mmnrste�fT_.t'.m�mf a2m2ms-sa�wnf.rn-?r-s.�...xr+.. .f erewv:�a�zay..acvve.T Sa.w.�e�-:r�..ea..�.s....-��.........._.'.�_._._ Summary Revenue & Expenditure Report — Page 2 CURRENT YEAR TO PERCENT OF All Funds Consolidated BUDGET MONTH DATE BALANCE BUDGET—YTD Culture & Leisure Services 701 Library Service 91984 17921 74063 .19 702 Parks & Recreation 363235 22051 96684 266551 .27 703 Park Maintenance 31800 31800 Total Culture & Leisure Services 487019 22051 114605 372414 .24 Community Development - 901 Planning 389130 19242 98346 290784 .25 902 Building & Safety 278100 20112 75517 202583 .27 903 Engineering 417700 44316 215947 201753 .52 Total Community Development 1084930 83670 389810 695120 .36 Internal Service Fund Charges 0 3995 6456 —6456 6456.00 TOTAL OPERATING EXPENDITURES 6659833 1060990 2135901 4523932 .32 DEBT SERVICE EXPENDITURES 1538641 798312 740329 .52 CAPITAL IMPROVEMENT EXPENDITURES Public Facilities Project 546000 116210 477565 68435 .87 General Improvements 1319550 49349 183550 1136000 .14 Community Improvements. 911500 7425 33524 877976 .04 Parks Improvements 1886950 2356 33124 1853826 .02 Street Improvements 3231100 423666 734933 2496167 .23 TOTAL CAPITAL IMPROVEMENT EXPENDITURES 7895100 599006 1462696 6432404 .19 TOTAL ALL EXPENDITURES 16093574 1659996 4396909 11696665 .27 APPROPRIATIONS FROM RESERVES 4199396 253061 435402 3763994 .10 CITY OF .DUBLIN STATEMENT OF REVENUE AND EXPENDITURES FOR THE PERIOD ENDING NOVEMBER 30, 1986 (As Revised_-January 6, 1987) s` 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 7623 10377 .42 .04 Retirement 1170 43 404 766 .35 .05 Group Insurance 13560 3273 10287 .24 .06 Worker's Compensation 100 100 Total Personal Services 32830 1429 11300 21530 .34 705 Services & Supplies .01 Office Supplies 250 27 205 45 .82 .02 Postage 100 15 48 52 .48 .05 Professional Services 4400 3500 900 .80 .08 Advertising 1500 198 677 823 .45 .09 Printing 250 32 218 .13 .14 Books, Pubis & Subscp 200 200 .15 Memberships & Dues 5600 5600 .17 Trvl, Confs & Meetings 9400 1189 3796 5604 .40 .18 Training 6500 6500 .19 Community Promotion 9660 1186 4645 5015 .48 Total Services & Supplies 37860 2615 12903 24957 .34 757 Capital Outlay - 700 43 43 657 .06 TOTAL CITY COUNCIL 71390 4087 24246 47144 .34 102 CITY MANAGER / CLERK 701 Personal Services .01 Salaries, Full Time _ 152500 11802 60978 91522 .40 .02 Salaries, Part Time 2000 1901 99 .03 Salaries, Overtime _ 440 111 342 98 .78 .04 Retirement 14050 536 4828 9222 .34 .05 Group Insurance 15600 391 4299 11301 .28 .06 Worker's Compensation 3530 2320 1210 .66 .08 Medicare FICA 275 22 56 219 .20 Total Personal Services 188395 12862 74724 113671 .40 705 Services & Supplies .01 Office Supplies 3150 503 1370 1780 .43 .02 Postage 2900 180 788 2112 .27 .03 Reproduction Svcs 2100 149 969 1131 .46 .08 Advertising 1800 232 1568 .13 .09 Printing 12500 447 12053 .04 .12 Repairs & Maintenance 200. 200 .14 Books, Pubis & Subscps = 1700 1628 72 .96 .15 Memberships & Dues 550 550 .16 Auto Mileage & Allow. 5000 : '.. ., - 424 1947 3053 .39 Expenditure Report - Page 2 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE - BUDGET-YTD CITY MANAGER / CLERK. - Services & Supplies (Continued) r .17 Trvl, Confs & Meetings 5700 767 2613 . ,3087 .46 .18 Training 1100 1100 Intrnl Srvc Fund Chrgs 5830 5830 Total Services & Supplies 42530 2023 9994 32536 .23 722 Contract Services 7500 7500 757 Capital Outlay-Mchnry & Eqp 2700 21 940 1760 .35 TOTAL CITY MANAGER / CLERK 241125 14906 .85658 155467 .36 103 LEGAL SERVICES 701 Personal Services .04 Retirement 4300 59 837 3463 .19 .05 Group Insurance 2710 = 2710 Total Personal Services 7010 59 = 837 6173 r.12 705 Services & Supplies .05 Professional Services 79500 - 6708 29633 49867 .37 Total Services & Supplies 79500 6708 29633 49867 .37 TOTAL LEGAL SERVICES 86510 6767 30470 56040 .35 104 FINANCE 701 Personal Services .01 Salaries, Full Time 69400 5354 =15801 53599 .23 .03 Salaries, Overtime 500 111 389 .22 .04 Retirement 4520 166 784 3736 .17 .05 Group Insurance 8245 88 828 7417 .10 .06 Worker's Compensation 1450 1450 .08 Medicare FICA 600 53 92 508 .15 Total Personal Services; 84715 5661 - 17616 --67099 .21 705 Services & Supplies .01 Office Supplies 1250 337 664 586 .53 .05 Professional Services 21800 1951 13129 8671 .60 .09 Printing & Binding 1300 127 880 420 .68 .12 Repairs & Maintenance 220 220 .14 Books Publs & Subscrps 770 30 154 616 .20 .15 Memberships & Dues 400 400 .16 Auto Mileage & Allwnc 2300 192 - 378 1922 .16 .17 Trvl, Confs & Meetings 2100 2100 .18 Training 400 17 383 " .04 .20 Miscellaneous 79 79 -79 79.00 Intrnl, Srvc Fnd Chrgs 600 600 Total Services & Supplies 31140 2716 15301 15839:;;,':;; 1.49 757 Capital Outlay-Mchnry & Eqp 2000 631 631 1369 .32 TOTAL FINANCE 117855 9008 33548 . 84307rF w' 28 Expenditure Report -' Page 3 f CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD 105 BUILDING MANAGEMENT - 705 Services & Supplies .01 Office Supplies 250 51 142 108 .57 .04 Operating Supplies 300 300 .07 Communication _ 25500 1335 9309 16191 .37 .13 Rentals 1469651 675276 705491 764160 .48 .21 Utilities 1200 52 133 1067 .11 Total Services & Supplies 1496901 676714. 715075 781826 .48 722 Contract Services 2200 523 1620 580 .74 Capital Outlay 755 Improvements Othr Than Bldgs 2000 699 699 1301 .35 757 Machinery & Equipment 2000 1926 1926 74 .96 Total Capital Outlay 4000 2625 2625 1375 .66 TOTAL BUILDING MANAGEMENT 1503101 679862 719320 783781 .48 106 INSURANCE 705 Services & Supplies .05 Professional Services. 200 192 8 .96 .10 Insurance Premiums 93200 51649 41551 .55 .11 Insurance Claims Expns 49800 49800 Total Services & Supplies 143200 51841 91359 1.36 TOTAL INSURANCE 143200 51841 91359 .36 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 100 224 2056 .10 TOTAL ELECTIONS 4300 100 1412 2888 .33 108 NON-DEPARTMENTAL 705 Contingent Reserve 126820 126820 TOTAL NON-DEPARTMENTAL 126820 126820 TOTAL GENERAL GOVERNMENT 2294301 714730 946495 1347806 .41 PUBLIC SAFETY 201 POLICE SERVICES 701 Personal Services .02 Salaries, Part Time = 12400 3876 8524 .31 .06 Worker's Compensation 350 :. 350 Total Personal Services " 12750 3876""­"*" 8874 .30 Expenditure Report - Page 4 _CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD 201 POLICE SERVICES (CONTINUED) 705 Services & Supplies .01 Office Supplies 1500 405 1172 328 .78 .02 Postage 900 135 441 459 .49 .03 Reproduction Supplies 1750 115 781 969 .45 .04 Operating Supplies 11350 .172 1037 10313 .09 .09 Printing & Binding 2000 .82 609 1391 .30 .12 Repairs & Maintenance 3950 120 212 3738 .05 .13 Rentals 150 150 .14 Books, Publs & Subscrps 100 43 57 .43 .15 Memberships & Dues 100 70 30 .70 .16 Auto Mileage & Allownc 600 54 546 .09 .17 Trvl, Confs & Meetings 1500 184 957 543 .64 .18 Training Expense 400 400 .19 Community Promotion 200 5 195 .03 Intrnl Svc Chg-Ofc Eqp 4200 4200 .25 Intrnl Svc Chg-Vehicles 111500 14360 97140 .13 Total Services & Supplies 140200 1213 19741 -120459 :14 710 Contract Services .01 Personnel Costs 1139940 161303 361706 778234 :32 .02 Vehicle Costs 26000 3781 20372 5628 .78 .03 Indirect Costs 73240 6103 24411 48829 .33 .04 Dispatch 115000 21655 93345 .19 .05 Admin. - Financial Svcs 20605 5151 15454 ;25 .06 Services & Supplies 50180 3458 46722 .07 Total Contract Services 1424965 171187 436753 988212 ^.31 757 Capital Outlay-Mchnry & Eqp 4000 1406 2594 .35 TOTAL POLICE SERVICES 1581915 172400 461776 1120139 .29 202 CROSSING GUARDS 705 .04 Srvc & Supp-Optg Supp 712 .16 Contract Services 15500 15500 TOTAL CROSSING GUARDS 15500 -~- - --15500 203 ANIMAL CONTROL 716 Contract Services .01 Shelter Services 10700 10700 .02 Field Service 40000 40000 Total Contract Services 50700 50700 --� TOTAL ANIMAL CONTROL 50700 50700 204 TRAFFIC SIGNALS & SAFETY LIGHTING 705 .21 Srvc & Supp-Utilities 12600 2463 7689 4911 .61 712 .01 Contract Services 25600 25600 757 Cptl Outlay-Mchnry & Eq 4000 4000 TOTAL TRAFFIC SGNLS-SFTY LIGHTING 42200 - 2463 7689 34511 ~.18 Expenditure Report - Page 5 CURRENT' . YEAR TO PERCENT OF BUDGET . MONTH .f. 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 381 3067 11933 .20 757 Capital Outlay-Mchnry & Eqp 7000 7000 TOTAL DISASTER PREPAREDNESS 23600 381_ 3067 20533 .13 TOTAL PUBLIC SAFETY 1713915 175244. 472532 1241383 .28 TRANSPORTATION 301 PUBLIC WORKS ADMINISTRATION 701 Personal Services .01 Salaries, Full Time 22200 1689 8871 13329 .40 .03 Salaries, Overtime 100 40 187 -87 1.87 .04 Retirement 1400 52 468 932 .33 .05 Group Insurance 4020 27. 685 3335 .17 .06 Worker's Compensation 120 120 Total Personal Services 27840 1808 10211 17629 .37 705 Services & Supplies - .01 Office Supplies 800 81 337 463 .42 .02 Postage 280 75 249 31 .89 .03 Reporduction Services 200 24 158 42 .79 .12 Repairs & Maintenance .16 Auto -Allwnc & Mileage 50 50 .18 Training 1000 31 969 = .03 Intrnl Svc Fund Chrgs 2830 2830 Total Services & Supplies 5160 180 775 4385 .15 712 .17 Contract Services 73200 5741 20927 52273 .29 757 Capital Outlay-Mchnry & Eqp 2650 166 2484 .06 TOTAL PUBLIC WORKS ADMINISTRATION 108850 7729 32079 76771 .29 302 STREET MAINTENANCE 705 .04 Srvc & Supp-Optg Supp 2500 2500 712 .02 Cntr Svc-St. Repair 173500 4873 6162 167338 _ .04 712 .06 Cntr Svc-Sign Rpr/Instl 2000 21 178 1822 .09 755 Imprvmt Othr Thn Bldgs 5000 5000 TOTAL STREET MAINTENANCE 183000 4894- 6340 176660 = .03 304 STREET TREE MAINTENANCE 705 .21 Svc & Supp-Utilities 712 .09 Cntr Svc-Public Works 74400 -3136 _ .7302 67098 .10 TOTAL STREET TREE MAINTENANCE ;; -74400 -3136 7302 1:67098 `~.10 Expenditure Report - Page 6 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD 305 STREET LANDSCAPE MAINTENANCE 705 .21 Svc & SupplUtilities 11100 1648 3821 7279 .34 712 .15 Cntr Svc-Public Works 110350 13681 40544 69806 .37 718 .02 Cntr Svc-Litter Pickup 7000 . 456 4222 2778 .60 757 Cptl Outlay-Mchnry/Eqp 4000 4000 TOTAL STREET LANDSCAPE MAINTENANC 132450 15785 48587 83863 .37 306 PARATRANSIT SERVICE 714 Cntrct Svc-SRV Community Ctr 11773 11773 TOTAL PARATRANSIT SERVICE 11773 11773 r TOTAL TRANSPORTATION' 510473 25272 94308 416165 .18 HEALTH & WELFARE SERVICES 501 VECTOR CONTROL SERVICES 722 Contract Services 6000 490 5510 .08 TOTAL VECTOR CONTROL SERVICES 6000 490 5510 .08 CULTURE & LEISURE SERVICES 701 LIBRARY SERVICE 722 Cntrct Svcs - County Library 91984 17921 74063 .19 TOTAL LIBRARY SERVICE 91984 17921 74063 .19 702 RECREATION 701 Personal Services .01 Salaries, Full Time 84000 7642 35430 48570 .42 .02 Salaries, Part Time 86760 3842 20013 66747 .23 .03 Salaries, Overtime 500 35 159 341 .32 .04 Retirement 7400 238 1845 5555 .25 .05 Group Insurance 19780 121 3517 16263 .18 .06 Worker's Compensation 6460 6460 .07 Unemployment Ins Claims .08 Medicare FICA 1245 51 204 1041 .16 Total Personal Services 206145 11929 61168 144977 ^.30 705 Services & Supplies .01 Office Supplies 2400 133 807 1593 .34 .02 Postage 4720 360 1870 2850 .40 .03 Reproduction Services 2400 53 333 2067 .14 .04 Program Materials 14630 416 2044 12586 .14 .07 Communications 4600 630 3970 .14 .08 Advertising 300 193 107 .64 .09 Printing 13800 3372 10428 .24 .12 Repairs & Maintenance 1700 1700 .13 Rentals 6580 3975 3975 2605 .60 .14 Books, Publs & Subscrip 200 84 116 .42 t� it h„� .•l.- M 7, t: Expenditure Report - Page 7 .,,.,­,,,,CURRENT ` YEAR TO - PERCENT OF BUDGET =; MONTH . DATE BALANCE BUDGET YTD 702 RECREATION - Services & Supplies (Continued) - .15 Memberships & Dues 280 :.; _ 100 ":'' ^;_: 280 _ 0 1.00 .16 Auto Mileage & Allow. 3790 353 ... 1133 2657 .30 .17 Trvl-Confrncs-Meetings 3950 35 3915 .01 .18 Training Expense 1000 . 25 729 271 .73 .19 Community Promotion 3000 3000 .21- Utilities 20700 813 2864 17836 .14 Intrnl Svc Fund Chrgs 2160 2160 Total Services & Supplies 86210 6228 18349 67861 .21 725 Contract Services .01 Recreation Instruction . 34900 2505 10301 24599 .30 .02 Shannon Services 19560 1251 5370 14190 .27 .03 Senior Center Services _- 9300 9300 Total Contract Services 63760 3756 15671 48089 .25 757 Cptl Outlay-Mchnry & Eqp 7120 138 1496 5624 .21 TOTAL RECREATION DEPT. 363235 22051 96684 266551 .27 703 PARK MAINTENANCE 705 .21 Srvc & Supp-Utilities - 5000 5000 722 Contract Services 21300 21300 TOTAL PARK MAINTENANCE 26300 26300 TOTAL CULTURE & LEISURE SERVICES 481519 22051 114605 366914 .24 COMMUNITY DEVELOPMENT = 901 PLANNING . 701 Personal Services .01 Salaries, Full Time 172900 10546 60645 112255 .35 .02 Salaries, Part Time 3880 3880 .03 Salaries, Overtime 2300 86 919 1381 .40 .04 Retirement 11260 327 3234 8026 .29 .05 Group Insurance 20590 224 4835 15755 .23 .06 Worker's Compensation 4510 4510 Total Personal Services 215440 11183 69633 145°07 T.32 705 Services & Supplies .01 Office Supplies 4150 150 1489 2661 .36 .02 Postage 3200 614 1938 1262 .61 .03 Reproduction Supplies 3500 134 908 2592 .26 .05 Professional Services 129330 5579 .. ' 18414 110916 .14 .08 Advertising 1500 167 . 844 656 .56 .09 Printing & Binding 7600 _ 63 ..-. 703 6897 .09 .12 Repairs & Maintenance 1000 : .; 1000 .14 Books, Publs & Subscrps , 1200 42 1158 .04 .15 Memberships & Dues :340 �; � 317 23 .93 ry .16 Auto Mileage & Allow. _ 2530 :207 `ti x .'963 1 -67' .38 .17 Trvl, Confs & Meeting 5700 :N" 1145 ;y?:1595 a 4105 : .28 v rw4 i e e ar 4 l Expenditure Report - Page 8 CURRENT 'kR TO PERCENT OF BUDGET ' _ MONTH ATE BALANCE BUDGET YTD 901 PLANNING - Services & Supplies (Continued) :'`.: - _ . .18 Training 1200 220 980 .18 .24 Annexations/Filing Fees 4100 1280 2820 .31 Intrnl Svc Fund Chrgs 4550 4550 Total Services & Supplies 169900 8059 28713 141187 .17 757 Capital Outlay-Mchnry & Eqp 3790 3790 TOTAL PLANNING 389130 19242 98346 290784 .25 902 BUILDING & SAFETY 701 Personal Services .01 Salaries, Full Time 26000 1800 9900 16100 .38 .03 Salaries, Overtime 700 13 199 501 .28 .04 Retirement 1620 56 524 1096 .32 .05 Group Insurance 4040 563 1207 2833 .30 .06 Worker's Compensation 140 ' 140 Total Personal Services 32500 2432 11830 20670 .36 705 Services & Supplies .01 Office Supplies 1000 141 409 . 591 .41 .02 Postage 400 60 192 208 .48 .03 Reproduction Supplies 300 5 32 268 .11 .09 Printing & Binding 800 550 250 .69 .12 Repairs .14 Books, Publs & Subscps 600 34 566 .06 .15 Memberships & Dues 550 10 540 .02 .16 Auto Mileage & Allow. - 50 50 .18 Training Expense 1000 308 692 .31 Intrnl Svc Fund Chrgs 1850 1850 Total Services & Supplies 6550 206 1535 5015 .23 722 Contract Services 237600 17474 62152 175448 .26 757 Cpt1 Outlay-Mchnry & Eqp _ 1450 1450 TOTAL BUILDING & SAFETY 278100 20112 75517 202583 .27 903 ENGINEERING 705 Services & Supplies .01 Office Supplies 300 129 306 -6 1.02 .02 Postage 400 75 281 119 .70 .03 Reproduction .09 Printing & Binding 2000 100 462 1538 .23 Total Services & Supplies _ 2700 304 1049 1651 .39 722 Contract Services 400000 44012 204255 195745 .51 757 Cptl Outlay-Mchnry & Eqp 2500 .. 1707 793 .68 TOTAL ENGINEERING ;405200,:`;- 44316 207011 198189 .51 i r TOTAL .COMMUNITY DEVELOPMENT ' 1072430 `-"-, 83670 380874 691556 .36 4r TOTAL GENERAL FUND 6078638 :;.<;.1020967 2009304 4069334 .33 Expenditure Report - Page 9 _CURRENT SEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD TRAFFIC SAFETY FUND (FUND # 2-5) 205 TRAFFIC SIGNALS & STREET LIGHTING 705 .21 Srvc & Supp-Utilities 21400 240. 2056 19344 .10 712 .01 Cntrct Svc-Trfc Signls 42600 1891. 5026 37574 .12 TOTAL TRAFFIC SIGNALS & STREET LG 64000 2131 7082 56918 .11 TOTAL TRAFFIC SAFETY FUND 64000 2131 7082 56918 .11 STATE GAS TAX FUND (FUND # 2-6) TRANSPORTATION 302 STREET MAINTENANCE 712 Contract Services .02 Street Repair 110000 110000 .03 Drainage & Maintenance 22500 1745- 9917 12583 .44 .04 Storm Patrol & Clean-up 13150 - 13150 .00 .05 Curbs Gutters Sidewalks 24000 7283 7283 16717 .30 .06 Sign Rpr & Installation 23500 1678= 4213 19287 .18 .07 Striping & Marking 40000 4187 16473 23527 .41 .08 Guardrail Repair 2000 2000 .10 Weed Control 3000 857_ 1836 1164 .61 .13 Bike Path Maintenance 7000 1303- 1303 5697 .19 Total Contract Services 245150 17053 41025 204125 .17 755 Imprvmts Othr Thn Bldgs 35000 4850 30150 .14 TOTAL STREET MAINTENANCE 280150 17053 45875 234275 .16 303 STREET SWEEPING 718 Contract Services .01 Street Sweeping 57600 4508. 15920 41680 .28 Total Contract Services 57600 4508- 15920 41680 .28 TOTAL STREET SWEEPING 57600 4508 15920 41680 .28 TOTAL TRANSPORTATION 337750 21561 61795 275955 .18 COMMUNITY DEVELOPMENT 903 ENGINEERING-TRAFFIC 722 Contract Services 4000 4000 TOTAL ENGINEERING 4000 4000 TOTAL STATE GAS TAX FUND 341750 21561 61795 279955 .18 TRANSPORTATION DEVELOPMENT ACT FUND (FUND # 2-11) 306 PARATRANSIT SERVICE 714 Cntrct Svc-SRV Community Ctr 12345 12345 TOTAL TRANSPORTATION DVLPMNT ACT FUND 12345 12345 Expenditure' Report - Page 10 - _ CURRENT ZAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD ST. LIGHTING ASSESSMENT DISTRICT 83,-1 FUND (FUND # 2-18) 204 SAFETY LIGHTING 705 .21 Srvc & Supp-Utilities 132500 9225 36940 95560 .28 903 ENGINEERING SERVICES 722 Contract Services 6500 7616 -1116 1.17 TOTAL ST. LIGHTING ASSMNT DISTR. FUND 139000 9225 44556 94444 .32 LANDSCAPE DISTRICT ASSESSMENT FUND 83-2 (FUND # 2-19) 305 STREET LANDSCAPE MAINTENANCE 705 .21 Srvc & Supp-Utilities 11600 1445 3528 8072 .30 712 .15 Cntrct Svc-Public Works 5000 1666 1860 3140 .37 TOTAL STREET LANDSCAPE MAINTENANC 16600 3111 5388 11212 .32 703 PARK MAINTENANCE 722 Contract Services 5500 5500 903 ENGINEERING SERVICES 722 Contract Services 2000 1320 680 .66 TOTAL LANDSCAPE DISTR. ASSMNT FUND 83-2 24100 3111 6708 17392 .28 INTERNAL SERVICE FUND (FUND # 10-30) 705 Services & Supplies .01 Office Supplies 1000 1000 .04 Operating Supplies 32031 1013 1013 31018 .03 .10 Insurance Premium 10800 10800 .12 Repairs & Maintenance 22015 500 2961 19054 .13 Total Services & Supplies 65846 1513 3974 61872 .06 757 Machinery & Equipment 2485 2482 2482 3 1.00 764 Depreciation & Replacement 63969 = 63969 Internal Service Credits -132300 -132300 TOTAL INTERNAL SERVICE FUND 0 3995 . 6456 -6456 6456.00 TOTAL OPERATING EXPENDITURES - ALL FUNDS 6659833 1060990 2135901 4523932 .32 DEBT SERVICE EXPENDITURES SAN RAMON RD SPECIFIC PLAN ASSMT DISTR FUND (FUND # 5-20) 730 Debt Service .01 Principal Payments 87869 87869 1.00 .02 Interest Payments 70921 36887 34034 .52 TOTAL SAN RAMON RD ASSMT DSTR FUND 158790 -124756 34034 .79 DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 722 Contract Services L 5745 -5745 5745.00 730 .02 Debt Service-Interest 1379851 667811 712040 .48 TOTAL DUBLIN INFORMATION, INC. FUND 1379851 - 673556 706295 .49 TOTAL DEBT SERVICE EXPENDITURES 1538641 798312 740329 .52 Expenditure Report - Page 11 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YTD CAPITAL IMPROVEMENTS EXPENDITURES DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 751 Land 5000 -5000 5000.00 755 .01 Sierra Ct Sthrn Extnsn 546000 116210 472565 73435 .87 TOTAL DUBLIN INFO INC. CAPTL EXPS 546000 116210 477565 68435 .87 CAPTIAL PROJECTS FUNDS (FUND # 3-XXXX) General Improvements 0024 Civic Center 1200000 33350 53097 1146903 .04 0030 Word Processing 16000 15999 15999 1 1.00 0049 DSRSD Services Study 8797 -8797 8797.00 0066 Police Vehicles 103550 105657 -2107 1.02 Total General Improvements 1319550 49349 183550 1136000 �.14 Community Improvements 0020 Sewage Facility Expansion 800000 800000 0025 Sidewlk Sfty/Bus Stop Pads 50000 2625 8073 41927 .16 0032 Downtown Improvement Plan 31500 17936 13564 .57 0033 Dublin Blvd Undergrounding 4800 5231 -5231 5231.00 0067 Doherty Rd Fencing-Est Side 20000 1308 18692 .07 0068 Major Artrl Fence Replacemnt 10000 976 9024 .10 Total Community Improvements 911500 7425 33524 877976 .04 Park Improvments 0035 Kolb Park 817300 190 817110 0060 Park Development Plan 256 13003 -13003 13003.00 0061 Shannon Park Renovation 456130 456130 .0063 Dolan Park 407020 2100 2100 404920 .01 0065 Amador Lakes Mini Park 46500 1937 44563 .04 0069 Senior Citizens Center 102000 102000 0070 Doherty Hills Park 58000 15894 42106 .27 Total Park Improvements 1886950 2356 - 33124 1853826 ~.02 Street Improvements 0029 Annual Street Overlay 130000 1256 128744 .01 0036 San Ramon Rd Phase II 1298100 199808 235051 1063049 .18 0037 Sn Rmn Rd-III/Hillsd Lndscp 32000 31426 574 .98 0038 Trfc Sgl-Alcosta/San Rmn Rd 6287 10397 -10397 10397.00 0039 Trfc Sgl-Dbin Blvd/Sierra 218000,. 91413 126587 .42 0042 Traffic Signal Interconnect 150000 1632 6188 143812 .04 0044 Lndscp Vllg Pkwy to Kimball 70000 2000 32251 37749 .46 0053 Arroyo Vista Sidewalks 1438 5788 -5788 5788.00 0055 Dghrty Rd Wdng at SP Rlyd 120000 4542 115458 .04 0056 Rehb/Lndscp AVB-VP to Dghrty 989000 210172 238948 750052 .24 0059 San Ramon Rd Phase IV 43000 1003 41636 1364 .97 0071 Dbin Blvd NW Frntg at Clark 161000 9154 151846 .06 0072 Trfc Sgnls & St Light Addtns 20000 1326 26883 -6883 1.34 Total Street Improvements 3231100 423666 -734933 2496167 .23 f Expenditure Report — Page 12 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET—YTD TOTAL CAPITAZ PROJECTS FUND 7349100 482796 985131 6363969 .13 TOTAL CAPITAL EXPENDITURES 7895100 599006 1462696 6432404 .19 TOTAL EXPENDITURES — ALL FUNDS 16093574 1659996 4396909 11696665 .27 BUDGET TRANSFERS OUT From General- Fund 5095151 667811 4427340 .13 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 667811 7052540 .09 x ,