Loading...
HomeMy WebLinkAbout4.02 Financial Report 05-31-1987 CITY OF DUBLIN BALANCE CE SHEET FOR THE PERIOD E.'DING MAY 31, 1987 TRAFFIC STATE REVENUE COhMUNITY FEDERAL TRANSPORTATION OFFICE OF PARK ST LIGh-r L--VNDSCAPE SAN RAF017 RD SN MN RD TRUST CAPITAL FIXED IKITYLZAL DUBLIN GENERAL SAFETY GAS TAX STARING DvLpnr BCE AID URBAN DEVELOPMENT M%.FFIC DEDICATION DISASTER ASS.�, ASS`Tr DISTR SPECIF PLAN BOND RSRV DEPOSIT PF40JEM ASSETS SERVICE INFO INC. TOTAL ALL FUND FUND 'FUND FUND GRANT FUND FUND ACT FUND SAFETY FUND FUND ASST END 83-1 FZ\T) 83-2 FUND ASS*Tr FUND FUND FUND FUND FUND FUND RNT FUNDS ASSETS Cash & Investments 8326977 44331 262287 48825 42640 719123 6173 729952 63437 36289 406378 67131 112580 -90505 48136 8371859. 19195613 Due Frm Othr Funds 478844 478844 Due Frm OPhr Govt's 5562 460498 466060 Accamts Receivable 710 318 1028 Assessments Recvbl 701624 ' 1624 Prepaid Items 13 8616 529 Amt Provided-Lng Trm Dbt 0 Fixed Assets 124482 88424 5650000 boo2906 --- ----- ----- ------ ----- ------ ------- ----- ------- ----- ------ ----- ------- ------ ------ ------ ------ ----- -------- ----- TOTAL ASSETS 8812106 44331 262605 48825 42640 1179621 6173 0 729952 0 63437 36289 1108002 67131 112580 -90505 124482 145176 14021859 26714704 LLABILI= s Deposits frm Othrs 108207 3125 112580 223912 Payroll Taxes Pybl 0 Allwnc-Depreciatn 25115 25115 Adwnc Due Othr Fads 63309 63309 Due to Other Funds 460498 18346 478844 . Deferred Revenues 577331 577331 Accounts Payable 13813 ( 13813 Bonds & Certif Pybl 857869 11968000 12825869 ------ ----- ------ ----- ------ ------- ----- ------- ----- ------ ----- ------- ------ ------ ------ ------ ------ -------- — TOTAL LIABILITIES 122020 — 0 0 0 0 460498 0 0 0 0 1438325 112580 18346 88424 11968000 14208193 FUND EQUITY Fund Reserve 5623264 3574 179416 486 520074 28820 32476 -286969 67131 2221756 124482 25115 2918364 89 Fund Balance 3080272 40757 83189 48339 111340 719123 6173 209878 34617 3813 -43354 -2399307 18187 -864505 j22 Flns3 Transfers -13450 -68700 68700 13450 0 ----- ------ ------- ----- ------- ----- ------ ----- ------- ------ ------ ----- ------ ------ -------- - TOTAL FL\'D EQUITY 8690086 44331 262605 48825 42640 719123 6173 0 729952 0 63437 36289 -330323 67131 _ 0 108851 124482 56752 2053859 12506511 ------ ------ ------ ------ ----- ------ ------- ----- ------- ----- TOTAL LIABILITIES & 8812106 44331 262605 48825 42640 1179621 6173 0 729952 0 -63437 36289 1108002 -67131 112580 -90505 124482 145176 14021859 26714704 ----- ------- ------ ------- ------ ------ -------- -------- FL:D EQUITY ------ ----- ------- ------ ------ ------- ------ W l� CITY OF.DUBLIN SUMMARY REVENUE & EXPENDITURE REPORT ALL FUNDS CONSOLIDATED FOR THE PERIOD ENDED MAY 31, 1987 CURRENT YEAR TO PERCENT OF REVENUES BUDGET MONTH DATE BALANCE BUDGET-17M Property .Tax 524900 97537 535742 -10842 1.02 Other Taxes 5005000 456762 '4420315 584685 .88 Licenses & Permits 663300 31033 555994 107306 .84 Fines & Forfeitures 78500 9851 79379 -879 1.01 Special Assessments 287393 53983 270869 16524 .94 For Use of Money & Property 2732491 51415 2520873 211618 .92 Intergovernmental Revenue 2754684 439767 1725002 1029682 .63 Charges for Services 725450 8127 558884 166566 .77 Other Revenue 692250 3965 393452 298798 .57 TOTAL REVENUES 13463968 1152440 11060510 2403458 .82 EXPENDITURES General Government 101 City Council 71690 3432 48604 23086 .68 102 City Manager/Clerk 243000 23934 206922 36078 .85 103 Legal Services 86510 10326 66624 19886 .77 104 Finance 117855 11608 95326 . 22529 .81 105 Building Management 1503101 10779 1491642 11459 ,99 106 Insurance 143200 56573 86627 ,40 107 Elections 4300 2620 1680 ,61 108 Non-Departmental 24619 100000 -75381 4.06 -----=- ------- Total General Government 2194275 ; 60079 2068311 125964 ,94 Public Safety 201 Police Services 1584915 143190 1129423 455492 202 Crossing Guards 21800 .7407 14393 .71.34 203 Animal Control 50700 29170 21530 204 Traffic Signals.& Safety Lighting 238700 13959 130331 108369 .55 205 Disaster Preparedness . 23600 .2175 7330. 16270 .31 Total Public Safety 1919715 159324 1303661 616054 .68 ' ' Transportation 301 Public Works 108850 8453 103993 4857 .96 302 Street Maintenance 468560 12501 129214 339346 .28 303 Street Sweeping 57600 4822 41914 15686 .73 304 Street Tree Maintenance 74400 6091 29803 44597 .40 305 Street Landscape Maintenance 170550 15565 118841 51709 .70 306 Paratransit Service 28039 17262 10777 .62 -- Total Transportation 907999 47432 441027 466972 .49 Health & Welfare 501 .Vector Control Service 6000 2120 3880 .35 ------ ------- ---- Total Health & Welfare ----°- '---- 6000 '2120 3880 .35 Summary Revenue & Expenditure Report - Page 2 CURRENT YEAR TO PERCENT OF All Funds Consolidated BUDGET MONTH DATE BALANCE BUDGET-YM Culture & Leisure Services 701 Library Service 91984 60692 31292 .66 702 Parks & Recreation 369035 27589 238033 131002 .65 703 Park Maintenance 26300 26300 ------- ------- ------- ------ Total Culture & Leisure Services 487319 27589 ' 298725 188594 .61 Community Development 901 Planning 409780 28615 273091 136689 .67 902 Building & Safety 287700 25833 197968 89732 .69 903 Engineering 417700 29836 435365 -17665 1 .04 ------- ------- ------- Total Community Development 1115180 84284 906424 208756 .81 Internal Service Fund Charges 145750 1969 42609 103141 .29 TOTAL OPERATING EUDENDITURES 6776238 380677 5062877 1713361 .75 DEBT SERVICE-SR RD ASSMT DISTR 158790 158787 3 1.00 DUBLIN INFORMATION INC. EXPENDITURES Operating Expenditures 547212 45229 335231 211981 .61 Debt Service Expenditures 1379851 1379851 0 1.00 Capital Expenditures-Public Facility 1587675 665 529276 1058399 .33 TOTAL DUBLIN INFORMATION INC. EXPENDITURES 3514738 45894 2244358 1270380 .64 CAPITAL IMPROVEMENT EXPENDITURES General Improvements 140950 733 131664 9286 .93 Community Improvements 936981 869 68824 868157 .07 Parks Improvements 1930045 96409 162326 1767719 .08 Street Improvements 4013276 427664 2183140 1830136 .54 TOTAL CAPITAL IMPROVaIENT ZPENTDITURES 7021252 525675 2545954 4475298 .36 TOTAL ALL EXPENDITURES 17471018 952246 10011976 7459042 .57 APPROPRIATIONS FROM RESERVES 4007050 -200194 -1048534 5055584 -.26 CITY OF DUBLIN STATEMENT OF REVENUE & EXPENDITURES FOR THE PERIOD ENDING MAY 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 ------------------------- --------- --------- ------------ ---------- PROPER'L'Y TAX 510.01 Current Year Secured 444000 88094 438583 .99 510.02 Current Year Unsecured 51500 5513 64550 1.25 510.03 Prior Year Secured 19400 3033 15196 .78 510.04 Prior Year Unsecured 2000 621 .31 510.05 Supplemental Property Tax 8000 897 16792 2.10 Total Property Tax 524900 97537 535742 1.02 OTHER TAXES 515.00 Sales & Use Tax 4500000 419200 4020625 .89 517.00 Real Property Transfer Tax 58000 5482 56130 .97 518.00 Transient Occupancy Tax 160000 23987 78461 .49 519.00 Electric Franchise Tax 121000 114820 .95 521.00 Gas Franchise Tax 38000 29003 .76 522.00 Garbage Franchise Tax 60000 8093 53266 .89 523.00 CATV Franchise Tax 68000 68010 1.00 Total Other Taxes 5005000 456762 4420315 .88 LICENSES & PERMITS 530.01 Building Permits 651000 30978 547220 .84 530.02 Animal Licenses 8000 5375 .67 530.03 Bus Bench Ad Permits ;300 612 2.04 530.04 Enchroachment Permits 4000 55 2707 .68 530.05 Other Permits 30 30.00 530.06 Recycling Transporter Permits 50 50.00 Total Licenses & Permits 663300 31033 555994 .84 FINES & FORFEITURES 532.02 Other Court Fines 14500 2175 13861 .96 Total Fines & Forefeitures 14500 2175 13861 .96 REVENUE FROM USE OF MONEY & PROPERTY 550.01 Interest 800000 47578 1105401 1.38 . 550.03 Rents & Concessions 53790 3837 35621 .66 ------ ------- ---- Total Revenue from Use of Money & Property 853790 51415 1141022 1.3.1 INTERGOVERNMENTAL REVENUES - STATE 555.01 Motor Vehicle in Lieu Tax 570000 49707 470735 .83 555.02 Trailer Coach in Lieu Tax 5000 1234 4128 .83 555.03 Cigarette Tax 97000 3441 83375 .86 555.04 Off Highway Vehicle in Lieu Tat 450 163 .36 555.05 Homeowner's Property Tax Relief 18000 6594 16051 .89 555.06 SB 300 Allocation 46500 39166 .8=1 Total Intrgvrmmntl Rvnues - State 736950 60976 613618 .83 Revenue Report - Page 2 Estimated Current Received Estimate Revenue Month Year to Date Received CHARGES FOR SERVICES --------- --------- ------------ ---------- 565.01 Zoning & Subdivision Fees 115000 1221 54194 .47 565.02 Plan Checks & Inspection Fees 371000 358296 .97 565.04 Sales of Maps & Documents 5500 192 4964 .90 565.06 Special Police Dept. Services 6400 280 5890 .92 565.12 Park & Recreation Fees 78650 2196 53200 .68 565.15 Other Charges for Services 7500 3763 10299 1.37 565.16 Building Use Insurance 6200 400 4300 .69 565.18 Zone 7 Drainage Fees 2900 20 4882 1.68 565.19 Field Use Fees 55 2061 206.00 Total Charges for Services 593150 8127 498086 .84 OTHER REVENUES 570.02 Contributions 4750 570.03 Miscellaneous 1000 4557 4.56 570.05 Reimbursements - General 3485 26922 269.00 570.06 Reimbursement for Public Damage 4000 922 .23 570.07 Trash Bag Program 1000 480 4525 4.53 Total Other Revenue 10750 3965 36926 3.43 TOTAL GENERAL FUND REVENUES 8402340 711990 7815564 .93 TRAFFIC SAFETY FUND (FUND # 2-5) -------------------------------- FINES & FOEFEITURES 532.01 Vehicle Code Fines 64000 7676 65518 1.02 TOTAL TRAFFIC SAFETY FUND 64000 7676 65518 1.02 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 5968 72329 .84 555.08 State Gas Tax (2107) 169200 12177 143909 .85 555.09 State Gas Tax (2107.5) 4000 4000 1.00 Total State Gas Tax 259100 18145 220238 .85 TOTAL STATE GAS TAX FUND 271100 18145 220238 .81 REVENUE SHARING FUND (FUND # 2-8) ---------------------------------- INTERGOVERNMENTAL REVENUES - FEDERAL 559.01 Revenue Sharing 48339 48339 1 .00 ------ ---- TOTAL REVENUE SHARING FUND 48339 48339 1.00 COMMUNITY DVLPAMNT BLOCK GRANT FUND (FUND # 2-9) ----------------------------------------------- INTERGOVERNMENTAL REVENUES - FEDERAL 559.02 Community Development Block Grant 68000 42640 111340 1.6.1 TOTAL COMMUNITY DVLPMNT BLOCK GRANT FUND 68000 42640 111340 1.6.1 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 318006 719122 .47 ------- ------ ------- ---- TOTAL FEDERAL AID URBAN FUND 1541000 318006 719122 .47 TRANSPORTATION DVLPMNT ACT FUND (FUND # 2-11) --------------------------------------------- INTERGOVERNMENTAL REVENUES 555.10 Article 4.5 Funds (Paratransit) 12345 12345 1.00 ------ ------- ---- TOTAL TRANSPORTATION DEVELOPMENT ACT FUND 12345 12345 1.00 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 139000 32175 133443 .96 550.01 Interest ------ ------- ---- TOTAL STREET LIGHTING ASSMNT DISTR 83-1 139000 32175 133443 .96 LANDSCAPE ASSESSMENT DISTRICT 83-2 (FUND # 2-19) ------------------------------------------------ 534.03 Special Benefit Assessments 24100 1386 21849 .91 550.01 Interest TOTAL LANDSCAPE ASSMNT DISTR 83-2 24100 1386 21849 .91 SAN RAMON RD SPECIFIC PLAN ASSMT DISTR (FUND # 5-20) ---------------------------------------------------- 510.01 Property Tax-Current Year 534.03 Special Benefit Assessments 124293 20422 115577 .93 550.01 Interest 27000 TOTAL SAN RAMON RD SPECIFIC PLN ASSMT FUND 151293 20422 115577 .76 Revenue Report - Page 4 Percent of Estimated Current Received Estimate Revenue Month Year to Date Received ------ --------- ------------ ---------- DUBLIN INFORMATION, INC. FUND (FUND # 6-1) ----------------------------------------- Interest 444000 550.03 Rents & Concessions 1379851 1379851 1.00 TOTAL DUBLIN INFORMATION, INC. FUND 1823851 1379851 .76 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 PROJECT'S FUND (FUND # 3-)OCK) ------------------------------------ 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 132300 60798 .46 - ----- ------- -------- TOTAL INTERNAL SERVICE FUND 132300 60798 46 TOTAL REVENUE - ALL FUNDS 13463968 1152440 11060510 .82 ------- -------- ---- -------- ------- -------- BUDGET TRANSFERS IN To Operating Fund 832500 To Dublin Information, Inc. Fund 1379851 To Capital Projects Fund 5593340 68700 .01 To Internal Service Fund 13450 134.00 ------- ------- -------- -�-- TOTAL BUDGET TRANSFERS IN 7805691 82150 01 CITY OF DUBLIN STATEMENT OF REVENUE AND EkPENDITURES FOR THE PERIOD ENDING MAY 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 2079 16632 1368 .92 .04 Retirement 1170 86 997 173 .85 .05 Group Insurance 13560 603 7725 5835 .57 .06 Worker's Compensation 100 100 ------- ------- ------- ------- ----- Total Personal Services 32830 2768 25354 7476 .77 705 Services & Supplies .01 Office Supplies 250 104 146 .42 .02 Postage 100 2 92 8 .92 .05 Professional Services 4400 3500 900 .80 .08 Advertising 1500 373 1207 293 .80 .09 Printing 250 169 81 .68 .14 Books, Publs & Subscp 200 200 .15 Memberships & Dues 5600 5496 104 .98 .17 Trvl, Confs & Meetings 9400 289 6138 3262 .65 .18 Training 6500 6500 .19 Community Promotion 9960 6501 3459 .65 ------- ------- ------- ------- ----- Total Services & Supplies 38160 664 23207 14953 .61 757 Capital Outlay 700 43 657 .06 TOTAL CITY COUNCIL 71690 3432 48604 23086 .68 102 CITY MANAGER / CLERK 701 Personal Services .01 Salaries, Full Time 152500 17813 137871 14629 .90 .02 Salaries, Part Time 2000 1900 100 .95 .03 Salaries, Overtime 440 190 1031 -591 2.34 .04 Retirement 14050 1076 12277 1773 .87 .05 Group Insurance 15600 1080 10673 4927 .68 .06 Worker's Compensation 3530 2815 715 .80 .08 Medicare FICA 275 35 204 71 .74 ------- ------- ------- ------- ----- Total Personal Services 188395 20194 166771 21624 .89 705 Services & Supplies .01 Office Supplies 3500 101 2840 660 .81 .02 Postage 2900 4.66 2481 419 .86 .03 Reproduction Svcs 2100 1924 176 .92 .08 Advertising 1800 541 1259 .30 .09 Printing 14900 1500 12414 2486 .83 .12 Repairs & Maintenance 210 18 209 . 1 1.00 .14 Books, Publs & Subscps 1700 1706 -6 1.00 .15 Memberships & Dues 580 541 39 .93 .16 Auto Mileage & Allow. 5120 341 4263 857 .83 Expenditure Report - Page 2 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-=1 CITY MANAGER / CLERK - Services & Supplies (Continued) .17 Trvl, Confs & Meetings 5700 676 4533 1167 .80 .18 Training 2975 2103 872 .71 .25 Intrnl Srvc Fund Chrgs 5830 3960 1870 .68 ------- ------- ------- ------- ----- Total Services & Supplies 47315 3102 37515 9800 .79 722 Contract Services 4590 4590 757 Capital Outlay-Mchnry & Eqp 2700 638 2636 64 .98 TOTAL CITY MANAGER / CLERK 243000 23934 206922 36078 .85 103 LEGAL SERVICES 701 Personal Services .04 Retirement 4300 68 1407 2893 .33 .05 Group Insurance 2710 2710 Total Personal Services 7010 68 1407 5603 • .20 705 Services & Supplies .05 Professional Services 79500 10258 65217 14283 .82 ------- ------- ------- ------- ----- Total Services & Supplies 79500 10258 65217 14283 .82 TOTAL LEGAL SERVICES 86510 10326 66624 19886 .77 104 FINANCE 701 Personal Services .01 Salaries, Full Time 56240 8232 51271 4969 .91 .03 Salaries, Overtime 500 9 129 371 .26 .04 Retirement 4520 340 3140 1380 .69 .05 Group Insurance 8245 315 3309 4936 .40 .06 Worker's Compensation 1450 1450 .08 Medicare FICA 600 79 434 166 .72 ------- ------- ------- ------- ----- Total Personal Services 71555 8975 58283 13272 .81 705 Services & Supplies .01 Office Supplies 1250 60 1160 90 .93 .05 Professional Services 33300 1803 28328 4972 .85 .09 Printing & Binding 1300 344 1526 -226 1.17 .12 Repairs & Maintenance 220 220 .00 .14 Books Publs & Subscrps 770 135 996 -226 1.29 .15 Memberships & Dues 400 75 325 .19 .16 Auto Mileage & Allwnc 2300 198 1542 758 .67 .17 Trvl, Confs & Meetings 2100 39 2061 .02 .18 Training 400 17 383 .04 .20 Miscellaneous ' 260 206 54 .79 .25 Intrnl Srvc Fnd Chrgs 600 450 150 .75 ------ --- -- ----- Total Services & Supplies 42900 2540 34339 8561 .80 722 Contract Services 1400 1399 1 1.00 757 Capital Outlay-Mchnry & Eqp 2000 93 1306 694 .65 TOTAL FINANCE 117855 11608 95327 22528 .81 Expenditure Report - Page 3 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-1"n ) 105 BUILDING MANAGEMENT 705 Services & Supplies .01 Office Supplies 250 8 234 16 .94 .04 Operating Supplies 300 16 284 .05 .07 Communication 25500 2416 23107 2393 .91 .13 Rentals 1469651 • 7465 1462321 7330 1.00 .21 Utilities 1200 58 357 843 .30 ------- ------- ------- ------- ----- Total Services & Supplies 1496901 , 9947 1486035 10866 .99 722 Contract Services 2200 1814 386 .82 Capital Outlay 755 Improvements Othr Than Bldgs 699 699 0 1.00 757 Machinery & Equipment 3301 832 3094 207 .94 ------- ------- ------- ------- ----- Total Capital Outlay 4000 832 3793 207 .95 TOTAL BUILDING MANAGEMENT 1503101 10779 1491642 11459 .99 106 INSURANCE 705 Services & Supplies .05 Professional Services 200 192 8 .96 .10 Insurance Premiums 93200 55631 37569 .60 .11 Insurance Claims E.%,pns 49800 750 49050 .02 ------ ------ ------ ------ ----- Total Services & Supplies 143200 56573 86627 .40 TOTAL INSURANCE 143200 56573 86627 .40 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 .00 705 .20 Miscellaneous E%-pense 100000 -100000 1000.00 TOTAL NON-DEPARTMENTAL 24619 100000 -75381 4.06 TO'T'AL GENERAL GOVERNMENT 2194275 60079 2068312 125963 .94 PUBLIC SAFETY 201 POLICE SERVICES 701 Personal Services .02 Salaries, Part Time 12350 1690 10001 2349 .81 .06 Worker's Compensation 400 400 ---- ------ ------ ----- Total Personal Services 12750 1690 10001 2749 .78 Expenditure Report - Page 4 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-17M 201 POLICE SERVICES (CONTINUED) 705 Services & Supplies .01 Office Supplies 2500 8 1845 655 .74 .02 Postage 925 16 771 154 .83 .03 Reproduction Supplies 1705 1463 242 .86 .04 Operating Supplies 11350 276 2407 8943 .21 .09 Printing & Binding 2000 44 748 1252 .37 .12 Repairs & Maintenance 2950 45 1173 1777 .40 .13 Rentals 150 21 104 46 .69 .14 Books, Publs & Subscrps 100 11 81 19 .81 .15 Memberships & Dues 120 80 40 .67 .16 Auto Mileage & Allownc 600 52 279 321 .47 .17 Trvl, Confs & Meetings 1700 44 1469 231 .86 .18 Training Expense 400 205 304 96 .76 .19 Community Promotion -5 0 0 .25 Intrnl Svc Chg-Ofc Eqp 4200 3150 1050 .75 .27 Intrnl Svc Chg-Vehicles 105500 45948 59552 .44 ------- ------- ------- ------- ----- Total Services & Supplies 134200 717 59822 74378 .45 710 Contract Services .01 Personnel Costs 1132940 85522 838208 294732 .74 .02 Vehicle Costs 39000 1864 31939 7061 .82 .03 Indirect Costs 73240 12205 67129 6111 .92 .04 Dispatch 124200 32644 87637 36563 .71 .05 Admin. - Financial Svcs 20605 5151 15453 5152 .75 .06 Services & Supplies 40980 3307 16093 24887 .39 ------- ------- ------- ------- ----- Total Contract Services 1430965 140693 1056459 374506 .74 722 Contract Services 3000 90 90 2910 .03 757 Capital Outlay-Mchnry & Eqp 4000 3051 949 .76 TOTAL POLICE SERVICES 1584915 143190 1129423 455492 .71 202 CROSSING GUARDS 705 .04 Srvc & Supp-Optg Supp 712 .16 Contract Services 21800. 7407 14393 .34 ------- ------- ------- ------- ----- TOTAL CROSSING GUARDS 21800 7407 14393 .34 203 ANIMAL CONTROL 716 Contract Services .01 Shelter Services 10700 8621 2079 .81 .02 Field Service 40000 20549 19451 .51 ------- ------- ------- ------- ----- Total Contract Services 50700 29170 21530 .58 TOTAL ANIMAL CONTROL 50700 29170 21530 .58 204 TRAFFIC SIGNALS & SAFETY LIGHTING 705 .21 Srvc & Supp-Utilities 12600 365 9691 2909 .77 712 .01 Contract Services 25600 4668 20932 .18 757 Cptl Outlay-Mchnry & Eq 4000 4000 ------ ------- ------- ------- ----- TOTAL TRAFFIC SGNLS-SFTY LIGHTING 42200 365 14359 27841 .34 Expenditure Report - Page 5 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YET 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 15 165 535 .24 ------- ------- ------- ------- ----- Total Services & Supplies 1600 15 165 1435 .10 722 Contract Services 15000 2160 7165 7835 .48 757 Capital Outlay-Mchnry & Eqp 7000 7000 TOTAL DISASTER PREPAREDNESS 23600 2175 7330 16270 .31 TOTAL PUBLIC SAFETY 1723215 145730 1187689 535576 .69 TRANSPORTATION 301 PUBLIC WORKS ADMINISTRATION 701 Personal Services .01 Salaries, Full Time 21730 2534 19851 1879 .91 .03 Salaries, Overtime 560 150 457 103 .82 .04 Retirement 1400 105 1193 207 .85 .05 Group Insurance 2920 117 1622 1298 .56 .06 Worker's Compensation 130 130 ------- ------- ------ ------- ----- Total Personal Services 26740 2906 23123 3617 .86 705 Services & Supplies .01 Office Supplies 900 48 840 60 .93 .02 Postage 505 8 390 115 .77 .03 Reporduction Services 325 279 46 .86 .12 Repairs & Maintenance .14 Books 20 18 2 .90 .16 Auto Alli.mc & Mileage 50 50 .18 Training 530 31 499 .06 .25 Intrnl Svc Fund Chrgs 2830 1710 1120 .60 ------- ------- ------- ------- ----- Total Services & Supplies 5160 56 3268 1892 .63 712 .17 Contract Services 74300 5491 77436 -3136 1 .04 757 Capital Outlay-Mchnry & Eqp 2650 166 2484 .06 TOTAL PUBLIC WORKS ADMINISTRATION 108850 8453 103993 4857 .96 302 STREET MAINTENANCE 705 .04 Srvc & Supp-Optg Supp 2500 405 2095 .16 712 .02 Cntr Svc-St. Repair 173500 4894 33443 140057 .19 712 .06 Cntr Svc-Sign Rpr/Instl 2000 229 1771 .11 755 Imprvmt Othr Thn Bldgs 10410 10410 ------ ------ ------- ------- ----- TOTAL STREET MAINTENANCE 188410 4894 34077 154333 . 18 Expenditure Report - Page 6 CURRENT 1L,-,R TO PERCENT OF BUDGET• MONTH DATE BALANCE BUDGET-YTD 304 STREET TREE MAINTENANCE 705 .21 Svc & Supp-Utilities 712 .09 Cntr Svc-Public Works 74400 6091 29803 44597 .40 TOTAL STREET TREE MAINTENANCE 74400 6091 29803 44597 .40 305 STREET LANDSCAPE MAINTENANCE 705 .21 Svc & Supp-Utilities 11100 4952 10642 458 .96 712 .15 Cntr Svc-Public Works 110350 7725 85095 25255 .77 718 .02 Cntr Svc-Litter Pickup 7000 79 6390 610 .91 757 Gptl Outlay-Mchnry/Eqp 4000 4000 -- ------- ------- ------- ------- ----- TOTAL STREET LANDSCAPE MAINTENANC 132450 12756 102127 30323 .77 i 306 PARATRANSIT SERVICE 714 Cntrct Svc-SRV Community Ctr 15694 11090 4604 .71 TOTAL PARATRANSIT SERVICE 15694 11090 4604 .71 TOTAL TRANSPORTATION 519804 32194 281090 238714 .54 v HEALTH & WELFARE SERVICES 501 VECTOR CONTROL SERVICES 722 Contract Services 6000 2120 3880 .35 TOTAL VECTOR CONTROL SERVICES 6000 2120 3880 .35 CULTURE & LEISURE SERVICES 701 LIBRARY SERVICE 722 Cntrct Svcs - County Library 91984 60692 31292 .66 TOTAL LIBRARY SERVICE 91984 60692 31292 .66 702 RECREATION 701 Personal Services .01 Salaries, Full Time 100000 12417 87580 12420 .88 .02 Salaries, Part Time 70760 5904 44518 26242 .63 .03 Salaries, Overtime 500 58 293 207 .59 .04 Retirement 7400 510 5276 2124 .71 .05 Group Insurance 19530 734 8379 11151 .43 .06 Worker's Compensation 6460 2320 4140 .36 .07 Unemployment Ins Claims .08 Medicare FICA 1245 95 564 681 .45 ------- ------- ------- ------- ----- Total Personal Services 205895 19718 148930 56965 .72 • 705 Services & Supplies .01 Office Supplies 2400 160 1928 472 .80 .02 Postage 4820 690 4508 312 .94 .03 Reproduction Services 2300 1585 715 .69 .04 Program Materials 16880 2593 7684 9196 .46 .07 Communications 4600 155 1581 3019 .34 .08 Advertising 665 115 528 137 .79 .09 Printing 14250 1306 10764 3186 .76 .12 Repairs & Maintenance 1700 88 1612 .05 .13 Rentals 7730 332 4518 3212 .58 .14 Books, Publs & Subscrip 200 172 28 .86 Expenditure Report - Page 7 CURRENT SEAR TO PERCENT OF BUDGET MONTH " DATE BALANCE BUDGET YTD 702 RECREATION - Services & Supplies (Continued) .15 Memberships & Dues 360 360 0 1.00 .16 Auto Mileage & Allow. 3790 247 2819 971 .74 .17 Trvl-Confrncs-Meetings 3870 -137 1427 2443 .37 .18 Training Expense 1000 0 1000 .00 .19 Community Promotion -7447 0 0 .00 .21 Utilities 20700 859 8031 12669 . .39 .25 Intrnl Svc Fund Chrgs 2160 1620 540 .75 --- ------- ------- ------- ----- Total Services & Supplies 87425 -1127 47613 39552 .54 725 Contract Services :01 Recreation Instruction 34900 3217 22460 12440 .64 .02 Shannon Services. 19560 945 12639 6921 .65 .03 Senior Center Services 9300 9300 .04 Special Events 3750 3750 3750 0 100.00 ------- ------- ------- ------- ----- Total Contract Services 67510 7912 38849 28661 .58 757 Cptl Outlay-Mchnry & Eqp 8205 1086 2641 5564 .32 TOTAL RECREATION DEPT. 369035 27589 238033 130742 .65 703 PARK MAINTENANCE 705 .21 Srvc & Supp-Utilities 5000 5000 722 Contract Services 21300 21300 ------- ------- ------- ------- ----- TOTAL PARK MAINTE.T1kNCE 26300 26300 TOTAL CULTURE & LEISURE SERVICES 487319 27589 298725 188334 .61 COMMUNITY DEVELOPMLIT 901 PLANNING 701 Personal Services .01 Salaries, Full Time 172900 16782 133643 39257 .77 .02 Salaries, Part Time 3880 3880 .03 Salaries, Overtime 2300 451 2073 227 .90 .04 Retirement 11260 407 7739 3521 .69 .05 Group Insurance 19890 921 11330 8560 .57 .06 Worker's Compensation 4760 2320 2440 .49 .08 Medicare FICA 100 100 ------- ------- ------- ------- ----- Total Personal Services 215090 18561 157105 57985 .73 705 Services & Supplies .01 Office Supplies 4150 236 3163 987 .76 .02 Postage 4,100 67 4181 219 .95 .03 Reproduction Supplies 3500 1841 1659 .53 .05 Professional Services 149980 7722 88302 61678 .59 .08 Advertising 1850 117 1789 61 .97 .09 Printing & Binding 6400 38 1568 4832 .25 .12 Repairs & Maintenance 1000 442 558 .44 .14 Books, Publs & Subscrps 1200 50 963 237 .80 .15 Memberships & Dues 340 412 -72 1.21 .16 Auto Mileage & Allow. 2530 175 2073 457 .82 .17 Trvl, 'Confs & Meetings 5700 1244 5058 642 .89 Expenditure Report - Page 8 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE .. 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 1562 .66 ------- ------- ------- ------- ----- Total Services & Supplies 190900 9649 115472 75428 .60 .757 Capital Outlay-Mchnry & Eqp 3790 405 514 3276 .14 TOTAL PLANNING 409780 28615 273091 136689 .67 902 BUILDING & SAFETY 701 Personal Services .01 Salaries, Full Time 26000 2908 22708 3292 .87 .03 Salaries, Overtime 700 491 1143 -443 1.63 .04 Retirement 1620 407 1650 -30 1.02 .05 Group Insurance 3800 139 2070 1730 .54 .06 Worker's Compensation 180 180 ------- ------- ------- ----^ Total Personal Services 32300 3945 27571 4729 .85 705 Services & Supplies .01 Office Supplies 1000 37 932 68 .93 .02 Postage 400 10 346 54 .87 .03 Reproduction Supplies 300 63 237 .21 .09 Printing & Binding 1600 258 1534 66 .96 .12 Repairs .14 Books, Publs & Subscps 350 282 318 32 .91 .15 Memberships & Dues 350 115 350 0 1.00 .16 Auto Mileage & Allow. 50 50 .18 Training Expense 850 403 447 .47 .25 Intrnl Svc Fund Chrgs 1850 972 878 53 ------- ------- ------- Total Services & Supplies 6750 702 4918 1832 722 Contract Services 247200 20843 164127 83073 .66 757 Gptl Outlay-Mchnry & Eqp 1450 343 1352 98 .93 TOTAL BUILDING & SAFETY 287700 2583-3 197968 89732 .69 903 ENGINEERING 705 Services & Supplies .01 Office Supplies 600 431 169 .72 .02 Postage 700 8 442 258 .63 .03 Reproduction 103 -103 .09 Printing & Binding 1900 25 7 1918 -18 1.01 Total Services & Supplies 3200 265 . 2894 306 .90 722 Contract Services 400000 29426 421396 -21396 1.05 757 Cptl Outlay-Mchnry & Eqp 2000 1994 6 1.00 TOTAL ENGINEERING 405200 29691 426284 -21084 1.05 TOTAL COMMUNITY DEVELOPr1ENT 1102680 84139 897343 205337 .81 TOTAL GENERAL FUND 6033293 349731 4735279 1297754 .78 Expenditure Report - Page 9 CURRENT YEAR TO PERCENT OF BUDGET MONTH DATE. BALANCE BUDGET-YTD TRAFFIC SAFETY FUND (FUND # 2-5) 204 TRAFFIC SIGNALS & STREET LIGHTING 705 .21 Srvc & Supp-Utilities 21400 2078 14380 7020 .67 712 .01 Cntrct Svc-Trfc Signls 42600 869 10381 32219 .24 TOTAL TRAFFIC SIGNALS & STREET LG 64000 2947 . 24761 39239 .39 TOTAL TRAFFIC SAFETY FUND 64000 2947 24761 39239 .39 STATE GAS TAY FUND (FUND # 2-6) TRANSPORTATION 302 STREET MAINTENANCE 712 Contract Services .02 Street Repair 110000 110000 .03 Drainage & Maintenance 22500 17540 4960 .78 .04 Storm Patrol & Clean-up 13150 817 12333 .06 .05 Curbs Gutters Sidewalks 24000 27 9586 14414 .40 .06 Sign Rpr & Installation 23500 2980 20381 3119 .87 .07 Striping & Marking 40000 2744 24113 15887 .60 .08 Guardrail Repair 2000 2000 .10 Weed Control 3000 600 2673 327 .89 .13 Bike Path Maintenance 7000 73 2479 4521 .35 ------- ------- ------- ------- ----- Total Contract Services 245150 6424 77589 167561 .32 755 Imprvmts Othr Thn Bldgs 35000 1183 17548 17452 .50 TOTAL STREET MAINTENANCE 280150 7607 95137 185013 .34 303 STREET SWEEPING 718 Contract Services .01 Street Sweeping 57600 4822 41914 15686 .73 ------- ------- ------- ------- ----- Total Contract Services 57600 4822 41914 15686 .73 TOTAL STREET SWEEPING 57600 4822 41914 15686 .73 TOTAL TRANSPORTATION 337750 12429 137051 200699 .41 COiMMUNITY DEVELOPMENT 903 ENGINEERING-TRAFFIC 722 Contract Services 4000 4000 TOTAL ENGINEERING 4000 4000 TOTAL STATE GAS TAX FUND 341750 12429 137051 204699 .40 TRANSPORTATION DEVELOPMENT ACT FUND (FUND # 2-11) 306 PARATRANSIT SERVICE 714 Cntrct Svc-SRV Community Ctr 12345 6172 6173 .50 TOTAL TRANSPORTATION DVLPMNT ACT FUND 12345 6172 6173 .50 Expenditure Report. - Page 10 CURRENT R TO PERCENT OF BUDGET MONTH DATE BALANCE BUDGET-YI'D ST. LIGHTING ASSESSMENT DISTRICT 83-1 FUND (FUND # 2-18) 204 SAFETY LIGHTING 705 .21 Srvc & Supp-Utilities 132500 10647 91211 41289 .69 903 ENGINEERING SERVICES 722 Contract Services 6500 7616 -1116 1.17 TOTAL ST. LIGHTING ASSMNT DISTR. FUND 139000 10647 98827 40173 .71 LANDSCAPE DISTRICT ASSESSMENT FUND 83-2 (FUND # 2-19) 305 STREET LANDSCAPE MAINTENANCE 705 .21 Srvc & Supp-Utilities 11600 456 5162 6438 .45 712 .15 Cntrct Svc-Public Works 26500 2353 11552 14948 .44 ------- ------- ------- ------- ----- TOTAL STREET LANDSCAPE MAINTENANC 38100 2809 16714 21386 .44 703 PARK MAINTENANCE 722 Contract Services 903 ENGINEERING SERVICES 722 Contract Services 2000 1320 680 .66 TOTAL LANDSCAPE DISTR. ASSMNT R)NID 83-2 40100 2809 18034 22066 .45 INTERNAL SERVICE FUND (FUND w 10-30) 705 Services & Supplies .01 Office Supplies 1000 1000 .04 Operating Supplies 32031 1615 19113 12918 .60 . 10 Insurance Premium 10800 10800 .12 Repairs & Maintenance 22015 354 19152 2863 .87 ------- ------- ------- ------- ------- Total Services & Supplies 65846 1969 38265 27581 .58 757 Machinery.. Equipment 15935 4344 11591 .27 764 Depreciation & Replacement 63969 63969 TOTAL INTERNAL SERVICE FUND 145750 1969 42609 103141 .29 TOTAL OPERATING FUND =LNDITURES 6776238 380532 5062733 1713505 .75 SAN RAMON RD SPECIFIC PLAN ASSMT DISTR FUND (FEND.; 5-20) - DEBT SERVICE 903 722 Engineering Prfsnl Srvcs 145 145 -145 145.00 730 Debt Service .01 Principal Payments 87869 87869 0 1.00 .02 Interest Payments 70921 70918 3 1.00 --^---- ------- ------- TOTAL SN RMN RD ASSrTT DSTR - DEBT SRVC 158790 145 158932 -142 1.00 DUBLIN INFORMATION, INC. FUND (FUND # 6-1) 705 .05 Professional Services 500000 43306 287308 212692 .57 705 .09 Printing 41 -41 41.00 705 .24 Filing Fees 667 670 -670 670.00 705 .26 Property Tax 41467 1256 41467 0 1.00 722 Contract Services 5745 5745 0 • 1.00 Subtotal - Operating F-%penditures 547212 45229 335231 211981 .61 Expenditure Report - Page 11 CURRENT 'YEAR TO PERCENT OF BUDGET MONTH DATE. BALANCE BUDGET-YTD DUBLIN INFORMATION, INC. FUND (CONTINUED) 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 751 Land 841675 5000 836675 .01 753 Improvements 200000 200000 755 .01 Sierra Ct Sthrn Extnsn 546000 665 524275 21725 .96 Subtotal - Capital Expenditures 1587675 665 529275 1058400 .33 TOTAL DUBLIN INFORnATION, INC. FUNS 3514738 45894 2244357 1270381 .64 CAPITAL IMPROVEMENTS �ITURES CAPTIAL PROJECTS FUNDS (FUND # 3-XXX'1) General Improvements 0024 Civic Center 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 733 1211 11389 .10 ------- ------- ------- ------- ----- Total General Improvements 140950 733 131664 9286 .93 Community Improvements 0020 Sewage Facility Expansion 800000 800000 0025 Sidewlk Sfty/Bus Stop Pads 57200 338 12910 44290 .23 0032 Downtown Improvement Plan 44550 274 48025 -3475 1.08 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 257 1233 8767 .12 ------- ------- ------- ------- ----- Total Community Improvements 936981 869 68824 868157 .07 Park Improvments 0035 Kolb Park 817300 93118 103048 714252 .13 0060 Park Development Plan 17000 15296 1704 .90 0061 Shannon Park Renovation 456130 456130 0063 Dolan Park 407020 2943 8194 398826 .02 0065 Amador Lakes Mini Park 72595 348 3022 69573 .04 0069 Senior Citizens Center 102000 115 101885 0070 Doherty Hills Park 58000 15645 42355 .27 0075 East Doherty Hills Park 17006 -17006 1701.00 ------- ------- ------- ------- ----- Total Park Improvements 1930045 96409 162326 1767719 .08 Street Improvements 0029 Annual Street Overlay 111769 2915 20227 91542 .18 0036 San Ramon Rd Phase II 1892100 384940 796028 1096072 .42 0037 Sn Rmn Rd-III/Hillsd Lndscp 32000 2818 40255 -8255 1.26 0038 Trfc Sgl-Alcosta/San Rmn Rd 43507 43599 -92 1.00 0039 Trfc Sgl-Dbin Blvd/Sierra 218000 15039 201232 16768 .92 0042 Traffic Signal Interconnect 150000 15898 54768 95232 .37 bcpenditure Report - Page 12 CURRENT YEAR TO PERCEN7 OF BUDGET MONTH DATE BALANCE BUDGET-YTD CAPITAL PROJECTS - STREET IMPROVIIMENTS (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 249300 254 131123 118177 .53 0056 Rehb/Lndscp AVB-VP to Dghrty 1029500 5709 768175 261325 .75 0059 San Ramon Rd Phase IV 47000 19 44055 2945 .94 0071 Dbin Blvd NW Frntg at Clark 161000 11615 . 149385 .07 0072 Trfc Sgnls & St Light Addtns 29000 72 28884 116 1.00 Total Street Improvements 4013276 427664 2183141 1830135 .54 TOTAL CAPITAL PROJECTS FUND 7021252 525675 2545955 4475297 .36 TOTAL EXPENDITURES - ALL FUNDS 17471018 952246 10011977 7459041 .57 BUDGET TRANSFERS OUT From General Fund 5095151 13450 5081701 From Community Developent Block Grant 141040 68700 75340 .48 From Federal Aid Urban Fund 1541000 1541000 From Park Dedication Fund 763650 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 7805691 82150 7723541 .01